Expense Report Template

Employees group receipts into expense reports, managers approve them, and the reimbursement due is worked out for you.

An expense report template is a ready-made record that groups an employee's business expenses for a trip or period, with a receipt for each item, and works out how much the company owes them after excluding company-paid items and any advance already given.

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

Finance

Tables

Reports, Expenses

Fields

25

Views

grid, kanban, calendar, form, dashboard

Updated

2026-11-19

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Reports

14 fields · 3 sample rows

  • All reports (Grid)
  • Approval board (Kanban)
ReportTextEmployeeTextEmailEmailDepartmentSingle selectPeriod StartDatePeriod EndDateStatusSingle selectApproverTextExpensesLink to another tableItemsCountTotal SpentRollupReimbursableRollupAdvance ReceivedCurrencyAmount DueFormula
Mumbai client visit – NovRohit Sinha[email protected]Sales7 Nov 202610 Nov 2026SubmittedPriya DesaiFlight BLR → BOM, Hotel – 3 nights, Client dinner (4 people), Cabs to office and airport4₹43,680.50₹36,840.50₹10,000.00₹26,840.50
Tech conference – BengaluruEmma Wilson[email protected]Engineering30 Oct 20261 Nov 2026ApprovedArvind RaoConference pass, Lunch during conference2₹12,860.00₹12,860.00₹12,860.00
Team offsite suppliesSneha Pillai[email protected]Operations14 Nov 202617 Nov 2026DraftPriya DesaiSticky notes, markers & chart paper1₹3,450.00₹3,450.00₹3,450.00
Field details
Report · Text
Employee · Text
Email · Email
Department · Single select
Sales, Engineering, Marketing, Operations
Period Start · Date
Period End · Date
Status · Single select
Draft, Submitted, Approved, Rejected, Reimbursed
Approver · Text
Expenses · Link to another table
Links to Expenses
Items · Count
Total Spent · Rollup
sum of Amount via Expenses
Reimbursable · Rollup
sum of Reimbursable Amount via Expenses
Advance Received · Currency
INR
Amount Due · Formula
{Reimbursable} - {Advance Received}

Expenses

11 fields · 7 sample rows

  • All expenses (Grid)
  • Calendar (Calendar)
  • Submit an expense (Form)
  • Spend analysis (Dashboard)
DescriptionTextReportLink to another tableDateDateCategorySingle selectMerchantTextAmountCurrencyPaid WithSingle selectReimbursable AmountFormulaBillable to ClientCheckboxReceiptAttachmentNotesLong text
Flight BLR → BOMMumbai client visit – Nov7 Nov 2026AirfareIndiGo₹6,840.00Corporate card₹0.00Yes
Hotel – 3 nightsMumbai client visit – Nov10 Nov 2026HotelTrident Nariman Point₹25,500.00Personal card₹25,500.00Yes
Client dinner (4 people)Mumbai client visit – Nov8 Nov 2026Client entertainmentBastian₹9,200.00Personal card₹9,200.00With Acme procurement team.
Cabs to office and airportMumbai client visit – Nov9 Nov 2026Local transportUber₹2,140.50UPI₹2,140.50
Conference passTech conference – Bengaluru30 Oct 2026OtherDevSummit₹12,000.00Personal card₹12,000.00
Lunch during conferenceTech conference – Bengaluru31 Oct 2026MealsTruffles₹860.00Cash₹860.00
Sticky notes, markers & chart paperTeam offsite supplies15 Nov 2026SuppliesStaples₹3,450.00UPI₹3,450.00
Field details
Description · Text
Report · Link to another table
Links to Reports
Date · Date
Category · Single select
Airfare, Hotel, Meals, Local transport, Mileage, Client entertainment, Supplies, Other
Merchant · Text
Amount · Currency
INR
Paid With · Single select
Personal card, Cash, UPI, Corporate card
Reimbursable Amount · Formula
IF({Paid With} = 'Corporate card', 0, {Amount})
Billable to Client · Checkbox
Receipt · Attachment
Notes · Long text

Form view “Submit an expense” asks for: Description, Report, Date, Category, Merchant, Amount, Paid With, Billable to Client, Receipt, Notes.

Why each part of the base is there

Reports: Employee, Period, Approver and Status

A report groups related expenses, for example one client visit, so they are approved and paid together. Status moves from Draft to Submitted, Approved or Rejected and finally Reimbursed, and the Approval board shows each report's place in that flow.

Items, Total Spent and Reimbursable

Items counts the linked expenses, Total Spent sums every amount, and Reimbursable sums only what the employee paid themselves. Seeing both side by side shows how much of a trip was paid by the company directly.

Advance Received and Amount Due

If the employee was given cash or a transfer before travelling, record it as Advance Received. Amount Due is Reimbursable minus the advance, which is the figure finance actually pays.

Expenses: Category, Merchant and Amount

Category and merchant make spending easy to analyse on the Spend analysis dashboard, for example hotel spend by month, and help approvers check items against policy.

Paid With and Reimbursable Amount

Paid With is Personal card, Cash, UPI or Corporate card. The formula sets the reimbursable amount to zero for corporate card items, because the company has already paid them, and to the full amount otherwise.

Billable to Client, Receipt and Notes

The checkbox marks costs you will recharge to a client, so they can be filtered when you invoice. The receipt attachment keeps the proof with the line, and notes explain anything unusual, such as who attended a client dinner.

About the Expense Report Template template

This expense report template has two linked tables. Reports holds one row per claim, such as a client visit or a conference, with the employee, email, department, period start and end, the approver and a status that runs Draft, Submitted, Approved, Rejected and Reimbursed. Each report counts its expense items, totals the amount spent and the reimbursable amount, and subtracts any advance received to give the amount due. Expenses holds each item with its description, report, date, category (airfare, hotel, meals, local transport, mileage, client entertainment, supplies or other), merchant, amount in rupees, how it was paid, a billable-to-client checkbox, the receipt and notes. A formula sets the reimbursable amount to zero for items paid on a corporate card. Views include an approval board, an expenses calendar, a spend analysis dashboard and a Submit an expense form.

Who it is for

It is for small and mid-sized companies, agencies, consultancies and sales teams that reimburse travel and client expenses but have no expense software, and currently collect receipts on WhatsApp and totals in Excel. Payment methods include UPI, cash, personal card and corporate card, which reflects how Indian employees typically pay on the road. Finance teams can use the status board to see what is waiting for approval and what is approved but not yet paid.

How to use it

  1. 1

    Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.

  2. 2

    Edit the Department, Category and Paid With options to match your expense policy, and delete the sample reports and expenses.

  3. 3

    For each trip or month, create a report in Reports with the employee, period and approver, and record any advance received.

  4. 4

    Share the Submit an expense form with employees: they add one receipt at a time, choose the report it belongs to and attach a photo of the receipt.

  5. 5

    Approvers move reports across the Approval board from Submitted to Approved or Rejected, and finance marks them Reimbursed once the amount due has been paid.

Connected templates in other Edesy apps

Expense Report Template: frequently asked questions

Each expense paid by personal card, cash or UPI counts in full as reimbursable; corporate card items count as zero. The report sums the reimbursable amounts and subtracts the Advance Received to give the Amount Due.

Yes. The Receipt field is an attachment field, and it is part of the Submit an expense form, so employees can upload a photo or PDF of the bill when they add the item.

Open the Approval board, which groups reports by Status, and drag a report from Submitted to Approved or Rejected. Give approvers an editor role in the workspace so they can change the status.

Yes. Tick Billable to Client on the expense. Filter the Expenses table by that checkbox and the client or report to get the list you need when raising your invoice, and export it to Excel if needed.

No. Mileage is a category, and the amount is entered by the employee. To calculate it, add a distance field and a formula that multiplies it by your per-kilometre rate.

Yes, with an automation triggered when a report is updated and matches Status is Approved. It can post a message to a connected Slack channel or call a webhook to your accounting process.

About the app

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