Templates · Google Sheets

Business Expense Tracker

Log every business expense with its category, business-use % and a link to the receipt, and see your deductible total by category and month for the whole tax year.

Deductible worked out
Receipt links in one place
Category and month summary

Coming soon

Visit the Etsy shop

This template is on its way to our Etsy shop. Instant download when it's there.

Business Expense Tracker in Google Sheets on a laptop, shown with sample data

What's inside

Start HereYour welcome page: a 3-step setup checklist, how the tabs fit together, a guide to every tab with clickable links, and the color legend.
ExpensesYour expense log, with room for 2,000 rows. Type the date, vendor, category, description, amount and how you paid; add a business-use % for shared expenses and a link to the receipt. The deductible amount and month fill in.
SummaryYour tax year at a glance: every category by month with the year total, plus a table by payment method. Leave the year blank for the current tax year, or type a year to look back. Show the deductible amounts or the full amounts spent.
SettingsSet up once: your business name, the month your tax year starts, and your lists of expense categories and payment methods.

A closer look

Log every expense: Date, vendor, category, amount, business use and a receipt link. (Expense Tracker, sample data)

Deductible worked out for you: Amount times business use, for every expense. (Expense Tracker, sample data)

See the whole tax year: Every category by month, with the year total. (Expense Tracker, sample data)

By payment method: See what went on which card, account or cash. (Expense Tracker, sample data)

Your categories and payment methods: Set them once; every dropdown and total follows. (Expense Tracker, sample data)

Screenshots show the Sample copy with made-up data.

Get set up in minutes

Open your copy's Start Here tab.
Settings: your business name, tax-year start, categories and payment methods.
Expenses: log your first expense and paste a receipt link.
Summary: see your tax year and print it.

Good to know

Google Sheets: you need a free Google account. This isn't an Excel file.
Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
Nothing to install: no add-ons, no scripts.
You get a ready-to-use copy plus a Sample copy filled with example data, and a step-by-step PDF guide.

Ready when you are

Coming soon

Visit the Etsy shop

This template is on its way to our Etsy shop. Instant download when it's there.

Small Business Pricing Calculator

Work out what your business needs to earn, turn it into an hourly floor, and price every product or service so it covers your costs, fees and your time.

$7.00View template →

Client Tracker

Keep your clients, jobs and payments in one place, move every job from lead to paid, and see what needs your attention today.

$6.00View template →

Business Mileage Tracker

Log every business drive in seconds and see your miles and mileage deduction by month, purpose and vehicle for the whole tax year.

Coming soonView template →