Heating Oil Budget Excel - Free Template

1. Read the Instructions sheet before entering data. It explains the pale yellow input cells, YYYY-MM-DD dates, Canadian currency formatting and the workbook legend.
2. Open Deliveries and enter a unique Delivery ID, delivery date, customer or property, contact, city, province and supplier. Image 2 shows the 23-column delivery register, including the visible fields from Delivery ID through Tank Fill %.
3. Enter tank capacity, previous meter reading, delivered quantity, price per litre, delivery fee and budgeted cost. The validation rules accept quantities from 0 to 10,000 litres, prices from $0 to $10 and fees from $0 to $1,000.
4. Select the full province name in Province and choose Paid, Pending or Partially Paid in Payment Status. The province selection retrieves the matching rate from TaxRates.
5. Check the calculated columns for Fuel Cost, Subtotal, Tax Rate, Tax, Total Cost, Variance, Status and Tank Fill %. Do not overwrite formula cells.
6. Review TaxRates and update editable reference rates only when you have confirmed the supplier's treatment and the applicable Canadian tax rules. Image 3 shows the province, rate and tax-type columns.
7. Use Summary for the annual review. Image 4 shows the 2026 budget summary, province breakdown and three charts covering delivery cost, litres and cost components.

A homeowner with an oil-fired furnace may use this workbook before the heating season to estimate deliveries and compare actual supplier invoices with the household budget. A property manager can use the same register for several rental properties, while a small fuel-delivery office can record customer properties, tank sizes and supplier charges without mixing one delivery with another.

The practical need usually appears in late summer, when you set a winter budget, and again after each delivery during the heating season. For example, a duplex in Montreal may receive 1,000 litres at $1.55 per litre plus a $35 delivery fee. The fuel cost is $1,550, the subtotal is $1,585, and the workbook applies the Quebec reference rate before comparing the total with the $1,800 budget.

Households and rental properties

The Customer / Property, Contact Name, City and Province columns let you distinguish a residence from a duplex or townhome. Tank Capacity and Previous Meter Reading add useful operating context: a 1,200-litre tank with a previous reading of 310 litres and a delivery of 890 litres tells you more than an invoice total alone.

Suppliers and office staff

An office manager at a property company can record Irving Energy, Ultramar, Petro-Canada or another supplier in the Supplier column, then retain the delivery ticket and invoice with the record. Payment Status is especially useful during a weekly accounts-payable review because Paid, Pending and Partially Paid accounts remain visible beside the calculated Total Cost.

Image 1 shows the Instructions sheet, which separates user-entry guidance from tax and records guidance. Image 2 shows the working register; its auto-filter and frozen header make it practical to review a long winter delivery list.

The TaxRates sheet is an editable reference, not a substitute for the supplier invoice or current CRA guidance. In the supplied workbook, Alberta and Manitoba use 5.000% GST, Ontario uses 13.000% HST, New Brunswick, Nova Scotia and Prince Edward Island use 15.000% HST, and Quebec uses 14.975% GST + QST.

The Deliveries formula uses VLOOKUP to find the selected province in TaxRates and applies that rate to the delivery subtotal. For an Ontario delivery with $1,080 of fuel and a $30 fee, the subtotal is $1,110; at 13%, tax is $144.30 and the calculated total is $1,254.30. If the budget is $1,320, the variance is negative $65.70 and the status is Under Budget.

What to verify on the invoice

Check whether the supplier has charged GST, HST, QST or another applicable amount, and whether delivery fees are taxable. The workbook's reference rate should agree with the transaction you are recording; do not force the sheet to reproduce an invoice by changing a rate without documenting why.

Records for Canadian bookkeeping

Keep the invoice, delivery ticket, supplier statement and payment record together. A registered business generally needs its supporting records for the CRA's six-year retention period. If the purchase belongs to a GST/HST registrant, the tax treatment and any input tax credit depend on the business use, registration status and invoice details.

The $30,000 small-supplier threshold is the key GST/HST registration threshold for many taxable businesses over four consecutive calendar quarters. It does not turn a household heating budget into a tax return, and personal heating oil is not automatically a business expense. For a sole proprietor reporting eligible business use on T2125, separate the business portion and retain the supporting calculation.

Image 3 shows the exact rates supplied with this workbook. Confirm them before use because the sheet is an editable reference and supplier billing can contain charges or treatments not represented by a single provincial percentage.

The most expensive error is often a quantity or unit mistake. Entering 890 instead of 890 litres is harmless if the column is clear; entering 890 gallons in a litre field can multiply the expected fuel cost dramatically. At $1.42 per litre, 890 litres costs $1,263.80 before a $25 fee, while an accidental entry of 3,368 litres would produce $4,782.56 of fuel cost.

Invoice totals that do not reconcile

People frequently record the fuel price but forget the delivery fee, or enter a tax-inclusive invoice amount as the pre-tax price. In the sample pattern, 890 litres at $1.42 plus a $25 fee gives a $1,288.80 subtotal. Applying 15% produces $193.32 tax and a $1,482.12 total; entering $1,482.12 as the price per litre would destroy every comparison.

Budget variance that sends the wrong signal

A budget must be recorded on the same basis as the calculated total. If the budget is pre-tax but Total Cost includes tax, every delivery appears over budget even when the fuel purchase was planned correctly. My practical preference is to budget the invoice total, including expected fees and tax, because that is the cash amount the household or property manager must pay.

Tax and payment details left stale

A copied row can retain the wrong province, supplier or Payment Status. A Quebec delivery left as Ontario changes the reference rate from 14.975% to 13.000%; on a $1,585 subtotal that changes the tax calculation by $31.29. A Pending invoice left as Paid also understates the amount still owed, even though the Summary focuses on cost rather than outstanding balance.

Another common failure is treating a blank or estimated tank reading as a precise measurement. Tank Fill % is calculated from delivered quantity divided by tank capacity, so a 750-litre delivery into a 1,100-litre tank gives 68.2%. It is a useful check, not proof that the tank was physically filled to that level. Keep the delivery ticket when the number matters.

Use one fixed time after every delivery rather than waiting for year-end. A five-minute routine on the day the supplier invoice arrives is enough: enter the date and ID, copy the ticket's litres and price, add fees, select the province, enter the budget and mark the payment status. This prevents six winter invoices from becoming a two-hour reconstruction exercise.

Use the workbook's controls consistently

• Keep dates in YYYY-MM-DD format so the date-based Summary chart remains readable.
• Use the Province dropdown instead of typing abbreviations such as ON or QC; the VLOOKUP requires the full province name.
• Enter currency as numbers, not text, so SUM, AVERAGE and variance calculations continue to work.
• Review red over-budget results immediately and green under-budget results during the monthly review.

After each entry, compare Total Cost with the supplier invoice and check that Payment Status matches the bank or accounts-payable record. At month-end, review Summary's Total Litres Delivered, Average Price per Litre, Total Heating Oil Spend and Total Variance. For example, four deliveries averaging 800 litres at $1.50 per litre represent $4,800 of fuel before fees and tax; that scale is large enough to investigate a $500 variance rather than simply accepting it.

Know when the file is no longer enough

This workbook is a sensible manual register for a modest list of properties and up to the prepared 106 delivery rows. Move to dedicated accounting, property-management or inventory software when several people need simultaneous entry, invoices must be matched automatically, payment balances need ageing, or you require audit history and user permissions. Until then, keep the workbook in a controlled folder, save a dated backup after each review and store source documents beside it.

Image 4 is the best monthly checkpoint: its provincial table and three charts turn individual delivery lines into a short management review without asking you to rebuild totals manually.