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.
1. In the Billing menu, click Receipt Report.
The General Report tab is opened by default.
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.
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.
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
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.
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.
13. When all of the report criteria has been entered and/or selected, click Run 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.
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 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.
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.
1. In the Billing menu, click Receipt Report.
2. Click the Detailed Report tab.
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.
4. Select the Voided check box to include voided receipts in the 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.
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.
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.
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 #.
The Receipt Reconciliation report is used as a reference for reconciling receipts in Focus.
1. In the Billing menu, click Receipt Report.
2. Click the Receipt Reconciliation tab.
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.
4. To include receipts generated over a specific Date Range, enter the start and end date in the two provided text boxes.
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. Select the Internal Accounts check box to include internal accounts in the report.
9. 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.
10. Click Run Report.
The Receipt Reconciliation report is broken down by customer, then Receipt #, Transaction #, Receipt Date, Description, Receipt Amount, MJ #, MJ Source & Amount, Debit Account, Credit Account, Type, and the applicable elements that make up the accounting strip.
11. To print all sections of the receipt reconciliation at once, click Print All.
12. Click the Download PDF link to download all sections of the receipt reconciliation to a PDF.
