 |
Mobius Reconciliation Tips
DePaul’s budget managers serve a critical role in ensuring financial responsibility with university funds. Budget managers must make sure that all transactions recorded in a department’s reports are accurate and legitimate. A monthly review of Mobius reports is an essential way to monitor internal financial controls.
Below is a list of tips for reconciling Mobius (the university’s financial activity reports):
Accessing Mobius Reports (month-end reports are available by the 10th day of the next month)
- Log into “Campus Connection”
- Select “For Employees”
- Select “Reports”
- Select “Financials”
- Select current fiscal year’s report to open (i.e. “FINACTIVITY5”) by clicking on its blue document symbol
- Report opens in Excel (automatic when the browser has been “fooled”)
- Sort by date (in an Excel spreadsheet, click on any cell that is located above the data cells on the report, click on “data,” then on “sort”)
- Save file using identifiable name (i.e. December 2004 report)
- Print the saved report
Reconciling Mobius
- Review and compare reports for accuracy (beginning with the FINACTIVTY report).
- For each report, a list of critical areas to review is provided. Scan the bulleted items to ensure each makes sense.
- FINACTIVTY_X (“Statement of Activity” summary)
- Recognize vendor names
- Ensure accuracy of dollar amounts paid to vendors
- Look for anomalies in reimbursements
- Look for any duplicate charges (should they be there?)
- Scan payroll dollar amounts for any changes (should match previous reports, unless there has been an employee termination, new hire, or change in salary)
- LBR/POS_X (transactions by position) – if applicable
- Ensure that list of employee names is accurate and current
- VAC/SICK_X (vacation and sick time used) – if applicable
- Confirm vacation and sick hours used by employees
- TELECOMM_X (Transactions by phone extension) – if applicable
- Ensure that telephone charges are reasonable
- Confirm that charges apply to employees in the department
- GFTACTVTY_X (donor activity) – if applicable
- SCHOLRSHP_X – if applicable
If there are inaccuracies in Mobius Reports:
Review source documents for transactions
- Receipts
- Purchase orders
- Invoices
Compare source documents to Mobius reports
REMEMBER:
- Report any inaccuracies to Accounts Payable, General Accounting or to the Controller's Office.
- Question the transactions, especially if they don’t make sense to you.
|
