2013-05-09 nonprofit financial management & accounting systems
DESCRIPTION
Raffa understands the challenges that Nonprofits, NGO's, and Associations face when it comes to providing grant tracking to funders and managers, managing multiple locations, and generating critical government financial reports. Sucessful management of a Nonprofit organization requires providing high-quality service, but at the same time, careful administration of expenses and improving processes are ongoing requirements. Spend more time securing grants and performing effective financial management with the right accounting system in place.TRANSCRIPT
![Page 1: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/1.jpg)
Thrive. Grow. Achieve.
NonProfit Financial Management & Accounting
Systems Seminar
Seth Zarny – Partner Buu-Linh Tran – Senior Manager Troy Minor – Senior Consultant Jeremy Taro – Business Development
Date: May 9, 2013
![Page 2: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/2.jpg)
WHAT’S ON TAP
INTRODUCTION & AGENDA
CHALLENGES (GRANTS MANAGEMENT)
GRANTS MANAGEMENT SOLUTIONS
• Non-Financial Information • Financial Information
FIELD OFFICE ACCOUNTING
FEDERAL REPORTING
DEMO (INTACCT & MICROSOFT DYNAMICS)
Page 2
![Page 3: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/3.jpg)
CHALLENGES - GRANTS
FINANCIAL REPORTING – MAINTAINING GRANT REPORTS/ DONOR REPORTS
TRACKING GRANT DOLLARS - MAINTAINING LARGE CHART OF ACCOUNTS
AVOID OVER SPENDING
GRANTS – TRACKING NON FINANCIAL INFORMATION & MANAGING GRANT INFORMATION
Page 3
![Page 4: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/4.jpg)
CHALLENGES – FIELD OFFICE
PEOPLE (PRIORITIES/CULTURE/AUTHORITIES)
TECHNICAL CHALLENGES
DIFFERENT PROCESSES
MULTICURRENCY
DIFFERENT SYSTEMS
LOCATIONS
SUPPORT/ FINANCIAL REPORTING
• Reporting to necessary stakeholders (Board of directors, Donors, executives, program managers, grants managers, etc.)
NONPROFITS MUST ACCOUNT FOR:
• Funds, Grants, Projects, Programs, and More
DOCUMENTATION
Page 4
![Page 5: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/5.jpg)
CHALLENGES WITH FEDERAL REPORTING & COMPLIANCE
IDENTIFY TOOLS TO ASSIST WITH FEDERAL REPORTING
• FAS 116 - Accounting for contributions • FAS 117 - Financial statements for NonProfit Organizations • Segregation and auditing of uses and sources of funds • 501(c)(3) charitable vs. non-exempt activities • IRS Forms 990, etc
Page 5
![Page 6: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/6.jpg)
TRACKING NON-FINANCIAL DATA
INTACCT PROJECT ACCOUNTING/ USER DEFINED FIELDS
MICROSOFT DYNAMICS GP GRANTS MANAGEMENT/EXTENDER
MICROSOFT DYNAMICS SL – PROJECT/GRANTS – ALLOCATIONS, MODIFIER
SHAREPOINT
FINANCIAL SYSTEM(S)
CUSTOM APPLICATION/ DATABASE
MS EXCEL / WORD
Page 6
![Page 7: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/7.jpg)
TRACKING FINANCIAL DATA
INTACCT
• Dimensions • Project Accounting Modules
DYNAMICS GP
• Chart of account (COA) – Track grant activities through segment of COA
• Analytical Accounting (AA) – Dimensions • Olympic – Use project to track grant transactions
DYNAMICS SL
• Project Accounting Series • Cost Allocations • Project, Tasks, Account Category • Indirect & Direct Rates, Provisional/Actual
Page 7
![Page 8: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/8.jpg)
SOLUTION – TRACK FINANCIAL DATA IN MS DYNAMICS GP, SL, & INTACCT
Features Chart of Account
Analytical Accounting
SL/Olympic Intacct
1.Track grant transactions X X X X
2. Track grant budgets for fiscal and grant period
X X X X
3. Prevent or provide warning when expenditure exceed grant revenue
X X (SL)
4. Track employee time against grant
X X (Only w/ Project)
5. Track employee expense against grant (web-based application)
X X (only w/ Project)
6. Bill against the grant X X X X (only w/ Project)
7. Management Reporter (FRx)/ Financial Reports by Project
X X X
8. Smartlist X X X
9. SSRS/ Custom report X X X X
10. Cost Allocations Moderate Moderate Extensive Moderate
Page 8
![Page 9: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/9.jpg)
PROS AND CONS
Solutions Pros Cons
Chart of Account
Easy to maintain (Accounting dept control over COA) No sub-ledger to manage Easy to create report using MR Can slice and dice segment for reporting Work with MR/ existing report writer
Long COA Not accommodate multiple year (grant yr vs. fiscal yr) Maintain old accounts forever Data entry Unable to handle complex grant requirement (time entry, complex allocation, etc.)
Analytical Accounting
Shorten COA Prevent charging expenditure in excess of revenue Work with MR/ existing report writer
Maintain sub-ledger / resource Separate screen for data entry Require reconciliation Additional training Additional configuration/setup
Olympic Project Accounting/ Dynamics SL
Shorten COA Track employee time and expense against grant Allows for sophisticated allocation Allows for sophisticated billing Sophisticated Costing – Direct/Indirect Rates
Maintain sub-ledger / resource Separate screen for data entry Additional training Additional configuration/setup Has separate reporting function
Intacct Project Accounting
Shorten COA Track employee time and expense against grant
Maintain sub-ledger / resource Require reconciliation Additional training Additional configuration/setup
Page 9
![Page 10: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/10.jpg)
FIELD OFFICE ACCOUNTING SUGGESTIONS
Challenges Suggestions People Establish and document field office accounting processes
Provide onsite training (processes/ system) Provide training @ home office (annually) Keep it simple (process/ accounting/ technology)
Technology Excel Remote access to GP & SL Other system (QB) Maintenance factor/ Lag time User’s background Leverage on GP & SL MC
Financial Report Report in local currencies (MR, SSRS) Easy access to reports
Documentation GP & SL – Leverages document management system integration Intacct - Document imaging is part of core product
Page 10
![Page 11: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/11.jpg)
FEDERAL REPORTING REQUIREMENTS
LEVERAGE MANAGEMENT REPORTER (MR) OR SQL REPORTING SERVICES (SSRS)
FORM 990
SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (SEFA)
FASB 117
Page 11
![Page 12: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/12.jpg)
FORM 990
Page 12
![Page 13: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/13.jpg)
Page 13
FORM 990 – MANAGEMENT REPORTER
![Page 14: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/14.jpg)
SEFA
Page 14
![Page 15: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/15.jpg)
Page 15
SEFA – MANAGEMENT REPORTER
![Page 16: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/16.jpg)
FASB 117
Page 16
![Page 17: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/17.jpg)
NONPROFITS USING INTACCT
Page 17
![Page 18: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/18.jpg)
NONPROFITS USING MICROSOFT DYNAMICS GP & SL
Page 18
![Page 19: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/19.jpg)
GRANTS MANAGEMENT
DEMO INTACCT
• Dimension • Project
MICROSOFT DYNAMICS GP
• Grants Management • Analytical Accounting • Olympic
Page 19
![Page 20: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/20.jpg)
Q & A
Page 20
![Page 21: 2013-05-09 Nonprofit Financial Management & Accounting Systems](https://reader034.vdocuments.us/reader034/viewer/2022052507/5581ac7bd8b42afd4c8b51a5/html5/thumbnails/21.jpg)
Page 21
THANK YOU!
Seth Zarny Direct: 301-279-6500 E-mail: [email protected] Buu-Linh Tran Direct: 301-279-6511 E-mail: [email protected] Troy Minor Direct: 301-279-6507 E-mail: [email protected] Jeremy Taro Direct: 301-279-6504 E-mail: [email protected]