HST GST Receipt Tracking Template

If you run a business in Canada and pay HST or GST on purchases, the tax you pay is not just a footnote. It is money you can usually recover as Input Tax Credits on your next GST/HST return. Recovery only works when you can prove what you paid, when, and to whom. A loose shoebox of thermal-paper receipts will not survive a CRA review, and a cluttered spreadsheet quietly shrinks the credit you are entitled to.

An HST/GST receipt tracking template keeps that proof in one place. Each row records one taxable purchase with the same columns: date, vendor, amount, HST, GST, total, the tax actually paid, and a notes field. Filled in weekly, the workbook becomes the source your bookkeeper uses at filing time. This guide explains the columns, the daily habit, and the customization options that make the template fit your business.

What the template is

The HST/GST receipt tracking template is a structured workbook that turns each receipt into one row. You can keep it as a single sheet or split it into monthly tabs once volume grows, but the columns stay the same. Every row carries enough information to satisfy a CRA or Revenu Québec review without anyone having to dig back through email, photo albums, or shoeboxes.

The template is also a reconciliation tool. When your bookkeeper prepares the GST/HST return, they add up the tax you paid on eligible business purchases and subtract it from the tax you collected. A clean template makes that math straightforward. A messy one quietly shrinks your claim or triggers follow-up questions at filing time. Ten minutes a week keeping the template current is cheaper than recovering missed credits at year end.

Fields and columns

The columns below are the ones most small Canadian businesses need. Add more if your situation calls for it, but resist over-engineering the first version. A template you actually fill in beats a comprehensive one you abandon in week two.

• Date: the date the purchase was made, taken straight from the receipt. Consistent date format matters; pick one (YYYY-MM-DD works well for sorting) and stick with it.
• Vendor: the merchant name exactly as printed on the receipt. Avoid abbreviations like "Amzn" or "Staples #123" unless the official invoice uses the same wording.
• Amount: the net subtotal before tax, in Canadian dollars. For foreign-currency receipts, convert at the rate your bookkeeper uses and note the conversion in the Notes column.
• HST: the Harmonized Sales Tax portion on receipts from HST provinces (Ontario, New Brunswick, Nova Scotia, PEI, Newfoundland and Labrador). Often a single line, sometimes a 5% federal portion plus a provincial rate.
• GST: the 5% federal Goods and Services Tax on receipts from non-HST provinces (Alberta, BC, Manitoba, Saskatchewan, plus the territories). Quebec receipts list GST separately from QST.
• Total: the full amount charged including tax. Equals Amount + HST + GST (or Amount + GST for non-HST regions).
• HST/GST paid: a single column showing the total tax actually paid. This is the number that flows into the ITC claim on your return.
• Notes: project, client, mileage, meal attendees, foreign currency conversion, or partial business use percentage, whatever helps you or your bookkeeper later.

How to use it step by step

The fastest way to keep the template current is to capture receipts as they come in and add rows in small batches. A 15-minute Friday afternoon review is usually enough for a small business or freelancer.

1. Capture every receipt the same day. Snap a photo, email it to a dedicated inbox, or scan it into a folder named by month. Thermal paper fades within a year; if the receipt matters, capture it now.
2. Extract the fields with SlipSheet. Drop the image in and pull out the date, vendor, amount, tax, and total in one pass. Each receipt becomes a clean row you can paste into the template instead of typing line by line.
3. Paste and verify. Review the row against the original image. Confirm the date format, the vendor spelling, and that the HST and GST add up to the Total. Five seconds of checking now saves a back-and-forth later.
4. Categorize once. Use the Notes column for project, client, or category tags. A consistent tagging system means year-end filtering is one filter, not a week of cleanup.
5. Reconcile monthly. At month end, run a quick sanity check: do the HST and GST totals match what your accounting software or bank feed shows for that period? If not, you are missing a row.
6. Hand it off clean. When your bookkeeper prepares the GST/HST return, the template is the support schedule. No hunting, no retyping, no missing credits.

Customization options

The base template covers most small Canadian businesses. A few common adjustments fit it to a specific province, project, or claim.

• Province-specific tax columns. Quebec businesses usually add a QST column (9.975%) and keep GST separate, since the two are claimed on different returns. BC and Saskatchewan can add their provincial sales tax columns if they prefer the full breakdown.
• Project or client tags. Contractors and agencies add a Project or Client column so they can invoice a client for reimbursable expenses at month end. A short tag (three or four letters) works better than a free-text field.
• Business use percentage. For partly personal expenses (cell phone, home internet, mixed-use vehicle), add a Business % column. The HST/GST paid becomes (Tax x Business %), and only that portion flows to the ITC claim.
• ITC eligibility flag. Add an Eligible column (Yes/No) for purchases that are not fully ITC-eligible: meals and entertainment at 50%, certain motor vehicle expenses, and club memberships. Your bookkeeper overrides this at filing time, but flagging the edge cases saves review time.
• Receipt link column. Once you store digital copies of every receipt, add a column with a link or filename so anyone reviewing the row can jump straight to the source image.

Common pitfalls to avoid

A template is only as useful as the habits around it. A few things consistently trip people up the first time they track HST/GST in a spreadsheet.

• Mixing tax-inclusive and tax-exclusive totals. Make sure every Amount is net of tax and every HST/GST is the tax portion. A receipt showing "Total: $113.00, HST: $13.00" should be entered as Amount $100.00, HST $13.00, Total $113.00. Reversing these silently shrinks the ITC claim.
• Letting the vendor column drift. "Starbucks" in one row, "Starbucks Coffee #1234" in another, "Sbux" in a third makes vendor-level reporting noisy. Pick the official name on the receipt and use it everywhere.
• Forgetting small recurring purchases. Subscriptions, app store purchases, and monthly domain renewals are easy to skip because there is no paper receipt. Set a monthly reminder, or sync them from your bank feed.
• Claiming tax on exempt supplies. Some business expenses are zero-rated or exempt (basic groceries, certain medical supplies, residential rent). Verify before assuming every line is ITC-eligible. Your bookkeeper is the final authority.
• Holding receipts without digitizing. Thermal receipt paper fades. Photograph or scan within the first month; CRA requires supporting documents for six years from the end of the last tax year they relate to.

A working HST/GST receipt tracking template does not need to be fancy. It needs to be complete, consistent, and easy to defend if anyone asks. Capture the receipt, capture the fields, run a monthly sanity check, and let your bookkeeper handle the heavy lifting at filing time. The credits are already yours; the template just keeps them. SlipSheet can speed up the capture step by reading the receipt and laying out the columns in one pass, so the only real work left is the review and the monthly reconciliation.