19.9% VAT Rate on API Generated Invoice?


#1

Hi,

Invoices are created using the API from WooCommerce Orders, however, they are showing the VAT as 19.9%? But it should be 20%?

20% is the rate set in WooCommerce Tax settings and all invoices/orders in WooCommerce show as 20% it’s only when the invoice is generated in Freeagent the 19.9% situation occurs.

Has anybody had this happen before? And if, so is there a fix?

Thanks


#2

This is a rounding error due to when the VAT is calculated. There are various threads about it on the community forum; here’s one:

As you mentioned, FreeAgent rounds the VAT figure per line rather than at the end of the invoice and this is where the discrepancy is occurring.

You can see from this HMRC article (point 17.5.2) that they advise you can calculate VAT either way as long as it is consistent.

Therefore, in effect there is no incorrect answer here - the VAT total of the previous amounts, or the new amounts (1p higher or lower) are both correct depending on how you calculate the VAT.

Here is one possible way to resolve the issue of 1p underpayments on your invoices:

  1. Create a new spending category like this Add new category and call it something like “Penny Roundings”. Set this as N/A for VAT.

  2. Each time you receive a payment from a customer that falls a penny short of the amount you’ve invoiced, when you explain the bank transaction first select the transaction and choose More Options, then explain it as an invoice receipt, change the amount in the “Credit Value” box, to match the amount of the invoice. Save that transaction. This will ensure the invoice shows as fully paid.

  3. FreeAgent will have created a payment of £0.01 in your bank account. Explain this as a Payment to the Penny Roundings category.

When I create invoices from Stripe charges / GoCardless payments I detect any rounding error and and add an invoice item entitled “Rounding error adjustment” for plus or minus 1p to correct it.

Yours,
Andrew Stewart