Farm Fuel Tax Exemption Excel - Free Template

1. Open the Fuel Log sheet and enter each fuel receipt on its own row. Use the purchase date, vendor, fuel type, litres purchased, and use type exactly as shown on the receipt.
2. Check the tax rates on the Tax Rules sheet before you enter or review a batch. That keeps the GST and provincial tax figures consistent across the workbook.
3. Record exempt litres and taxable litres for mixed-use fuel. If a 620-litre gasoline purchase is 70% farm use, enter 434 exempt litres and 186 taxable litres.
4. Review the Exemption Summary sheet after you finish a week, month, or quarter. Use it to confirm the totals before you file, claim, or archive the records.
5. Use the Notes column to capture details that matter later, such as field work, equipment use, or a delivery that explains the purchase.
6. Keep the Instructions sheet handy for your staff or family members. It shows the same process in one short reference tab, which reduces entry errors during busy season.

If you are a sole proprietor, family farm, or incorporated operation, this workbook helps you record fuel receipts as you buy them instead of sorting them at tax time. A spring seeding run with 12 diesel receipts, or a fall harvest month with 40 entries, is much easier to manage when the details are already in one sheet.

Where the log fits in the season

The Fuel Log sheet is the working tab. You enter purchase date, vendor, city, fuel type, use type, litres purchased, price per litre, and the tax lines, then review the exempt and taxable litre split before the month gets away from you.

Why the summary matters

The Exemption Summary sheet is the part you check before year-end or before handing records to your bookkeeper. If you have 18,000 litres of diesel for the year and 11,700 litres are farm exempt, the summary gives you the split without rebuilding it from receipts.

Who normally uses it

This is the kind of file a farm owner uses after fuel delivery, a bookkeeper uses during a GST review, or a spouse who helps with the books uses once a week. It is also useful when you have mixed-use purchases, such as a 620-litre gasoline buy where only part of the fuel is tied to exempt farm use.

The workbook is built for record support, not for guessing. The CRA expects you to keep enough detail to show what was purchased, when it was purchased, who sold it, and how the fuel was used, and you should keep those records for six years.

Tax rates shown in the file

The Tax Rules sheet reflects the Canadian structure you actually deal with: GST at 5% federally, plus provincial sales tax where it applies. In Ontario, that means 13% HST; in the Atlantic provinces, 15% HST; in Quebec, QST applies separately; and in provinces with PST, the provincial line is tracked on its own.

Why the split matters

If you buy 850 litres of diesel at $1.42 per litre, the pre-tax amount is $1,207.00. If 80% is exempt farm use, you would tag 680 litres as exempt and 170 litres as taxable, which makes the record far more defensible than a single vague note like “farm fuel”.

Practical filing point

For most farms, the cleanest approach is to keep the workbook aligned with your GST/HST filing period and your fiscal year. That way, the log supports the return, the input tax credit review, and any discussion of mixed-use fuel without forcing you to rebuild the numbers from scratch.

That same period-by-period tracking lines up neatly with a GST/HST remittance record, so the fuel log feeds the return instead of sitting apart from it.

The biggest problem is not the tax rate; it is the missing detail. A receipt with no vendor city, no use type, and no exempt-litre split is hard to defend, and a stack of 30 such receipts can turn into hours of rework when you are trying to finish the books.

What gets disallowed or delayed

If you claim the whole purchase as exempt without support, the error can show up as an overstated farm-use amount or an overstated tax claim. On a $9,600 annual fuel spend, a 10% classification mistake is $960 of fuel misallocated, and that is before anyone starts rechecking the tax lines.

The mixed-use trap

Mixed-use fuel is where people drift. A 620-litre gas purchase that should be split 70/30 but is entered as 100% exempt gives you a neat spreadsheet and a bad record, which is exactly the kind of problem that slows a review and creates unnecessary follow-up.

What wastes time at year-end

Another common issue is not reconciling the fuel log to the actual receipts. If you bought 4,500 litres during harvest and the workbook only shows 3,900, you lose confidence in the whole file and spend another evening hunting through emailed invoices and paper slips.

The workbook works best when you touch it on a fixed day, not when you “get around to it”. Many farms do the update right after the fuel delivery, or every Friday after the bank and cheque run, which keeps the log current without turning it into a weekend project.

Simple habits that stick

• Enter receipts the same day you receive them, while the vendor and litre amount are still in front of you.
• Use the Instructions sheet as your first stop each season, especially if someone new is helping with the books.
• Review the Exemption Summary once a month so you spot a bad split before it repeats for 20 more purchases.
• Keep the workbook with your other records for the CRA six-year retention period.

When a spreadsheet is no longer enough

If you are processing hundreds of fuel lines a year, buying from multiple sites, and trying to match inventory, payroll, and job costing at the same time, you may have outgrown a manual spreadsheet. At that point, a farm accounting system or a stronger AP workflow is usually the better move.