MyClawn Books › Bank reconciliation
Bank reconciliation, and catching up on months you never closed
Reconciling means proving that your records match what the bank says. When months pile up unreconciled, the job is the same but bigger. Here is how it works in our prep, and how to catch up.
What reconciliation is
A bank reconciliation compares the transactions in your books with the transactions on the statement for the same period, and explains any difference. If your ledger says money in minus money out equals X and the statement says the balance moved by X, you are reconciled. Differences come from missing rows, duplicate rows, transactions that cleared in a different month, or typing errors.
How our prep reconciles
- Every transaction row from every statement is extracted into one table.
- Rows are counted per file and compared with statement totals or running balances.
- If rows do not reconcile, the cause is searched for (a missed row, a duplicate, a header counted as a row) before anything is delivered.
- The ledger total is re-added against the statements, and the result, success or a stated gap, goes in the Notes tab.
We reconcile from the files you upload, not against live bank data, so what you upload is what is checked. If a statement is missing, the gap shows up.
Drop your statements here. Starter $49/mo · Pro $149/mo. Refund within 14 days if it misses.
Upload your filesCatch-up months
Use the Catch-up months template: These files cover several months I never closed. Give me one ledger with a month column, a P&L per month, and one import CSV. You get one ledger across all months, one P&L column per month, one import CSV (QuickBooks Online by default, Xero on request) and one Questions tab, with duplicates across overlapping statements flagged. Up to 60 files per upload; use several uploads if you have more.
What catch-up costs
Firm guides list cleanup work commonly at $150 to $500 per month of backlog. On Starter, four uploads at $49 for the month can cover several months of statements, depending on how many files you have. These are published ranges from bookkeeping firms, not quotes.
Common reasons things do not reconcile
| Cause | What to look for |
|---|---|
| Missing statement | A month gap, or opening balance not equal to prior closing |
| Duplicate rows | Same date, amount and description twice |
| Transfers counted twice | One transfer shown as money out and money in across accounts |
| Timing | Item posted in a different month than the receipt date |
| Card payments | A card payment from checking treated as an expense and also in card spending |
Reconciliation checklist
- Opening balance equals last month closing balance.
- Every deposit and withdrawal on the statement is in the ledger once.
- Transfers between accounts appear as one movement, not income and expense.
- Card payments are matched to the card statement.
- Closing balance equals opening plus net movement.
- Anything unexplained is written down, not rounded away.
Our Notes tab reports on these checks for the files you upload.
When it will not reconcile
Sometimes the files themselves are the problem: a PDF statement where a page is missing, a CSV that cuts off at a row limit, or an export that skips pending items. In that case the result says what did not add up and by how much, instead of hiding it. Re-download the statement, upload again, and use one of your two rounds of changes. That honest gap is more useful than a clean-looking ledger that is silently wrong.
Be realistic
Missing statements leave gaps. Quality is only as good as the files: if a month is missing, upload it or the result will say so. Not tax advice; have a CPA review before filing. If you would rather have a person do the catch-up and talk to you, hire a bookkeeper. See FAQ and pricing.
Upload this month's statements. Bookkeeping prep only, not tax advice. 14-day refund if it misses, two rounds of changes, cancel any time.
Drop your statements here. Starter $49/mo · Pro $149/mo. Refund within 14 days if it misses.
Upload your filesMore about Books
Sources (checked 2026-11-09): beancount.io/blog/2026/10/05/how-much-does-a-bookkeeper-cost-2026-pric · tgg-accounting.com/how-much-does-bookkeeper-cost/