Expense Reimbursement Spreadsheet

Employees submit out-of-pocket expenses with receipts; finance approves, pays and sees spend by category and person.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Human Resources

Tables

Expense claims

Fields

16

Views

grid, kanban, form, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Expense claims

16 fields · 6 sample rows

  • All claims (Grid)
  • Approval board (Kanban)
  • By employee (Grid)
  • Submit an expense (Form)
  • Spend (Dashboard)
DescriptionTextClaim #AutonumberEmployeeTextDepartmentSingle selectExpense dateDateCategorySingle selectMerchantTextAmountCurrencyBillable to clientCheckboxReceiptAttachmentStatusSingle selectApproverTextPaid onDateOutstandingFormulaDays to reimburseFormulaNotesLong text
Flight BLR → DEL for client workshopEXP-0001James WhitfieldSales1 Nov 2026TravelIndiGo₹8,450.00YesPaidNeha Kapoor13 Nov 2026₹012
Hotel, 2 nightsEXP-0002James WhitfieldSales2 Nov 2026LodgingTaj Palace₹15,600.00YesApprovedNeha Kapoor₹15,600
Team dinner after launchEXP-0003Lucas FernandesMarketing14 Nov 2026MealsToit Brewpub₹6,320.00Submitted₹0
Figma annual seatEXP-0004Aditi KulkarniEngineering10 Nov 2026SoftwareFigma₹12,800.00ApprovedVikram Rao₹12,800
Cab to vendor site (42 km)EXP-0005Farhan QureshiOperations16 Nov 2026MileageUber₹740.00Submitted₹0
Personal gym membershipEXP-0006Tom BeckerSupport7 Nov 2026Office suppliesCult.fit₹2,500.00RejectedKavya Reddy₹0Not covered by the expense policy.
Field details
Description · Text
Claim # · Autonumber
Employee · Text
Department · Single select
Engineering, Sales, Marketing, Operations, Finance, People, Support
Expense date · Date
Category · Single select
Travel, Lodging, Meals, Mileage, Client entertainment, Software, Office supplies
Merchant · Text
Amount · Currency
INR
Billable to client · Checkbox
Receipt · Attachment
Status · Single select
Submitted, Approved, Rejected, Paid
Approver · Text
Paid on · Date
Outstanding · Formula
IF({Status} = 'Approved', {Amount}, 0)
Days to reimburse · Formula
IF(AND({Paid on}, {Expense date}), DATETIME_DIFF({Paid on}, {Expense date}, 'days'), BLANK())
Notes · Long text

Form view “Submit an expense” asks for: Description, Employee, Department, Expense date, Category, Merchant, Amount, Billable to client, Receipt, Notes.

Expense Reimbursement Spreadsheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates