Tax Analysis Tab of the Vendor Review Form

Use the Tax Analysis tab to see all of the tax amounts imposed on your company's transactions with a vendor. This data may help you identify the vendors who generate lower tax costs to your company.

This tab displays only if the Enable Tax Auditing Feature check box is selected on the Tax Auditing tab in Settings > Accounting > Company Settings. The Tax Analysis tab includes an inputs grid that shows information for all of the vendor's transactions that specify a tax code in one or more detail lines, match the criteria specified on the Vendor Options dialog box, and match the Excluded Prior To data on the Vouchers tab.

Contents

Inputs Grid

Field Description
Drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Invoice Date This field displays the date when the invoice was created.
Invoice This field displays the invoice number or description.
Voucher This field displays the number that DPS gives the voucher during the posting procedure.

If the voucher number has leading zeros, they display if the Display voucher number leading zeros check box is selected in Settings > Advanced Accounting > System AP.

Currency If you use multiple currencies, this field displays the transaction currency of the expense transaction.
Net Amount This field displays the amount entered in the voucher data entry file.
Tax Amount This field displays the tax amount entered in the voucher data entry file.
Amount This field displays the sum of the Net Amount and the Tax Amount.