How to Create Expense Analytics in an ERP: A Spend Dashboard Finance Will Actually Read
For finance controllers and CFOs of Indian SMEs: see where travel and claims money goes, who is waiting on whom, and what is still owed to employees.
If you are working out how to create expense analytics, you probably already have a monthly expense export. It lists every claim, and it answers almost nothing: which team spent most on hotels, which approver sits on claims for a fortnight, how much is approved but still unpaid.
The usual fix is a pivot table built on the fifth of every month. It is out of date by the tenth, it breaks when a category is renamed, and it never includes the claims still stuck in approval.
This guide covers what to measure, an illustrative quarter at a Chennai engineering services firm, and how Apragya's travel and expense app builds the dashboard from live claims.
How to create expense analytics, step by step
Expense analytics answers three questions: where the money goes, how fast claims move, and what is still owed. To answer them, every claim line needs a category, a date, an employee and, where it applies, a project. Without those tags, no dashboard can split spend meaningfully.
Next, measure the process as well as the money. Count claims at each stage, the age of the oldest one in each, and the time each approver takes. Delays are usually the first thing employees notice and the last thing finance measures.
Finally, separate approved from paid. An approved claim is a liability until it is reimbursed, and it belongs on the dashboard until then.
- Fix a short list of expense categories.
- Require a project on claims for client or site work.
- Report spend by category, employee, project and month.
- Track claims by stage and the age of the oldest one.
- Measure turnaround per approver.
- Show approved but unpaid claims separately.
- Review the dashboard monthly with department heads.
What a monthly pivot table misses
Slow approvers
Nobody sees that one manager holds claims for three weeks.
Money owed
Approved but unpaid claims do not appear on any report.
Project spend
Travel for a client project is buried in a general expense line.
Tax on expenses
GST on eligible claims is never totalled for the accounts team.
An example: a quarter at a Chennai engineering services firm
Take an illustrative 220-person engineering services firm in Chennai with site teams travelling to plants across Tamil Nadu and Karnataka. The CFO wanted to know why travel cost had risen and why engineers complained about late reimbursement.
From question to answer in one dashboard
Pick the quarter
Date range set to July to September.
Spend by category
Hotels up sharply against last quarter.
Spend by project
Most of the rise on two plant projects.
Approval delays
One approver averaging far longer than peers.
Payment pipeline
Approved claims waiting for the next run.
The hotel rise came from two long commissioning jobs, which the project managers had already budgeted, so no policy change was needed. The late payments came from one approver on leave with no delegate. Finance added a delegate, and the waiting claims cleared in the next run.
How to create a travel expense dashboard in Apragya
Step 1 of 6
Headline figures
Reports by stage, approved spend, pending payment and average turnaround.
- Headline figures: Reports by stage, approved spend, pending payment and average turnaround.
- Breakdowns: Spend by category, employee, project and month, over the range you choose.
- Approval queue: What is pending and how long each approver takes.
- Payment pipeline: Each stage shaded by the age of its oldest claim.
- Tax on expenses: Tax on approved expense lines, totalled by tax code.
- Agency bills: Travel agency invoices by status and age.
Employee spend analysis: spreadsheet, BI tool or ERP
A BI tool can draw any chart, but someone has to feed it, map categories and refresh it. When the dashboard reads the same claims, trips and payment runs the approvers work on, the figures are current the moment a claim moves, and a number can be opened to the claim behind it.
Ways to analyse expenses, compared with Apragya
| Feature | Monthly export and pivot | Apragya expense analytics |
|---|---|---|
| Freshness | As of the last export | Current as claims move |
| Claims in approval | Not included | Shown with their age |
| Project view | Manual tagging | From trips and claims linked to a project |
| Approver delays | Not measured | Turnaround by approver |
| Employee view | Asked of finance | Own reports and waiting time |
Checked against public information on 16 September 2026.
What sets Apragya's expense tracking report for India apart
Same records
Charts read the claims, trips and runs people work on.
Self view
Employees see their own reports and how long each has waited.
Access by role
Wider figures appear only for the roles you allow.
Per company
Groups can read spend company by company.
Agents on claims
Agents can flag unusual lines for a person to review.
Copilot
Ask a plain question about spend and get pointed to the figures.
The figures come from claims set up as in how to create expense reports and paid through reimbursement runs. See the expense analytics feature and corporate cards.
Getting your first dashboard working
- Agree the expense categories finance wants to see.
- Link trips and claims to projects where the cost belongs.
- Set the date range to the last full quarter.
- Review approval turnaround with department heads.
- Check the payment pipeline before each run.
The first useful finding is usually a slow step, not an overspend.
What it costs to start
Creating expense analytics, answered
What period can the dashboard cover?
Can employees see analytics?
Can we see spend by project?
Are travel agency invoices included?
What does it cost to start?
See where the claims money goes
Open the spend dashboard on live claims and find the slow step first.