AP: Use Tax Due Report
Overview
This report details all purchase amounts by Use Tax Code that should have been taxed for the invoice date range specified. These taxable purchases were indicated when invoices were entered. This is helpful when preparing your monthly or quarterly Sales and Use Tax returns.
If you print a Summary Report Type, each City will print along with the total taxable purchases for each county within the city, and the total for the city.
If you choose to print in Detail, each Vendor and its invoices will print for each city with the invoice date, number, amount, taxable purchases, and County/State. Each county will be subtotaled. The report will default to print in Detail.
If you select the Detail Report Type, you also have the option to include a recap of the invoice General Ledger distribution information on the report.
Key Functionality
Type a description to name the report. This description prints above the Report Title.
Available for Clients using the Multi-Company feature. The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies you have permission to access.
- If the User has permission to only one company, then just that one company will display in the list.
- If the User has permissions to more than one company, the list will contain all companies the User has rights to PLUS the default reporting company.
When the Group By Company option is selected, the default company prints on the Grand Total Page and the Report Criteria page. All other pages print the applicable company name. When the Group By Company option is NOT selected, the default company prints on every page of the report.
For more information see Learning about WinTeam Reports.
Use the Report Type option to choose the level of detail for the report.
- If you print a Summary Report Type, each City will print along with the total taxable purchases for each county within the city, and the total for the city.
- If you choose to print in Detail, each Vendor and its invoices will print for each city with the invoice date, number, amount, taxable purchases, and County/State. Each county will be subtotaled. The report will default to print in Detail.
If you select the Detail Report Type, you also have the option to include a recap of the invoice General Ledger distribution information on the report.
Invoice Dates
Use the Invoice Dates category to filter the report criteria by invoice dates.
Select All to include all invoices regardless of the invoice date.
Select Date Range to define a range of dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field, or use the Date Control to select a date.
Posting Dates
Use the Posting Dates category to filter the report criteria by posting dates. Payments that are marked as Use Tax Due (Applied to Expenses) will also be picked up if the Check Date is within the Posting Date range entered.
Select All to include all invoices regardless of the posting dates.
Select Date Range to define a range of dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field, or use the Date Control to select a date.
Tax Codes
Use the Tax Codes category to select the Use Tax Codes to include on the report.
Use Tax Codes are defined on the Use Tax Codes add/edit list.
Select All to include all Use Tax Codes.
Select Pick > to define specific Use Tax Codes for the report. When you select Pick, a list of Use Tax Codes display. Select the check box next to each Use Tax Code to include on the report.
Vendors
Use the Vendors category to select the Vendors to include on the report. (On the HR: and INS: Benefit Insurance/Other Analysis Reports, this Category is available when the Report Type is Vendor Billing.)
Select All to include all Vendors.
Select Range to define a range of Vendors for the report. When you select Range, the range fields display. Type the beginning Vendor Number in the From field and the ending Vendor Number in the to field, or use the Lookup to locate the Vendor Number.
Select Pick to define specific Vendors for the report. When you select Pick, the Vendor list displays. Select the check box next to each Vendor to include on the report.
Select Create to define your own list of Vendors. When you select Create, a small grid displays to the right. Enter the Vendor Numbers you want to include in the list, or use the Lookup to locate the Vendor Numbers.
Select Exclude to identify records that should not be included. When you select Exclude, a small grid displays to the right. Enter the Vendor Numbers you want to exclude in the list, or use the Lookup to locate the Vendor Numbers.
Companies
The Company Pick option filters for AR Invoice and Payment records. The Companies category is available for Clients using the Multi-Company feature.
Select the Companies to include on the report.
Select All to include all companies on the report.
Select Pick to define specific Companies for the report. When you select Pick, the Companies list displays. Select the check box next to each Company to include on the report.
Note: When running reports using the Company Category/Record Pick and the company name exceeds the maximum number of characters, WinTeam will truncate the name.
This option is available to users who have more than one company, but is not selected by default. If selected, the default company prints on the Grand Total Page and the Report Criteria page. All other pages print the applicable company name. If not selected, the default company prints on every page of the report.
Select the Include G/L Distribution check box to include a recap of the invoice G/L Distribution information on the report.
Select this check box to print the company logo on the report. It is selected or cleared by default based on the option selected in SYS:Defaults. However, you can modify the setting on each report.
Select this check box to include a list of the report options selected for the report. The Report Criteria page includes any ranges specified and each Category/Record selection made for the report. This check box is cleared selected by default.
Preview
Click the Preview button (or use the shortcut key, ALT + V) to view the report before printing.
Click the Print button (or press ALT + P) to send the report to your default printer.
Export
Click the Export button (or press ALT + X) to export the report to a specified format. Reports may be exported to Adobe Acrobat (PDF), Excel, Comma-Separated Values (CSV), Grid View and E-mail (available for premise-based clients only).
Related Information
The AP Report Use Tax Due screen has its own Security Group, AP Report Use Tax Due.
The AP Report Use Tax Due screen is part of the AP;Reports ALL Security Group.
Tip: For more information see Security Groups Overview and Security Groups By Module.