
Free Excel spreadsheet
The workbook library
Trace differences, organize supporting records, and prepare focused accounting checks. Work through supplier adjustments, cutoff questions, and close-related exceptions.
1 published spreadsheet
A reconciliation needs two defined sources and a clear period. Keep timing items separate from corrections already recorded, and retain a reference for each adjustment. A zero difference is meaningful only when both sides include the right transactions.
Prepare source totals, transaction references, relevant dates, and the status of unresolved items. Do not force an unexplained amount into an adjustment just to make the result balance. These working documents do not replace your accounting system or professional review.