A three-balance reconciliation workpaper

A blank operational comparison with an exception log; not a state compliance form.

A blank operational comparison with an exception log; not a state compliance form. Use this as an operational working document. It is not a legal compliance form or an instruction on tax treatment.

Download the worksheet

The working checklist

AreaWhat to record or check
Account and cut-offIdentify one account, report date, and export time.
Adjusted bankStatement balance plus documented reconciling items.
Trust-book balanceAccount-specific ledger balance at the same cut-off.
Beneficiary totalComplete relevant owner/tenant ledger report total.
ComparisonBank minus books; books minus beneficiary total.
ExceptionsAmount, source, cause being investigated, owner, next action.

Make it useful to the next person

Record the prepared date, the account or project covered, the person responsible, and links to the source documents. If an item is unresolved, write the next action and assign an owner. Keep a copy of the original source when a record changes.

Do not let a blank cell disappear

A missing value is an open question, not an invitation to guess. Mark it as missing or awaiting confirmation, keep the related amount visible, and return to it during the next agreed review.

Discuss how to apply this to your records →

Keep the systems. Connect the books.

Let’s talk about your property software, QuickBooks and the financial reports your business needs.

Book a call
DaxSync

Discovery call

Let’s connect your software and books.

Choose a time to discuss your operational software, QuickBooks and the reports your team needs.

45 minutes · Video call

  • Your software and current accounting handoff
  • The records, differences and reports involved
  • The scope and next steps

No documents needed to get started.

Appointments use our shared Daxable calendar. Your inquiry is for DaxSync.

Loading available times…

Having trouble? Open the calendar in a new tab ↗