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> Taxable toggle).  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 tab> Local Tax Percentage field) 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 tax columns.

Step by Step

1     Open the Use Tax window (AP> Report> Use Tax Report).

2     Complete the Print Options section.

• The Date From and Date To fields are used to filter the invoices that display in the report by check date.
  • Only committed and paid invoices will display on the report.
• The Local Tax Rate field cannot be modified from this window. The local tax rate is set up in the Setup window (AP> Utilities> Setup> General tab> Local Tax Percentage field).
• Check the New page for each state toggle to separate each state included on the report on a separate page.
• Check the New page for each city toggle to separate each city included on the report on a separate page.
• Check the List vendors toggle to include the vendor information on the report. This will add a vendor column to the report that will display the vendor name.
• The State and City fields 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 tab> Mailing City and Mailing State fields). The values in the City field will populate based on the state selected in the States field. If there is more than one state selected in the State field, the All option will display in the City field. 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 the States field.
    • The Cities field will populate with the cities of the vendors of the state selected in the States field.

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.