Employee expense policy check
“check expense reports against policy limits by category and flag ones over limit or missing a receipt”
Check Expensify expense export against Expense policy limits by category and flag ones over limit or missing a receipt.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileExpensify expense exportCSV export · 16 rows
- FileExpense policy limitsCSV export · 7 rows
- StepMake expense match keysStep 1
- StepMake policy match keysStep 2
- JoinAdd policy limits16 of 16 paired
- StepFlag policy exceptionsStep 4
- ResultExpense Policy Flags16 rows · 16 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out, and the join paired 16 of 16 rows.
- Download Expensify expense export sample (16 rows)Expensify: Expenses > Export > CSV
- Download Expense policy limits sample (7 rows)Finance team spreadsheet: Policy Limits tab > Download CSV
What you get back
The result of that run, the rows to look at first.
| Employee | Report | Date | Merchant | Expense category | Status | Expense amount (USD) | Policy limit (USD) | Receipt | Receipt required |
|---|---|---|---|---|---|---|---|---|---|
| Hannah Lee | Customer Summit | 2026-10-24 | Starbucks | Meals | Missing receipt | 12.80 | 45 | Missing | Receipt required |
| Noah Turner | Trade Show Prep | 2026-11-06 | Amazon | Office supplies | Missing receipt | 73.44 | 75 | Missing | Receipt required |
| Grace Kim | Field Ops | 2026-10-17 | Staples | Office supplies | Over limit | 88.90 | 75 | Attached | Receipt required |
| Marco Silva | Customer Summit | 2026-10-22 | United Airlines | Airfare | Over limit | 514 | 500 | Attached | Receipt required |
| Maya Singh | Renewal Trip | 2026-11-01 | Uber | Ground transport | Over limit | 63.25 | 60 | Not required | Not receipt required |
| Jules Martin | Partner Dinner | 2026-11-08 | Olive Garden | Meals | Over limit | 46.50 | 45 | Attached | Receipt required |
| Ava Chen | Q4 Sales Kickoff | 2026-09-18 | Delta Air Lines | Airfare | Within policy | 462.18 | 500 | Attached | Receipt required |
| Marcus Reed | Q4 Sales Kickoff | 2026-09-22 | Hilton Garden Inn | Hotel | Within policy | 238.40 | 250 | Attached | Receipt required |
| Nina Patel | Client Launch Week | 2026-09-29 | Uber | Ground transport | Within policy | 34.75 | 60 | Not required | Not receipt required |
| Jonah Brooks | Client Launch Week | 2026-10-02 | Staples | Office supplies | Within policy | 41.62 | 75 | Attached | Receipt required |
| Lena Ortiz | Product Workshop | 2026-10-08 | Marriott | Hotel | Within policy | 198.55 | 250 | Attached | Receipt required |
| Priya Nair | Product Workshop | 2026-10-10 | Lyft | Ground transport | Within policy | 58.20 | 60 | Not required | Not receipt required |
How do you check expense policy compliance?
Export your expense report from Expensify, then load it into the workflow with your policy limits by category. The workflow matches each expense to the right rule, flags anything over limit, and marks expenses with no receipt. On the sample, it returned 10 within policy, 4 over limit, and 2 missing receipt.
How it works
How to use the Expense Policy Flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Expense Policy Flags: questions
What export should you use?
What happens to expenses that do not match a policy rule?
How do you change the policy rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match two sets of records line by line, and see what agrees, what differs and what is missing on either side.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Payment processing fees by methodTrack payment processing fees by method each month, total sales and fees, and flag fee rates that are too high.See the workflow Built by the agent
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the workflow Template