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:
- Excluding VAT (the usual): the line price is the base and the VAT is added on top.
- VAT included: the line price includes the VAT (and the equivalence surcharge, if the customer has it).
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:
- 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).
- 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.
- 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?
- The Price cell shows and accepts the price with VAT. When you put in an item, its price appears with VAT: as it is if your prices already include it, or with the VAT added if not.
- The Amount column shows what the line is worth without VAT (its base). The Total column, what it is worth with VAT.
- The total of each line is exactly what results from what you typed: quantity × price, minus the discount. A price of 121 € at 21 % gives a base of 100 € and a total of 121 €.
- The line’s percentage discount is applied to the price with VAT. The general discount in the footer, to the totals with VAT.
- The withholding isn’t included in the price: it is subtracted afterwards, as always.
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:
| Method | With prices including VAT |
|---|---|
| Line by line | Each line respects its total. The base of each line comes from its total. |
| On totals | The 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 see | What has happened | What to do |
|---|---|---|
| The line price comes out with VAT and you didn’t want it | The 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 included | Their record says so, or the series is marked Show with VAT | Change 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 VAT | Change 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 × rate | With VAT included, the typed total takes priority | That is expected |
| The purchase invoice doesn’t match the paper by one cent | The supplier calculates with another method | Change VAT calculation; if it still doesn’t match, enter the cent as an expense without VAT |
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?
- Why is my invoice one cent out and how do I fix it?
- 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?