Group VAT returns

Where companies have separated their operations into 2 or more data companies, but have retained one VAT submission, there is the need to merge the values of the companies. 

To enable Group VAT submission each company will have the same VAT reg. no. in its Company Details. Only one company can be the Submission company so there is a drop down menu to select it. The rest will be Subsidiary companies.

The details for the Group VAT Submissions company and any Group VAT Subsidiaries are entered in Settings > Company Details > VAT Details.

The company that will be making Submissions will need to have a specific nominal for the Import VAT journal. This must be of Nominal Group Type either Current Assets or Current Liabilities and can be set up from the Nominal for Import VAT Journal field on the details form.

Export

Once a VAT return has been confirmed in a subsidiary company, an Export button will appear at the top of the VAT return:

This will download a new file in Excel format which can be saved and renamed as required.

The VAT returns listing screen in the subsidiary company will show when a VAT return has been exported:

Import

To import the Excel file, in the Submission company open the VAT returns screen and click on the Import button at the top. This will open the following screen:

Click on the upload button and browse to select the required file. The details from the spreadsheet will be shown so that you can check it is correct. Click on Import.

A pop-up will be displayed to give you the number of the journal which is created :

To check the values have been imported, run the Transactions report in the VAT return and you will see the journal including the name of the company it has been imported from.

Should an import be made in error or duplicated, as long as the VAT return has not been submitted then the journal can be removed. Press the Calculate button again on the VAT return to see the new figures.