marcumllp.com
Financial Management &
Accounting Software for Nonprofits
Featuring Sage Intacct
marcumllp.com
Presented by:
Buu-Linh Tran
Date
11/29/18
2
0914000N
What’s on tap
Introduction & Agenda
Grant Management Requirements
Field Office Challenges
Federal Reporting and Compliance
Introduction to Sage Intacct
Intacct –Grant Management Solution
Demo
3
0914000N
NASBA Requirements
Learning Objectives
Identify accounting and compliance challenges faced by Nonprofits
Sage Intacct’s powerful grant management capabilities
Sage Intacct software overview
NASBA Essentials
Course Update Date: 8/6/18
Course Review By: Glenn Anstead
Course Reviewed Date: 8/6/18
NASBA Field of Study: Information Technology
4
0914000N
Mutual Introductions
Who’s in the room?
Your name and organization
Size of organization
Current accounting system
Challenges & concerns with current system(s)
What would your ideal accounting system look like
Raffa
Seth Zarny, Partner
Buu-Linh Tran, Senior Manager
Jeremy Taro, Business Development Manager
5
0914000N
Nonprofit & Social Sector Overview
Our mission is be a catalyst for positive, systemic change in our communities.
Leading consulting firm in the Mid-Atlantic
Support over 2,000 Nonprofit clients
300+ specialists on staff at all levels
Support over 300 Financial System Clients
Certified System Consultants, Certified Project Management Professionals,
Business Process Consultants
34 years serving DC, MD & VA
19 partners, including 12 women partners
Women-owned firm
Multi-cultural with diversity at all levels
Member Affiliations: Leading Edge Alliance, AICPA, ASAE, GWSCPA
6
0914000N
Nonprofit & Social Sector Overview
Wide Range of Services
Technology Solutions
ERP & Accounting Systems Consulting & Implementation Services
Software Development
Managed IT Services & CIO Advisory
Audit and Tax
Managed Accounting Services
HR Consulting
Business Advisory
Employee Benefit Plans
Search and Transition Services
Nationally Recognized
Top 100 Largest Accounting Firms
Top 100 ERP VAR (Bob Scott & Accounting Today)
Top 100 and Fastest Growing Value Added Reseller
7
0914000N
Grant Requirements
Tracking non-financial data
Grant Financial Management (over or under budget)
Financial Reporting
Global Consolidation
Donor Reporting
Allocation of Overhead
Release restricted funds
Grant Billing
Fixed Price
Time and Material
Cost plus fee
8
0914000N
Field Office Requirements
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, Budget code, and More
Documentation
9
0914000N
Federal Reporting & Compliance
Identify tools to assist with federal reporting
FASB 116 -Accounting for contributions
ASC 958 -Financial statements for NonProfitOrganizations
Segregation and auditing of uses and sources of funds
501(c)(3) charitable vs. non-exempt activities
SF-425 Reporting
IRS Forms 990, etc.
10
0914000N
Sage Intacct Overview
Best in class financial management system
True Software-As-A-Service (SAAS)
Local Partners
Annual Subscription Costs
Preferred provider of the AICPA
Strong Financial & Accounting Functionality
Outgrowing QuickBooks
Nonprofit Focus
Public Charities
Private Foundations
Membership & Trade Associations
Public Charter Schools
International NGO’s
Business Process Automation
Multi-company / Multi-entity / Multi-currency
Consolidations
Superior financial reporting and dashboards
11
0914000N
Sage Intacct Overview
Very satisfied client base (Over 12,000 Clients)
Our clients range from $3M -$200M in budget/revenue
Employee sizes from 10 –1,000+
World-class Data Center operations
99.992% availability for 2017
Industry leading SLA’s
SSAE 16 Audited & PCI DSS Compliant / Successful DCAA Audits
12
0914000N
Sage Intacct Partner Ecosystem
13
0914000N
Sage Intacct Demo
Overview & Dimensions
Financial Reports & Dashboards
Grant Reports
Global Consolidation
Donor Reports by Budget Code
Grant Management –Financial and Non Financial Data
Allocations (Fixed vs. Variable)
Release of Restricted Funds
Timesheet, Expense Report, Purchasing
Billing (T&M and Fixed Fee & Expenses)
14
0914000N
Sage Intacct Dimensions
DIMENSIONS
Customer
or Funder
Vendor
Employee
Entity
Department
Project
Program
Grant
Class
Item
Who?
Where?
What?
Collect key
data for
analysis
15
0914000N
Fringe Calculation
16
0914000N
Fringe Allocation
17
0914000N
Timesheet Approvals
18
0914000N
Expense Report Approvals
19
0914000N
Purchasing Workflow
20
0914000N
Consolidated Report Notification
21
0914000N
Percent Complete Billing
Based on the percent of the project completed at a given time, i.e. If percentages for billing
are specified, invoicing will take place only when those percentages are reached
If no percentages are listed, then the percent completed to date at the time you generate
the invoice, will be billed
Can be applied at either the Project or Task level
22
0914000N
Milestone Billing
Enter Sales Order with Billing Template, Project and Task for full contract amount, i.e.
$200,000
Billing Template –50%, 40% then 10% Based on Estimated Hours (145 hours)
Enter Time against Project and Task (hours)