Reconcile a bank account

Import a CSV bank statement, match each line to your records, and clear the differences.

Reconciling means checking that every line on your bank statement matches a record in InvoBill.

Only CSV files work. The screen accepts .csv. Earlier help pages also listed OFX and QIF. The app does not read those. If your bank gives you PDF, OFX or Excel, download the CSV option or convert the file first.

Prepare the CSV

The first row must have column names. InvoBill understands these names:

  • Date: Date, Transaction Date or Txn Date
  • Description: Description, Narration or Particulars
  • Reference: Reference, Ref No or Chq/Ref
  • Money out: Debit or Withdrawal
  • Money in: Credit or Deposit
  • Balance: Balance or Running Balance

Reconcile

  1. Go to Finance > Bank Reconciliation. The page is titled Banking & Cash.
  2. If you have no account yet, tap Add Bank Account. Fill Account Name (required), Bank Name, Account Number, IFSC Code and Opening Balance.
  3. Under Select Bank Account, choose the account.
  4. With no lines yet the page says No transactions. Import a bank statement to begin. Choose your CSV file. If the file cannot be read you see Could not parse transactions. Check CSV format.
  5. The lines appear with a Status and a Confidence score. New lines start as unmatched.
  6. Run the auto match, then review each suggestion. Do not accept low-confidence matches blindly.
  7. If you clear a line by mistake, use the revert option. The page says Reverted last clear when it works.
  8. For anything left unmatched, check that the entry is not already recorded before you create a new one.
Check the totals: Total Transactions on the page against the number of lines in your statement.