Reconciliation
How to Reconcile Your Rental Property Books (Without a Bookkeeper)
Reconciling proves your rental books are complete and correct. Here is how to do it yourself, the small gaps to expect, and the real culprits behind a balance that won't tie.
Most landlords pour their bookkeeping time into categories. Was that Home Depot run repairs or supplies? Does the water bill go on line 17? Useful questions. But they sit on top of an assumption almost nobody checks, which is that the transactions in your books are the same ones that moved through your bank account. Reconciling checks it. It is the step that turns a pile of transactions into books you can trust.
It is also the step most people skip, because it sounds like accountant work. It is not. If you can read a bank statement, you can reconcile.
What reconciling actually means
Reconciling an account means proving your books and the bank agree. You take a statement for a period (a month is the natural unit) and confirm two things: every transaction on the statement is in your books, and your books' ending balance for that account matches the statement's, once any pending charges clear.
Tie those out and you have proof. Nothing missing, nothing invented. When they do not tie, the difference between the two balances is the exact size of your problem, and it points straight at what to fix.
The bank statement is the record of what actually left and entered the account. Your books are supposed to be a faithful copy. Reconciling is the comparison that proves they are.
That is a live account in the demo you can open and click through, no signup.
Why it matters more than categorizing
A flawlessly categorized set of books can still be wrong. Categories only describe the transactions you already have, so if a $1,400 insurance payment never made it into your books, no amount of careful tagging puts it there. Your Schedule E comes up $1,400 short on insurance, and nothing on the page looks off.
That is why reconciling comes first in any books worth trusting. It settles "is the set complete and correct" before you spend an hour on "what line does each item belong on." We covered the category side in how to categorize rental expenses for Schedule E; reconciling is what makes those categories worth anything. It is also the kind of supporting record the IRS expects you to keep for rental income and expenses (see Publication 527).
How to reconcile, step by step
The manual process is short.
- Pick one account and one period. A single bank account or card, for one statement month. Do not try to do everything at once.
- Confirm the opening balance. Your books' starting balance should equal the statement's opening balance. If it does not, last month never reconciled. Fix that first.
- Match each transaction. Go down the statement and tick off each line against your books. Most match cleanly. Mark them cleared as you go.
- Find the gap. Compare your ending balance to the statement's. Match? You are done. If not, that difference is your target number.
- Explain the difference. It is always one of a handful of things, covered below. Work them off until the difference is zero.
When the ending balances tie, the account is reconciled. Run the same loop on each account and the whole set is proven. It is the same logic a bank reconciliation follows in any business. Rentals just have fewer accounts to run it on.
The handful of things that cause a gap
Reconcile enough rental accounts and the same culprits keep showing up. If your balance is off, it is almost always one of these.
A duplicate from a bank feed. This one comes in two forms. The feed can spin up a second copy of an account you already had, so the same charges split across two accounts and neither one reconciles. We hit it on an Amex Platinum: the feed created a duplicate card next to the one already being tracked, and the account sat $49.99 off until we merged the two. Or the account is fine and single lines come in twice, which is what a bank reconnect does (walked through below).
Timing, meaning pending versus posted. A charge can be pending in your books the day you enter it and post to the bank a day or two later, or the other way around. That throws a small difference, and it clears itself once everything settles. On that same Amex, a $40.88 leftover turned out to be a Netflix charge that pended on one date and posted on another. Nothing wrong. The dates had not caught up to each other.
A sign or direction error. Book a refund as a charge, or a payment as a deposit, and the balance swings the wrong way by twice the amount. Easy to spot: the gap comes out to exactly two times some real transaction.
A line the bank never had. A receipt you keyed in by hand for a charge that went on a different card, or a transfer entered on both sides. Your books have it, this statement does not, and removing it closes the gap.
A missing transaction. Sometimes a charge never made it in. A feed hiccup, a receipt you forgot to enter. The statement has it, your books do not, and keying it in closes the gap.
The size of the gap tells you which one to look for first:
| If the gap equals | Look for |
|---|---|
| One line's amount, books higher | A duplicate, or a line the bank never had |
| One line's amount, bank higher | A missing line |
| Twice one line's amount | A sign flip on that line |
| The total of your pending lines, or less | Timing; wait a day or two |
| None of the above | Two or more causes stacked; fix the one you can prove, then recheck |
In practice you knock the difference down one cause at a time. Add what is missing. Remove what is duplicated. Flip what has the wrong sign. Leave real timing differences to settle on their own. We have walked an account that was $725 off all the way down to zero doing exactly that, one line at a time.
A worked example: $9.87 after a bank reconnect
Here is a fictional rental expense card. Its old bank connection broke, the card was reconnected, and the new connection backfilled 90 days of history the books already had. At month end:
| Amount | |
|---|---|
| Bank's balance owed | $1,284.16 |
| Books, posted lines only | $1,294.03 |
| Books, posted plus one $63.20 pending charge | $1,357.23 |
Step one is to set the pending line aside. The bank posts pending charges over time, so its balance can sit anywhere from $1,294.03 to $1,357.23 and still be explained by timing. The bank's $1,284.16 sits below that range by $1,294.03 − $1,284.16 = $9.87. Pending does not explain it. The books are $9.87 high.
Step two is the table above. Books higher by one line's amount means a duplicate or a line the bank never had. The card carries a $9.87 smart-lock app subscription, and the books show it on October 3 and again on October 4. One came from the old connection. The other came from the reconnect backfill, with a different bank ID and slightly different wording ("SMARTLOCK APP" against "SmartLock App Subscr"). The October statement lists it once.
Step three is the check that makes it a fix and not a guess. The September statement also lists a $9.87 charge, so the September line is real and stays. Only October has a line the statement does not. Remove the newer October copy and keep the older one, since it already has its category and notes.
Posted books drop to $1,294.03 − $9.87 = $1,284.16. The bank says $1,284.16. The gap is $0.00, and the $63.20 pending charge will post on its own.
What Oberlin24 does with a gap
We hit a $9.87 double on our own books when a card moved to a new bank, and it changed how the app treats both reconnects and gaps.
A reconnect no longer doubles history. When a new bank connection backfills an account that already has rows, a backfilled line folds into an existing one when it has the same amount and direction, is dated within a day, and reads as the same bank line. The existing row is kept with its category and notes, and it takes over the new bank ID so later updates track it. Two different bank IDs on posted lines otherwise stay two real transactions. That rule exists because a manager paying rent in two equal halves four days apart once had its second half dropped as a "duplicate."
Pending is timing, not an error. The reconcile compares the bank's balance against the range between your posted-only and all-in book balances, the same step one as above. Inside the range reads as reconciled. A live bank balance read mid-day can also miss lines that post later that day, so the app checks the books through the prior day before calling a gap.
When an account is off, it looks for one provable fix. It lists the lines that could cause the gap, each with its exact effect: a duplicate or a line the bank never had (removing it lowers the books by its amount), a sign flip (twice its amount), a missing statement line (adds it). Then it searches for the single smallest set, up to three lines, that closes the gap to the cent. If exactly one set does, it applies it, re-reads the account, and keeps the change only if the books now match the bank. If they do not, every change is undone. If two different sets of the same size both close the gap, that is a guess, so it changes nothing and tells you. When nothing provable exists, it refreshes the live bank balance once, so a stale bank figure heals on its own.
Removed rows are archived, not deleted. A missing line it adds goes into your review queue uncategorized, since the statement says what happened but not which Schedule E line it belongs on. With the books autopilot on (it is opt-in), this runs in the hourly pass and leaves a receipt like "It was off from the bank. I removed a duplicate $9.87 line, and the books match the bank again." Every change can be undone from History.
The by-hand method above is the same logic. The app runs it every hour instead of once a month.
Make it a monthly habit
Reconciling feels painful for one reason, almost always: it got left too long. One month is a handful of transactions and a small gap to explain. A year is hundreds of transactions and a gap that might be a dozen separate problems stacked on top of each other.
So do it when each statement closes, ideally the same week. Once you are caught up it is a few minutes per account. If you keep books in spreadsheets, two free templates carry the habit: the rent ledger template keeps the per-tenant payment history your deposits should tie back to, and the balance sheet template is where your reconciled cash balances land at each month-end. The moment your numbers feed a real decision, like the calculators in our free tools or the deduction math behind paying no tax on your rental income, reconciled accounts are what make those numbers mean anything. Twelve reconciled months also make tax season short, and the rental property tax prep checklist covers what else your preparer will ask for.
Keep one bookkeeping habit and make it this one. Categorize when you have the time. Reconcile every month, and after any bank reconnect, because an unreconciled book is a guess, no matter how tidy it looks.
Frequently asked questions
How often should I reconcile my rental accounts?
Once a month, when each bank and card statement closes. Monthly keeps the gaps small and easy to trace. If you have only ever caught up once a year, work through it month by month rather than all at once, because a year of mismatches is far harder to untangle than twelve small ones.
My books are off by a few dollars. Is that a problem?
Usually it is timing, not an error. A charge that posted on a different day than it cleared, or a pending transaction that has not settled, throws a small difference that resolves itself in a day or two. If the gap is a round number or repeats every month, look for a duplicate or a sign flip instead.
Do I still need to reconcile if I use a bank feed?
Yes, and it helps to be clear on what reconciling actually compares: the cash balance in your own books against the balance the bank shows on its statement. You would expect a feed to keep those equal on its own, since the data comes straight from the bank, and often it does. But a feed does not always write your books cleanly. It can create a duplicate account so the same charges split across two, import a transaction twice, or drop one, and it can collide with anything you entered by hand, like a receipt you keyed in that the feed then pulls again. Reconciling each month is the quick check that your books' balance still ties to the bank's, so those slip-ups get caught before they land on your return.
What is the difference between reconciling and categorizing?
Categorizing decides which Schedule E line a transaction belongs on. Reconciling proves the transactions are all there and correct in the first place. You can have perfect categories on an incomplete set of transactions and the books will still be wrong.
Can I reconcile without accounting software?
Yes. All you need is the statement and a way to mark each transaction as matched, even a spreadsheet. Software makes it faster by flagging the gaps for you, but the logic is identical: match what you have, then explain the difference until it is zero.
Why are my books off right after I reconnected my bank?
A reconnect, or a card that moved to a new bank, often backfills months of history the books already have. The bank labels the new copies with new IDs and sometimes new wording, so a feed that only matches on IDs books them twice. Look for pairs with the same amount and direction, dated within a day, that read as the same line. Delete or archive the newer copy and keep the one you already categorized.
Are two charges for the same amount a duplicate?
Not on amount alone. A $9.87 subscription bills every month, and some managers pay rent in two equal halves a few days apart. Check the statement: if it lists the charge twice, both are real. A duplicate is a line your books have twice that the statement has once.
What does it mean when the gap is exactly twice a transaction?
A sign error. A refund booked as a charge, or a payment booked as a deposit, moves the balance the wrong way by twice its amount. A $24.50 refund booked as a $24.50 charge shows up as a $49.00 gap. Flip that one line and the gap closes.