To change the report definition of the VAT Report, first click the [Settings] button in the Master Control panel and double-click 'Report Settings' in the subsequent list. Then highlight 'VAT Report' in the list on the left-hand side of the 'Report Settings' window and click the [Definition] button. The 'Definition of VAT Report: Browse' window is opened.

The definition above is a standard UK VAT report, using the Chart of Accounts and definitions supplied with HansaWorld Enterprise. You can alter it to suit your specific requirements: you will need to change it if you have modified the standard Chart of Accounts or imported your own. You will also need to change it if you are using the Book Receipt VAT, Book Prepayment VAT and/or Book Payment VAT options to calculate VAT from Receipts and Payments, not from Invoices and Purchase Invoices. If so, you will need to replace the Output and Input Accounts in the formulae with the O/P and I/P Accounts specified in the VAT Codes setting.

Each row in the definitions list represents a line in the VAT Report. You can add, insert or delete rows as necessary. To insert a row, highlight the row above which the new one is to be inserted (by clicking the row number) and press the Return key. To delete a row, highlight it and press the Backspace key.

The right-hand field of each row contains a formula by which the figure to be shown is calculated. This formula uses the same definition language as the Key Financial Ratios definition. Please refer to the page describing the definition of that report for a full description of the commands available.

If you are an existing user of HansaWorld Enterprise updating to version 4.1 or later, note that the syntax used in the Key Ratio formulae changed in this version. All parameters should now be enclosed in quotation marks. The order of parameters for the VATRESULT, VATBALANCE, VATCREDRESULT and VATDEBRESULT commands has been transposed.

Row: Each line of the report is defined on its own numbered row.
Code: A code identifying a row that you can use in the definitions of other rows.
Comment: A descriptive text that identifies the line in the finished report.
Definition: The definition of the row in the report, i.e. which Accounts should be used in calculating the figure to be shown, and the formula of that calculation.

If you are using the Add VAT Code to VAT A/C rows option in the Transaction Settings setting, the appropriate VAT Code will be copied to the V-Cd field in each Transaction row posting to a VAT Account, as well as to the V-Cd field in the rows posting to a Sales or Cost Account. This will allow you to apply the VATRESULT command to the VAT Accounts. You could do this instead of applying it to the Sales and Cost Accounts as shown in the illustration above, or in addition, as a check mechanism.

When you have finished defining the VAT Report, click [Save].

Previous Next Top Entire Chapter in Printable Form