/Marketing & sales

Sales Tax Summary

Tax charged on sales against tax paid on purchases, and the balance owed.

Details

sales tax summary template
Fills every box with an example you can type over.
Adding a logo, a photo or your signature?
One per line: Category | Net sales | Rate %
One per line: Category | Tax paid

Red highlights mark what is still blank. Click anything on the page to change it. Your draft is kept on this device as you work.

Tap the page to change any words.
[your business name]
[your address]
Sales Tax Summary

For the period [date] to [date].

CategoryNet salesRateTax
[add one category per line]
Tax paid on purchasesAmount
[add one category per line]
A working sheet, not a return. Rates, the treatment of exempt and zero-rated supplies, and the rules on reclaiming input tax differ by country and by category — reconcile this to the return before filing.
Prepared by [business]
Keep the categories the same every period. Most reconciliation pain comes from someone renaming a category mid-year and breaking the comparison.

What is a Sales Tax Summary?

A sales tax summary sets out the tax you charged on sales for a period against the tax you paid on purchases, and shows the net figure payable to or recoverable from the tax authority. It is the working paper behind the number you file. Without it, the return is a figure pulled from software with nothing to explain it, and any query — from the authority or from your own accountant — has to be answered from scratch.

Any registered business that charges VAT, GST or a state sales tax prepares one at the end of each filing period: monthly, quarterly or annually depending on registration. Bookkeepers use it to prepare the return, the owner signs it off, and the accountant checks it against the annual accounts. It is also the first document requested in an audit or inspection, because it shows whether the figures filed were derived from the ledgers or arrived at some other way.

Everything about the calculation is national. VAT in the UK and EU operates on output tax less input tax with rules on partial exemption and reverse charges; GST in India runs through GSTR filings with input tax credit matching and separate CGST, SGST and IGST components; Australia files a BAS; Canada has GST and HST with provincial variations; the US has no national sales tax at all, but state and local rules, nexus thresholds and exemption certificates that differ by state. Use your own authority's current guidance — no single template covers all of these.

The summary does not file anything and it does not decide what rate applies. Whether a supply is standard-rated, reduced, zero-rated, exempt or outside the scope is a technical question with real money attached, and getting it wrong on a whole product line multiplies across every invoice. It also does not test whether input tax is recoverable — entertainment, some vehicles and costs relating to exempt supplies are commonly restricted. Confirm treatment with your accountant or the authority's published guidance rather than with the sheet.

What to put in a Sales Tax Summary

These are the details this template asks for. Anything left blank is marked in red on the preview so you can see what is still missing.

FieldWhat goes in it
Business nameFor example: Barton Supply Co.
Your addressFor example: Unit 7, Barton Road, Columbus, OH 43212
Period fromFree text
Period toFree text
Sales tax summaryOne per line: Category | Net sales | Rate %
Tax paid on purchasesOne per line: Category | Tax paid

How to write a Sales Tax Summary

  1. Fix the period and the accounting basis

    State the exact start and end dates and whether you report on an invoice basis or a cash basis, because that determines which transactions belong in the period. On an invoice basis an unpaid sales invoice dated the last day of the quarter is in; on a cash basis it is not. Switching basis between periods without reconciling leaves transactions counted twice or missed entirely.

  2. Summarise output tax by rate

    Group sales by rate rather than by customer: standard, reduced, zero-rated, exempt, outside the scope, and any reverse charge supplies, each with the net value and the tax. Totals by rate are what let you check the arithmetic — if the standard-rated net multiplied by the rate does not approximate the tax column, something is coded wrong and one transaction has probably been entered at the wrong rate.

  3. Summarise input tax with the same discipline

    List purchase tax by category, separating anything with restricted or partial recovery, and exclude tax on invoices you do not hold. A supplier invoice that has not arrived is not a claim, however certain the amount. Where a cost is used partly for non-business or exempt purposes, show the full amount, the recovery percentage and the basis for it in its own column.

  4. Handle adjustments and corrections explicitly

    Credit notes, bad debt relief where your system allows it, corrections to earlier periods, imports and reverse charge entries, and any annual adjustment all belong on named lines rather than netted into the main totals. Each should carry a short note saying what it is. An adjustment with no explanation is the fastest way to turn a routine check into a longer one.

  5. Reconcile to the ledger and file on time

    Agree the net figure to the tax control account in your trial balance and to the return you submit; all three should tell the same story. Then check the filing and payment deadline for your period — they are not always the same date — and diary both. Keep the summary, the underlying reports and the submission confirmation together for the retention period your authority requires.

Common mistakes

  • Claiming input tax without holding a valid supplier invoice is the most common reason a claim is refused on inspection, however genuine the purchase was.
  • Coding zero-rated and exempt supplies as the same thing distorts the recovery position, because exempt sales can restrict how much input tax you may reclaim.
  • Filing from a software figure without ever reconciling it to the tax control account means a coding error can repeat quietly for a year before anyone notices.
  • Missing the deadline by a day still counts as late in most systems, and penalties are usually applied automatically regardless of the amount involved.
  • Reclaiming tax on entertainment, private use or restricted vehicle costs without checking the rules creates an underpayment that carries interest when it is found.

Frequently asked questions

What is the difference between output tax and input tax?

Output tax is the tax you charge your customers on sales. Input tax is the tax you are charged by your suppliers on purchases. In a VAT or GST system you generally pay over the difference, so a period with more sales than purchases produces a payment and a period of heavy investment can produce a refund. The names describe direction, not the type of tax.

Which period do I put a transaction in?

It depends on your accounting basis. On an invoice or accrual basis, the tax point is normally the invoice date, subject to rules about payments and deliveries that can move it. On a cash basis, it is the date the money moves. Special rules apply to deposits, continuous supplies and imports in most systems, so check your authority's guidance for the specific case rather than assuming.

What records do I need to keep and for how long?

Sales and purchase invoices, credit notes, import documents, the summaries behind each return, and the returns themselves. Retention periods are set nationally and commonly run to several years, with longer periods where property or capital goods schemes are involved. Digital records are accepted in most systems and required in some, so check the current position for your country rather than assuming paper is enough.

What happens if I find an error in a previous return?

Most authorities distinguish between small errors that can be corrected on the next return and larger ones that must be notified separately, with the threshold set nationally. Correcting promptly and voluntarily usually reduces any penalty. Keep a note of what the error was, how it arose and how you calculated the correction, and take advice if the amount is significant or repeated over several periods.

Do I have to register for sales tax?

Registration thresholds and triggers vary widely: a turnover threshold in the UK and Australia, turnover and inter-state supply rules in India, and economic nexus tests that differ state by state in the US. Voluntary registration is possible in some systems and can be worth it if you mainly sell to registered businesses. Check the current threshold with your own tax authority, because it changes.

This page explains general practice and is not legal advice. Requirements differ between countries and, in some cases, between states — check what applies where the document will be used.

All templates · Finance templates