⚡ QuickScan: Know exactly which workflows to automate in 2 weeks. Start your QuickScan →
Sapnity logo
CROSS-INDUSTRY · FINANCE & OPERATIONS

T&E Approval Automation — Policy-Governed Travel & Expenses

Sapnity implemented a governed Travel & Expense (T&E) approval engine on Power Platform, layered on top of SAP/D365. Approvers now see policy scores, budget impact and exceptions in one view — and finance teams get clean posting back into ERP without chasing email threads.

Core Platforms: Power Apps, Power Automate, Dataverse, SAP / D365, Outlook · Region: Global shared services · Complexity: Medium–High
T&E Automation Policy Engine SAP / D365 Integration Shared Services
10-Day Sprint
One-Workflow Automation Sprint

Take one broken T&E flow (travel request, advance, or claim) and ship a production-ready app in ~10 days.

View 10-day sprint →
2-Week Scan
SAP/D365 QuickScan Assessment

Identify where approvals, policy checks and finance postings leak effort across your SAP/D365 landscape.

Start QuickScan →
3-Week Pack
Power Platform Starter Pack

Stand up a reusable approval engine pattern that can be cloned for T&E, vendor, CAPEX and HR requests.

Explore Starter Pack →

1. Business Problem — Approvals Lost in Email

Finance and Shared Services were spending too much time chasing managers for approvals and clarifications. Travel and expense data existed in SAP/D365 — but the approval story lived in Outlook.

  • Travel requests raised over email or legacy portal; every BU had its own template.
  • Managers approved “Looks fine” without seeing policy impact or budget consumption.
  • Finance teams re-typed approved amounts into ERP, often with missing cost centers.
  • Policy exceptions (non-preferred hotels, last-minute flights) surfaced only during audits.
  • Month-end close was delayed by late submissions and unclear approval trails.

T&E was viewed as an “admin chore” instead of a governed, insight-rich process that protects margin.

Before — What Finance Saw at Month-End

Inbox reality: 400+ unread T&E-related emails, each in a different format.

Compliance reality: No quick way to answer “Which policy breaches got approved and why?”

Operational reality: Approvers escalated “just approve it” under time pressure — with no data.

2. Sapnity’s Mandate

Leadership gave Sapnity a clear brief:

  • Design a policy-governed T&E experience that feels lighter than email, not heavier.
  • Give approvers a single screen with purpose: policy score, budget impact, key exceptions.
  • Ensure every approved item lands in SAP/D365 with the right cost center, GL and tax code.
  • Reduce back-and-forth with finance by turning policy rules into checklists, not PDFs.
  • Build a reusable approval engine pattern that can later power vendor and CAPEX workflows.

3. Before — Approval Story Hidden in Threads

We followed one T&E request from initiation to posting. The story looked like this:

  • Employee forwarded old email chain and attached an Excel template “from last year”.
  • Manager replied “Approved” but missed that the flight class breached policy.
  • Travel desk booked tickets in a separate system and updated a shared spreadsheet.
  • Employee submitted expenses weeks later, referencing a different cost center.
  • Finance had to reconcile three sources and call the BU controller for clarification.

Every exception required a human to remember policy, interpret context and take a risk. Nothing about this flow was scalable, auditable or analytics-ready.

Where the Process Leaked Value

✔ Policy breaches approved without visibility to alternatives or impact.

✔ Duplicate and late claims pushed costs into the wrong period.

✔ No central view of which BUs or managers drove the highest exception rates.

4. After — Sapnity T&E Approval Engine

Sapnity didn’t just digitize a form. We implemented a T&E approval engine that elevates every decision with context, policy rules and finance-ready data.

T&E APPROVAL AUTOMATION PATTERN

Employees & Managers

Submit and approve requests from Teams, mobile or web — one consistent flow.

1

T&E Request App

Guided capture of trip purpose, policy category, cost centers and estimated spend.

2

Policy & Budget Engine

Rule tables calculate policy score, exceptions, and BU budget impact in real time.

3

Approval Workflow Orchestrator

Routes single or multi-level approvals, SLAs, reminders and escalation logic.

4

Dataverse T&E Model

Requests, approvals, exceptions and allocation details with full audit trail.

5

SAP / D365 Posting

Clean, validated lines for expenses, advances and recoveries into ERP.

6

T&E Insights Cockpit

Exception rates, policy score trends and BU-level spend KPIs in Power BI.

This pattern now underpins not only T&E, but also CAPEX approvals and vendor onboarding for the same client — one approval brain, many workflows.

5. Implementation Story — From Email Threads to Policy Scores

Phase 1 — Shadowing & Policy Discovery

  • Shadowed Shared Services to map real-life exception patterns, not just written policy.
  • Identified top 10 reasons why requests bounced between BU, approver and finance.
  • Translated policy PDFs into rule tables with clear conditions and outcomes.

Phase 2 — T&E Request & Approval Apps

  • Built a model-driven app for finance and a clean canvas-style request form for employees.
  • Designed manager view showing policy score, spend-to-budget and key exception flags.
  • Embedded comments, attachments and audit timeline for each decision.

Phase 3 — Policy Engine & Orchestration

  • Implemented a rule-based scoring engine in Dataverse and Power Automate.
  • Configured dynamic approval paths (single, dual, or finance review) based on score.
  • Introduced SLA tracking, reminders and escalation to BU heads for stuck items.

Phase 4 — SAP / D365 Integration

  • Mapped cost centers, GL codes and tax logic between Dataverse and ERP.
  • Ensured only validated, approved lines could be posted to SAP/D365.
  • Created reconciliation views so finance could see request → approval → posting in one place.

Phase 5 — Rollout, Governance & Extensions

  • Rolled out to two pilot BUs, then scaled to global Shared Services within a quarter.
  • Set up monthly governance to adjust policy rules without code changes.
  • Extended the pattern to CAPEX approvals and vendor onboarding with minimal rework.

6. Technical Architecture — Approval Engine Pattern

Experience Layer Power Apps (model-driven + lightweight canvas) for employees, managers and finance — surfaced in Teams, browser and mobile.
Teams Mobile-ready Role-based views
Policy & Workflow Layer Power Automate flows executing rule tables, SLAs, exception routing and escalation logic.
Rule tables Multi-level approval
Data & Audit Layer Dataverse tables for requests, lines, approvals, exceptions and attachments, with full row-level security and audit history.
Audit-ready RLS
ERP & Analytics Layer SAP/D365 connectors for postings; Power BI datasets for spend analytics and policy adherence dashboards.
SAP / D365 Power BI

7. Outcomes & KPIs

KPI Before After Sapnity
Average T&E approval time 5–7 days across BUs 24–48 hours for 80% of requests
Policy exception visibility Manual sampling during audits Real-time dashboard by BU, manager & category
Finance rework on postings Frequent chasing for cost centers / clarifications ↓ 60% fewer queries to BUs at month-end
Stuck / overdue approvals Hidden in email, discovered late Tracked with SLAs and escalations to BU heads
Time to onboard new BU Weeks of template & training work Days — clone pattern, tweak rules, go live

For leadership, the biggest shift was cultural: approvals went from “click to clear inbox” to data-backed decisions with traceable rationale.

8. Sapnity Differentiators — Why This Worked

01 · PATTERN-FIRST
One Approval Brain, Many Workflows We didn’t build a one-off T&E app — we delivered an approval engine pattern that is now reused for CAPEX, vendor, HR and IT requests.
02 · POLICY IN MOTION
Rules as Live Assets, Not PDFs Policy logic lives in governed rule tables that finance can adjust, without raising IT change requests or breaking the app.
03 · ERP-CENTRIC DESIGN
Built Around SAP/D365, Not Beside It Every decision ends in clean lines posted to ERP — with cost centers, GL codes and tax logic aligned to finance reality, not generic forms.
04 · GOVERNED SCALE
ALM & Environment Strategy from Day One Dev/Test/Prod environments, managed solutions and deployment pipelines ensured that adding new BUs increased value — not technical debt.

Sapnity turned T&E from a noisy email problem into a governed approval fabric that finance, Shared Services and business leaders can all trust.