Cash App can move a reimbursement. What it can't do is keep your team's books. That job goes to Google Sheets or Excel, in one file holding expenses, participant shares, receipts, and completed payments.
This setup fits sports teams, travel groups, clubs, roommates, and small committees. Agree on the split rule before anyone pays. Cash App then covers the sending and the requesting. The spreadsheet explains the math.
Separate the jobs
Cash App handles the transfer. The spreadsheet holds everything the transfer can't tell you.
A payment activity record helps confirm money moved. It won't tell you which expense a payment covered, who participated, or what's still outstanding. That context belongs in the shared file, not scattered across chat messages.
| Job | Use Cash App for | Use the spreadsheet for |
|---|---|---|
| Payment | Sending or requesting money | Recording sender, recipient, amount, and status |
| Proof | Checking payment details or a confirmation | Linking the receipt and matching it to an expense |
| Group math | Adding a clear payment note | Calculating shares, IOUs, and net balances |
| Settlement | Sending the reimbursement | Showing which expenses and payments are closed |
Build a four-tab team expense tracker
Start with four tabs. Keep the layout boring on purpose. Boring is what makes the whole thing easy to audit later.
| Tab | Recommended columns | Purpose |
|---|---|---|
| Expenses | Date, expense ID, description, payer, total, split rule, receipt link, notes | One row for each purchase or charge |
| Shares | Expense ID, member, share owed | One row for each participant in each expense |
| Payments | Date, sender, recipient, amount, expense ID, status, Cash App note or reference | One row for each reimbursement |
| Summary | Member, paid upfront, share owed, sent, received, net balance | One row for each team member |
Give every expense a short ID, something like JERSEY-01 or TRIP-GAS-03. Use that same ID in the Shares and Payments tabs.
Shares gets one row per member. Several names in one cell will look tidy, then break your formulas.
Keep receipt links in the file. Don't store full bank account numbers, passwords, or unrelated personal information in a shared sheet.
Pick the split rule before anyone pays
Turns out the money is rarely the hard part. Deciding what each person should owe is.
Choose a rule that matches the expense, then write it down before the first purchase.
| Split rule | Best fit | Watch for |
|---|---|---|
| Equal | Team dues, uniforms, or shared supplies used by everyone | Exclude people who did not participate |
| Participation-based | Tickets, meals, or activities used by only some members | Record who was included |
| Usage-based | Gas, lodging, meals, or equipment used at different levels | Agree on the measurement first |
| Custom | Partial attendance, credits, discounts, or special circumstances | Add a note explaining each adjustment |
An income-based split can make sense in a household budget, but it needs everyone's explicit agreement. It should never slide in as a silent rule for team expenses. On trips, nights stayed or room size can replace headcount when the costs genuinely differ.
Put the rule above the Summary tab: Equal split; nonparticipants excluded; custom amounts need a note.
Use formulas that keep IOUs accurate
One payment-status column is not enough on its own. Track expenses and reimbursements separately, then let the Summary tab combine them.
Assume the member name sits in A2 on Summary. In Payments, column B holds the sender, column C the recipient, column D the amount, and column F the status.
| Summary field | Formula in row 2 | What it shows |
|---|---|---|
| Paid upfront | =SUMIF(Expenses!$D:$D,A2,Expenses!$E:$E) |
Expenses this member paid for initially |
| Share owed | =SUMIF(Shares!$B:$B,A2,Shares!$C:$C) |
This member's assigned portion |
| Sent | =SUMIFS(Payments!$D:$D,Payments!$B:$B,A2,Payments!$F:$F,"Paid") |
Completed reimbursements sent |
| Received | =SUMIFS(Payments!$D:$D,Payments!$C:$C,A2,Payments!$F:$F,"Paid") |
Completed reimbursements received |
| Net balance | =B2-C2+D2-E2 |
The member's remaining credit or amount owed |
Only payments marked Paid count in these formulas. Until the recipient confirms the transaction, keep the status consistent, something like Pending.
A positive net balance means the member should receive money. A negative one means they still owe. Share owed already includes the payer's own portion, so the payer can't accidentally reimburse themselves for personal spending.
For an equal split, put this in Shares!C2 when A2 contains the expense ID:
=SUMIF(Expenses!$B:$B,A2,Expenses!$E:$E)/COUNTIF(Shares!$A:$A,A2)
For a custom split, type the agreed amount instead. Then check that every share for an expense adds up to the expense total. An optional check column in Expenses can use:
=E2-SUMIF(Shares!$A:$A,B2,Shares!$C:$C)
Zero is the target.
Example: a $200 uniform purchase
Alex buys five uniforms for $200. Five team participants, so each share comes to $40.
| Member | Paid upfront | Share owed | Net before payments |
|---|---|---|---|
| Alex | $200 | $40 | +$160 |
| Blair | $0 | $40 | -$40 |
| Casey | $0 | $40 | -$40 |
| Drew | $0 | $40 | -$40 |
| Ellis | $0 | $40 | -$40 |
Alex's $200 belongs in Expenses, not Payments. When Blair sends Alex $40 through Cash App, you add a Payments row: Blair as sender, Alex as recipient, JERSEY-01 as the expense ID, Paid as the status.
Blair's net hits zero. Alex's becomes +$120. Repeat that for the other three teammates.
Follow the reimbursement workflow
-
Agree on the rule. Name it first: equal, participation-based, usage-based, or custom. Write the choice down, and decide how discounts, credits, and transfer fees get handled.
-
Create the expense row. The payer records the date, expense ID, description, total, split rule, and receipt link before any reimbursement request goes out.
-
Add the share rows. List each participating member in Shares. Check the total before anyone sends a payment request.
-
Send the request. Use Cash App to request or send the amount, and add a short note such as
JERSEY-01 - uniform shareso the payment can be matched later. -
Verify the payment. Thing is, a request is not a payment. The recipient checks the actual transaction status before anyone marks the Payments row as
Paid. -
Review the balances. Check the Summary after each new expense during an active trip or event. For a recurring season or club fund, a weekly or monthly review can be enough.
-
Settle and close. When the balances are clear, save a copy of the spreadsheet and keep the receipt folder with it. Don't delete the original rows just because an expense has been settled.
Protect the sheet and account for fees
Give the organizer or treasurer edit access. Everyone else can usually work from view or comment access, while people who enter expenses get edit rights on the input columns only.
Protect formula columns and header rows if your spreadsheet tool supports protected ranges. And keep a backup before changing formulas or reorganizing tabs.
Cash App may show a fee for some transfer choices, particularly when money is moved out instantly. Check the fee the app displays before you confirm. If the group agrees to cover that cost, record it as a separate shared expense, or document how it changes the total.
The Cash App Terms of Service are the place to check current account and transfer rules. If an account can't send or receive as expected, look at the in-app notice and those current terms instead of guessing at the fix.
Treat peer-to-peer payments as transfers between people who know and trust one another. Verify the recipient and the $Cashtag before sending. The FCC guidance on peer-to-peer payment apps makes the same recommendation: stick to people you know and trust.
Before marking a balance settled, check:
- The receipt is linked to the right expense ID.
- Every participant has a share row.
- The share check returns zero.
- The payment status is
Paid, notPending. - The payment note or reference matches the expense.
- A backup copy includes the final receipts and balances.
Handle refunds, credits, and combined payments carefully
Refunds and credits deserve their own trail. If a purchase is refunded, add an adjustment tied to the original expense ID instead of deleting the original row.
If a driver receives a credit, write exactly what the credit covers and reduce only the affected shares. A payment covering several expenses can use one settlement ID in the note, or separate Payments rows for each expense. Either approach works. Pick one and stay consistent.
To be honest, a shared sheet is enough for many informal groups. If the money belongs to a formal organization, or tax and legal questions come up, treat this tracker as a recordkeeping tool, not professional advice.
Test the tracker before sharing it
Open a blank workbook, create the four tabs, and enter the $200 uniform example. The share check should return zero, and one test payment should move both members' net balances the way the example says it will.
Delete only the sample data, keep the headers and formulas, then send the first real Cash App request with the matching expense ID in the note.