Reconcile an owner distribution across three records

Reconcile an owner distribution by matching one approved payment across the property-software detail, the QuickBooks record and the bank withdrawal. Use the same distribution reference in all three places. A cleared bank payment confirms cash moved, but it does not prove the amount was approved for the correct owner, property and period.

This workflow controls the handoff between records. It does not determine distribution rights, trust-account requirements, taxable income or the accounting treatment of owner activity. Confirm the entities, agreements, bank account and accountant-approved system roles before recording the event.

Open a distribution authorization card

Give the proposed payment a stable reference such as OD-418-0930. Record:

• owner and property or portfolio identifiers;
• statement or reporting period;
• amount proposed and amount approved;
• approving person and approval date;
• property-software report or distribution reference;
• QuickBooks transaction reference;
• bank payment trace and settlement date; and
• any amount held back or left unresolved.

AppFolio’s current Owner Portal help describes property- and date-filtered reports, published statement packets, and export options. Actual features and permissions vary by account, so use the reports enabled for the property manager rather than assuming one universal export.

Compare the same event in three places

1. Property software: owner, property, period, approved distribution and the detail supporting it.
2. QuickBooks: the approved summary or transaction under the documented system-role map.
3. Bank: the payment that actually cleared, including date, amount and trace.

If property software owns the detailed owner ledger, QuickBooks may hold an approved summary. Keep the cross-reference instead of recreating every operational line without a defined accounting need. The bridge should prove how one distribution moved through the three layers.

Worked example: an $8,200 owner distribution

Illustrative example. Property software shows $8,200 approved for owner O-418 for the September reporting period. QuickBooks records one approved $8,200 owner-distribution summary using OD-418-0930. The bank shows an $8,200 ACH clearing on October 2.

Preserve the September approval date and October settlement date. The one-day or cross-month timing difference is not automatically an error. It should remain visible until the bank clears, then close against the same reference.

Separate approval, recording and payment

These actions may occur on different dates. Do not mark a proposed distribution paid merely because it appears on a statement draft. Do not create another distribution when the bank feed later downloads the cleared ACH if the approved payment is already recorded.

Intuit’s current reconciliation guidance describes comparing QuickBooks with the bank statement until the difference reaches zero. That zero confirms the cash comparison. The property-software layer is still needed to confirm which owner, property and reporting period the payment belongs to.

Investigate differences with a reason code

Use a short reason code rather than a plug:

• TIMING: approved or recorded before the bank settled;
• AMOUNT: bank payment differs from the approved distribution;
• OWNER: payee or owner reference does not agree;
• PROPERTY: supporting detail points to a different property;
• DUPLICATE: bank activity was added after an existing payment record; or
• MISSING: one of the three layers has no corresponding record.

Put unresolved items in the reconciliation exception log with an owner and review date. Use the system-role guide when it is unclear which system should hold the detail.

Close only after four checks

Confirm that the distribution was approved for the stated owner and period, the property-software amount agrees with the QuickBooks record, the bank payment cleared for the same amount and payee, and no duplicate was created from downloaded bank activity. Keep any mismatch open until evidence explains it.