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.

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.

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.

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.

Jake Baker · Answer

@Robert Baron

For my flipping business, I prefer to use fewer software programs to streamline things. It's easy to get bogged down by too much software in today's world. A double-entry system (like QuickBooks) allows you to reconcile your bank statements, ensuring that no transactions are missing or duplicated.

Flips are tracked as inventory on the balance sheet. When they are sold, those accumulated expenses are journaled to the P&L as Cost of Goods Sold (COGS). Flips are not like rentals, where you deal with monthly cash flow and depreciation. A flip is an active business where your "product" is the house. If you use rental-centric software, you might find it difficult to track Work in Progress (WIP) correctly, which makes tax season a total mess.

Noah Wright · Answer

Wanting to know whether you hit the budget, and not just what you spent, is the right instinct. Plenty of people with more deals than a handful never get that far. If you finance the rehab, the draw budget can do a lot of that work for you. Fix-and-flip lenders that fund rehab commonly release it in draws against a line-item budget after an inspection. If your tracking sheet uses those exact line items, each draw request doubles as a mid-project reconciliation, and moving savings from one line to another becomes a change you asked for instead of a surprise at the end. A budget only tells you something if you keep spending against the same categories you set it up with. Are you financing the rehab portion or paying it out of pocket?

Josh Handler · Answer

Cameron's point about tracking commitments rather than receipts is the right answer, and I'll build on it from the contractor side, since I'm the one generating the paperwork that's annoying you. I run a construction company here in Memphis, so this is the view from the other end of the invoice.

The reason your spreadsheet becomes a reconstruction project at the end is usually structural rather than clerical. Your budget is organized by ROOM and your contractor's invoice is organized by TRADE, and neither of you is going to change. So every receipt needs a judgment call about where it belongs, and judgment calls at volume are what make the end of a job miserable.

The fix costs nothing and has to happen at one specific moment: require the bid to be structured in the same line items as your budget, BEFORE you award the job. At that moment you have all the leverage and it's a trivial ask. After award it's a favor. After the job starts it's impossible. Once the budget, the bid and your tracking share line names, tracking stops being categorization and becomes matching.

Two lines almost nobody creates that would fix most of what you're describing.

A DISCOVERED CONDITIONS line, funded at the start. Every surprise gets booked there rather than smeared across the trade lines. At the end you can then tell the difference between I estimated badly and the house had things wrong with it. Those are completely different problems with completely different fixes, and most people book both into one overrun number and learn nothing across three rehabs.

And a PUNCH LIST line with real money in it. The last ten percent of a job is where tracking collapses, because it's thirty small runs with no obvious home. A missing cover plate, two hinges, caulk, the blind that didn't fit. None of it belongs to a trade and all of it lands in miscellaneous. Give it a line at the start and you stop losing a couple thousand dollars a project into a bucket you can't analyze.

On the subs texting one price and invoicing another: real, and the confirmation text works. I'd add one thing to it. Have the text state what's EXCLUDED, not just the number. Most of those disputes aren't dishonesty, they're that the sub priced the work he imagined and invoiced the work he found, and the entire gap lives in what neither of you said out loud.

Last thing, since you're in Memphis: if you ever want a second read on a bid before you authorize it, or on a house before you buy it, send it over. Free, no obligation, and I'll tell you when a number looks light, which is the direction that actually costs you money.

Payment Info	Date	Payee	Amount	Type of Expense
Cashiers Check	12 Feb 25	Goldline Investments LLC	$7,500.00	Ernest Money Deposit
	14 Feb 25	Amazon	$18.38	Lockbox for keys
	23 Feb 25	Steadily	$729.34	House Insurance
Wire Transfer	28 Feb 25	Goldline Investments LLC	$194,988.12	Final Payment
	28 Feb 25	Jim Key Guy	$200.00	Rekey Locks
	28 Feb 25	NBU	$45.00	Water Hookup
	28 Feb 25	GVEC	$50.00	Electrical Hookup
	28 Feb 25	Lowes	$42.46	AC Filters
	2 Mar 25	Bobby Jo	$40.00	Mowing
	5 Mar 25	Bobby Jo	$100.00	Trash Removal
	6 Mar 25	Foundation Guy	$5,100.00	Foundation Repair
	10 Mar 25	Lowes	$16.69	Garage Door Hinges
	10 Mar 25	Lowes	$10.00	Small Bathroom Light
	11 Mar 25	Habitat for Humanity	$40.59	Bedroom Door, Light, Door Handle
	11 Mar 25	Home Depot	$166.53	Electrical Plates/Shower Hardware
	11 Mar 25	Home Depot	$29.18	Touch up Paint
	11 Mar 25	Lowes	$263.18	Closet Doors
	11 Mar 25	Lowes	$215.42	Toilet/Light Bulbs
	12 Mar 25	Lowes	$215.33	Mini Blinds
	12 Mar 25	Amazon	$67.10	Smoke Alarms
	12 Mar 25	Lowes	$28.90	Fan Switch/Wood Filler/Light Bulbs
	16 Mar 25	Diana	$180.00	Cleaning

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

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

Most Popular Reply

21 Replies