Aantar Books
Sales Tax reports
Every sales tax report explained: the GST/HST Return and its detail, the PST / QST Return, the review reports to run before filing, and Sales Tax Liability.
Where: Reports ▸ Sales Tax ▸ Tax Agency Report (GST/HST Return) · Reports ▸ Sales Tax ▸ Tax Agency Detail Report · Reports ▸ Sales Tax ▸ Line 101 Sales by Invoice · Reports ▸ Sales Tax ▸ Line 101 Sales by Tax Code · Reports ▸ Sales Tax ▸ PST / QST Return · Reports ▸ Sales Tax ▸ Unassigned Sales Tax Amounts Detail Report · Reports ▸ Sales Tax ▸ Sales Tax Exception Report · Reports ▸ Sales Tax ▸ Tax Collected by Province and Tax Type · Reports ▸ Vendors & Payables ▸ Sales Tax Liability
The Sales Tax reports turn your invoices, credit memos, bills and expenses into the figures you put on your sales tax returns, and help you check those figures before you file. They are built for Canada's four kinds of sales tax: the federal GST, the harmonized HST, and the provincial PST, QST and RST.
Open them from Reports ▸ Sales Tax, or from the Sales Tax category in the Report Centre (Reports ▸ Report Centre). The one exception is Sales Tax Liability, which sits on Reports ▸ Vendors & Payables. How to set dates, drill down and print is the same for every report: see Running a report, Drilling down from a report and Print, export and email a report.
Important: These reports show the figures. To file a return, record the payment and clear the liability in your books, use Manage Sales Tax (see Manage Sales Tax and Prepare and file a sales tax return).
Which report do I want?
| Question | Report |
|---|---|
| What goes on my GST/HST return this period? | GST/HST Return |
| Which invoices make up line 103? | GST/HST Return Detail |
| Which sales make up line 101, one row per invoice? | Line 101 Sales by Invoice |
| What did each tax code charge on a sale in line 101? | Line 101 Sales by Tax Code |
| What do I owe the province? | PST / QST Return |
| How much GST/HST and PST did I collect, per rate? | Tax Collected by Rate |
| Did anything sell without a tax code? | Unassigned Sales Tax Amounts |
| Did any line charge a different amount from its tax code? | Sales Tax Exception |
| How much tax did I charge customers in each province? | Tax Collected by Province and Tax Type |
| How much did I sell taxable and non-taxable, by tax code? | Sales Tax Liability |
How these reports treat tax
A few rules hold across the whole category. Knowing them explains most figures.
- Combined codes are split. A sale in British Columbia carries one 12% code, but 5% of it is GST owed to the federal government and 7% is PST owed to the province, on different returns. The reports split every combined (group) tax code into its parts, in proportion to their rates, so each part lands on the right return.
- Federal or provincial. Each tax rate is treated as federal (GST/HST) or provincial (PST, QST, RST) by the account it posts to in Accounting Setup (see Accounting Setup). A rate with no posting account set is judged by its name: a name containing GST or HST is federal; PST, QST or RST is provincial. Rates judged by name are listed in a note so you can make it definitive; a rate that is neither appears on no return and raises an alert.
- What counts. Only saved (final) invoices count. Estimates, sales orders and held or pending sales do not.
- Credit memos reduce tax in the period the credit memo is dated, split across the tax codes of the invoice they reverse. A credit memo not linked to an invoice cannot be split by rate (see Unassigned Sales Tax Amounts).
- An invoice-wide discount lowers the tax the invoice actually charged, and the reports use that lower figure. It lowers the sale too: on line 101 each line carries its share of the discount, so an invoice shows the same figure as on the Profit & Loss (a $19.00 sale less a $1.90 discount is $17.10).
- Tax on shipping (freight) is tax collected, and is included.
- Tax on the whole invoice. When an invoice carries its tax code on the invoice rather than on its lines, that tax is counted through the invoice's code.
- Very long periods are refused, not cut short. If a period holds more than 100,000 sale or purchase lines, a filing report shows This period contains … sale lines, more than this report will compute in one pass. A tax return must not be produced from a partial period, so nothing is shown. Run it one month at a time and add the results.
Filing
GST/HST Return
What it answers: the figures for your GST/HST return (the CRA's GST34), line by line, for the period, with every figure clickable. On the Reports menu it is Tax Agency Report (GST/HST Return), and in the Report Centre you can press V to open it.
| Menu | Reports ▸ Sales Tax ▸ Tax Agency Report (GST/HST Return) |
| Dates | Period — use the exact period of your return (a month, quarter or year). |
| Filters | None besides the date. It always covers every location. |
| Source | Tax from the documents, checked against the GST/HST account in your books; line 101 from the books. |
Columns: Line (the return's line number), Description, Amount.
Rows:
| Line | Description | How it is worked out |
|---|---|---|
| 101 | Sales and other revenue | The income your books recorded for the period, from every income account: the same figure the Sales Tax filing screen uses. It is before discounts (your chart books a discount as an expense) and includes other income. When the books hold no income for the period (accounting not yet switched on), it is your invoices' totals less tax, tips and rounding, net of credit memos. |
| 103 | GST/HST collected or collectible | The federal part of the tax on your invoices, less credit memos. When every document agrees with your books, line 103 is the GST/HST your books recorded. |
| 104 | Adjustments to be added | Always 0.00 on this report. The return in Manage Sales Tax fills it in: general journal entries to the GST/HST collected account dated in the period, and tax entered late in a period already filed (see Prepare and file a sales tax return). |
| 105 | Total GST/HST and adjustments | Line 103 + line 104. |
| 106 | Input tax credits (ITCs) | The federal part of the tax on your received bills, less vendor credits, including tax on freight charged on bills. Purchase orders do not count. Provincial tax you paid is never an ITC. |
| 107 | Adjustments to be deducted | Always 0.00 on this report. The return in Manage Sales Tax fills it in from general journal entries to the input tax credits account dated in the period, and late ITCs. |
| 108 | Total ITCs and adjustments | Line 106 + line 107. |
| 109 | NET TAX — amount owing (or NET TAX — refund due) | Line 105 − line 108, in the highlighted total row. |
Under Breakdown of line 103 each GST or HST rate is listed with its amount (for example GST (5%), HST ON (13%)). Two rates for the same tax at the same percentage (a G 5% and a GST 5%) are one line, named by the clearer name. Two more lines can appear there:
- No tax rate on the document — counted as your books posted it (n) — tax on documents with no tax code that your books posted to GST/HST. It is on line 103 already.
- Rounding — the cents between rounding each invoice's tax and adding up unrounded lines. When every document agrees with your books it reads Rounding — each invoice's tax is rounded to the cent in your books.
The breakdown always adds up to line 103 exactly.
Drill-down:
| Click | Opens |
|---|---|
| Line 101 | Line 101 Sales by Invoice: every sale behind line 101, one row per invoice. |
| Lines 103 and 105 | GST/HST Return Detail: every document behind line 103. |
| Lines 106 and 108 | Transaction List by Vendor: the purchases behind the ITCs. |
| A rate in the breakdown | The detail for that one rate (Tax Detail). |
| No tax rate on the document… | Unassigned Sales Tax Amounts. |
Alerts it can raise (cards above the report, each listing up to 25 documents you can click):
| Alert | Meaning and what to do |
|---|---|
| One document does not match your books — do not file yet (or N documents…) | Red, with the red bar This report does not balance. Do not file from it. For each document listed, your books hold a different amount of GST/HST than the document charges (shown as books minus document). One marked not in your books at all was never posted: open it and save it again. A chip Journal entries with no document opens the GST/HST account's transactions. Fix every item, then Refresh. |
| N documents have tax but no tax rate — counted as GST/HST, as your books did | Amber. Usually a credit memo issued without linking the original invoice, or an invoice line with no tax code. The amounts are already on line 103, so the return can be filed. Open the list shows them. |
| … of tax is on no return | Red. These documents charged tax with no tax rate, and your books did not post it to GST/HST either. Give each line a tax code before filing. |
| Some tax rates are not set up | Red. A tax rate used in the period is neither federal nor provincial, so it appears on neither return. Map it to its tax account in Accounting Setup. |
Notes under About this report explain line 101, say whether line 103 agrees with the books document by document, list any rates classified by name (Classified by name, not by your posting map: …), and remind you that lines 104 and 107 are adjustments (the return in Manage Sales Tax includes journal entries to the tax accounts there).
Related: GST/HST Return Detail lists line 103's documents; the PST / QST Return is its provincial companion; the Tax report screen shows tax collected by rate at a glance.
Tip: Run Unassigned Sales Tax Amounts and Sales Tax Exception for the same period first. A clean result on both, and no red alert here, means the return is ready to file from Manage Sales Tax.
Note: Aantar Books shows the return's lines as a report, and every line opens the transactions behind it.
GST/HST Return Detail
What it answers: which invoices and credit memos make up line 103, rate by rate.
| Menu | Reports ▸ Sales Tax ▸ Tax Agency Detail Report |
| Dates | Period |
| Filters | None besides the date. Drilled from a single rate, it shows only that rate. |
| Source | The documents. |
| Column | What it shows |
|---|---|
| Date | The document date. |
| Num | The invoice or credit memo number. |
| Name | The customer (Walk-In Customer for sales without one). |
| Taxable amount | The amount the tax was charged on. |
| GST/HST | The federal tax on that line. |
| PST | The provincial tax on the same line (a GST + PST code shows both). Headed RST in Manitoba, QST in Quebec, and PST/QST when the period's documents carry more than one province's tax. |
| Amount | This section's tax on that line: the GST/HST share on line 103, the rate's share when opened for one rate, the input tax credit on line 106. |
| Balance | A running total of the tax columns shown: GST/HST plus PST when both are shown, either one alone when the other is hidden with Columns. It starts again at each section. See A running Balance of the tax columns. |
Rows and totals: a heading for each GST or HST rate (for example GST (5%)), the documents under it (credit memos negative), and Total GST (or the rate's name) under each. The grand total is TOTAL GST/HST COLLECTED, which equals the tax on line 103 before any "no tax rate" or rounding lines.
When opened for one rate (by clicking a rate on the GST/HST Return, a rate on the PST / QST Return, or a tax row on the Tax report screen) the title is Tax Detail, it shows that rate only (provincial rates included), and the grand total is TOTAL COLLECTED.
Drill-down: each line opens its invoice or credit memo.
Clicking line 101 on the GST/HST Return opens Line 101 Sales by Invoice, one row per invoice. To see what each tax code charged on a sale, use Line 101 Sales by Tax Code.
Note: A combined code is split here, so the tax on a line can be smaller than the tax printed on the invoice: a 12% GST + PST invoice shows only its 5% GST share on the GST section.
Line 101 Sales by Invoice
What it answers: which sales make up line 101, one row per invoice or credit memo, whatever tax codes its lines carry.
| Menu | Reports ▸ Sales Tax ▸ Line 101 Sales by Invoice |
| Dates | Period |
| Filters | None besides the date. The same dates and documents as Line 101 Sales by Tax Code. |
| Source | The documents, with line 101 itself from your books. |
| Column | What it shows |
|---|---|
| Type | Invoice or Credit Memo. |
| Date | The document date. |
| Num | The invoice or credit memo number. |
| Customer | The customer (Walk-In Customer for sales without one). |
| Sales before tax | All the document's lines added up, whatever their tax codes, after line discounts and its share of any discount on the whole invoice. |
| GST/HST | The federal tax on the document. |
| PST | The provincial tax on the document. |
| Total tax | GST/HST plus PST. |
| Total | Sales before tax plus total tax. |
Rows and totals: one row per document by date (credit memos negative), then any documents with no tax rate (Counted as your books posted it) and a Rounding line, as on Line 101 Sales by Tax Code, and Total sales by invoice. A line Other revenue in the books (card surcharges, other income, adjustments) holds the income that is on no sale. The grand total, LINE 101 Sales and other revenue, equals line 101 on the GST/HST Return, and its GST/HST equals line 103.
Drill-down: each row opens its invoice or credit memo; the other revenue line opens the entries behind it.
This is the report line 101 on the GST/HST Return opens, and the one the PST / QST Return's Total sales (before tax) opens: match its invoices one for one against your sales reports.
Tip: An invoice with lines on S, G and E is one row here and three rows on Line 101 Sales by Tax Code.
Line 101 Sales by Tax Code
What it answers: what each tax code charged on the sales in line 101: a sale is listed once for every tax code on its lines.
| Menu | Reports ▸ Sales Tax ▸ Line 101 Sales by Tax Code |
| Dates | Period |
| Filters | None besides the date. The same dates and documents as Line 101 Sales by Invoice. |
| Source | The documents, with line 101 itself from your books. |
| Column | What it shows |
|---|---|
| Type | Invoice or Credit Memo. |
| Date | The document date. |
| Num | The invoice or credit memo number. |
| Source Name | The customer (Walk-In Customer for sales without one). |
| Tax Code | The tax code on these lines of the document (Not specified when they carry none). |
| Sales | The document's lines on that code, after line discounts and their share of any discount on the whole invoice, the figure your books posted. |
| GST/HST | The federal tax those lines charged. |
| PST | The provincial tax those lines charged. |
| Total Tax | GST/HST plus PST. |
Rows and totals: the sales in groups (taxable sales, zero-rated and exempt sales, sales taxed provincially only, sales with no tax code, card surcharges invoiced), each with its total. Under the taxable sales come any documents with no tax rate (Counted as your books posted it) and a Rounding line (each invoice's tax is rounded to the cent in your books), so the GST/HST column adds up to line 103. A line Other revenue in the books (card surcharges, other income, adjustments) holds the income that is on no sale, and the grand total, LINE 101 Sales and other revenue, equals line 101 on the GST/HST Return.
Drill-down: each line opens its invoice or credit memo; the other revenue line opens the entries behind it.
Note: An invoice with lines on more than one tax code appears once per code, so its rows do not match the invoice's total one for one. To tick invoices off against your sales, use Line 101 Sales by Invoice.
PST / QST Return
What it answers: the provincial sales tax you collected in the period, per provincial rate: the figures for your PST, QST or RST return.
| Menu | Reports ▸ Sales Tax ▸ PST / QST Return |
| Dates | Period |
| Filters | None besides the date. |
| Source | The documents. |
| Column | What it shows |
|---|---|
| Tax | The provincial rate's name. |
| Rate | Its percentage. |
| Taxable sales | The sales it was charged on. |
| Tax collected | The provincial tax charged, less credit memos. |
Rows and totals: one row per provincial rate that collected tax (two rates of the same tax at the same percentage, such as P 7% and BC PST 7%, are one row), then TOTAL PROVINCIAL TAX PAYABLE.
Drill-down: each rate opens Tax Detail for that rate: every document behind it.
Notes: Provincial sales tax has no input credits — PST, RST and QST paid on purchases is a business cost, not something you claim back. Some provinces allow a collection commission on the return; it is not deducted here, so apply it on the provincial form. No provincial tax was collected in this period. appears when there is none. Rate classification notes appear as on the GST/HST Return.
Tip: Quebec's QST, like BC's PST, Saskatchewan's PST and Manitoba's RST, is charged on the selling price without compounding on GST, so splitting a combined code by rate gives each government its exact share.
Review
Tax Collected by Rate
What it answers: how much GST/HST and PST you collected in the period, per rate, with the sales each was charged on. It is the report behind the Tax (GST/PST) screen, worked out exactly as the returns are.
| Menu | Reports ▸ Report Centre ▸ Sales Tax |
| Dates | Period |
| Source | The documents, as the GST/HST and PST / QST Returns read them. |
Rows and totals: GST/HST (line 103) with one row per rate, then No tax rate on the document and Rounding rows when there are any, and Total GST/HST, which is line 103 of the GST/HST Return for the same dates; PST / RST / QST with one row per provincial rate and Total provincial tax, the PST / QST Return's total; No tax charged with the zero-rated and exempt sales and the sales with no tax code; and TOTAL TAX COLLECTED. Each rate row opens its Tax Detail.
Unassigned Sales Tax Amounts
What it answers: which sale lines were sold with no tax code, and which credit memos carry tax but are not linked to an invoice. Review it before every filing. On the Reports menu it is Unassigned Sales Tax Amounts Detail Report.
| Menu | Reports ▸ Sales Tax ▸ Unassigned Sales Tax Amounts Detail Report |
| Dates | Period |
| Filters | None besides the date. |
| Source | The documents. |
| Column | What it shows |
|---|---|
| Date | The document date. |
| Num | The invoice or credit memo number. |
| Customer | The customer. |
| Item | The item sold, or Credit note — not linked to an invoice. |
| Code | The item's code (SKU). |
| Amount | The line's amount (quantity less any returned, times price). Credit memo lines are negative. |
| Tax charged | Any tax on the line despite having no code. |
Rows and totals: one row per line, oldest first, then a TOTAL row.
Drill-down: each row opens its invoice or credit memo, where you can give the line a tax code.
Notes you may see:
- Every line sold in this period carries a tax code. Nothing to review.
- N line(s) were sold with no tax code… — legitimate for zero-rated groceries or an exempt sale; if any should have been taxed, the return is understated.
- N credit note(s) were issued without linking the original invoice, so no tax rate can be read from them. Your books still reduced GST/HST by their tax.
- WARNING: … of tax sits on the documents above with no tax rate. Give each line a tax code, and link each credit memo to its invoice, so it can be split by rate.
Tax Collected by Province and Tax Type
What it answers: how much GST, HST, PST, QST and RST you charged on sales supplied to each province (or state), in one grid.
| Menu | Reports ▸ Sales Tax ▸ Tax Collected by Province and Tax Type |
| Dates | Period |
| Filters | None besides the date. |
| Source | The documents. |
| Column | What it shows |
|---|---|
| Province / state | Where the sale was supplied, for example Ontario (ON), United States (export), Outside North America (export) or Not recorded. |
| Sales excl. tax | Sales before tax to that province (the same figure as Sales by Province / State). |
| One column per tax rate | For example GST (5%), PST (7%), HST (13%): the tax of that rate charged there, with combined codes split into their parts. Ordered by how much each rate collected. |
| No tax rate | Only when some tax was charged with no tax code. |
| Total tax | The row's total tax. |
Where a sale is placed: by the same rule the tax was charged under. An Amazon order is placed where Amazon shipped it; any other sale is placed at the customer's address. A sale whose place cannot be read is under Not recorded.
Rows and totals: one row per province, largest sales first, and a TOTAL row. Credit memos subtract in the period they were issued; delivery charges carry their tax like any other line.
Drill-down: a province opens Sales by Province / State Detail for that province and period.
Notes: when this report's tax total differs by a dollar or more from the tax shown on Sales by Province / State, a note explains why: that report reads the tax stored on each invoice, which on invoices created in the web back office holds only the tax on the invoice as a whole.
Tip: Use this report to check that out-of-province sales were charged the destination's tax: a customer in Nova Scotia should show HST, not your home province's PST.
Sales Tax Exception
What it answers: which taxed lines were charged a different amount of tax from what their tax code says.
| Menu | Reports ▸ Sales Tax ▸ Sales Tax Exception Report |
| Dates | Period |
| Filters | None besides the date. |
| Source | The documents. |
| Column | What it shows |
|---|---|
| Date | The document date. |
| Num | The invoice number. |
| Customer | The customer. |
| Item | The item. |
| Code | The item's code (SKU). |
| Tax code | The code on the line. |
| Expected | Price × the code's rate × quantity (less any returned). |
| Charged | The tax actually on the line. |
| Difference | Charged − Expected. |
Rows and totals: only lines whose difference is more than 2 cents (or 0.1% of the expected tax, whichever is larger) are listed, since a cent either way is rounding. The last row is TOTAL DIFFERENCE.
Drill-down: each row opens its invoice.
Notes: N taxed line(s) checked against the rate their code declares. Then either Every line agrees with its tax code. Nothing to explain to an auditor. or a note that each line listed was charged something other than its tax code says. That is legitimate when the price was entered tax-inclusive or the tax was changed by hand on the invoice, but each one needs a reason.
Returns
Sales Tax Liability
What it answers: for each tax code, your total sales, how much was taxable and non-taxable, and the tax collected. It sits on the Vendors & Payables submenu.
| Menu | Reports ▸ Vendors & Payables ▸ Sales Tax Liability |
| Dates | Period |
| Filters | None besides the date. |
| Source | The documents (invoice lines). |
| Column | What it shows |
|---|---|
| Tax | The tax code as it appears on the lines (a combined code stays whole), or No tax code. |
| Total Sales | Sales on lines with that code, before tax, net of quantities returned. |
| Non-Taxable Sales | The same sales when the code charged no tax (or there was no code). |
| Taxable Sales | The same sales when the code charged tax. |
| Tax Rate | The code's rate. |
| Tax Collected | The tax charged on those lines. |
Rows and totals: one row per tax code, then TOTAL.
Drill-down: a row with a tax code opens GST/HST Return Detail for the same period.
Note: Sales are net of returns, before tax. The balance still owed to each agency is on the Balance Sheet and in Manage Sales Tax.
Note: Unlike the returns, this report keeps a combined code whole and reads quantities returned against the original invoice rather than the credit memo's date. Use it to see sales by code; file from the GST/HST Return and PST / QST Return.
Common problems
| Problem | Cause and fix |
|---|---|
| Red bar This report does not balance. Do not file from it. on the GST/HST Return | Some documents disagree with your books. Open each listed document; for one not in your books at all, open it and save it again. Refresh until the alert is gone. |
| Some tax rates are not set up | A rate is neither federal nor provincial. Set its tax account in Accounting Setup (see Accounting Setup and Tax rates and tax groups). |
| Line 101 does not equal Sales by Customer Summary | Line 101 is your books' income, before discounts and including other income; Sales by Customer is invoices before tax, after discounts. The note on the return says so. |
| Line 103 differs from the tax printed on the invoices | Combined codes are split: only the GST/HST share is on line 103. The provincial share is on the PST / QST Return. |
| Tax refunded on a credit memo landed in the wrong period | Credit memos count in the period they are dated, not the period of the original invoice. |
| …more than this report will compute in one pass… | Run the return one month at a time and add the months together. |
| A sale shows under Not recorded on Tax Collected by Province | The customer has no province on file. Add the address in the Customer Centre. |
| PST paid on purchases is not on any return | Intended: provincial tax paid on purchases is a cost, not a credit. |
Related articles
Related articles
Something unclear or out of date? Write to support@aantar.com and name this page.