CheapBankConvertCheapBankConvert home

Caregiver Expense Log Built From Bank Statements

By CheapBankConvertPublished October 17, 2026

A caregiver expense log is a dated list of every cost you pay while caring for someone, with the amount, what it was for, whose money paid it and the receipt that backs it. Building it from bank statement rows keeps the amounts exact. A monthly total then tells siblings or a reimbursing program what is owed.

What should a caregiver expense log record?

A caregiver expense log should record, for each cost, the date, the payee, the amount, a short purpose, a category, whose money paid it and where the receipt is. Those seven columns answer every question a sibling, an executor or a tax preparer is likely to ask later. A log with fewer columns tends to need rebuilding.

The columns, and why each one earns its place:

  • Date, taken from the statement so it matches the bank record.
  • Payee, the pharmacy, care agency, taxi firm or store.
  • Amount, exact to the cent.
  • Purpose, such as "blood pressure tablets" or "taxi to cardiology".
  • Category, for totals: medical, transport, household, personal care, home repairs.
  • Paid from, either your account or the care recipient's account.
  • Receipt, a file name or "paper, March folder".

Mileage is the one cost with no statement row. Add it as its own line with the trip, the miles and the date, so the driving you do shows up next to the money you spend.

Pulling care costs from bank statements into the caregiver log

Care costs reach the caregiver log by going through each month's statement, marking every row that was for the person you care for, and copying those rows across. Statements catch the costs you forget, such as a pharmacy charge paid by card on a busy day. Doing it monthly keeps the job to under an hour.

Work through it like this:

  1. Download the month's statement for each account that paid for care.
  2. Mark each care-related row. A highlighter on a printout works; a filter in a spreadsheet works faster.
  3. Copy the marked rows into the log, with the date, payee and amount exactly as printed.
  4. Fill in purpose, category and receipt for each row while the month is fresh.
  5. Add rows with no statement line, such as mileage or cash spent at a market.

When statements arrive only as PDFs, retyping thirty rows is the slow step. CheapBankConvert, once it opens, will turn a statement into a CSV or Excel file for a single payment with nothing renewing, so the rows can be filtered and pasted instead (how it works).

Receipts to keep alongside a caregiver expense log

Keep receipts alongside a caregiver expense log whenever the statement row does not say what was bought. A pharmacy or supermarket charge could be medicine or shampoo, and only the receipt tells them apart. Keep receipts for anything over a set amount, for every medical cost, and for anything you will ask to be reimbursed.

Receipts matter most for:

  • Prescriptions and medical equipment, which may count toward a tax deduction.
  • Mixed shopping trips, where care items and your own items are on one bill.
  • Cash payments, which leave no statement row at all.
  • Home changes, such as grab rails or a ramp.

A phone photo saved under the date and payee is enough for most purposes. Name it to match the log, such as "2026-03-14-Pharmacy.jpg".

Medical costs can matter at tax time. IRS Publication 502 on medical and dental expenses says only the part of medical expenses above 7.5% of adjusted gross income is deductible on Schedule A, and it lets you include costs paid for someone who would have been your dependent except for certain income or filing tests. Whether that applies to you is a question for the tax return, and the tax document checklist lists what to bring to it.

How do you total a caregiver log for family reimbursement?

A caregiver log is totalled for family reimbursement by summing each month's rows by category and by who paid. The total paid from your own money is what family members or a reimbursing program may owe you. Send the summary with the month's rows behind it, so anyone can check a number against a receipt.

An example month, with example values

These figures are made up to show the layout.

Date Payee Purpose Category Paid from Amount
Mar 3 Example Pharmacy Monthly prescriptions Medical Mine $46.20
Mar 7 Example Taxi Ride to cardiology Transport Mine $28.00
Mar 10 Example Market Groceries for Mum Household Mum's account $84.15
Mar 14 Example Supply Co Shower chair Medical Mine $59.99
Mar 21 Example Care Agency Four hours respite care Personal care Mum's account $120.00
Mar 28 Mileage 42 miles, two appointments Transport Mine Logged, not priced

Monthly summary for the example: $134.19 paid from my account, $204.15 paid from Mum's account, plus 42 logged miles. If three siblings agreed to share costs equally, each owes a third of the $134.19 and a share of whatever rate the family set for mileage.

The format is close to a small organization's monthly report: money in, money out, and a balance anyone can check. The guide to writing a club treasurer report from the bank statement shows a layout that adapts well if several relatives contribute to a shared care fund.

Caregiver log mistake: mixing your money with the care recipient's

The caregiver log mistake that causes the most trouble is mixing your own money with the care recipient's, for example by paying their bills from your account and then repaying yourself in round sums. Months later no one can tell which payments were which. Keep "Paid from" accurate on every row, and repay yourself only against logged totals.

The safest setup uses separate accounts. Pay care costs from the care recipient's account when you have authority to do so, and record any cost you cover yourself as a separate line to be reimbursed. Never move their money into your account for convenience.

Clean separation matters beyond the family. If the person you care for later needs to move, a landlord or care home may ask for their statements, and the guide to bank statements for an apartment application shows what those reviewers look for. Statements full of transfers to a relative raise questions that a tidy log answers.

All posts in Statements for life's paperwork