Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesReal Estate & PropertyRental Property ManagementHOA Dues and Violations Tracker

SpreadsheetRental Property ManagementFree

HOA Dues and Violations Tracker

Track assessments, payments, late fees and delinquencies for every unit, and log covenant violations from courtesy letter to resolution.

Shown with sample data

Colour

HOA Dues and Violations Tracker

Track assessments, payments, late fees and delinquencies for every unit, and log covenant violations from courtesy letter to resolution.

Collection rate
50%
Total owed
$5,875
Accounts late or delinquent
4
Delinquent 90+ days
1
Open violations
4
Overdue cures
3
Fines imposed
$250
Total owed by unit
  • 102$425
  • 103$1,175
  • 105$1,175
  • 106$1,150
  • 108$800
  • 109$1,150

How to use it

  1. 1Set the late fee and grace period from your governing documents on Settings.
  2. 2List every unit with owner, assessment due, any special assessment and the due date.
  3. 3Record payments as they arrive; balance, days late and late fee calculate.
  4. 4Log each violation with the notice sent, the cure-by date and any fine.
  5. 5Review delinquent accounts and overdue violations at each board meeting.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Self-managed associations live or die by two lists: who has paid and who is breaking the rules. The dues sheet tracks each unit’s regular and special assessments, payments, balance, days late and late fee from your settings, and flags accounts in the grace period, late or delinquent over 90 days. The violations log records each violation by type with notice level, cure date and fine, and flags overdue cures so enforcement stays consistent and fair.

Who it’s for

  • Self-managed HOAs and condo associations
  • Treasurer reports to the board
  • Consistent covenant enforcement
  • Preparing delinquency lists for collections

What’s included

  • Dues sheet: Assessments, payments and status for every unit.
  • Violations sheet: Each violation from first notice to resolution.
  • Settings sheet: Late fee and grace period from your governing documents.

How to use it

  1. 1Set the late fee and grace period from your governing documents on Settings.
  2. 2List every unit with owner, assessment due, any special assessment and the due date.
  3. 3Record payments as they arrive; balance, days late and late fee calculate.
  4. 4Log each violation with the notice sent, the cure-by date and any fine.
  5. 5Review delinquent accounts and overdue violations at each board meeting.

Tips

  • Follow your CC&Rs, bylaws and state HOA law exactly on notices, hearings and fines; most states require notice and an opportunity to be heard before a fine.
  • Treat every owner the same way: inconsistent enforcement is the most common defence against HOA fines.
  • Many states regulate HOA late fees, interest and collection steps, and some require a payment plan offer before liens or foreclosure.

Questions

How are late fees calculated here?

A flat late fee from Settings is added once the account is more than the grace period days past due and still has a balance. Change the formula if your documents use interest or a percentage.

When is an account delinquent?

This tracker marks accounts more than 90 days past due as Delinquent 90+, a common point for referral to collections; your governing documents may set a different trigger.

What are the usual HOA violation steps?

A courtesy letter, a first formal notice with a cure period, a second notice, a hearing before the board, then a fine or other remedy, as set out in your governing documents and state law.

Related searcheshoa dues trackerhoa assessment trackerhoa violation loghomeowners association spreadsheethoa delinquency reportcondo association dues tracker

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
3
Setup
20 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetRental Property ManagementFree

HOA Dues and Violations Tracker

Track assessments, payments, late fees and delinquencies for every unit, and log covenant violations from courtesy letter to resolution.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Rental Property Management
Sheets
3
Setup
20 min
Level
Intermediate
Price
Free

Your copy is private to you.

More rental property management templates

View all
Rent Roll
Task
JunJulAugSepOct
12 Oak Street
12 Oak Street
12 Oak Street
48 Elm Avenue
7 Pine Court
SpreadsheetRental Property Management

Rent Roll

Units, tenants, lease dates, rent, deposits and payment status across your portfolio.

10 min setupPreview
Tenant Rent Ledger2 sheets

Charged

$11,250

Collected

$9,300

Outstanding

$1,950

ABCD
1DateTenantTypeDescription
2Oct 1J. Alvarez - Unit 1Rent chargeOctober rent
3Oct 1M. Chen - Unit 2Rent chargeOctober rent
4Oct 1R. Okafor - Unit 3Rent chargeOctober rent
5Oct 1S. Novak - Unit 4Rent chargeOctober rent
Ledger
SpreadsheetRental Property Management

Tenant Rent Ledger

Charges, payments and late fees for every tenant, with a balance per tenant and your collection rate.

10 min setupPreview
Rental Property Income & Expenses2 sheets

Income

$7,575

Expenses

$2,577

Net cash flow

$4,998

Net cash flow by property
$3,485
$913
$600
12 Oak Street7 Pine Court48 Elm Avenue
SpreadsheetRental Property Management

Rental Property Income & Expenses

Track rent and property expenses by category for cash flow and tax time.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ