lamp.
ResourcesPricingAbout
5 min readBy

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.

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
E1Every bill is recorded with supplier, bill number, date and amount before it goes for approvalPick 5 bills from the payment list and trace each back to a recorded entryBill file, expense registerReviewer
E2Supplier identity matches a verified supplier recordCompare supplier name, tax registration number and bank account on 5 bills with the supplier masterSupplier master, bill copyReviewer
E3Line items were confirmed against the bill by someone other than the recorderCheck the confirmation initials and date on each sampled billAnnotated bill, approval noteReviewer
E4Cost centre or branch split adds up to the bill total and was approvedAdd the split lines and compare with the bill totalAllocation sheet, approval messageReviewer
E5Tax and posting treatment was confirmed by the accountantRead the treatment noted against each bill, including whether tax credit and tax deduction were consideredPosting note, accountant's sign-offReviewer
E6Payment was approved by a person with authority for that amountMatch the approver to the approval matrix for each paid billPayment approval, approval matrixReviewer
E7No bill was paid twiceSort the month's bills by supplier, bill number and amount and look for repeatsPayment list, bank statementReviewer

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

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
E7No bill was paid twiceSorted October bills by supplier, number and amountPayment list, bank statementMeera (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 004512Ask 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.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →