An approval matrix only works if the limits written on paper match the limits enforced in the system and the bank.
An approval limits matrix sets who can approve purchases, invoices and payments, and up to what amount. Define a few levels, require two approvers above a set amount, stop anyone approving their own spend, align bank portal limits with the matrix, and test approvals monthly in Excel against each approver's limit.
A delegation of authority usually covers three separate decisions, and the same person shouldn't control all three for one transaction:
Keep it to a handful of levels. A typical structure, with limits you set for your own size and risk:
| Level | Role | Limit per transaction |
|---|---|---|
| 1 | Budget holder | Up to limit A |
| 2 | Department head | Up to limit B |
| 3 | Finance director or CFO | Up to limit C |
| 4 | CEO or board | Above limit C |
Add rules that sit across the levels:
Write the limits into your accounting or AP workflow so an invoice can't route to someone without authority. Then check the bank portal: user payment limits and dual-authorisation rules should match the matrix. A matrix that says two approvers while one person can release a payment alone in the bank gives no protection. See the payment run approval checklist.
Hold the matrix in a table named Limits with columns Approver and Limit. In your approved invoice export, with amount in column C and approver in column D:
=IF(C2>XLOOKUP(D2,Limits[Approver],Limits[Limit],0),"Over limit","")
An approver missing from the table returns zero, so every approval they gave is flagged: that is intended. To find the level an amount requires from a table Levels sorted by From amount ascending:
=XLOOKUP(C2,Levels[From],Levels[Level],,-1)
The -1 match mode returns the exact match or the next smaller value, which is the level band the amount falls in. Also flag requester equals approver:
=IF(B2=D2,"Self-approved","")
Limits create an incentive to split. Look for several invoices or POs from the same supplier on the same or nearby days that sit just under a limit. See detecting split purchase orders.
Approval rules are one part of wider segregation of duties.
UK organisations often call this a "scheme of delegation" or "delegated authority matrix"; US organisations say "delegation of authority (DOA)" or "approval matrix". The design is the same. Decide whether limits apply to amounts including or excluding VAT or sales tax, and write it in the policy.
Score a payment request against the warning signs of fraud. Free to use online.
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.
A table setting who can approve purchases, invoices and payments, and up to what amount, with rules such as dual approval above a set level and no self-approval.
As few as practical, often three or four. More levels slow approvals without adding much control.
Export approved invoices monthly, look up each approver's limit in Excel, and flag anything over limit, self-approved or approved by someone not on the matrix.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.