When several orders land just under an approval limit, the limit isn't working.
A split purchase is one purchase broken into smaller orders or invoices so each stays below an approval limit. Test for it by grouping spend by requester and supplier within a short date window and flagging groups whose total exceeds the limit while each item stays below it. Review each flag, and treat repeated splitting as a control failure, not an admin error.
Sometimes it is deliberate fraud. More often it is someone avoiding a slow approval process. Either way the effect is the same: spend that should have had a senior approval, or a competitive quote, didn't.
Export orders or invoices with requester (A), supplier (B), date (C) and amount (D). Put the approval limit in a cell named Limit and the window in days in Window.
E: total for the same requester and supplier within the window
=SUMIFS($D$2:$D$5000,$A$2:$A$5000,A2,$B$2:$B$5000,B2,$C$2:$C$5000,">="&C2-Window,$C$2:$C$5000,"<="&C2+Window)
F: count in the same group
=COUNTIFS($A$2:$A$5000,A2,$B$2:$B$5000,B2,$C$2:$C$5000,">="&C2-Window,$C$2:$C$5000,"<="&C2+Window)
G: possible split
=AND(D2<Limit,E2>=Limit,F2>1)
Run it once for each approval level you have. A short window, such as three to seven days, keeps false alarms down.
A second useful test is simply counting how many items fall in a narrow band just below each limit, compared with the band just above. A pile-up just below the line is a sign that people are working to the limit rather than to the need.
=COUNTIFS($D$2:$D$5000,">="&Limit*0.9,$D$2:$D$5000,"<"&Limit)
The same test works on corporate card spend, where split transactions are common; see the expense claim audit checklist. For the approval rules themselves, see the invoice approval workflow.
If splitting is common, ask why. Approval limits that are too low for routine purchases, approvers who take days to respond, and no option for framework agreements or blanket orders all push people to split. A blanket purchase order for repeat supplies, a faster approval route for low-risk items, or a limit that reflects real spending patterns often removes most of the splitting without weakening control.
The test is the same in both countries. Public sector bodies often have additional procurement rules on splitting contracts to avoid tender thresholds; check the rules that apply to you.
Matches every company card transaction to its expense claim, and flags spend nobody claimed, claims made twice, missing receipts and splits under the approval limit. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
Yes. Several card charges at the same merchant on the same day, each under the single-transaction limit, are the card version of a split purchase.
One purchase deliberately divided into several smaller orders so that each one falls below an approval or tender threshold.
No. It is often someone avoiding a slow approval process. It is still a control failure and should be reviewed and recorded.
A few days to a week usually catches genuine splits without flagging normal repeat purchasing. Adjust it to how your business buys.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.