MMHS Finance
Money

Bank reconciliation

Import a bank statement, match it to your books and explain every difference.

Importing an October statement: the supplier payment, customer cheque and rent match by themselves; the bank charge is posted and matched in one step.

Import the statement

Download the statement from internet banking as CSV (or save the Excel file as CSV) and use Bank reconciliation → Import statement. Columns are recognised by their headings: Date, Description/Narration/Particulars, Withdrawal/Debit and Deposit/Credit (or a single Amount), Balance and Cheque/Reference. Dates like 05/11/2026 or 05-Nov-26 and Bangla digits are read correctly. Lines already imported for the account are skipped.

Matching

Lines are matched to entries with the same amount within a week, using cheque numbers and shared words to decide. Only clear matches are made automatically. For the rest:

  • Find match lists entries of the same amount to choose from.
  • Post entry records what is missing from the books — bank charges, interest, transfers, tax — and matches it at once. Customer receipts and supplier payments are recorded under Banking first, then matched.
  • Explain marks a line that does not belong in the books (for example a bank error that will be reversed).
  • Suggest with AI proposes what each unmatched line is.

The reconciliation

The panel shows the bank's balance plus deposits not yet credited less payments not yet presented, against the book balance plus bank items not yet recorded. When both sides agree the statement is reconciled.