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 — Period id used to match GL cash account to bank statement and identify all reconciling items
- bank_statement_balance — Closing balance per bank statement (AED)
- reconciliation — Draft reconciliation note awaiting approver sign-off.
- approver — Approver used to update status to approved once all differences are explained
How you ask
- Bank reconciliation
- Cash balance discrepancy
- Bank statement doesn
Outputs
- approved-reconciliation (markdown)
- bank-reconciliation (markdown)
Levelbeginner
Inputdata
Outputspreadsheet
Setup[none]
Roles[Finance Manager]