Template Setup & Excel Help
Learn the recommended first steps after downloading a KanderBooks template: save a backup, create a working copy, review instructions, and enter data safely.
Best for: any customer opening a KanderBooks workbook for the first time.
Important: This guide covers general workbook setup. Individual templates may have their own instructions, formulas, tabs, and protected areas.
Start with these first steps
- Download the file to your computer rather than editing from a browser preview.
- Save a blank backup copy before adding your information.
- Create a working copy with the year, month, business name, or household name in the file name.
- Open the instructions, README, or setup tab first.
- Enter data only in input areas unless the template instructions say otherwise.
- Save frequently and keep final copies in an organized folder.
Recommended file naming
Use file names that make sense six months from now. Include the year, month if needed, template purpose, and business or household name.
2025 Monthly Bookkeeping Close - April - Business Name.xlsx 2025 Personal Tax Organizer - Household Name.xlsx 2025 Estimated Tax Planner - Business Name.xlsx
Understanding workbook tabs
| Section | Use it for |
|---|---|
| Instructions | Read this first for template-specific notes. |
| Setup | Enter business, household, year, month, or category information. |
| Input tabs | Type your records, amounts, dates, notes, and checklist items. |
| Summary tabs | Review totals, dashboards, or reports created from the input tabs. |
| Reference tabs | Use these for category lists, notes, or support information. |
Safe editing rules
- Do not delete hidden rows, formulas, or summary tabs unless you are comfortable repairing the workbook.
- Use copy and paste values when bringing in data from other systems.
- Keep one clean backup before making major edits.
- Use comments or notes for explanations instead of overwriting formulas.
FAQ
Why does Excel ask me to enable editing?
Files downloaded from the internet may open in protected view. Review the file source and enable editing only if you trust the file.
Can I change categories?
Usually yes, but use the template instructions. Some dashboard formulas may depend on category names or ranges.
What if I made a mistake?
Close without saving if you just made the mistake, or restore from your blank backup copy.
Can I use the template on my phone?
A desktop version of Excel is recommended. Mobile apps can make workbook editing harder.
Should I save as PDF?
Save an editable Excel copy for ongoing use and a PDF copy for sharing or archiving final results.
Was this tutorial helpful?
Your feedback helps improve the KanderBooks tutorial library.