210 likes | 308 Views
A Fast and Easy Tool to Reconcile with CMS. CSU Academic Resources Conference April 1, 2009 Edith Winterhalter , Assoc. Budget Analyst Dan Vaughn, Administrative Analyst Vincent Chavez, Accounting Tech III CSU, Northridge. AGENDA. Getting to know the workbook
E N D
A Fast and Easy Tool to Reconcile with CMS CSU Academic Resources Conference April 1, 2009 Edith Winterhalter, Assoc. Budget Analyst Dan Vaughn, Administrative Analyst Vincent Chavez, Accounting Tech III CSU, Northridge
AGENDA • Getting to know the workbook • Demo on reconciling with the workbook • Questions and answers
What Is It? • University Financial Assistants (UFA) Reconciliation Workbook • Excel template • Uses VLOOKUP, pivot tables, formulas • Both a reconciling and a reporting tool • Works like a checkbook register
Why Use the UFA Reconciliation Workbook? • Streamlines processes • All-in-one requisition log and shadow spreadsheet • No double-entry • Accommodates multiple funds and departments • Accommodates multiple users • Ease in reconciling with CMS
Two Basic Components • CMS (PeopleSoft) Generated Reports = bank statement • General ledger summary • General ledger journal detail • Budget journal detail • UFA Reconciliation Workbook = checkbook register
UFA Reconciliation Workbook • All transactions with $ need to be entered in the workbook • All types of funds • General Fund, Trust, Lottery, IRA, Foundation, University Corp • All types of expenses • Payroll • Operating expenses • All budgets • All revenues • In short, EVERY TRANSACTION with $
Setting up the UFA MasterLog MasterLog
Expense Codes Updated MasterLog
Lookup Tables Sorts Data for Summary Report Account Name Account Code Lookup Tbls (2)
-80,256.33 Comparing Detail Report To PeopleSoft GL Summary UFA Reconciliation Workbook Detail Report CMS Summary Download
CSUN’s CMS Journal Detail Report The CMS Journal Detail Report
$71,281.33 Detail Report Balances to CMS Summary Report UFA Reconciliation Workbook Detail Report CMS Summary Download
Uses of the Workbook in a College • College or department level • Provides most accurate current status of ALL funds • Includes received and expected budget • Up-to-date and projected payroll figures • Actual expenses and planned expenses • Useful for financial analysis and planning • Answers financial questions
Contact Information • Edith Winterhalter • edith.winterhalter@csun.edu • 818-677-4066 • Dan Vaughn • daniel.vaughn@csun.edu • 818-677-5780 • Vincent Chavez • vincent.chavez@csun.edu • 818-677-3735
UFA Reconciliation Workbook Visit the CSUN UFA website at: http//www.csun.edu/academic.resources/UFA.html