Free template
Family Reimbursement Tracker Template
Use this free template to track money you pay for parents, siblings, relatives, shared family bills, subscriptions, groceries, online orders, pharmacy purchases, and repayments.
Family reimbursements are easy to lose track of because everyone usually means well, but the details live in texts, receipts, memory, and partial payments.
Includes an Excel workbook, CSV version, printable PDF, example rows, running balance formulas, and monthly review instructions.
Downloads
Download the family reimbursement tracker
Start with the Excel workbook if you want formulas and a summary. Use the CSV if you prefer to import the tracker into another tool. Use the printable PDF if you want a simple paper log.
Excel workbook
Best for Excel, Apple Numbers, and Google Sheets. Includes instructions, a blank tracker, example rows, summary formulas, dropdowns, and a monthly review sheet.
Download Excel workbook (.xlsx)CSV template
Use this if you want a simple import file for Excel, Numbers, Google Sheets, Airtable, Notion, or another spreadsheet tool.
Download CSV template (.csv)Printable PDF log
Use this if you prefer to write reimbursements by hand before moving them into a spreadsheet or app.
Download printable PDF log (.pdf)To use this in Google Sheets, download the Excel file, then upload it to Google Drive and open it with Google Sheets.
What to track
What this template helps you track
Parent bills
Internet, utilities, subscriptions, phone plans, and regular services you cover for a parent.
Family purchases
Groceries, household items, online orders, and everyday help that should be reimbursed later.
Pharmacy or care-related purchases
General pharmacy pickups, supplies, or care-related errands, with private details kept brief.
Sibling reimbursements
When one sibling pays for a family cost and another sibling reimburses their part later.
Partial repayments
When someone sends part of the amount, but not all, and the remaining balance needs to stay clear.
Recurring costs
Monthly bills, shared subscriptions, household services, or other family costs that come back again.
If your main situation is paying bills or purchases for an elderly parent, read the guide on how to track money you pay for elderly parents.
Example
Example family reimbursement log
Here is what a family reimbursement log can look like when someone pays several costs and receives a partial repayment later.
The key is to record repayments as their own rows. That way the remaining balance stays clear even when someone sends only part of what they owe.
| Date | Family member | Entry type | Category | What it was for | Expense amount | Repayment amount | Balance change | Running balance | Notes |
|---|---|---|---|---|---|---|---|---|---|
| May 1, 2026 | Mom | Expense paid for family | Utilities | Monthly internet bill | $48 | — | +$48 | $48 | Recurs monthly |
| May 3, 2026 | Dad | Expense paid for family | Pharmacy / care purchase | Pharmacy pickup | $23 | — | +$23 | $23 | Add receipt reference |
| May 5, 2026 | Mom | Expense paid for family | Online order | Household supplies | $37 | — | +$37 | $85 | Ordered online |
| May 8, 2026 | Mom | Repayment received | Repayment | Partial repayment | — | $40 | -$40 | $45 | Partial repayment |
| May 10, 2026 | Family shared | Expense paid for family | Subscription | Shared cloud storage | $12 | — | +$12 | $12 | Monthly subscription |
The important part is not only the original expense. It is also what was repaid, what is still open, and which family member the balance belongs to.
Workflow
How to use the template
- Add every family payment when it happens.
- Choose the family member or shared family group.
- Mark whether the row is an expense or repayment.
- Add the amount and a short note.
- Check the running balance before asking for repayment.
- Review the tracker weekly or monthly.
If the situation is sensitive, use the tracker as your private record first. You do not have to turn every small purchase into a conversation.
Columns
What each column means
Date
When the payment, repayment, or adjustment happened.
Family member
The parent, sibling, relative, or shared family group this balance belongs to.
Entry type
Use expense, repayment, or adjustment so the formula knows how to treat the row.
Category
The kind of cost: utilities, subscription, groceries, pharmacy / care purchase, online order, repayment, or other.
What it was for
A short plain-language description such as monthly internet bill or household supplies.
Paid by
Who paid or sent the repayment. This is helpful when siblings or partners are involved.
Expense amount
The amount you paid for a family member or shared family cost.
Repayment amount
The amount someone sent back. Add repayments as separate rows.
Balance change
Expenses increase the balance. Repayments reduce the balance.
Running balance
The running balance shows what is still open for that family member after each row.
Status
Mark whether the item needs reimbursement, is partly repaid, repaid, or should be reviewed later.
Review / due date
The date you want to review, settle, or gently follow up.
Receipt or reference
A receipt number, order name, bank transfer note, or simple reference.
Notes
Any calm context you may need later, without storing unnecessary sensitive details.
Monthly review
Monthly family reimbursement review
A monthly review keeps the conversation easier. Instead of sending several small reminders, you can check the tracker and send one calm summary.
Once the balance is clear, use the Polite Payback Reminder Generator if you need help turning it into a calm family-safe message. Prefer to copy a ready-made message? Browse repayment reminder text examples, including family and partial-repayment wording.
- Filter by family member.
- Check the remaining balance.
- Confirm which items were already repaid.
- Mark partial repayments clearly.
- Send one calm summary instead of several small reminders.
- Keep the history for next month.
When this becomes more than a family template
If the spreadsheet starts becoming hard to maintain, the Family Reimbursement Tracker shows how You Owe Me handles recurring bills, partial repayments, reminders, running balances, and clean summaries.
If the situation moves beyond family reimbursements into personal IOUs, ongoing payback, or broader money-owed records, see the app to track money owed.
See the family trackerWhen this template is enough
A spreadsheet is enough when the situation is simple, occasional, and easy to update. If you only need to divide one family purchase or trip cost, the Split Expense Calculator may be enough.
- You only help family occasionally.
- There are only a few payments.
- Repayments usually happen quickly.
- One person is tracking one simple balance.
- You are comfortable maintaining a spreadsheet manually.
When You Owe Me is better
A spreadsheet is a good starting point. But when family reimbursements keep changing, You Owe Me keeps the balance, repayment history, notes, recurring entries, reminders, and PDF statements organized in one place.
For the app workflow, see the Family Reimbursement Tracker. You can also review features like recurring entries, reminders, and PDF statements if you want the full app capability list.
- Family costs repeat every month.
- There are partial repayments.
- Several family members are involved.
- You need a clear history over time.
- You want reminders or money check-ins.
- You want professional PDF statements.
- You do not want to maintain spreadsheet formulas manually.
- The conversation is sensitive and you want the facts organized before you say anything.
Related resources
Related family money tools and guides
For more practical helpers, browse all Tools and templates.
FAQ
Frequently asked questions
What is a family reimbursement tracker?
A family reimbursement tracker is a simple record of money you paid on behalf of a parent, sibling, relative, or family group, plus repayments received and the remaining balance.
Can I use this template in Excel on Windows and Mac?
Yes. The .xlsx workbook is designed to open in Microsoft Excel on Windows and Mac. It can also be opened in Apple Numbers and uploaded to Google Sheets.
Can I use this in Google Sheets?
Yes. Download the Excel file, upload it to Google Drive, and open it with Google Sheets. If any formatting changes slightly, the main columns and formulas should still be understandable.
How do I track partial repayments from family?
Add the original expense as one row, then add the partial repayment as a separate repayment row. The running balance should show what is still open after the repayment.
What should I track when I pay bills for elderly parents?
Track the date, bill or purchase, amount, family member, repayment received, remaining balance, and any helpful note such as "monthly internet bill" or "online order."
When should I use an app instead of a spreadsheet?
Use an app when the balance changes often, repayments happen later, several people are involved, recurring bills repeat, or you want reminders, history, and clearer repayment conversations without maintaining a spreadsheet manually.
Keep the facts clear before the conversation gets hard
Family money gets messy because everyone means well, but the details are scattered. A simple tracker helps you separate the facts from the conversation.
The goal is not to make family money colder. The goal is to make it clearer.