Property Tax Excel - Free Template

1. Open the Instalment Tracker sheet and review the sample rows before adding your own properties. The table has prepared operational rows from row 3 through row 102.
2. Complete the pale yellow input cells for each instalment: property ID, owner, municipality, province, address, roll number, tax year, annual levy, instalment number and due date.
3. Use a separate row for every due date. For example, four instalments for one property require four rows with the same property details and different instalment numbers and due dates.
4. After paying, enter the payment date, amount paid and payment method. Add a receipt number, municipal confirmation or cheque detail in Notes.
5. Leave Scheduled Amount, Status, Days Late and Reference Tax Rate as formula outputs. The scheduled amount is calculated as annual levy divided by four.
6. Open the Dashboard to review total levy, scheduled instalments, paid amounts, outstanding balance, completion percentage, paid count, overdue count and average instalment.
7. Read the Instructions sheet before relying on the municipality reference table. Confirm official due dates, levies and payment instructions with the relevant municipality.

A homeowner may use this spreadsheet while organizing several municipal tax bills, while a landlord may use it to monitor taxes for rental properties. A bookkeeper at a property-holding corporation can also use it during the monthly close, especially when bank activity shows a municipal payment but the supporting notice is stored elsewhere.

The workbook is designed around one row per instalment rather than one row per property. That distinction matters when a Toronto property has four due dates, a Vancouver property has two, and a municipality sends a revised notice during the year. The same Property ID can appear on multiple rows while the Instalment No. and Due Date identify the individual obligation.

A practical owner example

Suppose a Toronto property has a 2026 Annual Tax Levy of $6,240. The formula in Scheduled Amount divides that levy by four, producing $1,560 per instalment. If you enter $1,560 in Amount Paid, the Status becomes Paid; if the due date passes with no sufficient payment, the formula reports Overdue and calculates the number of days late.

Image 1 shows the Instalment Tracker layout, including Property ID, municipality, province, roll number, annual levy, due date, payment fields, status and notes. The table is filtered from row 2 and the panes freeze above the data, which makes reviewing a longer list easier.

When the dashboard helps

At month-end, a treasurer or bookkeeper can open image 2 and see the combined position instead of checking each row manually. The Dashboard summarizes paid and outstanding amounts, counts paid and overdue instalments, calculates the average scheduled amount and groups scheduled amounts by municipality.

Property tax is administered by the municipality, not by the CRA. That means the official bill, assessment notice, payment schedule and accepted payment methods come from the relevant city, town or regional municipality. A Canadian workbook can organize those records, but it cannot replace the municipal notice or calculate an official levy.

Municipal schedules differ. The Dashboard sample reference table lists Toronto, Montreal, Vancouver, Calgary, Ottawa and other municipalities with typical frequencies such as 2 or 4 instalments. These entries are lookup references only. For example, the workbook shows Toronto with an indicative 0.67% reference rate and Montreal with 0.98%; neither figure is an official rate for calculating your property tax.

Use the municipal bill as the authority

If a municipality issues four instalments for a $4,875 levy, a simple equal split would be $1,218.75 each, but the actual bill may use a different schedule or adjustment. This template divides Annual Tax Levy by four in Scheduled Amount, so you should enter the municipal instalment amount or adjust your process when the official schedule is not an equal quarter.

Do not treat property tax as GST or HST collected from a customer. The federal GST rate is 5%, and HST is 13% in Ontario and 15% in New Brunswick, Nova Scotia, Prince Edward Island, and Newfoundland and Labrador, but ordinary municipal property-tax charges are not sales invoices simply because you record them in Excel.

Records for owners and landlords

For a rental property, retain the tax bill, payment confirmation and property records with the information used for the T776 rental statement. For a sole proprietor using part of a property for business, only the supportable business portion belongs in business records. Keep source documents for at least six years where the CRA record-retention rule applies, and protect roll numbers and addresses because they identify property and ownership information.

The most expensive error is often not a wrong formula; it is a payment recorded against the wrong property. A bookkeeper handling six properties can easily enter a $2,400 municipal payment on the wrong roll number. The Dashboard may still balance in total, but the affected property appears unpaid and the correct property appears overpaid.

When one row hides several obligations

Another common failure is entering one annual row instead of one row per instalment. A $9,600 annual levy may involve four $2,400 due dates. If only the annual amount is recorded, you lose the payment history, cannot identify which instalment is overdue and make the Dashboard's instalment counts meaningless.

Do not mark a payment as complete merely because money left the bank. The Status formula considers an instalment Paid only when Amount Paid is at least Scheduled Amount. If the scheduled amount is $1,560 and you record $1,500, the row is not Paid; a $60 shortfall can remain hidden if you do not compare the payment confirmation with the municipal statement.

Dates and confirmations cause avoidable rework

Entering 2026-03-31 as a text string instead of a real date can prevent reliable overdue testing. The workbook uses TODAY() to compare the current date with Due Date, so use the YYYY-MM-DD date format shown in the Instructions sheet. A missed or ambiguous date can create a false Upcoming result or delay follow-up by several days.

Finally, notes such as paid or done are weak evidence. Record the municipal portal confirmation, cheque number or bank reference instead. If three properties each require 20 minutes to investigate a missing confirmation, one careless month-end entry can cost an hour before you even contact the municipality.

The spreadsheet works best when you attach it to an existing banking routine rather than opening it only after a missed due date. Set a fixed review, such as the first business day of each month, and compare upcoming Due Date values with the municipal notices and the bank account.

Use a short repeatable check

• Review rows with an upcoming due date within the next few weeks and confirm the cash is available.
• After each payment, enter Payment Date, Amount Paid and Payment Method before filing the confirmation.
• Filter Status for Overdue and investigate every result rather than relying on the Dashboard total alone.
• Check that the roll number and Property ID agree with the municipal notice before saving the row.

For example, a landlord with eight properties and four instalments each has 32 expected rows in a year. A 15-minute Friday review can confirm two or three recent payments, while a quarterly review may leave 24 unverified records and make a $3,000 missing payment harder to trace.

Keep the formulas intact

Use the pale yellow input cells for changes and leave the formula columns in place. The workbook uses SUM for totals, COUNTIF for paid and overdue counts, AVERAGE for the average instalment, SUMIF for municipality totals and VLOOKUP to bring the indicative reference rate into the tracker. Copying over those formulas with typed values removes the automatic review.

Move to property-management or accounting software when you need automated municipal imports, approval workflows, recurring payment instructions, document attachments, user permissions or more than 100 prepared tracker rows. Until then, a disciplined weekly or monthly review is more reliable than an elaborate file that nobody updates.