Get the template — real downloads, no email gate
Most pages promising a free HOA violation log end at a form asking for your email address. This one does not. The full template is available two ways: download it as CSV or Excel below — the Excel version ships with the Notice stage and Status dropdowns already configured — or copy the column structure straight from the table on this page. Either way you have a working violation log in about ten minutes. The columns cover what a small self-managed board actually needs — who, where, which rule, which notice stage, and the deadlines that keep enforcement fair and defensible.
Each row is one case, tracked from first observation through cure or hearing. The three example rows show a realistic mix: a courtesy notice for trash bins, a lawn case cured before re-inspection, and an unapproved shed that has escalated to a second notice with a hearing requested.
If you would rather build the sheet by hand, the raw CSV header row is below — paste it into cell A1 and split on commas.
Case #,Lot,Owner,Rule cited (section),Date observed,Violation summary,Notice stage,Notice sent date,Delivery method,Cure deadline,Re-inspect date,Status,Fine recorded,Notes
| Case # | Lot | Owner | Rule cited (section) | Date observed | Violation summary | Notice stage | Notice sent date | Delivery method | Cure deadline | Re-inspect date | Status | Fine recorded | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-013 | 8 | R. Whitfield | CC&R 5.4 (unapproved structure) | 2026-06-11 | Shed installed without ARC approval | Second notice | 2026-07-01 | Certified mail | 2026-07-31 | 2026-08-01 | Open | $50 | Owner requested hearing 7/10; board scheduled 7/28 |
| 2026-014 | 17 | J. Alvarez | CC&R 4.2 (trash containers) | 2026-07-02 | Bins at curb three days after pickup | Courtesy notice | 2026-07-03 | 2026-07-17 | 2026-07-18 | Open | $0 | Second occurrence this year; photo saved to shared drive | |
| 2026-015 | 42 | M. Okafor | CC&R 6.1 (lawn maintenance) | 2026-06-20 | Front lawn overgrown well past community standard | First notice | 2026-06-24 | First-class mail | 2026-07-08 | 2026-07-09 | Cured | $0 | Mowed before re-inspection; closed 7/9 |
HOA violation log
One row per case, from first observation through cure or hearing, with three example rows. The Excel version includes Notice stage and Status dropdowns.
Set it up in about ten minutes
The instructions below are written for Google Sheets, with the Excel equivalents at the end. If you took the Excel download above, the dropdowns in step 3 are already configured and you only need the conditional-formatting rule. Two pieces of configuration do most of the work: a conditional-formatting rule that turns a row red when its cure deadline has passed and the case is still open, and dropdown lists that keep the Notice stage and Status columns consistent so the sheet stays sortable.
GOOGLE SHEETS SETUP
1. Import the template
- Download the CSV version above, then in a new spreadsheet:
File > Import > Upload the file.
- Or paste the raw header line from the first section into cell A1
and use Data > Split text to columns.
- If importing, choose "Replace current sheet" and comma as the separator.
2. Flag overdue cure deadlines
- Select A2:N1000.
- Format > Conditional formatting.
- Under "Format cells if" choose "Custom formula is" and enter:
=AND($J2<TODAY(), $J2<>"", $L2<>"Cured", $L2<>"Closed")
- Pick a red fill. The $ before J and L locks those columns so the
whole row lights up, and the status check stops flagging cases
that are already resolved.
- If you add more rules later, keep the most specific rule at the
top of the list — Sheets applies the first matching rule.
3. Add dropdowns for Notice stage and Status
- Select column G (Notice stage), then Data > Data validation > Add rule.
- Criteria "Dropdown", values: Courtesy notice, First notice,
Second notice, Hearing.
- Repeat for column L (Status), values: Open, Cured,
Hearing scheduled, Closed.
EXCEL EQUIVALENTS
- Import: Data > From Text/CSV, or paste and run Text to Columns.
- Overdue flag: Home > Conditional Formatting > New Rule >
"Use a formula to determine which cells to format", same formula.
- Dropdowns: Data > Data Validation > Allow: List.Using the log week to week
When a violation is observed, add the row immediately — date observed, the rule section quoted from your governing documents, and a factual one-line summary. Cite the actual section number, not a paraphrase like "yard looks bad." If the case ever reaches a fine or a hearing, the citation in this column is the one the owner and, potentially, a lawyer will check against your declaration.
Once a week, sort by cure deadline. The conditional-formatting rule will have turned overdue open cases red. Re-inspect those lots: if the violation is cured, set Status to Cured and note the date; if not, the board decides whether to advance the case to the next notice stage. When a case advances, update Notice stage and Notice sent date, and record the previous stage and its dates in Notes — otherwise the update silently overwrites the history you may later need. Advancing should always be a deliberate board decision, never a reflex.
Apply the same sequence to every lot for the same rule. A log that shows lot 8 getting three notices while lot 42 was fined on first observation is the raw material of a selective-enforcement complaint; the guide on what selective enforcement is and how boards protect themselves covers this in depth. For the wording of the letters, see the guide on how to send an HOA violation notice.
Check the columns against your state's rules
The Cure deadline and Delivery method columns are where state law shows up in this template, and the law genuinely splits. Some states hard-code specific windows — Florida, Colorado, and Virginia among them — while Texas and Arizona require only a "reasonable" period with no fixed day count, and Georgia and Washington leave the fine process largely to the governing documents. That means a single default like "14 days to cure" typed into every row can misstate the law in your state. Set your deadlines from your state statute and your declaration, not from a template default.
This table is operational guidance, not legal advice. Statutes change — several of these have been amended recently — so verify the current text and consult association counsel before your board adopts or changes a fine policy.
| State | What the statute requires before a fine | Statute / authority |
|---|---|---|
| Florida | At least 14 days' written notice of the right to a hearing before a committee; the hearing must be held within 90 days of the notice; no fine or suspension if the violation is cured before the hearing; a confirmed fine is not due until at least 30 days after written notice. | Fla. Stat. § 720.305 |
| California | At least 10 days' written notice before a disciplinary meeting (15 days where suspension of membership privileges is at issue, under Corp. Code § 7341), stating date, time, place, the alleged violation, and the member's right to attend and address the board; no discipline if the member cures before the meeting. | Cal. Civ. Code § 5855 |
| Texas | Written notice by certified mail; if the violation is curable and not a public health or safety threat, a reasonable cure period (no fixed day count); the owner may request a hearing within 30 days of receiving the notice, and the association must hold it within 30 days of the request. | Tex. Prop. Code §§ 209.006, 209.007 |
| Arizona | No fixed statutory cure period; only reasonable monetary penalties authorized by the governing documents. An owner may respond in writing by certified mail within 21 calendar days, the association must reply within 10 business days, and the owner may petition the Arizona Real Estate Department for an administrative hearing. | Ariz. Rev. Stat. § 33-1803 |
| Colorado | 30 days to cure an ordinary violation (and two consecutive 30-day cure periods before the association may sue), with total fines for that violation capped at $500; a 72-hour cure period before fines for violations posing an imminent public health or safety threat. | Colo. Rev. Stat. § 38-33.3-209.5 |
| North Carolina | Unless the declaration provides otherwise, a fine requires a hearing before the executive board or an adjudicatory panel, with notice of the charge, an opportunity to be heard, and notice of the decision; fines capped at $100 per violation, and $100 per day for a continuing violation beyond five days after the decision. | N.C. Gen. Stat. § 47F-3-107.1 |
| Georgia | No statutory cure period or hearing procedure for fines; the association may fine or suspend rights only to the extent the declaration provides, so the process is governed by the declaration. A 2024 amendment (HB 220, eff. July 1, 2024) allows injunctive relief after 10 days' written notice. | Ga. Code Ann. § 44-3-223 |
| Nevada | Written notice stating the alleged violation, the action needed to cure, the fine amount, and the hearing date, time, and location; a hearing before imposing the fine unless the owner pays first, signs a written waiver, or fails to appear after proper notice. Non-health/safety fines capped at $100 per violation or $1,000 total, whichever is less. | Nev. Rev. Stat. § 116.31031 |
| Virginia | A reasonable opportunity to correct the violation after written notice; hearing notice hand-delivered or sent by registered or certified mail at least 14 days before the hearing; the decision delivered within 7 days; charges capped at $50 for a single offense or $10 per day for a continuing offense, up to 90 days. | Va. Code Ann. § 55.1-1819 |
| Washington | Reasonable fines only after notice and an opportunity to be heard by the board or its designated representative, under a fine schedule the board previously adopted and furnished to owners; the cure timeline itself is left to the governing documents. | Wash. Rev. Code § 64.38.020 |
The same columns in Notion or Airtable
The template translates directly if your board prefers a database tool. In Airtable, each column becomes a field — single-select for Notice stage and Status, date fields for the deadlines — and a view sorted by cure deadline replaces the weekly sort. In Notion, a database with select and date properties does the same job, and a filtered view of open cases past their cure deadline replaces the conditional-formatting rule.
What these tools do not change is the fundamentals. The structure is still hand-built by one board member, the deadline discipline still depends on someone opening the workspace, and every gap described in the next section applies just as much. There is also a succession question worth taking seriously: when the volunteer who built the base or the Notion workspace rotates off the board, the next secretary inherits a system nobody else understands.
Where the spreadsheet honestly breaks
A plain spreadsheet does not remind anyone of anything. Every deadline check is a human re-reading the sheet; the red conditional-formatting rows only work when someone opens the file. Miss two weekly passes over a busy summer and a cure deadline slides by unnoticed — which matters in states where the timeline is statutory, not just courteous.
The evidence trail is weaker than it looks. Google Sheets version history records that a cell changed, when, and from which account — but not the prior value or the reason for the change, and it does not tie a row to the photos, notice PDFs, or emails that live in someone's inbox or a shared drive. If an owner disputes a fine a year later, you will be reconstructing the case from three or four separate places.
Most importantly, a spreadsheet has no send log. There is no native record that a notice was actually delivered rather than merely drafted, and several states — Florida, Nevada, Virginia, and Texas among them — condition the enforceability of a fine on proper notice and, in some cases, a specific delivery method such as certified mail. The full comparison lives in the guide on HOA violation tracking, spreadsheet vs. software; the short version is that the spreadsheet works well right up until the first contested fine.
Where ViolationFlow fits
ViolationFlow is built for the point where the spreadsheet stops. Each lot gets a case with a dated timeline; notices are sent from templates by email and every send is logged, so the delivery question has an answer; and the whole timeline exports to PDF when a hearing or an attorney needs the record. Escalation ladders carry your cure periods and a fine ledger — the board sets its own amounts (a ladder like courtesy at $0, first notice at $0, second notice at $50, hearing at $100 is illustrative, not a recommendation) — and advancing a case to the next step is always an explicit board action. Notices are never auto-sent.
The free tier covers 10 lots, 5 active cases, and 1 board user with no credit card required, which is enough to run it alongside this spreadsheet for a season and compare. Paid plans run $19 to $39 per month by lot count, with all features at every tier, including ARC request tracking with deadlines and owner links — private URLs where an owner can view the status of their own case.
Frequently asked questions
- Is there a free Excel or Google Sheets download for this HOA violation log?
- Yes — the log is a real, ungated CSV or Excel download above, no email required, and the Excel version includes the Notice stage and Status dropdowns. You can also copy the column structure from the table on the page. The same columns work in Notion or Airtable.
- Should each violation get its own row?
- Yes — one row per case, not per letter. When a case advances to the next notice stage, update the stage and sent date and record the previous stage and its dates in Notes, so the earlier history is not silently overwritten.
- How do we prove a notice was actually sent?
- The spreadsheet only shows what someone typed. File the certified-mail receipt or a copy of the sent email under the case number, because several states — including Florida, Nevada, Virginia, and Texas — condition fines on proper notice and, in some cases, a specific delivery method.
- What fine amounts should we put in the Fine recorded column?
- Only what your governing documents authorize, checked against state caps: North Carolina caps fines at $100 per violation, Nevada at $100 per violation or $1,000 total for non-safety issues, Virginia at $50 for a single offense, and Colorado at $500 total per violation. The guide on HOA fine schedules and escalation ladders covers setting the amounts.
- Can this template track ARC requests too?
- You can add a second sheet with parallel columns — request date, project description, decision deadline, decision — but architectural review runs on different deadlines and stakes than enforcement. The guide on ARC request tracking for small associations covers that workflow separately.