Convert Canadian receipts to Excel with GST/HST separated
GST/HST and PST/QST each get their own column, read straight from the receipt, in CAD.
Your receipts
Drop receipts or invoices here
PDF, JPG, PNG · up to 200 files · several receipts in one photo is fine
Processed, then discarded. We never store your files. · Not tax advice.
Self-employed Canadians and small businesses claiming input tax credits need the GST or HST on each receipt, and sometimes PST or QST, kept apart from the total. Drop your receipts and invoices and get a spreadsheet with the date, vendor, GST/HST, PST/QST and total for each. Tax amounts are read as printed, so receipts from different provinces work in the same batch. The summary tab totals each category so you can reconcile quickly.
Why Canadian sales tax is hard to track
- GST, HST, PST and QST appear differently on each receipt.
- Rates differ by province.
- Input tax credits need the tax amount from every receipt.
| Date | Vendor | GST/HST | PST/QST | Total | |
|---|---|---|---|---|---|
| 1 | 2026-02-20 | Staples Canada | 6.50 | 56.49 | |
| 2 | 2026-02-24 | Petro-Canada | 2.85 | 4.00 | 63.85 |
GST/HST receipts — questions
Does it work with receipts from any province?
Yes. It reads the tax amounts printed on each receipt rather than applying a rate, so mixed provinces are fine.
Is the vendor's GST/HST number captured?
When it's printed, it's added to the description so you have it for your records.
What currency is used?
CAD by default. Receipts in other currencies keep their own currency code. We don't convert them.
More conversions
UK VAT receipts
Get net, VAT, gross, VAT rate and the supplier's VAT number for every receipt, in pounds.
Openfreelancer receipts
Software, equipment, travel, meals and home-office costs, categorised and totalled, in an hour or less.
Openfuel receipts
Gallons, price per gallon, jurisdiction and total from every fuel receipt, totalled by state or province.
Openreceipt photos
Snap your paper receipts with your phone, drop the photos here and get a clean CSV or Excel file.
OpenCanada GST/HST receipts, one clean file.
10 receipts free, no signup.