HOA Board Packet With AI: Agenda, Financials and Open Items

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for HOA Board Packet With AI: Agenda, Financials and Open Items.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for HOA Board Packet With AI: Agenda, Financials and Open Items.

An HOA manager can assemble the monthly board packet faster by keeping a fixed checklist of required items, asking AI to compare the folder against it, and using templates to draft the agenda, financial summary and open-items list from the source reports. The board still approves the content before anything is distributed.

The missing-items check is the part most managers undervalue. A packet that is eighty per cent right but lacks the reserve report or last month's minutes generates emails, a delayed meeting, or a vote taken on partial information. Assembly time shrinks with templates; errors shrink because something checks the pile against the list before it leaves.

Follow me on Instagram@sagnikteaches

Start with the packet list, not the prompt

Before any AI is involved, write down what your board actually receives. Your governing documents may require certain financial reports, and the board will have habits beyond that. A typical list, to adapt:

Connect on LinkedInSagnik Bhattacharya
  1. Agenda with times and the person leading each item.
  2. Draft minutes of the previous meeting.
  3. Manager's report: activity, complaints, compliance counts.
  4. Balance sheet and income statement against budget.
  5. Bank and reserve account balances and the reconciliation sign-off.
  6. Accounts receivable ageing (delinquency) summary.
  7. Open work orders and vendor updates.
  8. Architectural requests awaiting decision.
  9. Correspondence needing board action.
  10. Open-items log from last month with status.

Save it as a plain checklist with a column for the source of each item (accounting export, work-order system, inbox folder) and who owns it. That list becomes the standing instruction for everything below. If you manage several associations, keep one list per community, because boards differ on what they want to see.

Subscribe on YouTube@sagnikteaches

Run the missing-items check first

Drop the month's files into a folder and paste the file names, or a short description of each file, into your AI tool along with the checklist. You are not asking it to analyse the content yet; you are asking it to compare a list with a list.

Here is our board packet checklist and the list of files in this month's
folder. For each checklist item, mark Present, Missing or Unclear (file name
does not make the content obvious). List any file that is not on the
checklist. Do not guess contents from file names that are ambiguous.

CHECKLIST:
[paste]

FILES:
[paste file names with dates]

An illustrative reply: "Present: agenda draft, balance sheet (dated 31 Oct), income statement. Missing: reserve account statement, accounts receivable ageing, draft minutes of the previous meeting. Unclear: 'Report_final2.pdf' (could be the manager's report or the reserve study). Extra: 'Pool_quote_v3.pdf' (not on checklist; attach to open items?)". That took thirty seconds and caught three gaps before the board did. Ask the model to also return a short chase list: who to ask for each missing item and a suggested message.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Draft the agenda from a standing template

Agendas repeat. Give the model last month's agenda, the open-items log and any new items, and ask it to produce this month's in the same order, with carried-over items marked. Include your meeting's required order if the bylaws set one, such as call to order, quorum, approval of minutes, reports, old business, new business, owner comments and adjournment.

Using last month's agenda as the format, draft this month's agenda.
Keep the standing order of business exactly. Under Old Business, list every
open item from the log whose status is not Closed, with the owner's name and
due date. Under New Business, list: [new items]. Suggest a time allowance in
minutes for each item totalling no more than 90 minutes. Mark any item that
needs a vote with (VOTE).

The (VOTE) marker is worth keeping. It lets the president see at a glance how many motions to expect, and it reminds the manager to attach supporting papers to those items. Check the time allowances; the model will happily propose twenty minutes for the pool resurfacing and five for the budget, which may be exactly backwards.

A financial summary prompt that stays honest

Boards mostly want to know three things: are we within budget, is the money safe, and who owes us. A summary should answer those in plain English with the numbers from the statements, never numbers the model computed itself unless you ask it to show the sum.

You are summarising an HOA's monthly financials for a volunteer board.
Use ONLY the figures in the data below. Do not estimate or round differently.
Write under 200 words in plain English:
1. Operating result against budget for the month and year to date.
2. The three line items with the largest variance, and the amount.
3. Operating and reserve cash balances.
4. Total delinquent assessments and the change since last month.
End with "Questions for the manager" (maximum three), phrased as questions
the treasurer might ask. Flag any number you could not find.

DATA:
[paste summary totals, not owner-level ledger]

Illustrative output for a fictional 220-home community: "Operating income was $41,800 against a budget of $40,500 for October. Year to date, expenses are $18,600 over budget. Largest variances: landscaping (+$9,200, snow removal contract billed early), insurance (+$4,100), utilities (-$2,300). Operating cash is $62,400 and reserves are $215,900. Delinquent assessments total $14,300, up from $11,800. Questions: Is the landscaping overage timing or a real overspend? Does the insurance increase include the new umbrella policy? Which accounts moved into the 90-day bucket?" The treasurer's reaction is the test. If they say "that is exactly what I would have asked", the template works.

The check is mechanical: tick each figure in the summary against the source statement before it goes out. If any number differs, discard the summary and look at how you pasted the data. Merged cells and screenshots of tables cause most of those errors. To see where the packet sits among a manager's other repeat jobs, read six HOA management jobs worth automating.

Keep the open-items log as a living table

The open-items log is the board's memory. Each line records something promised or pending: a roof leak quote, a response to an owner, a pending insurance renewal. The common failure is that items are added at meetings, forgotten in the next packet, and reappear in the annual meeting as complaints.

ItemRaisedOwnerDueStatusLast update
Obtain three bids for gate repairAug 12ManagerOct 15Overdue: two bids inThird bid chased Oct 20
Reply to owner about drainage at lot 41Sep 9SecretaryOct 1ClosedLetter sent Sep 28
Renew pool operator contractSep 9TreasurerNov 30OpenRenewal terms requested

After each meeting, paste the minutes or your notes and the current log into the model and ask it to update the table: close what was resolved, add new actions with an owner and date, and move any item whose date has passed to Overdue. Tell it to list every change it made in a separate list so you can check them. A model that silently rewrites a status is worse than no model.

Update the open-items log using the meeting notes below.
Return: (1) the updated table, (2) a list of every change you made, with
the sentence in the notes that justifies it, (3) any action in the notes you
could not assign to an owner. Do not mark an item Closed unless the notes say
it was completed.

That third return is the quiet value. Meetings produce vague actions like "someone should look at the fence"; a prompt that surfaces unowned items forces the manager to ask the board who. Minutes themselves are covered in the tutorial on AI-drafted board minutes, and the two fit together: minutes record decisions, the log tracks what happens after them.

The manager's report, drafted from your own notes

The manager's report is where narrative lives: what the property looked like, what owners asked, what is coming. Keep a running notes file during the month (a few bullet points a week) and paste it at month end. Ask the model to sort the notes under fixed headings, such as Grounds and common areas, Owner communications, Compliance, Vendors and Upcoming. It should not add anything you did not write.

Before and after, illustrative. Your notes: "Oct 3 pool closed for season. Oct 11 three owners asked about leaf pickup. Oct 18 gate arm broken again, vendor says part due 28th. 6 violation letters sent, 4 resolved." The draft: "The pool closed for the season on 3 October. Three owners asked about leaf collection; the schedule has been posted on the notice board. The entrance gate arm failed again on 18 October and the vendor expects the replacement part on 28 October (see open items). Six violation letters went out in October and four were resolved by month end." The manager edits the tone, confirms the facts and moves on. The format does the work; the facts are all theirs.

Summarising correspondence without losing the detail

The board does not need forty emails; it needs the three that require a decision. Paste a month's correspondence headings and bodies with owner names replaced by lot numbers, and ask for a table: topic, who wrote, ask in one line, suggested category (for information, for action, for the manager to handle), and the date the board last saw the issue. Check every "for information" label, because the model will sometimes downgrade something legally sensitive, such as a lawyer's letter, to a routine note. Instruct it: "Anything mentioning a lawyer, insurance claim, discrimination, harassment or injury must be categorised For action." Then read those emails yourself.

Check the packet before it goes to the board

A final pass works as a second pair of eyes. Paste the complete assembled text, or a list of each document's title and first paragraph, and ask for inconsistencies:

  • Dates that differ between the agenda and the minutes' heading.
  • A delinquency total in the manager's report that differs from the ageing summary.
  • An item on the agenda with no supporting document.
  • Votes listed on the agenda that lack a draft motion.
  • Names or lot numbers that appear in a document that goes to owners.

The last one matters most when part of the packet is posted for owners. Decide in advance which sections are board-only, such as legal matters and personal information, and which can be shared. Your governing documents and applicable law decide what owners may see. If unsure, ask your association's lawyer once, and write the answer into the checklist.

Approval before distribution

Add a line at the top of every draft: "DRAFT for board approval. Not for distribution." The president or secretary reads it, corrects it and releases it. With a clear checklist and short summaries that read is quick; time it on the first few packets so the board knows what it is signing up for. Keep a record of who approved and when. If the board prefers, hold a 24-hour window: draft goes out to officers, final to the full board the next morning. Nobody is bound to the AI's drafting; they are bound to the content they approved.

Timing one month's packet at a 150-home association

Take an illustrative association of 150 homes, one part-time manager and a volunteer treasurer. Packets currently take about four hours: pulling reports, retyping the agenda, writing the manager's report, chasing the minutes. Try it for one month.

  1. Write the packet checklist (45 minutes, once).
  2. Run the missing-items check on day one of packet week and send the chase list.
  3. Draft the agenda and open-items update from the template and last month's file (about 15 minutes with review).
  4. Paste totals into the financial summary prompt, then tick every figure against the statements (20 minutes).
  5. Draft the manager's report from the notes file (15 minutes).
  6. Run the consistency pass, then send to the president for approval.

Time the whole thing against your usual four hours. The point is a measured number for the board, not a boast. If the first packet is faster by half an hour only, that is fine; templates improve as you correct them, and the checklist's main benefit is fewer last-minute scrambles.

Walking a budget variance through the model

The financial summary is only as good as the explanations behind each variance, and those live in the manager's head, not the statement. Give the model both. Say the statement shows landscaping $9,200 over budget year to date. Add a one-line note from the manager: "Snow contract invoiced in full in October; budget assumed monthly billing." Ask the model to draft the board-ready sentence: "Landscaping is $9,200 over budget year to date because the seasonal snow contract was invoiced in a single payment in October; the budget spread it over six months, so the variance should reverse by March." Notice that the model only rephrased facts supplied by the manager. If you give it a variance with no note, tell it to write "Reason to be confirmed" rather than invent one. Boards forgive "we are checking"; they do not forgive an explanation that turns out to be made up.

Reserve and cash questions the board will ask

Reserve funds draw the most scrutiny. Keep a standing paragraph in the packet with three facts: the reserve balance, the planned contribution for the year against actual to date, and any withdrawals approved since the last meeting with the minute reference. Paste those figures with the reserve study's next three scheduled replacements and ask for a short paragraph. A sample output: "Reserves stand at $215,900. Contributions are on plan at $3,600 a month. No withdrawals this month. The study schedules the clubhouse roof (estimated $48,000) and pool resurfacing next; the board has not yet requested bids." Then ask the model for two questions an owner might raise at the annual meeting. If one of them is "why has the roof not been bid when the study dates it to next year?", you have a useful prompt for the board before an owner asks it.

Vendor and work-order updates in one table

Export open work orders from your system, or list them from your notes, and ask for a table grouped by vendor: job, date opened, days open, last action, cost approved, cost to date. Instruct the model to sort by days open, longest first, and to flag anything above a threshold you set, such as thirty days. For a gate repair open 55 days with two of three bids received, the table makes the delay visible without a speech. Add a column "Needs board decision" with Yes or No, filled by you. This turns a page of chatter into the three items the board must vote on, and the bids themselves can be compared using the approach in the vendor bids tutorial.

A seasonal calendar so the packet anticipates the year

Packets get easier when the manager knows what usually arrives in each month. Ask the model to build a twelve-month calendar from last year's packets: paste the table of contents of each month's packet and ask which items recurred. Then check and complete it by hand. A plausible result: January, draft budget review; February, insurance renewal quotes; March, annual meeting notice preparation; April, landscaping contract review; May, pool opening inspections; September, budget workshop; October, reserve study check; November, winter readiness. Pin the list above the checklist. Each month the packet starts with "what is due this month", and nothing slides because it was nobody's reminder. Edit the calendar whenever your governing documents set a fixed date, such as a budget delivery deadline to owners.

Preparing the board's likely questions

Before the meeting, paste the finished draft packet and ask: "List the ten questions a volunteer board member is most likely to ask after reading this, with the page where the answer sits, or 'Not in packet' if it is missing." Every "Not in packet" is either a gap to fill now or a question the manager should prepare to answer verbally. In an illustrative run, five of the ten might already be covered, three point to a page, and two expose real holes, perhaps the cost of a pending legal matter or why the electric bill rose. It takes two minutes and it is the cheapest way to avoid the phrase "I'll get back to you on that" appearing six times in the minutes.

Filing, versions and keeping the record clean

Save the approved packet as a PDF with the meeting date in the file name, and keep the AI-assisted drafts out of the permanent record folder, since only the approved version represents the board. Store the prompts you used in a shared document so the next manager, or a temporary replacement, can repeat the process. Retention periods for board records are set by your governing documents and applicable law; ask the association's lawyer once and put the answer in the checklist. If your tool keeps chat history, decide who may see it, because pasted financial data lingers there.

Five packet faults, the symptom and the fix

Most early problems are not the model's prose. They are inputs and habits, and each one leaves a visible trace in the packet if you know where to look.

FaultHow it shows upFix
Summary built from last month's statementTotals that match October's report in November's packetTick every figure against the source statement before release
Orphan items in the logLines with no owner or no due date, carried month after monthReject any line missing either; ask the board who owns it
An agenda that grows every monthClosed items still listed under Old BusinessState in the prompt that Closed items drop off after one report
A packet the board stops readingQuestions at the meeting that page 3 already answeredKeep the summary to one page and put detail behind it
Owner names reaching the modelSurnames or lot-plus-name pairs in pasted textPaste lot numbers only and check the tool's data terms

Once the packet routine is stable, the same files make it easier to prepare for the owner meeting: the year's open-items log and financial summaries become the raw material for the annual meeting notice and report, and the board's decisions about collections can be summarised alongside the figures from the escalation ladder tutorial.

Packet questions managers ask

Can I paste the whole financial statement into an AI tool?

Only if your tool's terms allow business data and you have removed owner names and account numbers. Summarise from the report totals, not owner-level ledgers, and always check the totals in the summary against the original statement.

What should the board see before the packet goes to owners?

Everything. The manager assembles a draft, the president or secretary approves content, and only then does it go to the board or owners. Mark the draft clearly so nobody forwards it early.

How long does a packet take with this method?

Time one month's packet before and after. Assembly steps such as retyping the agenda and chasing missing files shrink most; reading, checking figures and approving do not, and should not. Expect the first month to be slower while you build the checklist and templates.

Which parts of the packet should AI never write?

Anything that states a legal position, a delinquency decision, or a vendor award. Drafts of those come from the board or counsel. AI can organise facts around them.

Does the open-items log need special software?

No. A shared spreadsheet with columns for item, owner, date raised, due date and status works, and the AI can read an export of it each month.

Further reads

Sources: general HOA management practice. No vendor pricing quoted; check your governing documents for what the board must receive and when.

Want your monthly reporting set up properly?

On a 1:1 call we'll walk through how your packet is built today, find the steps worth automating first, and decide which tools you already own can handle them.

Book a 1:1 call with me