Item wise Tax and Income account when invoicing

Introduction

In this manual we will look at how we correctling define our taxes and income account on invoices. Tax and income account are not defined on transaction level but rather on item level. This also accounts for the income account. Meaning the two are connected.

We will be looking at examples for the swiss region.

This works very similar in other reagions and can be transfered

Assumptions

In Switzerland there are 3 different taxes that are used

Reference: https://www.ch.ch/de/steuern-und-finanzen/steuerarten/mehrwertsteuer/

In Germany we have two different tax rates

An example for tax: An employee is  staying at a hotel to work on site on a customer project in switzerland. He is staying at a hotel and will stay in to eat. We let the clerk know, that we would like just one invoice wich we give to our accounting department. The invoice will have the following items

We send our sales representive to Germany to try and close a deal with a German custmer.

As seen in the two tables we have two different items and four diffent tax rates. Also there are two different expense account groups.

In ERPNext we can control the item-tax based on tax rules set up in our system. Missing in ERPNext are "expense account rules" which control which expense account is used depending on the region where an item is purchased or consumed (delivered).

Solution: As we can set up Item-Tax-Templates (on Item or Item-Group Master) combined with Tax Rules we could set up the expense accounts inside the Item-Tax-Tamplate and fetch the value into the transaction on item-level.

Also the item-tax-template can hold the VAT-Codes as these align.