Skip to content
The title slide and first slides of the Small Business Tax Organizer template

Small Business Tax Organizer

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Owners of small shops, studios and service firms use this small business tax organizer to hand an accountant one tidy file. The Months tab holds income, expenses and payroll cost for each month. The Assets tab lists equipment and larger purchases with vendor, use and receipt status. The Payroll tab records wages, withholding, employer taxes and deposits for each quarter. The Summary charts the months and shows what is left over.

Fill in the Months tab as soon as you close each month, not at year-end. Add equipment to the Assets tab when you buy it, and mark whether it is business-only or mixed use. If your payroll deposits do not match the figures on your quarterly filings, correct them now while the records are fresh.

Useful for

  • Give an accountant one year in a single file
  • Check what is left over month by month before tax time
  • Keep equipment purchases and receipts together

What's included

  • 5 tabs: Summary, Months, Assets, Payroll, How to use
  • Summary: a dashboard with 5 summary figures
  • Months: a table
  • Assets: a table
  • Payroll: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Months tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What records does a small business need for taxes?

Keep income records, proof of every expense, receipts for equipment, payroll records and bank statements. The IRS lists how long to keep each kind, so check its current guidance. This workbook gathers the totals and the asset list in one place.

How do I organize business taxes for my accountant?

Close each month, enter the totals, list new equipment as you buy it and fill the payroll figures every quarter. Then send the file with your bank statements. A clear monthly picture saves the accountant time.

Is payroll cost part of business expenses?

Wages and employer taxes are costs of running the business. The Months tab keeps them in their own column so you can see them apart from other expenses. Ask your accountant how to report them on your return.

  • #tax-tracker
  • #small-business-tax-organizer
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…