Website preview · Online inquiries and booking are being connected.

DAXSYNC / RESOURCE

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 →

A matching total is the start. An explainable total is the goal.

Discuss your reconciliation