Template Setup & Excel Help
Use a simple review routine to compare template totals to source records, spot missing entries, and document assumptions.
Best for: customers who want confidence that a completed template agrees to their source records.
Important: A template can organize information, but it cannot guarantee that source data is complete or correct.
The three-part review
Did all expected records make it into the file?
Do entered amounts match source reports?
Do totals make sense compared to prior months or expectations?
Can someone else understand where the numbers came from?
Review checklist
- Compare template totals to source reports or accounting records.
- Check for duplicate rows, blank required fields, and old placeholder data.
- Look for negative numbers, unusually large changes, or amounts in the wrong category.
- Confirm date ranges match the period being reviewed.
- Save source documents in the same folder as the completed template.
- Write notes for assumptions, estimates, or unresolved questions.
What to do when totals do not match
- Check the date range. Many differences come from comparing different periods.
- Check filters. A hidden filter can make rows disappear.
- Check duplicates. Imported rows or manually entered totals can be counted twice.
- Check formulas. Compare against a blank copy if a formula may have been overwritten.
- Document unresolved differences. If you cannot fix it quickly, explain the difference and ask for help.
FAQ
Does matching the template mean everything is correct?
No. It means the template agrees to the sources you reviewed. Source records may still need professional review.
How much difference is acceptable?
That depends on the workflow and professional judgment. Do not ignore differences that affect decisions.
Should I delete old estimates?
Keep a note of what changed rather than erasing the story behind the number.
Can I send mismatched totals to my preparer?
Yes, if you clearly mark the issue and provide source documents.
What if formulas are broken?
Restore from backup or compare with a clean copy.
Was this tutorial helpful?
Your feedback helps improve the KanderBooks tutorial library.