Owner Statement Integrity: Why Your PMS Reports Don't Tie to Your GL, and the Monthly Tie-Out That Fixes It

Updated for 2026, Owner-statement integrity now depends on whether the firm has allowed any agent to post journal entries between the PMS and GL. The tie-out workpaper still bridges the two systems; the control narrative needs the language in our AI trust accounting controls for property management before any agent activity is acceptable upstream of an owner statement. We have audited the owner-statement and general-ledger relationship across mid-market property management firms running every major property management system against every common general ledger pairing, Yardi or AppFolio with NetSuite, Buildium or AppFolio with Sage Intacct, Entrata with both, and the consistent finding is that the owner statement and the GL almost never tie cleanly without a monthly tie-out workpaper bridging them. The mismatch is structural: the property management system is built around property-level cash basis reporting that owners can read, and the general ledger is built around accrual-basis financial statements that the firm's auditor can validate. The two systems are doing different jobs against the same underlying transactions, and the gaps between them have to be reconciled monthly or they accumulate into disputes the firm cannot explain a year later. The pattern across the firms we have engaged with is that the controller treats the property management system's owner statement report as authoritative for owner-facing communication and treats the general ledger as authoritative for the firm's financial statements, and the two never get reconciled because they appear to "do different things." The appearance is misleading. They report on the same money. When the GL shows an aggregate management fee revenue number that is materially different from the sum of individual property-level fee accruals on the owner statements, the difference is either a legitimate timing or methodology gap that the firm should be able to articulate, or it is an error that will eventually surface either at year-end audit or in an owner dispute. The discipline that holds is a monthly tie-out workpaper that reconciles the property management system's trial balance and revenue summary to the corresponding GL accounts at the firm level, identifies every reconciling item, attributes it to a known cause, and documents the resolution or the carry-forward. This guide describes the workpaper structure we install on engagements where the firm has reached the scale at which manual reconciliation by tribal knowledge no longer holds. The framing builds on the close discipline described in the mid-market 10-day close reference calendar and the systems-integration discipline described in the finance transformation piece. The integration architecture is the source of most of the gaps The property management system and the general ledger almost never share a single source of truth in real time. The integration is typically a batch posting from the PMS to the GL, daily, weekly, or monthly, that summarizes property-level activity into journal entries the GL can consume. The summarization is where most of the structural gaps originate. The PMS records cash receipts at the property level and the tenant level; the GL receives a summarized journal entry that aggregates those receipts into a single line per income category. When the summary mapping is wrong, missing, or out of sync with the chart of accounts, the GL diverges from the PMS in ways that are not visible without an explicit reconciliation. The firms we have audited where the integration runs cleanly do so because they treat the integration mapping as a managed artifact, documented, version-controlled, reviewed at every chart-of-accounts change, and reconciled monthly. The firms where the integration is opaque almost universally have a "set it once at implementation and forget it" history, which means the mapping reflects the chart of accounts that existed at go-live rather than the chart of accounts in use today. Every chart-of-accounts change since implementation has either been reflected in the mapping or quietly dropped on the floor. The mapping document is the artifact that survives staff turnover. A current, version-controlled mapping document lists every PMS account, every corresponding GL account, the posting frequency, the summarization rules, and any conditional logic (for example, "post to property-specific GL when property code matches X, otherwise post to consolidated"). The document is owned by the controller and reviewed quarterly. We have seen firms where the mapping was understood only by the bookkeeper who left two years ago, and the controller's reconstruction of the logic took longer than rebuilding the integration from scratch. Chart-of-accounts changes are the single largest cause of recurring tie-out breaks. The PMS chart of accounts and the GL chart of accounts are typically maintained by different teams, and a change to either side that is not reflected on the other produces an immediate gap. The discipline is that any chart-of-accounts change has to flow through both systems and the integration mapping at the same time, with sign-off from the controller and a confirming tie-out the following month. Cross-link to the PM software selection guide for the procurement-time decisions that affect how easy this is. The monthly tie-out workpaper has a fixed structure The workpaper that holds across engagements has a fixed structure: a top-line reconciliation summary, a per-account detail section, a reconciling items schedule with documented causes, and a sign-off section. The top line shows the PMS total for each major category, rental income, operating expenses by class, security deposits held, management fees billed, and the corresponding GL balance for the same period. The per-account section shows the tie-out for each major chart-of-accounts node, with the reconciling items broken out and traceable to the underlying causes. The reconciling items fall into a small number of recurring categories that the workpaper labels explicitly: chart-of-accounts mapping differences, timing differences (the PMS recognized in one period and the GL in another, or vice versa), accrual-versus-cash methodology differences, security deposit exclusions, management fee accrual policy differences, and unbilled-receivables timing. Every reconciling item is attributed to one of those categories, the dollar impact is quantified, and the workpaper includes a brief description of the cause and the resolution path. Timing differences are normal but have to be documented. Cash received on the last business day of the month and posted to the PMS at the close cycle but cleared by the bank on the first day of the next month is a normal timing difference. The workpaper documents it, ages it, and resolves it in the following period. The pattern that breaks is when timing differences accumulate without resolution, and a year-old "timing" item in the schedule turns out to be a posted journal entry that nobody actually cleared. The sign-off block is non-negotiable. The workpaper carries the preparer's signature, the controller's signature, and the date of completion. The signatures are what make the workpaper an evidence artifact rather than a working document. We have seen workpapers that were technically complete but unsigned, and the auditor or owner-side accountant treated them as drafts on which no one had committed. Signed workpapers close conversations; unsigned workpapers prolong them. Security deposits are the most-misunderstood reconciling item The structural gap between the PMS and the GL on security deposits is consistent across every system pairing we have audited. The PMS records the deposit as a liability owed to the tenant and segregates it on the property-level statement; the GL records the deposit either as a liability in the firm's books (when the deposits are commingled in a single trust account) or excludes it entirely (when the deposits are held outside the firm's GL in a dedicated trust account that the firm administers but does not own). The two treatments produce dramatically different reconciliation profiles, and the firm has to be explicit about which treatment applies to which property. The workpaper section on security deposits identifies the deposit holding methodology per property, operating account, dedicated trust, separate per-property escrow, and reconciles the PMS balance to the corresponding GL position or trust account balance. When the deposit is held outside the GL, the reconciling item is the full deposit balance and the workpaper has to demonstrate that the deposit is held in the named trust account and reconciles to the bank statement for that account. The cross-reference to the trust accounting reconciliation guide is direct; the trust account reconciliation produces the inputs the owner statement tie-out consumes. Interest credited to tenant deposits is its own reconciling item. When state law requires interest to be credited to tenant deposits, the interest accrual is recorded in the PMS at the property level and the GL records the corresponding interest expense or interest liability adjustment. The two have to tie monthly, and any divergence has to be attributed and resolved. Disposition entries at lease termination produce reconciling activity. When a deposit is partially returned with deductions, the PMS records the return, the deductions, and the property-level repair income; the GL records the cash disbursement, the deduction credits to repair income, and any cleared liability. The timing of those entries can diverge by a few days, and the workpaper has to capture the in-flight transactions cleanly. Prepaid rent and unearned income create accrual-basis complications Tenants who pay rent in advance, first-of-month payments received in the prior month, annual rent paid for a full year up front, percentage rent estimates paid quarterly against an annual reconciliation, produce a divergence between the PMS's cash-basis recording and the GL's accrual-basis treatment. The PMS records the cash receipt against the tenant's account when received; the GL has to defer the revenue to the period in which it is earned and recognize it ratably or against the appropriate trigger. The reconciling item is the unearned income balance. The workpaper shows the prepaid rent balance per the PMS, typically the sum of credit balances on tenant ledgers as of month-end, and the corresponding GL liability for unearned rent. The two have to tie, with reconciling items attributed to known timing differences (rent paid by ACH at month-end where the PMS has not yet received the file) or known methodology differences (the PMS treats free-rent periods differently than the GL accrues against straight-line rent). Straight-line rent under ASC 842 is a methodology difference that has to be documented. When the firm produces GAAP-compliant financials, lease income has to be recognized straight-line over the lease term regardless of the actual cash payment schedule. The PMS reports cash-basis. The difference, the straight-line adjustment, is a recurring reconciling item that has to be calculated monthly, posted to the GL, and reconciled to the schedule of leases. The schedule itself depends on accurate lease abstraction; cross-link to the lease abstraction guide for the upstream discipline. Free-rent periods produce a deferred rent liability under straight-line. A tenant in a six-month free-rent period at the start of a sixty-month lease is paying nothing in cash but accruing five-twelfths of the average monthly straight-line rent in the GL. The PMS shows zero billings; the GL shows accrued straight-line revenue and a deferred rent liability. The workpaper has to articulate this and reconcile the deferred rent liability schedule to the GL. Management fee accruals are the most-disputed line at the firm level Management fee accruals are the most-disputed line in our experience because the firm's revenue and the property's expense are the same dollars from different sides, and any inconsistency in timing or methodology shows up as a reconciliation gap that affects both the firm's financial statements and the owner statement. The pattern we see is that management fees are accrued in the PMS based on rent received (a cash-basis trigger), recorded in the GL based on the firm's revenue recognition policy (typically when earned, which may be when billed or when received depending on the methodology), and the two diverge in the routine course of business. The fix is a documented management fee accrual policy that defines the trigger, the rate, the timing, and the treatment of any owner-specific exceptions. The workpaper reconciles the PMS-side accrual to the GL revenue, and reconciling items are attributed to specific known causes, owner-specific rate exceptions, percentage-rent fees that lag the underlying tenant payment, leasing fees that follow a different cycle than recurring management fees. Owner-specific rate exceptions are documented in the management agreement file. When an owner has negotiated a rate that differs from the firm's standard rate, the exception is documented in the management agreement, captured in the PMS at the property level, and reflected in the GL accrual. The workpaper reconciles the rate-by-rate calculation; we have seen firms where owner-specific rates were maintained in spreadsheets outside the PMS and the system-calculated fee was overridden monthly without a documented audit trail. Leasing fees and renewal fees follow separate cycles. Leasing commissions and renewal fees are typically triggered by lease execution rather than by rent receipt, and the timing diverges from the recurring management fee cycle. The workpaper has to break these out as separate reconciling items rather than collapsing them into the management fee total. Unbilled CAM and operating expense pass-through is its own category Operating expense pass-throughs are billed to tenants on a periodic basis, monthly estimated billings, quarterly true-ups, annual reconciliations, and the relationship between the PMS-recorded billings and the GL-recorded recoverable expenses produces a recurring accrual that has to be reconciled monthly. The accrual represents the difference between what the firm has incurred in operating expenses (recorded in the GL as expenses) and what the firm has billed to tenants on a pass-through basis (recorded in the PMS as billings). The workpaper section on CAM and operating expense pass-through reconciles the unbilled recoverable expense balance, the amount the firm has incurred but not yet billed to tenants, to the corresponding GL accrual. The reconciling items are attributed to known causes: invoices received but not yet processed in the PMS, expense accruals posted to the GL ahead of vendor invoice receipt, billings issued in the PMS for expenses not yet recorded in the GL. Cross-link to the CAM reconciliation guide for the annual cycle that closes this accrual at year-end. The monthly accrual is the leading indicator of year-end true-up exposure. When the unbilled recoverable balance grows materially across a quarter, the firm has either under-billed estimated CAM (which produces a large catch-up at year-end) or has expense recognition that is not flowing through to tenant billings. The workpaper surfaces this as a trend, and the asset management team can adjust monthly billings to smooth the year-end true-up rather than producing a tenant invoice surprise. The owner statement itself is a derived artifact, not the source The owner statement that the firm sends to the property owner each month is a derived artifact built from the property management system's general ledger view of the property, the cash activity for the period, and the management fee accrual. The statement is what the owner reads, but the statement is not the source of truth; the source is the underlying transactional ledger and the firm's accrual policies. The discipline that produces credible owner statements is the discipline that ensures the underlying ledger ties cleanly to both the bank and the firm-level GL, and that the management fee calculation, the operating expense allocation, and the cash distribution are reproducible from documented policies rather than ad-hoc adjustments. The firms we have engaged with who deliver owner statements that withstand owner-side scrutiny do so because the statement is generated mechanically from a system whose inputs have already been reconciled. The statement is not edited after generation; if a number on the statement is wrong, the upstream input is wrong, and the fix happens upstream rather than as a manual override on the statement. The pattern we see at firms with chronic owner disputes is that statements are routinely edited after generation to "fix" issues the controller cannot resolve in time, and the edits accumulate without documentation until a sophisticated owner runs a multi-month tie-out and finds inconsistencies the firm cannot explain. The statement footnotes are the firm's defensive layer. Owner statements that include footnotes describing the management fee methodology, the operating expense allocation methodology, the security deposit treatment, and any non-recurring items consume more controller time to produce but produce dramatically fewer follow-up questions. The footnotes also serve as the firm's contemporaneous documentation of the methodology in effect for the period, which matters when a methodology change later in the year produces a comparison the owner questions. The cash distribution detail has to tie to the bank. The cash distribution shown on the owner statement has to match the actual disbursement that hit the owner's bank account, and any discrepancy, even by a single dollar in fees, produces an immediate inquiry. The pattern we see is that firms produce statements showing the gross distribution and net distribution but do not break out the wire fees, the holdback for upcoming expenses, or the management fee deduction at sufficient granularity. Owners who reconcile to their bank accounts notice every variance. What we recommend The mid-market property management firms we have audited where the PMS-to-GL relationship is genuinely under control share a small set of practices that any firm with multiple properties and a meaningful portfolio can implement within two close cycles. The investment shows up immediately as faster owner-statement turnaround, fewer owner disputes, and a year-end audit that consumes less time and produces fewer adjustments. First, install the monthly tie-out workpaper as a discipline with a fixed structure, signed by the preparer and the controller, and stored as part of the close binder. Second, document the integration mapping between the PMS and the GL as a version-controlled artifact, and require any chart-of-accounts change to flow through both systems and the mapping in the same close cycle. Third, treat security deposits as a distinct reconciling category with the trust account reconciliation as its source-of-truth. Fourth, document the management fee accrual policy and the owner-specific rate exceptions, and reconcile the firm-level accrual to the property-level fees monthly. Fifth, calculate the straight-line rent adjustment monthly under ASC 842 and reconcile the deferred rent liability schedule to the GL. Sixth, surface unbilled CAM and operating expense pass-through accruals as a leading indicator of year-end exposure, and use the trend to inform monthly tenant billing adjustments. The cost of installing this discipline is bounded, typically a one-time cleanup of the integration mapping, a one-time documentation of the accrual policy, and a one-time templating of the workpaper, followed by an ongoing monthly review that the controller absorbs into the existing close cycle. The payback shows up in the next owner dispute the firm avoids and the next year-end audit that closes without methodology adjustments. For the upstream lease discipline, see the lease abstraction guide. For the upstream trust account discipline, see the trust accounting checklist. For the broader close cadence this fits within, see the 10-day close calendar.