Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceTax PlanningTax Deduction Tracker

SpreadsheetTax PlanningFree

Tax Deduction Tracker

Deductible expenses with business-use share and receipts, plus a mileage log, totalled by category for your return.

Shown with sample data

Colour

Tax Deduction Tracker

Deductible expenses with business-use share and receipts, plus a mileage log, totalled by category for your return.

Expenses deductible
$4,048
Mileage deduction
$92.40
Estimated tax saving
$1,242
At your marginal tax rate
Missing receipts
2
Deductible by category
  • Equipment$1,169.10
  • Software$809.78
  • Home office$486
  • Professional fees$450
  • Vehicle & travel$400.40
  • Education$399
  • Marketing$220
  • Phone & internet$82

How to use it

  1. 1Log each expense with date, vendor, category and amount.
  2. 2Set Business use (100% for purely business costs, less for mixed use like phone or internet).
  3. 3Record where the receipt is and mark whether you have it.
  4. 4Log business journeys on the Mileage sheet; set your rate per mile and tax rate on the Settings sheet.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Stop scrambling for receipts at tax time. Log each potentially deductible expense with its category, amount, business-use share and where the receipt is kept, and record business trips in the mileage log at your rate per mile. The tracker totals the deductible amount by category, adds mileage, flags missing receipts and shows the estimated tax saving.

Who it’s for

  • Freelancers and sole traders
  • Side businesses and landlords
  • Handing tidy records to an accountant

What’s included

  • Expenses sheet: Deductible expenses with business-use share and receipt status.
  • Mileage sheet: Business journeys and their mileage deduction.
  • Settings sheet: Rates used for mileage and the tax saving estimate.

How to use it

  1. 1Log each expense with date, vendor, category and amount.
  2. 2Set Business use (100% for purely business costs, less for mixed use like phone or internet).
  3. 3Record where the receipt is and mark whether you have it.
  4. 4Log business journeys on the Mileage sheet; set your rate per mile and tax rate on the Settings sheet.

Tips

  • Photograph receipts the day you get them.
  • Commuting to a regular workplace is usually not deductible; client visits usually are.
  • Ask your accountant which categories apply where you live.

Questions

What rate should I use for mileage?

Use your tax authority's standard rate (for example the IRS standard mileage rate in the US). Update it on the Settings sheet each year.

What is the estimated tax saving?

Total deductions multiplied by your marginal tax rate. It is a guide only.

Related searchestax deductionsbusiness expensesself employed deductionsmileage logreceipt trackerwrite offs

Details

Format
Spreadsheet
Category
Tax Planning
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTax PlanningFree

Tax Deduction Tracker

Deductible expenses with business-use share and receipts, plus a mileage log, totalled by category for your return.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Tax Planning
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More tax planning templates

View all
Sales Tax & VAT Log2 sheets

Output tax (sales)

$3,178

Input tax (purchases)

$383

Net tax due

$2,795

Net tax due by quarter
$1,715
$1,080
Q4 2026Q3 2026
SpreadsheetTax Planning

Sales Tax & VAT Log

Output and input tax on every sale and purchase, the quarter worked out from the date, and the net due for each return.

10 min setupPreview
Mileage Log2 sheets

Business miles

285

Amount to claim

$191

Trips

6

ABCD
1DateFromToCategory
2Nov 2OfficeHarbor LogisticsClient visit
3Nov 3OfficeWholesale depotSupplies
4Nov 5HomeBluepeak HQClient visit
5Nov 6OfficeThree customer dropsDelivery
Trips
SpreadsheetTax Planning

Mileage Log

Business trips with odometer readings, purpose, miles and the deduction or reimbursement at your rate.

10 min setupPreview
Quarterly Estimated Tax Planner2 sheets

Profit so far

$56,300

Estimated tax

$14,075

Paid

$10,700

ABCD
1QuarterPayment dueIncomeDeductible expenses
2Q1Apr 15$21,400$5,200
3Q2Jun 15$18,900$4,700
4Q3Sep 15$24,600$6,100
5Q4Jan 15$9,800$2,400
Quarters
SpreadsheetTax Planning

Quarterly Estimated Tax Planner

Estimate tax on self-employed profit each quarter, what to set aside and what has been paid.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ