What it is
Every audit has adjusting entries, reclassifications and passed adjustments. A single log that checks each entry balances and rolls them into the trial balance prevents transcription errors.
The workbook logs entry lines, flags entries that do not balance or use accounts missing from the trial balance, computes the adjusted trial balance for posted entries and shows the effect of passed entries and their size against materiality.
When to use it
- Tracking proposed entries during fieldwork.
- Preparing the summary of uncorrected misstatements.
- Final trial balance review.
What’s inside
- Entries tab with type, account, debit, credit and status
- TB impact tab with unadjusted, posted, passed and adjusted balances
- Pretax income effect and materiality comparison
- Legend tab
Standard cited
This template follows AU-C 450. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use. See AU-C 450 explained.
Questions
What is the difference between posted and passed?
Posted entries are booked by the client in the adjusted trial balance. Passed entries are not booked and go to the summary of uncorrected misstatements.
What sign convention does it use?
Debits are positive and credits are negative on the trial balance.
Related templates
- Summary of Uncorrected Misstatements (AU-C 450)
- Audit Results Evaluation and Basis for the Opinion Memo
- Trial Balance Template with Mapping (Excel)
- Lead Schedule Template (Excel)
Last updated 11/06/2026. All free templates.