How to do month-end close for a small property management company?
By the Propfina team · Last updated
Month-end close for a small property-management company is posting every rent deposit and short-term payout, reconciling the trust bank, tying the three-way rec and security deposits, taking management fees and owner draws, sending owner statements, tracking 1099s, and signing off. Do it in that order.
This is the monthly packet for an office of about 50 to 300 doors on AppFolio, Rentvine or Buildium, often with a few short-term listings and QuickBooks Online on the side. Pull last month’s bank statements, the deposit and payout reports, and the owner and tenant ledger exports.
Close in this order
Pick the bank-statement date first. Run every report to that date. The usual miss is a statement through the 30th and an owner-ledger export generated on the 2nd.
| Step | Done when |
|---|---|
| 1. Post deposits and payouts | Every rent batch and every Airbnb or Vrbo payout equals the bank lump |
| 2. Bank rec | Trust bank and operating rec to $0.00 |
| 3. Three-way trust rec | Adjusted bank, trust ledger, and sum of owner and tenant ledgers agree |
| 4. Security deposits tied out | Deposit cash equals deposit liability, same cutoff |
| 5. Management fees and owner draws | Fees left trust; no negative owner got a draw |
| 6. Owner statements | Each packet’s ending balance equals that owner’s ledger |
| 7. 1099 tracking | W-9s on file; year-to-date vendor totals noted |
| 8. Sign-off | Packet filed: statement, outstanding list, three reports, $0.00, signature |
How to do bookkeeping for a small property management company is the daily cycle. This page is the close.
Post deposits and payouts
Do this before you open the rec. Cash sitting in undeposited or unapplied is the usual hole in the three-way.
| Transaction | Where the cash goes | What the ledger does |
|---|---|---|
| Rent deposit | Trust bank | Raises that owner’s balance. The batch has to equal the bank lump |
| NSF / reversed ACH | Trust bank, reversed | Reverses the owner ledger |
| Security deposit | Trust or a separate deposit account | Liability. Not income |
| Airbnb or Vrbo payout | Trust or operating, per the management agreement | Split rent, cleaning, host fee and tax |
| Vendor bill for a door | Trust bank, from that owner’s funds | Lowers that owner’s ledger. Attach the invoice |
How to reconcile Airbnb payouts in QuickBooks Online is the split if those listings land in QuickBooks. Same-day posting keeps tenant ledgers current. Buildium (January 11, 2026) puts that posting, and a monthly three-way rec, on its checklist. Rentvine (read 2026-10-09) writes month-end as rec the trust, post fees, then pay vendors and owners.
Bank rec, then the three-way
A two-way rec matches the bank to the books. It is not the close. Finish the trust bank and the operating account until the difference is $0.00. A connected bank feed is not a rec.
How to reconcile a property management trust account in QuickBooks Online is the click path if the CPA’s trust bank lives there. Do not add an adjusting entry to force it closed. Then run the three-way on the same cutoff. How to do a three-way trust account reconciliation is that packet.
AppFolio (June 16, 2026) calls this a Triple Tie Out of owners, banks, and the general ledger, and says to rec it monthly, 100 percent of the time. A NARPM conference presentation (Mumford, hosted on narpm.org) writes it as bank statement = check register = client ledgers, with no negative ledgers.
Security deposits, fees, and draws
Security-deposit cash has to equal security-deposit liability on the same cutoff. If your state wants deposits in their own trust account, that account gets its own rec. IRS Topic 414 (read 2026-10-09) says not to include a security deposit in income if you may have to return it. If you keep part at move-out, that amount is income in that year. State holding rules still apply. This is not tax advice. Check your CPA.
Take the management fee before the owner draw. Move it to operating. Rent that stays in trust is owner funds, not company sales.
Do not send an owner draw while that owner’s ledger is negative. Cash in the trust account can still belong to other owners and tenants. Buildium’s January 2026 checklist says a negative owner ledger before a draw means you are using other owners’ funds. Colorado’s Division of Real Estate lists negative ledger balances among common violations (audit process, read 2026-10-09).
On r/PropertyManagement in December 2024, offices paid owners on the 10th, between the 11th and the 14th, or at month-end after expenses. The rec still has to close first. Paying an owner from uncleared rent, then taking an NSF, shorts the other owners.
Owner statements and 1099s
Owner statements go out after the rec, not instead of it. AppFolio, Rentvine and Buildium win this job. They keep owner and tenant ledgers in the same system as the bank rec. On their own books, the statement is a report, not a rebuild.
How to create owner statements for property management in QuickBooks is the rebuild if QuickBooks is the only ledger. Do not retype the PM-software statement into QuickBooks. Post the management fee. Leave the owner packet in the ledgers.
On r/PptyMgmtSoftware in February 2026, an office of about 45 doors on AppFolio wrote that custom Excel owner reports ate a full weekend, 12-plus hours. Extra tabs are a second set of numbers.
For 2026 vendor payments, the IRS 1099-NEC threshold (read 2026-10-09) is $2,000, up from $600 for payments made before 2026. Track W-9s during the year. Filing is still on you or your CPA. AppFolio (June 16, 2026) lists 1099s as one of four accounting KPIs.
When the lists still disagree
Work bank-to-ledger first, then ledger-to-owners.
| Symptom | Likely cause | What to do |
|---|---|---|
| Trust bank higher than the ledgers | Unapplied receipt, or a fee never allocated | Find cash sitting in undeposited or unapplied |
| Ledgers higher than the bank | Owner credit without cash, or a cutoff mismatch | Re-export ledgers to the statement date |
| QuickBooks income is far higher than the management fee | Rent posted as sales | Reverse it. Rent is a liability until it is the owner’s |
| One owner is negative, cash is still in trust | Bills paid before rent posted, or rent applied to the wrong door | Hold that owner’s draw; fix the allocation |
| Bank rec closes, owner statements still wrong | Two-way rec only | Sum the owner and tenant ledgers |
On r/PropertyManagement in September 2025, one office heading into a real-estate-commission audit wrote that the trust account had never reconciled to the bank, and several properties showed negative balances they could not verify. Close totals are not a rec.
What the software already does
AppFolio, Rentvine and Buildium win owner ledgers, the three-way rec and owner statements. QuickBooks Online wins the two-way rec and the corporate file.
| Job | AppFolio, Rentvine or Buildium | QuickBooks Online | Spreadsheet |
|---|---|---|---|
| Two-way bank rec | Yes | Yes, native | Yes, by hand |
| Three-way trust rec | Yes, in the PM software | No. Bank vs register only | By hand |
| Owner statements from the same numbers | Yes | No. Export and rebuild | If you rebuild them |
| Blocks a negative owner draw | Visible on the owner balance report | No | Only if you look |
| Company P&L the CPA already opens | Extra, or a summary journal | Yes, that is the product | Fragile |
Someone still has to pick the cutoff, refuse a negative draw, and keep rent off the company’s income line.
Rules vary by state. Colorado expects monthly three-way recs and the signed packet (audit process, read 2026-10-09). California Commissioner’s Regulation 2831.2 requires a monthly reconciliation of beneficiary records to the control record in months with activity. Texas requires a monthly accounting of trust money when the account had activity. This is not legal advice. Check your own state’s commission and your CPA.
How to tell this month is closed
Adjusted bank, trust ledger, and the sum of owner and tenant ledgers agree to the cent. No owner ledger is negative. Security-deposit cash equals deposit liability. Management fees left trust and landed in operating. Rent did not land in company income. Owner statements were built from those ledgers. The packet is signed.
Set the cutoff to the trust-account statement date. Export the deposit and payout reports, the owner and tenant ledgers, and last month’s signed rec to that same date. Start posting and reconciling from those files. The statements wait until the difference is $0.00.
Frequently asked questions
When is a property-management month actually closed?
When the adjusted bank, the trust ledger, and the sum of every owner and tenant ledger agree to the cent on the same cutoff, no owner ledger is negative, management fees left trust for operating, owner statements were built from those ledgers, and someone signed the packet. A bank rec that still has a plug is not a close.
Can I send owner statements before the three-way rec is done?
No. If the bank, the trust ledger, and the sum of owner and tenant ledgers disagree, the statement is someone else's money with a name on it. Close the three-way rec, hold any negative owner, then build the packet from those same ledgers.
Do I still need QuickBooks if AppFolio already produces owner statements?
For the doors, no. AppFolio, Rentvine and Buildium already hold owner ledgers, the trust rec and owner statements. QuickBooks Online is the company file most CPAs already open: payroll, operating expenses and tax. Post the management-fee transfer into QuickBooks, not every rent receipt.
How often do I have to reconcile a property-management trust account?
It depends on the state. Colorado expects a monthly three-way rec for property-management trust accounts. California requires a monthly reconciliation of beneficiary records to the control record in months with activity. Texas requires a monthly accounting when the account had activity. Check your own state's commission and your CPA.