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
Tables
Reports, Expenses
Fields
25
Views
grid, kanban, calendar, form, dashboard
Updated
2026-11-19
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.
14 fields · 3 sample rows
| ReportText | EmployeeText | EmailEmail | DepartmentSingle select | Period StartDate | Period EndDate | StatusSingle select | ApproverText | ExpensesLink to another table | ItemsCount | Total SpentRollup | ReimbursableRollup | Advance ReceivedCurrency | Amount DueFormula |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mumbai client visit – Nov | Rohit Sinha | [email protected] | Sales | 7 Nov 2026 | 10 Nov 2026 | Submitted | Priya Desai | Flight BLR → BOM, Hotel – 3 nights, Client dinner (4 people), Cabs to office and airport | 4 | ₹43,680.50 | ₹36,840.50 | ₹10,000.00 | ₹26,840.50 |
| Tech conference – Bengaluru | Emma Wilson | [email protected] | Engineering | 30 Oct 2026 | 1 Nov 2026 | Approved | Arvind Rao | Conference pass, Lunch during conference | 2 | ₹12,860.00 | ₹12,860.00 | ₹12,860.00 | |
| Team offsite supplies | Sneha Pillai | [email protected] | Operations | 14 Nov 2026 | 17 Nov 2026 | Draft | Priya Desai | Sticky notes, markers & chart paper | 1 | ₹3,450.00 | ₹3,450.00 | ₹3,450.00 |
11 fields · 7 sample rows
| DescriptionText | ReportLink to another table | DateDate | CategorySingle select | MerchantText | AmountCurrency | Paid WithSingle select | Reimbursable AmountFormula | Billable to ClientCheckbox | ReceiptAttachment | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|
| Flight BLR → BOM | Mumbai client visit – Nov | 7 Nov 2026 | Airfare | IndiGo | ₹6,840.00 | Corporate card | ₹0.00 | Yes | ||
| Hotel – 3 nights | Mumbai client visit – Nov | 10 Nov 2026 | Hotel | Trident Nariman Point | ₹25,500.00 | Personal card | ₹25,500.00 | Yes | ||
| Client dinner (4 people) | Mumbai client visit – Nov | 8 Nov 2026 | Client entertainment | Bastian | ₹9,200.00 | Personal card | ₹9,200.00 | With Acme procurement team. | ||
| Cabs to office and airport | Mumbai client visit – Nov | 9 Nov 2026 | Local transport | Uber | ₹2,140.50 | UPI | ₹2,140.50 | |||
| Conference pass | Tech conference – Bengaluru | 30 Oct 2026 | Other | DevSummit | ₹12,000.00 | Personal card | ₹12,000.00 | |||
| Lunch during conference | Tech conference – Bengaluru | 31 Oct 2026 | Meals | Truffles | ₹860.00 | Cash | ₹860.00 | |||
| Sticky notes, markers & chart paper | Team offsite supplies | 15 Nov 2026 | Supplies | Staples | ₹3,450.00 | UPI | ₹3,450.00 |
Form view “Submit an expense” asks for: Description, Report, Date, Category, Merchant, Amount, Paid With, Billable to Client, Receipt, Notes.
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 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.
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.
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 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.
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.
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.
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.
Click Use this template, sign in with your Edesy account, and click Use template in the preview to copy the base into your workspace.
Edit the Department, Category and Paid With options to match your expense policy, and delete the sample reports and expenses.
For each trip or month, create a report in Reports with the employee, period and approver, and record any advance received.
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.
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.
Use an expense report form to collect expense details consistently for approval and reimbursement. Ready for approvals: add approvers in Settings → Approvals after you create the form.
7 questionsEdesy FlowExpense ReportEmployees submit a period’s expenses as one report; the line manager approves, missing receipts need a signed exception from the finance manager, and receipts are filed in Google Drive.
8 steps · 3 rolesEdesy SignExpense Reimbursement Policy AcknowledgementEmployees confirm the rules for claiming business expenses: eligible costs, bills, GST invoices, timelines and false claims.
2 signer roles · 10 fieldsEdesy AgentsExpense Report AgentTurns quick messages into structured expense report entries — dates, numbers and notes — so records stay complete and consistent.
Report · 2 actionsEach 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.
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.
Track invoices from draft to paid with GST totals, partial payments and days overdue, plus outstanding balance per client.
2 tables · 26 fieldsBalance Sheet TemplateList every asset, liability and equity account with this and last period’s balances, and check that the books balance.
1 table · 10 fieldsBusiness Budget TemplatePlan annual budget lines by department, log real expenses against them and see year-to-date variance at a glance.
2 tables · 19 fieldsClassified Balance SheetClassify accounts into current and non-current groups and get working capital, current ratio and debt-to-equity per period automatically.
2 tables · 23 fieldsGrant Budget TemplateBuild funder-ready grant budgets with cost-share, justification and burn rate, and keep unallocated award money in view.
2 tables · 24 fieldsPetty Cash LogRecord every petty cash voucher and top-up with approvals and receipts, and see each cash box’s live balance and top-up alert.
2 tables · 23 fields