VAT Report: Default Summarizing

By default, the VAT report calculates VAT balances for a time span covered by the report. The report summarizes the following VAT data in 4 columns:
  • Base income amount (the total net amount of sales for the period on which VAT is chargeable) in the Base amount credit column.  
  • Output VAT for the period (VAT amount you charged on sales of goods or services) in the Amount credit column.
  • Base expense amount (the total net amount you paid for goods or services purchased) in the Base amount debit column.
  • Input VAT for the period (VAT amount charged on your business purchases) in the Amount debit column.
The balances are worked out by summing the original values (using the SUM function).  
The final total amounts are presented at the grand total level. Summable values are in your system currency.
NoteSummary values are displayed at all grouping levels. If no data is available for certain groupings, nothing is displayed for them.
The default summarizing settings are defined in the values section of the VAT report. To define the summarizing methods, the summable fields have been added and summarizing options have been specified for them.  Except for specific reports that do not provide for full customization (see Customize Reports), you can change the summable fields and the summarizing methods for your reports. In case of VAT report, you can do that.
To customize the default summarizing parameters
1. On the page for configuring report parameters, click the Customize button.
2. Use the values section to view and customize the default summable fields and summarizing methods defined for them.
You can delete, rearrange, add new summable fields and specify summarizing methods for them.
For information how to customize summarizing settings, see Summarize Report Data.
To add a summable field:
  • In the values section, click the Select an option box, and then select a summable field from the list of options.
The list displays summable fields from the selected report type which you can use to summarize report data in columns. For the VAT report, you can use the following fields:


Used for summarizing and displaying

Base amount debit

The total net amount you paid for goods or services purchased for a given period.

Base amount credit

The total net amount of sales for the period on which VAT is chargeable.

Amount debit

VAT amount charged on your business purchases for the period.

Amount credit

VAT amount you charged on sales of goods or services for a given period.

The SUM function is selected as a default summarizing method for all fields. 
If it is required to change the summarizing method, you do that as follows:
  • Click the calculation option box to the right of the field, and then select one of the available summarizing options from the list.
For summarizing options, see Summarizing Methods.