A shared Google Sheet can split grocery costs by income and keep the reimbursement math visible. Put each purchase on one row, calculate each member's income share, and record who paid. That's enough for a small household or group.

Turns out, the arithmetic is easy. The rule is harder. Decide which items are shared, whether the split reflects income or usage, and how a person gets reimbursed.

With incomes of $80,000 and $40,000, a strict income-based split is 66.67% and 33.33%. A $100 shared purchase would be $66.67 for the higher earner and $33.33 for the lower earner. A 60/40 split can still be an agreed compromise, but it is not the exact ratio from those incomes.

Choose a fairness rule before adding formulas

Income is a contribution rule, not a usage meter. Thing is, one grocery receipt can contain shared staples, dietary choices, and personal items.

Method Calculation Useful when Main tradeoff
Equal or per-person Total cost divided by participating people People use groceries similarly Simple, but the same dollar amount may feel heavier for a lower earner
Income-proportional Total cost multiplied by a person's income share Earnings differ substantially Needs agreement about income and may not reflect consumption
Usage-based Shared portion plus each person's assigned items Diets or consumption differ More receipt sorting
Hybrid Shared staples use one rule; personal items stay separate Receipts contain mixed purchases Requires clear categories
Room-size or nights-stayed Cost follows occupancy or time in the home Household costs tied to occupancy Usually a weak fit for ordinary groceries

Reimbursement-after-proof is a payment workflow, not a split formula. One person pays the receipt, everyone can see the allocation, and the transfer is recorded after the purchase. It works best when the receipt is available.

Agree on the income basis too. Use gross or take-home income consistently, and write the choice in a Rules tab. No formula can settle a disagreement about what counts as shared.

Build the Google Sheets workbook

A small workbook can use four tabs. Keep the purchase ledger separate from the income settings.

Tab Suggested fields Purpose
Settings Person, income, income share, effective date Calculates each member's percentage
Groceries Date, items, total cost, rule, percentages, shares, payer, status, receipt notes Records each purchase
Reimbursements Date, from, to, amount, related purchase, status Records money that actually moved
Rules Shared items, personal items, income basis, review day, rounding rule Stores the agreement

For a larger group, add one percentage and one share column per person. Keep the names consistent across every tab.

Calculate income shares in Settings

Set up the Settings tab like this:

A1: Person
B1: Income
C1: Income Share

A2: Person 1
B2: 80000
C2: =IFERROR(B2/SUM($B$2:$B$10),0)

A3: Person 2
B3: 40000
C3: =IFERROR(B3/SUM($B$2:$B$10),0)

Copy the formula in column C down for every member. Format that column as a percentage.

In this example, the result is 66.67% for Person 1 and 33.33% for Person 2. The underlying calculation is:

grocery total * person income / total group income

If the grocery total is in C2 and the incomes are in B2:B10, the direct formula is:

=C2*(B2/SUM($B$2:$B$10))

The income range must include every member. Use the same income period and basis for everyone.

Add the grocery ledger

Use one row for each purchase:

Column Field
A Date
B Items or store
C Total Cost
D Split Rule
E Person 1 %
F Person 2 %
G Person 1 Share
H Person 2 Share
I Paid By
J Status
K Receipt or Notes
L Check

For a two-person sheet, use these formulas in row 2:

E2: =IF($D2="Proportional",Settings!$C$2,IF($D2="Equal",50%,""))
F2: =IF($D2="Proportional",Settings!$C$3,IF($D2="Equal",50%,""))
G2: =ROUND($C2*E2,2)
H2: =ROUND($C2-G2,2)
L2: =IF(ROUND(E2+F2,4)=1,"OK","Check %")

Set D2 to Proportional for an income-based row or Equal for a 50/50 row. For a Custom row, replace E2 and F2 with the agreed percentages. A personal item can use 100% and 0%, or stay out of the shared ledger.

The formula in H2 uses the remaining cents after G2. That keeps the row total equal to the receipt total. With three or more people, calculate the earlier shares normally and use the final person's share as the total minus the earlier rounded shares.

Use Open and Settled in the Status column. Don't treat a purchase as settled just because someone requested payment.

Track purchases and reimbursements in a simple routine

  1. Write the rule first. In the Rules tab, state which groceries are shared and how personal items are handled. For example: "Shared staples use income percentages; personal items stay with the buyer."
  2. Enter the incomes or agreed percentages. Check that all shares add to 100%.
  3. Log the purchase promptly. Add the date, receipt total, items, payer, and split rule. Use the receipt total, not a rounded estimate.
  4. Review the sheet weekly. A 10-minute Sunday or Monday check-in is enough for many small groups. Check unusual items, missing receipts, and rows marked Check %.
  5. Record the transfer separately. Add the date, sender, recipient, amount, and related purchase to the Reimbursements tab. Don't change the original grocery total.
  6. Close the row after payment. Change the grocery status to Settled after the related reimbursement is recorded.

The sheet can be tidy without being fussy. One row per purchase, one receipt, one payer, and one rule. Someone will forget a receipt; build a reminder rather than pretending that won't happen.

A useful payment note is: "Please send $33.33 for the March 8 groceries. Your recorded share is in the sheet, and the receipt is linked." Specific wording keeps the request from sounding personal.

Calculate who owes whom

A purchase row shows the allocation. A reimbursement row shows what actually moved.

On a Summary tab, use these fields:

Column Field
A Member
B Share Allocated
C Paid Upfront
D Sent
E Received
F Net

For Person 1, where that person's share is in column G, use:

B2: =SUM(Groceries!$G:$G)
C2: =SUMIF(Groceries!$I:$I,"Person 1",Groceries!$C:$C)
D2: =SUMIFS(Reimbursements!$D:$D,Reimbursements!$B:$B,"Person 1",Reimbursements!$F:$F,"Recorded")
E2: =SUMIFS(Reimbursements!$D:$D,Reimbursements!$C:$C,"Person 1",Reimbursements!$F:$F,"Recorded")
F2: =C2-B2+D2-E2

Use From in column B, To in column C, Amount in column D, and Status in column F of the Reimbursements tab.

For Person 2, use the H share column in B3 and replace the name in the other formulas. A positive net means the member should receive money. A negative net means the member still owes money.

With three or more members, repeat the allocated-share calculation for each person's share column. The total allocated amount should reconcile to the total grocery cost.

Update income percentages without rewriting history

Income changes can quietly rewrite old records. If every grocery row points directly to Settings, changing an income changes past shares too.

At the end of a month or other agreed period, copy the percentage cells in closed rows and paste them as values. Another option is to keep dated settings blocks and use the correct block for each period. Record the effective date in the Rules tab.

Use new percentages for future purchases. Leave closed purchases unchanged unless you are correcting a genuine entry error.

Protect formulas and limit sensitive access

Share the sheet with specific people when income amounts are visible. A public edit link is a poor fit for private financial details.

Let members edit purchase inputs, but protect formula cells and the Settings tab where appropriate. Google Sheets uses the Data menu for protected sheets and ranges; this Google Sheets protected ranges walkthrough shows the range-based process.

Protection helps prevent accidental edits. It does not replace sensible sharing permissions. If exact incomes should remain private, agree on the percentages separately and put only those percentages in the shared grocery tab.

Common mistakes to avoid

Mistake Better approach
Calling 60/40 income-proportional when incomes are $80,000 and $40,000 Use 66.67/33.33, or label 60/40 as an agreed compromise
Including personal purchases in the shared total Remove them or use a custom 100% and 0% split
Letting percentages total something other than 100% Keep the Check column and correct the row before settling
Changing Settings and unintentionally changing old rows Paste closed percentages as values or use dated settings
Marking a purchase settled before the transfer arrives Keep it open until the reimbursement is recorded
Using a public edit link for income details Share with named members and protect sensitive ranges

Questions that come up

Can equal and income-based splits share one sheet?

Yes. Use the Split Rule column for each purchase. Shared staples might use income percentages, while a group meal or a purchase used equally by everyone might use 50/50.

Should the split use gross income or take-home pay?

Either can be an agreed basis. Use the same basis for everyone, record it in the Rules tab, and update future rows when the group changes the rule. Neither choice is automatically fair for every household.

Is a spreadsheet enough for a small group?

Usually, a sheet is enough when people can enter receipts and review balances. Consider another tool only if manual entry, reminders, or receipt handling becomes the actual problem. The important parts are still the rule, the receipt, the payer, and the reimbursement record.

Start with last week's receipt. Enter the two incomes, test one $100 row, and compare the result with a hand calculation. Then write the rule in the Rules tab and schedule the first Sunday review.