Paste expense claims and enter the limits from the client's own policy. The tool flags claims over a category limit, missing receipts, self-approval, duplicates and claims sitting just under an approval limit. Flags are questions to ask, not findings.
Paste from Excel or CSV. Columns are found by header names; if a name is not recognised the default position above is used.
Every limit here is yours. Take them from the client's expense policy. Tax treatment of expenses is a separate question; check the current rules.
| Claim | Date | Employee | Category | Amount | Flags |
|---|---|---|---|---|---|
| C-003 | 2026-09-06 | Rohit | Client gifts | 9,800.00 | Over category limit (5,000); No receipt at or above your receipt amount; Approved by the claimant; Just under your approval limit; Weekend expense date |
| C-004 | 2026-09-12 | Asha | Meals | 1,200.00 | No receipt at or above your receipt amount; Weekend expense date |
| C-007 | 2026-09-19 | Meena | Hotel | 9,950.00 | Just under your approval limit; Weekend expense date |
| C-001 | 2026-09-02 | Asha | Meals | 2,400.00 | Over category limit (1,500) |
| C-002 | 2026-09-05 | Meena | Travel | 18,500.00 | Weekend expense date |
| C-005 | 2026-09-14 | Kiran | Travel | 18,500.00 | Possible duplicate claim |
| C-006 | 2026-09-14 | Kiran | Travel | 18,500.00 | Possible duplicate claim |
One over-limit claim is a conversation. The same approver clearing many claims just under their limit, or people approving their own, is a control problem. Looking at the pattern across the whole listing shows which. Treat each flag as a reason to look at the receipt and the business purpose, and ask whether the policy is being applied or being worked around.
Each claim is read from your pasted rows. A claim is over limit when its amount is above the limit you entered for its category. A missing receipt is flagged when the amount is at or above the receipt amount you set.
Self-approval is flagged when the employee and approver names match. A claim is just under the approval limit when it is at or below that limit and within your band, in percent, of it. Possible duplicates share employee, category, date and amount.
A claim can trip several tests and the list is sorted with the most flags first.
An approval limit of 10,000 and a 5% band. A hotel claim for 9,950.
