Track shared child expenses and who owes whom

Shared costs for a child get argued twice: once about whether the shoes were necessary, and again about who already paid. A spreadsheet will not settle the first question. It can settle the second if you agree the split in advance and you both log the same way.

This is a record. It is not legal advice, not financial advice, and not tax advice. Court orders, support agreements, and what your agreement counts as “shared” are outside the file. If a lawyer or a court told you to track something in a specific format, follow that. Use this only as a plain log of amounts, payers, and the math of a split you typed in yourself.

Set the split and the names before the first row

Two parents. Parent A’s share is a percent you type, for example 60. Parent B’s share is the rest, calculated, not typed a second time. If the shares do not add to 100, stop and fix the settings. Do not “adjust it in your head” on the expensive months.

Type both names once in settings. Dropdowns, headers, and the sentence that says who owes whom should use those names. If you rename someone later, go back through Paid by and update the old rows. A dropdown that still says the old name will drop those payments out of the total.

Currency is a symbol, USD or RMB. Switching it does not convert amounts. Do not mix a dollar receipt and a yuan receipt in one column and expect a meaningful balance. Pick the currency you will actually settle in.

One expense, one row

Category is a dropdown so “doctor,” “Dr,” and “medical” do not become three piles. If a cost is not shared under your agreement, do not put it in this log to win an argument. The sheet will treat every row as shared and apply the percents. A personal purchase logged here becomes part of the other parent’s share.

Paid by is who fronted the money, not who you think should have. The “should” is the percent in settings.

How the balance is computed

For a period, usually a month or a stack of months you are settling:

• Total shared expenses = sum of the rows
• Each parent’s fair share = total times their percent
• Each parent’s paid = sum of rows where Paid by is their name
• Net = paid minus fair share

If Parent A’s net is positive, A fronted more than A’s share, and B owes A the difference. If it is negative, A owes B. The useful output is a sentence, not only a signed number: “Parent B owes Parent A 80.” You can check the arithmetic by hand on a small month before you trust a large one.

Example. Split 60 / 40. Three rows.

Total = 600. A’s fair share = 360. B’s fair share = 240. A paid 560. B paid 40. A’s net = 560 − 360 = 200. B’s net = 40 − 240 = −200. B owes A 200. The two nets sum to zero. If they do not, a percent or a name is wrong.

A monthly block for up to twenty-four months repeats that picture: what each parent spent, their fair share, the balance, and one “X owes Y” line per month. Settle a month when you say you will. Leaving nine months in a pile makes the necessary-or-not argument louder, because nobody remembers the shoes.

The reimbursement list is a separate record

Some parents also track a request: date, who asked, who owes, item, amount, a receipt link, and a status of Requested, Approved, Paid, or Disputed, plus the date it was settled and a note. Totals for outstanding, paid, and disputed are useful as a mailbox.

That list does not change the balance. The balance comes from the expense rows and the percents. If you mark a request Paid but forget to log the expense, or you log the expense and also expect the request total to subtract, you will double count. Use the expense log as the math. Use the request list as correspondence. If a disputed item should not be in the split, delete it or exclude it from the expense log. Do not leave it in the math and also mark it Disputed and hope the balance moved.

A monthly close

1. Both parents can add rows if you keep the file in Google Sheets. One editor is enough if the other only reads. Agree which.
2. New rows need a category and a Paid by before you send the summary.
3. Read the sentence for the month. Nets must sum to zero.
4. Send the settlement you agreed, or write down that you are rolling it, on purpose, into next month’s conversation. Do not roll it by forgetting.
5. If the split percent changes because an agreement changed, start the new percent in a new month. Do not rewrite last month’s fair shares unless you both mean to.

Print landscape, fit to width, if you need paper for a meeting. A repeating header helps when the log is long. Printing is not filing. It is a copy of the same numbers.

Limits

The file will not decide which expenses your order requires you to share. It will not compute child support, taxes, or currency conversion. It will not see a payment that nobody logged. Gray sample rows, if the template includes a sample half-year, are there so you can see the sentence work. Delete them before you rely on a total. Set the names first.

The co-parenting workbook does the split you type (Parent A’s percent, Parent B’s as the remainder), uses your names in the dropdowns and the result, shows total shared costs, each fair share, what each person paid, and who owes whom. It has a twenty-four month settle-up, a reimbursement request log that does not alter the balance, an expense log, and a category summary for tuition, medical, childcare, meals, transport, clothing, and other. The currency switch changes the symbol only. Basic formulas. Excel and Google Sheets. A short PDF explains the first setup. Not legal, financial, or tax advice. The link is in the box below.