Skip to content

How do I sell with prices including VAT?

On a document you can type and see prices with VAT already included, as at the counter: you type 121 € and the line is worth 121 €. The program works out the base backwards. What is declared to the Tax Agency —base, tax amount and total— has the same form as always.

Where is it turned on?

On the document, Financial tab, VAT calculation data card, Prices field:

You don’t need to set it on each document: it starts on its own, and you can change it afterwards.

What value does a new document start with?

It looks, in this order, and the first one that says something takes priority:

  1. The series. If the document’s series is marked Show with VAT, the document has VAT included. It is what you would expect of a series for selling to the public (counter, shop).
  2. The customer or supplier record. On the Financial tab of the record, the Prices field can say VAT included, Excluding VAT or The company’s.
  3. Your company. In Settings → Sales and documents → Prices, Prices including VAT:
    • Prices excluding VAT: documents start without VAT.
    • Sales with VAT: sales documents start with VAT included; purchase documents, without VAT.
    • Sales and purchases with VAT: both start with VAT included.

When you choose the customer or change series, the document looks again and warns you if it changes (for example, ‘Prices including VAT, from the series.’). Each line keeps its total.

Do my item prices include VAT?

The same setting in Settings → Sales and documents → Prices says so. With Sales with VAT, the sale price of your items and price lists already includes VAT: an item at 121 € at 21 % goes onto the line at 121 €, with a base of 100 €. With Sales and purchases with VAT, the purchase price on the record does too. With Prices excluding VAT, the price on the record is the base.

This applies even if a particular document is without VAT: if the customer record says Excluding VAT, that 121 € item goes in with a price of 100 € and a total of 121 €. VAT is never added twice.

The last price you bought at from a supplier comes from an earlier invoice: that one is already without VAT.

What changes on the lines?

What happens if I change it with lines already entered?

Each line keeps its total. If you switch to ‘VAT included’, each line keeps the price with VAT that gives the total it already had. If you go back to ‘Excluding VAT’, it keeps its price without VAT. When rounding, a line can move by one cent.

Why isn’t the VAT amount exactly the base times the rate?

Because with prices including VAT the total you have typed takes priority. The program calculates the base, rounds the surcharge, and the VAT amount is whatever is left to reach the total. That is why the tax amount can differ by one cent from base × rate. It is the same as the desktop application does.

The VAT calculation method (line by line or on totals, see fix the VAT cent) still decides where the rounding happens:

MethodWith prices including VAT
Line by lineEach line respects its total. The base of each line comes from its total.
On totalsThe totals for each VAT rate are added up and the base comes once from that sum. That base is shared out among the lines, and each line keeps its total.

What about purchases?

It works the same. The invoice you type should match the supplier’s paper to the cent if you use the same calculation method as their program (see fix the VAT cent). If there is still a one-cent difference, add that cent as an expense without VAT (see charge expenses without VAT). Don’t make up a separate amount.

If something goes wrong

What you seeWhat has happenedWhat to do
The line price comes out with VAT and you didn’t want itThe document is set to ‘VAT included’Change Prices to ‘Excluding VAT’ in Financial; the totals are kept
All of a customer’s documents start with VAT includedTheir record says so, or the series is marked Show with VATChange Prices on the customer record, or the box in Document series
An item at 121 € comes out at 146,41 €The company is on Prices excluding VAT and the record has the price with VATChange Settings → Sales and documents → Prices to Sales with VAT, or put the price without VAT on the record
The VAT amount differs by one cent from base × rateWith VAT included, the typed total takes priorityThat is expected
The purchase invoice doesn’t match the paper by one centThe supplier calculates with another methodChange VAT calculation; if it still doesn’t match, enter the cent as an expense without VAT

More about Invoicing