The Short Answer

A spreadsheet is a legitimate system for one or two long-term rentals, one bank account, and an owner who reconciles it monthly. It is outgrown when the month-end total no longer ties to the bank statement, the same number lives in two tabs that disagree, a partner or lender asks for a balance sheet, or short-term payouts need splitting.

When is a spreadsheet still the right system?

For a narrow but common situation, a spreadsheet is a fine set of books. The conditions: one or two long-term rentals, one bank account and one card used only for the rentals, and an owner who checks the spreadsheet total against the bank statement every month end. A rent deposit, a mortgage payment, an insurance bill, and a couple of repairs fit in a dozen rows, and the CPA has no reason to send the year-end summary back.

The reconciling is what makes it work. Two doors with no monthly bank check have already outgrown the spreadsheet; three doors checked every month may be fine for a while yet.

“A spreadsheet that gets checked against the bank every month is a ledger with extra typing. One that gets updated when someone remembers is a list of guesses.”

What are the signals it has been outgrown?

None of them is “when you get serious.” Each is a specific job the spreadsheet was never built for.

  • It no longer ties to the bank statement at month end, and nobody can say why. The first time, you find the missing row. The third time, you stop looking.
  • The same number lives in two tabs and they disagree. Rent on the summary tab, rent on the property tab, and a formula that broke when a row was inserted in March.
  • A second entity or a partner needs their own view. A second LLC needs its own books and bank account. A partner wants their share and the capital account behind it. Filtering one workbook by a column is a report, and they will ask for the real thing.
  • Short-term rental payouts need splitting. One deposit that bundles rent, platform fees, cleaning, and guest-collected lodging tax is four entries, and the tax portion is a liability rather than income.
  • Capital improvements are a note in a cell. “New roof, see invoice” in a comment is not an asset with a date, a cost, and a property, and the CPA needs exactly that for the depreciation schedule.
  • A lender or CPA asks for a balance sheet, and there is none. A spreadsheet tracks what came in and went out. What you own and owe at a point in time is a separate structure nobody maintains by hand for long.

What does a ledger add that a spreadsheet cannot?

Four things, each closing a gap from the list above. Which platform is a separate decision; our Stessa versus QuickBooks Online comparison covers where each fits.

  • A bank feed with reconciliation. Transactions arrive from the bank instead of being typed, and month-end reconciliation either clears or shows the exact difference. “Does not tie and nobody knows why” stops being a mystery.
  • A balance sheet that balances. Double-entry means every transaction touches two accounts, so the loan balance, escrow, deposits held, and owner’s equity are tracked as a by-product of ordinary bookkeeping. When the lender asks, the report already exists.
  • Per-property tagging. Each transaction carries a property (Stessa’s property field, a QuickBooks class), so a per-property profit and loss is a filter rather than a second tab. Per-property P&L from one bank account walks through the setup.
  • An audit trail. Every entry keeps its date, source, and edit history. A spreadsheet cell holds only its current value.
Example

The third door

A landlord runs two long-term rentals from one workbook for four years, and every month the total matches the bank to the penny. In year five they close on a third property with a new loan and escrow account, and a week after closing the seller wires over the tenant’s $1,500 security deposit. The next month the spreadsheet is $300 off the bank, because a closing credit for prorated rent was never entered, and that is the only error the cash check can see. Two more are invisible to it: the $1,500 deposit wire was typed in as rent, and the $600 escrow portion of the new mortgage payment was typed in as interest. Both match the bank to the dollar and both are wrong, and the year-end summary will carry them to the CPA. The third door introduced three kinds of transaction the workbook had no row for, and a five-minute check stopped proving what it used to prove. Illustrative example.

How do I move off it without re-keying history?

Do not migrate the spreadsheet. Start the ledger on a clean date and leave the history where it is.

  1. Pick a start date. January 1 of the current year is the usual choice, so the whole tax year lives in one system. Late in the year, January 1 of next year is the alternative.
  2. Set up the chart of accounts before the first transaction. Our chart of accounts article and the free template are the starting point; a structure that is right on day one avoids recategorizing later.
  3. Enter opening balances from statements, not from the spreadsheet. Bank balance from the bank statement on the start date; loan balance from the lender; escrow from the escrow statement; deposits held from the leases; each property at cost, plus improvements to date, from closing statements and invoices. The spreadsheet is a cross-check. The statements are the source.
  4. Connect the bank feed from the start date and reconcile the first month. If it clears, the opening balances were right. If not, fix it now, with one month to look at rather than twelve.
  5. Keep the spreadsheet as an archive. It is the record for prior years. Re-keying them takes weeks, introduces new errors into filed years, and produces nothing the CPA needs.

The Bottom Line

A spreadsheet is outgrown at a specific moment, usually a recognizable one: the month the total stopped tying and nobody could say why, or the day a lender asked for a balance sheet. Until then, a reconciled spreadsheet for one or two doors is a legitimate system. When the moment arrives, start a ledger on January 1, enter opening balances from statements, connect the feed, and leave the history where it is.

Real Cents Organized is a bookkeeping firm. We record and organize the books; your CPA determines the filing position, the depreciation schedules, and what any of this means on your return.

Frequently asked questions

Can I keep a spreadsheet alongside bookkeeping software?

Yes, for the things a ledger does not hold well: the rent roll, lease dates, tenant contacts, a capital improvement list with invoice references. The ledger is the record of money in and money out, and the reconciliation is what proves it. Keep the spreadsheet for reference and planning, and stop treating it as the books once the ledger is live.

Is Stessa enough after the spreadsheet, or do I need QuickBooks Online?

For a few long-term doors in one entity, Stessa is often enough and is the smaller step up from a spreadsheet: it brings the bank feed and per-property tagging, though as a single-entry system it does not produce a balance sheet that ties out. QuickBooks Online is the usual answer once a second entity, a partner, or a lender asking for a balance sheet enters the picture. Our Stessa versus QuickBooks Online article covers the decision in detail.

My spreadsheet history has errors. Do I fix it before migrating?

No. Prior years are already filed, and rebuilding them produces nothing the CPA needs. Enter opening balances from the bank, lender, and escrow statements on the start date, so the ledger begins from a verified position rather than from the spreadsheet. If you find a material error in a filed year, note it and hand it to the CPA rather than editing the archive.

TL

Tom Latuga

Founder, Real Cents Organized

Tom is a real estate investor, Intuit Trained Bookkeeper, and founder of Real Cents Organized. He helps landlords and real estate investors across the United States transform messy books into tax-ready clarity.

Read more about Tom →