Use Tax Liability Report
Use this report to determine the amount of use tax you owe to each tax authority for invoices you enter during a period. Payables defines Use Tax as the amount of tax a supplier should have, but did not, charge you for an invoice. You must enter a Use tax name(s) on invoice distributions for Payables to select the invoice in this report.
Payables determines the use tax liability for each use tax name by taking the tax rate you defined for each tax name and applying it to the sum of each invoice distribution with a particular tax name. Payables ignores Sales tax names in this report.
The report lists in summary or detail the total amount of tax you owe for each tax name on invoices you enter between two dates you specify when you submit the report. Payables displays the amount of use tax you owe in the currency in which you entered an invoice.
Report Submission
You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Selected Report Parameters
Currency Code. The currency of the invoices you want to select for the report.
Report Date Basis. Enter the date basis you want to use for selection of invoices for the report. You specify a range of dates using the Start Date and End Date report parameters. You choose from the following invoice dates:
- Entered. Invoices entered between the Start Date and the End Date.
- Invoice. Invoices with invoice dates between the Start Date and the End Date.
- GL. Invoice distributions that have a GL Date between the Start Date and the End Date.
Invoice Status. Invoice status of the invoices you want to include in this report. Payables lists use tax for invoices with the status you enter here:
- All. Payables lists use tax you owe for all invoices.
- Approved. Payables only lists use tax you owe for invoices which you have approved and are not on hold.
- Paid. Payables only lists use tax you owe for invoices that you have already paid.
- Posted. Payables only lists use tax you owe for invoices that you have already transferred to general ledger.
Report Ordered By. Enter your choice for ordering this report. Payables sorts the use tax information in the report first by tax name and then by one of the following methods:
- Invoice. Payables sorts the report by tax name and invoice date. If you order your report by invoice, you do not have the option to summarize the selected invoices.
- Supplier. Payables sorts the report by tax name, supplier, supplier site, and invoice date. If you order your report by supplier, you have the option to summarize the selected invoices.
Start/End Date. Payables lists the use tax you owe on all invoices with dates including and between the Start Date and the End Date.
Tax Name. If you want to submit the report for a single tax name, enter it here. To report on all tax names, leave this field blank.
Summarize. Enter Yes or No to indicate whether you want to summarize the information in the report. Payables summarizes the report only if you are ordering by supplier. If you summarize, Payables lists subtotals for each supplier site with no invoice details. If you do not summarize, Payables lists the amount of use tax you owe for every invoice, by invoice.
Selected Report Headings
Tax Name. Use tax name.
Tax Rate%. Rate of a use tax name. Payables validates the tax amount you enter on an invoice distribution against your invoice amount by comparing it with this rate. Payables validates the tax amount when you submit Approval.
Taxable Amount. Amount of an invoice subject to taxation. Payables lists the sum of all the distributions with a particular tax name.
Tax Liability. Amount of use tax you owe for an invoice. The tax liability is the amount that Payables calculates by applying the tax rate for the tax name to the sum of the invoice distributions with the tax name.
See Also
Common Report Parameters
Common Report Headings
Tax Names
Entering Taxes on Invoices
