RPT-13 Bank Reconciliation
Certified daily report for Finance & Audit: bank statement imports vs ERP cash with matched / unmatched / exception totals per account. Definition owner: Fatima Rashid (Finance Manager).
RPT-13
FIN-04
FIN-10
§9.2
Report certification & ownershipCertified
- Report owner
- Fatima Rashid — Finance Manager (metric owner of record)
- Prepared by
- DCDaniel Chen — Accountant (maker)
- Authoritative dataset
fin.bank_statement_lines+fin.gl_cash_postings· semantic modelfin_recon_v4- Refresh cadence
- Daily 06:00 GST · last refresh 17 Jul 2026 06:02 (next 18 Jul 2026 06:00)
- Certification state
- Certified as of period Jun 2026 close · today's rows provisional until close approval
- Definition version
RPT-13 v3.2· approved 04 May 2026 by Fatima Rashid- Governing policy versions
- Fiscal policy
FIN-POL-2026.3· Recon toleranceTOL-CASH-01 v2(AED 5.00 per line) · Export policyEXP-FIN-02 - Currency / time zone
- AED (base) · Asia/Dubai (GST) · company Al Manara Properties LLC
§9.2 Report definition of done8 / 8 met
| Criterion | Evidence | State |
|---|---|---|
| Named owner & business definition | Fatima Rashid · definition RPT-13 v3.2 | Met |
| Authoritative dataset & lineage | Lineage panel below · fin_recon_v4 | Met |
| Filters, dimensions, currency/TZ | Account, branch, status, period · AED / GST | Met |
| Refresh & certification state | Daily 06:00 · Certified (Jun close) | Met |
| Permission-aware drill-down | Statement lines visible to Finance/Audit only | Met |
| Controlled export + watermark | Export (audited) → watermarked XLSX/PDF | Met |
| Reconciliation totals & tolerances | tfoot control row · TOL-CASH-01 v2 | Met |
| Accessible chart/table alternative | Bars + data table (this page) · EN/AR labels approved | Met |
Accounts reconciled today
5 / 6
ENBD Escrow pending sign-off
Matched value (16 Jul)
AED 18.42M
▲ 96.9% auto-match rate
Unmatched items
14
AED 512,300.00 · oldest 4 days
Exceptions open
3
▼ 1 aged > 3d — escalated to Fatima Rashid
Duplicate imports blocked
1
MT940 re-upload 06:01 · idempotent (FIN-04)
Matched vs unmatched value by account — 16 Jul 2026AED millions
| Account | Matched (AED) | Unmatched (AED) | Exceptions |
|---|---|---|---|
| ENBD Operating | 9,840,140.00 | 86,300.00 | 1 |
| ENBD Escrow | 5,096,500.00 | 380,000.00 | 1 |
| ADCB Operating | 2,312,760.00 | 34,500.00 | 0 |
| Mashreq PDC clearing | 941,000.00 | 11,500.00 | 1 |
| ENBD Payroll / WPS | 218,400.00 | 0.00 | 0 |
| Petty cash — Dubai HQ | 12,150.00 | 0.00 | 0 |
| Total | 18,420,950.00 | 512,300.00 | 3 |
Open exceptions — investigation queueInvestigate
| Exception | Account / line | Amount (AED) | Age | Status |
|---|---|---|---|---|
Unknown remitter credit EXC-2026-0141 · ref "PR-A-1103 DEPOSIT" | ENBD Escrow · line 2214 | 380,000.00 | 4d | Escalated — client-money hold |
Partial match — split required EXC-2026-0144 · INV-2026-01187 (Amina Noor) | ENBD Operating · line 2231 | 86,300.00 | 1d | With Daniel Chen |
Returned cheque awaiting journal EXC-2026-0146 · PDC-2026-0562 → RPT-14 | Mashreq PDC · line 118 | 11,500.00 | 6h | Return recorded — AR reopened |
Daily reconciliation by account — statement date 16 Jul 2026
Generated 17 Jul 2026 06:02
| Bank account | Import batch | Bank closing (AED) | ERP cash (AED) | Matched | Unmatched | Exceptions | Difference (AED) | Status |
|---|---|---|---|---|---|---|---|---|
ENBD Operating — Dubai HQ AE07 0331 ●●●● ●●●● ●●●● 456 |
BST-2026-0712 CAMT.053 · 06:00 · 214 lines |
9,926,440.00 | 9,840,140.00 | 208 | 5 | 1 | 86,300.00 | Open items |
ENBD Escrow — Prototype Residences AE43 0331 ●●●● ●●●● ●●●● 889 · client money |
BST-2026-0713 CAMT.053 · 06:00 · 41 lines |
5,476,500.00 | 5,096,500.00 | 39 | 1 | 1 | 380,000.00 | Exception — unknown remitter |
ADCB Operating — Abu Dhabi Branch AE19 0030 ●●●● ●●●● ●●●● 021 |
BST-2026-0714 API pull · 06:00 · 96 lines |
2,347,260.00 | 2,312,760.00 | 93 | 3 | 0 | 34,500.00 | Open items |
Mashreq PDC clearing AE55 0330 ●●●● ●●●● ●●●● 112 |
BST-2026-0715 MT940 · 06:01 · 38 lines |
952,500.00 | 941,000.00 | 36 | 1 | 1 | 11,500.00 | Cheque return in progress |
ENBD Payroll / WPS AE81 0331 ●●●● ●●●● ●●●● 204 |
BST-2026-0716 CAMT.053 · 06:00 · 12 lines |
218,400.00 | 218,400.00 | 12 | 0 | 0 | 0.00 | Reconciled — approved |
Petty cash — Dubai HQ Cash count · custodian Elena Petrova |
BST-2026-0717 Manual count · 08:30 · 6 lines |
12,150.00 | 12,150.00 | 6 | 0 | 0 | 0.00 | Reconciled — approved |
ENBD Operating — Dubai HQ (15 Jul) Prior day carried forward |
BST-2026-0708 CAMT.053 · 16 Jul 06:00 · 198 lines |
9,614,220.00 | 9,614,220.00 | 198 | 0 | 0 | 0.00 | Closed — Fatima Rashid 16 Jul 10:12 |
Mashreq PDC clearing (re-upload) Same MT940 uploaded twice |
BST-2026-0715-DUP MT940 · 06:01 · hash match BST-2026-0715 |
— | — | 0 | 0 | 0 | 0.00 | Duplicate blocked — no lines created |
| Reconciliation control total — 16 Jul 2026 | 6 batches accepted · 1 duplicate blocked | 18,933,250.00 | 18,420,950.00 | 394 | 10 | 3 | 512,300.00 | Explained by 13 open items |
Difference fully itemised: 13 open items + 0 unexplained (tolerance AED 5.00/line). Close requires balanced totals + Finance Manager approval (FIN-04).
Lineage — source to report (§9.2)Lineage snapshot 17 Jul 2026 06:02
Bank feeds (CAMT.053 / MT940 / API)→
Dedupe + idempotency check (FIN-04)→
fin.bank_statement_lines→
Match engine v4 (auto / split / partial)→
Recon close approval — Finance Manager→
fin.recon_results→
RPT-13 semantic view fin_recon_v4
| Source object | Transformation | Refresh | Reconciliation evidence |
|---|---|---|---|
fin.bank_statement_lines | Import, dedupe by (account, ref, amount, value date) hash | Daily 06:00 + intraday API | Batch hashes in Audit Explorer |
fin.gl_cash_postings | Posted journals filtered to cash control accounts 1010–1060 | On posting | Drill-down to GL / RPT-08 |
fin.recon_results | Match state machine: matched / unmatched / exception | On match action | Close approvals with e-sign hash |
Static render mockup — no live data. Source: ERP Modern Development Specification v2.0 · Covers: RPT-13 (Table 15), FIN-04, FIN-10, §9.2 report definition of done.