Google Sheets Expense Tracker with Reimbursement Column

A Google Sheets expense tracker with a reimbursement column gives your group one place to log shared costs, track who still owes what, and avoid double-counting. It does not replace the payment apps or banking tools you use to move money; it just keeps the record clean. Use these eight columns: Date, Description, Category, Total Amount, Paid By, Split Method, Amount Owed per Person, and Reimbursement Status.

Recommended Column Headers

Start a new sheet and place these headers in row 1. This structure keeps the original cost, the split rule, and the reimbursement status separate.

One expense per row is usually easiest to manage. If a bill is split unevenly, keep the split method in the same row so the sheet still shows how the amount was calculated.

Adding Dropdown Lists for Paid By and Status

Dropdowns help keep names and statuses consistent, which makes formulas easier to maintain.

To add them in Google Sheets:

1. Select the cells in the Paid By column.
2. Go to Data > Data validation.
3. Choose a dropdown rule and enter the names of the people in your group.
4. Repeat the same steps for Reimbursement Status with values like Pending and Settled.

The official Google Docs Editors Help page on creating in-cell dropdown lists is the best reference for the current steps.

Flagging Outstanding Balances with Simple Formulas

A simple IF formula can help flag rows that still need attention. For example, in a helper column called Outstanding, you could use:

=IF(H2="Pending","Yes","")

That returns "Yes" only when the reimbursement is still pending.

You can also use IF in the amount column if you want the sheet to calculate a share only when the split method matches a certain rule:

=IF(F2="Even",D2/3,"")

If you need a more flexible lookup later, VLOOKUP can be an option, but it is not required for a basic shared-expense tracker. For most small groups, a straightforward IF formula is enough to show what is still open.

Using Filter Views So Multiple People Can Check Status

Filter Views are useful when several people share the same sheet. One person can look only at open items while someone else keeps the full table visible.

To create one:

1. Go to Data > Filter views > Create new filter view.
2. Set the filter for Reimbursement Status to show only Pending items, or any other view you need.
3. Save the view with a clear name.

Filter views change only the current user's view and do not affect what other people see. Google also notes that filters do not change the data values in the spreadsheet. For more on that behavior, see manage data visibility with filters and this overview of filter views without affecting others.

Creating a Summary Tab to See Totals by Person

Add a second tab called Summary so you can see totals by person without scanning every row.

A simple layout is:

• Column A: person name
• Column B: total owed
• Column C: total settled, if you want a separate check

For example, if your expense data lives on a tab named Expenses, you can use a SUMIF formula in the Summary tab to total what each person is owed:

=SUMIF(Expenses!E:E,A2,Expenses!G:G)

That setup looks at the Paid By column and adds the matching values from Amount Owed per Person.

If you want to track settled items too, add another SUMIF that checks the status field. Keep the Summary tab simple and update it automatically with formulas rather than manual counting.

A good workflow is:

• enter each expense once
• pick names and statuses from dropdowns
• use IF to flag open balances
• use Filter Views to review only pending items
• check the Summary tab when it is time to settle up

This keeps the sheet useful for roommates, partners, trips, or small groups without making it more complicated than it needs to be.