Start with a tracker that separates goals and reimbursements
Ever finish a month with no real idea of who covered what? That's the gap a couples savings tracker template has to close. It should show three things with zero mental math: money planned for shared bills, each person's contribution, and progress toward a specific goal.
Reimbursements get their own lane. Let a grocery payback sit next to new savings and it starts reading as fresh progress, which it isn't.
You don't need a specialized app to begin, by the way. A shared Google Sheet or Excel workbook holds up well when the rules are clear and both people keep it current. A combined view doesn't require joint bank accounts either.
The chart was never the trick. The agreement behind the columns is.
Choose a template that matches your setup
Start from a template if it already separates shared and personal spending. You can layer in savings goals and settlement tracking without rebuilding every total.
| Starting point | Useful when | Check before you use it |
|---|---|---|
| Couples Budget Spreadsheet from WordLayouts | Shared expenses, individual expenses, flexible split ratios, and savings allocations live in one layout. | Confirm the categories and split rules match how rent, groceries, and personal purchases actually get handled in your house. |
| Tiller's free Google Sheets budget templates | You want a no-cost Google Sheets jumping-off point for a monthly budget. | Add columns for who paid, each partner's share, and settlement status if they're missing. |
| A blank workbook | Your arrangement has odd rules: uneven rent, separate savings accounts, frequent reimbursements. | Build the formulas slowly and test them against a few old transactions before trusting them. |
Thing is, a template can look polished and still assume every expense is shared equally, and plenty of couples aren't. Pick the structure that reflects your real arrangement, not the arrangement you wish you had.
One firm rule: no account numbers, passwords, or security answers in the workbook. The sheet tracks decisions and amounts. It isn't a vault.
Pick Google Sheets or Excel based on how you work
Google Sheets fits when both partners want the same live workbook open from different devices. It's usually the simpler way to log a purchase while you're still at the register.
Excel works better for couples who prefer a desktop file, offline access, or heavier analysis. Co-authoring is possible too, as long as the workbook lives in a supported cloud location and both people have the required Microsoft 365 setup. Microsoft's Excel co-authoring instructions spell out those requirements.
Keep one authoritative file. Two downloaded copies produce missing receipts, conflicting totals, and a steady drip of "which version is right?" messages.
Share edit access with the people who need it, and nobody else. Where your platform allows it, protect the formula cells and leave transaction entry open.
Set up five tabs
One giant tab becomes hard to trust fast. Give every job its own place.
| Tab | What belongs there |
|---|---|
| Monthly Plan | Shared income or planned contributions, expected bills, spending categories, and planned savings. |
| Transactions | Every shared purchase, who paid, the split percentages, receipt link, and settlement status. |
| Contributions | Deposits to each shared savings goal, including negative entries for withdrawals. |
| Goals | Target amount, opening balance, current balance, remaining amount, and progress percentage. |
| Rules and Settlements | Your split rules, spending approval threshold, settlement dates, and reimbursement transfers. |
Personal purchases stay off the shared Transactions tab. If the same workbook handles individual budgets, those go on separate tabs so they can't distort the settle-up total.
Agree on split rules before you enter expenses
Equal splits win on simplicity. They work when incomes, use of the home, and spending expectations feel roughly level.
Proportional splits earn their keep when one partner earns more, or when the household agreed to contribute by take-home pay. Rent and utilities might run 60/40 while shared groceries stay 50/50.
Category-based rules show up a lot too. One person covers the pet's costs, a personal subscription, or a car payment, while food and household supplies are shared.
To be honest, one universal ratio tends to cause more arguments than it prevents. Decide separately whether savings contributions follow the expense split, because they don't have to.
Put a plain-language version in the Rules tab:
Shared groceries are split 50/50. Rent and utilities are split 60/40 based on current take-home pay. Personal purchases stay personal. We review unapproved shared purchases before settling at month-end.
Then update the rule when circumstances change. Not mid-disagreement.
Add formulas that show who owes what
Use real names in the workbook. The examples below use Alex and Jamie.
| Column | What to enter |
|---|---|
| A: Date | Purchase date |
| B: Description | A label you'll recognize later, such as "Groceries - March 12" |
| C: Category | Groceries, utilities, rent, household, or another agreed category |
| D: Paid By | Alex or Jamie |
| E: Total | Full purchase amount |
| F: Alex Share % | Alex's agreed percentage, such as 50% or 60% |
| G: Jamie Share % | Jamie's agreed percentage |
| H: Alex Share | =IFERROR(E2*F2,0) |
| I: Jamie Share | =IFERROR(E2*G2,0) |
| J: Split Check | =IF(ABS(F2+G2-1)<0.001,"OK","Check split") |
| K: Receipt or Note | Receipt link, reimbursement note, or the reason for a custom split |
Format the share columns as percentages. A $250 utility bill split 55/45 should show $137.50 for Alex and $112.50 for Jamie.
Reserve 0% and 100% for costs one person is responsible for in full, and drop a note when you use them. Neither of you should have to reconstruct the reason months later.
On a Dashboard tab, Alex's purchase credit comes from:
=SUMIF(Transactions!$D:$D,"Alex",Transactions!$E:$E)-SUM(Transactions!$H:$H)
A positive result means Alex paid more than Alex's assigned share and should receive money at settlement. Jamie's formula follows the same pattern.
Reimbursement transfers belong on the Settlements tab, not entered as negative groceries. If column B lists the payer, column C the recipient, and column D the amount, Alex's settlement adjustment is:
=SUMIF(Settlements!$B:$B,"Alex",Settlements!$D:$D)-SUMIF(Settlements!$C:$C,"Alex",Settlements!$D:$D)
Add that adjustment to Alex's purchase credit and you get the current balance after transfers.
Track savings contributions separately
A transfer into savings is not a household expense. Treat it like