How I keep books for flips, rentals and private loans without losing my mind

How I keep books for flips, rentals and private loans without losing my mind

Investor · Member since 2025 · 9 posts · 2 votes

I invest in a mix of fix-and-flips, rentals held in a few LLCs, and some private lending. Each one needs its books set up differently. Here's the setup that's worked for me, in case it helps anyone juggling more than one strategy.

1. One set of books per LLC. Keep each entity in its own file, with its own bank account and card. Mixing entities in one file is the fastest way to a messy tax season and a weaker liability shield.

2. Track every property separately. In Xero I use tracking categories (classes in QuickBooks), so each rental gets its own P&L. You can see which doors actually make money, not just the portfolio total.

3. Treat each flip as a job. Purchase, closing costs, rehab draws, holding costs and selling costs all get tagged to that project. When it sells, you know your real profit, and rehab costs end up in the property's basis instead of buried in expenses.

4. Lending needs its own schedule. Track every loan by principal, interest received, points and payoff date. Interest income and principal coming back look the same in the bank account, so a separate loan schedule keeps them straight.

5. A monthly 30-minute habit. Reconcile the bank accounts, attach receipts while you still remember what they were, and look at each property's P&L. It beats spending 20 hours hunting receipts in March.

What does everyone else use? Curious who's on Xero, QuickBooks, Stessa or plain spreadsheets, and what's working.

0Reply
362 views

8 Replies

Jump to latestLatest
  • Virtual Assistant · Remote · Member since 2020 · 122 posts · 49 votes
    6d

    Solid framework. The one place I see this break down on my company's client files is the money moving between the LLCs themselves. One LLC fronts the down payment for another's flip, or a rental covers a lending draw for a week, and it gets booked as income on one side and an expense on the other. Both P&Ls are now wrong and the tax returns inherit the mess.

    The fix is simple: every transfer between entities gets tagged as a due-to/due-from loan the moment it happens, even if it clears back next week. Reconcile those balances to zero monthly, right alongside the bank recs. If it never zeros out, that's money the IRS will ask about later.

    The other add I'd make to your monthly habit: scan for rehab costs that landed in repairs instead of basis. On flips that mistake goes straight to the tax return, and it's the most common one I find. Your five points cover the rest well.

    • Investor · Member since 2025 · 9 posts · 2 votes
      6d

      @Rachel Mazzanti Great adds, Rachel. Money moving between LLCs is the one I see trip people up the most, especially when one entity covers a deposit "just for a few days." Booking it as a loan right away and zeroing it out every month keeps both P&Ls honest. And yes on rehab costs. Setting up rehab categories that add to the property's cost from day one saves a lot of cleanup at tax time.

  • Diana KhanPro Member
    Attorney · 10451 Mill Run Cir #755 Owings Mills, MD 21117 · Member since 2024 · 634 posts · 222 votes
    6d
    Quote from @Amanda Taylor:

    I invest in a mix of fix-and-flips, rentals held in a few LLCs, and some private lending. Each one needs its books set up differently. Here's the setup that's worked for me, in case it helps anyone juggling more than one strategy.

    1. One set of books per LLC. Keep each entity in its own file, with its own bank account and card. Mixing entities in one file is the fastest way to a messy tax season and a weaker liability shield.

    2. Track every property separately. In Xero I use tracking categories (classes in QuickBooks), so each rental gets its own P&L. You can see which doors actually make money, not just the portfolio total.

    3. Treat each flip as a job. Purchase, closing costs, rehab draws, holding costs and selling costs all get tagged to that project. When it sells, you know your real profit, and rehab costs end up in the property's basis instead of buried in expenses.

    4. Lending needs its own schedule. Track every loan by principal, interest received, points and payoff date. Interest income and principal coming back look the same in the bank account, so a separate loan schedule keeps them straight.

    5. A monthly 30-minute habit. Reconcile the bank accounts, attach receipts while you still remember what they were, and look at each property's P&L. It beats spending 20 hours hunting receipts in March.

    What does everyone else use? Curious who's on Xero, QuickBooks, Stessa or plain spreadsheets, and what's working.

    @Amanda Taylor, I like how you've separated the bookkeeping for rentals, flips, and private loans. I'd also keep the loan agreements and payment records organized alongside the books, especially for private lending. Having clear repayment terms and knowing what happens if a borrower misses a payment can be just as important as tracking the numbers.

    I'm a real estate attorney and investor based in Maryland, and I work with clients on contracts, property ownership, and business matters. I've seen how helpful clear agreements and proper records can be when questions or disagreements come up. Good bookkeeping is important, but having the right documents to support those transactions matters too.

    I appreciate you sharing your approach, @Amanda Taylor. It's a helpful reminder that different investments need different systems. This connects with the real estate and contract work I do, and I'd be happy to stay connected!

    • Investor · Member since 2025 · 9 posts · 2 votes
      6d

      @Diana Khan Thanks, Diana. Agreed. On private loans, the paperwork is half the story, and the books are only as clean as the documents behind them. Happy to stay connected.

  • Investor · Fairfax Station, VA · Member since 2012 · 4 posts · 1 vote
    5d

    Solid setup. Two additions, because flips and private loans don't behave like rentals in the books.

    Flips are inventory, not rental property. Purchase, closing, rehab and holding costs (interest, taxes, insurance, utilities while you own it) build up in a balance-sheet account for that property and come out as cost of sales when it closes. Nothing gets depreciated, and the profit is ordinary income, often with self-employment tax depending on the entity. That's another reason to keep flips in a different LLC from the rentals: it keeps the dealer question away from what you hold long term.

    On the private loans, book interest as it accrues each month rather than when the payment arrives, so a borrower who falls behind shows up as a growing receivable instead of a quiet gap. Points and origination fees are income to you, and on longer loans may need to be spread over the term, so confirm the treatment with your CPA. If lending is a regular business for you and a borrower is an individual, ask whether you owe them a Form 1098 at year end.

    One month-end check that catches most errors across several LLCs: the due-to and due-from balances Rachel mentioned should match exactly between each pair of entities. If they don't, a transfer was booked on one side only.

  • Divin KanyamaBusiness Member
    Accountant · Seattle, WA · Member since 2025 · 546 posts · 232 votes
    5d

    @Amanda Taylor This is a strong framework, especially the separation by entity, property, project, and loan. The software matters less than maintaining that structure consistently and reconciling it regularly.

    I’d add a standardized chart of accounts across the LLCs, clear rules for shared expenses, and documented intercompany transfers so consolidated reporting does not become confusing. For flips, retaining settlement statements, invoices, draw records, and basis support by project is essential. For lending, I’d also track accrued interest, late fees, collateral, maturity dates, and modifications.

    Monthly review is the real advantage. A short, repeatable close process—reconcile, attach support, review exceptions, and compare each property or project with budget—creates cleaner decisions throughout the year and a much easier tax season.

  • Aaron ZimmermanBusiness Member
    Accountant · Chicago, IL · Member since 2018 · 2k+ posts · 1k+ votes
    5d

    Great framework! Love it . Simple, clean, and effective. Thanks for sharing the one on loans!

  • Member since 2026 · 3 posts · 0 votes
    1d

    My partner and I are building an app for exactly the problem flagged above: when one of your LLCs fronts cash to another, it posts on both sides at once, so the books between entities always agree. It's not public yet, but here's the manual version in the meantime. Book every transfer in both LLCs the same day ("due from" in the lender, "due to" in the borrower), then check once a month that the two balances match.

    How do you handle those balances now: settle at year end, or let them ride?

Join the conversationCreate a free account to reply, vote on answers and follow this thread.