PTA groups can split shared bills by budget share. The spreadsheet is the easy part.

First, agree on what the share measures, who approves it, and which families or participants belong in each expense. Turns out, a fair process matters more than a clever formula.

Here, budget share means an agreed percentage based on dues, fundraising contributions, private income bands, or another documented basis. It doesn't require publishing each household's income. If you use income, calculate the percentage privately and share only the final percentage with the people who need it.

For an official PTA expense, review your local bylaws, policies, and approval process before charging families. National PTA's budgeting and special funds guidance also advises local leaders to consult their bylaws and policies when developing and approving budgets.

Decide what "budget share" means

Equal, proportional, and usage-based splits solve different problems. Write the rule down before a receipt arrives, not after someone has already paid.

Method How it works Best fit Main tradeoff
Equal split Every participating family pays the same dollar amount. Schoolwide costs with similar benefits. Simple, but it ignores differences in capacity or attendance.
Budget-share split Each family pays an agreed percentage of the total. Recurring funds or expenses where contributors have different agreed capacities. More equitable for some groups, but the basis needs privacy and periodic review.
Usage-based split Participants pay according to units, nights, seats, or another usage measure. Optional trips, meals, materials, or activities. More precise, but someone must track participation.
Per-person split The cost is divided by the number of attendees or recipients. Food and supplies tied closely to headcount. Larger families may pay more overall.

Budget share isn't automatically fair. A dues-based percentage, an income-based percentage, and a fundraising-based percentage each send a different message about responsibility.

Use the smallest amount of personal data that will do the job. If exact income would make the group uncomfortable, calculate percentages privately or use broad contribution bands instead. Don't place household income on a sheet shared with the whole PTA.

Build the workbook in two tabs

Google Sheets or Excel can handle a small PTA's basic split. Use whichever tool the treasurer and reviewers can maintain consistently.

Two tabs are usually enough at first: People for the agreed basis and Expenses for transactions. Add a Payments tab when reimbursements begin moving in different directions.

  1. On the People tab, create columns for Family or member, Agreed basis, Split %, and Notes. The basis might be dues, contribution units, or a private value used only to calculate the percentage.
  2. Put the basis amounts in B2:B6. In C2, enter =IFERROR(B2/SUM($B$2:$B$6),0) and fill the formula down. Replace row 6 with the last participant row.
  3. Check the percentage total with =SUM(C2:C6). It should equal 100%, allowing for minor display rounding. Stop and fix the basis if it doesn't.
  4. On the Expenses tab, use columns for Date, Description, Total, Paid by, Receipt, each participant's Share, Status, and Notes.
  5. If Expenses!C2 contains the total and Family 1's percentage is in People!C2, calculate that family's share with =Expenses!$C2*People!$C$2. Adjust the reference for each participant.
  6. Add a status such as Open, Requested, or Paid. Add the payment date once the reimbursement is confirmed.

Enter 40% or 0.40 when you mean forty percent. Entering 40 creates a much larger share.

Keep formula cells protected if your spreadsheet tool supports range permissions. Give edit access to the treasurer and designated reviewers, while letting other participants view the rows they need. Sometimes the treasurer has the private inputs, the chair has the receipts, and another officer approves payments, which feels slightly fussy for a small event but keeps one shared sheet from becoming the only record.

Use version history when you need to understand a changed percentage or deleted row. It helps explain what changed, but it doesn't replace receipt storage or approval records.

Test one bill before you roll it out

Run a simple calculation before adding real expenses.

Suppose three families agree on bases of $600, $300, and $100. Their shares are 60%, 30%, and 10%. A $450 supply bill would therefore produce assigned shares of $270, $135, and $45.

If Family A paid the entire bill, its net position is positive $180 because it paid $450 but owed $270. Family B shows negative $135, and Family C shows negative $45. Those negative balances identify what they owe under the agreed rule.

This is only a math check. It isn't a recommended contribution level.

The test also catches practical mistakes. A percentage can be correct while pointing to the wrong family, the wrong expense row, or an outdated basis. Test one row, then ask another reviewer to repeat the calculation.

Turn assigned shares into reimbursements

A shared expense row tells you what happened. A payment row tells you whether the money was settled.

Create a summary by person with these fields:

Summary field Example formula Purpose
Total paid =SUMIF(Expenses!$D:$D,A2,Expenses!$C:$C) Adds expenses paid by the person in A2.
Assigned share =SUM(Expenses!F2:F100) Adds that person's share column. Adjust F for each person.
Net balance =B2-C2 Shows whether the person paid more or less than their assigned share.

A positive net means the person paid more than their share. A negative net means they paid less.

Don't mix direct repayments into the expense total. On the Payments tab, record the date, sender, recipient, amount, related expense or settlement, payment method, and confirmation status. A payment app, check, or cash entry can all be recorded as text; the sheet's job is to preserve the record.

A clear request might say: "The sheet shows your share of the supplies as $135. Please send that amount to the designated payer and mark the payment complete once it clears." Use the method your PTA has approved.

Review the sheet on a regular rhythm

Set aside about 10 minutes once a week during an active event or fundraising period. The point isn't to stare at the spreadsheet. It is to catch missing receipts and wrong balances while the details are still fresh.

  • [ ] Add each new expense, payer, receipt, and description.
  • [ ] Confirm that the expense belongs in the chosen split.
  • [ ] Check that the percentages and formulas still match the approved rule.
  • [ ] Compare the summary with payments received.
  • [ ] Mark settled rows and record the payment date.

During a quiet period, a review before the next reimbursement may be enough. Keep receipts in an organized digital or paper folder, and export a copy when your PTA's recordkeeping process calls for one.

Thing is, most disputes are about scope rather than arithmetic. A family was not attending, the contribution basis changed, a receipt was entered twice, or a payment was marked complete before anyone confirmed it.

Add an effective date whenever percentages change. Don't overwrite an old percentage for expenses already approved; record the new rule separately or identify which expenses use the new basis.

Know when another split works better

Use an equal split for a cost that benefits every participating family in roughly the same way. It avoids collecting sensitive information and keeps the explanation short.

Use a usage-based or per-person split when only some families attend an activity, receive materials, or use a service. A budget percentage can be unfair when one family receives much more or much less of the benefit.

Use a budget-share split for a recurring fund when the group has agreed that contributors should carry different percentages. Put that agreement in writing, including how the group handles new families, withdrawals, missed payments, and changes in the basis.

To be honest, a spreadsheet is not a substitute for PTA approval. A percentage tells you how to divide an approved expense; it does not authorize the purchase or payment. Follow the bylaws and local policies for approving budgets, special funds, reimbursements, and access to PTA money.

If the group has many transactions, several approvers, or frequent disputes, add stronger review procedures or consider a dedicated tracking tool. Keep the same essentials either way: the approved rule, the receipt, the payer, the assigned share, and the settlement record.

At the next treasurer meeting, agree on the split basis, write the rule in one sentence, and test it with one real expense. Then lock the formula cells, assign reviewers, and send the first reimbursement request from the finished sheet.