How to check a supplier invoice before you key it into SQL Accounting
Before a supplier invoice goes into SQL Accounting, check ten things: it is addressed to you, from a supplier you know, not keyed already; every line, the subtotal, the tax and the total add up; the dates and terms are right; the currency is the one you expect; and it matches what you ordered and what arrived.
Last checked against eStream’s SQL Accounting documentation (the Purchase and Supplier usage guides).
The ten checks
- It is addressed to your company, not to a sister company or another branch’s name.
- The supplier is one you already have in SQL Accounting, under the same name and tax numbers.
- The supplier’s invoice number has not been keyed before.
- Each line adds up: quantity times unit price, less any line discount.
- The lines add up to the subtotal.
- The tax is the rate printed, applied to the right amount.
- The total is the subtotal, less any discount, plus tax and any rounding.
- The invoice date, the payment terms and the due date make sense.
- The currency is the one this supplier bills in, and any exchange rate looks right.
- It matches what you ordered and what arrived.
Do them in this order. The first three take seconds and stop the wrong paper before you spend time on its sums.
Is it yours, and from a supplier you know?
Read the buyer’s name first. In a group with several companies, or with branches billed under different names, an invoice can land on the wrong desk. One for another company goes to the person who keeps that company’s books.
Then the supplier. Match the name, and the registration and tax numbers if the invoice prints them, to the supplier you already keep in SQL Accounting. A supplier you have never dealt with is not an error, but it is worth a question before the bill goes in: set the supplier up in SQL Accounting first, with someone who can approve it.
Has it been keyed already?
Look for the supplier’s own invoice number in what you have already keyed for that supplier. The same invoice often arrives twice: by email and on paper, as a copy and an original, or again with a new date when it is overdue. The guide on duplicate supplier invoices covers how that happens and how to stop it.
Do the sums hold?
Work the arithmetic again instead of trusting the printed figures.
- Each line: quantity times unit price, less the line’s discount, should give the line amount. A line of 4 at 23.48 is 93.92, not 39.92.
- The subtotal: add the line amounts. If they do not reach the printed subtotal, a line was printed or read wrong.
- The tax: apply the rate printed on the invoice to the amount it is charged on. Leave out any lines that carry no tax.
- The total: the subtotal, less any invoice discount, plus tax, plus or minus rounding. A difference of a sen or two often comes from rounding the tax line by line instead of once.
When a figure does not add up, do not change it to fit. Ask the supplier: they either confirm the paper or send a corrected invoice or a credit note, and you key what their paper says.
Dates and terms
- The invoice date should not be in the future, and an invoice dated months back deserves a second look.
- The payment terms should be the terms you agreed with this supplier.
- The due date should be the invoice date plus those terms.
Currency
If the supplier bills in a foreign currency, check the currency code on the invoice is the one you expect from them. If it prints an exchange rate, compare it with the going rate for that currency on that date. A rate far from it is worth a call to the supplier before you key it.
Does it match what arrived?
Compare the invoice with your purchase order and with the supplier’s delivery order or your goods received note: the same items, the quantities that actually arrived, and the prices you agreed. This one is a person’s check. Only someone who knows what was ordered and what came in can say the invoice is right to pay.
In SQL Accounting, a Purchase Invoice can be transferred from the Goods Received note, so the invoice starts from what was received. See which document each paper goes into.
When something is wrong, the fix comes from the supplier. Ask for a corrected invoice, or a credit note for an overcharge, and key what their paper says. The guide on supplier credit notes and debit notes explains which document each note goes into.