Frequently Asked Questions (FAQ)
- Why does it take so long to see my cash deposits?
- An error was made and a deposit went into the wrong account. How can I get it corrected?
- How can I get more detailed information about the total revenue posted to my account?
- What is the revenue web application?
- I need detailed deposit data for several months of activity. Where can I get this?
- I'm in the Business Intelligence Account Summary dashboard but some of my revenue data is missing. Where is it?
- Where are the revenue transaction descriptions in BI?
- Overhead assessments are not up-to-date on my account. When will I see this?
1. Why does it take so long to see my cash deposits?
All deposits are processed in the Student Accounts office. On the 15th and 31st of each month a revenue summary report is generated in Banner identifying the total of all deposits made to each account for the previous 15 days. Revenue Accounting reviews this report and subsequently enters the revenue information into the SUNY Financial System.
As this revenue summary report is only run on the 15th and 31st of the month, deposits will only be able to be viewed in your account after that time. For example, a deposit receipted into Banner on March 3rd will not be posted in your account until after the revenue summary report is run on March 15th. This is a system limitation and is not due to a delay by Revenue Accounting.
2. An error was made and a deposit went into the wrong account. How can I get it corrected?
Contact either Student Accounts or Revenue Accounting to explain the error and indicate the correct account. A transfer between the accounts will be processed.
3. How can I get more detailed information about the total revenue posted to my account?
Revenues are posted in the SUNY Financial System every 15 days at the revenue class level. The revenue web application can be used to obtain additional detail at the Banner receipt number level for department deposits and at the B number level for those items billed and collected by Student Accounts.
4. What is the revenue web application?
The revenue web application is an internally developed application which enables you to obtain revenue data at the receipt number level for department deposits and at the B number level for those items billed and collected by Student Accounts. The sum of this detailed data ties out with the 15-day revenue cycle transactions you see posted to your account. The data can be sorted within the revenue web application by using the toggle buttons to the right of each field heading (click the upward arrow to sort ascending; click the downward arrow to sort descending). It can also be exported to a spreadsheet by clicking the 'save as csv file' link.
In the 'Detail Code' module, you must select the detail code and 15-day revenue cycle for which you would like detailed information.
In the 'IFR Account' module you must select the account number and 15-day revenue cycle for which you would like detailed information. The resulting data will include all detail codes and revenue classes for which you had activity in that account during that revenue cycle.
To request access to the revenue web application you must 1) have access to Business Intelligence and 2) submit a request with your PODS ID via email to Katie Keesler at firstname.lastname@example.org. You can navigate to the login page here https://secure.binghamton.edu/revrept/login.jsp.
5. I need detailed deposit data for several months of activity. Where can I get this?
One option is to use the revenue web application to export each revenue cycle to compile the necessary data.
Hyperion/ODS is another tool that can also be used to extract detailed transaction data. The miscellaneous_transaction view is used to obtain non-billable detail code data (such as IFR deposits) and the receivable_account_detail view is used to obtain billable detail code data.
For more information on the process flow of collections data and how to extract transaction detail from Hyperion/ODS, please view the Tracking Collections Data powerpoint presentation.
6. I'm in the Business Intelligence Account Summary dashboard but some of my revenue
data is missing. Where is it?
If an IFR, SUTRA, or DIFR-IFR account is not sub accounted then all revenue will post to the parent account (xxxxxx-00). However if the account has been sub accounted, then all revenue will post to the xxxxxx-99 sub account. To view total revenue data make sure you use the six digit account number (excluding the two digit suffix) then click 'Apply' in Business Intelligence (BI).
If you have sub accounted after the fiscal year has begun, call the Revenue Accounting office for more help on how to view revenue data in BI.
7. Where are the revenue transaction descriptions in BI?
The SUNY Financial System does not permit transaction descriptions for deposits, revenue adjustments, or balance transfers and therefore this information is not included in BI.
Revenue transactions with a From Date and To Date covering a 15-day revenue cycle is deposit activity for which you can get more detail from the revenue web application. For example, if the From Date is 6/30/13 and the To Date is 7/15/13, access the revenue web application IFR Account module and select the associated account and revenue cycle to view the individual transactions which tie out with the BI posting.
When the From Date and To Date are only one day apart (for example, From Date is 7/10/13 and To Date is 7/11/13) and the revenue class is 18178, this is most likely a balance transfer requested by your department. These are manual entries processed by the Revenue Accounting office and an email confirmation is sent to the department representative upon completion of the transaction. Keep these confirmation emails to assist in reconciling your account.
8. Overhead assessments are not up-to-date on my account. When will I see this?
The SUNY Financial System posts overhead assessments on a monthly basis. It is typically posted on the 1st or 2nd of the month based on the revenue activity posted during the prior month.