Summary

The Receipt Listing by GL Report will display a filtered list of receipts grouped by GL account. If the 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 by GL window (CR> Reports> Receipt Listing by GL).

2     Configure 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 account number, account description and amount for each line item. A report total will also be provided.
  • The Detail option will display all of the information included in the summary version of the report as well as receipt number, void status, customer number, customer name, receipt date and line item description.
  • Some of the filters in the Cash Receipts Listing by GL 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 by GL 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 Account Number field label 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.
  • This is a required field. You must enter a full or partial GL account.
• The Batch Number field is used to filter the receipts that display on the report by Cash Receipts batch.
  • Click the Batch Number field label 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. Press DELETE to remove a date from the date range fields.
  • 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 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).
• 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.

3     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).