Language:


VAT Report - Setting up the VAT Report

You can define the VAT Report to determine which Accounts should be included.

To change the report definition of the VAT Report, first select 'Settings' from the File menu 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 FirstOffice. It can be altered to suit your specific requirements: you will need to change it if you have modified the standard Chart of Accounts or imported your own.

Each row in the definitions list represents a line on the VAT Report. Rows can be added, inserted or deleted 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 covering that report for a full description of the commands available.

If you are an existing user of FirstOffice or Office/2 updating to version 4.1 or later, note that the syntax used in the 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 may be used 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.
When you have finished defining the VAT Report, click [Save].