Shared bills turn messy when a spreadsheet treats a merchant charge and a later repayment as one event. Keep the two records separate, and the file can show household spending, each person's responsibility, and the remaining balance.

One field names the person who paid the merchant. Another names the person responsible for the cost. Paid By and Share answer different questions.

This copy-ready tracker works in Google Sheets or Excel. It records your entries and runs formulas; it does not connect to a bank account or send money.

Use your own names for Partner 1 and Partner 2.

Build the Expenses tab

The Expenses tab is the source of truth for purchases and bills. Add one row per charge, even if the same partner paid several things.

Column What to enter Example
Date Date the charge occurred 01/01/2026
Description Specific name for the expense January rent
Category Household budget group Housing
Paid By Partner who paid the merchant Partner 1
Amount Total charge as a positive number $2,000.00
Split Method Equal, Proportional, Custom, or Personal Proportional
Partner 1 % Partner 1's agreed responsibility 60%
Partner 2 % Partner 2's agreed responsibility 40%
Partner 1 Share Formula-calculated responsibility $1,200.00
Partner 2 Share Formula-calculated responsibility $800.00
Settled? Optional visual marker No
Notes Receipt, due date, or context Paid from checking

Enter charges as positive numbers. Put a refund or credit on its own row as a negative adjustment, then agree how it changes the original split.

A personal purchase can stay off this tab. If you need it recorded, choose Personal and allocate 100% to one partner.

Make descriptions review-friendly. January rent is better than bill.

Add the share formulas

Columns I and J calculate each person's responsibility. Paste these formulas into row 2, then fill them down.

I2: =IF(E2="","",IF(F2="Equal",E2/2,IF(SUM(G2:H2)=0,0,E2*G2/SUM(G2:H2))))
J2: =IF(E2="","",IF(F2="Equal",E2/2,IF(SUM(G2:H2)=0,0,E2*H2/SUM(G2:H2))))

Equal ignores the percentage cells and divides the amount in half. Every other method uses G and H as weights, so the formula still calculates when the pair does not total exactly 100%.

For Proportional, enter agreed income shares in G and H. For Custom, enter the exact responsibility. For Personal, use 100% and 0%, or reverse them.

An unfinished non-equal row returns zero shares. Complete G and H before trusting a balance.

Turns out, leaving the visible percentages in place makes later checks much easier. The formula can normalize a 60% and 40% pair, but the written percentages show what you both agreed to.

This layout assumes two people, so it needs no participant-count cell. In a separate equal-split model, you could store a count in N2 and use =IFERROR(E2/$N$2,0).

Set up the workbook in Google Sheets or Excel

Set up the file once, then test it before sharing.

  1. Open a blank workbook. Name the tabs Expenses, Payments, and Budget. Add an optional Rules tab if your split agreements need more explanation.
  2. Paste the expense headers into row 1. Format Date as a date, Amount and the share columns as currency, and the percentage columns as percentages.
  3. Create dropdowns for Paid By, Split Method, and Settled?. Use your two names, Equal, Proportional, Custom, Personal, Yes, and No as appropriate. Excel users can use Microsoft's data validation guidance for list restrictions.
  4. Test the formula with $2,000 rent at 60/40. It should return $1,200 and $800. Add $250 utilities at 55/45, then $120 groceries as an equal split.
  5. Paste the share formulas into columns I and J. Copy them through the rows you expect to use.
  6. Freeze the first row and enable filters. In Google Sheets, use the View menu. In Excel, use View, Freeze Panes, then Freeze Top Row.
  7. Protect the formula columns after testing. Keep entry cells open so either partner can add a charge or payment.
  8. Excel users can convert the range into a table. Microsoft's structured references guidance covers table formulas if you prefer names over cell coordinates.

Keep the range endpoints consistent. If you extend one formula from row 1000 to row 2000, extend the related ranges too.

Choose the split rule before tracking bills

Agree on the rule before a large bill arrives. The spreadsheet should record a decision, not settle a fairness argument after the fact.

Method Use it when Entry rule Tradeoff
Equal Incomes, usage, and spending habits are fairly similar Choose Equal Simple, but it may not reflect different incomes or usage
Proportional You want contributions tied to an agreed income ratio Enter the percentages in G and H You must agree on gross pay, take-home pay, or another basis
Category-based Different types of bills need different treatment Set the method per row The categories and rules need written notes
Custom or usage-based One person uses more of a service or item Enter the exact percentages More accurate for some bills, but it requires better records

Proportional does not have to mean gross pay. Some couples use take-home pay, while others use gross pay. Pick one basis and record it in Rules or Notes so the ratio does not quietly change each month.

Hybrid rules can work well. Rent might be proportional, groceries might be equal, and personal purchases might stay separate.

To be honest, a rule you both use beats a sophisticated formula nobody updates. Review the ratio when income, living arrangements, or regular usage changes.

Track reimbursements in a separate Payments tab

The Expenses tab answers what the household bought. The Payments tab answers what cash moved afterward.

Suppose Partner 1 pays $120 for groceries and the bill is split equally. Each partner's share is $60, so Partner 1 has advanced $60 for Partner 2.

Create the Payments tab with these columns:

Date From To Amount Note
01/06/2026 Partner 2 Partner 1 $60.00 January groceries

Do not add that $60 transfer to Expenses. It is a repayment, not another grocery purchase.

For partial reimbursements, add each transfer as its own row. Never overwrite an earlier payment.

Use this formula in a summary cell for Partner 1's all-time balance:

=SUMIF(Expenses!$D$2:$D$1000,"Partner 1",Expenses!$E$2:$E$1000)-SUM(Expenses!$I$2:$I$1000)+SUMIF(Payments!$B$2:$B$1000,"Partner 1",Payments!$D$2:$D$1000)-SUMIF(Payments!$C$2:$C$1000,"Partner 1",Payments!$D$2:$D$1000)

The formula starts with what Partner 1 paid, subtracts Partner 1's assigned share, then adjusts for transfers sent and received.

A positive result means Partner 1 fronted more than their share. A negative result means Partner 1 owes money instead. After Partner 2 sends the $60 in the example, the balance returns to zero if there are no other rows.

For a two-person file, Partner 2's balance is the inverse of Partner 1's when every expense has a complete allocation. The Settled? field can provide a quick visual flag, but the Payments tab is the actual transfer history.

Thing is, the balance is only as current as the last payment you entered.

Add a monthly Budget tab

A reimbursement balance is not a spending limit. Use a Budget tab when you want planned amounts compared with total household spending.

Column Purpose
Category Housing, groceries, utilities, or another group
Planned Amount set aside for the month
Actual Matching expense total for the month
Variance Planned minus actual

Put the first day of the review month in B1. If the category is in A4, enter this formula in C4:

=SUMIFS(Expenses!$E$2:$E$1000,Expenses!$C$2:$C$1000,A4,Expenses!$A$2:$A$1000,">="&$B$1,Expenses!$A$2:$A$1000,"<"&EDATE($B$1,1))

Then enter this in D4:

=B4-C4

Copy both formulas down for each category. A positive variance means spending is below the planned amount. A negative variance means the category is over plan.

Use real spreadsheet dates in the expense rows and in B1. Text that only looks like a date can prevent the monthly formula from finding the row.

This tab counts the full expense amount before reimbursements. That is generally the useful figure for a household spending limit; the Payments tab handles money returned between partners.

Share the file without making it public

Both partners need access, but the workbook should not be public. In Google Sheets, invite your partner as an Editor. In Excel, share the workbook through OneDrive.

Review access when your household changes. Keep bank account numbers, passwords, and full login credentials out of the file.

Cell group Recommended handling
Date, description, category, payer, amount, method, percentages, and notes Leave editable
Partner 1 Share and Partner 2 Share Protect after testing
Balance summary formulas Protect
Budget Planned and category names Leave editable
Budget Actual and Variance formulas Protect

For Excel, unlock the cells that others may edit before protecting the worksheet. Microsoft's worksheet protection guidance describes that two-step process.

For Google Sheets, protect the formula ranges and leave the entry columns available. A tracker works better when adding dinner takes a few seconds.

Fix the small habits that break totals

Most incorrect balances come from a few repeat mistakes.

Double-counting a repayment. Keep the merchant charge on Expenses and the cash transfer on Payments.

Confusing payer and responsibility. The person who used a card may not owe the whole bill. Select Paid By separately from the two share percentages.

Overwriting a partial payment. Add a new payment row for every transfer. The dates and amounts create an audit trail.

Using text in number cells. Keep Amount and percentage cells numeric. A label placed in a calculation column can stop the formulas from working as expected.

Changing a rule without a note. If you switch from equal to proportional, record the change and the date in Rules or Notes.

Use a small review routine

A tracker needs a routine that feels lighter than the problem it solves.

When Action
After a purchase Add the expense, choose the category, and save the receipt or context in Notes
Once a week Spend about five minutes adding missing charges and correcting unclear entries
Once a month Review category totals, upcoming bills, and the running reimbursement balance
After a settlement Enter the transfer immediately and check that the balance moved as expected

If practical, settle the net balance with one transfer rather than several small ones. Then record it while the payment is still easy to identify.

Create the three tabs, enter the test rows, and agree on the split rule before the next shared bill arrives.