VAT Supplier Purchases
This report is a simple list of Suppliers showing total purchases including VAT in the report period. The Suppliers are listed in VAT Registration Number order. The information is taken from
approved Purchase Invoices. Purchase Invoice rows using
VAT Codes whose Real Sales field on flip B is set to 'Exclude from Official Invoices' will not be included.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter a start and end date for the report.
- Supplier
- Paste Special
Supplier register
- Range Reporting Alpha
- If necessary, enter here the Supplier Number of the Supplier (or range of Suppliers) you wish to have shown in the report.
- Note: all Suppliers in the range should have VAT Registration Numbers specified. The report calculates purchases from each VAT Number, not from each Supplier. If more than Supplier in the range is without a VAT Number, each of their sales totals will be the total for all Suppliers without a VAT Number.
- Category
- Paste Special
Supplier Categories setting, Purchase Ledger
- If you want to restrict the report to Suppliers of a particular Category, specify that Category here.
- Min. Amount
- Enter a figure here if you only want to list Suppliers whose purchases including VAT in the report period exceed that figure. If you choose to print using the Exact Notation (below), an exact figure must be entered here. If you choose to print using the Thousands Notation, enter the exact figure divided by one thousand. For example, if you want to list Suppliers whose sales total including VAT exceeds 10,000 during the report period, enter "10,000" if you are using the Exact Notation or "10" if you are using the Thousands Notation.
- Function
- Use these options to control the level of detail shown in the report.
- Overview
- This is a simple list of Suppliers, showing for each their VAT Registration Number and total purchases including VAT for the report period.
- Detailed
- In addition to the information shown in the Overview, this option lists per Supplier the total purchases excluding VAT and total VAT.
- Detailed With Invoices
- This is similar to the Detailed option, but also lists the Invoices (showing Invoice Number and Date) that contribute towards the total figures.
- Notation
- The report can show exact amounts, or amounts divided by one thousand. If the latter option is chosen and the Min. Amount (above) is blank, the Min. Amount is effectively set to 1,000 as Suppliers whose purchases are less than that will not be listed.
Introduction to Reports in the Purchase Ledger
