Customer and Vendor Turnover Report

This section describes the fields and descriptions on the Customer and Vendor Turnover report.

In some countries, tax figures related to sales and purchases need to be reported to authorities to make a foundation for preventing fraud. This is statutory in many countries, especially when it concerns transactions across country borders.

This report shows all tax-related transactions for customers and vendors. The details on sales and purchases of a company are provided in this report, and indicate whether a customer or vendor is from a different country. The report also shows tax-specific figures such as non-deductible and deferred tax.

In the report, when a customer invoice is registered for a foreign customer, the basis amount, tax amount, and selected dimensions are displayed in the report. Additionally, when a vendor invoice is registered for a foreign vendor, the basis amount, tax amount, and selected dimensions are displayed in the report. You can control whether to include or exclude same-country customers and vendors, as the rules for reporting to authorities are different in the various countries. Additionally, you can also control whether to include or exclude EU members.

Note: The figures in the reports are grouped by the tax settlement types such as Receivable or Payable. If a tax figure is payable, it is included in the Customer Turnover report. If a tax figure is receivable, it is included in the Vendor Turnover report.

The following Turnover reports are available:

  • Customer Turnover
  • Vendor Turnover

Customer Turnover

Top-Level Header Header Title Description
Customer No. This column displays the customer number of the invoice.
Customer Name This column displays the customer name of the invoice.
Customer Tax No. This column displays the customer's tax number.
Customer ZIP Code This column displays the ZIP Code of the customer.
Customer Country This column displays the resident country of the customer.
Customer EU Member This column states whether the customer's country is a member of the EU Union.
Basis Subject to Tax This column displays the amount that on the invoice is subject to tax. This is the foundation for calculating tax.
Tax Code This column displays the tax code applied for calculating the tax.
Tax Amount This column displays the tax amount related to the tax code.
Tax Non-deductible This column displays the tax amount that is non-deductible.
Tax Deferred This column displays the tax amount that is deferred.
Tax Total This column displays the amount including tax. It is calculated as: Subject to Tax plus Tax Amount minus Tax Non-Deductible minus Tax Deferred.

Vendor Turnover

Top-Level Header Header Title Description
Vendor No. This column displays the vendor number of the invoice.
Vendor Name This column displays the vendor name of the invoice.
Vendor Tax No. This column displays the vendor Tax No.
Vendor ZIP Code This column displays the ZIP Code of the vendor.
Vendor Country This column displays the resident country of the vendor.
Vendor EU Member This column displays whether the country of the vendor, is member of the EU Union.
Basis Subject to Tax This column displays the amount that on the vendor invoice is subject to tax; i.e., the foundation for calculating tax.
Tax Code This column displays the tax code applied for calculating the tax.
Tax Amount This column displays the tax amount related to the tax code.
Tax Non-deductible This column displays the tax amount that is non-deductible.
Tax Deferred This column displays the tax amount that is deferred.
Tax Total This column displays the amount including tax. It is calculated as: Subject to Tax plus Tax Amount minus Tax Non-Deductible minus Tax Deferred.