Log caregiver time, shared purchases and reimbursements
Set up a family caregiving tracker that records care time, shared purchases, receipts, agreed shares and repayments in four linked spreadsheet tables, with a worked example.
Contents
The simplest reliable setup is one spreadsheet, in Excel or Google Sheets, with four linked tabs: Time, Purchases, Agreements and Repayments. Each purchase gets a transaction ID, and every agreement and repayment points back to that ID. Care hours stay in their own tab and are never converted into money automatically. With this structure, anyone in the family can see who did what, who paid, whose money was used, what everyone agreed to and what is still open.
What this tracker covers
The tracker covers three things: the actual time relatives spend on care tasks, the nontravel purchases made for the person receiving care, and the reimbursements family members report sending to each other. Mileage and appointment travel belong in whatever travel or appointment log you already keep. Store those entries there so they are not counted twice. Clinical information, such as symptoms, medications or care instructions, also belongs elsewhere. The healthcare provider is not a party to family reimbursement arrangements. Provider and pharmacy invoices and statements are simply supporting records that you attach to a purchase.
Three roles shape the log. The person receiving care may be funding some purchases from their own money and should have a say in how their finances are handled. The family coordinator maintains the spreadsheet and runs the regular review. Other relatives add their own entries and confirm the ones that involve them.
Separate the two kinds of money first
The most useful distinction is between money that belongs to the person receiving care and money a relative paid personally. Purchases from the care recipient's own account do not create a family reimbursement question. Purchases a sibling paid out of pocket might, if the family agreed to share them. CoParentSplit's caregiver expense log follows this approach. It has separate fields for purchases funded by the parent's money and purchases paid personally by relatives. It also records whether a receipt is available, each participant's share, repayments and, optionally, care hours, with monthly summaries by funding source and by person.
Set up four linked tables
| Tab | Columns | Purpose |
| Time | Date, caregiver, activity, start, finish, breaks (minutes), actual minutes | Records care time as time only |
| Purchases | Transaction ID, date, nontravel purpose, amount, currency, payer, funding source (care recipient's money or payer's own money), receipt reference | One row per purchase |
| Agreements | Related transaction ID, participants, expressly agreed shares, confirmation date, unresolved items | Records what people actually agreed to for a specific purchase |
| Repayments | Related transaction ID, sender, recipient, amount, date, reported status, confirmation | Records money moving between relatives |
For the receipt reference, use something you can find again later, such as a photo file name or a folder and file number. Repayments go only in the Repayments tab. A repayment is a transfer linked to an existing purchase, not a new purchase, so entering it in the Purchases tab would double-count the money.
Spreadsheet formulas for the main calculations
Excel and Google Sheets store times as fractions of a day, so multiplying by 1440 converts a time difference to minutes. The formulas below assume the column layouts in the comments. Adjust the cell references to match your sheet, and format Start and Finish as times.
Time tab (D = Start, E = Finish, F = Break minutes)
Actual minutes: =(E2-D2)*1440-F2
Hours (optional): =G2/60
Agreements tab, one row per participant (B = Participant, C = Share %, A = Transaction ID)
Amount owed: =C2*XLOOKUP(A2,Purchases!A:A,Purchases!D:D)
Outstanding for a participant on a transaction:
=AmountOwed - SUMIFS(Repayments!D:D,Repayments!A:A,A2,Repayments!B:B,B2,Repayments!G:G,"Confirmed")In older Excel versions without XLOOKUP, INDEX and MATCH does the same lookup. The payer's own share does not need a repayment row. Only the other participants' shares are expected to move.
A recording routine that keeps the log current
- Pick a starting date and log only from that date forward, so the family does not have to reconstruct the past.
- Enter purchases as they happen, with amount, category or purpose, payer and funding source.
- Photograph the receipt right away and record its file name in the receipt reference column.
- Keep invoices and statements, such as pharmacy or provider bills, alongside the receipts.
- Log care time from actual start and finish times, subtracting breaks.
- Let each relative enter their own time and purchases, then have the coordinator check the entries at the regular review.
CareSplit's suggested routine follows the same pattern: choose a starting date, enter purchases as they occur, attach receipt photos, record amounts and categories, share the entry work and produce a regular summary. It is presented as a workflow suggestion, not as a rule for what counts as a fair contribution.
Worked example (hypothetical)
The following example is illustrative and does not describe a real family. Alex provides a care session from 09:15 to 10:45 with a 15-minute break. The Time tab records 75 minutes, or 1.25 hours. No dollar value is attached to that time.
Separately, Alex pays $72 from their own money for a nontravel purchase that Alex, Bea and Chen agreed to share. The Purchases tab records one row with Alex as payer and Alex's own money as the funding source. The Agreements tab records the explicit shares of 50%, 25% and 25%, which come to $36 for Alex, $18 for Bea and $18 for Chen. Bea sends Alex $18, and both confirm it, so the Repayments tab shows one confirmed $18 transfer linked to the purchase. Chen's $18 stays visible as pending under that same agreement.
| Item | Recorded as | Status |
| Care session, 75 minutes | Time tab only | Logged |
| $72 purchase paid by Alex | Purchases tab, payer's own money | Receipt referenced |
| Shares 50/25/25 | Agreements tab | Confirmed by all three |
| Bea to Alex, $18 | Repayments tab, linked transfer | Confirmed |
| Chen to Alex, $18 | Agreements tab outstanding balance | Pending |
Run a short monthly review
- Filter for purchases with no receipt reference and decide how to document each one.
- List purchases that have no confirmed agreement yet, along with any disputed shares.
- Show pending repayments by person and by transaction.
- Go through the actual entries with the participants before marking anything confirmed.
- Check receipts, invoices and statements against the log, and resolve any discrepancies.
- Summarize totals by funding source and by person, and keep time totals separate from money totals.
When the review touches the care recipient's own money, include them in the conversation about their financial preferences wherever they are able to take part. A guest author on CalendarBudget recommends this, along with keeping receipts, invoices and statements and reviewing discrepancies.
What the log records and what it does not decide
The tracker records what happened and what people said they agreed to. It does not create a debt or an entitlement on its own, and logged hours do not imply that anyone is owed payment for their time. Unresolved items stay open until the people involved settle them. If the family plans to use these records for taxes, benefits or a formal paid caregiver arrangement, check the current requirements with the relevant agency or a qualified professional before relying on this structure, because those uses may call for documentation the log does not capture.
Related articles
How to Write a Clear Nonclinical Care Task Handoff
A practical guide to writing a care task handoff note for family members, friends or household help, with a checklist, a reusable template and tips for shared care.
Moving family care records to another organizer
A step-by-step guide to moving family care records, appointments, contacts and documents into a new online organizer without losing information or access.
Removing a former caregiver's access to a shared care organizer
A practical checklist for removing a former caregiver's access to shared care calendars, notes, files, organizer apps and accounts on an iPhone, and handing off cleanly.
Organize a confirmed move into senior living
A practical plan for families coordinating an agreed move into senior living: confirm requirements with the residence, track requested paperwork, decide belongings with the resident, manage notifications and assign moving-day roles.
Plan a nursing home tour around family logistics and administrative questions
A practical guide to preparing for a nursing home tour, recording answers about visits, family communication, belongings, administration and fees, and comparing facilities against your household's priorities.
Check a home care invoice against visit records and agreed terms
A step-by-step method for matching home care invoice lines to booked visits, household time records and agreed rates, recalculating totals and asking clear questions.
Compare apps against your family's care coordination requirements
Build a household requirements matrix, test care coordination apps with fictional tasks, and verify access, cost, export and privacy before choosing.
Compare Splitwise and Tricount for shared family caregiving expenses
Splitwise vs. Tricount for family caregiving costs: entry limits, receipts, editing access, repayments, exports, cost and privacy, matched to your family's needs.
Track hospital belongings, transfers and returns
A practical family worksheet for logging a relative's hospital belongings, where each item was placed, every transfer, what came back and what is still missing, alongside the hospital's own property process.
Prepare household arrangements for a first home care visit
A practical checklist for agreeing visit timing, arrival contact, home access, space, communication preferences and nonclinical tasks before a first home care visit.