Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceTax PlanningSales Tax & VAT Log

SpreadsheetTax PlanningFree

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.

Shown with sample data

Colour

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.

Output tax (sales)
$3,178
Input tax (purchases)
$383
Net tax due
$2,795
Output tax minus reclaimable input tax
Returns not filed
2
Net tax due by quarter
  • Q3 2026$1,080
  • Q4 2026$1,714.50

How to use it

  1. 1Record each sales invoice and purchase receipt with date, reference, type, net amount and tax rate.
  2. 2Tax, gross and Quarter fill in for you.
  3. 3Before filing, check the Returns sheet for the quarter and mark it Filed and Paid once done.
  4. 4Keep the reference matching the invoice or receipt for audit.

In this workbook

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

About this template

Keep a clean record of tax on sales (output tax) and on purchases (input tax) for every filing period. Enter each invoice or receipt with its net amount and rate; tax and gross amounts are calculated, the filing quarter is worked out from the date, and a returns sheet shows output tax, reclaimable input tax and the net amount to pay for each quarter, with its filing status.

Who it’s for

  • VAT, GST or sales tax registered businesses
  • Preparing quarterly returns
  • Checking your figures against accounting software

What’s included

  • Tax log sheet: Every taxable sale and purchase with its tax.
  • Returns sheet: Each filing period with tax due and its status.

How to use it

  1. 1Record each sales invoice and purchase receipt with date, reference, type, net amount and tax rate.
  2. 2Tax, gross and Quarter fill in for you.
  3. 3Before filing, check the Returns sheet for the quarter and mark it Filed and Paid once done.
  4. 4Keep the reference matching the invoice or receipt for audit.

Tips

  • Only reclaim input tax you hold a valid tax invoice for.
  • Zero-rated sales still count towards taxable turnover.
  • Diarise each filing deadline as soon as the quarter ends.

Questions

What is the difference between zero-rated and exempt?

Zero-rated sales are taxable at 0% and still let you reclaim input tax; exempt sales are outside the tax and usually do not. Record exempt sales with rate 0% and a note.

Can I use other periods?

Yes. Replace the Quarter formula with months, or change the period names on the Returns sheet.

Related searchesvat returnsales tax loggst trackerinput taxoutput taxtax filing

Details

Format
Spreadsheet
Category
Tax Planning
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetTax PlanningFree

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.

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
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More tax planning templates

View all
Tax Deduction Tracker3 sheets

Expenses deductible

$4,048

Mileage deduction

$92

Estimated tax saving

$1,242

ABCD
1DateVendorCategoryDescription
2Jan 8AdobeSoftwareCreative Cloud annual
3Feb 14AppleEquipmentMacBook Air
4Mar 1ComcastPhone & internetInternet: March
5Mar 22ShellVehicle & travelFuel: client visit
Expenses
SpreadsheetTax Planning

Tax Deduction Tracker

Deductible expenses with business-use share and receipts, plus a mileage log, totalled by category for your 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