Bookkeeping Template: Templates and Setup
A bookkeeping template should match the record you need: a cash register for payments, a journal for double-entry lines, or a checklist for recurring reviews.
Income: public sample
Fields from the original workbook. Filled rows are fictional examples; blank fields are for your records.
Reporting amounts use USD in this worked example. Dates use YYYY-MM-DD.
| Date | Reference | Company | Payer | Entry type | Amount | Account | Source | Signed income |
|---|---|---|---|---|---|---|---|---|
| 2026-01-05 | IN001 | A | Fictional client | Income | 500 | Checking | INV001 | Calculated in workbook |
On this page6
Choose the recordkeeping task first. A cash list, a balanced journal and a month-end checklist solve different problems. The shared pack includes each without pretending that one file is a complete accounting system. Open the worked copy, compare its fields to the job you have, and use the matching blank version after checking its limits.
Choose your bookkeeping template
| Need | Pack tab | What it does not do |
|---|---|---|
| Track paid costs | Transactions | Determine tax deductions |
| Compare received money and paid costs | Income and Cash Movement | Produce accrual profit |
| Record debit and credit lines | Journal | Choose the right accounts |
| Assign weekly and monthly checks | Review Checklist | Schedule reminders automatically |
Scroll for more →
Pick one source record for each event. Copying a cost into several tabs without clear links can create conflicting totals. A summary should point back to the original entry, not become another unmarked copy of it.
Inspect the sample before entering records
The fictional month includes a purchase, a refund, a second company and a cost outside the month. Those cases show why a simple grand total may answer the wrong question. Check the dates and selected company before comparing the result to your own records.
Keep the original blank copy. Save a working version with a clear company and period in the filename. Share it only with the people who need it. Sheet protection can limit accidental edits; it does not secure confidential business information.
Choose a platform and review process
Excel suits a local file workflow. Google Sheets can hold an imported private copy when browser sharing fits your process. Recheck formulas and access after import. CSV moves rows between tools but drops the workbook's tabs and formulas.
Use the dedicated Excel, Sheets and print guides for the exact setup steps. If your problem is missing receipts or unclear ownership, changing apps alone will not fix it. Assign a reviewer and retain source references from the start.
FAQ: choosing a file
Is one file enough for every task?
A shared pack can hold several related records, but the tabs still have distinct purposes. A payment list does not replace an approval form or a balanced journal. Use the tab that matches the event and retain the source reference. Expand the process only when you know what additional record you need.
Can I edit the categories?
Yes. Use labels that help you review your own business costs. Keep a short definition for each label and apply it consistently. Renaming a category does not change tax treatment. Check older rows and summary criteria when you alter a label, so one category does not split across old and new names.
Is the worked file real business data?
No. Its entries are fictional examples chosen to show the calculations and their boundaries. Replace them in a separate working copy. Keep the example available when checking formulas, since its expected totals give you a repeatable reference after an import, a range extension or a change to the summary.
Can I print the records?
The pack includes A4 and US Letter forms for a cash log, journal, claim and month-end review. Their totals are manual. Print the relevant form rather than shrinking every workbook tab onto one sheet. Keep page numbers and the reporting period visible if the record spans more than one page.
Sources and checks
Checked 15 October 2026. The examples are fictional and the arithmetic is original.
- IRS records: Business recordkeeping and supporting documents.
- Excel SUMIFS: Official multiple-criteria sum syntax.
- Sheets SUMIFS: Official Sheets multiple-criteria sum syntax.
- IRS books: Publication 583, December 2024 edition, Recordkeeping System section.
Related records and guides
Verdict on choosing a bookkeeping template
Choose the bookkeeping template by the job it must perform. Begin with the simplest record that captures the event and its evidence, then use the matching platform guide to keep the file usable.
Keep the worked file beside your records
Compare the fictional example with the blank fields before starting.