Tax Analysis Report

Use the Tax Analysis report to review purchases, sales, and associated taxes.

You can also use this report to review originating vendor tax entries for employee expenses, AP vouchers, and AP disbursements.

This report is available only if you select the Enable Tax Auditing Feature check box on the Tax Auditing tab of the Accounting Company Settings form (Settings > Accounting > Company.

The report is available in My Stuff > Reporting (an Accounting report) and on the Review tab in Accounting > Tax File Generation in the desktop application.

Leading Zeros in Voucher Numbers

If your enterprise uses leading zeros in voucher numbers but you do not want to display the zeros on the report, clear the Display Voucher Number Leading Zeros option on the Accounts Payable tab of the System AP Configuration form (Settings > Advanced Accounting > System AP).

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, clear the Display Invoice Leading Zeros option in the Invoice section on the General tab of the Accounting System Settings form (Settings > Advanced Accounting > System).

Cash-Basis Setting

To run this report as a cash-basis report, you must select Cash-Basis Reporting on the Reporting tab of the Accounting System Settings form(Settings > Advanced Accounting > System).

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, DPS displays Retainage Billing in the Description column to identify the retainage invoices.

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

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 levels in the work breakdown structure 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 can see display net amounts, tax basis amounts, and tax amounts in any of the following currency types:

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

DPS 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.

Options Dialog Box

Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.