OWNER WORKFLOW GUIDE
How to Record Tenant Rent Payments (Rental Income) in QuickBooks for Commercial Properties
Learn how to record tenant rent payments in QuickBooks for commercial properties: setting up the Customer, Item, and income accounts, splitting base rent and CAM across invoice lines, and applying a partial payment so a shortfall stays traceable instead of turning into an unexplained AR balance.
Recording a tenant's rent payment in QuickBooks is mechanically simple: a Customer, an Item, and a Receive Payment screen. What actually matters for a commercial property is what happens when that one payment doesn't match the invoice — because a commercial tenant rarely pays exactly the invoiced total, and QuickBooks needs to be told, explicitly, what the difference means.
1. Set up the tenant, the rent item, and the income accounts it points to
In QuickBooks Online, a tenant is a Customer, and rent isn't just "money you deposit" — it's an Item on an invoice line, and that Item decides which income account the money actually posts to on your P&L. For a single-tenant residential landlord, one "Rent" item pointed at one income account is enough. For a commercial tenant paying base rent plus a CAM reimbursement, and occasionally a late fee, you need at least two Items — each mapped to its own income account — before you create the first invoice.
Set up "Base Rent" as a Service item pointed at a Base Rent (or Rental Income) account, and "CAM Reimbursement" as a separate Service item pointed at its own account. CAM reimbursement isn't the same income category as rent for reporting and CAM-reconciliation purposes, and keeping it on its own item and its own account is what lets you run a clean reconciliation later without re-sorting a year of invoice history line by line. Add a third item, "Late Fee," pointed at its own income account the same way.
- Customer = the tenant, not the property — a tenant leasing two suites is invoiced from one Customer record, not two
- One Item per income line: Base Rent, CAM Reimbursement, and Late Fee are three separate Items with three separate income accounts
- The Item, not the invoice, decides where a dollar lands — get the mapping right once and every future invoice inherits it automatically
- If a fee only applies occasionally (like late fees), give it its own item anyway; you want it separable even in the months it's zero
2. Build the invoice as separate lines, not one lump "Rent" charge
A commercial tenant's monthly invoice is rarely one number. On a realistic $4,650 invoice, run it as two lines — Base Rent at $4,000 and CAM Reimbursement at $650 — each using its own Item from step one, not a single "Rent" line for $4,650 with the split explained in a memo somewhere. In months a late fee applies, add a third line for it rather than folding it into the base rent amount. Line-level detail is what makes the difference later: QuickBooks tracks the invoice's open balance as a single number, but your P&L and any CAM reconciliation read from the underlying lines, not from that one total.
Property and tenant tracking (Class or Location, whichever your setup uses) is set once at the invoice header and applies to every line on it. Splitting revenue into two or three lines doesn't multiply that work — it only changes which income account each line posts to, not how the property itself is tagged.
- Base Rent — $4,000 → Base Rent item → Base Rent income account
- CAM Reimbursement — $650 → CAM Reimbursement item → its own income account, kept separate from base rent
- A late fee, when one applies, gets its own line and its own item — never folded into the base rent line, or you lose the ability to waive it without touching rent itself
- Invoice total: $4,650 — this is the single number the Receive Payment screen will show as the open balance, not $4,000 and $650 tracked separately
3. Receive the payment and route it through Undeposited Funds
Use Receive Payment, not a journal entry — a journal entry against Accounts Receivable never closes the invoice and won't show correctly against the tenant's balance. On the Receive Payment screen, select the tenant, select the open invoice, and leave "Deposit to" set to Undeposited Funds rather than the bank account directly, unless this single check is genuinely the entire contents of one bank deposit by itself.
Undeposited Funds exists because the bank rarely deposits one tenant's rent as its own line item. Three tenants' checks handed to the bank together, or several ACH payments batched by your processor, show up on the bank statement as one deposit — not three. Undeposited Funds holds each Receive Payment until you create a Bank Deposit that groups the ones that actually landed together, so that one bank line can be matched to the group instead of forcing a payment-by-payment match that doesn't exist in the real bank feed.
- Receive Payment against the open invoice — never a journal entry, and never a direct deposit-only edit to the bank register
- Deposit to: Undeposited Funds by default; direct-to-bank only when you're certain this one payment is the entire bank deposit
- When you build the Bank Deposit later, select every tenant payment that landed in the same physical deposit or ACH batch, not just this one tenant's
- Skipping Undeposited Funds works fine for a single check and breaks the first time two tenant payments arrive in one deposit
4. Apply a partial payment without guessing which line is short
Say the tenant owes the $4,650 invoice from step two but pays $4,300, withholding $350 because they're disputing a repair charge pending resolution. On the Receive Payment screen, select the $4,650 invoice and enter $4,300 in the Payment field. QuickBooks accepts an amount less than the open balance without complaint — it applies the full $4,300 against the invoice and automatically leaves $350 open. That part QuickBooks handles correctly on its own, with no special configuration.
What QuickBooks does not do is tell you which line the missing $350 belongs to. The invoice's open balance is tracked as one number at the invoice level — it is never decomposed back into "base rent paid in full, CAM $350 short." If that reason isn't written down at the moment you receive the payment, the $350 becomes an unexplained AR balance someone has to reconstruct from memory three months later. Use the Memo field on the Receive Payment transaction itself — internal, never shown to the tenant — to record the reason in the same transaction that created the shortfall.
- Enter $4,300 in Payment and leave the invoice as-is — don't edit the CAM line amount to try to force the numbers to match; that alters the actual invoice
- Don't apply a discount or credit to close the $350 at receiving time — the dispute isn't resolved yet, and writing it off early understates a real, still-open balance
- Use the Receive Payment memo, not the invoice message, to record why: "$350 withheld, disputed repair charge WO-1142, pending resolution" — it's the field permanently attached to this exact transaction
- If a work order or maintenance ticket is the reason for the dispute, note its number in that memo so the accounting record and the operational reason point at each other
5. Track and resolve the outstanding balance
The $350 sits on the tenant's Open Invoices and A/R Aging reports until it's resolved one of two ways: the tenant pays it once the dispute is settled — a second Receive Payment against the same invoice, for $350, following the same steps as above — or the dispute resolves in the tenant's favor and you issue a Credit Memo for $350 against the same item the disputed amount was tied to, closing the invoice without ever recording it as cash received. Which outcome applies is a lease and maintenance decision, not an accounting one; QuickBooks only needs to be told the result once it's decided.
Check the A/R Aging Detail or Customer Balance Detail report on a schedule, not just when a tenant calls about it. That report is the only place that shows how long a specific short-pay has actually been sitting open — a memo written six weeks ago only does its job if someone reads it before assuming the balance is a data-entry error and writing it off.
- Resolved in the tenant's favor: Credit Memo for $350 against the same item/account the disputed amount lived on, applied to the invoice
- Resolved against the tenant: a second Receive Payment for $350 once they pay, same invoice, same Undeposited Funds routing as step three
- Run A/R Aging Detail monthly — it's the only view that shows how long a specific short-pay has been open, not just that a balance exists
- Revisit any invoice with an open balance older than one billing cycle; an explained $350 gap left unresolved for a year reads the same on the books as an unexplained one
Frequently asked questions
Can QuickBooks automatically apply a partial payment to one invoice line instead of the whole invoice?
No. Receive Payment in QuickBooks Online applies against the invoice's total open balance, not against individual lines. A $350 shortfall on a $4,650 invoice is tracked as one open-balance number, not as "CAM: $350 short" — that distinction only exists if you write it down yourself, in the payment's memo.
Should base rent, CAM, and late fees be separate invoices instead of separate lines on one invoice?
Some property managers split them, usually so a late fee can be waived without touching the rent invoice. Either approach works as long as it's consistent tenant to tenant and month to month — what actually breaks your reporting is mixing both approaches across the same portfolio.
What if a tenant's check is for more than the invoice total?
Apply the invoiced amount to the invoice and let QuickBooks hold the overage as an open credit on the customer record rather than recording it as a separate, unexplained deposit. It's then available to apply automatically against next month's invoice.
Do I still need Undeposited Funds if the tenant pays by ACH directly into the bank?
Usually yes. Banks frequently batch several tenants' ACH payments into one deposit line that doesn't map one-to-one to a single Receive Payment. Depositing straight to the bank account can work for a single, unbatched payment, but it's the exception, not something to rely on by default.
USE THIS WITH ONE REAL PROPERTY
Stop rebuilding the operating record every month.
Start a 15-day trial, add one property, and bring the lease, rent, CAM, and tenant communication into the same workspace.