Then created some Item Tax Templates. Initially I had each template linked to separate purchase and sales tax accounts. However as this did not work and looking through the forums and at GitHub @Paul-STHL seems to have used only single tax account, modified all the ‘Item Tax Templates’ to link only one account ‘2230 - VAT Liability’. But did not solve the issue.
This where I am not sure how the UK VAT module should work. How does it pull the entries to the VAT return? Looking through the forum if I understand correctly only ‘VAT Details’ inside the yellow box on the below image are used to create the VAT entry to report. Is this correct? If it is then it should be possible to use separate VAT Purchase and VAT Sales accounts on the Accounts Ledger.
When I then create ‘New UK VAT Return’ nothing appears in the boxes. Any ideas what have I missed in the configuration?
On the technical note, does the ‘Item Tax Template’ ‘VAT Details’ section create extra columns to the mysql database for these details (VAT rule, type, VAT rate) to the specific transaction. And then the VAT return goes through all the transactions for the period and pull the relevant data to the relevant boxes on the UK VAT Return?
Have been investigating further the UK VAT MODULE operations, and when it is generating the tax return in the Python script it pulls data from the MarianDB tables
However my ‘tabPurchase Invoice Item’ entries do not have the ‘item-tax_template’ registered (and item_code is empty)
I think after Submitting the invoice the ERPNEXT should assign the ‘item_tax_template’ to the Purchase Invoice Item? Any reason why it would not do that?
Do NOT put the percentage in brackets e.g. (20%) to the ‘Item Tax Template’ name. If you put it in, the ‘tabPurchase Invoice Item’ table in the database will not get the ‘item_tax_template’ reference posted. There is no error on this when creating the template, so perhaps something that ERPNEXT team could add things to do list!
Now ‘item_tax_template’ has entry and the VAT report is generated!
Using the ERPNext UK VAT MTD module. I had some installation issues, and the fix I managed to do is under post
Once Installed few things to note:
You must not use the Purchase and Sales Tax templates on the ERPNext, they will not work with UK MTD module
You must use the Item Tax templates (go accounting and taxes - Item Tax Template)
UK MTD Module adds ‘VAT Details’ section to Item Tax template, you have to set
VAT Rules (you can use this to assign specific rules to e.g. supplier or customer)
Transaction type (see details in guide as if I remember right this is only required to EU Services /Good imports)
VAT Rate
You must not use special character (e.g. %) in the name as then module will not work.
When you then create purchase/sales invoices, do not use Sales/Purchase tax template, but go to individual Items and set the tax template there for the items. This way they are included in the generated VAT report.
I have not figured out how to :
Do actual submissions digitally (have two months to figure that out :-))
How do count import VAT. What I mean is imports e.g. from China where the Courier/customs at the time of import calculated the duty and VAT. As this is not fixed amount of VAT cannot use Item Tax template to set the percentage. It should be possible to manually define the VAT amount on the Purchase Invoice. Could anyone help on this?
Below is setting from my Item Tax template for UK standard 20% VAT
