Cash & banking

Cash, and proof that it is there.

Each bank account mapped to the ledger account it is, statements loaded against it, and what is still unmatched listed rather than hidden.

Bank statement · BPI 1885imported this morning
Deposit — Ayala takings16 Sept₱284,120matched
Deposit — IT Park16 Sept₱241,880matched
Check 004412Nestle Phils-₱412,900matched
Check 004413issued, not yet presented-₱88,400open
Bank chargeunrecorded-₱1,200to post
Auto-matchedof 148 lines14699%
BANK RECONCILIATIONBPI 1885 · 16 September
Balance per bank8,412,900.00
Less outstanding checks(88,400.00)
Add deposits in transit142,600.00
Less unrecorded charge(1,200.00)
PER BOOKS8,465,900.00
2 itemsleft for a person
Agrees to the general ledger
What it is

Bank accounts, statement loading, reconciliation, check registers and petty cash.

How it works

What it actually does.

01

A ledger account with no bank account is visible

The accounts that can never be reconciled are listed separately, because a reconciliation that silently skips an account is worse than one that fails.

  • Statements loaded per account, matched against posted entries.
  • What is unmatched is listed, with why, rather than absorbed.
  • Checks written, outstanding, and the numbers that are missing from the sequence.
Across four accounts₱8,412,006
BDO — operatingreconciled to 15 Sep₱4,882,110
BPI — payrollreconciled to 15 Sep₱2,140,400
Metrobank — collectionsreconciled to 14 Sep₱1,284,496
Petty cash, all sitescounted Monday₱105,000

Including the tin in the drawer, because that is money too and it is where it goes missing.

02

Petty cash that balances

Each float, what has gone out of it, and what is left. When the float and the movements disagree it is a missing receipt, and the report says which float.

  • Replenishment against what was actually spent.
  • Every movement carries its document.
  • Variance thresholds you set, not ones we chose.
Checks written
004810Danao Meats TradingCleared 12 Sep₱37,766.40
004811Tirso SupplyCleared 13 Sep₱18,204.00
004812SSS remittanceCleared 14 Sep₱94,200.00
004813Cebu LightOutstanding, 6 days₱42,118.00

Outstanding checks are a reconciling item, not a missing payment — the difference matters at year end.

Questions

The ones people ask about this.

Can it import our bank’s statement format?

Yes — through a feed where the bank offers one, and through the file they send where they do not. Either way the matching is the same.

What happens to an unmatched line?

It stays listed as unmatched. Nothing is force-matched, because a reconciliation that always balances is not a reconciliation.

Do you handle multiple currencies?

Yes, at a rate that carries the source it came from and its date. Nothing is a gain until the bank has actually bought the notes.

Can we print checks?

Yes, with the register tracking the sequence so a gap is visible rather than discovered.

See it on your own figures.

Bring one ordinary day from your business and we will run it through in front of you, on your own items and your own prices.