Accounting & Database Implementation Services
*SaaS stands for Software as a Service
SaaS Stack Implementation:
SaaS Stack Implementation Details
SaaS Stack Set-up & Shell Design
Configure vs. customize SaaS Stack to maximize stack programs and apps
Map org chart and governance structure in the database
Create security protocol that limits access to data
Migration of Scrubbed Data into new SaaS Stack
All historical revenue data
Two prior & current fiscal year expense data
Audit & 990 preparation
Programming & Development
Configure organization’s programming (events, courses, and other activities)
Analysis & Reporting
Determine what types of reports are needed by which departments
Configure reports and dashboards so that department heads can access relevant information with a few clicks
Automate reporting and train department heads to create new reports
SaaS Stack Components
|More Detail||More Detail||More Detail|
SaaS stack adds a web-based interface for clients to enter data and make purchases, and an accounting back-end to monitor financial transactions.
Front- and back-end can be added piecemeal.
Participants, patrons and non-profit staff enter data using apps
Data is automatically validated (e.g., using spellchecks, Google address checks, email checks, etc.)
Department heads review & edit data in the apps before it is uploaded to Salesforce
Transactions are uploaded directly from external programs into Salesforce
External organizations are responsible for server maintenance
Apps are continuously updated for Salesforce compatibility
Backups with Spanning
SaaS Stack Centerpiece
What is Salesforce?
Salesforce is a cloud-based CRM (Customer Relation Management) software that handles customer relationships, sales, and marketing. It is used to manage internal operations and programs, connects to external organizations, and keeps track of business processes and transactions in real time. Users can create dashboards and meaningful reports.
Useful Reads (optional):
Short Videos (optional):
What is Salesforce? (4 min)
15 Things about Salesforce (15 min)
Base is Salesforce.com
Non-Profit Cloud: Non-Profit Success Pack (NPSP)
Philanthropy Cloud: Volunteers
Education Cloud: Education Data Architecture EDA)
Free to non-profits
Use Apps from the Salesforce AppExchange
Choose task specific apps and add to the SaaS Stack
Configure vs. customize
Non-Profit Success Pack (NPSP)
What is the ?
Salesforce’s Non-Profit Success Pack (NPSP) offers additional key features including fundraising and donor management, program management and mission measurement, and marketing and engagement.
The NPSP ecosystem uses the familiar nomenclature and Salesforce structure, integrating smoothly with other Salesforce objects.
What is Volunteers for Salesforce?
The Volunteers App matches companies with volunteers through giving, corporate grants, fund disbursement, and collaboration & engagement.
Education Data Architecture (EDA)
What is the?
Salesforce’s Education Data Architecture provides a platform to administer the needs of educational institutions, like K-12 schools and universities.
The EDA ecosystem uses the familiar nomenclature and Salesforce structure, integrating smoothly with other Salesforce objects.
EDA manages the full student lifecycle, including recruitment, admissions, degree programing, registration, performance, progress throughout studies, and alumni relations.
EDA pack can be used to administer events and participation activities.
Clean Ledgers also configures the EDA pack to manage governance.
Configuration vs. Customization
Build custom objects using APEX code → requires a developer
Use native objects built by Salesforce
Max out of the box functionality of Salesforce
Native objects are continuously updated for Salesforce compatibility
Eliminates the need for programmers and developers
No programming necessary → non-profit staff can do it
WooCommerce provides an interactive website that integrates commerce with content.
WooCommerce integrates smoothly using the organization’s website theme.
Clients can make donations and/or purchase products and memberships via the user-friendly WooCommerce shopping cart.
Clients can enter data, fill out forms, and sign agreements. They can register for courses, sign up for events, and edit their personal account information.
WooCommerce Salesforce Integration
The power of Salesforce is leveraged by mapping WooCommerce variables and attributes to Salesforce objects and fields.
Syncs established by Actus Data
Expense Management Tools
Accounting Seed is an accounting software on the Force.com (Salesforce) platform, offers full revenue and expense integration
SAP Concur is an expense management SaaS that syncs with corporate credit cards
Paychex is preferred because of its general ledger mapping feature, but any payroll service can be used
Actus syncs Concur and Paychex with Accounting Seed (Paychex sync is only recommended for large organizations with complicated payroll journal entries)
Accounting Seed Advantages
Accounting Seed leverages the power of Salesforce to create stakeholder reports.
Data Configuration & Flow
Privacy Risks & Protecting Minors
Organizations are obliged to know/comply with data privacy/security laws
Potential liability if data on minors is lost, stolen, hacked/breached or misused
Federal law about the privacy of data collected on children
Federal Trade Commission (FTC) implements COPPA Rule
Safe Harbor Program self-regulatory compliance guidelines
Video about Google/YouTube allegations & settlement regarding data on minors
Questions to consider
Where is the line between data sharing and data breach?
What disclosures should be provided when data is collected?
Where and how is cloud data being stored? Is data “reasonably” secure?
Do employees have security clearance? Can they recognize phishing attacks?
Upload only “aggregated” data to national database
Store “encrypted” child data locally