--- title: "HOA & Condo Association Books (Excel) | MCC Solutions" description: "Excel workbook for volunteer treasurers of small HOAs and condo associations: a dues roll with months behind, budget vs actual, a reserve fund tracker…" url: "https://mcc-solutionsnj.com/toolkits/hoa-condo-association-books" --- Excel workbook # HOA and Condo Association Books: Dues Roll, Budget vs Actual, Reserves and a Treasurer Report in Excel Track who has paid dues and who is behind, compare spending to the budget, follow the reserve fund and hand the board a one-page report. **$39** one time · 14-day full refund · example and blank copies · download link by email Buy now, $39 🌙 The desk is asleep. The store never is. Every kit and ebook downloads the moment you pay, day or night. Questions get answered after we open in the morning. [Browse the store](/toolkits) Who it is for Volunteer treasurers and small self-managed associations of up to about 100 units. Not the right fit if Your association has well over 100 units or a management company, or you need a professional reserve study. Why it is different - It is built around the dues roll, which is the part volunteer treasurers struggle with. - Payments are applied to the oldest dues first, so months behind is clear for every unit. - A filled example for an invented 24-unit condo and a blank copy with working formulas. What is inside - **Start Here.** Purpose, which cells to fill in and what the workbook is not. - **Setup.** Your fiscal year, number of units, monthly dues, any special assessment, late fee, reserve target and categories. - **Dues Roll.** One row per unit with twelve months of payments, what is owed to date, the balance and how many months behind. - **Income and Expense.** Budget and actual for every category by month, with variance and flags when a line is off by more than the threshold you set. - **Reserves.** Reserve balance by month, plus a simple list of components with the yearly set-aside each needs. - **Treasurer Report.** A one-page board summary: dues collected, delinquent units, budget variances and the reserve balance. - **Checks.** Unit counts, totals that do not agree and negative balances. A look inside ## Example data, real formulas [![Treasurer Report tab of the HOA and Condo Association Books, with example data](/img/toolkits/hoa-condo-association-books/a.png)](/img/toolkits/hoa-condo-association-books/a.png) Treasurer Report tab with example data. Made-up numbers. [![Dues Roll tab of the HOA and Condo Association Books, with example data](/img/toolkits/hoa-condo-association-books/b.png)](/img/toolkits/hoa-condo-association-books/b.png) Dues Roll tab with example data. Made-up numbers. Get it ## HOA and Condo Association Books Or pay with PayPal Uses the email and terms box above. You get the same download link by email. ZIP code (for sales tax) Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly. Get every update for a year, $29: the [Yearly Updates Pass](/updates-pass?kit=hoa-condo-association-books) gives you each refreshed edition we release of the kits you own. One payment, no automatic renewal. Delivered as a zip with a filled example and a blank copy. Built for Excel, tested in LibreOffice; it should open in Google Sheets but not every feature is tested there. For one business, your own use. General information, not accounting, tax or legal advice. A bookkeeping aid, not legal, tax or accounting advice. Your governing documents and state law control what you must do. The reserve section is a simple planning estimate, not a reserve study. Ask the association's attorney or accountant. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right. Ways to get it ## Just this kit, or more This kit **$39 one time** HOA & Condo Association Books. Buy this kit Membership **$29 a month** Every kit and document pack in the store, including new ones. Cancel any time. [See the membership](/membership) Questions ## Common questions **What do I get and how is it delivered?** The HOA & Condo Association Books as two Excel files in one zip: a filled-in EXAMPLE so you can see every tab working, and a BLANK copy for your own numbers, plus a README. The download link arrives by email after payment. **Will it open on a Mac, Google Sheets or my phone?** Built for Excel and tested in LibreOffice, which runs on Mac and Windows; it should open in Google Sheets, but not every feature is tested there. Phone spreadsheet apps are not tested. If a file will not open or something looks wrong, reply to your order email and we will make it right. If it is not right for you, email us within 14 days of buying for a full refund. **Is this legal or tax advice?** A bookkeeping aid, not legal, tax or accounting advice. Your governing documents and state law control what you must do. **Is it the right fit for me?** It is made for volunteer treasurers and small self-managed associations of up to about 100 units. Skip it if your association has well over 100 units or a management company, or you need a professional reserve study. Rather hand it off? ### We can keep the books for you each month If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation. [Get a bookkeeping quote](/bookkeeping/#interest) [Free books health check](/bookkeeping/health-check) Prefer to keep it yourself but want a hand getting started? [Book a 45 minute setup session](/workbook-setup-session) ($65). Also from MCC Solutions [### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. $19](/toolkits/month-end-close-workbook)[### Sales-Channel Profit Tracker Which channel makes you money, and which one only looks busy? Sales minus cost of goods, shipping, platform and card fees and event costs, by channel, by event and by month. $24](/toolkits/sales-channel-profit-tracker) ## More bookkeeping and business toolkits - [Holiday and Gift Budget Tracker](/toolkits/holiday-gift-budget-tracker) $14 - [Home Buying Cost and Affordability Planner](/toolkits/home-buying-cost-planner) $19 - [Home Project and Renovation Budget Tracker](/toolkits/home-project-budget-tracker) $19 - [Hospitality and Food Service Resume Template Pack](/toolkits/hospitality-food-service-resume-template-pack) $15 - [House Cleaning Business Kit](/toolkits/house-cleaning-business-kit) $24 - [Household Budget and Bill Calendar](/toolkits/household-budget-bill-calendar) $19 [See every toolkit and document pack](/toolkits/all) ## Rather have someone do the books? [Get a Bookkeeping Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)