A PTA can use Google Sheets to track field trips, supplies, event deposits, and reimbursements. Keep the math visible. The useful setup separates the purchase, each person's share, and the final balance.

One row can record a purchase. It can't also show every participating family cleanly. Use an Expenses tab, a Splits tab, and a formula-driven Balances tab instead.

Decide what money belongs in the tracker

Start by deciding what you want the file to show. If a volunteer paid upfront, the record should connect the receipt, approved amount, people who bear the cost, and repayment status.

PTA-funded purchases are different. You can log them for reference, but mark them No in the balance column unless someone still needs repayment. A cost paid directly from PTA funds should not accidentally create an IOU between families.

Set up three simple tabs

Create a spreadsheet at Google Sheets, then add these tabs:

Tab Purpose Main fields
Expenses One row for each purchase or adjustment ID, date, description, category, amount, payer, receipt
Splits One row for each person who bears an expense Expense ID, person, share, settlement status
Balances One row for each person or organization Name, amount paid, assigned share, net balance

This structure takes a little more work at the start. It saves cleanup later.

Build the Expenses tab

Put these headers in row 1:

Expense ID, Date, Description, Category, Amount, Paid by, Balance tracked?, Receipt link, Approval status, Notes

Then enter each purchase once.

  1. Give every expense a unique ID, such as E-001 or E-002.
  2. Enter the amount as a number, such as 150, and format the column as currency. Don't type a dollar sign into a value you plan to calculate.
  3. Set Balance tracked? to Yes when a volunteer, family, or the PTA still needs to be repaid. Use No for a record that is already covered.
  4. Add a receipt link that the officers can open. A shared Drive folder can keep scans in one place.
  5. Use Notes for rules such as "attending families only" or "approved at April meeting."

A sample row might look like this:

Expense ID Date Description Category Amount Paid by Balance tracked? Approval status
E-001 2026-03-15 Art supplies Supplies 150.00 Volunteer A Yes Pending

Use a consistent spelling for names. Volunteer A and A, Volunteer will be treated as different people by a formula.

Add one row per person on the Splits tab

Create these columns:

Expense ID, Person, Share amount, Settled?, Settlement date, Notes

For a $150 purchase split among Alice, Bob, and Cara, enter three rows:

Expense ID Person Share amount Settled?
E-001 Alice 50.00 No
E-001 Bob 50.00 No
E-001 Cara 50.00 No

If Alice paid the full amount and is also participating, include her row. Her $50 share offsets part of the $150 she advanced, so the group owes her $100 rather than $150.

To calculate an equal share automatically, put this in C2 and copy it down:

=IF(A2="","",VLOOKUP(A2,Expenses!$A:$J,5,FALSE)/COUNTIF($A$2:$A,A2))

The formula looks up the expense amount and divides it by the number of rows with that expense ID. For an uneven split, replace the formula with an agreed fixed amount for each person.

Check the assigned shares before settling. In a spare cell on the Expenses tab, you can use =SUMIF(Splits!$A:$A,A2,Splits!$C:$C)-E2. A result of zero means the split rows match the expense amount. If the result is off by a few cents, adjust one share rather than ignoring the difference.

Thing is, the sheet can't decide what is fair. It can only apply the rule your group chose.

Turn the rows into balances

On the Balances tab, add these headers:

Name, Paid for tracked expenses, Assigned share, Net, Action

List each payer and participant in column A. Include the PTA as a name when families owe the organization directly.

In row 2, use these formulas:

Column Formula
B, Paid =IF($A2="","",SUMIFS(Expenses!$E:$E,Expenses!$F:$F,$A2,Expenses!$G:$G,"Yes"))
C, Share =IF($A2="","",SUMIF(Splits!$B:$B,$A2,Splits!$C:$C))
D, Net =IF($A2="","",B2-C2)
E, Action =IF($A2="","",IF(ABS(D2)<=0.005,"Settled",IF(D2>0,"Receive","Pay")))

Copy the formulas down for every name.

A positive net means the group should pay that person. A negative net means that person should reimburse the group or another participant. A zero balance means the recorded amounts cancel out.

For the $150 example, Alice shows 100.00 and Receive. Bob and Cara each show -50.00 and Pay. The formula does not move money; it gives the treasurer a clear settlement list.

Add a small summary

An optional Summary tab can show totals without changing the transaction data.

What to show Formula
All tracked expenses =SUMIFS(Expenses!$E:$E,Expenses!$G:$G,"Yes")
Tracked supplies =SUMIFS(Expenses!$E:$E,Expenses!$D:$D,"Supplies",Expenses!$G:$G,"Yes")
Tracked expenses awaiting approval =SUMIFS(Expenses!$E:$E,Expenses!$I:$I,"Pending",Expenses!$G:$G,"Yes")

Use the pending figure as a review queue. It is not necessarily the amount currently owed, especially if some people have already settled.

Pick a split rule before the purchase

Write the rule in the expense notes before anyone pays. That keeps the conversation about the rule, not about who entered the last formula.

Split rule How it works Useful for
Equal per family Divide the cost by participating families Shared supplies or a group event
Equal per person Divide by the number of attendees Meals, tickets, or materials used by individuals
Attendee or usage-based Include only people who attend or use the item Optional field trips or activity fees
Custom amount Enter an agreed amount for each person Different ticket prices or family arrangements
Income-based or proportional Use agreed percentages without storing private details Only when the group has explicitly adopted this approach

Equal is easy to explain, but it may not fit a trip where only some families attend. Per-person splits can reflect actual attendance better, while custom shares require more checking. If you use an income-based arrangement, keep income information out of the shared file and record only the agreed amount or percentage.

Give access without giving away the sheet

Access should follow the job.

  • Editors: Give edit access to the treasurer and a designated backup who enter expenses or correct records.
  • Viewers: Give read-only access to members who need transparency but should not change the data.
  • Formula ranges: Protect balance and formula cells through Data > Protect sheets and ranges, leaving only intended input cells open.

Avoid an open edit link for a file containing names, receipts, or balances. Specific email access is easier to review and remove.

Protection helps prevent accidental edits, but it does not hide information from viewers. If individual balances are sensitive, keep the master file limited to officers and share an aggregate summary or individual amounts separately. Use File > Version history when a row or formula changes unexpectedly.

Use a small review routine

Timing Action
Before a purchase Agree on participants, split rule, spending limit, and approval path
At the purchase Save the receipt and note who paid
After the purchase Add one Expenses row and one Splits row per person
Before settlement Confirm the share check is zero and the expense is approved
After settlement Mark each person's Settled? field and add the settlement date

Turns out, the part people skip is the boring part: match the names, check the receipt, check the shares, then check the shares again before anybody sends money. It feels fussy. It also keeps a small rounding error from turning into a meeting debate.

Fix the problems that cause most disputes

Most spreadsheet problems are ordinary data-entry problems.

  • A payer's name does not match the name on the Balances tab.
  • Several participants are typed into one cell instead of using separate Splits rows.
  • A formula is overwritten with a number and nobody notices.
  • A receipt link requires access that the treasurer does not have.
  • An old settled row is changed instead of adding a clearly labeled adjustment.
  • A PTA-funded expense is marked Yes and creates a balance that should not exist.

For a refund or correction, update the original row only if nobody has settled it yet. After settlement, add an adjustment row with its own ID so the original decision remains visible.

Keep the tracker in its proper lane

To be honest, the spreadsheet is a working record, not proof that a purchase was authorized or that a receipt is valid. It also does not replace bank statements, check records, approval notes, or the PTA's written reimbursement policy.

Keep the original receipts and approval records in the group's controlled folder. If the PTA requires offline records, make dated exports rather than relying on one constantly changing file.

U.S. PTA requirements can depend on the entity, governing organization, and local policy. If the group is tax-exempt, ask its treasurer or qualified tax professional which records to retain. A 30-day receipt deadline is not universal, so use the rule your organization has actually adopted.

Don't put bank passwords, Social Security numbers, or unnecessary family financial details in the spreadsheet.

Questions that come up

Can I use uneven shares for one expense?

Yes. Replace the equal-share formula with a fixed amount for each person, then use the share-check formula to confirm that the amounts equal the expense total.

What if the PTA paid the vendor directly?

Set Balance tracked? to No if nobody needs repayment. If families owe the PTA, set it to Yes, use PTA in Paid by, and add each family's share on the Splits tab.

Why don't my balances add up?

Check the name spelling first. Then look for a missing split row, a duplicate expense ID, a negative adjustment, or a share total that differs from the expense amount.

Should every parent edit the file?

Usually not. Keep editing with the officers responsible for receipts and approvals. Read-only access may be enough for members who only need to review totals or rules.

Create the three tabs, enter one completed expense, and make its split-check formula return zero before importing older transactions. That test will expose naming, permission, and rounding problems while the file is still easy to fix.