How to Keep a Shared Cost Ledger Between Siblings

Decide what the ledger is for before you open a spreadsheet

Be clear with everyone from the first email that this is a record, not an agreement. That single sentence prevents most of the resistance, because what people are usually resisting is the feeling that they are being invoiced.

A shared ledger serves three purposes. Visibility, so nobody is guessing what anyone else is spending. Settlement, so reimbursement happens monthly on a known date instead of building into an awkward number. And history, so that when a form, an agency, an insurer or an attorney asks what has been spent on your parent's care and from where, you can answer with a file rather than a memory.

What it is not: it is not a binding arrangement between siblings, and it is not a scoreboard. Anything intended to be binding — a loan between family members, a repayment arrangement, anything involving your parent's assets — is drafted by an attorney, and the ledger simply records what happened. Write that in the header of the sheet so it is never in doubt.

Agree the purpose in one email, then set the thing up the same evening while agreement is fresh.

The exact columns to use

Ten columns. Fewer and you will be reconstructing detail later; more and nobody fills it in.

Use: Date | Paid by | Paid from (which account) | Category | Vendor and description | Amount | Receipt (Y/N + file name) | For whose benefit | Reimbursable (Y/N/Pending) | Settled on.

Two of those columns do most of the work. "Paid from" separates money that came out of a sibling's own account from money that came out of your parent's, and that distinction has to be visible on every single row. "For whose benefit" separates spending on your parent from household spending that also benefits others and from a sibling's own travel costs, which are real but different in kind.

Fix the category list at the start and never let it grow informally, or the annual totals become meaningless. Eleven categories cover almost everything. Add a new one only by agreement at a family meeting, and if you do, go back and recode the year.

• Medical copays, premiums and office fees
• Pharmacy and prescriptions
• Home care hours and agency invoices
• Transport, gas, parking, tolls and rides
• Groceries and household supplies
• Home repairs, maintenance and safety items
• Utilities, property taxes and insurance on the home
• Equipment purchase or rental
• Legal, accounting and professional fees
• Sibling travel to visit
• Everything else, described in full

The receipt rule that prevents the whole argument

One rule, applied without exception: photograph the receipt before you leave the parking lot. Not that evening, not at the weekend. In the car.

Name the file immediately in the format 2026-08-14_Pharmacy_2317.jpg — date first so it sorts, vendor second, last four digits of the total or the receipt number third. Drop it into a shared folder with one subfolder per month. Twelve folders a year, nothing nested deeper.

When there is no receipt, and there often is not — the neighbour's teenager who mowed the yard, the parking meter that prints nothing — still put the line in the ledger and write "no receipt" in that column. A ledger with a few honest gaps is credible. A ledger with silent gaps is not, and the missing lines are exactly the ones somebody will query later.

One person owns the folder and does a monthly sweep for rows marked Y where no file exists. That is a five-minute job and it is the difference between a ledger that holds up in a difficult conversation and one that dissolves under the first question.

The fifteen-minute monthly close

Pick a date — the first Sunday works well because statements have landed — and run the same six steps every month. Whoever holds the ledger does it; nobody else needs to be involved until step six.

One, enter anything still sitting in your camera roll or your inbox. Two, reconcile against the statements for both accounts, your own and your parent's, and chase anything on a statement that is not in the ledger. Three, check every row marked as having a receipt actually has a file. Four, total by category and by person. Five, calculate the net settlement — a single figure and a single direction, not four transfers. Six, send a one-page PDF to everyone with the month's total, the category breakdown, and the settlement figure.

That monthly PDF is worth more than the spreadsheet. It arrives whether or not anyone asks, it is short enough to read on a phone, and it means the annual conversation is a formality rather than a discovery. Name it Care-Ledger_Surname_2026-07.pdf and file it behind the money tab in the binder.

How to settle up without a fight

Settle monthly. The size of the number is what makes these conversations hard, and a monthly number is always small enough to pay without anyone having to think about it.

Use one net transfer in one direction rather than everyone paying everyone. Agree a de minimis figure — under twenty dollars, nobody bothers — and agree it in advance so it is a policy rather than a favour.

Keep money that came from your parent's account rigidly separate. Give it its own tab, its own totals and its own receipt folder, and never let a single row mix the two. If a power of attorney or any similar authority is in place, the person acting under it should ask the attorney who drafted it, and the bank, exactly what records they are expected to keep and in what form. Do not work it out from what a forum said. Ask, write the answer in the header of the tab, and keep to it.

Where someone cannot pay their share, record it as such with a date rather than quietly writing it off. A recorded and forgiven amount is a fact. An unrecorded one becomes a grievance.

What the ledger should not try to do

Ledgers get overloaded, and overloaded ledgers get abandoned by about month four. Three things to keep out.

It is not a tax document. Categorised annual totals and a receipt folder are exactly what a tax preparer needs, and whether any of it is deductible in your particular situation is their question to answer, not yours and not the internet's. Your job is the folder. Take it to them once a year.

It is not a legal agreement. If siblings are lending money, repaying each other over time, or making any arrangement involving your parent's property or assets, an attorney drafts that. The ledger records the payments that followed.

And it is not an hours tracker. Time is the other currency in caregiving, and it deserves its own record, but mixing hours and dollars in one sheet reliably produces an argument about what an hour is worth. Keep hours in the rota, money in the ledger, and bring both to the same meeting.

Questions