Care Expenses: Robert (Dad), March 2025
I logged 13 expenses totaling $974.60. That total doesn't include the 38 miles, which still need a rate. 5 items need a quick check before you settle up, and they're all listed in section 4.
1. Expense spreadsheet (CSV)
Copy everything in the box below into a file named care-expenses.csv, or paste it straight into Google Sheets or Excel.
Date,Payee,Description,Category,Amount,Paid By,Reimbursable,Notes
2025-03-02,CVS,Prescriptions for Dad,Medical & Prescriptions,42.18,Jen,Yes,"Listed as ""I paid""; you are Jen"
2025-03-05,Uber,Rideshare to cardiology appointment,Transportation & Mileage,23.50,Sam,Yes,
2025-03-05,Uber,Rideshare home from cardiology appointment,Transportation & Mileage,21.75,Sam,Yes,Same day as the ride there but a different amount so not a duplicate
2025-03-07,Dr. Patel,Doctor visit copay,Doctor & Dental Visits,40.00,Dad's checking,No,Paid from Dad's own account
2025-03-09,Walmart,Adult briefs and wipes,Personal Care & Hygiene,61.07,Unknown,Check,FLAG: no payer listed
2025-03-12,Amazon,"Shower chair, grab bar",Home Safety & Modifications,89.98,Jen,Yes,"Listed as ""me""; you are Jen"
2025-03-15,Brenda (home aide),Home aide 12 hrs @ $25,In-Home Care & Aides,300.00,Dad's checking,No,Math checked: 12 x 25 = 300.00
2025-03-18,Kroger,Groceries for Dad,Groceries & Meals,74.32,Sam,Yes,
2025-03-22,Brenda (home aide),Home aide 10 hrs @ $25,In-Home Care & Aides,250.00,Dad's checking,No,"FLAG: listed as $260 but 10 x 25 = 250.00; used 250.00. Check hours, rate, or any extra charge"
2025-03-24,CVS,Prescriptions,Medical & Prescriptions,18.40,Unknown,Check,FLAG: possible duplicate of the next row (same date/store/amount); no payer listed
2025-03-24,CVS,Prescriptions,Medical & Prescriptions,18.40,Unknown,Check,FLAG: possible duplicate of the row above; no payer listed
2025-03-28,,Gas driving Dad to physical therapy (38 miles),Transportation & Mileage,,Jen,Yes,"FLAG: 38 miles; amount blank until the family picks a per-mile rate. Assumed Jen from ""my gas"""
2025-03-30,,Dad's cell phone bill,"Phone, Tech & Subscriptions",35.00,Jen,Yes,"Listed as ""me""; you are Jen. Phone company not named"
2. Category summary
| Category | # of items | Total | % of total |
|---|---|---|---|
| In-Home Care & Aides | 2 | $550.00 | 56% |
| Home Safety & Modifications | 1 | $89.98 | 9% |
| Medical & Prescriptions | 3 | $78.98 | 8% |
| Groceries & Meals | 1 | $74.32 | 8% |
| Personal Care & Hygiene | 1 | $61.07 | 6% |
| Transportation & Mileage | 2 | $45.25 | 5% |
| Doctor & Dental Visits | 1 | $40.00 | 4% |
| Phone, Tech & Subscriptions | 1 | $35.00 | 4% |
| Total | 12 | $974.60 | 100% |
The mileage item (38 miles) isn't counted here because its amount is still blank.
- Brenda's home aide visits were about 56% of March spending, and Dad's checking covered all of it.
- Dad's checking paid $590.00 in total (about 61%). Jen and Sam together paid $286.73 on confirmed items.
- Everything else (supplies, rides, groceries, prescriptions, phone) is spread across small amounts, each under 10%.
3. Who paid & settle-up
This uses your rule: anything Jen or Sam paid is split 50/50 between you two. Dad's checking pays for its own items and doesn't pay anyone back.
| Person/Account | Paid | Fair share | Difference (+ is owed money, - owes money) |
|---|---|---|---|
| Jen | $167.16 | $143.37 | +$23.80 |
| Sam | $119.57 | $143.37 | -$23.80 |
| Dad's checking | $590.00 | $590.00 (not split) | $0.00 |
| Unknown payer (3 items) | $97.87 | n/a | Not included yet |
The exact half is $143.365, so the difference rounds to $23.80.
Sam pays Jen $23.80. (This covers confirmed items only.)
Once you sort out the flagged items, here's how they change things. Whoever actually paid an item gets back half of it from the other person:
- Walmart briefs and wipes, $61.07: shifts $30.54 toward whoever paid.
- Each CVS $18.40 prescription: shifts $9.20 toward whoever paid. If it turns out to be a duplicate, it changes nothing.
- Mileage, 38 miles: once you pick a rate, the amount is 38 × your rate, and Sam owes Jen half of that. For example, at a rate of $0.50/mile it would be $19.00, so Sam would owe Jen $9.50 more. That rate is just an example to show the math, not a recommendation.
If Jen paid all three unknown items, Sam would pay Jen $72.73 before mileage. If Sam paid all three, Jen would pay Sam $25.14 before mileage.
4. Items to check
- 3/9 Walmart, $61.07: Who paid, Jen or Sam?
- 3/24 CVS, $18.40 (two identical lines): Was this one purchase entered twice, or two separate prescriptions? And who paid?
- 3/22 Brenda, home aide: You wrote $260, but 10 hrs × $25 = $250. Was it really 10 hours, or was there an extra $10 (a fee or reimbursement)? I used $250 for now.
- 3/28 Mileage, 38 miles: Pick a per-mile rate together as a family, then fill in the Amount.
- 3/30 cell phone bill: This isn't a problem, just a note: the phone company wasn't named, so Payee is blank. Add it if you'd like it for your records.
5. Assumptions
- "I," "me," and "my" mean Jen, since you're the one filling this out.
- All dates are in 2025, based on "March 2025."
- I read "Keep home aide separate" as keeping Brenda's visits in their own category, and they're also shown separately in the summary. If you meant something else, like leaving them out of the totals, you can use your one free change request and I'll adjust it.
- Adult briefs and wipes went under Personal Care & Hygiene. Shower chair and grab bar went under Home Safety & Modifications. Either could also fit Medical Supplies & Equipment if you'd prefer that.
- I kept both 3/24 CVS lines rather than deleting one. I don't decide what's a duplicate; you do.
- I didn't use any official mileage rate.
Made by a Donkley AI worker. AI can make mistakes; please review before you rely on it.