Property Management Statement Reconciliation Template (15 Minutes a Month)
Your property management statement is not your system of record.
It is a PDF your property manager generated.
If you have to guess whether the numbers are real, you do not have “passive income.” You have a monthly mystery novel.
This post gives you a property management statement reconciliation template you can run in about 15 minutes per property, per month.
Statements are PDFs.
Portals are partial.
Spreadsheets break.
Your bank account does not care.
The PM statement is a story. Your bank account is the truth.
Most owners skim the statement for one number.
Net owner distribution.
Then they look for a matching deposit in the bank.
That is a start. It is also how you miss the stuff that quietly eats cash flow:
- A management fee that drifted from 10 percent to 11 percent
- A reserve holdback that keeps changing with no explanation
- A “maintenance coordination” fee that showed up three months ago and never left
- Invoices that exist on the statement but nowhere in your inbox
The fix is not becoming your property manager’s accountant.
The fix is a boring monthly check that catches the same 8 failure modes every time.
“I will reconcile it at tax time.” Sure you will.
The 8 checks that catch most issues
Print this and stick it next to the statement.
Or do it in the table template below.
1) Statement period matches reality. If the statement says April but you are missing March, the rest of the math is noise.
2) Beginning and ending balances make sense. A “balance forward” that never moves usually means you are looking at a summary, not the full owner ledger.
3) Gross collected rent is plausible. Compare to your rent roll. If scheduled rent is $1,450 and collected is $1,050, you need the story.
4) Vacancy and concessions have receipts. “Vacancy” is not an expense. It is a reason. Make them show the reason.
5) Management fee math is correct. If the contract says 10 percent, then 10 percent means 10 percent. Not “about 10.”
6) Repairs have invoices. Every repair line should have a matching invoice, vendor, and date. If it does not, it is not an expense. It is a rumor.
7) Reserve movement is explained. Reserves are the number one way statements and bank deposits stop matching. Track them explicitly.
8) Net owner distribution ties to the bank deposit, or you can explain the gap. A $0 gap is ideal. A explained gap is fine. An unexplained gap is where problems live.
One example, because this is always what happens:
Your statement shows net owner distribution of $1,842.
Your bank deposit is $1,742.
The missing $100 is a reserve top up. Fine. Log it. Move on.
If you cannot explain that $100 in 60 seconds, you are not reconciling. You are hoping.
The reconciliation template (copy and paste)
Use this table per property, per statement.
If you have multiple property managers, the format stays the same. Only the PDF changes.
| Check | Statement value | Bank or source of truth | Expected | Pass | Notes |
|---|---|---|---|---|---|
| Statement period | 2026 05 | PM email subject | 2026 05 | ☐ | |
| Gross rent collected | $1,450 | Lease rent | $1,450 | ☐ | |
| Management fee percent | 11% | Management agreement | 10% | ☐ | fee drift |
| Management fee dollars | $159.50 | Rent x contract percent | $145.00 | ☐ | math mismatch |
| Repairs total | $312.40 | Invoices folder | $312.40 | ☐ | missing invoice for HVAC |
| Reserve change | $100.00 | Reserve schedule | $100.00 | ☐ | reserve top up |
| Net owner distribution | $1,742.10 | Bank deposit | $1,742.10 | ☐ | ties out |
Two rules that make this actually work:
1) If a row fails, add one sentence in Notes that starts with “Because.”
2) If you cannot write the “Because” sentence, you do not have the document you need.
That is the whole reconciliation game.
The “send this to your PM” discrepancy email
Copy this when something does not tie out.
Subject: Owner statement reconciliation questions for May
Hi [PM name],
I reconciled the May owner statement for [Property nickname]. I have three items to confirm:
1) The management fee shows 11 percent. Our agreement is 10 percent. Can you confirm why the fee percent changed and which month it started
2) Repairs include an HVAC line for $187.40. Can you forward the invoice and vendor details
3) The statement shows a $100 reserve top up. Can you confirm the current reserve balance and the reserve policy for this property
Thanks. Once I have those, the statement will be fully reconciled.
Best,
[Your name]
Notice what is missing.
No anger. No threat. No drama.
Just math.
How DoorVault turns this into a 10 minute review
Templates are fine.
The problem is you still have to do the work.
DoorVault is built for the investor who uses property managers and still wants the numbers to be true.
Here is what changes when you run reconciliation through Knox Intelligence:
- Forward the statement. Every account gets a Knox email inbox. Forward the monthly statement email and attachments and Knox routes them to the right property.
- Any document works. Knox Document Intelligence handles 72 plus real estate document types, not only statements.
- Knox reads the line items. PM statement processing turns income, expenses, fees, and reserves into structured transactions you can review.
- You pick the speed. Trust Knox OFF means Knox proposes every change for approval. Trust Knox ON means routine items can apply instantly.
- Batch Review prevents pop up hell. Upload 30 PDFs. Review them on one page. Approve per field, per document, or all at once.
- Corrections stick. Fix a categorization once and the Knox Learning Loop remembers it for the next statement from that same property manager.
- The audit trail is built in. The Activity Log shows before and after, with one click revert on any field.
Then you zoom out.
Clean statements become clean reporting.
Per property P&L. Portfolio dashboard. Loans and equity tracking. Multi entity reporting. Schedule E exports your CPA can import.
That is why statement reconciliation matters. It is not about being right. It is about having numbers you can use.
Here are two related reads if you want the full owner side system:
- How to manage an out of state rental property with a property manager
- Rental property bank reconciliation: match PM disbursements to your bank account
FAQ: reserves, fee drift, missing invoices, multiple PMs
Do reserves mean my PM is stealing
No. Reserves are normal.
They are also the most common reason your statement and bank deposit do not match.
Track reserve adds and deductions as their own line, every month. If the reserve balance is a mystery, your cash flow is a mystery.
How do I catch fee drift early
Run one check every month:
Actual management fee dollars divided by collected rent.
If your contract is 10 percent and your actual is 10.7 percent, you do not have a rounding error. You have a conversation.
What if my PM does not send invoices
Make it a rule.
No invoice, no approval. You are the asset owner. You are allowed to require proof for expenses.
If you want the boring version: keep one folder per property where every invoice lands. Email forwarding is fine. Cloud sync is fine. The rule is that it exists.
What breaks when I have multiple property managers
The numbers are the same. The formats are different.
That is the scaling problem.
If each PM statement lives in a different portal and every property has a different chart of accounts, you become the integration layer.
That is also why DoorVault exists. One owner dashboard across every property and every PM.
Start with the free Starter tier.
https://doorvault.app
