Receipt Report
The Receipt Report allows users to review information pertaining to receipts generated via Receipt and Internal Account Receipts modules, as well as Point of Sale (POS). 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. From the Accounts Receivable menu, click Receipt Report.
2. Click the General 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.To filter the General 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.
14. 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.
15. Click the Receipt # link to open Accounts Receivable > Receipts or Internal Account Receipts.
16. When you hover over the Invoices column with the mouse, all linked invoices display; from here, you can click the desired Invoice link to open Accounts Receivable > Invoices or Internal Account Invoices.
17. Click the MJ # link to open Budgeting/General Ledger > Manual Journals or Internal Account Manual Journals.
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 #. In the example displayed, there are multiple manual journal numbers linked to the same receipt.
1. From the Accounts Receivable 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.
16. Click the Receipt # link to open Accounts Receivable > Receipts or Internal Account Receipts.
17. When you hover over the Invoices column with the mouse, all linked invoices display; from here, you can click the desired Invoice link to open Accounts Receivable > Invoices or Internal Account Invoices.
18. Click the MJ # link to open Budgeting/General Ledger > Manual Journals or Internal Account Manual Journals.
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 #. In the example displayed, there were multiple checks issued for the same receipt.
The Receipt Reconciliation report is used as a reference for reconciling receipts in Focus.
1. From the Accounts Receivable 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 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.
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.
10. Click the Receipt # link to open Accounts Receivable > Receipts or Internal Account Receipts.
11. Click the MJ # link to open Budgeting/General Ledger > Manual Journals or Internal Account Manual Journals.
12. To print all sections of the receipt reconciliation at once, click Print All.
13. Click the Download PDF link to download all sections of the receipt reconciliation to a PDF.
To navigate through the listed pages, click the Prev and Next buttons. To jump to a specific numbered page, type the number in the page text box and press Enter. Note: This option will not display if all data can be shown on one page.
Click the Excel icon in the Export section to export the table of data to an Excel spreadsheet, which can then be saved to your computer.
Click the Printer icon to print the table of data.
Click the Filters button to filter data and apply filter rules.
a. To add more than one filter to a column, click on the green plus sign.
b. To delete an added filter, click on the red minus sign.
c. Select the gray arrow for additional filtering rules.
For more information on how to use the Filters feature, see the Filters document.
You can also sort data by clicking on any of the headers. Click once for ascending results; click twice for descending results.
Use the Filter text box located in select pull-down to quickly find a selection. Begin typing the name or number of the data in question to pull it to the beginning of the list.
Click the Check all visible link to select all options in the pull-down. Click Clear selected to remove any selections made in the pull-down.
