Someone in the house just paid cash for a shared bill. Log it today, before the receipt vanishes into a pocket or the laundry and everybody starts guessing. Give the payer credit for the full amount they fronted, then work out what each participant actually owes. Turns out both facts belong on the same row.
So who ends up owing whom? The sheet has to answer that separately from who paid. Treating the full receipt as the payer's personal cost is the classic mistake. So is booking each repayment as a brand new expense. Record both facts and neither error happens.
A shared spreadsheet, a receipt photo, and a written settlement rule are enough for plenty of small households. The sheet is a record. It isn't a referee.
Separate who paid from who owes
Every cash expense hides three questions: who advanced the money, who should carry the cost in the end, and who has repaid whom since. Split those into layers and the ledger stays straight.
| Record layer | What it answers | Example for a $200 expense |
|---|---|---|
| Payment | Who advanced the money? | Jordan paid $200 cash; Jordan paid 100% upfront |
| Allocation | Who should ultimately bear the cost? | Four participants owe $50 each |
| Settlement | Who repaid whom? | Alex, Mia, and Sam each repay Jordan $50 |
Some spreadsheet templates use Reimbursement as the split type. The label describes cash one person fronted well enough. It should never replace the actual cost allocation.
In the payment section, Jordan sits at 100% and the other roommates at 0%. That part is right. In the allocation section, all four people carry a 25% share. Also right. Put 0% in both places, though, and the ledger incorrectly says the other roommates owe nothing.
Log the cash expense in six steps
-
Confirm that the expense is shared. Pull personal items off a mixed grocery receipt before you split anything. If the group never agreed an item was shared, ask before you request money.
-
Save proof right away. Photograph the receipt while you still have it. Capture the date, seller, total, and any detail that might matter later. If there's no receipt, write down what was bought and ask the group to confirm the entry.
-
Create one row in the shared ledger. Enter the date, description, full amount, payer, payment method, split type, participants, and a link to the receipt. The amount-paid field gets the full cash amount, not just your share.
-
Choose the allocation. For an equal split, divide the amount by the number of participating people. For a custom split, record percentages or dollar amounts that add back up to the full total.
-
Send a clear reimbursement request. Name the expense, the person's share, the payment method, and the due date your household already agreed on. A payment app is optional.
-
Mark the entry settled only after payment arrives. Add the payment date and method. If the repayment is also cash, both people confirm it in the sheet or the group message.
Jordan pays $200 cash for groceries shared by four roommates, which works out to $50 each, and since Jordan has already covered Jordan's own share, the other three roommates owe Jordan $50 apiece, a net reimbursement of $150.
Those repayments are transfers, not new grocery expenses. The original $200 expense stays intact.
Spreadsheet columns that prevent double counting
A lean tracker can run on these columns:
| Column | What to enter |
|---|---|
| Date | The day the expense occurred |
| Description | A short label such as "Water bill" or "Groceries" |
| Amount paid | The full amount on the receipt |
| Paid by | The roommate who handed over the cash |
| Payment method | Cash, bank transfer, or another agreed method |
| Split type | Equal, per-person, usage-based, custom, or Reimbursement |
| Participants or shares | The people included and what each owes |
| Settlement status | Unpaid, partly paid, or settled |
| Receipt and notes | Receipt link, exclusions, or an explanation |
For a four-person equal split, an amount cell divided by four gives each person's share. If the amount is in D2 and the participant count is in F2, the basic formula is =D2/F2.
One row per expense. Always one row. Keep the original amount fixed, then record repayments in a settlement column or a separate payment log, because otherwise a single $200 purchase can look like two separate expenses once someone pays back the person who used cash.
Give editing access only to people who should be changing the ledger. Keep receipt photos in a shared folder, and leave out account numbers or anything else sensitive. If the spreadsheet offers edit history, check it when a total or share changes instead of silently deleting the old entry.
Choose the split before the cash changes hands
Who paid first and who should carry the final cost are two different questions. A reimbursement label answers only the first.
| Split method | Often fits | What to write down |
|---|---|---|
| Equal | Groceries, cleaning products, or supplies used similarly by everyone | The participating roommates |
| Per-person | A meal, item, or activity used by only some people | Who participated |
| Usage-based | Utilities or services where use differs and the group accepts a clear basis | The estimate, meter reading, or agreed rule |
| Room size or amenities | Rent, private bathrooms, parking, or larger rooms | The percentages and reason |
| Income-based | A household that intentionally ties contributions to income | The agreed percentages and review date |
| Nights or occupancy | A partial month, move-in, move-out, or guest stay | The relevant dates and proration rule |
Equal shares are the easiest to audit, but identical numbers aren't always the fairest. An income-based split can also require more privacy than roommates want to share, so record only the percentage needed to apply the agreement.
Security deposits and moving costs deserve separate notes. Write down who contributed, who should receive any refund, and how deductions get handled. Lease terms and local law may control parts of that arrangement, and a spreadsheet cannot override them.
Set a review and settlement rhythm
Pick one day for checking entries and one cadence for repayments. Logging during the week and settling once a month can work for a small household. Frequent purchases or a large bill call for an earlier review.
Thing is, a reminder works better when it names the receipt, the amount, the share, and the due date.
Keep it plain:
I paid $200 cash for groceries. The receipt is linked. Your share is $50. Please reimburse me by Friday through our agreed method, or flag the split before then.
Never mark a balance settled because someone said they would pay. Record it when the cash or transfer has actually arrived. If the repayment is also cash, add the date and a confirmation. If an app handles the transfer, keep the spreadsheet as the record of why the amount was owed.
Handle exceptions before they become disputes
The receipt includes personal items. Remove those items before calculating shares, and note the exclusion. Splitting a mixed total only plants confusion for later.
There is no receipt. Write down the seller, date, amount, purpose, and participants, then ask the group to confirm the entry in writing. If someone disputes it, leave the amount marked as disputed rather than quietly treating it as settled.
Someone did not use the item. Change the participant list before the request goes out. The denominator should reflect the people the agreement actually covers, not simply everyone on the lease.
Someone moved in or out mid-month. Use the household's agreed occupancy rule and write down the dates. No single proration method is fair for every home.
A number changes after entry. Keep the original receipt and add a note explaining the correction. If your spreadsheet has edit history, review the change there instead of deleting the row.
Questions roommates often ask
Should the payer be listed at 100 percent or split evenly?
Use 100 percent in the payment layer when that person covered the full cash amount. In the final allocation, the payer's own share counts right alongside everyone else's.
Do we need an app to track cash reimbursements?
No. A shared spreadsheet, a receipt folder, and a written group rule can run a small household. To be honest, an app may make requests easier, but it isn't a substitute for deciding who participates or keeping the receipt.
Can we settle once a month?
Yes, if everyone agrees and entries get logged promptly. Review the sheet during the month so forgotten expenses don't pile up, then settle on the date you chose.
Start with the most recent cash receipt. Photograph it, add one row, write in the participants and their shares, and send the group the exact balance. Then agree on the next review date before another bill arrives.