Bank sync failed at 06:00 — the BML statement format changed, so today's auto-import and auto-matching didn't run (automation au8). Reconcile manually below or paste the CSV.
Fix in Automation 🏦 Bank
BML Current · 7730-****-1042 MVR 412,860.55 Bank of Maldives
🕌 Bank
MIB Savings · 9010-****-3377 MVR 186,420.00 Maldives Islamic Bank
🏦 Bank
BML USD · 7730-****-8821 USD 14,250.75 = MVR 219,746.57 @ 15.42
💵 Cash
Main Cash Drawer MVR 18,240.00 On premises — counted at shift close
Total across accounts (MVR) MVR 837,267.12
Cash flow — 30 days
net 400,389 MVRJun 15Jun 22Jun 29Jul 6Jul 13
Daily net movement, all accounts, MVR. Payroll (10 Jul) and rent (13 Jul) are the two big out-days.
Daily cash summary — today (14 Jul)
Money inMVR 24,906.40
Money outMVR 855.00
POS cash takings — Malé HQ (to 14:00) +6,480
Card settlements — BML gateway (13 Jul) +18,426.4
Petty cash float top-up −855
Card takings settle T+1 — today's POS card sales land in BML Current tomorrow morning.
Opening & closing balances — last 5 days
all accounts, MVR equivalent| Day | Opening | In | Out | Closing | Net |
|---|---|---|---|---|---|
| 10 Jul | MVR 913,096.72 | 15,000 | 99,000 | MVR 829,096.72 | -84,000 |
| 11 Jul | MVR 829,096.72 | 28,527 | 14,200 | MVR 843,423.72 | +14,327 |
| 12 Jul | MVR 843,423.72 | 25,000 | 31,420 | MVR 837,003.72 | -6,420 |
| 13 Jul | MVR 837,003.72 | 4,212 | 28,000 | MVR 813,215.72 | -23,788 |
| 14 Jultoday | MVR 813,215.72 | 24,906 | 855 | MVR 837,267.12 | +24,051 |
Bank reconciliation — BML Current · 10–13 Jul
difference —Tick statement lines to match them against book entries with the same reference. The difference must reach MVR 0.00 before the reconciliation can complete. One statement line (the BML service fee) has no book entry yet — add it, don't force it.
Bank statement (7 lines)
| Date | Description | Amount | Match | |
|---|---|---|---|---|
| 13 Jul | CHQ/TRF HDC RENT JUL | −28,000 | JV-0552 | |
| 12 Jul | STELCO BILLPAY 5501 | −6,420 | EXP-0210 | |
| 12 Jul | IB TRANSFER TO 9010***3377 | −25,000 | TRF-0092 | |
| 11 Jul | TRF FELIVARU FISHERIES | −14,200 | SP-0219 | |
| 13 Jul | MERCHANT SETT 130726 | +18,426.4 | SETT-0713 | |
| 10 Jul | CASH DEPOSIT BRANCH 001 | +15,000 | DEP-0201 | |
| 12 Jul | BML SERVICE FEE JUL | −145 |
Book entries (6 lines)
| 13 Jul | Rent — HDC Hulhumalé JV-0552 | −28,000 | open |
| 12 Jul | STELCO utilities EXP-0210 | −6,420 | open |
| 12 Jul | Transfer to MIB Savings TRF-0092 | −25,000 | open |
| 11 Jul | Supplier payment — Felivaru SP-0219 | −14,200 | open |
| 13 Jul | Card settlements 13 Jul SETT-0713 | +18,426.4 | open |
| 10 Jul | Cash deposit from drawer DEP-0201 | +15,000 | open |
Statement import — paste CSV
While the au8 feed is down, paste statement rows as date,description,amount (one per line). They parse and stage into the statement table above.
Transaction history — all accounts
| Date | Account | Memo | Ref | In | Out |
|---|---|---|---|---|---|
| 14 Jul | Main Cash Drawer | POS cash takings — Malé HQ (to 14:00) | SHIFT-0713A | 6,480 | — |
| 14 Jul | BML Current | Card settlements — BML gateway (13 Jul) | SETT-0713 | 18,426.4 | — |
| 14 Jul | Main Cash Drawer | Petty cash float top-up | PC-0714 | — | 855 |
| 13 Jul | BML Current | HDC shop rent — Hulhumalé (EXP-0211) | JV-0552 | — | 28,000 |
| 13 Jul | Main Cash Drawer | POS cash takings — Hulhumalé | SHIFT-0712B | 4,212 | — |
| 12 Jul | BML Current | STELCO utilities (EXP-0210) | EXP-0210 | — | 6,420 |
| 12 Jul | MIB Savings | Transfer in from BML Current — reserve build | TRF-0092 | 25,000 | — |
| 12 Jul | BML Current | Transfer out to MIB Savings — reserve build | TRF-0092 | — | 25,000 |
| 11 Jul | BML Current | Supplier payment — Felivaru SI-0133 (SP-0219) | SP-0219 | — | 14,200 |
| 11 Jul | BML USD | Coral Reef Resort — USD invoice receipt | RCP-0448 | USD 1,850 | — |
| 10 Jul | BML Current | Payroll — June (PAY-0219) | JV-0549 | — | 84,000 |
| 10 Jul | Main Cash Drawer | Cash deposit to BML Current | DEP-0201 | — | 15,000 |
| 10 Jul | BML Current | Cash deposit from drawer | DEP-0201 | 15,000 | — |
| 9 Jul | BML Current | m-Faisaa wallet settlement | SETT-0708 | 7,315.5 | — |
| 8 Jul | MIB Savings | Profit share — MIB Q2 | MIB-PS-Q2 | 1,240.6 | — |
| 8 Jul | BML USD | TT to Colombo Trade House (SP-0218) | SP-0218 | — | USD 1,200 |