bank-reconciliation
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.
Inputs
- 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
How you ask
- bank reconciliation
- cash balance discrepancy
- bank statement doesn
- unpresented cheques
- close the books.
Outputs
- approved-reconciliation (markdown)
- bank-reconciliation (markdown)
Levelbeginner
Inputdata
Outputspreadsheet
Setup[none]
Roles[Finance Manager]