Skip to content
Employee Reimbursement Tracker cover: a sample sheet with claims logged, total claimed and approved, not paid and a bar chart, beside the Dashboard tab

Employee Reimbursement Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This tracker suits finance and office staff who handle expense claims for a small team. The Claims tab records each claim with its ID, employee, submitted date, category, amount, status and notes. The Dashboard shows the total claimed, the amount approved but not yet paid and the amount paid out, then splits the claims by employee and by status with charts.

Set up the employee names and categories in the dropdown lists on the Claims tab before you start, so every claim matches a name in the breakdown. Move a claim from Submitted to Approved and then to Paid as the process moves along. Rejected claims show in red, which makes them easy to follow up with the employee. Keep one file per year so the list stays easy to read.

Useful for

  • Tracking claims from submission to payment
  • Showing staff how much is still waiting for payment
  • Checking a team's claims before month end

What's included

  • 3 tabs: Dashboard, Claims, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Claims: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Claims tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Can I add an approval limit to claims?

This template does not enforce limits, but you can add a column for the limit and a check that compares each amount with it. Policies vary, so compare every claim with your company rules before you approve it.

What do the statuses mean?

Submitted means the employee has sent the claim and it is waiting for review. Approved means it has passed review but is not yet paid. Paid means the money has gone out, and Rejected means the claim was turned down.

How do I see totals for one employee?

Look at the employee breakdown on the Dashboard. Each row shows the amount claimed, the amount paid and the amount still awaiting payment for that person. Filter the Claims tab by name to list their individual claims.

  • #expense-tracker
  • #reimbursement-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…