Expense-to-pay: control and audit worksheet
This worksheet lets a reviewer test whether your expense bills are really handled the way you say they are, from the day a bill arrives to the day it is paid. It is used by an owner, an accounts head or an outside reviewer who wants proof, from a small sample, that bills are recorded, checked, allocated and approved before payment. It tests the controls around the bills, not the people who handle them.
When to use it
Use it once a month on the previous month's bills, before the books are closed. Run the full version when you start the process, when the bill recorder, department approver or accountant changes, and after any case of a duplicate payment, a payment to a wrong account or a bill booked to the wrong branch. A shorter run with three or four controls is fine in a quiet month.
The template
Test each control on a small sample of bills and record what you found. Keep one worksheet per month and file it with the month's accounts papers.
| Ref | Control | How to test | Evidence to check | Tester | Result and note | Corrective action |
|---|---|---|---|---|---|---|
| E1 | Every bill is recorded with supplier, bill number, date and amount before it goes for approval | Pick 5 bills from the payment list and trace each back to a recorded entry | Bill file, expense register | Reviewer | ||
| E2 | Supplier identity matches a verified supplier record | Compare supplier name, tax registration number and bank account on 5 bills with the supplier master | Supplier master, bill copy | Reviewer | ||
| E3 | Line items were confirmed against the bill by someone other than the recorder | Check the confirmation initials and date on each sampled bill | Annotated bill, approval note | Reviewer | ||
| E4 | Cost centre or branch split adds up to the bill total and was approved | Add the split lines and compare with the bill total | Allocation sheet, approval message | Reviewer | ||
| E5 | Tax and posting treatment was confirmed by the accountant | Read the treatment noted against each bill, including whether tax credit and tax deduction were considered | Posting note, accountant's sign-off | Reviewer | ||
| E6 | Payment was approved by a person with authority for that amount | Match the approver to the approval matrix for each paid bill | Payment approval, approval matrix | Reviewer | ||
| E7 | No bill was paid twice | Sort the month's bills by supplier, bill number and amount and look for repeats | Payment list, bank statement | Reviewer |
How to fill it
- Ref: keep the numbers fixed so results can be compared month to month.
- Control: change the wording only to match your own practice. Do not delete a control because it fails; a failed control is the reason for the worksheet.
- How to test: write down the sample you used (bill numbers or supplier names) so another person can repeat the test and reach the same answer.
- Evidence to check: note the file name, page or message date you looked at. "Seen" is not evidence.
- Tester: the person who did the test. It must not be the person who recorded or approved the bill being tested.
- Result and note: write Pass or Fail, then one line on what you saw. A pass with a worry still deserves a note.
- Corrective action: name the person and the date. If the fix means recovering money or correcting an entry, say which.
Tax credit, tax deduction at source and the records you must hold for each bill depend on current tax law and your registration. Check the current rule on the official portal or with your CA before acting.
Example row
| Ref | Control | How to test | Evidence to check | Tester | Result and note | Corrective action |
|---|---|---|---|---|---|---|
| E7 | No bill was paid twice | Sorted October bills by supplier, number and amount | Payment list, bank statement | Meera (accounts head) | Fail. Bill SP/1184 from Sharma Packaging, ₹38,500, was paid on 9 October by bank transfer and again on 21 October by cheque 004512 | Ask Sharma Packaging to adjust the next bill by ₹38,500 or refund it. Raj Kumar to confirm by 5 November |
Review and sign-off
- The accounts head or owner reviews the completed worksheet within a few days of testing, signs it and writes the date.
- Review it every month while the process is new, then every quarter if two or three clean months in a row have passed.
- Escalate to the owner at once for any duplicate or wrong-account payment, any bill paid without approval, or a supplier whose bank details changed without a written request.
Keeping it up to date
- Add a control when a new kind of loss appears, such as a bill paid from a photograph rather than the original.
- Keep each month's worksheet with its sampled bills for the period your CA or the law requires.
- Remove nothing without noting why, and re-date the worksheet each time the approval matrix changes.