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?
- Line by line (the e-invoice one: FacturaE, Verifactu, TicketBai): the VAT of each line is calculated and rounded, and the results are added up.
- On totals (the ‘classic’ one): first the bases of all the lines are added up and the VAT is calculated only once on the total for each rate.
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:
- From settings (the default value): the record doesn’t impose anything and the company’s general rule applies.
- Line by line (e-invoice) or On totals (classic): their documents will always be calculated with that method.
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 see | What has happened | What to do |
|---|---|---|
| A customer rejects your invoice for a one-cent ‘calculation error’ | Their system uses the other method | Set on their record the method their system uses and issue again |
| The purchase invoice doesn’t match the supplier’s paper by one cent | Their program calculates with the other method | Change 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 cent | The new customer has another method on their record and the document inherits it | That is expected; if you don’t want it for this document, change it in Financial |
More about Invoicing
- How do I delete a document?
- How do I make the consignment note for a shipment?
- How do I charge shipping or expenses without VAT?
- Setting up numbering series
- How do I convert several documents at once?
- How do I turn a quote into a sales order, a delivery note or an invoice?
- Can I leave a document half-done and go to another screen?
- How do I issue an invoice?
- How do I deliver a sales order in several deliveries?
- How do I invoice a fee that repeats every month?
- How do I invoice several delivery notes at once?
- Pro forma invoices