Make shared and personal spending visible
Does tracking shared money actually require joint checking accounts? Not at all. A simple Google Sheets setup works if it answers three core questions immediately: what got spent, who paid for it, and who owes what.
Keep it bare-bones so you both actually use it. A flashy dashboard is fun to build, but a balance you can understand in three seconds is what keeps arguments from happening.
Set ground rules before logging that first swipe. Rent coming out of one account is completely different from someone grabbing takeout on a solo whim.
- Shared: Bills both people agreed to split, like groceries, electric, or rent.
- Personal: Solo expenses you pay alone, even when rung up on a shared run.
- Reimbursement: Stuff one person pays for upfront that the other promised to repay in full.
- Shared savings: Joint pots for trips or emergency cushions with their own set contribution rates.
Thing is, paying an invoice is not the same thing as owning the expense. One partner can swipe the card today, but the obligation still belongs to both of you.
Keep later paybacks away from the original purchase row. The grocery charge tells you what food cost. The settlement line shows how you cleared the tab.
Copy this free Google Sheets template layout
Four tabs will handle almost everything. Stick to these to start, and resist adding visual charts until the numbers are running smoothly.
| Tab | What it does | Recommended columns or fields |
|---|---|---|
| Setup | Records the rules you both agreed to follow | Partner names, default split, rent split, savings contribution rule, review date |
| Transactions | Holds every shared, personal, and reimbursable purchase | Date, category, description, amount, paid by, type, split percentages, receipt link, note |
| Monthly Budget | Compares your plan with actual shared spending | Category, planned amount, actual amount, variance |
| Settlements | Records money that was actually repaid | Date, from, to, amount, payment note |
Use the Setup tab to write down agreements in plain English. Dropping in a sentence like "Rent is 60/40, groceries are 50/50, personal subscriptions stay personal" prevents fuzzy memory four months down the road.
If you grab a pre-made template online, wipe out its sample rows right away. Check every category dropdown and formula reference before you log real money. A fancy dashboard is useless if the log underneath is broken.
Decide how shared costs are split
Splitting everything down the middle is simple. It works cleanly when you earn similar wages, share the space equally, and buy similar things.
When earnings diverge, proportional math prevents burnout. For a 60/40 income split, enter 0.60 for Partner A and 0.40 for Partner B across joint charges.
Different bills can have different logic. You might split rent by take-home pay, groceries straight down the center, and keep personal phone bills completely separate. There is no moral mandate for how couples divide a bill. The only standard that matters is whether you both agreed to it before the charge landed.
To be honest, exceptions are where couples run into friction: the grocery receipt that sneaks in expensive personal skincare, a restaurant check padded by a visiting pal, or concert seats only one person cared about. Little edge cases look harmless in the moment, but they create resentment when the end-of-month tally looks off.
Jot predictable exceptions on your Setup tab. If a weird charge happens once, drop an explanation right in the transaction note.
Enter expenses with simple formulas
Set up the Transactions tab with these exact columns across row 1:
Date | Category | Description | Amount | Paid by | Type | Partner A % | Partner B % | Partner A share | Partner B share | Include in settlement | Receipt or note
Spell names identically in every single Paid by cell. Typos break the summary formulas later.
Assuming your total amount sits in column D, Partner A's percentage in G, and Partner B's in H, drop =IFERROR(D2*G2,0) into cell I2. Put =IFERROR(D2*H2,0) into J2. Drag or copy both formulas down through your active rows.
Test it with a quick mental check. A $120 dinner entered at 0.60 and 0.40 will produce $72 for Partner A and $48 for Partner B.
Joint bills need percentages summing to 100. If you want to record personal expenses in the sheet without changing what anyone owes, label the type Personal A or Personal B and place a 0 under Include in settlement. That keeps the item cataloged while blocking it from the settlement math.
For pure reimbursements, mark the type as Reimbursement. If Partner A pays $45 for Partner B's prescription, set the split to 0/100 and put 1 in Include in settlement.
Over on your Monthly Budget sheet, pull actual shared spend by category using this formula: =SUMIFS(Transactions!$D:$D,Transactions!$B:$B,A2,Transactions!$F:$F,"Shared"). In this setup, cell A2 holds the category name, like Groceries.
Build a settlement balance without changing old expenses
When one of you transfers cash to settle up, log that payment on the Settlements tab. Never go back and rewrite or delete the original expense row. Preserving the real history is the whole reason to keep a ledger.
Make five columns on Settlements: Date, From, To, Amount, and Note. Then build a small summary block on your Setup tab or a dedicated Dashboard tab.
These calculations assume your sheet uses Partner A as the exact name text. Swap in your actual names where shown.
| Dashboard cell | What it measures | Formula |
|---|---|---|
| B2 | Shared and reimbursable expenses paid by Partner A | =SUMIFS(Transactions!$D:$D,Transactions!$E:$E,"Partner A",Transactions!$K:$K,1) |
| B3 | Partner A's assigned share of included expenses | =SUMIFS(Transactions!$I:$I,Transactions!$K:$K,1) |
| B4 | Transfers Partner A received | =SUMIFS(Settlements!$D:$D,Settlements!$C:$C,"Partner A") |
| B5 | Transfers Partner A sent | =SUMIFS(Settlements!$D:$D,Settlements!$B:$B,"Partner A") |
| B6 | Partner A's current settlement balance | =B2-B3-B4+B5 |
A positive number means Partner A has fronted more than their assigned share and should be paid back. A negative number means Partner A is currently behind.
In a two-person household, Partner B's balance will mirror Partner A's balance to the exact cent, flipped in sign. If the figures don't cancel each other out, check for three common errors: a transfer entered with the wrong direction, a misspelled name, or a split row where the two percentages do not equal 1.0.
Share the sheet carefully
Only grant Editor permissions if both partners intend to add entries and fix numbers directly. Google Sheets also includes Commenter and Viewer roles. Anyone holding edit access can browse and restore previous revisions through version history, according to Google's collaboration help.
Use cell comments when an entry looks confusing. Flagging a cell with "Was part of this warehouse receipt personal?" keeps discussions tied directly to the purchase date. Once you talk it over, tweak the percentage or add a note.
Turns out, protecting a formula range stops accidental typing, but it offers zero privacy. Anyone with view permissions can read every cell in the workbook. Keep credit card numbers, passwords, bank account digits, and private tax documents off the spreadsheet entirely.
If one of you prefers keeping personal purchases private, do not log itemized solo receipts here. Maintain separate personal sheets instead, or pipe a single monthly personal total into the shared view.
Keep the budget useful after month one
Settling up after every single grocery run or coffee order is exhausting. It turns a partnership into an endless ping of payment requests.
A steady operating rhythm works far better:
- [ ] After a shared purchase, add the date, amount, payer, category, and split before the receipt gets lost.
- [ ] During a weekly check-in, fill in missing charges and resolve any comments.
- [ ] At month-end, compare planned and actual shared spending, then agree on a settlement amount.
- [ ] After a transfer is made, record it in the Settlements tab rather than deleting or editing the original expense.
Keep your spending buckets wide when starting out. Seven categories are plenty: rent, utilities, groceries, dining out, transportation, household items, and shared savings. Resist creating a new category unless that breakdown directly changes how you make a financial choice together.
Whenever you split a mixed receipt, leave a brief note. Note cash outlays too, since those are the easiest to forget. If an error creeps in, append a quick correction row or paste a clarification in the note column rather than quietly erasing historical rows.
Open a blank Google Sheet today and set up the four tabs. Enter just the past week of joint expenses to verify the formulas, agree on a single split method, and lock in your first monthly review date.