NEMT Trip Mileage Reconciliation Audit
Use this NEMT Trip Mileage Reconciliation Audit template to compare billed loaded miles against GPS shortest-route data, document variances, and catch recurring billing issues before payer audits.
Trusted by frontline teams 15 years of frontline software AI customization in seconds
Built for: Non Emergency Medical Transportation · Medicaid Transportation Brokerage · Healthcare Transportation Billing · Patient Mobility Services
Overview
This template is for auditing NEMT trip mileage by comparing billed loaded miles to GPS shortest-route data and the supporting trip record. It walks the reviewer through trip identification, mileage reconciliation, GPS data quality, exception pattern detection, and corrective action closeout so each trip has a clear audit trail.
Use it when you need to verify that a claim or encounter record reflects the miles actually supported by dispatch and GPS evidence, especially when payer policy allows only limited variance or requires specific rounding, base-mile, or minimum-mile logic. It is also useful for identifying repeat issues by driver, vehicle, route, or facility before they turn into denials, recoupments, or broker findings.
Do not use this template as a substitute for payer policy or as a general trip quality checklist. If the trip lacks a unique trip ID, claim link, origin/destination, or usable GPS trace, the audit should be marked incomplete rather than forced to a conclusion. It is also not the right tool for clinical transport documentation, vehicle maintenance review, or dispatch performance alone; its purpose is mileage reconciliation and exception control. When the trip record is incomplete, the template helps you document the deficiency, assign follow-up, and keep the variance from being treated as a clean match.
Standards & compliance context
- This template supports documentation practices commonly expected under Medicaid transportation program rules, broker oversight, and payer post-payment audit processes.
- Mileage reconciliation and exception tracking align with general healthcare billing control expectations and quality management practices used in ISO 9001-style audit systems.
- If your organization operates under state Medicaid transportation guidance or broker contract terms, configure the template to match the required mileage method, tolerance, and supporting documents.
- When GPS data is used as audit evidence, retain the route trace, timestamps, and variance rationale so the record can be defended during a payer review or recoupment dispute.
General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.
What's inside this template
Audit Scope and Trip Identification
This section confirms you are reviewing the right trip, tied to the right claim, with enough source data to make the mileage comparison valid.
- Trip record includes unique trip ID, date of service, member identifier, origin, destination, and vehicle/driver assignment
- Trip is within the audit period and matches the selected claim or encounter record
- Trip type is correctly classified as loaded miles, deadhead miles, or wait time per payer policy
- Supporting source documents are available for review
Billed Mileage vs GPS Route Reconciliation
This section is the core of the audit because it compares what was billed to what the GPS route supports under the payer's mileage rules.
-
Billed loaded miles match GPS shortest-route miles within payer tolerance
Enter the absolute variance in miles between billed loaded miles and GPS shortest-route miles.
- Billed loaded miles entered on the claim
- GPS shortest-route miles calculated for the same origin and destination
- Variance reason is documented and supported by the trip record
- Mileage rounding, minimum-mile rules, or base-mile rules were applied consistently with payer policy
Trip Integrity and GPS Data Quality
This section checks whether the GPS evidence is reliable enough to support the mileage conclusion and whether any data gaps need explanation.
- GPS breadcrumb or route trace shows continuous trip coverage from pickup to drop-off
- Pickup and drop-off timestamps align with dispatch and trip completion records
- GPS data quality is sufficient to support route validation
- Any GPS gaps, device resets, or signal loss events are documented
Exception Review and Pattern Detection
This section turns single-trip variances into actionable trends by showing whether the same issue is repeating across drivers, vehicles, routes, or facilities.
- Trip variance exceeds internal exception threshold
- Similar mileage variances are recurring for the same driver, vehicle, route, or facility
- Exception pattern is categorized for follow-up
- Potential overbilling or underbilling impact is estimated
Corrective Action, Closeout, and Sign-Off
This section ensures every discrepancy has an owner, a root cause, and a documented resolution before the audit is closed.
- Corrective action assigned for any mileage discrepancy or documentation deficiency
- Root cause identified and documented
- Follow-up owner and due date assigned
- Inspector sign-off completed
How to use this template
- 1. Enter the trip ID, date of service, member identifier, origin, destination, and vehicle or driver assignment, then confirm the trip falls within the audit period and ties to the correct claim or encounter record.
- 2. Record the billed loaded miles, the GPS shortest-route miles, and the payer rule used for rounding, minimum miles, or base miles so the comparison is made under the correct policy.
- 3. Review the GPS breadcrumb or route trace for continuous coverage from pickup to drop-off and compare the timestamps against dispatch and trip completion records.
- 4. Document any variance reason, including detours, road closures, wait-time handling, device resets, or GPS signal loss, and mark whether the support is sufficient.
- 5. Flag trips that exceed the internal exception threshold, look for recurring patterns by driver, vehicle, route, or facility, and estimate the billing impact where appropriate.
- 6. Assign corrective action, root cause, owner, and due date, then complete sign-off only after the deficiency or discrepancy has been resolved or formally accepted.
Best practices
- Use the same mileage source and route logic for every trip in the audit period so reviewers do not mix shortest-route, actual-route, and map-estimate methods.
- Set an internal exception threshold that is tighter than the payer tolerance so recurring issues are caught before they become claim denials or recoupments.
- Photograph or export the GPS trace, dispatch record, and claim support at the time of review so the evidence set does not change after the audit is closed.
- Treat missing GPS coverage, device resets, and signal loss as documentation deficiencies that require explanation, not as automatic proof that billed miles are correct.
- Separate loaded miles from deadhead miles and wait time in the review so a trip is not marked compliant when the wrong mileage type was billed.
- Apply rounding, minimum-mile, and base-mile rules consistently across all trips and document the rule used on each record.
- Trend variances by driver, vehicle, facility, and route to find process problems such as repeated detours, dispatch errors, or systematic overbilling.
- Do not close the audit until the root cause and follow-up owner are recorded for every discrepancy that exceeds your threshold.
What this template typically catches
Issues teams running this template most often surface in practice:
Common use cases
Frequently asked questions
What trips should be included in this audit?
Use this template for completed NEMT trips that have a claim or encounter record, a trip ID, and enough source data to compare billed miles to GPS route data. It works best for trips billed on loaded miles, but it also helps when deadhead miles or wait time are part of the payer policy and need to be classified correctly. Exclude trips with missing core identifiers until the record can be tied back to the claim and dispatch file.
How often should mileage reconciliation be performed?
Most organizations run it on a daily, weekly, or monthly cadence depending on trip volume and payer risk. High-volume brokers or providers often review a sample of trips continuously and then do a fuller monthly reconciliation for exception trending. The right cadence is the one that catches recurring variance patterns before post-payment audits or denial cycles build up.
Who should run this audit?
This template is typically run by billing, compliance, operations, or quality staff who can access trip records, dispatch logs, and GPS traces. A reviewer should understand payer mileage rules, rounding practices, and the difference between loaded miles, deadhead miles, and wait time. If a variance suggests a systemic issue, operations and billing should both be involved in the follow-up.
Does this template align with payer and regulatory requirements?
Yes, it is designed to support documentation and internal control expectations commonly seen in Medicaid transportation programs, broker audits, and payer post-payment reviews. It also fits general compliance practices used in healthcare billing oversight and quality management. The template does not replace payer-specific policy, so mileage rules, tolerance thresholds, and documentation requirements should be configured to match the contract or state program.
What are the most common mistakes this audit catches?
Common findings include billed miles that do not match the shortest GPS route, inconsistent rounding or minimum-mile application, and missing explanations for detours or route changes. It also catches GPS gaps, device resets, and trips where pickup or drop-off times do not line up with dispatch records. Repeated variances tied to one driver, vehicle, or facility are another frequent pattern.
How should variance thresholds be set?
Set an internal exception threshold that reflects payer tolerance, your billing rules, and the level of risk you want to manage. Many teams use a tighter internal threshold than the payer’s allowed variance so they can investigate patterns before they become claims issues. The threshold should be documented in the template and applied consistently across all trips in the audit period.
Can this template be customized for different payers or brokers?
Yes, and it should be. Different payers may use different mileage rounding rules, base-mile logic, minimum-mile rules, or documentation standards for variance justification. Add payer-specific fields, tolerance limits, and exception categories so reviewers can apply the correct policy without relying on memory.
How does this compare with manual spot-checking in spreadsheets?
Manual spot-checking often misses recurring patterns because it focuses on individual trips instead of the underlying cause. This template forces a consistent review of trip identity, billed miles, GPS route evidence, and exception follow-up, which makes it easier to defend decisions during an audit. It also creates a repeatable closeout trail instead of scattered notes across email or spreadsheets.
What systems should this audit connect to?
It is most useful when connected to dispatch, claims, GPS, and document storage systems so reviewers can pull the trip record, route trace, and supporting notes in one place. If your workflow uses a broker portal or billing platform, map the template fields to those records to reduce rekeying. Integrations are especially helpful when you need to trend exceptions by driver, vehicle, route, or facility.
Related templates
Go deeper on the topic
-
Predictive scheduling laws — also called fair workweek laws or secure scheduling — require employers in covered industries to publish employee schedules...
-
Overtime calculation is the process of applying federal, state, local, and contractual rules to hours worked to determine the correct pay — including...
-
A near-miss is an event that could have caused injury or damage but didn't — a slip that didn't fall, a load that shifted but didn't drop, a machine that...
-
Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
-
Discover 4 proven keys to successful project management and team collaboration — from transparent goal-setting to real-time communication and workflow...
-
Boost team collaboration with modern tools that improve visibility, accountability, and communication for stronger project outcomes.
-
Compare the best employee apps of 2026—MangoApps, Blink, WorkJam, Flip, and more—to find the right fit for your frontline workforce.
-
Discover why an employee text alert system is essential for frontline safety, faster emergency response, and two-way communication across your entire workforce.
Ready to use this template?
Get started with MangoApps and use NEMT Trip Mileage Reconciliation Audit with your team — pricing built for small business.