How do I configure the Spreadsheet Settings in the Submit VAT Return window?

The Sheet Name and Cell spreadsheet settings in the Submit VAT Return window (see fig. below) let Easy MTD know where in your selected spreadsheet each of the 9 VAT figures are located.

Fig. Submit VAT Return window with the spreadsheet settings shown on the right

Note: To enable the spreadsheet settings, a spreadsheet must be selected (use the Find button or drop the spreadsheet file inside the Submit VAT Return window).

There are two spreadsheet settings for each VAT figure:

Determining and Selecting a Sheet for a VAT Figure

To determine the sheet where a VAT figure is located in your spreadsheet, perform the following actions:

1. Open your spreadsheet in Excel.
2. Find the associated VAT figure in your spreadsheet.
3. Make a note of the sheet name where the VAT figure appears. In Excel, this is normally indicated by a sheet tab located at the bottom left of Excel (see fig. below).

Fig. Example Excel sheet tab (the name here is Sheet1)

Now you know the sheet where a box figure is located, you can select it for the corresponding box in the Submit VAT Return window. Do this by clicking the associated Sheet Name list box and clicking the corresponding option. For example, if the figure for box 1 is located in a sheet called Sheet1 within your spreadsheet, select the Sheet1 option from the box 1 Sheet Name setting list box (see fig. below).

Determining and Specifying a Cell for a VAT Figure

To determine the cell where a VAT figure is located in your spreadsheet, perform the following actions:

1. Open your spreadsheet in Excel.
2. Find the associated VAT figure in your spreadsheet.
3. Make a note of the cell where the VAT figure appears. In Excel, this is indicated by a letter followed by a number (see fig. below), e.g. B2. The letter indicates the column and the number indicates the row. Clicking inside the cell normally displays the cell letter and number within the Excel interface.

Fig. Example Excel cell (the value is in cell A1)

Now you know the cell where a box figure is located, you can specify it for the corresponding box number in the Submit VAT Return window. Do this by clicking inside the associated Cell setting then typing the cell value. For example, if the figure for box 1 is located in cell A1 within your spreadsheet, specify A1 for the box 1 Cell setting.

Dealing with Missing VAT Figures or VAT Figures That Are Not Applicable

Your spreadsheet may not contain certain VAT figures because they may not be applicable to your business (e.g. box 2, box 8 and box 9 because you do not deal with the EU), or you have not calculated them (e.g. box 3 and box 5). When this occurs, simply leave the associated Sheet Name and Cell settings blank in the Submit VAT Return window. For box 2, box 8 and box 9, Easy MTD will apply 0.00 or 0 for the associated VAT figure. For box 3 and box 5, Easy MTD will calculate the associated VAT figure.