Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
How-to guide

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.

A finance controller sorting coloured expense slips into piles on a table

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.

  1. Fix a short list of expense categories.
  2. Require a project on claims for client or site work.
  3. Report spend by category, employee, project and month.
  4. Track claims by stage and the age of the oldest one.
  5. Measure turnaround per approver.
  6. Show approved but unpaid claims separately.
  7. 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

  1. Pick the quarter

    Date range set to July to September.

  2. Spend by category

    Hotels up sharply against last quarter.

  3. Spend by project

    Most of the rise on two plant projects.

  4. Approval delays

    One approver averaging far longer than peers.

  5. Payment pipeline

    Approved claims waiting for the next run.

The delay complaint traced to a single approval step, not to finance.

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.

A row of ribboned envelopes with one set apart under an hourglass
The waiting claims cleared once the absent approver had a delegate, in the very 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.

  1. Headline figures: Reports by stage, approved spend, pending payment and average turnaround.
  2. Breakdowns: Spend by category, employee, project and month, over the range you choose.
  3. Approval queue: What is pending and how long each approver takes.
  4. Payment pipeline: Each stage shaded by the age of its oldest claim.
  5. Tax on expenses: Tax on approved expense lines, totalled by tax code.
  6. 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

FeatureMonthly export and pivotApragya expense analytics
FreshnessAs of the last exportCurrent as claims move
Claims in approvalNot includedShown with their age
Project viewManual taggingFrom trips and claims linked to a project
Approver delaysNot measuredTurnaround by approver
Employee viewAsked of financeOwn 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

  1. Agree the expense categories finance wants to see.
  2. Link trips and claims to projects where the cost belongs.
  3. Set the date range to the last full quarter.
  4. Review approval turnaround with department heads.
  5. Check the payment pipeline before each run.

The first useful finding is usually a slow step, not an overspend.

What it costs to start

INR 7,999
Pro, a month
Up to 25 users, with Travel and Expense and every enterprise app
5,000
AI Credits a month
Included on Pro
Free
Up to 3 users
CRM and HR, to try the platform first

Creating expense analytics, answered

What period can the dashboard cover?
You pick the date range, up to a year at a time, and the monthly trend shows the last twelve months.
Can employees see analytics?
Employees get a self view of their own reports and waiting times. Wider figures depend on their role.
Can we see spend by project?
Yes. Trips and claims linked to a project appear in the project breakdown.
Are travel agency invoices included?
Yes. An agency view shows their invoices by status and age.
What does it cost to start?
Travel and Expense comes with the Pro plan, INR 7,999 a month for up to 25 users, which includes every enterprise app, 5,000 AI Credits a month, single sign-on and audit logs. The free plan covers up to 3 users with CRM, HR and Vendor Onboarding if you want to try the platform first.

See where the claims money goes

Open the spend dashboard on live claims and find the slow step first.