A small trades business in Australia can flag out-of-policy expenses before month end by giving every spend a status, pending, approved or rejected, and by watching month-to-date spending against a budget for each category. Anything pending after a few days is chased. The figures below are invented, and the budgets are examples only.
The problem with approval after the fact
A tradie buys a A$480 tool from a supplier because the job needs it today. Nobody is on the phone to approve. By month end the cost is in the books and the question is just whether it was needed. A status column does not stop the purchase; it makes sure someone looks at it within the week.
Columns that make approval simple
- Date, who bought, supplier, amount, job.
- Status: pending, approved, rejected.
- Approved by and date.
- Category, so budgets can be checked.
A month-to-date budget check
Put category budgets on a tab named Budgets, with the category in A2:A5 and the monthly budget in B2:B5. In the expense log, category is in column C, amount in D and date in A. This formula gives month-to-date spend for the category named in cell G2: =SUMIFS($D$2:$D$500,$C$2:$C$500,G2,$A$2:$A$500,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1)). Then =IF(H2>VLOOKUP(G2,Budgets!$A$2:$B$5,2,FALSE),"Over budget","OK") flags the category. It works in Excel and Google Sheets.
Worked example for one month
| Category | Budget | Spent so far | Flag |
|---|---|---|---|
| Tools | A$600 | A$720 | Over budget |
| Fuel | A$900 | A$610 | OK |
| Materials | A$2,500 | A$2,350 | OK |
| Safety gear | A$250 | A$90 | OK |
Tools are A$120 over their A$600 budget: 720 minus 600. The tool purchase of A$480 on the 12th did most of the damage, because the rest of tools spending was A$240. That is the item to look at, and the budget flag points straight at it.
What if it was needed?
Then approve it with a reason and raise the budget if you expect more, or treat it as a one-off. The aim is not to refuse spending but to make sure that each overspend is a decision rather than an accident. Write the reason in the approved by column so a later review does not repeat the same discussion.
How often should we check?
Weekly for pending items, because they are the ones that age badly, and a fuller look on the last working day of the month for budgets. Ten minutes on Friday afternoons is usually enough for a business with a handful of people.
Who should approve what?
Keep the ladder short. Purchases under A$100 need no approval but still get logged; between A$100 and A$500 one named person approves, usually the owner; above A$500 you talk first, whenever possible. These thresholds are examples, so choose figures that fit how your jobs actually run. If the owner is on a roof and unreachable, agree who stands in, so work is not held up by a missing signature.
Whatever the ladder, record the approval in the sheet and not only in a text thread. A message from three weeks ago is hard to find at month end, and the sheet is the thing your accountant will actually see.
Keep rejected items visible too. A rejected A$480 purchase that the tradie already paid for means the business owes the tradie, or the tradie returns the item. Write which of those happened, so that the sheet and the bank statement agree.
Month-end close
- Clear every pending item to approved or rejected.
- Compare category totals with budgets.
- Note any budget to change next month.
- Back up the sheet.
SpendixAI has budgets, but it is built for India and INR and covers one personal workspace, not approvals, so it is not designed for an Australian business with staff.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
