Missing Toolkit: Templates logo
Missing Toolkit Templates
↑ ↓ navigate ↵ open esc close

Print a Tax Summary

QuickBooks prints a tax summary under the totals on our invoices: each tax, its rate, the tax, and the amount it was charged on. Can my template do the same?

Yes. Tax line items are placeholders for one tax each. You put them in a table row, and the row repeats once for every tax on the invoice, so the same template works whether an invoice has one tax or five.

What you need

  • Sales tax set up in QuickBooks.
  • Microsoft Word, to edit the template.

Steps

  1. In Word, add a small table below your totals with a heading row and one more row under it:

    Rate Tax Net
    ${TAX_LINE_DESCRIPTION} @ ${TAX_LINE_RATE} ${TAX_LINE_AMOUNT} ${TAX_LINE_TAXABLE}
  2. Keep this table separate from your line items table. Tax line items repeat once per tax, and line items repeat once per item, so each needs a row of its own.

  3. On the Templates page, open the template, click Edit, then Replace document, and upload the updated file.

Example

A print shop in Victoria bills $200.00 of banners, which are charged GST and PST, and $80.00 of design work, which is charged GST only. The tax summary prints:

Rate Tax Net
GST @ 5% 14.00 280.00
PST (BC) @ 7% 14.00 200.00

Good to know

  • To see the values for a real invoice, open it in Missing Toolkit: Templates and look under Tax Line Items.
  • A tax charged at 0%, such as GST on zero-rated items, gets its own row, the same as on QuickBooks' invoices.
  • An invoice with no tax prints no tax rows. The heading row stays, so a table with only its headings is what a tax-free invoice shows.
  • ${TAX_LINE_NAME} prints the tax rate's name in QuickBooks instead of its description. In the US, where every rate is often described as "Sales Tax", the name is the one that tells the state, county and city apart.
  • Add ${TAX_LINE_NUMBER} for each tax's registration number.