How to see all your rental properties and LLCs in one report
When each property sits in its own LLC with its own bank account, the books stay clean but the big picture disappears. To get it back, run the same four reports on every LLC for the same dates and add them up: a profit and loss statement, a rent roll, a trailing twelve month (T12) statement and the Schedule E totals. Keep the chart of accounts identical across LLCs so the lines add up, and you can answer "how much did I make this month" in one step.
The problem with one set of books per LLC
Separate books are the right call for liability and for clean sales. They have a cost: to answer "how did I do this month" you open five ledgers, export five reports and add them in a spreadsheet. By the time it is done, it is the next month.
The fix is not to merge the books. It is to make every LLC's books look the same and then roll them up for reading only. The LLCs stay separate; the report does not.
The four reports that matter
| Report | Answers | Why across all LLCs |
|---|---|---|
| Profit and loss | What came in, what went out, what was left in a month or year | Shows which property carries the portfolio |
| Rent roll | Every unit, tenant, rent, lease end date and balance | Shows who is late and which leases end soon |
| T12 (trailing twelve months) | The last twelve full months, month by month | Smooths out seasons and shows trends |
| Schedule E totals | Income and each expense line, per property | Tax time becomes a copy job |
The IRS explains how rental income and expenses are reported, property by property, in the Instructions for Schedule E.
Three rules that make a roll-up work
- One chart of accounts for every LLC. If one LLC calls it "Repairs" and another "R and M", the total is wrong or takes an hour to fix.
- The same date range and the same method. Compare cash to cash or accrual to accrual, and use month end for all of them.
- Close every LLC before you read the total. A roll-up that includes an unreconciled bank account carries its errors upward.
Example a made-up owner has three LLCs for the month of March. Elm Street collected $9,600 of rent and spent $4,100. Oak Court collected $7,200 and spent $3,300. Pine Lane collected $5,400 and spent $2,900. The combined rent is $9,600 + $7,200 + $5,400 = $22,200. The combined expenses are $4,100 + $3,300 + $2,900 = $10,300. The combined result before mortgage principal and taxes is $22,200 - $10,300 = $11,900.
Questions worth asking across the whole portfolio
Once the numbers line up, the useful part is asking questions in plain words:
- How much did I make this month, and how does that compare to the same month last year?
- Who is late right now, how much do they owe, and for how many days?
- Which property had the highest repair spending in the last twelve months?
- Which leases end in the next 90 days?
- What is my total for each Schedule E line across all properties so far this year?
- Which LLC has the lowest cash balance compared with its next 30 days of bills?
A good answer names the properties, shows the dates it used and says which numbers are final (closed months) and which are still moving.
How DoorKeeping handles it
Each property in DoorKeeping has its own books, bank accounts and tenants, and you see them together on one screen. The profit and loss, rent roll, T12 and Schedule E reports run for one property or for all of them with the same date range, because every property uses the same chart of accounts.
Connect DoorKeeping to Claude or ChatGPT and ask the questions above as they come to mind. The answer comes from the live books, names each property and marks which months are closed. Reports are read-only. Anything that changes money or sends a legal notice waits for your one-tap approval. Rent and payments stay in your own bank accounts. DoorKeeping never holds your money and sends a payment only when you approve it. The price is $2 per unit a month, with every feature and every report included.
DoorKeeping gives no tax advice. Your tax preparer decides how each LLC is reported.
Sources
- IRS Instructions for Schedule E (Form 1040), read Oct 30, 2026
Questions
- What is a T12 for a rental property?
- A T12 is a trailing twelve month statement: income and expenses for each of the last twelve full months, shown side by side. Lenders and buyers ask for it, and it is useful to you for spotting trends.
- Can I combine several LLCs into one profit and loss?
- You can add their reports together for reading. Do not mix their bank accounts or books. Each LLC keeps its own records, and the combined view is only a report.
- How do I get Schedule E totals for several properties?
- Keep each property's books on the Schedule E expense lines all year, then run the totals for each property. Each rental gets its own column on the form.
- Can ChatGPT or Claude read my rental books?
- Only if your software connects to them. With a connection, you can ask questions in plain words and the answer is built from your own records.