This option allows the user to view the VAT related balances for selected VAT periods, for each VAT code, for input and output VAT where relevant. As well as being useful for a summary, this menu option also allows the user to view the detailed transactions that make up the overall balances for each code, in other words the user can actually drill into the transactions as far as the detail of a single invoice that has been produced in the relevant VAT period.
1. From the Autoline master menu select the Nominal Ledger option and the company you require.
2. Select the VAT options option.
3. Select the VAT Reconciliation option.
4. The VAT Reconciliation summary form is displayed
You will be presented with a form that consists of a transaction grid and several selection criteria buttons and 
boxes.
PERIOD SELECTION
In order to select the relevant VAT period, a box is provided, to select the VAT year, and also the VAT period. There is a "from year" and a "to year" to aid selection. The same applies to the period selection. Once the user has selected the relevant year and period, the Start and End date will be displayed to the right of the selection boxes, and these fields are for information only [in other words they cannot be edited by user]
At this point there is also the facility to Suppress unused account codes, this is selected via a check box.[to switch the facility on, the user must check the box] This effectively will stop any account codes that do not have any transactions posted to them.
The Drill errors only check box will highlight any errors where VAT amounts do not correspond exactly to the amounts that equate to the VAT rate. For example, if a goods value of £100 was set to a VAT code of S [standard rate at 17.5%], the VAT should be £17.50 and the total for the document should be £117.50. Sometimes the VAT amount is not exactly the same as the rate would suggest (perhaps £17.49) hence these type of errors are highlighted when the drill errors only box is checked.
THE OUTPUT TAB
When the user is presented with the output tab, the grid presents the following fields:
Control Account: This is the control account used for VAT purposes for outputs- usually it will be either expense code 9642 or 9643.
Vat code: For every control account, there can be an entry for the VAT code- this is displayed as a single character.
Vat Group: This will display the VAT group that is related to the VAT code, for instance UKL
DescriptionThe description that corresponds to the VAT code.
Vat rate: The rate for the relevant VAT group and VAT code.
Goods amount: This field is divided into two halves- Invoices and Credit Notes. Hence it will show the [net of VAT] amounts for each VAT rate, both for invoices and credit notes.
VAT amount: This field is similar to Goods amount, but will show the VAT portion for each VAT rate, hence for VAT rates that are zero rated, there will be no figures populated in this field, but there will be for goods amounts.
Nominal Transaction summary: The user also has the ability to perform detailed queries on the amounts displayed for each code, by right clicking the mouse into the relevant line of the VAT Reconciliation Summary grid for goods OR VAT amounts. This will display all the relevant transactions that total to the amount displayed in the VAT Reconciliation Summary. More detail is displayed in terms of where the document was sourced, the document and daybook number, as well as the breakdown of the goods and VAT amounts. It also displays whether there are any errors, by highlighting them in red.[If the goods value and the VAT value do not agree with the amounts stated on the source document] Please note that the transactions will not be highlighted in red for VAT codes of r [Used Non-qualifying VAT invoices] if UK Country Specifics are switched on, and the Non Validated VAT code is used and set to r in the NL Parameters field] These transact ions will be displayed in blue. At this point the user can either Close or access online Help, or can right click on an individual line to access one of the following options:
Display Document details: This displays the Document for all VAT codes form, which explains in further detail all the information for the document required , including references and the status of the document, as well as the goods and VAT amounts. The user can either Close, access online Help, or display the Document itself if is has been archived.
Display actual document: This option is identical to that when the user clicks the Document button in the Display Document details option as discussed above.
Drill on daybook number: By selecting this option, the grid displays all the transaction lines for the daybook the VAT transaction was allocated to. The user can double click on the individual lines in order to view more detail [including the document itself], or alternatively can click the buttons Detail, or Document. The user can also click Close to return to the menu, or Help to access online help.
Reconcile errors: If the VAT value calculated from the goods value is different to the calculated value [calculated by Autoline], a difference will be displayed and the user can make an amendment. If the values are not different, the fields will not be editable.
THE INPUT TAB:
The functionality and display is identical to the Outputs tab, except it displays the Input [purchasing side of VAT] transactions.
THE BALANCES TAB:
This tab displays the Inputs and Outputs together, along with the balances that are found in the Nominal Ledger.
BUTTONS
On Input, Output and Balances tab, the user can choose from the following buttons:
Close: Returns the user to the VAT options menu.
Print current: Prints the currently selected period to the selected printer.
Print all: Prints all periods information to the selected printer.
Help: Displays online help in the default browser.
