Limited time: 90% off your first 6 months on Bookkeeping plans Claim offer
Municipal Features

How to Use Municipal Property Tax — Setup & Configuration

Intermediate 9 min read 3 views

The Municipal Property Tax module is a complete system for managing property assessments, tax billing, collections, and enforcement. Before you can bill taxpayers, you need to configure your municipality's province, GL accounts, mill rates, and classifications.

This guide walks through the Dashboard and all Configuration pages, step by step, in the order you should set them up.


Getting Here

  1. Open the main sidebar and select a Bookkeeping Client.
  2. In the client sidebar, expand Municipal Government, then expand Property Tax.
  3. Click Dashboard to see the overview.

The sidebar groups all Property Tax features into five sections:

Section Pages
Properties & Assessments Properties, Property Owners, Assessment Roll, Assessment Appeals, Exemptions, Property Transfers
Billing & Notices Tax Notices, Notice Templates, Supplementary Notices, Billing Cycle, Requisitions, Local Improvements
Collections & Arrears Tax Collection, Batch Import, Tax Arrears, Interest & Penalties, Payment Plans, Tax Sales, Write-Offs, Credits & Refunds
Reporting & Compliance Receivables, Statements, Tax Roll Report, Tax Certificates, Reconciliation, Receivable Classification, Doubtful Accounts, Period Accruals, Multi-Year Comparison
Configuration Mill Rates, Province Config, Year-End Rollover, Settings

The Property Tax Dashboard

When you first open Property Tax, you land on the Dashboard. This page gives you a high-level snapshot of the entire tax system.

Tax Year Selector

At the top-right of the dashboard, a dropdown lets you switch between tax years. The default year comes from your fiscal year-end setting in Settings. All stats, notices, and arrears data update when you change the year.

Top Metrics

Four stat cards sit across the top of the page:

Metric What It Shows
Total Assessed Value The sum of all property assessed values for the selected year, with a count of total properties.
Tax Levy The total tax amount billed across all notices for the selected year.
Collection Rate The percentage of billed taxes that have been collected, shown as a progress bar.
Outstanding Arrears The total unpaid balance across all overdue accounts, with a count of accounts in arrears.

Property Classification Breakdown

Below the metrics, a card shows the distribution of properties by classification: Residential, Commercial, Industrial, and Farmland. Each tile shows the count and the percentage of the total.

Quick Access Tiles

Four clickable cards let you jump directly to the most-used pages:

  • Assessment Roll — View and manage property assessments.
  • Tax Notices — Generate and send tax bills.
  • Collection — Record tax payments.
  • Arrears — Manage outstanding balances.

Recent Activity Tabs

Two tabs at the bottom of the page show recent activity:

  • Recent Notices — A table of the latest tax notices with notice number, property, amount, status, and due date. Click any notice number to open its detail page. An Export button downloads the list.
  • Tax Arrears — A table of the most significant arrears accounts with property, tax year, balance owing, status, and tax sale eligibility. Click Manage to go to the Arrears page. An Export button downloads the list.

Additional Quick Actions

Below the tabs, two more cards give you shortcuts:

  • Mill Rates — A card showing the current tax year and a button to Manage Mill Rates.
  • Tax Exemptions — A card with a button to Manage Exemptions.

These cards mirror the Quick Access Tiles and give you an alternate way to reach key configuration pages without using the sidebar.


Follow this order when setting up a municipality for the first time:

  1. Province Config — Select your province to load default rules.
  2. Settings — Configure GL accounts, classifications, charge rules, fiscal year settings, and automation.
  3. Mill Rates — Define tax rates for each property classification.
  4. Properties & Owners — Add properties and property owners (see the Properties & Owners guide).
  5. Assessment Roll — Import or enter assessed values (see the Assessments guide).

Province Configuration

Path: Configuration → Province Config

Property tax legislation varies by province. This page lets you select your municipality's province and apply standard assessment classifications, rate caps, and billing defaults.

Select Your Province

  1. Open the Province Configuration page.
  2. Use the Province / Territory dropdown to select your province (e.g., Ontario, British Columbia, Alberta).
  3. Click Save Province.

A badge at the top of the page shows the currently selected province.

Apply Province Defaults

Once a province is selected, a Province Defaults card appears. It shows:

  • Assessment Classifications — Standard property classes for the province (e.g., Residential, Commercial, Industrial, Farmland, Multi-Residential, Pipeline, etc.).
  • Rate Caps / Limits — Any statutory limits on tax rate increases per class.
  • Billing Timelines — Standard due dates, installment schedules, and notice periods required by provincial legislation.
  • Regulatory Templates — Standard notice templates and compliance requirements.

Click Apply All Defaults to load these into your municipality's configuration. You can customize them later in Settings.

ℹ Info: Applying defaults does not overwrite existing data. It only sets options that have not been configured yet.


Settings

Path: Configuration → Settings

The Settings page is the central configuration hub. It is organized into five tabs. A Save Settings button at the top-right persists all changes. A banner at the top shows whether the module is configured (green) or needs setup (yellow).

Configuration Status Banner

At the top of the page, a banner tells you if the module is ready:

  • Setup Required (yellow) — The GL Accounts tab has not been fully configured. The system cannot post journal entries yet.
  • Configured (green) — GL accounts are mapped and the module is ready to post entries.

Tab 1: General

This tab covers province, payment, billing schedule, document numbering, and charge caps. It is organized into four cards:

Province & Payment Card

Setting What It Does
Province Select the province or territory (AB, BC, MB, NB, NL, NS, NT, NU, ON, PE, QC, SK, YT). Determines applicable tax legislation and rules.
Payment Allocation Method How payments are applied across outstanding years: Oldest Year First, Newest Year First, or Proportional.
Certificate Validity (Days) How many days a tax certificate is valid after issuance (default 30).
Tax Sale Minimum Years Years of arrears before a property becomes tax-sale-eligible (default 3).

Tax Year & Billing Card

Setting What It Does
Current Tax Year The active tax year. Defaults to the client's fiscal year. Override only if needed.
Fiscal Year-End Month The month the fiscal year ends (1–12). Synced from the client profile.
Final Billing Month Which month final tax notices are issued (default June).
Interim Billing Toggle on if your municipality issues interim (mid-year) tax notices.
Interim Billing Month When interim notices are issued (default March). Only shown if Interim Billing is on.
Interim Installment Months Comma-separated month numbers for interim due dates (e.g., "2,3").
Arrears Transfer Eligibility When unpaid notices become eligible for arrears transfer: N days after due date, First day after fiscal year-end, or Last day of fiscal year-end.
Arrears Transfer Days If using days-after-due, how many days before transfer (default 90).

Document Numbering Card

Setting What It Does
Notice Prefix Prefix for tax notice numbers (default "TN").
Next Notice # The next sequential notice number to use.
Certificate Prefix Prefix for tax certificate numbers (default "TC").
Next Certificate # The next sequential certificate number to use.

Charge Rules Card

Setting What It Does
Cumulative Charge Cap Maximum total charges (interest + penalties) allowed on a single arrear account. If all charge rules would exceed this cap, they are reduced pro-rata. Leave blank for no limit.

Tab 2: GL Accounts

This tab maps every tax transaction to the correct general ledger account. Each field has a searchable dropdown that shows account number and name from your chart of accounts. It is organized into two cards:

GL Accounts Card

Setting What It Maps Debit/Credit
Tax Receivable Account AR for property tax receivables. Required. DR when notices are posted.
Tax Revenue Account Revenue for tax levy income. Required. CR when notices are posted.
Collection Bank Account Bank account for tax payments. Required. DR when payments are collected.
Arrears Receivable Account AR for taxes moved to arrears. DR when taxes move to arrears.
Penalty Revenue Account Revenue from late-payment penalties. CR for penalties.
Interest Revenue Account Revenue from interest charges. CR for interest.
Certificate Fee Revenue Account Revenue from tax certificate fees. CR for certificate fees.
Write-Off Expense Account Bad debt expense for write-offs. DR when taxes are written off.
Requisition Payable Account Payable for requisition remittances. DR when remitting to boards.
Tax Sale Revenue Account Revenue from tax sale proceeds. CR for tax sale proceeds.

AFDA & Deferred Revenue Accounts Card

Setting What It Maps
Allowance for Doubtful Accounts Contra-asset account. CR when provisioning for bad debts (PS 3510).
Bad Debt Expense Account Expense account. DR when provisioning for bad debts.
Deferred Tax Revenue Account Revenue account for deferred revenue recognition on interim billing.

⚠ Warning: The Tax Receivable Account, Tax Revenue Account, and Collection Bank Account are required. The system cannot post journal entries without them.


Tab 3: Tax Year Rules

This tab configures year-specific tax rules. Use the Tax Year dropdown at the top to select which year you are configuring. The tab has three cards:

Minimum Tax Rules Card

Sets a floor amount per classification or per mill rate. Even if the calculated tax is lower, the property is billed at least this amount.

  1. Click Add Rule.
  2. Select a Classification and optionally a specific Mill Rate (leave Mill Rate blank to apply the minimum to the total notice).
  3. Enter the Minimum Amount in dollars.
  4. Add a Description (optional).
  5. Click Save.

The table shows: Classification, Scope (Total Notice or a specific rate), Minimum amount, and Description. Click the trash icon to delete a rule.

Percent-of-Value Rules Card

Converts assessed value to taxable value per classification. For example, some provinces tax farmland at 55% of assessed value and residential at 80%.

The card shows an input field for each active parent classification. Enter a percentage (0–100) for each. Leave blank for 100% (fully taxable). Click Save Percent-of-Value Rules to persist.

Penalty & Interest Rules Card

This card shows a read-only summary of all charge rules for the selected tax year: Type (penalty/interest badge), Name, Method, Rate, Days After Due, and Cap.

Click Manage Penalty & Interest Rules to jump to the dedicated Interest & Penalties page, where you can create, edit, and test charge rules in detail. (See the Collections, Arrears & Enforcement guide for full charge rule documentation.)


Tab 4: Classifications

This tab manages property tax classifications — the categories that determine which mill rate applies to a property.

The page shows a hierarchical list. Parent classifications (e.g., "Residential") can have child sub-classifications (e.g., "Improved" and "Vacant"). Each shows its slug, name, and whether it is a System or Custom classification.

To add a classification:

  1. Click the Add Classification button.
  2. Enter a Name (e.g., "Commercial").
  3. Optionally enter a Description.
  4. If this is a sub-classification, select a Parent from the dropdown.
  5. Click Save.

To delete a classification: Click the trash icon on the row. System classifications that are in use cannot be deleted. Custom classifications can be removed if no assessments reference them.

Classifications appear in dropdowns throughout the system — Assessment Roll, Mill Rates, Exemptions, and more.

ℹ Info: Classifications auto-seed when first accessed if the list is empty.


Tab 5: Automation

This tab has manual trigger buttons for background jobs:

Button What It Does
Process Charges Calculates and posts overdue penalty and interest charges for all accounts. Check Dry Run to preview without posting.
Transfer Arrears Moves eligible unpaid balances to the arrears ledger based on the arrears transfer rules configured in the General tab. Check Dry Run to preview without posting.

⚠ Warning: These actions post real financial transactions. Always run a dry run first and review the results before posting.


Mill Rates

Path: Configuration → Mill Rates

Mill rates determine how much tax each property pays. A mill rate is the amount of tax per $1,000 of taxable assessed value.

Tax Formula:

$$ \text{Tax} = \frac{\text{Taxable Assessed Value}}{1{,}000} \times \text{Mill Rate} $$

For example, a property with a taxable value of $250,000 and a mill rate of 3.423 would pay:

$$ \frac{250{,}000}{1{,}000} \times 3.423 = $855.75 $$

The Mill Rates Table

The page shows a table of all mill rates for the selected tax year. Use the year dropdown at the top to switch between years.

Column What You See
Classification The property class this rate applies to. Shows parent › child for sub-classifications.
Rate Name A label for the rate, e.g., "Municipal," "Education," "Library."
Mill Rate The rate value in mills (e.g., 3.423).
Tax Year The year this rate is effective for.
Revenue Account The GL revenue account where tax from this rate is posted.
Description Any notes about the rate.
Actions Edit and Delete buttons.

Summary metrics above the table show: number of unique classifications, total rates configured, and the average mill rate.

Creating a Mill Rate

  1. Click the Create Mill Rate button.
  2. The create dialog opens. Fill in the fields:
Field What To Enter
Classification Select from the dropdown. If sub-classifications exist, they appear indented under their parent. Required.
Tax Year The year this rate applies to. Defaults to the current fiscal year. Required.
Rate Name A label like "Municipal," "Education," or "Library." Required.
Mill Rate The rate in mills. Enter a decimal like 3.423. The formula is Taxable Value ÷ 1,000 × Mill Rate. Required.
Revenue GL Account Optional. The revenue account for this specific rate. If left blank, the default from Settings is used. Use the searchable dropdown to find the account.
Description Optional notes about this rate.
  1. Click Save.

Editing a Mill Rate

  1. Click the pencil icon on any row.
  2. The same form appears pre-filled with the current values.
  3. Make changes and click Update.

Deleting a Mill Rate

Click the trash icon on any row. The rate is deleted immediately after confirmation.

⚠ Warning: Deleting a mill rate that has already been used to calculate tax notices may affect historical reporting. Consider setting a rate to zero instead.

How Multiple Mill Rates Work

A property can be subject to multiple mill rates. For example, a residential property might have:

  • Municipal rate: 2.500 mills
  • Education rate: 1.200 mills
  • Library rate: 0.150 mills

The total tax is the sum of all applicable rates. Each rate can post to a different GL revenue account for proper fund accounting.

Mill rates are applied per classification. If you have "Residential," "Commercial," and "Industrial" classifications, you typically create at least one rate for each.


Next Steps

Once you have completed the setup:

  • Province selected
  • GL Accounts mapped
  • Classifications defined
  • Tax Year Settings configured
  • Charge Rules created
  • Mill Rates entered

You are ready to move on to adding properties, owners, and assessments. See the Properties, Owners & Assessments guide.

Was this article helpful?

Get help

Questions & Answers

Ask a question about this article and our team will reply.

0 answered
No questions yet. Be the first to ask about this topic.

Ask a question

Questions are reviewed before they're answered and published.

Never published. We'll only use it if we need to follow up.