All templates

Automated Ramp Mileage Reimbursement Review

Every Monday, WebRun opens Ramp, pulls all mileage reimbursement requests submitted in the past week, checks each against your configured IRS reimbursement rate and maximum per-trip mile thresholds, logs all submissions in a Google Sheet, and posts a ranked approval list to Slack so managers can review and approve in one session.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Ramp pull pending mileage reimbursement submissions
2 Google Sheets log all submissions with plausibility check results
3 Slack post approval list to managers
In short

How do I automatically review Ramp mileage reimbursement requests each week?

WebRun pulls all pending Ramp mileage reimbursement submissions each Monday, checks each against your IRS rate and per-trip mileage cap, logs every result in Google Sheets, and posts a clean versus flagged approval list to Slack. Managers review and approve in one session instead of hunting through individual claims.

  • All mileage claims reviewed against IRS rate and mileage caps before approval
  • Managers approve a week of claims in one Slack session
  • Google Sheet builds a full audit trail of mileage reimbursements

Built for finance managers · HR teams · operations leads · controllers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.ramp.com/expenses in a real browser with your saved login - no setup, no API keys.

  2. 1
    Ramp - pull pending mileage reimbursement submissions
    ramp.com
    WebRun in Ramp: pull pending mileage reimbursement submissions
    WebRun opens Ramp to pull pending mileage reimbursement submissions.
    • Open Ramp and navigate to Expenses, filter to mileage reimbursement submissions pending approval
    • Record employee name, submission date, trip description, miles claimed, and reimbursement amount for each
    • Check each claim against your configured IRS rate and per-trip mile maximum
    • Flag claims that exceed the per-trip maximum or use an incorrect rate for review

    Done when All pending mileage claims are listed with plausibility-check results and flags noted.

  3. 2
    Google Sheets - log all submissions with plausibility check results
    google.com
    WebRun in Google Sheets: log all submissions with plausibility check results
    WebRun opens Google Sheets to log all submissions with plausibility check results.
    • Open the Mileage Reimbursement Log sheet (or create it on first run)
    • Append a row for each submission with employee, date, miles, amount, and check result
    • Mark flagged items in red for easy visual identification by managers

    Done when Sheet has this week's mileage submissions logged with plausibility check results.

  4. 3
    Slack - post approval list to managers
    slack.com
    WebRun in Slack: post approval list to managers
    WebRun opens Slack to post approval list to managers.
    • Post the week's mileage approval list to the manager Slack channel, clean claims first, flagged items at the bottom
    • Include employee, miles, amount, and flag reason for each item

    Done when Managers have this week's mileage approval list in Slack, clean and flagged items separated.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.ramp.com/expenses
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Mileage review list · Slack
OutputWhat each run produces - A Google Sheet mileage reimbursement log with plausibility check results, plus a weekly Slack approval list separating clean claims from flagged ones.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does WebRun approve or pay mileage claims automatically?

No. WebRun checks and lists the claims for human review. All approvals and reimbursements are made by a manager in Ramp. No payment is triggered without a human decision.

How does it check plausibility?

It applies your configured IRS reimbursement rate and a per-trip maximum mileage threshold. Claims outside those parameters are flagged in the list. You set the rules once during setup.

Can it handle submissions from multiple offices or regions?

Yes. All pending mileage submissions in Ramp are included regardless of employee location or department, so managers see the full company-wide week in one list.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.