Receipt Report

The Receipt Report allows users to review information pertaining to receipts generated via the Student Billing and the Purchase & Pay screens. Depending on the amount of information required for review, two different receipt reports are available: The Receipt Report and the Detailed Report, which includes Debit and Credit Account information, Allocation Amount, and more.

Generating the General Report

1. In the Billing menu, click Receipt Report.

Receipt Report

The General Report tab is opened by default.

Receipt Report

2. Before generating the report, be sure the correct fiscal year is selected from the pull-down. The fiscal year defaults to the current year.

Receipt Report

3. Select the Voided check box to include voided receipts in the report.

4. Select the Internal Accounts check box to include receipts that are linked to an internal account.

Receipt Report

5. To include receipts printed over a specific Receipt Date Range, enter the start and end date in the two provided text boxes.

6. To include receipts created over a specific date range, enter the start and end date in the Created Date Range text boxes.

7. To pull receipts that are linked to a specific Debit Account or Credit Account, select the applicable accounts from the corresponding pull-downs.

8. To include receipts generated as a specific Payment Type, select the type of payment(s) from the corresponding pull-down, such as Cash, Credit, Check, etc.

9. To include receipts generated for a specific Amount of money, enter the dollar amount in the provided text box.

10. To filter the report by a specific Invoice #, enter the number in the provided text box.

11. To filter the report by a specific Receipt #, enter the number in the provided text box

Receipt Report

12.To filter the General Report based on accounting strip elements, such as a specific Fund, Center, etc., enter the element code in the applicable text box. You can filter by as many elements as needed.

Receipt Report

To conduct a search of accounts, click the Account Lookup button. This opens a pop-up window giving you the ability to search through all available elements and corresponding codes and descriptions.

Receipt Report

13. When all of the report criteria has been entered and/or selected, click Run Report.

Receipt Report

You have the ability to save your report before or after running the report. Click the floppy disk icon to name and save the report. In order to generate a saved report, from the Receipt Report screen, select the saved report from the pull-down; your report will generate automatically.

Receipt Report

a. You can also click the Trash Can icon to delete saved reports.

b. To edit a Report Name after saving, select the report, then click the Blue Arrow next to the Trash Can.

Receipt Report

The General Report displays the following columns: Receipt #, Transaction #, Receipt Date, Created Date, Fiscal Year, Customer name, Invoiced To, Invoices, Description, Created By, Deposit Date, Void Date, Reference Number, Payment Type, Amount, Ledger Balance, MJ #, and MJ Source & Amount.

Receipt Report

The columns displayed are included in the report; however, if you find specific columns unnecessary, you can remove columns by clicking Toggle Columns. To hide a column from the report, clear the selected check box. To include the column, select the check box.

Receipt Report
Detailed Report

1. In the Billing menu, click Receipt Report.

Receipt Report

2. Click the Detailed Report tab.

Receipt Report

3. Before generating the report, be sure the correct fiscal year is selected from the pull-down. The fiscal year defaults to the current year.

Receipt Report

4. Select the Voided check box to include voided receipts in the report.

Receipt Report

5. Select the Internal Accounts check box to include receipts that are linked to an internal account.

6. To include receipts printed over a specific Receipt Date Range, enter the start and end date in the two provided text boxes.

7. To include receipts created over a specific date range, enter the start and end date in the Created Date Range text boxes.

8. To pull receipts that are linked to a specific Debit Account or Credit Account, select the applicable accounts from the corresponding pull-downs.

9. To include receipts generated as a specific Payment Type, select the type of payment(s) from the corresponding pull-down, such as Cash, Credit, Check, etc.

10. To include receipts generated for a specific Amount of money, enter the dollar amount in the provided text box.

11. To filter the report by a specific Invoice #, enter the number in the provided text box.

12. To filter the report by a specific Receipt #, enter the number in the provided text box

13. Select the Display Element Descriptions check box to display descriptions for applicable elements on the report.

14. To filter the Detailed Report based on accounting strip elements, such as a specific Fund, Facility, etc., enter the element code in the applicable text box. You can filter by as many elements as needed.

Receipt Report

To conduct a search of accounts, click the Account Lookup button. This opens a pop-up window giving you the ability to search through all available elements and corresponding codes and descriptions.

15. When all of the report criteria has been entered and/or selected, click Run Report.

Cursor

You have the ability to save your report before or after running the report. Click the floppy disk icon to name and save the report. In order to generate a saved report, from the Receipt Report screen, select the saved report from the pull-down; your report will generate automatically.

a. You can also click the Trash Can icon to delete saved reports.

b. To edit a Report Name after saving, select the report, then click the Blue Arrow next to the Trash Can.

The Detailed Report displays the following columns: Receipt #, Transaction #, Receipt Date, Created Date, Fiscal Year, Customer name, Invoiced To, Invoices, Description, Created By, Deposit Date, Deposit #, Cashout Date, Cashout #, Void Date, Voided By, Receipt Amount, MJ #, MJ Source & Amount, Reference Number, Payment Type, Debit Account, Credit Account, Allocation Amount, Payment Amount, Refunded Amount, Type, and all applicable accounting strip elements, such as Fund, Function, etc.

Receipt Report

The columns displayed are included in the report; however, if you find specific columns unnecessary, you can remove columns by clicking Toggle Columns. To hide a column from the report, clear the selected check box. To include the column, select the check box.

If you see grayed out lines in the report, it means there are multiple lines of information that pertain to the same Receipt #.

Receipt Report
Receipt Reconciliation Report

The Receipt Reconciliation report is used as a reference for reconciling receipts in Focus.

1. In the Billing menu, click Receipt Report.

Receipt Report

2. Click the Receipt Reconciliation tab.

Receipt Report

3. Before generating the report, be sure the correct fiscal year is selected from the pull-down. The fiscal year defaults to the current year.

Receipt Report

4. To include receipts generated over a specific Date Range, enter the start and end date in the two provided text boxes.

Receipt Report

5. Select how you want the receipts to be sorted in the report from the Sorting pull-down; options include Fund then Customer or Customer.

6. Select the Exclude EFT Receipts check box to exclude receipts created as a result of an electronic funds transfer.

7. Select the Exclude Customers Not in System check box to exclude receipts generated for customers who aren't recorded in the system via ERP > Purchasing/Accounts Payable > Vendors/Customers or as a student.

8. To conduct a search of accounts, click the Account Lookup button. This opens a pop-up window giving you the ability to search through all available elements and corresponding codes and descriptions.

9. When all of the report criteria has been entered and/or selected, click Run Report.

Receipt Report

The Receipt Reconciliation report is broken down by customer, then Receipt #, Transaction #, Receipt Date, Description, Receipt Amount, MJ #, MJ Source & Amount, Debit Account, Type, and the applicable elements that make up the accounting strip.

Receipt Report

10. To print all sections of the receipt reconciliation at once, click Print All.

Receipt Report

11. Click the Download PDF link to download all sections of the receipt reconciliation to a PDF.

Receipt Report