Summary

The Excise Tax Report will display a list of invoices filtered by Invoice Date and applies a user defined invoice cap amount and excise tax rate to those invoices. Committed and uncommitted invoices created in AP> Invoices will display on the report.

The Excise Tax Report will only display the invoices of vendors that have the Excise Tax toggle checked on the Vendor Maintenance window (AP> Maintenance> Vendor> Details tab).

Step by Step

1     Open the Excise Tax window (AP> Reports> Excise Tax Report).

2     Complete the Print Options section.

• The From Date and To Date fields are used to filter the invoices that display on the report by invoice date. When creating an invoice (AP> Invoices), the invoice date is entered in AP> Invoices> Enter Invoices> Create a new invoice> Invoice Date field.
• Enter the excise tax rate in the Tax Rate field.
  • The Tax Rate will be multiplied by the taxable amount.
    • The taxable amount is the invoice amount after the Invoice Cap Amount field has been applied. If an invoice cap amount is not applied, the tax rate will be applied to all the vendor invoices included on the report based on the date range.
    • Taxes and handling added to the invoice will be included on the invoice amount (AP> Invoices> Enter Invoices> Create an invoice> Handling and Tax fields).
  • The report does not include any taxes paid on the invoice when calculating the excise tax.
• Enter an Invoice Cap Amount. This is an optional field.
  • The invoice cap amount sets the maximum amount that will be taxed on each invoice included on the report.
    • For example, if an invoice is $775 and the cap is set at $500, the tax will only be calculated on $500.
  • Taxes and handling charges applied to the invoice will be included in the invoice amount (AP> Invoices> Enter Invoices> Create an invoice> Invoice Information section> Handling and Tax fields).
• Select the tax entity you are generating the report for in the Tax Entity drop-down menu.
  • The selection in the drop-down menu will only affect the title of the report.
• Select a Report Type from the drop-down menu.
  • The Summary report will display the Invoice Number, Vendor Number, Vendor Name, Invoice Description, Invoice Amount, Taxable Amount, Total Tax and Grand Totals.
    • The Invoice Amount column will display the invoice amount included on the report. The invoice amount will not include taxes, but it will include shipping and handling.
    • The Taxable Amount column on the report will display the invoice amount after the invoice cap amount has been applied.
    • The Total Tax column will display the tax calculated on each invoice included on the report.
  • The Detail report will display everything included in the Summary report as well as the Invoice Date, Check Number, Check Date, and GL Account Number.

3     Print the report.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.