Yes, a shared Google Sheet can track household reimbursements. You don't need a dedicated app for this.

Keep track of who paid, who owes, the agreed amount, and whether the IOU is still open. That's the whole job of the sheet. Your bank or payment app moves the money; the sheet just documents the agreement.

Start with one clear ledger rule

A reimbursement row is for one situation: one spouse paid upfront and expects an agreed amount back. If the expense came out of a joint account and nobody owes anybody anything, log it for your spending totals and leave the IOU columns empty.

Recommended columns for a couples reimbursement tracker

Skip the complicated budget dashboard. A small table is easier to keep up with. Start with these columns:

Column What to enter
Date The date of purchase or the bill date
Description A clear label such as January electricity
Category Utilities, groceries, travel, repairs, or another agreed category
Amount The full cost of the expense
Paid By Spouse A or Spouse B
Split Type Equal, Proportional, or Reimbursement
Owed By The spouse expected to repay money
Owed Amount The amount still owed, not always the full bill
Status Pending or Paid
Payment Date The date the reimbursement was sent
Receipt Link A link to the receipt or shared file
Notes A rule, transfer reference, or short explanation

Use Owed Amount for the actual IOU. Say Spouse A pays a $180 electricity bill and Spouse B owes half. The row shows $180 in Amount and $90 in Owed Amount.

Some templates show this differently, with split percentages: the payer sits at 100% and the other spouse at 0% when the expense gets entered. Fine. Those labels describe who funded the purchase, not the final amount owed, so keep the agreed repayment in Owed Amount.

Agree on the split before entering several bills

The formula can't decide what feels fair. That part is a conversation, and it needs to happen before the bills pile up.

Split method Works when Tradeoff
Equal Both people want the same share Simple, but it may ignore income differences
Proportional Contributions follow an agreed income ratio Can feel fairer, but the ratio needs review when income changes
Usage-based One person uses more of a service or stays more nights More precise, but it requires extra tracking
Category-based Each spouse takes responsibility for certain bills Easy to remember, though costs can become uneven
Reimbursement after proof One spouse fronts a cost and provides the receipt Clear for one-off expenses, but entries must be made promptly

Write the rule you land on in the Notes column or on a separate Rules tab. One sentence is enough. It prevents the later argument about whether a grocery run was shared, personal, or partly reimbursable.

Build the Google Sheets template

Open a blank Google Sheets file. The layout below is reusable, so you can copy the file for a new year or a new household arrangement.

  1. Rename the first tab Expenses. Add a second tab called Summary if you want balances kept apart from the transaction list.
  2. Put the recommended column names in Row 1, from Date through Notes. One expense per row.
  3. Format Date and Payment Date as dates. Format Amount and Owed Amount as currency.
  4. Add dropdowns with Data > Data validation: the two spouse names for Paid By and Owed By, Equal, Proportional, and Reimbursement for Split Type, and Pending and Paid for Status.
  5. Enter a test row: January 15, 2026; Electricity bill; Utilities; $180; Spouse A; Reimbursement; Spouse B; $90; Pending. Leave Payment Date blank until the transfer happens.
  6. Add the balance formulas from the next section to the Summary tab, then check the result against the test row before you enter anything real.
  7. Share the file with your spouse, and keep the same names and status labels in every row. Exact labels matter because the formulas match text.

A receipt link can point to a file in a shared Drive folder. Check that receipt file's permissions separately, since sharing the sheet doesn't share the folder.

Add formulas for pending reimbursements

Calculate outstanding IOUs from Owed Amount, never Amount. Amount tells you what the purchase cost. Owed Amount tells you what still needs repaying. These formulas assume the transaction tab is named Expenses and the first 1,000 rows are free.

Spouse A paid and Spouse B owes:

=SUMIFS(Expenses!$H$2:$H$1000,Expenses!$E$2:$E$1000,"Spouse A",Expenses!$G$2:$G$1000,"Spouse B",Expenses!$F$2:$F$1000,"Reimbursement",Expenses!$I$2:$I$1000,"Pending")

Spouse B paid and Spouse A owes:

=SUMIFS(Expenses!$H$2:$H$1000,Expenses!$E$2:$E$1000,"Spouse B",Expenses!$G$2:$G$1000,"Spouse A",Expenses!$F$2:$F$1000,"Reimbursement",Expenses!$I$2:$I$1000,"Pending")

Put the first in Summary!B2, the second in Summary!B3, and =B2-B3 in Summary!B4. A positive result means Spouse B owes Spouse A. Negative means the reverse. Zero means the pending rows balance out in both directions.

For spending by category, use the full bill amount in column D:

=QUERY(Expenses!A1:L1000,"select C, sum(D) where C is not null group by C label sum(D) 'Total'",1)

For pending reimbursement totals by category, use column H and filter the split and status columns:

=QUERY(Expenses!A1:L1000,"select C, sum(H) where C is not null and F = 'Reimbursement' and I = 'Pending' group by C label sum(H) 'Pending'",1)

Turns out spelling is where most of these break. Spouse A, Spouse A with a trailing space, and spouse a may not match the same way, so check your text carefully. And if you ever go past 1,000 rows, extend each range.

Share the file without losing control

Open Share, add your spouse's email, and pick Editor if you'll both be entering expenses. Google Sheets handles simultaneous editing, so you can review the same file together.

Use specific people access once the sheet holds receipts, notes, or household details. A link passed around too broadly can expose more than you meant to. Protect the header and formula cells with Data > Protected sheets and ranges, and leave the expense-entry rows open; protection stops accidental edits, though it won't hide anything from someone who already has editor access.

Before you rely on the file, run this check:

  • [ ] The spouse names match the formula criteria exactly.
  • [ ] The summary formulas count only Pending rows.
  • [ ] Both spouses can open the receipt links.
  • [ ] Formula cells and headers are protected.
  • [ ] Currency and date formats are consistent.

Conditional formatting can make pending rows easier to spot. Keep the visual rules simple.

Review, settle, and mark the row paid

Pick a routine you'll actually keep. A weekly review catches missing purchases. A monthly settle-up means fewer transfers.

Each session: add any missing expenses and receipts, filter Status to Pending, check each Owed Amount, and agree on the net balance. Thing is, the spreadsheet doesn't prove that money moved. Make the transfer outside the sheet, record the payment date, and flip the row to Paid only after both of you agree it's done.

If one transfer covers several expenses, put the same payment date on each row and add a short note like Settled with February transfer. Leave the original rows in place. The history is the point.

Receipts, privacy, and work-related expenses

Link receipts rather than typing full card numbers or other sensitive details into the spreadsheet. Store payment confirmations in a shared folder, with access limited to the people who actually need them.

Keep work-related reimbursements separate from ordinary household IOUs. An employer or tax authority may require specific records, and a personal Google Sheet doesn't decide whether an expense is deductible or properly documented. For situation-specific guidance, check the applicable employer policy or ask a qualified tax professional.

Common mistakes to avoid

Most tracker problems come down to unclear entries: summing the full bill instead of the amount owed, flipping Paid By and Owed By, or leaving a finished row marked Pending long after the money moved.

To be honest, the confusing part usually isn't Google Sheets. It's a fuzzy rule: one row says "groceries," another says "personal groceries," and a third reverses the payer, so the numbers look plausible while the balance quietly drifts. Write the rule down. Use one description style.

Don't delete paid rows just to make the sheet look tidy. Filter them out of the balance formulas instead, or move older entries to an archive tab.

Frequently asked questions

Can both spouses edit the tracker at the same time?

Yes. Give both people editor access and changes will appear in the shared file as they work.

Does a reimbursement row mean the other spouse owes the entire bill?

No. The Owed Amount column holds the agreed repayment. That can be the full bill, half, or another amount based on your rule.

Which formula shows the current net balance?

Put the two directional SUMIFS formulas in Summary!B2 and Summary!B3, then subtract B3 from B2 in Summary!B4. Positive means Spouse B owes Spouse A; negative means the reverse.

Should paid reimbursements stay in the sheet?

Yes. Keep them for recordkeeping, but change Status to Paid so they stop counting toward the pending balance.

Is a spreadsheet enough for a married couple?

It usually works for a small number of shared expenses and straightforward IOUs. Consider another tool only if you need automatic reminders, receipt scanning, or payment requests.

Create the file, enter the $180 test expense, and confirm the pending balance shows $90. Then remove the test row and add your next real shared expense.