Docstoc

Fund Accounting Basics - Excel

Document Sample
Fund Accounting Basics - Excel Powered By Docstoc
					                                     6da8f161-1003-4bef-b9cb-b3fa501db86d.xls
Course Listings



            Bold/Italic = Certificate Courses                                   X = Certification Required

                                                                                     X = Attend Class


                                                                                       Finance
Course #    Course Name                                                        Length Specialist II

FIN 100     The Basics of Cornell Accounting                                    3 hrs.      X

FIN 101     Policy Considerations in the Accounts Payable Process               3 hrs.      X

FIN 102     Identifying Independent Contractors                                 3 hrs.      X

            The Mechanics of Preparing a Voucher (Endowed &
FIN 103     Contract College                                                    3 hrs.      X



FIN 104     Financial Stewardship and Compliance Issues at Cornell              3 hrs       X

FIN 105     Understanding Cornell Accounts and Object Codes                     3 hrs.      X

FIN 107     Travel Policies                                                     3 hrs.      X

FIN 108     Unallowable Costs                                                   3 hrs.      X


FIN 109     The MechanicsWanted to Know About Gift andTravel Vouchers 3 hrs.
            Everything You of Preparing Pre-Travel and Invested Fund                        X
FIN 110     Accounting                                                3 hrs.                X

FIN 111     How to Account for Your Capital Assets                              3 hrs.      X

FIN 112     The Mechanics of Preparing Accounting Journals                      3 hrs.      X
            Everything You Wanted to Know About Sponsored Funds
FIN 114     Accounting and Contracts                                            3 hrs.      X
FIN 116     Administrative Charges: Cost Allocation Model                       3 hrs

FIN 117     The Business Expense Policy Overview                                2 hrs       X

FIN 118     Determining the Indirect Cost Rate                                  2 hrs
FIN 119     Working with Statutory Project Codes and Project Reporting          3 hrs


FIN 120     Working with State and Federal Appropriations                       3 hrs       X
FIN 200     Managing Transactions Through Object Codes                          3 hrs       X

            Developing User Fees for Service Facilities and Recharge
FIN 201     Operations                                                          3 hrs
FIN 202     Reconciling Accounts and Transactions                               3 hrs.      X

Reporting


ADW 101     Using the Accounting Data Warehouse                                 3 hrs.      X

ADW 201     Ad-hoc Queries Using ADW                                            3 hrs.      X



Payroll
PAY 100     The Basics of Cornell Payroll                                       3 hrs       X

PAY 101     The Mechanics of Processing On-Cycle and Off-Cycle Forms            3 hrs       X

PAY 102     The Mechanics of Processing Labor Distribution Payroll Forms        3 hrs       X

PAY 103     COLTS Training for Pay Reps and Supervisors                         3 hrs       X

                                            Last Updated: 11/14/201010:02 AM
                                    6da8f161-1003-4bef-b9cb-b3fa501db86d.xls
Course Listings



           Bold/Italic = Certificate Courses                                   X = Certification Required

                                                                                   X = Attend Class


                                                                                   Finance
Course #   Course Name                                                     Length Specialist II

PAY 104    Treaty Benefit and Taxation for Foreign Nationals                   3 hrs       X




                                        Last Updated: 11/14/201010:02 AM
                                     6da8f161-1003-4bef-b9cb-b3fa501db86d.xls
Course Listings



           Bold/Italic = Certificate Courses                                    X = Certification Required

                                                                                     X = Attend Class


                                                                                    Finance
Course #   Course Name                                                      Length Specialist II

PAY 105    Working with Sale Tax at Cornell University                          3 hrs

PAY 106    Unrelated Business Taxable Income                                    3 hrs

PAY 107    Taxation & Wage Reporting                                            3 hrs

Cash Management
CSH 100    Handling Cash & Checks in the Cornell Environment                    3 hrs       X

CSH 101      Processing Credit Card Transactions and Reconcilliations           3 hrs
Purchasing

PUR 100    The Basics of Cornell Purchasing (pur 200-203 PART OF THIS)          3 hrs.      X

PUR102     APPS Limited & Detailed Inquiry                                      3 hrs.      X

PUR103     APPS Requisition Entry for Standard & Blanket Orders                 3 hrs.      X

PUR104     APPS Requisition Release/Approval                                    2 hrs.      X

PUR105     APPS Receiver Entry                                                  2 hrs       X

PUR106     APPS Change Orders & Blanket Order Renewals                          3 hrs.      X

PUR107     APPS Capital Assets                                                  2 hrs.      X

PUR108     Resolving APPS Problem Invoices                                      3 hrs.      X

PUR 109    Procurement Card Cardholder Training                                 1 hr.       X
PUR 110    Procurement Card Coordinator Training                      2 hr.                 X
           Everything You Wanted to Know About Purchasing Computers &
PUR 200    Computer Supplies                                          3 hrs.                X
           Everything You Wanted to Know About Purchasing MRO
PUR 201    materials & Supplies                                       3 hrs.                X
           Everything You Wanted to Know About Purchasing Scientific
PUR 202    Equipment & Supplies                                                 3 hrs.      X

           Everything You Wanted to Know About Purchasing Graphic
PUR 203    Printing                                                             3 hrs.      X



Web-Based Tutorials

WBT 100    ADW 2001                                                                         X

WBT 101    Brio On-line Tutorial                                                            X

WBT 102    The Journal Entry Management System (JEMS)                                       X

WBT 104    The Web-Req Project                                                              X

WBT 105    Colts Tutorials                                                                  X

WBT 106    Kronos Tutorials

WBT 107    Actuate Accounting Reports                                                       X

WBT 108    Payment Request (A/P)                                                            X




                                         Last Updated: 11/14/201010:02 AM
                           6da8f161-1003-4bef-b9cb-b3fa501db86d.xls




ation Required

end Class



        Accounts Rep III

                 X

                 X

                 X


                 X



                 X

                 X

                 X

                 X


                 X



                 X

                 X




                 X




                 X



                 X




                 X




                               Last Updated: 11/14/201010:02 AM
                           6da8f161-1003-4bef-b9cb-b3fa501db86d.xls




ation Required

end Class



        Accounts Rep III




                               Last Updated: 11/14/201010:02 AM
                           6da8f161-1003-4bef-b9cb-b3fa501db86d.xls




ation Required

end Class



        Accounts Rep III




                 X

                 X

                 X

                 X

                 X

                 X

                 X

                 X

                 X
                 X




                 X

                 X

                 X

                 X




                 X

                 X




                               Last Updated: 11/14/201010:02 AM
           Accounting Certificate Courses                 X = Certification Required
           Sponsored Programs Certificate training        Y = Required (not part of certification)
                                                          Z = Recommended


                                                                   BUSINESS SERVICE
                                                                        CENTER                       DEPARTMENT

                                                                                       Departmen
                                                                  Financial Financial t Business Financial Administrat
                                                                    Team    Transactio Administra Reporting     ive
Course #   Course Name                                    Length Leader n Specialist      tor     Specialist Assistant
FIN 100    The Basics of Cornell Accounting                3 hrs.     X         X          Y         Y           Z
           Policy Considerations in the Accounting
FIN 101    Process                                        3 hrs.       X            X                             Z
FIN 102    Paying for Services                            3 hrs.       X            X                             Z
           The Mechanics of Processing Payment
FIN 103    Requests                                       3 hrs.       X            X
           Financial Stewardship and Compliance Issues
FIN 104    at Cornell                                      3 hrs       X            X            Y        Y       Z
           Understanding Cornell Accounts and Object
FIN 105    Codes                                          3 hrs.       X            X            Y        Y       Z
FIN 107    Understanding the Cornell Travel Policy        3 hrs.       X            X                             Z

FIN 108    Understanding Unallowable and Indirect Costs   3 hrs.       X            X            Y        Y       Z
           The Mechanics of Processing Travel
FIN 109    Reimbursements                                 3 hrs.       X            X
           Everything You Wanted to Know About Gift and
FIN 110    Invested Fund Accounting                       3 hrs.       X                         Y        Y
FIN 111    How to Account for Your Capital Assets         3 hrs.       X            X
           The Mechanics of Preparing Accounting
FIN 112    Journals in JEMS                               3 hrs.       X            X            Y        Y
FIN 113    Cost Sharing for Sponsored Agreements          3 hrs                                  Y        Y
           Accounting Certificate Courses                     X = Certification Required
           Sponsored Programs Certificate training            Y = Required (not part of certification)
                                                              Z = Recommended


                                                                       BUSINESS SERVICE
                                                                            CENTER                       DEPARTMENT

                                                                                          Departmen
                                                                     Financial Financial t Business Financial Administrat
                                                                       Team    Transactio Administra Reporting     ive
Course #   Course Name                                        Length Leader n Specialist     tor     Specialist Assistant
           Everything You Wanted to Know About Sponsored
FIN 114    Funds Accounting and Contracts                     3 hrs.       Y            Z            Y        Y
FIN 116    Administrative Charges: Cost Allocation Model      3 hrs        Y                         Y        Y
FIN 117    The Business Expense Policy Overview               2 hrs        Y            Y            Y        Y       Z
FIN 118    Determining the Indirect Cost Rate                 2 hrs                                  Y        Y
FIN 119    Financial Reporting on Organized Research          3 hrs                                  Y        Y
FIN 120    Working with State and Federal Appropriations      3 hrs                                  Y        Y
FIN 121    Managing Agency Funds                              3 hrs                                  Y        Y

FIN 200    Managing Transactions Through Object Codes          3 hrs       X            X            Y        Y       Z
           Developing User Fees for Service Facilities and
FIN 201    Recharge Operations                                3 hrs                                  Y        Z
FIN 202    Reconciling Accounts and Transactions              3 hrs.       X            X            Y        Y
           More than you ever wanted to know about gift and
FIN 210    invested fund accounting (advanced class)                                                 Y        Y

Reporting
ADW 101 Using the Accounting Data Warehouse                   3 hrs.       X            X            Y        Y
ADW 201 Ad-hoc Queries Using ADW                              3 hrs.       Z                         Z        Z
           Accounting Certificate Courses                      X = Certification Required
           Sponsored Programs Certificate training             Y = Required (not part of certification)
                                                               Z = Recommended


                                                                        BUSINESS SERVICE
                                                                             CENTER                       DEPARTMENT

                                                                                           Departmen
                                                                      Financial Financial t Business Financial Administrat
                                                                        Team    Transactio Administra Reporting     ive
Course # Course Name                                           Length Leader n Specialist     tor     Specialist Assistant
Sponsored Programs
          An Introduction to Sponsored Programs
          Administration - Currently only open to financial
          job titles                                                                                  X        X

Risk Management and Insurance
          EverythingYou Wanted to Know about Risk
RMI 100   Management and Insurance                             3 hrs.       X            X            Y        Y       Z

Payroll
PAY 100    The Basics of Cornell Payroll - HR                   3 hrs
           The Mechanics of Processing On-Cycle and Off-
PAY 101    Cycle Forms - HR                                     3 hrs
           The Mechanics of Processing Labor Distribution
PAY 102    Payroll Forms                                        3 hrs                                 Z        Z

PAY 103    COLTS Training for Pay Reps and Supervisors - HR     3 hrs                                 Z
PAY 104    Treaty Benefit and Taxation for Foreign Nationals    3 hrs       Y            Y            Z        Z
PAY 105    Working with Sales Tax at Cornell University         3 hrs       Y            Y            Z
PAY 106    Unrelated Business Taxable Income                    3 hrs       Y            Y            Z
PAY 107    Taxation & Wage Reporting - HR                       3 hrs
           Accounting Certificate Courses                   X = Certification Required
           Sponsored Programs Certificate training          Y = Required (not part of certification)
                                                            Z = Recommended


                                                                     BUSINESS SERVICE
                                                                          CENTER                       DEPARTMENT

                                                                                        Departmen
                                                                   Financial Financial t Business Financial Administrat
                                                                     Team    Transactio Administra Reporting     ive
Course #   Course Name                                      Length Leader n Specialist     tor     Specialist Assistant


Cash Management

CSH 100    Handling Cash & Checks in the Cornell Environment 3 hrs       Y            Y            Z        Z
           Processing Credit Card Transactions and
CSH 101    Reconcilliations                                  3 hrs       Y            Y                             Z

Purchasing
PUR 100 The Basics of Cornell Purchasing                    3 hrs.       Y            Y
PUR102    APPS Limited & Detailed Inquiry                   3 hrs.       Y            Y            Z        Z
          APPS Requisition Entry and APPS Requisition
PUR103    Release Approval                                  3 hrs.       Y            Y
PUR104    APPS Requisition Release/Approval                 2 hrs.       Y            Y
PUR105    APPS Receiver Entry                               2 hrs        Y            Y

PUR106     APPS Change Orders & Blanket Order Renewals      3 hrs.       Y            Y
PUR107     APPS Capital Asset Training                      2 hrs.       Y            Y
PUR108     Resolving APPS Problem Invoices                  3 hrs.       Y            Y
PUR 110    Procurement Card Coordinator Training             2 hr.       Y            Y
           Accounting Certificate Courses                   X = Certification Required
           Sponsored Programs Certificate training          Y = Required (not part of certification)
                                                            Z = Recommended


                                                                     BUSINESS SERVICE
                                                                          CENTER                       DEPARTMENT

                                                                                        Departmen
                                                                   Financial Financial t Business Financial Administrat
                                                                     Team    Transactio Administra Reporting     ive
Course #   Course Name                                      Length Leader n Specialist     tor     Specialist Assistant
           Everything You Wanted to Know About Purchasing
PUR 200    Computers & Computer Supplies                    3 hrs.       Y            Y
           Everything You Wanted to Know About Purchasing
PUR 201    MRO materials & Supplies                         3 hrs.       Y            Y
           Everything You Wanted to Know About Purchasing
PUR 202    Scientific Equipment & Supplies                  3 hrs.       Y            Y
           Everything You Wanted to Know About Purchasing
PUR 203    Graphic Printing                                 3 hrs.       Y            Y

Web-Based Tutorials
WBT 100 ADW Tutorial                                                     Y            Y            Z        Z
WBT 101 Brio On-line Tutorial                                            Y            Y            Z        Z
WBT 102 The Journal Entry Management System (JEMS)                       Y            Y            Y        Y
WBT 104 COLTS II onlike Tutorial
         Actuate - Electronic Accounting Statements
WBT 105 Online Tutorial - NO LONGER APPLICABLE
WBT 106 Travel System Online Tutorials                                   Z            Z            Z        Z       Z
WBT 107 The Payment Request System Online Tutorial                       Z            Z
         Cardholder Training: Everything you need to know
WBT 108 about procurement cards                                          Y            Y

				
DOCUMENT INFO
Description: Fund Accounting Basics document sample