Google Sheets is enough for a practical couples budget tracker. Not kind of enough, actually enough, as long as the workbook keeps three things apart: the expenses themselves, each person's share of those expenses, and the reimbursements that square everyone up later. One monthly tab for entries, a summary tab for totals, and a settlement tab for money that actually moved between you.
The math stays visible, and that's the real advantage here. The sheet can tell you who should reimburse whom, but it never moves money or confirms a transfer. Both partners can enter expenses from the Google Sheets app on iOS or Android, then review the same file on a computer when there's time to sit down.
Choose the split rule first
Your formulas are only as fair as the rule behind them. Before anyone touches a cell, decide three things: which costs are shared, which stay personal, and how the split works. Equal, proportional, or category-based are all fine. What matters is that both of you actually agreed to it.
| Split method | Works well when | Example |
|---|---|---|
| Equal | Both partners want a simple 50/50 arrangement | Each person covers half of rent |
| Proportional | Incomes differ or contributions follow income | Partner A pays 60% and Partner B pays 40% |
| Category-based | Different bills follow different rules | Rent is 50/50, while groceries follow income |
| Full reimbursement | One partner should cover the entire cost | A personal purchase is split 100% to one partner |
Use percentages that match your agreement, not a guess. If a row uses 60% and 40%, those two cells must total 100%.
Turns out, plenty of money arguments are really labeling problems. Write the rule down before either partner starts entering old expenses.
Build the monthly expense tab
Create a workbook with a Summary tab, one Settlements tab, and monthly tabs such as Jan 2026 and Feb 2026. Give every monthly tab the same headers. Formulas that jump between months will behave better for it.
| Column | Purpose | Example |
|---|---|---|
| Date | When the expense happened | 2026-01-15 |
| Description | What the charge was for | Grocery run |
| Amount | Total cost of the expense | $125.50 |
| Category | Consistent spending label | Groceries |
| Paid By | Person who paid upfront | Partner A |
| Partner A % | Partner A's agreed share | 60% |
| Partner B % | Partner B's agreed share | 40% |
| Partner A Share | Formula-calculated share | $75.30 |
| Partner B Share | Formula-calculated share | $50.20 |
| Partner A Net | Paid amount minus share | $50.20 |
| Partner B Net | Paid amount minus share | -$50.20 |
| Split Check | Confirms the percentages | 100% |
| Notes | Receipt location or context | Receipt in shared Drive folder |
Keep Partner A and Partner B as the exact values in the Paid By column unless you also change the formulas. You can replace those labels with real names later.
For Category, stick to a short fixed list. Rent, Utilities, Groceries, Dining Out, Subscriptions, Gas, Entertainment, and Reimbursements all work. Pick one label for each type. One label, reused every single time.
Set up the workbook for phone entry
This part goes fastest on a computer, and you'll only do it once.
- Open a blank Google Sheet and name it something recognizable, such as
Couples Budget. - Add
Summary,Settlements, and the monthly tabs. Use one name format, including the space inJan 2026. - Put the headers in row 1 of the first monthly tab, then copy that header row to the other monthly tabs.
- Format Amount and the calculated columns as currency. Format the four percentage columns as percentages.
- Add data validation for
Paid Byusing onlyPartner AandPartner B. Add category choices too if the list is stable. - Keep the entry columns together on the left, with calculated columns after them.
- Freeze the top row so headers stay visible while you scroll. On desktop, use View, Freeze, 1 row. On mobile, use the row menu; wording can vary by app version.
Short descriptions work better on a phone. Electric bill - January is easier to scan than a long paragraph.
Add formulas for shares and balances
These go in row 2 of each monthly tab, then get copied down. They assume Amount is column C, Paid By is column E, the percentages sit in F and G, and the calculated columns start at H.
| Cell | Formula | What it calculates |
|---|---|---|
| H2 | =IF(C2<>"",C2*F2,"") |
Partner A's share |
| I2 | =IF(C2<>"",C2*G2,"") |
Partner B's share |
| J2 | =IF(C2="","",IF(E2="Partner A",C2,0)-H2) |
Partner A's net position |
| K2 | =IF(C2="","",IF(E2="Partner B",C2,0)-I2) |
Partner B's net position |
| L2 | =IF(C2="","",F2+G2) |
Split percentage check |
A positive net position means that partner paid more than their share. A negative number means they owe the other person.
Run a quick example. Partner A pays a $100 expense with a 60/40 split. Partner A's share is $60, Partner B's share is $40, and Partner A's net position is $40. Partner B's is -$40.
That sign matters. Don't rename the net columns to vague labels like Balance 1 and Balance 2.
Reimbursements keep the same one-row structure. Say Partner A pays a $120 cost that Partner B should cover. Set Partner A to 0%, Partner B to 100%, and choose Partner A in Paid By. The row then shows that Partner B owes Partner A $120.
Create a summary dashboard
The Summary tab compares planned spending with actual spending for whichever month you pick. Type the exact monthly tab name into cell C3, such as Jan 2026.
| Cell or column | Use |
|---|---|
| A7 | Category |
| B7 | Budget |
| C7 | Actual |
| D7 | Difference |
| C3 | Selected month tab |
For actual spending by category, put this in C8:
=SUMIF(INDIRECT("'"&$C$3&"'!D:D"),$A8,INDIRECT("'"&$C$3&"'!C:C"))
In D8, use =B8-C8. Positive means the category came in under budget. Negative means it went over. Copy both formulas down for each category.
Notice which columns the formula touches. Column D holds the category and column C holds the amount, and that distinction matters. Sum the wrong one and you'll count labels instead of dollars.
To show the selected month's net position for Partner A, use:
=SUM(INDIRECT("'"&$C$3&"'!J:J"))
If the tab name in C3 is misspelled, the reference can fail. Use the same spelling everywhere.
Share the sheet without losing control
Select Share, add your partner's Google account, and choose Editor if both of you need to add rows or correct entries. On a phone, the sharing command usually hides in the three-dot menu under Share and export.
Invite specific people rather than using a broadly accessible link. The workbook contains private spending information, so review the sharing settings before you send anything.
Protect the formula columns after you've tested them. On desktop, select the calculated range and use Data, Protect sheets and ranges. Leave the entry fields editable.
Protection helps prevent accidental edits. It does not make the contents private, so sharing permissions still matter.
This sheet is a recordkeeping tool. It doesn't request, send, or verify a payment.
Keep reimbursements in a separate log
A transfer between partners is not a new household expense. Record it separately so the original grocery, rent, or utility row stays intact.
Create a Settlements tab with these columns:
| Column | Purpose | Example |
|---|---|---|
| Date | When the transfer was made | 2026-01-20 |
| Month | Monthly tab connected to it | Jan 2026 |
| From | Person who sent money | Partner B |
| To | Person who received money | Partner A |
| Amount | Amount transferred | $40.00 |
| Confirmed | Whether both agree it happened | Yes |
| Note | What the transfer settled | January groceries |
Thing is, a settlement should not erase the expense that created it. Add the settlement after the transfer is confirmed, not before, then leave the source transaction unchanged.
If you want the Summary tab to show the remaining position for Partner A, use these example cells:
| Metric | Formula |
|---|---|
| Net before settlements in G8 | =SUM(INDIRECT("'"&$C$3&"'!J:J")) |
| Confirmed received by A in G9 | =SUMIFS(Settlements!$E:$E,Settlements!$B:$B,$C$3,Settlements!$D:$D,"Partner A",Settlements!$F:$F,"Yes") |
| Confirmed sent by A in G10 | =SUMIFS(Settlements!$E:$E,Settlements!$B:$B,$C$3,Settlements!$C:$C,"Partner A",Settlements!$F:$F,"Yes") |
| Outstanding position in G11 | =G8-G9+G10 |
A positive G11 value means Partner B still owes Partner A. A negative value means Partner A still owes Partner B. Update the formula labels if you use real names.
Use a simple review routine
Add expenses when they happen, or enter them in a short daily batch. A brief weekly check-in catches missing receipts, wrong categories, and forgotten reimbursements before the numbers become difficult to untangle.
At the end of each month, review the category totals and confirm open settlements. Keep it boring. Boring works here.
Don't store bank passwords, full account numbers, or other credentials in the Notes column. A receipt location and a short explanation are enough.
Fix the problems that break shared trackers
Most shared trackers fail in small, fixable ways:
- The split doesn't equal 100%: Check column L before relying on the net figures.
- A category is spelled two ways:
GroceriesandFoodare different text values to aSUMIFformula. - A tab name changed: Fix C3 or restore the exact monthly tab name.
- A formula was overwritten: Protect H:L and spot-check a sample row after adding a new month.
- A reimbursement was entered as a negative expense: Keep expenses positive and put the transfer in
Settlements. - The
Paid Bylabel doesn't match:Partner A,A, and a real name are not interchangeable in the formulas. - The sheet is never reviewed: Set a weekly reminder and a separate monthly settle-up time.
If either partner changes the split rule, write the new rule in the Summary tab or a Notes section. A visible agreement helps when an old transaction comes up later.
Know when a spreadsheet is enough
To be honest, a spreadsheet works best when two people can agree on a routine. You get custom columns, visible formulas, and a record you can inspect yourself instead of handing the whole process to an automated system.
| Situation | A Google Sheet usually fits | Consider another workflow when |
|---|---|---|
| Two partners with manual entries | You want flexible categories and custom splits | Neither person will update it |
| Equal or proportional sharing | You can agree on percentages | The rules change for nearly every charge |
| Recurring household bills | You want a monthly history | You need automated reminders or requests |
| Reimbursements and IOUs | You can confirm transfers in a log | Many people need different access levels |
| Separate and shared spending | You want one visible record | You need features the sheet cannot provide |
A separate payment or budgeting tool may help with requesting money or scanning receipts, but those functions are different from tracking and recordkeeping. Keep the source expense record wherever it's easiest for both partners to review.
Frequently asked questions
Can we use unequal income splits?
Yes. Type the agreed percentage for each partner on every row. One proportional rule for shared bills works, or you can vary the split by category if both partners agree.
Do categories need to match exactly?
Yes. The summary formulas rely on exact text matches. Pick one term, such as Groceries, and use it on every relevant row.
Can one partner cover an expense entirely?
Yes. Set that partner's share to 100% and the other share to 0%. If the other partner paid upfront, the net columns will show the reimbursement owed.
Does the tracker prove that a payment happened?
No. It records what you enter. Mark a settlement as confirmed only after both partners agree the transfer actually occurred.
Is this tax advice?
No. Shared-expense records can be useful for your files, but U.S. tax treatment depends on the facts and may require guidance from the IRS or a qualified professional.
Build one test month with a few sample expenses before you commit to real data. Include a 60/40 bill and a 100% reimbursement, then check the net signs. Add your partner as an Editor. Once the test balances make sense, start entering current expenses.