Sales List Report

Use the Sales List report to review sales and associated taxes for the reporting period that you specify.

This report is available only if you select the Enable Tax Auditing Feature option on the Options form in Settings > Cash Management > Options.

Contents of the Report

The report includes only records for which the billing client for an invoice has an address entered in the Addresses grid on the Overview tab in the Firms hub, with both of the following settings applied for the address:

  • The Billing check box is selected (indicating that it is a billing address)
  • A tax country is entered in the Tax Country field

Cash-Basis Setting

To run this report as a cash-basis report, you must set Cash-Basis Reporting to Yes on the Options form in Settings > General Ledger > Options.

Retainage Invoices

This report shows retainage invoices that include tax amounts. Because the retainage invoice number is the same as the number of the original invoice from which it was withheld, Vantagepoint displays Retainage Billing in the Comments column to identify the retainage invoices.

The report does not show retainage invoices for which no taxes are due.

Leading Zeros in Invoice Numbers

If your enterprise uses leading zeros in invoice numbers but you do not want to display the zeros on the report, set the Display Invoice Leading Zeros option to No on the Options tab of the Accounts Payable form (Settings > Cash Management > Accounts Payable).

Multiple Companies

If you use multiple companies, only information for the active company is included in this report.

As a result, if you have projects for which lower work breakdown structure levels belong to companies other than the company that owns the project, billing transactions associated with those levels will not appear on this report when you generate it for the company that owns the project. To see those transactions, generate the report for the company to which the lower work breakdown structure level belongs.

Multiple Currencies

If you use multiple currencies, you have the option to have the report display tax basis amounts, tax amounts, and tax received amounts in any of the following types of currency:

  • Transaction currency: If you use the transaction currency, you also indicate if you want to include all currencies or only selected currencies; transactions on the report are limited to those with the transaction currencies that you specify.
  • Functional currency: The report displays the amounts in the functional currency of the active company.
  • Tax currency: This option is only available if tax auditing is enabled for the active company. If you use the tax currency, the report displays amounts in the currency specified for the tax code on the Tax Codes form. Normally, this is the currency in which the tax is reported and paid to the taxing authority.

If you choose to use tax currency, the report displays the amounts in the currency specified for the tax code on the Tax Codes form. Normally, this is the currency in which the tax is reported and paid to the taxing authority.

Vantagepoint stores amounts in these types of currencies when the transaction is posted. The amounts are calculated using the exchange rates in effect on the posting date.