Skip to content

Why is my invoice one cent out and how do I fix it?

There are two legitimate ways of calculating the VAT on an invoice, and depending on the figures they can give results that are one or more cents apart. Each business management program uses its own. The ERP lets you choose the method per customer, per supplier and per document, so that your invoices match to the cent with whoever receives them.

What are the two methods?

With many figures the result is the same. With others, it isn’t: the rounding remainders of each line build up in one direction or the other and the total is a cent out. Neither of the two is ‘wrong’; what is wrong is mixing the two in the same document — and that is exactly what the ERP no longer allows: once a method is chosen, the whole document (screen, VAT breakdown and PDF) comes from the same calculation.

Where do I choose the method for a customer or a supplier?

On their record, Financial tab, VAT calculation field:

On the supplier record it says how their program calculates invoices: that way the purchase invoice you type matches to the cent the paper they send you. On the customer record it says how they expect to receive yours: there are customers whose system rejects ‘wrongly calculated’ invoices because of a one-cent difference in method.

What about the company’s general rule?

In Settings → Sales and documents → Invoicing, VAT calculation field. By default it comes as Line by line, which is how this ERP has always calculated: if you don’t change anything, no total changes.

How is it applied to a document?

The document starts with the method from its business partner’s record (or, if the record doesn’t say anything, with the one from settings). You can see it and change it on the Financial tab, VAT calculation data card, VAT calculation field: when you change it, the totals and the breakdown are recalculated straight away.

The document field is the one that takes priority. It is for the one-off case: a new supplier whose method you don’t know yet, or an invoice that has been sent back to you over one cent.

What happens when invoicing several delivery notes with the classic method?

The invoice reproduces to the cent the sum of the delivery notes: each delivery note adds up its bases on its own —the same as when it was issued— and the tax amounts are added together. That way the customer, who already has the delivery notes in hand, sees that the invoice is exactly the sum of their papers.

Lines added by hand to that invoice (shipping, for example) are added up separately, as one more group.

With the line-by-line method there is nothing to decide: the sum of the lines always reproduces the sum of the delivery notes.

If something goes wrong

What you seeWhat has happenedWhat to do
A customer rejects your invoice for a one-cent ‘calculation error’Their system uses the other methodSet on their record the method their system uses and issue again
The purchase invoice doesn’t match the supplier’s paper by one centTheir program calculates with the other methodChange VAT calculation on the document (or on their record, for good) and check that it matches
When you change the customer on the document, the total changes by one centThe new customer has another method on their record and the document inherits itThat is expected; if you don’t want it for this document, change it in Financial

More about Invoicing