VAT Supplier Purchases
This report is a simple list of Suppliers showing total purchases including VAT during 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. Approved Purchase Invoices from the period specified here will be included in the report calculations.
- Supplier
- Paste Special
Suppliers in Contact 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 one Supplier in the range is without a VAT Number, each of their purchase totals will be the total for all Suppliers without a VAT Number, and some such Suppliers may be included in the report even if nothing has been purchased from them during the report period.
- Category
- Paste Special
Supplier Categories setting, Purchase Ledger
- If you want to restrict the report to Suppliers belonging to a particular Supplier Category, specify that Category here.
- Min. Amount
- If you enter a figure here. the report will only list the Suppliers whose total purchases including VAT during the report period exceed that figure.
- If you choose to print using the Exact Notation (below), you should enter an exact figure in this field. 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 Name, 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 Supplier Number, total purchases excluding VAT and total VAT.
- Detailed With Invoices
- This is similar to the Detailed option, but also lists the Purchase Invoices that contribute towards the total figures. For each Purchase Invoice, the Purchase Invoice Number, Date, total excluding VAT, VAT and total including VAT are shown.
- Notation
- The report can show exact amounts, exact amounts without decimals or amounts divided by one thousand.
- If you choose the Thousands option and leave the Min. Amount (above) blank, the Min. Amount will effectively be set to 500.00 as Suppliers whose total purchases are less than that will not be listed (499.99 and less will be divided by one thousand and then rounded down to zero).
- The No Decimals option will remove any decimals by truncation. For example, 312.77 will be printed as 312.
---
Reports in the Purchase Ledger:
Download:
Go back to:
Introduction to Reports in the Purchase Ledger
