Define the report population
Keep account identifiers, date filters and relevant closed records visible. Do not assume a plausible total is a complete export.
Check the export →PROPERTY-MANAGEMENT BOOKKEEPING
Bring the adjusted bank balance, trust books and beneficiary ledgers into the same view. DaxSync helps you keep the comparison—and the evidence behind it—clear.
Matching totals do not prove every underlying entry is correct. Keep the sources and exceptions with the comparison.
WHAT THREE-WAY RECONCILIATION MEANS
Three-way reconciliation compares the adjusted bank balance, the trust-book balance and the total of the relevant beneficiary ledgers for the same account and date. The account boundary and report population come first.
Walk through a supported example →A COMPARISON YOU CAN REPRODUCE
Keep account identifiers, date filters and relevant closed records visible. Do not assume a plausible total is a complete export.
Check the export →Save the bank statement and the reports actually reviewed, with export times and a version for later changes.
Assemble the packet →Separate observations from suspected causes. Record the supporting evidence, responsible person and next action.
Build the exception log →KEEP THE RECORDS BESIDE THE TOTALS
A blank operational worksheet for the comparison and its unresolved items. It is not a state compliance form.
Open the workpaper ↗REFERENCE DESK
FROM THE REFERENCE DESK
Test report filters, missing ledgers and control totals before comparing owner balances with the trust books. Includes an offsetting-error example.
Read the guide →FROM THE REFERENCE DESK
Build a monthly outstanding-check rollforward that separates cleared payments, unresolved items and authorized corrections for property-management books.
Read the guide →FROM THE REFERENCE DESK
Trace a fee batch from property detail to the trust payment and operating-bank receipt, without duplicating revenue or losing owner allocations.
Read the guide →CLARIFY THE SCOPE
Ten answers about report scope, differences and the work behind three-way reconciliation.
It compares the adjusted bank balance, the trust-book balance and the total of the relevant beneficiary ledgers for the same account and cut-off date. The report population and supporting adjustments must be defined before the comparison means anything.
See the three-balance example →A bank reconciliation compares the bank with the corresponding books. The third comparison adds the relevant owner, tenant or other beneficiary detail. Agreement between bank and books alone does not establish that the detailed ledgers are complete or correctly allocated.
Review the service scope →Start with the bank statement, supported reconciling items, trust-book report and relevant beneficiary detail. Save the report filters, account, cut-off date and export time. The specific report names depend on your system and the agreed account scope.
Prepare a consistent packet →Filters can leave out closed records or include the wrong account population. Offsetting omitted balances can leave the total unchanged. Check identifiers and record counts as well as the final number, and explain how property and owner records map together.
Check an owner-ledger export →Record the difference and the evidence needed to investigate it. A bank-to-book difference and a book-to-beneficiary difference can lead to different checks. Keep any proposed correction subject to the appropriate review; an unexplained balancing entry does not explain the records.
Build an exception log →No. Offsetting errors or entries assigned to the wrong beneficiary can still produce matching totals. Retain the source reports, review the ledger population and keep unresolved questions visible beside the comparison.
Open the workpaper →Keep a rollforward from the prior list through cleared, new and unresolved items, with payment references and supporting statements. If a payment is replaced, preserve the link to the original. The guide does not determine legal deadlines or authorize voids.
Review outstanding checks →Yes, within an agreed bookkeeping scope and using approved fee detail. A bridge connects the property-level allocation, the transfer and the operating-book record. It also checks whether income was already recognized, so one transfer is not counted twice.
Follow a management-fee transfer →Cleanup starts by locating the last supported comparison and the source records for the periods after it. The backlog, access limitations and current-month work are scoped together. Completion timing depends on the records available and the differences found.
Explore reconciliation cleanup →No. DaxSync provides bookkeeping and reconciliation support. State-specific legal requirements, entitlement to funds and regulatory interpretations are outside these operational guides. Your responsible professional confirms those requirements and any approval authority.
Understand DaxSync’s role →