Summary

The Use Tax Report displays the taxes paid in each state on AP invoice line items. The invoice line item must be set up as taxable and must be paid in order to display on the report. Uncommitted invoices or invoices being paid in an uncommitted Computer Checks batch will not be included on the report.

Invoice line items are set up as taxable using the Invoice Items window (AP> Invoices> Select Invoices> Open an invoice> Open an invoice line item>Taxabletoggle).If you use the Purchase Orders module, you can also set up PO line items to default to taxable. When invoices are generated using the POs, the invoice line items will be set up as taxable.

The report displays four columns: taxable purchases, tax paid, real tax and difference.

The taxable purchases column will display the total invoice line item amounts that were taxable. For example, if an invoice line item is purchasing an item of $35.00 and had a tax of $3.24 applied, the taxable purchases column will display $35.00.

The tax paid column will display the amount of tax paid on an invoice line item. For example, if an invoice line item is purchasing an item of $35.00 and had a tax of $3.24 applied, the tax paid column will display $3.24.

The real tax column will display the local tax rate (AP Utilities Setup General tabLocal Tax Percentagefield) multiplied by the value in the taxable purchases column. For example, if the taxable purchases column displays $15,000 and the local tax rate is 7.5%, the real tax column will display $1125 (15000 X .075).

The difference column displays the difference between the tax paid and the real taxcolumns.

Step by Step

1Open theUse Taxwindow (AP Report Use Tax Report).

2Complete the Print Options section.

• TheDate FromandDate Tofields are used to filter the invoices that display in the report by check date.
  • Only committed and paid invoices will display on the report.
• TheLocal Tax Ratefield cannot be modified from this window. The local tax rate is set up in the Setup window (AP Utilities Setup General tabLocal Tax Percentagefield).
• Check theNew page for each statetoggle to separate each state included on the report on a separate page.
• Check theNew page for each citytoggle to separate each city included on the report on a separate page.
• Check theList vendorstoggle to include the vendor information on the report. This will add a vendor column to the report that will display the vendor name.
• TheStateandCityfields are used to select which vendor invoices will be included on the report based on the mailing address on the vendor record (AP Maintenance Vendor General tabMailing CityandMailing Statefields). The values in theCityfield will populate based on the state selected in theStatesfield. If there is more than one state selected in theStatefield, the All option will display in theCityfield. You cannot select specific cities when more than one state is selected.
  • Check the toggles of the states you would like to include in the report in theStatesfield.
    • TheCitiesfield will populate with the cities of the vendors of the state selected in theStatesfield.

3Print the report.

• Once the required report settings have been specified, click the Print buttonto 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 iconnext 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 buttonon 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. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last three times the report was generated.