Reporting and finance 2 min read
Five invoicing jobs to stop doing by hand in Xero or QuickBooks
Raising invoices, chasing payment, matching receipts, month-end and the VAT return. Five finance jobs that most small businesses still do by hand, and how to automate each one.
Xero and QuickBooks are good at the accounting. What they cannot do is know when a job is finished, read your supplier's PDF, or chase a customer who has not paid. So a person does those bits, by hand, every week. Here are the five we see most, and what we do about them.
1. Raising the invoice
The job is finished in the scheduling system, the job sheet or a spreadsheet, and someone reads it off and types the invoice. That is a connection waiting to be made. When the job is marked done, the invoice should be raised automatically with the right customer, lines, nominal codes and VAT, and sent or held for a quick check, your choice.
Usually saves: four to eight hours a week, and the invoices go out the day the work is done rather than the end of the month.
2. Chasing payment
Both packages can send reminders, but most businesses turn them off because the wording is wrong or they fire at the wrong customers. The fix is a reminder sequence you control: polite on day three, firmer on day fourteen, stopping the moment a payment lands, and flagging the ones that need a phone call.
Usually saves: getting paid seven to fourteen days sooner, which for many businesses is worth more than every other item on this list.
3. Supplier invoices and receipts
PDFs opened, read, typed in and filed. Receipts in a shoebox. Both packages have document capture, and it is better than people think once it is set up properly: the document is read, matched to the purchase order and only put in front of someone when a figure does not add up.
4. Month-end
Exports from the accounts package, the CRM and the job system, pasted into one spreadsheet and fixed by hand. The alternative is a report that pulls from all three automatically, with one agreed definition of each figure, ready on the first of the month. We wrote about it in the Friday report that built itself.
5. The VAT return
Mostly this is a tidying problem: transactions coded wrong during the quarter because the person coding them was in a hurry. Automating the coding rules at the point of entry means the return is right first time instead of fixed at the end.
Where to start
Start with whichever one costs the most hours in your business, which is usually raising invoices or chasing them. Both are a few weeks' work, run in your own Xero or QuickBooks account, and pay for themselves quickly. Book a free call and tell us which one hurts most.