Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

VAT Reports

Datafile Software

VAT Reports

This option gives a sub-menu of three reports analysing the transactions against the VAT code.

VAT Summary

This report lists the total goods amount, tax, and for the purchase ledger, the EC Acquisition tax for each of the tax codes defined in the tax table. It is usually a single page report but if using ‘Cash Accounting’ a second page analyses the payments by tax code.

Include Previous Periods

Provided you are retaining analysis transactions for more than three periods (thus not applicable for Compactsystems) the VAT Summary can report for more than one period. If you wish to include up to two previous periods set this option and set the number of previous periods to include (1 or 2). The system will automatically set the ‘Starting Transaction Control No’ relative to the number of periods to include.

Comment Printed for this Period

Automatically updated with a text commentary reflecting the period the report covers but it can be manually updated if required.

Reporting Previous Period Transactions

This report and the two EC VAT reports allow the facility to report for up to two previous periods. If you wish to analyse the VAT over a greater length of time then you can use selection criteria on this report to do this, provided that you are retaining analysis transactions.

To report earlier periods you need to set within the selection criteria the starting record as ‘1’ and then enter criteria for the appropriate date range. When allowing posting using a previous periods date, then you will need to modify this slightly and use two lines of criteria – one to allow transactions with a date greater than (say) the start of the financial year, and a second line to only report transactions for the period range of x to y.

Similar criteria can be entered on other transaction reports to include details from previous periods.

EC Totals Report

This selects those transactions which have EC tax codes defined in them and sorts them by account within country. A line is printed for each account to show the country, the tax registration code, the goods amount, and (for the purchase ledger only) a calculated "acquisition tax” value for the goods. Overall totals and totals per country code are also printed.

EC Details Report

This report shows the detailed analysis transactions that go to make up the totals report above.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Ledger Enquiry – View Documents from Transaction List
Viewed 4948 times since Wed, Jun 13, 2012
Credit Control Manager / Additional Options
Viewed 2716 times since Mon, Jun 11, 2012
Increased Size of User-2 / User-3 Items
Viewed 1564 times since Wed, Jun 13, 2012
Unallocated Transaction Reports
Viewed 1643 times since Mon, Jul 2, 2012
Reporting Defaults
Viewed 1988 times since Wed, Jun 13, 2012
Validate Account and Stock Groups Entries
Viewed 1640 times since Fri, May 27, 2016
Cheque Design (Purchase Ledger) (Excluding Compact) - Document Design Manager
Viewed 2202 times since Mon, Jul 2, 2012
Account Statements - Application User Facilities
Viewed 1880 times since Mon, Jul 2, 2012
Provide for Bad Debts - Sales Ledger
Viewed 1697 times since Mon, Jul 2, 2012
Sales / Purchase Transactions - Application User Facilities
Viewed 1759 times since Mon, Jul 2, 2012