A budget-share pet expense calculator works when people share a pet but have different budgets. Build it in Google Sheets with one expense per row, an agreed percentage for each person, and a summary that compares responsibility with actual payments.

Use percentages that total 100%. A 60/40 split on a $100 vet bill assigns $60 to one person and $40 to the other, while the payer field records who fronted the charge. The spreadsheet handles the arithmetic. Your group still needs to agree on the rule.

Pick the split before you build formulas

Budget share fits when the group has agreed to tie contributions to income or a planned budget. It isn't automatically fair for every pet arrangement.

Split method Use it when Example
Equal Everyone accepts the same contribution $100 becomes $50 each
Budget share Contributions follow an agreed income or budget ratio 60% and 40%
Usage-based Care, use, or benefit is noticeably different One person covers a service they mainly use
Reimbursement One person paid first and the group settles afterward Jordan sends Alex $40

Write down the basis. If income is involved, note whether percentages use take-home pay, a fixed monthly budget, or another agreed measure. Revisit the numbers after a job change or a lasting change in who handles care.

Equal splitting is easier to explain. Budget sharing takes one extra decision, but it can better match the arrangement your household has chosen.

Set up the tabs

Keep the settings separate from the expense log. That small bit of separation prevents a changed ratio from being mistaken for an old transaction.

Create a Settings tab like this:

Cell Entry Purpose
A1 Person Header
B1 Share Header
A2 Alex Person name
B2 60% Alex's agreed share
A3 Jordan Person name
B3 40% Jordan's agreed share
A4 Total Check row
B4 =SUM(B2:B3) Should show 100%

Format B2:B4 as percentages. Enter 60%, not 60 formatted as a percentage.

Use this layout on the Expenses tab. Replace Alex and Jordan with the actual names in your group.

Column Field What to enter
A Date The purchase date, such as 2026-01-15
B Description Dog food, cat checkup, or grooming
C Category Food, Vet, Grooming, Medication, or Supplies
D Total Amount The full charge
E Split Type Budget Share, Equal, or Reimbursement
F Paid By The person who paid
G Alex Share % The percentage applied to this row
H Jordan Share % The percentage applied to this row
I Alex Share Alex's calculated responsibility
J Jordan Share Jordan's calculated responsibility
K Share Check Confirms the row totals 100%
L Notes Receipt link or extra detail

For three or more people, add one share column and one calculated-share column per person. The same pattern still works.

The ratio changes sometimes, and then old rows, well, they shouldn't quietly change with it. For a stable record, paste the current percentages into G and H as values before changing the Settings tab. For a live tracker, formulas such as =Settings!$B$2 and =Settings!$B$3 are convenient, but they will update earlier rows when the default ratio changes.

Build the calculator

  1. Create a blank Google Sheets file with Settings, Expenses, and Summary tabs. Add a Transfers tab if you want to record repayments separately.
  2. Enter each person's name and percentage on Settings. Add =IF(B4=100%,"OK","Check shares") in C4 if you want a visible warning.
  3. Add the expense headers, then format Total Amount and calculated-share columns as currency.
  4. Enter a sample row: a $100 vet bill, Alex as the payer, 60% in G2, and 40% in H2.
  5. Add the formulas below and copy them down for future rows.
  6. Check the sample before entering older receipts.

Add the budget-share formulas

With Total Amount in D, the applied percentages in G and H, and calculated shares in I and J, enter:

I2: =D2*G2
J2: =D2*H2
K2: =SUM(G2:H2)

With a $100 total, G2 at 60%, and H2 at 40%, I2 returns $60 and J2 returns $40. K2 should return 100%.

Copy I2:K2 down. Keep the row references relative so each expense uses its own amount and percentages.

If you skip the row-level share columns and want every new row to use the Settings values directly, use:

I2: =D2*Settings!$B$2
J2: =D2*Settings!$B$3

The dollar signs lock the Settings cells when you copy the formulas down. Do not divide by 100 when your cells contain real percentages. If you type whole numbers instead, use =D2*G2/100; don't mix the two formats.

See category totals and settlement balances

Category totals answer a different question from settlement balances. The first shows where money went; the second shows who should pay or receive.

List a category in A2 on the Summary tab and use:

=SUMIF(Expenses!$C:$C,A2,Expenses!$D:$D)

For a fixed category, this also works:

=SUMIF(Expenses!$C:$C,"Vet",Expenses!$D:$D)

Build a balance table beside those totals:

Person Responsibility Paid Balance
Alex =SUM(Expenses!$I:$I) =SUMIF(Expenses!$F:$F,"Alex",Expenses!$D:$D) =B2-C2
Jordan =SUM(Expenses!$J:$J) =SUMIF(Expenses!$F:$F,"Jordan",Expenses!$D:$D) =B3-C3

A positive balance means the person still needs to pay the group. A negative balance means the group owes that person.

If Alex pays the full $100 vet bill, Alex has a $60 responsibility but paid $100, producing a -$40 balance. Jordan has a $40 responsibility and paid nothing, producing a $40 balance. Jordan sends Alex $40.

Track reimbursements without double counting

Log the original pet charge once. A reimbursement is a transfer afterward, not another vet, food, or grooming expense.

Use a separate Transfers tab with Date, From, To, Amount, and Note columns. On the Summary tab, you can adjust the balance formula to include transfers:

=B2-C2-SUMIF(Transfers!$B:$B,A2,Transfers!$D:$D)+SUMIF(Transfers!$C:$C,A2,Transfers!$D:$D)

That formula treats money sent as reducing a balance and money received as increasing it.

Some simple templates mark a reimbursement with one person at 100% and everyone else at 0%. If you use that convention, exclude those rows from category totals. Otherwise, the sheet counts the same money twice.

Share and maintain the sheet

Thing is, access settings are part of the money workflow. Give edit access only to people who will enter expenses; others can use view or comment access, and formula or Settings ranges should be protected where possible.

Keep receipt links in Notes instead of scattering them across group chats. A weekly review suits an active household. Monthly is enough for occasional costs.

Before changing the agreed ratio:

  • Copy the current G:H percentages and paste them as values.
  • Check that every Share Check cell shows 100%.
  • Review unpaid balances and attach missing receipts.
  • Use version history before making a major edit.

When a sheet is enough

Sheets is a sensible fit for a small group that wants custom columns, visible formulas, and a shared receipt record. It won't send money or chase a payment.

Consider a dedicated app if mobile entry, reminders, or payment requests matter more than formula control. Keep the expense record and the settlement record aligned either way.

Common formula mistakes

Mistake Fix
Entering 60 and formatting it as a percentage Enter 60%, or divide whole numbers by 100
Forgetting the dollar signs in Settings references Use Settings!$B$2 and Settings!$B$3
Letting a changed ratio rewrite old expenses Paste each row's percentages as values
Adding reimbursement transfers to expense totals Use the Transfers tab or exclude transfer rows
Saving a row with shares that do not total 100% Check the Share Check column first

Start with one real receipt, such as the next food purchase or vet bill. Enter the agreed shares, confirm the row check reads 100%, and compare the summary balance with the amount the payer actually fronted.