HOA / Condo AR Aging and Collection Projection Calculator

Project 12-month ultimate collection from a community association's accounts receivable book, segmented by aging bucket (0-30 / 31-60 / 61-90 / 91+ days), using historical collection-rate curves benchmarked against CAI / FCAR collections research, CAM-specialty collections counsel observations (Hindman Sanchez and the regional firms), and Sperlonga / industry collections agency data. Industry-typical curves: 99%+ ultimate collection on 0-30 day balances, 88-94% on 31-60 days, 70-82% on 61-90 days, 30-55% on 91+ days. Models the standard collections workflow — pre-lien notice (state-specific content and mailing rules) at 60-90 days, statutory lien recording at 90-120 days, attorney handoff to CAM-specialty collections counsel at 120-180 days, foreclosure evaluation at 180-365 days depending on state statute and board decision. Outputs projected ultimate collection by bucket, total projected write-off, write-off as a fraction of annual assessment revenue (with a 2.5% structural warning threshold), estimated collection cost on 91+ recovery (typically 35% of recovered amount), net recovery after cost, and recommended actions by bucket. Tool, not advice — actual collections strategy must follow state-specific community association statute, the association's governing documents (declaration, bylaws, rules), the management agreement, and board fiduciary judgment.

Calculator

Adjust the inputs below; the result updates instantly.

Association profile

Unit-owner count in the association

Monthly assessment per unit ($)

AR aging buckets

AR balance — 0-30 days delinquent ($)

AR balance — 31-60 days delinquent ($)

AR balance — 61-90 days delinquent ($)

AR balance — 91+ days delinquent ($)

Historical collection rates

Historical collection rate — 0-30 days (%)

Historical collection rate — 31-60 days (%)

Historical collection rate — 61-90 days (%)

Historical collection rate — 91+ days (%)

Workflow triggers

Pre-lien notice trigger (days delinquent)

Lien recording trigger (days delinquent)

Attorney handoff trigger (days delinquent)

Total projected ultimate collection

17,243.00

Total projected write-off: $4,558.00
Write-off as fraction of annual assessment revenue: 0.6%
Total current AR balance: $21,800.00
Annual assessment revenue (at full collection): $756,000.00
Estimated collection cost (attorney, court, recording): $992.00
Net recovery after collection cost: $16,250.00
Recommended action — 0-30 day bucket: Standard ledger entry; reminder via owner portal at month-end statement.
Recommended action — 31-60 day bucket: Second-notice letter with late fee; courtesy phone or email reminder. Owners typically clear within 14 days of second notice. Pre-lien notice queued for day 75.
Recommended action — 61-90 day bucket: Pre-lien notice (state-specific content and mailing method required) and offer of payment plan; document hardship requests for board review. Lien recording queued for day 105.
Recommended action — 91+ day bucket: Record statutory lien (must comply with state notice and content rules), engage CAM-specialty collections counsel under management agreement, evaluate payment plan vs foreclosure path with board. Attorney handoff at day 150; recovery cost typically 35.0% of amount recovered.
Summary: Current AR aging: $8,500 0-30 days, $4,200 31-60 days, $2,800 61-90 days, $6,300 91+ days (total $21,800). Projected ultimate collection: $8,458 from 0-30 (99.5%), $3,822 from 31-60 (91.0%), $2,128 from 61-90 (76.0%), $2,835 from 91+ (45.0%) — total $17,243. Projected write-off of $4,558 (0.6% of annual assessment revenue) sits within the typical operating tolerance for a well-run association. Estimated collection cost on 91+ recovery: $992; net recovery after cost: $16,250. This is a screening tool; actual collections strategy must follow state-specific community association statute, the governing documents, the management agreement, and board fiduciary judgment. State law sets pre-lien notice content and mailing method, lien recording timing, and the available foreclosure path (judicial vs non-judicial, super-priority status).

Tools to go with this

Running AR for an HOA or condo portfolio? Lock in the collections workflow workbook before the next board meeting.

Fennec Press's property-management-operations bundle includes the state-by-state pre-lien notice content and timing matrix, the statutory lien recording workflow with mailing-method and recording-office detail, the CAM-specialty collections counsel evaluation framework (contingency vs hybrid vs hourly), the payment plan template with board-approval thresholds, the super-priority lien and foreclosure decision tree by state, the cash-position dashboard with write-off trend tracking, the assessment-increase analysis template when write-off exceeds the 2.5% structural threshold, and the board reporting package for quarterly collections review — built for community managers, regional VPs, AR specialists, and the board treasurers and CPAs who review association collections.

Open Fennec Press property-management-operations bundle→

Fennec Press is our sister site. Outbound link is UTM-tagged and disclosed.

Published by

The Fennec Lab Editorial Team

Statute-cited · Unit-tested

Reviewed against: Community Associations Institute (CAI) and Foundation for Community Association Research (FCAR) collections research and best-practice publications; CAI Manager Code of Ethics and Professional Conduct (collections handling scope); CAM-specialty collections counsel observed practice (Hindman Sanchez Levin, Vial Fotheringham, regional firms); Sperlonga and industry collections agency data; AAOM (Association of Association Management) firm-economics benchmarks (write-off rates as fraction of annual revenue); state-specific community association statutes (Florida Chapter 720 HOA / Chapter 718 condominium; Arizona ARS 33-1801; California Civil Code 4000+ Davis-Stirling; Colorado CCIOA; comparable structures across other states) for super-priority lien and foreclosure framework reference

Last reviewed: 2026-05-17

How this calculator works

This is a screening tool for projecting 12-month ultimate collection from a community association's accounts receivable book. It segments the current AR balance into the four standard aging buckets (0-30 days, 31-60 days, 61-90 days, 91+ days), applies bucket-specific historical collection rates, and computes the projected ultimate collection, projected write-off, write-off as a fraction of annual assessment revenue, estimated collection cost on 91+ recovery, and net recovery after cost. Industry-typical collection-rate curves: 99%+ ultimate collection on 0-30 day balances, 88-94% on 31-60 days, 70-82% on 61-90 days, 30-55% on 91+ days. The 91+ bucket carries an estimated 35% collection cost ratio (attorney fees, court costs, lien recording, mailing) which the calculator subtracts to produce a net-recovery figure. The output also includes recommended actions by bucket — standard late notice for 0-30, late fee and second notice for 31-60, pre-lien notice and payment plan offer for 61-90, lien recording and attorney handoff for 91+. The 2.5% structural-warning threshold on write-off-as-fraction-of-annual-revenue flags associations that may require board action (assessment increase, reserve adjustment, special assessment, collections policy tightening). This is a tool for community managers, AR specialists, and board treasurers reviewing association collections; for state-specific pre-lien notice content, lien recording procedure, super-priority statute application, and foreclosure path evaluation, the companion content flags the framework but the math does not separately compute those numbers.

The framework — CAI, FCAR, CAM-specialty collections benchmarks

The community association collections workflow is one of the most-developed specialty practice areas in residential real estate services. The benchmark data and procedural framework come from four sources.

Community Associations Institute (CAI) and its research arm the Foundation for Community Association Research (FCAR) publish best-practice collections guidance and the U.S. National Community Association Statistical Review, which includes AR aging distributions and write-off rates across the industry.

CAI's College of Community Association Lawyers (CCAL) is the specialty bar for attorneys practicing in the community association space. CCAL Fellows publish state-specific guidance on lien recording, foreclosure procedure, and super-priority statute interpretation. The CCAL framework is the most-authoritative legal reference for collections procedure.

CAM-specialty collections law firms — Hindman Sanchez Levin, Vial Fotheringham, Becker Poliakoff, Kaman & Cusimano, and the regional firms — operate as the practitioner reference. These firms collectively handle a meaningful fraction of community association collections in the United States and publish continuing-education materials and case-study data on workflow, recovery rates, and cost structure.

Sperlonga and the CAM-specialty collections agencies publish industry-aggregated collection-rate data by bucket and demographic profile. Sperlonga also operates the credit-bureau reporting platform that materially improves collection rates on owners who would not otherwise respond to association notices.

The collection-rate curves the calculator uses are the population-weighted midpoints of CAI / FCAR survey data, Sperlonga industry observations, and CAM-specialty counsel case-study data. The curves are stable across deal cycles; the absolute write-off levels move with macroeconomic conditions (recession-era write-off runs 1.5-2x baseline) and with the maturity of the association's collections program (well-run associations with timely pre-lien notice and lien recording sustain materially lower write-off than associations that allow AR to age past the 90-day workflow trigger).

Inputs explained

The calculator takes thirteen inputs.

Unit-owner count and monthly assessment. Drives the annual assessment revenue base against which the write-off fraction is computed. Annual revenue = units × monthly × 12.

AR balance by aging bucket (0-30 / 31-60 / 61-90 / 91+ days). Current receivable balance from delinquent owners segmented by days delinquent. The bucket boundaries follow the industry-standard reporting convention.

Historical collection rate by bucket. Bucket-specific ultimate collection rate based on the association's historical experience. Industry-typical: 99-100% for 0-30, 88-94% for 31-60, 70-82% for 61-90, 30-55% for 91+. Associations should track their own rates; under-performing buckets indicate workflow problems.

Pre-lien notice trigger (days delinquent). Days delinquent at which pre-lien notice is sent. State-specific rule applies — typically 60-90 days. Verify against state statute and governing documents.

Lien recording trigger (days delinquent). Days delinquent at which the statutory lien is recorded. Typically 90-120 days. The lien attaches to the unit and runs with the property.

Attorney handoff trigger (days delinquent). Days delinquent at which the matter is referred to CAM-specialty collections counsel. Typically 120-180 days.

Industry benchmarks

The bucket-specific collection rates and workflow thresholds the calculator uses.

0-30 days bucket: 99%+ ultimate collection. Most owners on a late-pay cycle (payday timing, autopay setup drift) clear within the current or next billing cycle. Action: standard ledger entry and owner-portal reminder.

31-60 days bucket: 88-94% ultimate collection (industry midpoint 91%). Second notice with late fee typically clears the bulk within 14 days. Owners reaching this bucket carry measurably elevated risk of further decline. Action: second-notice letter with late fee, courtesy phone or email reminder.

61-90 days bucket: 70-82% ultimate collection (industry midpoint 76%). Pre-lien notice typically issues in this window. Owners increasingly likely to be in financial distress, separation / divorce, or estate transition. Action: pre-lien notice with state-specific content and mailing method, payment plan offer, hardship documentation.

91+ days bucket: 30-55% ultimate collection (industry midpoint 45%). Lien recording, attorney handoff, payment plan or foreclosure evaluation. Recovery depends on state foreclosure law, unit equity, mortgage position. Collection cost typically 25-50% of recovered amount (35% midpoint).

Pre-lien notice trigger: 60-90 days (75-day midpoint). State-specific timing rule applies; some states require formal notice with specific content and recording period before lien recording.

Lien recording trigger: 90-120 days (105-day midpoint). State-specific rules govern content, mailing method, recording office, and timing. Lien attaches to unit and runs with property.

Attorney handoff trigger: 120-180 days (150-day midpoint). Engagement under CAM-specialty agreement (contingency, hybrid, or hourly).

Foreclosure evaluation: 180-365 days. Decision factors: state procedure (judicial vs non-judicial), super-priority statute strength, unit equity, mortgage default status, owner status, board appetite.

Super-priority statute states: Roughly 22 states grant some form of super-priority status to the association lien — NV (9 months), FL (12 months), CO (6 months), CT, DE, DC, MA, MN, NH, PA, RI, VT, WV, and others. The super-priority feature is the single most important collections lever; verify current status with CAM-specialty counsel.

Write-off structural warning threshold: 2.5% of annual assessment revenue. Sustained breach signals structural problem requiring board action — assessment increase, reserve adjustment, special assessment, or collections policy tightening.

What this calculator does NOT model

This is an AR aging and collection projection screening tool, not a full association financial model. It does NOT model state-specific super-priority lien interaction with first-mortgage holder behavior — the actual recovery on a 91+ balance depends heavily on whether the first-mortgage holder cures the super-priority arrears or defaults to a wipe-out scenario. It does NOT model the foreclosure-process timeline or the cost variance between judicial and non-judicial states. It does NOT compute the credit-bureau reporting uplift (Sperlonga and similar platforms typically add 15-25% collection rate to 31-90 day buckets) — treat the rate inputs as the without-reporting baseline. It does NOT model unit-owner bankruptcy treatment (Chapter 7, 11, 13) which freezes collection action under the automatic stay and creates pre-petition vs post-petition treatment differences. It does NOT model special-assessment AR separately from regular monthly assessment AR — special assessments typically carry separate collection workflow and recovery patterns. It does NOT model fee-shifting under state statute and governing documents for attorney fees and collection costs — recovery from the delinquent owner depends on reasonableness review and procedural compliance. It does NOT model payment plan economics including default rate, time-value-of-money on multi-year plans, and the credit risk on uncollateralized payment plan balances. It does NOT compute the operating cash impact of the projected write-off on association liquidity, reserve adequacy, or future budget. For comprehensive collections planning, the projection this calculator produces is one input among many; the CAI Best Practices on collections and the Fennec Press property-management-operations bundle cover the surrounding framework.

Sources

This calculator is built against the following references:

Community Associations Institute (CAI) — Best Practices on collections; statistical review on AR aging distributions; manager Code of Ethics scope.
Foundation for Community Association Research (FCAR) — U.S. National Community Association Statistical Review; write-off rate benchmarks.
CAI College of Community Association Lawyers (CCAL) — state-specific guidance on lien recording, foreclosure procedure, super-priority statute interpretation.
CAM-specialty collections law firms — Hindman Sanchez Levin, Vial Fotheringham, Becker Poliakoff, Kaman & Cusimano, regional firms; practitioner reference for workflow, recovery rates, cost structure.
Sperlonga and CAM-specialty collections agencies — industry-aggregated collection-rate data by bucket; credit-bureau reporting uplift observations.
AAOM (Association of Association Management) — firm-economics benchmarks for write-off as fraction of annual revenue.
State community association statutes — Florida Chapter 720 (HOA) and Chapter 718 (condominium); Nevada NRS 116.3116; Arizona ARS 33-1801; California Civil Code 4000+ (Davis-Stirling); Colorado CCIOA; comparable structures across other states.
11 USC § 362 (bankruptcy automatic stay) and 11 USC § 523(a)(16) (post-petition assessment treatment) — federal bankruptcy framework.
15 USC § 1681 (Fair Credit Reporting Act) — credit-bureau reporting compliance.

Last reviewed: 2026-05-17 against CAI Best Practices on collections (most recent release), FCAR statistical review (most recent annual), CCAL state-specific guidance (most recent updates), Sperlonga industry collection-rate data (most recent release), AAOM firm-economics benchmarks (most recent release), and the state community association statutes referenced (current as published).

Super-priority lien status means the association's lien for unpaid assessments has priority over the first mortgage for some defined portion of the delinquency — typically 6, 9, or 12 months of assessments plus reasonable collection costs. The super-priority feature is statutorily granted and varies by state. Roughly 22 states grant some form of super-priority: Nevada (NV NRS 116.3116) provides 9 months of assessment super-priority plus reasonable collection costs; Florida (Chapter 720 HOA, Chapter 718 condo) provides 12 months of assessment super-priority; Colorado (CCIOA 38-33.3-316) provides 6 months; Connecticut, Delaware, the District of Columbia, Massachusetts, Minnesota, New Hampshire, Pennsylvania, Rhode Island, Vermont, and West Virginia have variants. The super-priority status is the single most important collections lever the association has, because it forces the first-mortgage holder to either pay the super-priority arrears (typically 9-12 months of dues, a few thousand dollars) or risk the association foreclosing and wiping out the mortgage. The 2014 SFR Investments Pool v. U.S. Bank decision (Nevada Supreme Court) confirmed the wipe-out effect for non-judicial association foreclosures and triggered a wave of investor litigation; subsequent statutes in several states have clarified procedures. Verify the current super-priority status and procedure in your state with CAM-specialty collections counsel before relying on the doctrine in any specific case.

Pre-lien notice (sometimes called intent-to-lien notice) is a state-specific formal communication the association must send to a delinquent unit owner before recording a lien. State law typically prescribes: the content (specific recitation of unpaid amounts, late fees, interest, attorney fees, and statutory authority to lien); the mailing method (often certified mail return receipt requested, sometimes with additional first-class mailing or posting at the unit door); the recipient list (the unit owner, plus often any tenant in possession and any first-mortgage holder of record); the cure period (typically 30-45 days during which the owner can pay without further escalation); and the lien-recording office (county recorder, registry of deeds). Failure to comply with the state-specific pre-lien notice rule can void the subsequent lien recording, which means the association loses the priority date and may be barred from collecting attorney fees. The calculator does not enforce state-specific notice rules; verify the current rule with CAM-specialty collections counsel or the state community association regulator before sending notice on any specific account.

A payment plan is a written agreement between the association and a delinquent owner under which the owner pays the past-due balance in installments while staying current on ongoing assessments. The typical structure: 12-36 month repayment of past-due principal plus accrued interest and late fees, with the agreement requiring the owner to remain current on new monthly assessments, payments applied first to past due and then to current (or vice versa depending on state law and governing documents), and default of the payment plan accelerating the entire balance immediately due. Best practice: have the agreement drafted or reviewed by CAM-specialty collections counsel, recorded as a memorandum at the county recorder (to preserve priority and prevent the owner from selling the unit without satisfying the obligation), and require automatic-payment authorization for the duration. Payment plans are particularly valuable in states without super-priority statute (the association has limited leverage to force payment via foreclosure) and in cases where the owner has demonstrated good faith (job loss, medical emergency, family transition). Boards should reserve payment-plan approval authority — managers should not bind the association unilaterally to a multi-year repayment.

Foreclosure is the association's most-aggressive collections tool and the analysis is fact-specific. The decision factors: (1) state foreclosure procedure — non-judicial states (CA, NV, AZ, TX, CO, others) allow faster, lower-cost foreclosure than judicial states (FL, NY, NJ, OH, others); (2) super-priority statute — states with strong super-priority (NV 9 months, FL 12 months) give the association a defensible mortgage-wipe-out threat that often forces the mortgage holder to cure rather than risk loss of priority; (3) unit equity — if the unit has meaningful equity above the first mortgage, the association can recover through a successful foreclosure sale; (4) mortgage default status — if the first mortgage is already in foreclosure, the association can recover super-priority arrears from the foreclosing lender; (5) owner status — if the owner is deceased, abandoned the property, or is in active bankruptcy, foreclosure procedure differs materially; (6) board appetite — foreclosure is the most-visible collections action and some boards prefer payment plans even when foreclosure would be economically superior. Most foreclosures are economically marginal — the legal cost (judicial state: $15,000-$40,000; non-judicial state: $3,000-$10,000) consumes a meaningful fraction of the recovery, and the association ends up owning a unit it must then market, repair, and resell. The credible threat of foreclosure is often more valuable than the foreclosure itself; well-run collections workflows extract payment from owners who would default if there were no threat. Engage CAM-specialty collections counsel before initiating foreclosure on any specific case.

In association collections, "attorney fees" and "collection costs" are typically distinct line items with different recovery rules. Attorney fees are the legal counsel's fee for representing the association in the collection action — drafting demand letters, recording liens, filing foreclosure complaints, appearing at hearings. Most state community association statutes and governing documents permit the association to recover attorney fees from the delinquent owner as part of the secured lien balance, but the recovery requires the fees to be reasonable, properly documented, and (in many states) court-approved if foreclosure proceeds. Collection costs are out-of-pocket expenses other than attorney fees: court filing fees, sheriff service fees, lien recording fees, title search fees, mailing costs, late fee calculations. Collection costs are typically recoverable on the same basis as attorney fees. The "reasonable and necessary" standard limits both — courts will trim excessive fees or non-essential cost recovery. Sophisticated associations track attorney fees and collection costs separately by case, both for board reporting transparency and for billable-recovery documentation. Many CAM-specialty collections counsel work on contingency or hybrid contingency-plus-hourly arrangements where the attorney is paid from the eventual recovery rather than billing the association directly; this aligns incentives but can produce occasional perverse outcomes (counsel pursuing aggressive action because the contingency is at stake, when payment plan would serve the association better).

When a delinquent owner files bankruptcy (Chapter 7 liquidation, Chapter 13 wage-earner reorganization, or Chapter 11 reorganization), the automatic stay under 11 USC § 362 immediately halts all collection action against the owner. The association cannot send notices, record liens, or proceed with foreclosure without relief from the stay. The treatment differs by bankruptcy chapter. Chapter 7: pre-petition assessments are typically discharged as unsecured debt; post-petition assessments (assessments accruing AFTER the bankruptcy filing) are NOT discharged and remain collectible under 11 USC § 523(a)(16). The association files a proof of claim for pre-petition amounts; recovery depends on the bankruptcy estate. Chapter 13: pre-petition assessments are included in the wage-earner plan and paid pro-rata over 3-5 years; post-petition assessments are typically paid current as part of the plan. Chapter 11 (rare for individual owners): similar to Chapter 13 but for individuals with debts above the Chapter 13 ceiling. In all chapters, the association's lien (if properly recorded pre-petition) survives the bankruptcy and remains attached to the unit; the owner cannot discharge a properly-recorded lien and the lien follows the unit through any future transfer. Engage bankruptcy-experienced collections counsel immediately upon receiving any bankruptcy filing notice from an owner — the deadlines for filing proof of claim, objecting to plans, and seeking relief from the stay are short and unforgiving.

A well-run association in a stable market sustains write-off at under 1% of annual assessment revenue. Write-off of 1-2.5% is within normal operating tolerance; some loss is the cost of recovering from owner financial distress, estate transition, and the small minority of strategic defaulters. Write-off above 2.5% of annual revenue signals a structural problem that requires board action: assessment increase (if the association is under-funded relative to operating costs and reserves), reserve adjustment (if reserves are over-allocated and operating budget is compressing collections capacity), collections policy tightening (if pre-lien notice and lien recording are not being triggered timely), special assessment (if a one-time funding need has pushed owners into delinquency), or a comprehensive financial review (if the underlying business model is not sustainable at current dues levels). Write-off above 4-5% of annual revenue typically indicates a financially-distressed association — market downturn, foreclosure-wave aftermath, demographic shift, or governance failure — and benefits from outside review by an association-specialty CPA and CAM-specialty counsel. The calculator flags the 2.5% structural warning threshold; boards reviewing the calculator output should interpret a sustained breach of the threshold as a leading indicator of broader financial fragility.

Sperlonga and similar credit-bureau reporting platforms report unit-owner delinquency to the major credit bureaus (Equifax, Experian, TransUnion). Once an owner's delinquency hits the owner's credit report, the impact on credit score is comparable to a defaulted credit-card or installment-loan account — typically 80-150 point credit-score reduction depending on the owner's existing profile. The collection-rate improvement is meaningful: industry-observed data places the recovery uplift at 15-25% across the 31-60 and 61-90 day buckets, and 5-15% across the 91+ day bucket. The mechanism is owner motivation rather than enforcement — owners who would not respond to a pre-lien notice often respond to a credit-bureau reporting notice because the credit consequences extend beyond the association action (mortgage refinancing, employment background check, rental application). Implementation requires careful attention to Fair Credit Reporting Act (FCRA, 15 USC § 1681) compliance — the association must furnish accurate information, respond to disputes within 30 days, and follow specific notification procedures. Sperlonga and similar platforms typically include compliance frameworks in the service. The calculator does NOT model the credit-bureau-reporting uplift; treat the standard collection-rate inputs as the without-reporting baseline and adjust upward if the association is currently reporting.

Resources

Links marked sponsoredmay earn The Fennec Lab a commission. They do not affect the calculator's output. See disclosures.

Community Associations Institute (CAI) — Best Practices — CAI publishes a Best Practices series covering collections, financial operations, board governance, and document retention. The collections best-practices report covers the standard workflow (notice, late fee, pre-lien, lien, attorney handoff) and the state-specific variations.
CAI College of Community Association Lawyers (CCAL) — CCAL is CAI's college for attorneys practicing in the community association space; CCAL Fellows publish state-specific guidance on lien recording, foreclosure procedure, and super-priority statute interpretation.
Sperlonga — community association credit reporting — Sperlonga is a credit reporting and AR analytics platform for community associations; reports unit-owner delinquency to the major credit bureaus, which materially improves collection rates on owners who otherwise would not respond to association notices.
Hindman Sanchez Levin — CAM specialty collections counsel — Hindman Sanchez Levin is a regional law firm specializing in community association collections and governance work; the firm's practice library and continuing education materials are widely referenced as a regional benchmark for collections workflow.