How to ask AI for a profit and loss across several rental LLCs
Ask for the profit and loss per property first, then the total, and ask the assistant to name which LLC each number belongs to. Questions across a whole portfolio only give right answers when each property has its own books. The traps are double counting a transfer between LLCs and mixing cash accounts. A good assistant lists what it included.
Why a portfolio question is harder than it looks
If each property sits in its own LLC, each has its own bank account, deposits held and income and expenses. That is good for liability and for clarity. It also means "how much did I make this month?" has several honest answers: per LLC, for all LLCs, with or without money you moved between them. The idea is explained in one LLC per property, separate books.
How to word the question
- Give the period: "March 1 to March 31".
- Ask for one row per property or LLC, then a total row.
- Say which basis: cash (money in and out) or accrual (earned and owed).
- Ask it to show income, operating expenses and net operating income, and to say what it excluded.
- Ask for transfers between your own accounts to be left out of income and expenses.
Example a made-up owner has two LLCs. LLC A takes in $9,000 of rent and spends $3,000 on operating costs, so it earns $6,000 before mortgage and tax. LLC B takes in $4,000 and spends $4,500, so it is $500 below zero. The total is $5,500, which is $6,000 minus $500. A good answer shows both rows and the total, and it does not hide LLC B's loss inside the sum.
Traps the assistant should avoid
| Trap | What goes wrong | Fix |
|---|---|---|
| Transfer between LLCs | Counted as income in one and expense in another | Exclude transfers between your own accounts |
| Deposits held | A tenant deposit counted as income | Deposits are a liability until you keep them |
| Mortgage payment | Whole payment counted as expense | Interest is an expense; principal is not |
| Mixed cash accounts | Two properties share one account, so the split is a guess | One bank account per LLC |
| Different periods | One property reported through March 31, another through March 15 | State the period for all |
IRS Publication 527 explains that mortgage principal is not a deductible rental expense, which is why a profit and loss should not subtract it.
How to verify the answer
- Pick one property and add its income and expense lines yourself.
- Check that the sum of the property rows equals the total row.
- Compare rent income to the deposits in that LLC's bank account.
- Ask what the assistant excluded and why.
How DoorKeeping handles it
Each DoorKeeping property has its own books, bank account and profit and loss, and you see every property together. Through the connector, one connection covers every portfolio you belong to. Your assistant can call a profit and loss, net operating income by property, an owner statement or a Schedule E report, and for anything not covered by a fixed report it can ask a question across your portfolio from a fixed set of read-only views, never free-form database queries. Those views leave out SSNs, birth dates, bank and card numbers, and tenant emails and phones. All of this reads. It does not post or pay anything. Rent and payments stay in your own bank accounts. DoorKeeping never holds your money and sends a payment only when you approve it.
Sources
- IRS Publication 527: Residential Rental Property, read Oct 30, 2026
- DoorKeeping: Connect Claude or ChatGPT (steps and tools list), read Oct 30, 2026
Questions
- Can ChatGPT combine profit and loss reports from several LLCs?
- Yes if you give it each report. Ask for one row per LLC and a total, with transfers between your accounts left out.
- Should I combine all my LLCs for taxes?
- That is a tax question for your preparer. A combined view helps you manage, but each LLC files according to its own tax treatment.
- Is a tenant deposit income?
- Not when you hold it for the tenant. It is a liability until it is applied to charges or returned.
- What does cash basis mean?
- Income is counted when money arrives and expenses when you pay, not when they were earned or billed.