Now I have installed the UK VAT module (https://github.com/software-to-hardware/erpnext-vat-mtd) as discussed by @banksy. But the ‘New VAT Return’ does not seem to return any data on the test data.
First I have configured the tax categories as per the advice on GitHub.
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.
The documentation on the module (GitHub - software-to-hardware/erpnext-vat-mtd: ERPNext VAT return generator and Making Tax Digital (MTD) Submission) implies also using ‘Item Groups’. I don’t seem the find these on V13 ERPNext.
Then I created Purchase invoice to a supplier. On the supplier I set the ‘Tax Category’ to ‘UK’, as defined in ‘Tax Categories’ above.
Then I created new purchase invoice and posted it, it appears on the account ledger on 2230 VAT Liability.
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?
Thank you in advance.