Invoice subtotal without VAT

Hey i’m can’t seem to get a subtotal without VAT on my invoice.

how can i get this?
{% for total in table.totals %}

{{ total.label }}
{{ total.text }}

{% endfor %}
image

Why do you want to get a subtotal without VAT on the invoice ?
In all countries it is a legal requirement to disclose the VAT values being charged on a invoice.

It’s a legal requirement in belgium to have:

  • totaal with VAT
  • Totaal VAT
  • Totaal without VAT
  • VAT details per VAT tax

Can confirm this is a requirement in Macedonian VAT code: article 53(10).

I will amend your heading as its currently misleading.

If you use tax exclusive then you get all those values, but with tax inclusive (which is your example) you don’t.

So Manager shows amount without VAT as Sub-total.
It might be better to have this string changed to “Amount without Vat” but then, I don’t know if it is used elsewhere.

is there a way to force that output with ’ tax inclusive’

Not with the standard programme, perhaps with a custom theme.
But first I would double check local requirements, ask an accountant.
The Manager tax inclusive format is the generally accepted approach.

i’m trying to do this with a custom theme, but fail to get tax details to show
It was a problem that my accountant addressed to me.
I always need to show
totaal with VAT
Totaal VAT
Totaal without VAT
VAT details per VAT tax

Then perhaps you need to engage a local Liquid programmer as you are trying to manufacture a calculation (75.00 - 13.02) that Manager is doing.

With tax inclusive Manager is doing an inverse calculation (75.00 * 17.36%) to obtain the tax value.

Where can i find the list with prefixes/variables that i can use in the custom designs?

there is no list. you can build your custom theme with the in-built themes as a reference.

I’m working with copy from one off the default. But none of them our showing VAT details.
this is what i need to add.

I tink this code is not hiding more details:

    {% for total in table.totals %}
    <tr>
        <td colspan="{{ table.columns | size | minus:1 }}" style="padding: 5px 10px; border-color: #fff; border-right-width: 2px; border-bottom-width: 2px; background-color: #fff; text-align: right{% if total.emphasis == true %}; font-weight: bold{% endif %}">{{ total.label }}</td>
        <td style="white-space: nowrap; border-color: #fff; background-color: #ED7D31; border-right-width: 2px; border-bottom-width: 2px; padding: 5px 10px; color: #fff; text-align: right{% if total.emphasis == true %}; font-weight: bold{% endif %}">{{ total.text }}</td>
    </tr>
    {% endfor %}

like the other users have already informed above, you do not need a custom theme for what you are trying to show on the invoice.

just create the invoice with the Amounts are tax inclusive box unchecked. this will show the total excluding vat, vat amount, and the total including vat.
the vat rate column will automatically show if you select more than one tax rates in a single invoice. also, Manager will show the tax amounts for the different tax rates separately.

if you still want to use a custom theme and you personally do not have the skills, you can hire someone locally to do it for you. the themes use liquid coding.

As noted above, to get your “exc VAT 17.07” you need to manufacture a calculation (20.85 - 3.58) as 17.07 is not part of the Sales Invoice’s data with tax inclusive.

Also, you don’t need to put 21% per line item if all line items have the same rate as the “inclusief VAT 21%” indicates that that rate applies otherwise you will get this with multiple rates:
0000000%20Bug%202a

Now your theme would need to manufacture a calculation like this (40.00 - 1.42 - 2.60) to get an exc Vat of 35.98

Did you find a way to add those fields on invoice. I have same problem, can you help me with this :slightly_smiling_face:

You need to read the entire thread, @vedranbc. No special action is required. Just uncheck the tax-inclusive box.

Not working. When I add product to cart and also to checkout I have fields from picture.

I need to edit this and add extra fields so I will have this:
Subtotal
Price of product without VAT
VAT amount
Shipping
PayPal fee
Total

What does this have to do with Manager, @vedranbc? This forum is for discussion about the Manager accounting application.