Show Each Tax Separately
We charge GST and PST. QuickBooks lists them separately on our invoices, but my template only shows one tax total. Can I show each one?
Yes. Every tax in your QuickBooks sales tax settings has its own placeholders, named after the tax. You put them in your template where each tax should print.
What you need
- Sales tax set up in QuickBooks.
- Microsoft Word, to edit the template.
Steps
-
In Missing Toolkit: Templates, open any invoice and look under Tax Breakdown. It lists the placeholders for each of your taxes, such as
${TAX_GST_AMOUNT}and${TAX_PST_BC_AMOUNT}, with a button to copy each one. -
In Word, replace the single tax line in your totals with one line per tax. For example:
Subtotal ${SUBTOTAL} GST (${TAX_GST_RATE}) ${TAX_GST_AMOUNT} PST (${TAX_PST_BC_RATE}) ${TAX_PST_BC_AMOUNT} Total ${TOTAL_AMOUNT} -
Add your registration numbers near your company details, such as
GST No. ${TAX_GST_NUMBER}andPST No. ${TAX_PST_BC_NUMBER}. -
To show the tax code on each line, add a column to your items table with
${LINE_TAX_CODE}in the second row. -
On the Templates page, open the template, click Edit, then Replace document, and upload the updated file.
Example
A landscaping company in Vancouver bills $400.00 of mulch, which is charged GST and PST, and $600.00 of lawn care, which is charged GST only:
| Subtotal | 1,000.00 |
|---|---|
| GST (5%) | 50.00 |
| PST (7%) | 28.00 |
| Total | 1,078.00 |
${TAX_GST_TAXABLE} prints 1,000.00 and ${TAX_PST_BC_TAXABLE} prints 400.00, the amounts each tax was charged on.
Good to know
- A tax that isn't on an invoice prints blank. To print something in its place, add a default:
${TAX_PST_BC_AMOUNT|default:0.00}. - Purchase orders use the same placeholder names as invoices, so the same totals block works on both.
- If you add a tax in QuickBooks, click Connections in the sidebar, open your QuickBooks connection, and click Refresh from QuickBooks.