• May include: An owner dues log and delinquency tracker dashboard featuring the text SEE WHO OWES WHAT, PER LOT. It displays 48 lots tracked, £0.00 difference vs deposits, and a 94% collection rate. Includes status indicators for current, late, and delinquent accounts.
  • May include: A digital spreadsheet titled Owner Dues Log featuring columns for lot owner, contact, assessment, total paid, balance owed, days late, and status. The table displays financial data with rows for 37 lots, highlighting late payments in red.
  • May include: A digital spreadsheet template for tracking HOA and condo dues, featuring five colour-coded tabs: Start Here, Setup, Assessment Deposits, Owner Dues Log, and Delinquency Log. It includes instructions for Google Sheets, Excel, and Numbers.
  • May include: An owner dues log and delinquency tracker dashboard featuring the text SEE WHO OWES WHAT, PER LOT. It displays 48 lots tracked, £0.00 difference vs deposits, and a 94% collection rate. Includes status indicators for current, late, and delinquent accounts.
  • May include: A digital spreadsheet titled Owner Dues Log featuring columns for lot owner, contact, assessment, total paid, balance owed, days late, and status. The table displays financial data with rows for 37 lots, highlighting late payments in red.
  • May include: A digital spreadsheet template for tracking HOA and condo dues, featuring five colour-coded tabs: Start Here, Setup, Assessment Deposits, Owner Dues Log, and Delinquency Log. It includes instructions for Google Sheets, Excel, and Numbers.
Report this item to Etsy

HOA Owner Dues Log & Delinquency Collection Tracker, Google Sheets Excel Template

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF, 1 other file

Seller's description

This tracks what EACH OWNER owes: balances, late fees and collections. To track the HOA's own budget and bank, see our HOA Treasurer Spreadsheet: https://www.etsy.com/uk/listing/4559765013/hoa-treasurer-spreadsheet-google-sheets

HOA owner dues tracker and delinquency collection log for Google Sheets and Excel: 5 tabs, per-lot balance, 4-step escalation to lien warning.

Assessments come in, a few owners fall behind, and the board needs both numbers at the same time: who owes what, and where the collection process stands for the accounts that are actually late. This workbook tracks both, cross-checked against your deposits so nothing is typed twice.

WHAT YOU GET - one workbook, 5 tabs
- OWNER DUES LOG - one line per lot or unit (200 rows): owner, contact, assessment per period, total paid, last payment. Periods billed, total assessed, balance owed, days late, late fee and a Current / Late / Delinquent status calculate from the rule you set once in Setup. An at-a-glance block counts accounts current, late and delinquent, and cross-checks against the deposits entered in ASSESSMENT DEPOSITS.
- DELINQUENCY LOG - one line per account already late: balance, the date it went late, and the date you send each collection step. NEXT STEP DUE reads your own escalation schedule (reminder, late notice, formal demand, lien warning) and tells you exactly what is due next - it never skips a step.
- START HERE and SETUP - association name, number of lots, your assessment amount, billing frequency, grace period, late fee and your 4-step escalation schedule, typed once.
- ASSESSMENT DEPOSITS - one line per bank deposit (200 rows), feeding the cross-check automatically.

WHY THIS ONE
- Who owes what, per lot, and where collection stands for the ones who are late - in one workbook.
- Late fees are kept apart from the assessment balance, so neither number hides the other.
- A worked example is already in there: 48 lots, 3 late, one deposit that reconciles to the cent, and 5 accounts already at different collection stages, so you can see how the schedule behaves before you touch a cell.
- Set it up once, then you only ever type in four tabs. Everything else calculates itself.

WHO IT IS FOR
Treasurers and board members of self-managed HOAs, condo associations, and small communities that want dues and collections tracked without enterprise software pricing.

DETAILS
- Instant download: your Google Sheets copy link (one click creates your own private copy in your own Drive) plus the same workbook as an .xlsx file for Excel, Numbers, or LibreOffice
- 5 tabs, 200 rows per ledger, 200 lots in the dues log, 100 accounts in the delinquency log, US number formatting, prints on US Letter (the logs in landscape)
- Nothing to install

PLEASE NOTE
- This is a record-keeping tool, not accounting, tax, or legal advice. Your covenants, bylaws, and state statutes always come first.
- This is a digital download. Nothing will be shipped.
- The Google Sheets link requires a free Google account; the .xlsx file does not.
- For one association's internal use. Please do not resell or redistribute the file.

This shop also makes the full HOA Treasurer Spreadsheet (money in, money out, monthly report, bank reconciliation, budget vs actual) if you need the complete ledger, not just dues and collections.

If a formula ever misbehaves, message me - I will fix it the same day.

HOW IT WAS MADE
This spreadsheet was designed and built with the help of AI, then every formula and calculation in it was checked by machine before it was listed.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View programme terms

Price:£14.68

You can only make an offer when buying a single item.

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: An owner dues log and delinquency tracker dashboard featuring the text SEE WHO OWES WHAT, PER LOT. It displays 48 lots tracked, £0.00 difference vs deposits, and a 94% collection rate. Includes status indicators for current, late, and delinquent accounts.

This tracks what EACH OWNER owes: balances, late fees and collections. To track the HOA's own budget and bank, see our HOA Treasurer Spreadsheet: https://www.etsy.com/uk/listing/4559765013/hoa-treasurer-spreadsheet-google-sheets

HOA owner dues tracker and delinquency collection log for Google Sheets and Excel: 5 tabs, per-lot balance, 4-step escalation to lien warning.

Assessments come in, a few owners fall behind, and the board needs both numbers at the same time: who owes what, and where the collection process stands for the accounts that are actually late. This workbook tracks both, cross-checked against your deposits so nothing is typed twice.

WHAT YOU GET - one workbook, 5 tabs
- OWNER DUES LOG - one line per lot or unit (200 rows): owner, contact, assessment per period, total paid, last payment. Periods billed, total assessed, balance owed, days late, late fee and a Current / Late / Delinquent status calculate from the rule you set once in Setup. An at-a-glance block counts accounts current, late and delinquent, and cross-checks against the deposits entered in ASSESSMENT DEPOSITS.
- DELINQUENCY LOG - one line per account already late: balance, the date it went late, and the date you send each collection step. NEXT STEP DUE reads your own escalation schedule (reminder, late notice, formal demand, lien warning) and tells you exactly what is due next - it never skips a step.
- START HERE and SETUP - association name, number of lots, your assessment amount, billing frequency, grace period, late fee and your 4-step escalation schedule, typed once.
- ASSESSMENT DEPOSITS - one line per bank deposit (200 rows), feeding the cross-check automatically.

WHY THIS ONE
- Who owes what, per lot, and where collection stands for the ones who are late - in one workbook.
- Late fees are kept apart from the assessment balance, so neither number hides the other.
- A worked example is already in there: 48 lots, 3 late, one deposit that reconciles to the cent, and 5 accounts already at different collection stages, so you can see how the schedule behaves before you touch a cell.
- Set it up once, then you only ever type in four tabs. Everything else calculates itself.

WHO IT IS FOR
Treasurers and board members of self-managed HOAs, condo associations, and small communities that want dues and collections tracked without enterprise software pricing.

DETAILS
- Instant download: your Google Sheets copy link (one click creates your own private copy in your own Drive) plus the same workbook as an .xlsx file for Excel, Numbers, or LibreOffice
- 5 tabs, 200 rows per ledger, 200 lots in the dues log, 100 accounts in the delinquency log, US number formatting, prints on US Letter (the logs in landscape)
- Nothing to install

PLEASE NOTE
- This is a record-keeping tool, not accounting, tax, or legal advice. Your covenants, bylaws, and state statutes always come first.
- This is a digital download. Nothing will be shipped.
- The Google Sheets link requires a free Google account; the .xlsx file does not.
- For one association's internal use. Please do not resell or redistribute the file.

This shop also makes the full HOA Treasurer Spreadsheet (money in, money out, monthly report, bank reconciliation, budget vs actual) if you need the complete ledger, not just dues and collections.

If a formula ever misbehaves, message me - I will fix it the same day.

HOW IT WAS MADE
This spreadsheet was designed and built with the help of AI, then every formula and calculation in it was checked by machine before it was listed.

  • Designed by
    TheCaseFilePress
  • Item type
    Digital download
  • Digital file type(s)
    1 PDF, 1 other file
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View programme terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Promotion Tracker

Hoa Spreadsheet

Self Employed Income

Hoa Budget Template

Hoa Management Spreadsheet

Membership Tracker Spreadsheet

Job Expense Tracker

Subcontractor Tracker Spreadsheet

Listed on 06 Sept, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates