The Sales Tax Reconciliation Report is a reporting and troubleshooting tool that lists taxable transactions and amounts by GL Code by Cost Center over a date range, with options for User ID, drawers and receipt numbers. This program allows you to view transactions where taxable information is in question. It provides an onscreen option as well as print options for .pdf and .csv. Results are displayed in three (3) separate DataGrids (on screen) and sections (.pdf/.csv):
- Sales Tax G/L Summary Information - Lists GL Distribution records flagged as sales tax records. They are summarized by GL and Cost Center code with totals at the bottom.
- Taxable Fees Paid Summary - Lists the total un-taxed fees paid, taxed fees paid, and tax paid by Fee. Selecting an applicable line item in this DataGrid will enable a third DataGrid labeled Un-Taxed Payment Details.
- Troubleshooting UnTaxed Fees Paid Details - Lists un-taxed payments by individual receipt numbers. Selecting one of these line items and clicking Print Un-Taxed Payment Receipt allows you to reprint that specific receipt.
RecTrac Process and Reporting screens offer numerous fields and widgets that allow you to filter the data for which your process or report is being run. RecTrac Widgets provides definitions and examples to show you how these work.
From the bottom of the screen…
Click View/Refresh Results to populate the DataGrids discussed above.
Note: VSI recommends using limited selection criteria when using this option. If your selection criteria are too broad, then the system will not populate the DataGrids and you will have to use the Process option to print results.
Custom Title - Enter a free form text in this field, if desired. The text you enter here will overwrite the default report title. Leave this field blank to accept the default title.
SalesTaxReconciliationReport_Tab
Begin Date (SalesTaxReconciliationReport_BeginDate)
Click the Calendar icon to select your beginning and ending transaction date range date option.
THEN
Take appropriate action in the right-hand column to specify the dates you wish to select. Transactions recorded during the date range entered will be included in the output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Date (SalesTaxReconciliationReport_EndDate)
Click the Calendar icon to select your beginning and ending transaction date range date option.
THEN
Take appropriate action in the right-hand column to specify the dates you wish to select. Transactions recorded during the date range entered will be included in the output.
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeletePrint Revenue G/L Info for Tax Eligible Fee Payment Summary records? (SalesTaxReconciliationReport_PrintRevenueGLInfo)
Select this option to have a Revenue GL Code column included on the Tax Eligible Fee Payment Summary section of the printable report (.pdf or .csv). This column displays how the revenue for the Fee was allocated. Typically this will be 100% to GL XXX." In the event you split your revenue across two or more GL Codes then the column will display each allocation percentage.
De-select this option to skip the printing of Revenue GL Code information on the report output.
DeletePrint Un-Taxed Fee Payment Detail Records for Troubleshooting? (SalesTaxReconciliationReport_PrintUnTaxedDetails)
Select this option to include payment information made toward Fees where no tax was charged. This is a troubleshooting option to help you identify instances where tax should have been charged on a Fee but was not.
Note: Payments made toward non-taxable Fees will also appear.
De-select this option to skip payment information toward non-taxed Fees.
DeletePrint Tax G/L Amounts for Tax Eligible Fee Payment Summary records? (SalesTaxReconciliationReport_PrintTaxGLInfo)
Select this option to have a Tax GL Code row included on the Taxable Fees Paid Summary Information section of the printable report (.pdf or .csv). This row displays how the tax for the Fee was allocated. Typically this will be 100% to GL XXX." In the event you split your tax revenue across two or more GL Codes then the column will display each allocation percentage.
De-select this option to skip the printing of Tax GL Code information on the report output.
DeleteBegin UserName (SalesTaxReconciliationReport_BeginUser)
Click the Picklist icon to select a range of User IDs, if desired. Transactions processed by Users within the range will be included in the output.
Set these fields <blank> to ZZZZZ to include all User IDs in the output.
DeleteEnd UserName (SalesTaxReconciliationReport_EndUser)
Click the Picklist icon to select a range of User IDs, if desired. Transactions processed by Users within the range will be included in the output.
Set these fields <blank> to ZZZZZ to include all User IDs in the output.
DeleteBegin Drawer (SalesTaxReconciliationReport_BeginDrawer)
Enter a range of Drawer Numbers if desired. Transactions processed to Drawers within the range will be included in the output.
Set these fields 0" to "9999999" to include all Drawers in the output.
DeleteEnd Drawer (SalesTaxReconciliationReport_EndDrawer)
Enter a range of Drawer Numbers if desired. Transactions processed to Drawers within the range will be included in the output.
Set these fields 0" to "9999999" to include all Drawers in the output.
DeleteBegin Receipt # (SalesTaxReconciliationReport_BeginReceipt)
Enter a range of ReceiptNumbers if desired. Transactions processed with Receipt Numbers within the range will be included in the output.
Set these fields 0" to "9999999" to include all Reciepts in the output.
DeleteEnd Receipt # (SalesTaxReconciliationReport_EndReceipt)
Enter a range of ReceiptNumbers if desired. Transactions processed with Receipt Numbers within the range will be included in the output.
Set these fields 0" to "9999999" to include all Reciepts in the output.
DeleteSales Tax GL (SalesTaxReconciliationReport_ttSalesTaxGLDataGrid)
This DataGrid lists GL Distribution records flagged as sales tax records. They are summarized by GL and Cost Center code with totals at the bottom.
DeleteTaxable Fees Paid (SalesTaxReconciliationReport_ttTaxableFeesPaidDataGrid)
This DataGrid lists the total un-taxed fees paid taxed fees paid and tax paid by Fee. Selecting an applicable line item in this DataGrid will enable a third DataGrid labeled Un-Taxed Payment Details.
DeleteUnTaxed Payments (SalesTaxReconciliationReport_displayUnTaxedPaymentsDataGrid)
This DataGrid lists un-taxed payments by individual receipt numbers. Selecting one of these line items and clicking Print Un-Taxed Payment Receipt allows you to reprint that specific receipt.
Delete