finance

bank-reconciliation

Reconciles GL cash account balances to bank statements by matching deposits, unpresented cheques, and unrecorded bank charges.

Reconcile GL cash balances to bank statements. Identifies timing differences (deposits in transit, unpresented cheques) and unrecorded items (bank charges, interest). Required as part of period-end close before the trial balance is signed off.

Difficulty: beginner
Input: data
Output: spreadsheet
Needs: none
Used by: Finance Manager

What it needs

bank_account — Bank account master record with currency, GL code, and IBAN.
period_id
bank_statement_balance — Closing balance per bank statement (AED)
reconciliation — Draft reconciliation note awaiting approver sign-off.
approver

What you get

approved-reconciliation (markdown)
bank-reconciliation (markdown)

Ask it like this

bank reconciliation
cash balance discrepancy
bank statement doesn
unpresented cheques
close the books.