Workbook — Real Estate · Created October 5, 2026 · 2 min read
Property Tax Assessment Tracker
Every notice in one table, and a flag on the year worth questioning.
An assessment notice is easy to file and forget. Kept year after year, the notices show how the land and building values have moved, what you really pay as a share of value, and when a jump is large enough to ask the assessor how it was reached.
What This Workbook Does
- One row per tax year with land value, building value, assessed total, exemptions and tax due.
- Year-over-year change on land and building separately, and the effective tax rate.
- An appeal check that flags any single-year increase above the threshold you set.
- Average annual increase and cumulative increases in assessed value and in tax due.
The average annual increase is compounded from the first and last values rather than averaged across the yearly percentages, and tax due is tracked separately because the rate can rise while the assessment stays flat.
How to Use It
- Enter one row per tax year, oldest first; each row is compared with the one above.
- Split land and building — they move for different reasons.
- Enter exemptions separately from the assessed total.
- Enter the tax rate from the notice, converted to a percentage if it is quoted per hundred or per thousand.
- Set the appeal review threshold to the single-year increase you consider worth questioning.
- When a year is flagged, ask for the comparable sales behind it well before the appeal deadline.
What It Will Not Do
Assessed value is not market value, and the relationship between them varies by jurisdiction. A large increase is not proof of an error — it is a reason to look at how the number was reached.