You can analyse all the relevant transactions that add up to the amount displayed in the VAT Reconciliation Summary. More detail is displayed such as where the document was sourced, the document and daybook number, as well as the breakdown of the goods and VAT amounts.
To carry out VAT nominal analysis:
From the Autoline master menu select the Nominal Ledger option and the company you require.
The NOMINAL LEDGER MENU is displayed.
Select the VAT options option.
The NL VAT MENU is displayed.
Select the VAT Reconciliation option.
The VAT Reconciliation summary form is displayed.
Click an amount in the line whose VAT code you want to analyse.
The Nominal transaction summary drill on VAT code [identifier code] form is displayed.
This form is displayed when you click an amount on the VAT Reconciliation summary form. It enables you to perform a detailed query on a VAT code.
Num: Transaction line number
Source: Autoline module source of transaction
SL/PL Account: Sales or Purchase Ledger account number
Doc Num: Invoice or Credit Note number
Item Num: Line number
V: Letter of VAT code being analysed
Doc Date: Invoice or Credit Note date
Posting Date: Nominal Ledger posting date
Customer Ref: Customer or supplier reference number
Daybook Num: Nominal Ledger daybook number
Invoices/Credit Note Goods Value: Goods value
Invoices/Credit Note VAT Value: VAT Value
Tip: The Nominal Ledger module validates the VAT amount. Transactions where the VAT amount does not match the amount calculated by applying the tax rate to the goods value are shown in red.
Grid right-click menu:
Display Document Details: Displays the Document for all VAT codes form, which explains in detail all the information for the document required. This includes references and the status of the document, as well as the goods and VAT amounts. You can display the document itself if it has been archived.
Display actual document: Displays the document itself if it has been archived
Drill on daybook number: Enables you to see all the transaction lines for the daybook the VAT transaction was allocated to. You can double-click the individual lines in order to view more detail (including the document itself) or alternatively click Detail or Document.
Reconcile errors: Displays the Document VAT Reconciliation Form. If the VAT value calculated from the goods value is different from the value calculated by Autoline, a difference is displayed and you can correct it if you want to by processing a correcting document. The fields are not editable.
PUSH BUTTON:
Close: Returns you to the VAT Reconciliation summary form
This form is displayed when you take the Reconcile errors option from the grid right-click menu on the Nominal Transaction Summary Drill on VAT Code [identifier code] form.
Goods value: Value of goods
VAT value: Keyed VAT value
Calculated VAT value: System-calculated VAT value
Difference: Difference between the VAT value and the Calculated VAT value
This form is displayed when you take the Display Document Details option from the grid right-click menu on the Nominal Transaction Summary Drill on VAT Code [identifier code] form.
Account
Number: SL or PL account number
Name: Name of the SL or PL Account
Document Details
Document number: Document number relating to the document accessed
Item number: Item number of the document
Posting Date: When the document was posted to the ledgers
Document Date: Date used by the document for calculation of due dates
Due Date: When the document is or was due to be paid
Document Type: Whether the document is an Invoice or Credit Note
Customer Reference: Reference used for customers (if any)
Miscellaneous Ref: Optional field for reference
Status: Payment status (for example P if the document is paid, d if it is set to be paid in a BACS run)
Document Values
Goods Value: Net value of the document
VAT Value: VAT amount of the document
Base Value: Gross value of the document
Amount Paid [base]: How much of the document has already been paid
PUSH BUTTONS:
Document: Enables you to display the document itself if it has been archived
