GUIDE
Bank Reconciliation Problems: Why Your Books Don't Match the Bank and How to Fix Them
Your books don't match the bank when the balance your bookkeeping shows for an account differs from the statement balance on the same date. The difference is always made of specific transactions you can find.
This guide finds the difference safely, then fixes it. The examples use Demo Flips LLC, a sample company. Every number is invented data.
What does it mean when your real estate books don't match the bank?
The balance your books show for an account differs from the statement balance on the same date. The difference is never random. It is made of specific transactions: missing, doubled, reversed or in the wrong account.
A match looks like this. On Sep 30, 2026, the books of Demo Flips LLC showed checking at $193,631.75 and the business card at -$9,895.59. Both statements showed the same.
This is the troubleshooting half of the reconciliation step in the month-end close checklist.
What should you do before you change anything?
Save the statement, write down the exact difference and its date, and leave months already reconciled alone. Then find the transactions that make up the difference. Never post a balancing entry just to make the gap disappear.
- Keep a copy of the statement and of the last reconciliation that worked.
- Write the difference down to the cent. Every check below starts from that number.
- Leave reconciled months as they are. Changing one moves the starting balance of every month after it.
- Do not post a plug entry. It makes the gap disappear and hides the transaction that caused it.
- Change 1 thing at a time, and note what you changed and why.
How do you find the difference, step by step?
Check the starting balance, then work from the exact amount: 1 transaction of that amount, 1 of half that amount entered backwards, 2 swapped digits if it divides by 9, then a transfer recorded on only 1 side.
- 1Check the starting balance first. If the books' opening balance differs from the statement's beginning balance, an earlier month that was already reconciled has changed. Fix that month before this one.
- 2Write down the exact difference, to the cent, and the statement date.
- 3Set aside timing differences. A check you wrote that has not cleared yet (an outstanding check) and a deposit you recorded that the bank has not posted yet (a deposit in transit) are in the books but not on the statement. They are not errors, and they should clear on the next statement. What is left after them is the difference to explain.
- 4Look for 1 transaction of exactly that amount, in the books or on the statement. It is either doubled in the books or missing from them.
- 5Look for 1 transaction of half the difference. It was probably entered with the wrong sign: money in recorded as money out, or the reverse.
- 6If the difference divides evenly by 9, look for 2 digits typed in the wrong order.
- 7Look for a transfer or card payment recorded in 1 account but not the other.
- 8If nothing matches, tick the statement off against the books line by line, starting from the first day of the month.
The size of the difference usually points to its cause:
| If the difference is | Look for | Example |
|---|---|---|
| Exactly 1 transaction | A duplicate in the books, or a transaction missing from them | The $1,620.00 card receipt from Oct 14, 2026, entered twice (below) |
| Twice 1 transaction | A transaction entered with the wrong sign | If the $1,374.00 card payment were entered as money in, checking would be $2,748.00 off |
| Divisible by 9 | 2 digits swapped | If $1,620.00 were typed as $1,260.00, the gap would be $360.00, and 360 divided by 9 is 40 |
| The same as a transfer | A transfer recorded in only 1 account | See the card payment section below |
How do duplicate transactions get into your books?
Most often the same purchase arrives twice: once entered by hand from the receipt and again from the bank or card download. Importing the same statement twice does it too. Each copy looks real on its own.
QuickBooks Online can connect a bank or card account and download its transactions automatically, as Intuit's help page describes. A purchase you already entered by hand then arrives a second time.
On Oct 14, 2026, a single business card receipt of Demo Flips LLC covered materials for Project 8 and Project 10. It was entered by hand that day, with its split. Then the card download brought the same charge in again. Dated after the September close.
| Date | Entered from | Amount | Project 8 | Project 10 |
|---|---|---|---|---|
| Oct 14, 2026 | The receipt, by hand | -$1,620.00 | -$1,080.00 | -$540.00 |
| Oct 14, 2026 | The card download | -$1,620.00 | Not split | Not split |
| Card charges in the books | -$3,240.00 |
The card statement shows the charge once, so the books are $1,620.00 off.
Keep the copy with the receipt and the split, and match the downloaded line to it instead of adding it. October was still open, so nothing reconciled had to change.
Matching downloads to entries inside the software is part of setting up QuickBooks for house flippers.
What do you do with uncategorized transactions?
Do not guess. Park each one in a holding account, write down what is unknown and ask the person who knows. Categorize it when the answer arrives. Uncategorized items leave the balance right but the profit wrong.
On Sep 3, 2026, $850.00 left the checking account of Demo Flips LLC for Sample Credit Union. Nobody knew yet whether it was for the business. It went into a holding account named Unclear transfer, flagged for an answer.
The checking balance was still right, so the September reconciliation worked. What stays unfinished is the profit. Until the answer comes, nobody can say which project, if any, the $850.00 belongs to. That is why it went on the list we send with the reports:
- Tell us if the $850 transfer to Sample Credit Union on Sep 3, 2026 was for the business or personal.
- Send the invoice for the $1,240 payment to Sample Plumbing LLC on Sep 21, 2026 (Project 8).
The second item is a different kind of open item. The $1,240.00 payment is categorized, to Project 8 plumbing, but its invoice is missing.
Some items arrive with no category but are easy to settle. On Oct 21, 2026, a $72.00 refund for returned drywall came back to the card with no category. It belongs to Project 8's materials, so Project 8's share of the Oct 14, 2026 receipt dropped from $1,080.00 to $1,008.00.
Can a transfer or card payment cause the mismatch?
Yes, when it is recorded in only 1 account, or recorded as income or an expense. A card payment booked as an expense leaves the card balance in your books too high by exactly the payment.
On Sep 25, 2026, Demo Flips LLC paid $1,374.00 from checking to its business card. If that payment had been booked as an expense in checking, the card account would never have received it. The card would show $1,374.00 more owed than the card statement.
Money moving between your own accounts is the third common cause. We walk through each kind in how to record transfers and credit card payments.
When is it time to get help?
When the starting balance no longer matches, when several months are off, or when the same difference keeps coming back. Those point to older errors, and fixing them month by month from the statements is a cleanup.
A starting balance that has moved, or several months that are off, has a known fix. Our real estate bookkeeping cleanup service rebuilds those months from your statements.
Once the books are current, every account is reconciled each month.
Your company's performance, one deal at a time.
Flipper Bookkeeping keeps the books for real estate investors and sends you, every month, a profit and loss for each deal, budget against actual during the rehab, holding costs month by month and cash against profit. See real estate investor bookkeeping.
Free to use: the bookkeeping cleanup checklist.