Reconciled to the cent: what real reconciliation means
Sergei Pak · designs AI operating systems · русская версия
A bank statement drops overnight. By the time I open the laptop, the books have already squared with it to the cent: every entry in place, nothing left hanging. The interesting part started somewhere else.
What hides behind "deposit"
One line on the statement read "deposit". By its name, money set aside in reserve. The system looked at the movement and saw something else: an overnight sweep, the balance moved out at night and returned to the account in the morning. A reserve and a sweep look identical in a report and mean the opposite, one says "the money is frozen", the other says "the money works every night". Adding up the totals isn't enough. You have to know what each line is actually doing.
Why reconcile daily, not once a quarter
Reconcile a statement once a quarter and finding a discrepancy becomes an excavation: three months back, in a pile of entries, something drifted by 1,200 rubles. Reconcile after every statement and the same error surfaces the day it appears, while you still remember the context. Cheap infrastructure can afford to reconcile daily (there's a separate post on that), and the financial picture stops lagging behind reality.
How I check the system itself
Reconciliation has to be trusted, so I double-check it. The financial picture is assembled two independent ways, and I square them against each other. If both match the bank and each other to the cent, the number is good. I run four companies' data through this myself, statements reconciled to the last cent. If I didn't trust this reconciliation, I wouldn't keep my own money on it.
FAQ
- What does it mean to reconcile the bank to the cent?
- Every entry in the books matches the actual bank statement, with nothing left hanging or unexplained. The system does this after every statement, not once a quarter before the report.
- Why reconcile daily instead of once a quarter?
- Daily reconciliation surfaces a discrepancy the day it appears, while it's still clear where it came from. Quarterly reconciliation turns the search into an excavation and often masks classification errors.
- How do you make sure the automatic reconciliation isn't wrong?
- I keep two independent builds of the financial picture and square them against each other. If both match the bank and each other to the cent, the number can be trusted.