AfAdEvFinance tools Finance workspace

Bank reconciliation

Compare your bank statement with your cash ledger, match transactions, and review the remaining differences.

Private to this browser. Imported transactions and matches are saved in this browser only. They are not uploaded or backed up. Do not use a shared device; export your report if you need to keep a copy.
1
Import both CSVsBank statement and cash ledger
2
Review matchesAuto-match, then adjust as needed
3
Check the differenceResolve unmatched lines and balances
LKR
LKR
Balance difference—Enter both balances
Transactions matched0No transactions yet
Unmatched bank entries0Import a bank CSV
Unmatched book entries0Import a ledger CSV

Import transactions

CSV files stay on this device. Dates should use YYYY-MM-DD format.

Bank statement

Upload the CSV downloaded from your bank. Positive amounts are deposits; negative amounts are withdrawals.

Cash ledger

Upload your cash account ledger CSV. Debit increases cash; credit decreases cash.

Automatic matching looks for the same amount within three calendar days. Manual matches require the amounts to agree.

Bank dateBank transactionAmountMatch to ledger transactionStatus
Import a bank CSV to get started, or load the sample data.

Cash ledger entries

Matched ledger entries are linked to a bank line and cannot be reused.

Ledger dateDescriptionAmountMatching bank entryStatus
Import a cash ledger CSV to review entries.