VanillaPM
translation in beta
Se connecter Commencer gratuitement Dashboard

Reconcile the bank & close the period

Learn Finance · Fund & Financial Accounting · Task B8. Tie the books to the bank, complete the period-end entries, and close the month so every report drawn from it is final.

What it is

Bank reconciliation proves that the cash the ledger says you have matches what the bank says you have. They rarely agree on the day — because of timing: - Outstanding payments — you recorded a cheque/transfer the bank hasn't cleared yet. - Deposits in transit — money received that hasn't hit the statement yet. - Bank-only items — charges, interest, or fees you didn't know about until the statement.

Closing the period is the step after: finish the entries that only happen at month-end (accruals, FX revaluation, depreciation), confirm everything reconciles, then lock the month so no one can post into it.

Why it matters

  • Reconciliation catches what nothing else does — a missing transaction, a duplicate, an unauthorised withdrawal. It's the single most important routine control in finance.
  • An unreconciled bank account means you don't actually know your cash. Every budget-vs-actual and donor report built on top is suspect.
  • Closing makes numbers final. "The September accounts" only mean something if September can't change after it's reported. The lock is that guarantee.

Where you do it in VanillaPM

Everything below is in Finance → Accounting. A step-by-step:

  1. Reconcile the bank. In BankReconciliation, match ledger entries to the bank statement, identify the reconciling items (timing differences, bank charges), and confirm the adjusted balances agree. CashCount does the same for physical cash / petty cash.

  2. Capture the period-end entries. Before you close, book what the month owes but hasn't yet recorded: the FX revaluation of open monetary items (B6), accruals for goods received not invoiced, and the grant income recognised by matching (B3).

  3. Close the period. Flip the AccountingPeriod open → closed. Posting into a closed month is then blocked (B2), which is what makes a reported figure final.

  4. Re-opening is deliberate. Should you ever need to re-open a closed period, it's an explicit, logged decision — not a quiet edit — so the integrity of a signed-off month is never in doubt.

Walked example — Hilsa Health Initiative

At month-end the ledger shows a bank balance of BDT 4,150,000; the bank statement shows BDT 4,190,000. Reconcile the difference:

Item Amount Effect
Ledger balance 4,150,000 starting point
+ Deposit in transit (donor top-up not yet on statement) 60,000 add
− Outstanding supplier payment (not yet cleared) 15,000 subtract
− Bank charges (statement-only, now booked) 5,000 subtract
Adjusted ledger balance 4,190,000 = statement ✓

The BDT 5,000 of bank charges becomes a new journal entry (Dr bank charges / Cr bank); the timing items need no entry — they clear next month. Now the month ties, and it can be closed.

The numbers

The reconciliation identity: ledger balance ± timing items ± bank-only items = statement balance. Anything left unexplained after timing and bank items is a real discrepancy — a missing or wrong entry to find before you close. You never close a period that doesn't reconcile.

Controls & evidence

  • A reconciliation performed every month, reviewed by someone other than the preparer.
  • Every reconciling item explained — no "unidentified differences" left hanging.
  • A close checklist completed (reconciliations done, accruals and FX revaluation posted, grant income recognised) before the lock.
  • Closed periods locked — the evidence that reported numbers are final.

Best practices & pitfalls

  • Do reconcile monthly, not "when there's time." Discrepancies are cheapest to find fresh.
  • Do post bank-only items (charges, interest) as you find them on the statement.
  • Pitfall: forcing a reconciliation by writing off an unexplained difference. That difference is information — investigate it.
  • Pitfall: closing before the period-end entries (FX revaluation, accruals) are in. A month closed with those missing is a month you'll have to re-open.

Practise question

Q1. Your ledger shows BDT 1,000,000; the bank statement shows BDT 1,020,000. You find an uncleared supplier payment of BDT 30,000 and bank interest of BDT 50,000 not yet in the ledger. Does it reconcile, and what entry (if any) do you post?

Answer: 1,000,000 − 30,000 (outstanding payment) + 50,000 (interest) = 1,020,000 = statement ✓ — it reconciles. The interest needs a journal entry (Dr Bank 50,000 / Cr Interest income 50,000); the outstanding payment is a timing item that clears next month, so no entry for it.

Terms used here

  • Bank reconciliation — proving ledger cash equals bank cash, explaining the differences.
  • Reconciling item — a timing or bank-only difference between the two.
  • Accrual — recognising a cost/income in the period it relates to, before the cash moves.
  • Period close / lock — finalising and freezing a month's numbers.
  • Related: Record a balanced journal entry — the period lock that close enforces.

How an auditor / donor expects this

They expect a monthly bank reconciliation, reviewed and signed, with every item explained, and closed periods that don't move. Reconciliations are among the first things an auditor asks for — a clean, reviewed monthly rec plus a locked period is the evidence that the organisation's cash and reported figures can be trusted. This is where the whole track lands: coded, balanced, matched, recovered, revalued — and finally, reconciled and closed.