ReportOptionsHHPayCodeAuditReport_Tab
Pay Codes to Include (ReportOptionsHHPayCodeAuditReport_IncludePayCodes)
Click the Combo Box icon to select the Pay Codes you wish to include in the report output. Multiple selection is allowed. This is a Mandatory field for the default VSI RecTrac Design. Your Design and setup may vary.
THEN
Click the Combo Box icon for Pay Codes to SubTotal and make your selection(s).
Notes: VSI recommends selecting all Pay Codes in this field unless you are reporting on specific Pay Codes only.
Be sure to include your "VSI-System" Pay Code to report on payments made from a Credit Balance.
Pay Codes to SubTotal (ReportOptionsHHPayCodeAuditReport_SubTotalPayCodes)
Click the Combo Box icon to select the Pay Codes you wish to have subtotaled in the report output. Multiple selection is allowed. This is a Mandatory field for the default VSI RecTrac Design. Your Design and setup may vary. The Picklist contains only those Pay Codes you selected in the pay Codes to Include field.
Subtotaling Pay Codes provides a breakdown of the number of times each Pay Code was used.
- When running in Summary Option the report provides a single total of all subtotals provided the SubTotal Pay Codes Separately option is NOT enabled. For Example: The Pay Codes to Include are "Cash Check" and "VISA/MC." You opt to subtotal "Cash" and "Checks." Peter Bailey has five (5) transactions listed in the report. Each is for $100.00. One (1) is Cash Two (2) are Check and two (2) are VISA/MC. The report output will list five (5) transactions for $500.00 and three (3) sub totals that comprise 60% and $300.00 of the total.
Note: The SubTotal Pay Codes Separately field allows you to print a separate line for each Pay Code you choose to Sub Total. Refer to that field's definition.
- When running in Detail Mode (enabled the Print Detail option) the system will provide separate subtotals for each Pay Code you choose to subtotal. For Example: The Pay Codes to Include are "Cash Check" and "VISA/MC." You opt to subtotal "Cash" and "Checks." Peter Bailey has five (5) transactions listed in the report. Each is for $100.00. One (1) is Cash Two (2) are Check and two (2) are VISA/MC. The report output will list five (5) transactions for $500.00. It will then list the one (1) Cash transaction as comprising and 20% and $100.00 of the total and a second line for the two (2) Check transactions comprising 40% and $200.00 of the total. No such breakdown for VISA/MC will appear.
Modules to Include (Blank = All) (ReportOptionsHHPayCodeAuditReport_ModulesToInclude)
Click the Combo Box icon to select the Modules on which you wish to report. Multiple selection is allowed.
Optionally, you may leave this field at (0) Selected" to skip this field and report on all Modules.
DeleteSubTotal Pay Codes Separately (ReportOptionsHHPayCodeAuditReport_SubTotalSeparately)
Select this option to have the system subtotal each Pay Code in the Pay Codes to SubTotal individually. When this option is selected, the system provides a separate subtotal line for each Pay Code. This is true regardless of whether you run the report in Summary or Detail mode. For Example: The Pay Codes to Include are Cash Check" and "VISA/MC." You opt to subtotal "Cash" and "Checks." Peter Bailey has five (5) transactions listed in the report. Each is for $100.00. One (1) is Cash Two (2) are Check and two (2) are VISA/MC. The report output will list five (5) transactions for $500.00. It will then list the one (1) Cash transaction as comprising and 20% and $100.00 of the total and a second line for the two (2) Check transactions comprising 40% and $200.00 of the total. No such breakdown for VISA/MC will appear.
DeleteBegin Payment Date (ReportOptionsHHPayCodeAuditReport_BeginPayDate)
This range allows you to filter the report output by Transaction Date Range. Accept the default entry, or expand the Drop-down list and select your Begin Payment Date range for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date range.
If you are running this program manually, it is always safe to use Actual Date for these fields and your date range will be whatever you enter. If opting to Schedule this report, then consider using an alternate selection, such as Begin of Month."
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteEnd Payment Date (ReportOptionsHHPayCodeAuditReport_EndPayDate)
This range allows you to filter the report output by Transaction Date Range. Accept the default entry, or expand the Drop-down list and select your Begin Payment Date range for this report.
THEN
Take appropriate action in the right-hand column to specify the actual date range.
If you are running this program manually, it is always safe to use Actual Date for these fields and your date range will be whatever you enter. If opting to Schedule this report, then consider using an alternate selection, such as Begin of Month."
Refer to RecTrac Date/Time Select Fields for a listing of selection definitions and examples.
DeleteBegin UserName (ReportOptionsHHPayCodeAuditReport_BeginUser)
This range allows you to filter the report output by RecTrac User ID. Accept the default entry, <blank> to ZZZZZZZZ, or click the Picklist icons to select a range of User IDs. Transactions processed by a User ID within your range will be included in the output.
DeleteEnd UserName (ReportOptionsHHPayCodeAuditReport_EndUser)
This range allows you to filter the report output by RecTrac User ID. Accept the default entry, <blank> to ZZZZZZZZ, or click the Picklist icons to select a range of User IDs. Transactions processed by a User ID within your range will be included in the output.
DeletePrint Detail (ReportOptionsHHPayCodeAuditReport_PrintDetail)
Select this option to include separate line items for each Transaction listed on the report output.
THEN
Expand the Drop-down list for Detail Sort Option and make your selection.
When this option is selected, the report output skips the Pay Codes to SubTotal for each household and instead prints a separate line for each transaction. The line item includes the Household and Item Description as well as the Date, Pay Code and Receipt Number as determined by your Detail Sort Option.
Note: Debits and Credits are listed on the Report but the output does not offer a "Debit/Credit" column. Credits (i.e. payments to you) are listed as positive numbers. Debits (i.e. refunds to the household) are listed as negative numbers. For Example: A $50 Credit will be listed as "50.00" and a $50 debit will be listed as "50.00-."
Detail Sort Option (ReportOptionsHHPayCodeAuditReport_DetailSortOption)
This field is applicable only if you are opting to Print Detail.
Expand the Drop-down list to select your Sort Option for the report. When opting to Print Detail the report output skips the Pay Codes to SubTotal for each household and instead prints a separate line for each transaction. The line item includes the Household and Item Description. Your selection in this field determines how each line item is sorted.
- Date/Pay Code/Receipt# - by Date by Pay Code by Receipt Number.
- Pay Code/Date/Receipt# - by Pay Code by Date by Receipt Number.
Note: Debits and Credits are listed on the Report but the output does not offer a "Debit/Credit" column. Credits (i.e. payments to you) are listed as positive numbers. Debits (i.e. refunds to the household) are listed as negative numbers. For Example: A $50 Credit will be listed as "50.00" and a $50 debit will be listed as "50.00-."
Include FM Name (ReportOptionsHHPayCodeAuditReport_IncludeFMInfo)
This field is applicable only if you are opting to Print Detail.
Select this option to include the Family Member name linked to the transaction. For Example: Molly Jones enrolls her son Desi into a Beginning Archery program. The output of the report will display "Molly Jones" as the Household. The Detail Record will include the Item Description (Beginning Archery ) and "Desi Jones."
DeleteUse SubTotal Threshold (ReportOptionsHHPayCodeAuditReport_UseThreshold)
Select Use SubTotal Threshold option to filter the report by a threshold value.
THEN
Expand the Drop-down list for Threshold Option and make your selection.
THEN
Enter your Threshold Value.
- Amount - The report will filter by dollar amount. The subtotal amounts must meet or exceed the dollar amount you enter in order for a household to be listed on the report. For Example: Your Pay Codes to SubTotal is Check." You enter "500.00" in the Threshold Value field. Only those households with Check payment amounts meeting or exceeding $500.00 will be listed on the report.
- Amount - Percent - The report will filter by the percentage of transactions that include the Pay Codes by which you are subtotaling. For Example: Your Pay Codes to SubTotal is "Check." You enter "60.00" in the Threshold Value field. Only those households whose check transactions account for more than 60% of their total dollar amount will be listed. A household with two (2) transactions for a total of $150.00 one (1) by Cash for $100.00 and one (1) by Check for $50.00 would not be listed because 50.00 is only 33.33% of 150.00. A household with two (2) transactions for a total of $150.00 one (1) by Cash for $50.00 and one (1) by Check for $100.00 would be listed because 100.00 is 66.66% of 150.00.
- Count - The report will filter by Pay Code count. The subtotal counts must meet or exceed the number you enter in order for a household to be listed on the report. For Example: Your Pay Codes to SubTotal is "Check." You enter "10.00" in the Threshold Value field. Only those households with 10 or more Check payments will be listed on the report.
- Count - Percent - The report will filter by the percentage of transactions where the number of times the Pay Codes by which you are subtotaling were used meet or exceed the percentage threshold value you enter. For Example: Your Pay Codes to SubTotal is "Check." You enter "75.00" in the Threshold Value field. A household with three (3) transactions (one (1) Cash and two (2) Check) would not be listed because 2.00 is 66.66% of 3.00. A household with five (5) transactions (one (1) Cash and four (4) Check) would be listed because 4.00 is 80% of 5.00.
Threshold Option (ReportOptionsHHPayCodeAuditReport_ThresholdOption)
Select Use SubTotal Threshold option to filter the report by a threshold value.
THEN
Expand the Drop-down list for Threshold Option and make your selection.
THEN
Enter your Threshold Value.
- Amount - The report will filter by dollar amount. The subtotal amounts must meet or exceed the dollar amount you enter in order for a household to be listed on the report. For Example: Your Pay Codes to SubTotal is Check." You enter "500.00" in the Threshold Value field. Only those households with Check payment amounts meeting or exceeding $500.00 will be listed on the report.
- Amount - Percent - The report will filter by the percentage of transactions that include the Pay Codes by which you are subtotaling. For Example: Your Pay Codes to SubTotal is "Check." You enter "60.00" in the Threshold Value field. Only those households whose check transactions account for more than 60% of their total dollar amount will be listed. A household with two (2) transactions for a total of $150.00 one (1) by Cash for $100.00 and one (1) by Check for $50.00 would not be listed because 50.00 is only 33.33% of 150.00. A household with two (2) transactions for a total of $150.00 one (1) by Cash for $50.00 and one (1) by Check for $100.00 would be listed because 100.00 is 66.66% of 150.00.
- Count - The report will filter by Pay Code count. The subtotal counts must meet or exceed the number you enter in order for a household to be listed on the report. For Example: Your Pay Codes to SubTotal is "Check." You enter "10.00" in the Threshold Value field. Only those households with 10 or more Check payments will be listed on the report.
- Count - Percent - The report will filter by the percentage of transactions where the number of times the Pay Codes by which you are subtotaling were used meet or exceed the percentage threshold value you enter. For Example: Your Pay Codes to SubTotal is "Check." You enter "75.00" in the Threshold Value field. A household with three (3) transactions (one (1) Cash and two (2) Check) would not be listed because 2.00 is 66.66% of 3.00. A household with five (5) transactions (one (1) Cash and four (4) Check) would be listed because 4.00 is 80% of 5.00.
Threshold Value (ReportOptionsHHPayCodeAuditReport_ThresholdAmount)
Select Use SubTotal Threshold option to filter the report by a threshold value.
THEN
Expand the Drop-down list for Threshold Option and make your selection.
THEN
Enter your Threshold Value.
- Amount - The report will filter by dollar amount. The subtotal amounts must meet or exceed the dollar amount you enter in order for a household to be listed on the report. For Example: Your Pay Codes to SubTotal is Check." You enter "500.00" in the Threshold Value field. Only those households with Check payment amounts meeting or exceeding $500.00 will be listed on the report.
- Amount - Percent - The report will filter by the percentage of transactions that include the Pay Codes by which you are subtotaling. For Example: Your Pay Codes to SubTotal is "Check." You enter "60.00" in the Threshold Value field. Only those households whose check transactions account for more than 60% of their total dollar amount will be listed. A household with two (2) transactions for a total of $150.00 one (1) by Cash for $100.00 and one (1) by Check for $50.00 would not be listed because 50.00 is only 33.33% of 150.00. A household with two (2) transactions for a total of $150.00 one (1) by Cash for $50.00 and one (1) by Check for $100.00 would be listed because 100.00 is 66.66% of 150.00.
- Count - The report will filter by Pay Code count. The subtotal counts must meet or exceed the number you enter in order for a household to be listed on the report. For Example: Your Pay Codes to SubTotal is "Check." You enter "10.00" in the Threshold Value field. Only those households with 10 or more Check payments will be listed on the report.
- Count - Percent - The report will filter by the percentage of transactions where the number of times the Pay Codes by which you are subtotaling were used meet or exceed the percentage threshold value you enter. For Example: Your Pay Codes to SubTotal is "Check." You enter "75.00" in the Threshold Value field. A household with three (3) transactions (one (1) Cash and two (2) Check) would not be listed because 2.00 is 66.66% of 3.00. A household with five (5) transactions (one (1) Cash and four (4) Check) would be listed because 4.00 is 80% of 5.00.