An income-based split can be fair for a small PTA volunteer team. The catch is that it belongs in a voluntary cost-sharing agreement, not in place of the PTA's budget and reimbursement controls. Set the rule before anyone shops, keep income details private, and attach every claim to an approval and a receipt.

That line protects the group. When a purchase is board-approved, it should follow the treasurer's process like any other PTA expense, and volunteers shouldn't be expected to absorb a bigger share just because they earn more. Save the ratio method for costs the group knowingly agrees to share and that the group's rules allow in the first place.

Choose the basis before you choose the percentage

Income-based sharing works best for recurring costs that the same small group covers again and again, the kind where equal payments start to feel genuinely burdensome. Almost anywhere else it's the wrong tool. If the expense tracks actual use, or it's a formal PTA obligation, or nobody approved the purchase, pick a different rule.

Shared-cost situation Rule to consider Why
Similar incomes and a small one-time cost Equal split It requires little tracking.
A meaningful income gap and a recurring agreed cost Income-proportional split Each person contributes according to the chosen financial basis.
Different use or attendance Usage-based split The people who use more pay more.
Different volunteer workloads Separate time rule or hybrid Money and volunteer hours are different contributions.
An approved PTA obligation PTA reimbursement process The treasurer's records and authorization rules come first.

Turns out, the most practical rule is usually the least ambitious one. If the group can't agree on what a payment even represents, changing percentages won't settle the dispute.

Calculate an income-proportional share

Pick one income basis and apply it to everyone. Annual gross income works. Take-home income works. A direct contribution percentage works too. None of these is automatically correct, so write the choice down.

person ratio = person's agreed basis / total agreed basis

person share = approved expense * person ratio

Say a three-person team uses annual figures of $100,000, $80,000, and $40,000. Those total $220,000, which produces unrounded ratios of 45.45%, 36.36%, and 18.18%. A $500 approved cost then breaks into $227.27, $181.82, and $90.91.

The shares add back to $500.00.

Keep more precision in the spreadsheet than you display. If the group types rounded percentages in directly, a leftover penny is inevitable, so decide now who absorbs it under a rule everyone accepts. One easy fix: calculate the last ratio as =1-SUM(B2:B3) and the ratios will total 1.00 on their own.

Nobody has to share pay stubs. A range protects privacy, but a range alone can't produce one precise ratio. Agree on a midpoint, a tier, or a single percentage instead, then store only the final ratio in the shared sheet. If even that feels intrusive, drop the income angle and choose a non-income method.

Write the agreement before anyone spends

Write the rule down before the first receipt exists, because a short agreement stops the same argument from coming back after every event, and it gives whoever inherits the treasurer job something concrete to follow instead of guesswork.

  1. Define the eligible costs. Say whether the rule covers supplies, snacks, travel, meeting costs, or only certain categories. Personal purchases and anything unapproved stay out.
  2. Name the income basis. Write down whether the group uses gross income, take-home income, another agreed figure, or direct percentages. Keep raw income details out of any workbook the whole group can open.
  3. Record the ratios and rounding rule. List each person's percentage, check the total comes to 100%, and note who receives any rounding adjustment.
  4. Set approval and documentation rules. Every expense needs a date, purpose, amount, approver, payer, and receipt. Follow any PTA budget controls or two-person approval steps the group already has.
  5. Set the settlement schedule. Pick a weekly, monthly, or event-based review, and write down when reimbursements are due.
  6. Handle changes openly. Decide now how a new volunteer, a departure, or a material change in the agreed basis gets treated. No retroactive changes unless everyone approves them.

You can adapt this wording:

For approved shared costs, we will use the ratios recorded in the Settings tab: [Name] [X]%, [Name] [Y]%, and [Name] [Z]%. A purchase needs approval before payment and a receipt afterward. Reimbursements follow the treasurer's process and the schedule recorded here. Any ratio change requires group approval and applies only from the agreed effective date.

Plain language is fine here. The agreement doesn't need to sound legal.

Keep PTA reimbursement separate from private cost sharing

Personal sharing and PTA reimbursement are different ledgers, full stop. Before anyone books a purchase as a PTA expense, check the approved budget, the authorization rules, and the payment process. The ratio tracker should never become a second set of books.

If a volunteer fronts an approved cost, record who paid, the amount, the date, the purpose, the receipt, the approval, and the reimbursement that followed. Then run it through whatever review process the PTA requires. A spreadsheet can hold that record. It cannot approve an expense.

Thing is, the highest-income volunteer shouldn't automatically turn into the group's bank. The ratio sets final responsibility. It doesn't decide who floats every purchase.

Build the Google Sheets tracker

Give each job its own tab so the math, the receipts, and the settlements stay easy to audit. A simple layout:

Tab Suggested columns Purpose
Settings Name, Ratio, Notes Stores the final agreed percentages.
Transactions Date, Description, Amount, Paid by, Approved?, Receipt link, Category, Notes Records each approved cost.
Payments Date, From, To, Amount, Reference Records each reimbursement or settlement.
Summary Name, Ratio, Share owed, Approved costs paid, Payments received, Payments sent, Net position Shows who has paid too much or too little.

Type ratios as decimals, 0.45454545 style, and format the cells as percentages. =SUM(Settings!B2:B4) should return 1.00.

With the summary columns above, these formulas carry the core calculations:

  • C2 for share owed: =SUMIFS(Transactions!$C:$C,Transactions!$E:$E,"Yes")*B2
  • D2 for approved costs paid: =SUMIFS(Transactions!$C:$C,Transactions!$D:$D,A2,Transactions!$E:$E,"Yes")
  • E2 for payments received: =SUMIFS(Payments!$D:$D,Payments!$C:$C,A2)
  • F2 for payments sent: =SUMIFS(Payments!$D:$D,Payments!$B:$B,A2)
  • G2 for net position: =D2-C2+F2-E2

Read the net position like this: positive means the group still owes that person, negative means that person still owes the group. For a one-off calculation, =C2*$B$2 works when C2 holds the expense and B2 holds the ratio.

Edit access goes to the treasurer and designated approvers only. Wider access can be view-only if that matches the group's privacy expectations. Protect the formula cells, make approval status a Yes/No dropdown, freeze the header row, and back up the receipt files somewhere safe.

Full income figures never belong in a widely shared workbook. A ratio alone is still financial information.

Use a repeatable reimbursement process

Same steps every time. Before a purchase, the requester records the description, expected amount, category, and approver. After paying, they add the actual amount, the payer, the receipt link, and a short explanation for any difference from the estimate.

The treasurer checks the approval and the receipt, confirms the cost belongs in the shared category, and records the reimbursement. Name the sender and the recipient in the payment record. Then mark the transaction settled instead of deleting the original row.

Review the sheet after each event, or on the group's regular monthly schedule. Set the approved transactions, receipts, and payments beside the PTA's own records. Small discrepancies are easier to fix while everyone still remembers what happened.

A reminder can stay matter-of-fact:

Hi team, I paid $[amount] for [approved item] on [date]. Under our recorded ratios, your share is $[amount]. The receipt and approval are linked in the tracker. Please settle by [date], or reply with a correction before then.

Keep the message private when the expense details or the income-based ratios are sensitive. Not every group chat is the right audience.

Understand the recordkeeping and tax limits

A good tracker helps document a reimbursement. That's all it does. Whether a volunteer expense qualifies for a tax deduction is a separate question.

The IRS guidance for volunteers says an expense must be directly related to volunteer work for a qualifying charity. IRS Publication 526 covers charitable contribution records and limits. The guidance separates unreimbursed out-of-pocket costs from personal items and donated services.

To be honest, whether a PTA qualifies, whether a given cost is deductible, and how a reimbursement affects a claim all depend on the organization's status and the volunteer's tax situation. Keep receipts and reimbursement records, then check current IRS guidance or a tax professional before claiming anything. This is general information, not tax advice.

Questions groups usually settle first

Do we have to disclose salaries?

No. Nothing requires a group to use this method. People who choose it can share approximate figures privately, give the treasurer only the final ratios, or use a different basis entirely. Pay stubs shouldn't circulate.

Should volunteer hours change the percentage?

Income ratios measure