The process of reconciling accounts and reporting them is outlined below.

The process of reconciling accounting and reporting accounts is essential for ensuring accuracy and transparency. By comparing financial records, such as bank statements and general ledger accounts, discrepancies can be identified and addressed. This process not only helps to prevent errors and fraud, but also provides valuable insights into the financial health of a business. It is important for companies to have a standardized reconciliation process in place and to regularly review and update it as needed.

The onus is on account holders to avoid overspending and reconcile their accounts regularly. To ensure accuracy, all departments must review their accounts periodically and confirm that transactions have been correctly posted. The financial reports available for viewing include Funds, Orgs, and Accounts, along with the Statement of Account, Statement of Account Detail, and Statement of Account Financial Summary Report, and the Transaction Detail Report. Additionally, the Dashboards dropdown under Budget Development now includes the Personnel Expenditures Report and Personnel Expenditures Detail Report.

How do I get a listing of all my accounts?

To obtain a record of your accounts, access the Accounts Available for Viewing report through the Reporting tab on My UNIverse. This can be found in the Financial Reports section, simply click on it to view.

I have a General Fund account; which report should I use to reconcile my account?

1. Account Summary - This document presents your financial status, including budget, expenses, commitments, and available balance. For further information on any item, use the Statement of Account Detail report to access a detailed view with just a click.
2. Activity Breakdown - Obtain a comprehensive record of all transactions made in your account. This feature is especially useful when reconciling multiple months of activity.

I have a Grant account; which reports should I use to reconcile my account?

To track your grant spending and balances, rely solely on the Accounting Financial Summary report provided by the Office of Research and Sponsored Programs. For a breakdown of your grant expenses, consult the Transaction Detail report.

I have a Non-General Fund (a.k.a. Auxiliary, Local Activity) account; which report should I use to reconcile my account? What is the balance in my account?

The Financial Summary report, accessible by inputting the fund number, provides the sole source of information for starting and concluding balances. For a comprehensive record of all account movements, refer to the Transaction Detail report. In case of further inquiries regarding any entries in the Transaction Detail, the Statement of Account report is equipped with drill down capabilities to facilitate item research, requiring only the fund number and a verification of all zeroes in the low segment and all 9's in the high segment.

The Launch Page - OBIEE

• Report on Account Status
• Overview of Finances
• Choose a Different Report
• Steps to Initiate Report
• Initiate Report by Investment

Single Fund
1. Use identical figures for both fund sections
2. Refrain from altering any values in the remaining account sections

Multiple Investment Accounts

1. Input the minimum and maximum amounts for the investment segments
2. Avoid modifying any figures in the other account segments.

Launch by Specific Account

1. Input identical figures for the low and high account sections.
2. Launch the activity for various accounts and funds by specifying the Fund, Org, Program, Function 00-99 and using a range.
3. To display all accounts and funds, enter the fund section.
4. To restrict the range, modify the relevant account segments.

Note: Enter fund range to view all non-general fund accounts.

The Org segment must be for the report to calculate the fund balance.

This launch page offers great flexibility. Since the reports are restricted to show only authorized information, minimal adjustments are needed to run them. Plus, most launch pages include helpful tips to make running the reports even more convenient.
Users can easily run a report for any fund by entering the fund code. To run a report for a specific account, simply modify the fund, organization, program, function, and activity codes. Running a report for all accounts is just a matter of selecting the period.
Jumping to another report is a breeze – just choose it from the drop-down menu at the top of the page. The Transaction Detail Report even lets you specify the range of object codes if needed. You can also find your fund balance, non-general fund accounts, statement of account, and financial summary with ease.

Statement of Account - Financial Summary

The Statement of Account Financial Summary report provides an efficient way to obtain your account's financial information. By entering only the fund, you can quickly access your starting and ending fund balance. It is vital to keep track of both your cash balance and fund balance for Non-General Fund accounts. To obtain your fund balance details, generate the Statement of Account Financial Summary report specific to your fund. You can view an illustrative example of the report output above.

To find your beginning Fund Balance:

Find the row labeled Unrestricted Net Assets and the column labeled Beg Balance Actual. It's important to note that in the provided illustration, a Fund Balance that appears to be positive is actually negative, and vice versa. Specifically, the starting Fund Balance is ($19,945.47).

To find your ending Fund Balance:

• * Locate the Fund Balance figure at the top of the report (ex: $18,953.83).
• * Here positives are positive and negatives are negative.
• * Fund balance reflects the beginning Fund Balance plus YTD Revenues minus YTD Expenses and Encumbrances.
• * As noted, Users will need to review this data in conjunction with Cash Balance (Cash & Cash Equivalents Ending Balance Actual - in the example above: $18,992.80

Free Balance (Budget Variance) for General Fund Accounts

Departments with General Fund Accounts are only able to spend what has been budgeted for them. You can find your budget variance (free balance) for your account by running the Statement of Account, and locating the TOTAL Budget Variance number.

Statement of Account

This report includes summary and detail information about each account, including revenues, and expenses.

• * By clicking Show Detail, users will see their Statement of Account by Object Code with the capability to drill down into many numbers including the current cash balance.
• * Users can "drill down" to view detail information for Purchase Orders, Requisitions, and Invoices (including check #, check date)
• * Click on Current Budget amounts to see beginning budget and any budget transfers
• * Encumbrance summary is available by clicking on the Total Encumbrance numbers

Transaction Detail

This report provides users with revenue and expense transaction details. While the user can define any period range, the report is typically run monthly and allows users the opportunity to review and verify all transactions for their accounts. The report is sorted by object code with totals for revenue and expense.

• * Does not include budget and encumbrance information
• * Can not expand across fiscal years
• * Can run the report for any range of object codes

Payroll Expense Report

This report is run by each biweekly and monthly pay period.

Includes:

• * Effective date, GL account code, UID, assignment number, employee name, salary element, and distribution amount.
• * Subtotals by object code.
• * Totals by account.

Budget Development (Personnel Expenditures Report)

This is a great report for reviewing salary savings. Personnel budgets, expenses and encumbrances are reported by budget line number.

• * Includes budget line number, employee name, object description, original budget, current budget, encumbrance, YTD actual, and line variance.
• * Capability to view the monthly detail information by budget line number.