Each reconciliation is tied to an account and a half-month period (1stβ15th, or 16thβend). Run two per month per account. Save it and matched items are remembered β reload later to continue, re-upload updated data, or roll into the next period.
1 Load your two files
Accepts .csv, .xlsx, .xls. GL = your cash/bank ledger from the books. Bank = the statement export.
Β· βΆ Load example (sample GL + bank that ties out)
π GL / Book ledger
Click or drop file
π¦ Bank statement
Click or drop file
2 Map columns & enter balances
The tool auto-detects columns β adjust if needed. Amounts can be one signed Amount column, or separate Debit/Credit columns.
π GL / Book ledger
π¦ Bank statement
3 Review matches & tick to match manually
Auto-matched pairs are on the left. For the rest, tick one or more rows on each side (totals must agree) then Match selected.
GL rows 0Bank rows 0Matched 0Unmatched GL 0Unmatched Bank 0
π Unmatched β GL / Book0.00
π Unmatched β Bank0.00
β Matched pairs0 groups
4 Reconciliation summary
Recalculates live as you match. Unmatched GL items adjust the bank balance (timing); unmatched bank items are things to book in the GL. Β· Amounts in SAR.
π¦ Bank side
Balance per bank statement (closing)
0.00
Add: Deposits in transit (GL receipts not on bank)
0.00
Less: Outstanding payments (GL payments not on bank)
0.00
Adjusted bank balance
0.00
π Book side
Balance per books (GL)
0.00
Add: Credits not booked (interest, receipts on bank only)
0.00
Less: Charges not booked (fees, debits on bank only)