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 about the 6th business day ofthe next month)
  1. Log into “Campus Connection”
  2. Select “For Employees”
  3. Select “Reports”
  4. Select “Financials”
  5. Select current fiscal year’s report to open (i.e. “FINACTIVITY9”) by clicking on its blue document symbol
  6. Report opens in Excel (automatic when the browser has been “fooled”)
  7. Sort tab data (e.g. AP Detail, Journal Detail) by your preferences such as Journal Date.
  8. Save file using identifiable name (i.e. December 2008Fin Activity)
  9. Print the saved report
Accessing Telecommunications Reports (monthly telephone charges are itemized by each line assigned to the Dept ID)
  1. Log into “Campus Connection”
  2. Select “For Employees”
  3. Select “Reports”
  4. Select “Telecommunications”
  5. When then new window opens, select “Reports”

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 toensure each makes sense.

FINACTVTY9 STATEMENT OF ACTIVITIES

  • 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?)
  • Look for any missing entries
  • Review the Salary Cost Status Report for specific payroll data. Payroll data should be similar month-to-month unless there have been terminations, hires, or salary changes.

HR_CUREMP6 ACTIVE EMPLOYEES

  • Ensure that list of employee names is accurate and current
  • Full time tab
  • Part time tab

VAC_SICK9 VACATION SICK LEAVE BALANCES

  • Confirm vacation and sick hours used by employees
  • Accrual balances can be reviewed

GFTACTVTY9 BSR GIFT ACCOUNTING REPORTS

  • Donor Information
  • Date
  • Total

SCHOLRSHP9 SCHOLARSHIP REPORT

  • Itemized scholarship information
  • Student
  • Term
  • DeptID
  • Type of Scholarship

Reconciling Telecommunications

Review and compare monthly data to the FINACTIVITY report for accuracy

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, GeneralAccounting or to the Controller’s Office.

→ Question the transactions, especially if they don’t make sense to you.