Couples can track detergent, laundromat charges, and agreed laundry utilities in Google Sheets without turning every purchase into a debate. The useful part is the rule behind the spreadsheet: define what counts, assign each person's share, record who paid, and mark the balance settled.
Start with the split method. For example, a $15 purchase at 60/40 assigns $9 to you and $6 to your partner. If you paid the entire bill, your partner owes you $6, not $9.
Set the laundry boundary first
Decide which costs belong in the shared ledger. A practical laundry record might include:
- Detergent, softener, stain remover, dryer sheets, and other shared supplies
- Laundromat machines, wash-and-fold receipts, or shared laundry room charges
- An agreed estimate for the water and electricity used by a home washer or dryer
- Personal items, such as dry cleaning, only when both partners agree they belong in the shared budget
Write the boundary in the sheet notes. If you include home utilities, use the same written estimate until you both agree to change it. Precision is less useful than a rule you will actually follow.
Compare fair ways to split laundry costs
No single method fits every couple. Use the one that matches both the money and the work involved.
| Split method | Works better when | Main tradeoff |
|---|---|---|
| Equal, 50/50 | Incomes and laundry use are fairly similar | It ignores income and usage differences |
| Income-based | One partner earns substantially more or you already use proportional household contributions | The percentage needs review when income changes |
| Usage-based | One person washes far more loads or has more clothing in the shared laundry | You need a simple way to count or estimate usage |
| Custom or hybrid | You want income-based supplies but owner-pays rules for personal items | The rule needs to be written clearly |
| One-person owner | A cost belongs to one partner, such as personal dry cleaning | The owner still owes the payer if someone else fronts the bill |
For an income-based split, agree whether you are using gross income, take-home income, or another consistent measure. The calculator does not decide which definition is fair. It applies the percentage you enter.
Laundry work deserves its own conversation. One partner may pay 40% of supplies while doing every wash, dry, fold, and put-away task. You can rotate chores, keep chore and money rules separate, or agree on a credit, but record that decision outside the share formula.
Build the Google Sheets calculator
Use two tabs: Setup and Laundry log. Keeping the income inputs separate makes the sheet easier to review, while storing the percentage on each expense preserves the rule used at that time.
1. Create the Setup tab
Enter the following values:
| Cell | Label or formula |
|---|---|
| A2 | Your agreed income amount |
| B2 | Your amount for the chosen period |
| A3 | Partner's agreed income amount |
| B3 | Partner's amount for the same period |
| A4 | Your suggested income share |
| B4 | =IFERROR(B2/SUM(B2:B3),0) |
| A5 | Partner's suggested income share |
| B5 | =1-B4 |
Format B4 and B5 as percentages. If your incomes are $6,000 and $4,000 under the definition you chose, B4 will show 60% and B5 will show 40%.
Use B4 as a suggestion for new rows. Do not make every old expense reference a live percentage cell if you want a reliable history. Copy the agreed percentage into each row instead.
2. Create the Laundry log tab
Put the current balance in A1 and B1:
- A1:
Current balance - B1:
=SUMIF(L4:L,"No",K4:K)
A positive balance means your partner owes you. A negative balance means you owe your partner. Settle each row only after the money actually changes hands.
Add these headers in row 3:
| Column | Header | What to enter |
|---|---|---|
| A | Date | Date of the purchase or charge |
| B | Laundry item | Detergent, laundromat, dryer, or another agreed item |
| C | Total amount | Full cost of the transaction |
| D | Split method | Equal, Income-based, Custom, or One-person |
| E | Your share % | Enter a decimal such as 0.60 for income-based or custom rows |
| F | One-person owner | You or Partner when D is One-person |
| G | Your share | Formula |
| H | Partner share | Formula |
| I | Paid by you | Your actual payment amount |
| J | Paid by partner | Your partner's actual payment amount |
| K | Net owed to you | Formula |
| L | Settled? | No or Yes |
| M | Settlement date | Date the balance was paid |
| N | Receipt or notes | Receipt link, payment note, or rule used |
| O | Payment check | Formula |
For a row where one person paid the entire bill, enter the total in that person's payment column and 0 in the other. If both people paid at checkout, enter both actual amounts. Their sum should equal the total in column C.
3. Add the formulas
Enter these formulas in row 4, then copy them down:
- G4:
=IF(C4="","",IF(D4="Equal",C4*0.5,IF(D4="Income-based",C4*E4,IF(D4="Custom",C4*E4,IF(D4="One-person",IF(F4="You",C4,0),0))))) - H4:
=IF(C4="","",C4-G4) - K4:
=IF(C4="","",I4-G4) - O4:
=IF(C4="","",I4+J4-C4)
Column G assigns your share. Column H assigns your partner's share. Column K compares what you actually paid with what you were supposed to pay.
Column O should show $0.00. Any other amount means the payment entries do not add up to the transaction total.
Use dropdowns for the split method, one-person owner, and settled status. Format columns C, G, H, I, J, K, and O as currency. Format E as a percentage.
If both people will edit the sheet, limit editing access to the people who need it. Protect B1 and the formula columns G, H, K, and O, while leaving the input columns open. Google Sheets records the balance; it does not send the reimbursement.
Test the calculator with a $15 purchase
Enter a test row before relying on the sheet. These examples assume you paid the full $15.
| Rule | Your assigned share | Partner's assigned share | Current balance |
|---|---|---|---|
| Equal | $7.50 | $7.50 | +$7.50 |
| Income-based, you at 60% | $9.00 | $6.00 | +$6.00 |
| Custom, you at 40% | $6.00 | $9.00 | +$9.00 |
| One-person, partner owns the item | $0.00 | $15.00 | +$15.00 |
The plus sign means your partner owes you. If your partner paid the full $15 instead, the balance would be negative by your assigned share.
Turns out, the important distinction is simple: assigned share is not the same as actual payment. The sheet needs both numbers to calculate a reimbursement correctly.
Use a simple reimbursement workflow
Reimbursement is the settlement step, not a replacement for the original split rule. If you front a shared $15 purchase, keep Equal, Income-based, or Custom in column D, record your $15 payment in column I, and let column K show what your partner owes.
- Log the purchase after it happens. Add the date, item, total, split method, and receipt note.
- Confirm the assigned shares. For an income-based row, copy the agreed percentage into column E.
- Enter the actual payments. Check column O before discussing the balance.
- Review the current balance on the cadence you agreed on, such as weekly for logging and monthly for settlement.
- Transfer the amount through your usual payment method or exchange cash. Add the date and a short note without changing the original expense.
- Change column L to
Yesafter the full amount is received. The row remains in the history, but B1 stops counting it as outstanding.
For a partial reimbursement, leave the row open and record the partial amount in the notes, or add a separate settlement field. Do not mark the row settled until the full balance is paid.
Keep the rules fair as circumstances change
Thing is, a spreadsheet can only apply the rule you give it. It cannot decide whether an income split still feels fair after one partner takes on all the laundry or one person starts using the machines much more often.
Write a plain-language rule in the notes, such as: "Shared supplies are 60/40. Personal dry cleaning is paid by the owner. Laundromat charges follow actual loads. Review the rule monthly." That sentence can prevent a surprising amount of back-and-forth.
If income changes, update the Setup tab for future purchases and enter the new percentage in new rows. Leave old percentages alone unless you both deliberately agree to recalculate past expenses.
A useful conversation can sound like this:
"The sheet shows $6 due for the shared purchase. Should we keep 60/40, or has the work and usage changed enough to revisit it?"
To be honest, some couples will find that a simple 50/50 rule is easier than tracking every load. That is fine. The calculator is there to make an agreed rule visible, not to create work for its own sake.
Common spreadsheet mistakes
| Mistake | Better approach |
|---|---|
| Treating a fronted shared bill as a one-person expense | Keep the shared split and record who paid |
| Letting old rows use the current income percentage | Store the agreed percentage in each row |
| Marking a row settled before the transfer clears | Leave it as No until the full amount is paid |
| Entering only the assigned shares | Enter actual payments too |
| Ignoring a nonzero payment check | Correct columns I and J until O shows $0.00 |
| Changing the utility estimate without a note | Record the new estimate and the date it starts |
| Tracking costs without receipts or descriptions | Add a short item name and receipt reference |
Questions couples often ask
Should we split laundry costs by gross or take-home income?
Either can work if both partners use the same definition and time period. Choose the measure that fits your broader household rules, then keep it consistent.
What if both of us paid at the register?
Enter the actual amount paid by each person in columns I and J. Column K calculates the remaining balance, and column O checks that the two payments equal the total.
Should reimbursement be a separate split method?
Usually, no. Keep the original split method so the record shows who was responsible for the cost. Use the payment columns and settled status to record reimbursement.
Can this template track utilities or groceries?
Yes. Rename the item column or duplicate the tab, then use the same share, payment, and settlement logic. Keep each category's rules clear.
Create the Setup and Laundry log tabs, enter two or three purchases from last month, and compare the calculated balance with what you both remember. Fix the rule first; add more rows second.