Rehabbers: how do you actually track rehab expenses during a project?

Question

Good morning — I've done a handful of rehabs, and the part that still trips me up isn't estimating the budget up front, it's tracking the actual spend once you have the keys in your hands. Receipts pile up, I split some costs with a partner, and by the end I'm rebuilding everything in a spreadsheet just to see whether I actually hit the budget.

Curious how everyone here handles it:

• What do you use to track expenses across a rehab — spreadsheets, QuickBooks, a dedicated app, a shoebox of receipts?
• How do you deal with receipts from the field (Home Depot runs, subs, materials)?
• If you flip with partners, how do you keep straight who paid for what and settle up at the end?
• What's the most annoying part of the whole process — and have you found anything that actually solves it?

Trying to tighten up my own system and figured a lot of you have better setups than my messy spreadsheet. Appreciate any war stories.

Cameron Best · Answer

I manage large construction projects for my day job, and the habit that transfers: track commitments, not receipts. Your budget doesn't die when a receipt posts, it dies when you say yes to the change order. Log the committed number the day you agree to it and receipts become reconciliation instead of discovery.

Setup that works for me: one card per project, budget lines in the spreadsheet match the scope lines in the GC contract, and a 20 minute reconcile every Friday against the card feed. Field receipts get photographed same day into a shared project folder, then tossed. For partner splits, settle from the ledger monthly, not from memory at the end.

Most annoying part is still subs who text you a price, start work, and invoice something else. Only fix I've found is a one line text back confirming the number before they start. That text has settled more disputes than any spreadsheet.

Dan V. · Answer

I'm both a CPA and a real estate flipper, so I've gone through this process quite a bit.

My workflow starts before I close. I build my underwriting model in a spreadsheet with the purchase price, financing, cash investment, rehab budget by category, timeline, holding costs, interest, closing costs, projected sale price, and expected profit.

Once I close, I stop tracking the budget in Excel and enter it into QuickBooks Online. From that point on, I track actual costs vs. budget in QBO. That gives me a real-time view of where the project stands instead of rebuilding everything at the end.

A few things that have made a big difference:

• Use dedicated bank and credit card accounts for each project whenever possible. Some of my clients even have separate accounts by LLC/project. It's a little more work upfront but makes reconciliation and reporting much easier.
• Use purchase orders for larger material purchases whenever practical. It helps tie the estimate to the actual bill.
• Always identify the property. If I write a check, I include the property address and purpose in the memo. If I receive emailed receipts (utilities, online orders, etc.), I either forward them to a dedicated folder or label them with the property name so I can find them later.
• Capture receipts immediately. Whether you use Google Drive, an email folder, or QBO's receipt feature isn't as important as having a consistent process. Waiting until month-end almost guarantees you'll miss something.

I also keep a standardized folder structure for every project. It typically includes:

• Acquisition – Purchase contract, closing statement, loan documents, title documents
• Rehab – Contractor invoices, estimates, change orders, permits, receipts
• Insurance – Policies, renewals, claims
• Property Taxes – Tax bills and payment confirmations
• Utilities – Electric, water, gas, internet, and other utility invoices
• Loan Draws – Draw requests, lender approvals, inspection reports, and funding records

If I'm working with partners or contractors who purchase materials, I ask them to follow the same process—save the receipt immediately and identify the property and what it was for. That makes reimbursements and partner settlements much cleaner.

One area I see people overlook is tracking contractor draws and loan draws. If you're paying a GC in installments, you should know at any point:

• Original contract amount
• Change orders
• Amount paid to date
• Remaining balance

The same goes for construction loans. I keep a separate draw schedule so I know what has been requested, approved, funded, and what remains available.

The biggest lesson I've learned is that the software isn't what keeps you organized—the process does. If you capture transactions as they happen, maintain organized documentation, and reconcile regularly, you always know where the project stands. If you wait until the flip is over, you're basically doing a forensic accounting project instead of managing the rehab.

Ashish Acharya · Answer

@Robert Baron, From a tax side, whatever tracking system you use, the thing that actually matters is categorizing costs correctly as you go, not just totaling them. Rehab spend generally has to be capitalized into the property's basis rather than deducted as a current expense, since a flip is treated as inventory, so every dollar spent on materials, subs, and Home Depot runs needs to be tracked by category and tied to the specific property, that's what determines your cost of goods sold and ultimately your taxable gain when you sell. A shoebox of receipts reconstructed at year-end usually means some of that basis gets lost or misclassified, which either overstates your profit or creates documentation problems if you're ever asked to substantiate it.

On the partner cost-splitting piece, that's worth being precise about too, if you're each covering separate expenses and settling up later, how that gets recorded matters for each partner's basis and share of the eventual gain, informal reimbursements between partners without a clear paper trail tend to create headaches at tax time trying to reconcile who actually put in what. Worth setting up a simple system where every expense is tagged by property and by who paid, even if you're using something as basic as a shared spreadsheet, consistency matters more than sophistication here. Happy to connect!

Marcus Auerbach · Answer

Very different approach here.

I used to do a lot of BRRRRs and my budget was always just a ball park number, because I'd typically expand the scope as we discover issues and generally tend to over-rehab. But that's by design; we rent to top tier tenants and I don't want to touch a house twice.

To manage liquidity I had a dedicated rehab account, checks and credit card. All invoices go to my bookkeeping service and they have accountant access to credit cards and bank accounts, so they can reconcile books after the fact.

The result is that I know after the project what I have spent, but I typically don't know during the project. I would not recommend that approach for everyone, because you don't have much budget visibility during the rehab, but it works for me, because my priority is a great property and not a great spreadsheet and I can live with the ambiguity.

Richard Golding · Answer

Original contract finish within a predictable range.

Eduardo Cavasotti · Answer

Robert, I would track 3 states, not just expenses: committed, paid, and documented. The budget blows up when a $3,800 floor quote is treated as unknown until the receipt shows up, so log the commitment the day you approve it, attach the receipt when paid, and settle partner splits monthly. Also separate repair, capital improvement, and holding cost as you go, because tax cleanup after the sale is where lazy rehab books get expensive.

Richard Golding · Answer

One thing that's helped me is separating every project into three buckets instead of just one rehab number:

Base construction cost

Risk allowance

Market volatility

Then every invoice gets assigned to one of those buckets.

It becomes much easier to see whether you're actually over budget or simply spending contingency the way it was intended.

I also reconcile contractor estimates against completed invoices so future budgets are based on actual historical costs instead of memory.

Marcus Boles · Answer

Hey Robert! I'm originally from Kansas City and then moved to Memphis to continue my real estate investing. But before I moved physically into the market, I found that connecting with local professionals in the area for each division (title company, agents, contractors, etc..)  made this investing strategy of Out of State Investing (Flips & BRRR) a lot smoother and profitable!

Also working with lender who require you to stick to your budget has really helped. I continue to do this in Memphis and other markets as well. I'm happy to help and share what I have learned along the way!

Jason Malabute · Answer

The mental shift that helps here is realizing a flip isn't a rental, it's inventory. Your purchase and rehab costs get capitalized and sit on the balance sheet as work-in-progress while the project is going, so they don't hit your P&L as you spend. They convert to cost of goods sold when the house actually sells, which is when the profit shows up. Because of that, rental-focused apps usually aren't the right fit and can make tracking work-in-progress a mess come tax time. You're better off with a double-entry system like QuickBooks where you can reconcile your bank activity and make sure nothing is missing or double-counted, and keeping it lean with fewer programs is a plus. Just keep in mind the right setup depends on how your business is structured, so it's worth confirming with your own CPA.

Vijay Friedman · Answer

@Robert BaronI've seen a lot of investors stick with a spreadsheet at first, then move to something like QuickBooks or a dedicated rehab tracker once the number of projects grows. The biggest help seems to be logging expenses as they happen instead of trying to catch up later. Curious to see what systems others are using too.

Rehabbers: how do you actually track rehab expenses during a project?

Most Popular Reply