Summary
The Receipt Listing Report will display a filtered list of receipts with the receipt amounts grouped by payment type (cash, check, other), change returned on the transaction, net cash paid on the transaction and the total transaction. The report will not group the payments by pay method (CR> Maintenance> Pay method). When a pay method is selected on the Cash Entry window, the payment type attached to the selected pay method will be used to group the transaction amount on the report. Payment types are attached to pay methods in the Type drop-down menu on the Pay Method Maintenance window (CR> Maintenance> Pay Method).
If the Receipt Listing Report is generated in detail format, the detail line items on the receipt will display on the report.
Step by Step
1 Open the Cash Receipts Listing window (CR> Reports> Receipt Listing).
2 Configure the report.
- The Categories field is used to filter the receipt line items by the category code used to generate the receipt. Category codes are attached to receipts on using the Account/Category tab of the Cash Entry window.
- Only receipts created using a category code will have a category code associated with the receipt. If you select a category code in the Categories field only receipts generated by that category code will display in the report. Receipts generated without using a category code will not display on the report.
- If you select all of the category codes in the Categories field only receipts generated using category codes will display on the report.
- The category code will not display on the report. Only the type codes associated with the selected category code will display on the report.
- The Types field is used to filter the receipt line items that display on the report by the type code attached to the receipt. Type codes are attached to receipts using the Detail tab of the Cash Entry window.
- If the receipt was generated using a category code the type codes associated with the category code will be included on the report.
- Select the level of detail you would like to display on the report in the Report Type drop-down menu.
- The Summary option will display the receipt number, whether or not the receipt has been voided, customer account number, date, customer name and the dollar amounts by Cash, Check, Other, Change, Net Cash and Total.
- The Detail option will display all of the information on the summary version of the report plus the detail line items on the receipt on the report. The individual line items include the type code, line item description and the GL credit account on the line item.
- Some of the filters in the Cash Receipts Listing window will filter the report by receipt line item and others will filter the report by receipt. If you filter the report by a receipt line item but print the report in summary format, the entire receipt amount will display on the report, but only receipts that contain the filtered receipt line items will be included.
- Select the order in which information will display on the report in the Sort By drop-down menu.
- The Account Number field is used to filter the receipt line items that display on the report by the GL account number attached to them. The receipt line item will be included on the report if the GL account selected in the Account Number field is used as either the debit or credit account on the detail line item. Even when printing the Receipt Listing report in detail the report will only display the credit GL account attached to the detail line item, so the report will not display the GL account number if the GL account is the debit account on the receipt line item.
- Click the search icon next to the Account Number field to select a GL account from a list.
- The receipt line items will only display on the report if you print the report in detailed format.
- The Batch Number field is used to filter the receipts that display on the report by Cash Receipts batch.
- Click the search icon next to the Batch Number field to select a Cash Receipts batch from a list.
- The Receipt Number From and Receipt Number To fields are used to filter the receipts that display in the report by receipt number.
- The receipt number range is limited to 10,000 receipts to prevent system performance issues that can result from the report processing excessive amounts of data.
- The Receipt Date From and Receipt Date To fields are used to filter the receipts that display in the report by receipt date.
- The receipt date defaults to the current date when a receipt is created using the Cash Entry window. The receipt date will display in the Date field in the Receipt Information section of the Cash Entry window.
- If you only enter a receipt date in the Receipt Date From field, all receipts with a receipt date greater than the value in the Receipt Date From field will display on the report. The Receipt Date To field functions in a similar way; all receipts with a receipt date less than the value in the Receipt Date To field will display on the report.
- The receipt date range is limited to 95 days to prevent system performance issues that can result from the report processing excessive amounts of data.
- Select a commit status from the Commit Status drop-down menu to filter the receipts by commit status.
- Select Committed if only receipts in committed batches should display in the report. Receipts in batches that have not been committed will not display on the report.
- If a voided receipt is in a committed batch, the voided receipt will display on the report unless voided receipts are removed from the report using the Receipt Status drop-down menu.
- Select Committed if only receipts in committed batches should display in the report. Receipts in batches that have not been committed will not display on the report.
- Select a Receipt Status from the drop-down menu. The report can be configured to display Valid, Void or All Receipt Statuses.
- Select Void if you would like only voided receipts to display in the report.
- A VOID will display in the Void column of the report if you include voided receipts on the report.
- The Operator and Station drop-down menus are used to filter the receipts that display in the report by the station the receipt was created on or the operator that created the receipt.
- Operators are created and maintained on the Operators Maintenance window (CR> Maintenance> Operators).
- Stations are created and maintained on the Station Maintenance window (CR> Maintenance> Stations).
3 Print the report.
- Once the required report settings have been specified, click the Print button to print your report.
- Click the options section 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.
- 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.