Bank feeds are the best thing to happen to small business bookkeeping in twenty years, and they are also the reason a lot of books are quietly wrong.
The problem is not that feeds are bad. It is that they look authoritative. Transactions appear automatically, from the bank, so owners reasonably conclude the data must be complete. It frequently is not.
The four ways a feed misleads you
It drops transactions. Connections break. Banks change their systems, credentials expire, an outage lasts a day. When the feed comes back it often resumes from the current date rather than backfilling the gap. Nothing announces this. You simply have a hole in your records, and the only sign is that a month will not reconcile.
It duplicates them. The mirror image, and worse. Reconnect an account and the feed may re-import an overlapping range. Now the same expense appears twice. Each copy looks entirely legitimate on its own, which is why duplicates survive review, and they inflate both revenue and expenses.
It only reaches back so far. Most feeds pull ninety days on first connection. If you are eleven months behind, connecting the account gives you three months and a confident empty space where the other eight should be.
Pending amounts change. A transaction can post as pending at one amount and settle at another. Restaurant tips and fuel holds do this constantly. If the pending version was recorded and never updated, your books carry the wrong number.
What reconciling actually is
Reconciling means proving that your books agree with the bank’s ending balance for a specific month. Not approximately. Exactly, to the cent.
That is the whole idea, and its power is that it is a completeness check rather than a spot check. You are not reviewing transactions and forming an opinion. You are testing whether every transaction that happened is recorded, once, at the right amount. A missing item, a duplicate item and a wrong amount all break the match.
Nothing else you do in bookkeeping tests that. Categorizing well does not. Reviewing the feed does not. Only the reconciliation proves the data underneath is true.
Why unreconciled books are worse than no books
This is the part worth sitting with. Unreconciled books do not fail obviously. They produce reports that look completely normal and are wrong by an unknown amount.
An owner with no books knows they do not know their numbers. An owner with unreconciled books believes they do. The second one prices jobs, plans hiring and makes commitments based on figures nobody has verified, and the P&L reads perfectly plausibly the entire time.
Confident wrong numbers cost more than absent ones.
Reading the difference when it will not balance
When a month is out, the amount itself is a clue. After enough of these you start recognizing them.
Off by exactly one transaction’s amount. Almost always a duplicate or an omission. Search that figure.
Off by a round number. Usually a transfer recorded on one side only. Money left savings and never arrived in checking, as far as the books are concerned.
Off by twice a transaction. A single item entered twice, or entered with the wrong sign, which doubles the error.
Off by a small odd amount. Often a pending amount that settled differently, or a fee posted separately from the transaction it belongs to.
Off by a lot, suddenly, in one month. Look for a feed gap. Compare the transaction count in the books against the statement for that month.
The order matters
Oldest month first, always.
Books are cumulative. An error in March sits in every balance from March onward, so reconciling September while March is broken means reconciling September again after you fix March. Owners who work backward from the current month routinely do the whole year twice.
What good practice looks like
- Reconcile every account, including the card you barely use. The forgotten account is where the surprises are.
- Reconcile against the PDF statement, not the feed. The statement is the bank’s own record of the month. The feed is a copy that may be incomplete, and checking a copy against itself proves nothing.
- Do it monthly, close to month end, while you can still remember what an unfamiliar charge was.
- Investigate every difference. A month that is off by a few dollars is not close enough. It means something specific is wrong and you have not found it yet.
If you have never reconciled
Then you do not currently know whether your reports are accurate, and no amount of looking at them will tell you.
That is a fixable position and a common one. It is ordinary catch-up work: start at the oldest unreconciled month and go forward. The first month is the slow one, because that is where the accumulated problems surface. After that it moves quickly.
The payoff is not tidiness. It is that at the end you have numbers you are entitled to trust, probably for the first time.
If you would rather not do it yourself, send me three months of statements and I will build you a real Profit and Loss from them, free, reconciled against the statements rather than a feed, so you can see what the accurate version of your numbers actually looks like.