A real estate investor bookkeeping report, explained line by line

What is in a real estate investor bookkeeping report?

A real estate investor bookkeeping report has two parts. The first shows profit on every property, one row per deal. The second shows the month just closed: cash position, money in and out, active projects and contractor totals.

• Per-deal profit: one row for every project, sold or active.
• Month-end summary: the month just closed, on one page.

What does the per-deal profit report show?

It shows every project you own, sold or active, with its purchase cost, rehab, loan costs, holding costs, selling costs, net profit, return on cash and days held. Active projects show costs so far.

What stands out

• Project 4 lost $6,469. It sat 216 days, so holding costs reached $31,652. Time is the most expensive line on a flip.
• Rehab on Project 7 ran 31% over budget ($72,050 spent against $55,000). We flag overruns while the work is still going.
• Project 1 was the strongest sale at 35.0% return on cash in 135 days.
• Loan interest and points cost $166,917 across the 7 sold projects. That is 16% of the gap between buying and selling prices.

The losing project stays in the report, in red, with the reason next to it. In our experience, the flippers who know what every deal really made make better decisions on the next one.

How is net profit on a flip worked out in this report?

Net profit is the sale price minus the purchase cost, the rehab, the loan costs, the holding costs and the selling costs. Every cost counts; each sits on its own line so you can see which one moved.

• Purchase cost: what you paid for the property, plus the closing costs paid when buying.
• Rehab: every invoice and payment for the work on that property.
• Loan costs: the loan points, plus the lender's title insurance and deed of trust recording.
• Holding costs: loan interest, property tax, insurance and utilities.
• Selling costs: agent commission, escrow, transfer tax and staging.

Project 5, 4321 Mock Blvd, Roseville, worked through with its invented numbers:

What is return on cash on a flip, and why not return on the purchase price?

Return on cash is net profit divided by your own cash in the deal: the down payment plus the closing, loan and holding costs. The lender funds the rehab, so rehab money is not your cash.

On Project 5 the down payment was $38,200, the closing and loan costs were $7,156 and the holding costs were $14,894, so the owner's own cash in the deal was $60,250. The same $17,089 profit reads very differently against the two bases:

Return on cash measures what your own money earned. The lender's money is not counted as yours.

What does the month-end summary show?

The month-end summary shows four things: your cash position on the last day, every dollar in and out of checking that month, what is spent and owed on each active project, and contractor payments year to date.

• Cash position: checking, savings and the card balance on the last day of the month, the hard-money loans still owed, and what your other LLCs owe you.
• Money in and out: every dollar through checking that month, from the opening balance to the closing one.
• Active projects: what is spent and what is owed on each property still in work.
• 1099 contractors: what each contractor has been paid so far this year, ready for 1099 reporting.

What is the "what we need from you" list for?

It is the short list of items the bookkeeper could not settle alone: a transfer that might be personal, an invoice that has not arrived, a missing W-9. Three items, not thirty.

1. 1Tell us if the $850 transfer to Sample Credit Union on Sep 3, 2026 was for the business or personal.
2. 2Send the invoice for the $1,240 payment to Sample Plumbing LLC on Sep 21, 2026 (Project 8).
3. 3Send a W-9 from Demo Framing Crew. You will need it before you can file their 1099.

The report also lists the mix-ups caught during the year. In the sample, 4 personal charges ($1,203.70) were on the business card. We moved them out of the business books, so the profit numbers stay clean.

Whose numbers are these?

The numbers are invented. The format is the real report a client receives every month. Invented data lets the sample show a losing project and a rehab overrun, which a real client's report would not be shared to show.

Demo Flips LLC is a sample company. Its 10 projects, its contractors and Sample Credit Union are all invented, and the addresses use made-up street names in real Sacramento-area cities.

The same sample companies appear in every guide on this site, so one set of books sits behind every example. Demo Flips LLC holds the flips, Projects 1 to 10. Demo Wholesale LLC holds the wholesale deals, Deals 1 to 4. Demo Rentals LLC holds 2 rentals: Property 1 at 275 Demo St, Davis, and Property 2 at 1640 Test Way, Vacaville. All of their numbers are invented data.

This sample is the flip report. For Demo Wholesale LLC, wholesale real estate profit and loss shows what each deal made after its own costs and its marketing. For Demo Rentals LLC, the books are kept as the rental property bookkeeping guide sets out, and a rental property P&L shows each property's own income statement.