Language:


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: