iBill.ca
Start free
Sales tax and CRA reporting

Sales tax reports for your GST/HST return

When it's time to file, open the report for the period. iBill totals the tax on your invoices and the input tax credits on your purchases, so the figures for your return are in one place. You file the return yourself, or your accountant does.

Free · No credit card · All features included

Sales tax report in iBill with GST, PST and HST collected by province, sample data
Sample iBill sales tax report by province for a full year
Sales tax report in iBill (sample data)

How it works

  1. Pick the report

    Reports, GST/HST Report: a combined report, one tax type (GST/HST, PST or QST), or the detailed report listing every invoice.

  2. Pick the period

    Monthly, quarterly (Q1 to Q4), half-yearly or yearly, matching how often you file. Filter by province if you need to.

  3. Export it

    Download PDF, CSV or Excel. The exports list tax collected, input tax credits and the net amount on separate lines.

Worked example: an Ontario consultant's quarter

A consultant registered for GST/HST files quarterly. For July to September she invoiced $12,000.00 before tax and bought $3,000.00 of business supplies and software, all in Ontario.

LineAmount
HST collected on invoices$1,560.00
Input tax credits on expenses and bills$390.00
Net HST for the quarter$1,170.00

The HST collected counts each invoice in the period it was issued or paid, whichever came first, so an invoice sent in September and paid in October is in the third quarter. A voided invoice comes off in the period it was voided.

Input tax credits come from the GST/HST you entered on expenses and vendor bills. A receipt entered without its tax gives no credit, so enter the tax as it's shown.

Capital cost allowance and year-end

Before you file, run Validate Against General Ledger. It compares the tax on your invoices with the tax accounts in your books, so a mismatch shows up while it's still easy to trace, not after the return is in.

The CCA tracker in Accounting keeps your equipment, vehicles and other capital assets by class, with the half-year rule and the accelerated first-year rules where they apply. Its T2125 summary gives the figures for the capital cost allowance area of the self-employed business statement, and it downloads as a PDF.

On the dashboard, the Tax Summary tile downloads a CSV of the year for your accountant. Keeping your records for the required period, generally six years, is your responsibility; export them regularly.

What’s included, and what isn’t

  • Reports for GST/HST, PST and QST, separately or combined, with a province filter.
  • Calendar periods: months, quarters, halves and years. Custom date ranges aren't offered.
  • Validate Against General Ledger compares the invoice totals with the tax accounts in your books.
  • Input tax credits come from GST/HST Paid (ITC) and QST Paid, by the date of the expense or bill.
  • 18 CCA classes, including vehicles, computers and equipment, with the class 10.1 cost limit for the year the vehicle was bought.
  • Not included: filing with the CRA or Revenu Québec (iBill doesn't connect to government systems), payroll remittances, and income tax returns.

Questions

Does iBill file my GST/HST return?

No. iBill gives you the figures; you or your accountant file the return through the CRA's own services.

Are unpaid invoices included?

Yes. GST/HST generally becomes payable when you issue the invoice or are paid, whichever is earlier, so the report counts invoices in that period even if they're unpaid.

Can I report PST and QST too?

Yes. Pick PST or QST as the tax type, or use the combined report. Provincial returns are filed separately from your GST/HST return.

What if I file once a year?

Choose the yearly period. If your fiscal year isn't the calendar year, run the quarterly reports for the months your year covers and add them up, or ask your accountant to work from the CSV.

Have your sales tax figures ready at filing time

Invoice with the right tax, record expenses with theirs, and the report adds it up. See the rest of the accounting tools.

Start free

Free · No credit card · All features included · Join 1,200+ Canadian Businesses