A PTA bill calendar is a shared record of what the group owes, when it is due, which budget line covers it, and who is handling the payment. It can be a Google Sheet, an Excel file, or a paper register. Fancy software isn't required.
Start with last year's bills, then rebuild the list around this year's approved budget. A useful calendar answers four things quickly: the next due date, expected amount, responsible person, and receipt location.
Turns out, consistency matters more than the format. Keep the calendar beside, not instead of, the PTA's ledger, bank records, approvals, and receipts.
Start with last year's bills
Pull together last year's bill list, budget, invoices, reimbursement records, and meeting notes. Separate recurring costs from seasonal bills, one-time purchases, and expenses the PTA no longer expects to repeat.
Prior records are a baseline, not automatic permission to repeat every expense. Check each item against the current budget and confirm whether a new approval is needed under your PTA's bylaws or state association rules.
Have board members and event leads flag likely expenses before the treasurer loads the full calendar. A PTA budget planning overview from AIM Companies also recommends board and general member involvement and connecting purchases to PTA goals. Use it as a planning reference, not as a substitute for your governing documents.
For each bill, write down its purpose in plain language. "Teacher support," "literacy program," and "school event" are more useful than a vague label such as "miscellaneous."
Choose a format your group will actually maintain
Paper can work when one treasurer handles most updates. A shared spreadsheet makes more sense when several authorized volunteers need to see current amounts, due dates, or payment status.
| Group situation | Practical format | Setup note |
|---|---|---|
| One treasurer updates a short list | Printable form | Review it monthly and file it with supporting records |
| Several volunteers need a current view | Shared spreadsheet | Limit edit access to people who maintain or review the file |
| The board wants both live access and meeting records | Spreadsheet plus dated print or PDF | Save the reviewed version with the meeting records if your retention practice calls for it |
Some free bill spreadsheet resources, such as Tiller's bill spreadsheet page, can provide a starting grid. Check any current template before copying it. Its labels won't know your PTA's budget categories, approval rules, or recordkeeping routine.
Give edit access only to people who need to change the calendar. Members can usually use view or comment access when that fits the group's policy, while the treasurer and a designated backup handle routine updates.
Add columns that explain every payment
Use one row for each bill, reimbursement, or other payment obligation. Recurring costs should get separate rows for each occurrence, so the due date and receipt can be matched without guesswork.
Bill or vendor: Name the supplier, program, or expense type.
Due date: Enter the actual date, not just "October."
Expected amount: Use the invoice amount or a reasonable estimate for a variable bill.
Actual paid amount: Add this when the final amount differs from the estimate.
Budget line or purpose: Connect the expense to a program, event, or approved priority.
Owner or payer: Name the person responsible for checking, paying, or submitting the request.
Approval reference: Add a meeting note, budget reference, or other approval record when one is required.
Status: Use consistent labels such as Planned, Submitted, Paid, On hold, and Overdue.
Payment date and reference: Record when the payment was made and the check, transfer, or other internal reference.
Receipt location: Add a file name, shared-folder location, or link to the supporting document.
Notes: Record deposits, changed amounts, missing documents, or follow-up needed.
Keep payment status separate from approval status. A reimbursement can be approved and still unpaid.
If expected amounts are in column C and status is in column H, =SUM(C2:C100) gives the expected total, =SUMIF(H2:H100,"Paid",C2:C100) totals rows marked Paid, and =COUNTIF(H2:H100,"Overdue") counts overdue rows. These formulas support review; they don't replace the PTA's accounting records.
Set up the calendar in one sitting
- Create a sheet named
Bill Calendar. Add the columns above before entering data. - Copy in known recurring and seasonal bills from last year's records. Remove items that no longer apply.
- Enter due dates as dates and sort the sheet by due date. A filter can help the treasurer view unpaid or upcoming rows without changing the whole file.
- Add a status dropdown with a short, agreed list. Keep the written status visible even if you also use colors.
- Use conditional formatting carefully. For example, you might highlight Paid, Due soon, and Overdue rows differently, but don't rely on color alone.
- Share the file with the treasurer, backup, and board reviewers according to your PTA's policy. A public edit link creates unnecessary risk of accidental changes.
- Test the process with one upcoming bill. Enter its approval reference, receipt location, status, and payment record before loading the rest.
A built-in to-do list template can serve as a blank starting point, but it is still a task list until you add amounts, budget ties, payment dates, and receipt references.
Connect bills to approvals and receipts
The Purpose column gives the board a quick way to see what each expense supports. It also makes monthly budget review less abstract because the group can compare actual spending with planned programs.
Store each invoice, receipt, reimbursement form, or other supporting document in a shared folder with sensible access limits. Use a matching file name or link in the calendar. If a document contains personal information, don't give it wider access than necessary.
Thing is, the calendar is a visibility tool. It doesn't authorize spending, move money, or prove that a payment cleared. Follow the PTA's bylaws, state association guidance, district requirements, and internal approval process for those decisions.
If your PTA is in Utah, the Utah PTA treasurer handbook referenced in the source material includes manual report forms in Appendix 2. That is a Utah-specific resource, so verify the current handbook and don't treat it as a national PTA requirement.
Review the calendar and reimbursements on a set cadence
A treasurer can glance at upcoming bills weekly, especially before a large event. A formal review usually fits naturally with the PTA's monthly board meeting, when the group can compare the calendar with the budget and payment records.
During the review, sort for unpaid and overdue items first. Confirm that expected amounts still look reasonable, match Paid rows to receipts and payment references, and flag any difference between the estimate and the amount actually paid. If a bill is delayed, document who will follow up and when.
For a volunteer reimbursement, record the request as Submitted with the person's name, purpose, amount, receipt, and budget line. An authorized reviewer then approves it under the PTA's process. After the reimbursement is made, add the payment date and reference, link the supporting record, and mark it Paid.
Approval is not payment.
A short reminder can keep the next review focused: "Upcoming PTA bills are listed in the calendar. Please check the rows assigned to you and add missing receipts or approval details before the next meeting."
If your recordkeeping practice includes meeting archives, save a dated print or PDF after the review. Follow the PTA's retention policy rather than choosing a universal storage period from a generic template.
Avoid the tracking mistakes that cause confusion
Leaving the owner blank is a common failure point. A bill can be visible to everyone and still belong to no one.
Don't put several unrelated payments in one row. Separate rows make it easier to sort by due date, total amounts, and connect each expense to its own receipt.
Don't overwrite the original estimate when the final amount changes. Keep the expected amount, add the actual paid amount, and explain the difference in Notes.
Limit edit access. View access is enough for many members, and board reviewers can use comments when they don't need to rewrite payment data.
Some months are tidy. Others aren't, especially around school events. If the calendar falls behind, update the next due bills first, then reconcile older rows rather than trying to rebuild everything at once.
Questions PTA treasurers often ask
Is a bill calendar the same as a PTA budget?
No. A budget sets expected income and spending priorities. A bill calendar schedules specific obligations and shows who is handling each one.
How often should a PTA review its bill calendar?
A treasurer can check upcoming items weekly. A monthly board review gives the group a regular point to compare bills, payments, receipts, and budget totals.
Should every PTA member have edit access?
Not necessarily. Give edit access to the treasurer, backup, and designated reviewers, then provide view or comment access to others when appropriate.
What should happen when a volunteer pays first?
Log the reimbursement request with its receipt, purpose, amount, and budget line. Keep it in a Submitted or pending state until the authorized approval and reimbursement steps are finished.
This week, open last year's records, create the columns above, and enter only the bills you can verify. Test the workflow on one upcoming payment, then schedule the first monthly review.