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.
Nodig
- 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
Zo vraag je het
- Bank reconciliation
- Cash balance discrepancy
- Bank statement doesn
Oplevert
- approved-reconciliation (markdown)
- bank-reconciliation (markdown)
Niveaubeginner
Invoerdata
Uitvoerspreadsheet
Vereist[none]
Rollen[Finance Manager]