Property Management Bookkeeping: Rent Rolls, Security Deposits and Multi-Entity Books#
Property books go wrong in a few predictable places. Rent is collected into one bank account and spread across several owners. Security deposits are mixed in with income. Expenses for one building get paid from another building's account. Each of these is manageable on its own. Together they make a ledger where nobody can say what a single property earned last quarter.
This article sets out how the transactions should flow, what an offshore team can do inside your client's QuickBooks Online file, and which decisions stay with you.
How the transactions flow#
Rent receipts. Tenant rent usually arrives through a property management system, an online payment platform or a bank deposit. The deposit in the bank is often a batch: several tenants, fees and sometimes adjustments combined. The books need the underlying detail, not just the deposit total. The rent roll from the property system is the source for that detail.
The rent roll reconciliation. The rent roll lists each unit, tenant, scheduled rent, amount charged and amount received. We reconcile its totals to the ledger: rent income by property against the rent roll, and tenant receivables against the rent roll's outstanding balances. Differences go on a list for you, not into a plug entry.
Security deposits. A deposit is generally money the landlord holds for the tenant, so it is usually recorded as a liability rather than income. Whether it must be kept in a separate bank account, whether it earns interest and when it must be returned varies by jurisdiction and by lease. Those rules are for you and the client to confirm. We record deposits on the basis you tell us: a deposit liability by tenant or property, a matching bank balance where one exists, and deductions or refunds when a tenancy ends.
Multi-entity books. Many landlords hold each property in its own entity, or hold several properties in one and keep owners' money apart from the operating accounts. Each entity needs its own books, its own bank accounts and its own financial statements. Where one entity pays a cost for another, the cost goes on the correct entity's books with a balance between them, not into whichever account the cash happened to leave.
Owner contributions and distributions. Money the owners put in and take out is equity, not income or expense. These are recorded by owner and by entity, so the capital accounts agree with what the owners and your preparer expect.
A worked example (illustrative)#
All figures are illustrative round numbers.
A landlord owns two buildings, A and B, in separate entities. In one month the property system shows these receipts:
| Item | Building A | Building B |
|---|---|---|
| Rent collected | 8,000 | 5,000 |
| Security deposits collected | 1,000 | 0 |
| Platform fees charged | 100 | 50 |
The platform pays out to a single bank account: 8,000 + 5,000 + 1,000 - 150 = 13,850, which is the number the bank statement shows. A bookkeeper working only from the bank sees one deposit and records 13,850 as rent.
Done properly, Building A books rent income of 8,000 and a security deposit liability of 1,000. Building B books rent income of 5,000. Each building books its own platform fee as an expense. If Building B's bank account receives the whole payout, the 8,900 that belongs to Building A is recorded as an amount due between the entities until it is moved. The rent roll, split the same way, ties to the ledger line by line.
Why this work is hard to staff#
Security deposits are governed by state law, and the states differ, so the bookkeeping has to follow the property's state. Two examples. Under Florida Statutes s. 83.49 (current statute text), a landlord must hold a residential security deposit in a separate non-interest-bearing account, a separate interest-bearing account, or post a surety bond, give written notice within 30 days, and return the deposit within 15 days if no claim is made. Under New York General Obligations Law s. 7-103(1), deposits remain the depositor's money, are held in trust and are not to be mingled with the recipient's personal moneys. Rules and thresholds change; confirm the current position with the client's preparer.
For a multi-entity portfolio, this means deposits are tracked as liabilities by tenant, by property and by bank account, and a deposit sitting in the wrong entity's account is visible on the ledger. Which rule applies, and how a deposit must be held or returned, stays with the firm, the owner or the client's preparer; the bookkeeping records the data they need.
What can be handed to an offshore team#
Work we can carry out inside the file:
- Recording rent receipts and splitting batched deposits using the property system reports
- Reconciling the rent roll to the ledger each month
- Tracking security deposits as liabilities, with receipts, deductions and refunds recorded as you direct
- Coding expenses to the right property or entity, and tracking amounts owed between entities
- Recording owner contributions and distributions
- Bank, credit card and loan reconciliations for each entity
- Profit and loss by property and a written summary of adjustments
What stays with you#
- Tenant, owner and vendor communication
- Lease terms, rent increases and collections decisions
- Deciding how security deposits must be held and returned in the client's jurisdiction
- Entity structure, and how shared costs are divided between entities
- Depreciation methods, tax return preparation and filings, which we do not prepare
- Final review and sign-off
What to send#
- Access to the QuickBooks Online file for each entity
- Property management system reports each month: rent roll, tenant ledger or receivables, and deposit summary
- Payout and fee reports from any online rent platform
- Bank, card and loan statements for each entity
- Lease or deposit terms where deductions are being recorded
- A list of entities, properties, owners and the agreed method for shared costs
- Closing statements and loan statements for acquisitions or refinancings
What comes back#
- Rent roll reconciliation
- Profit and loss by property
- Multi-entity financial statements
- Bank, card and loan reconciliations for each entity
- A schedule of security deposits held, agreed to the ledger
- A written summary of adjustments, with open questions listed
Everything is done in the client's QuickBooks Online file and reviewed by a Chartered Accountant before it is returned to you.
Month-end review checks#
- Does rent income by property agree to the rent roll?
- Does tenant receivable agree to the rent roll's outstanding balances?
- Does the security deposit liability agree to the deposits listed in the property system, and to the bank balance where deposits are held separately?
- Is any deposit recorded as income? Is any refund missing?
- Are there expenses paid from one entity's account for another, and are they on the books as due between the entities?
- Do the amounts due between entities offset to zero when the entities are combined?
- Are owner contributions and distributions coded to equity, by owner?
- Are mortgage payments split between interest and principal as the loan statement shows?
- Do all bank, card and loan reconciliations agree to statements?
Frequently asked questions#
Can you work from a property management system's reports? Yes. We treat the system as the source for tenant detail and reconcile its totals to the ledger. We need the reports exported, or view access agreed with you.
Who decides how security deposits are treated? Your firm and the client do, based on the lease and local rules. We record on the basis you confirm and flag anything that looks inconsistent.
Do you file returns or handle property tax? No. We record and organise the figures for your preparer. Tax return preparation is not part of our work.
Can you start with a backlog? Yes. Past periods can be brought current first through cleanup, then maintained under monthly bookkeeping and reconciliation. See also the industries we support and the CPA firms page.
