Salesforce Fundraising and Operations Automation for United Way Simcoe Muskoka

United Way Simcoe Muskoka needed to extend Salesforce and the Nonprofit Success Pack to support complex fundraising, finance, call-center, payment processing, donor designation, and multi-organization workflows.

WebSolo supported the organization through a multi-year Salesforce enhancement engagement from 2016 to 2018. The work included fundraising data migration, Donor Choice payout automation, custom Batch Data Entry, Batch Payment Processing, accounting write-off automation, call-center workflow support, automated emails and PDF generation, and a multi-organization sharing model.

Success Story

Salesforce Fundraising and Operations Automation

Custom Salesforce and NPSP enhancements for fundraising, payment processing, donor designations, call-center workflows, data migration, and multi-organization operations.

Talk to us

Client Profile

Business Challenge

United Way Simcoe Muskoka relied on Salesforce and the Nonprofit Success Pack to manage fundraising, donor relationships, campaign activity, payments, and nonprofit operations. As the organization’s Salesforce usage expanded, several business processes required deeper customization than standard Salesforce or managed package functionality could provide.

The organization needed practical tools that could help staff process large volumes of fundraising and finance data, support donor designation and payout workflows, automate repetitive operational steps, and keep data properly segmented as more than one United Way organization worked within the same Salesforce environment.

• Support Salesforce fundraising data migration and cleanup from legacy source systems.
• Improve Donor Choice payout processing and audit visibility.
• Create custom tools for entering large batches of pledge and donation records.
• Improve batch payment processing and proportional payment allocation.
• Automate accounting write-off workflows for records with remaining balances.
• Support call-center and energy conservation program workflows.
• Generate PDF application documents and send automated emails to clients and delivery partners.
• Prepare Salesforce for a multi-organization model with more secure sharing and data segmentation.
• Support UAT, production deployment, post-deployment fixes, and metadata backup.

Key Requirements

• Load and validate Salesforce fundraising data, including accounts, contacts, affiliations, transactions, opportunities, and payments.
• Build a Donor Choice Payout Wizard to support campaign-year logic, agency designations, payout records, fees, partial payouts, and payment-to-payout tracking.
• Create a custom Batch Data Entry tool for workplace campaign pledge forms and high-volume opportunity entry.
• Replace or enhance older batch payment entry processes with a more robust Apex and Visualforce solution.
• Distribute payment amounts proportionally across open opportunities while preventing overpayments.
• Handle rounding differences so created payment totals matched cheque or EFT amounts.
• Support batches with large numbers of opportunity records.
• Create an accounting write-off wizard for selected opportunities with remaining balances.
• Support call-center workflows for LEAP, Energy Conservation, Winterproofing, and Weatherization processes.
• Prepopulate application data from contact-level household and housing information.
• Generate application PDFs and send automated email messages with the correct attachments.
• Update role hierarchy, sharing rules, organization-wide defaults, and Apex logic for a multi-organization operating model.

Delivered Solution

Salesforce Data Migration and Fundraising Foundation

WebSolo supported Salesforce data migration and fundraising data load activities, including review of upload tables, test loads, account and contact imports, affiliation logic, transaction mapping, payment records, and data cleanup.

The migration work helped prepare Salesforce for more reliable fundraising, payment, and donor management operations. Issues such as duplicate identifiers, payment mismatches, negative or zero values, and mapping differences between the legacy fundraising system and Salesforce were reviewed and addressed as part of the process.

Donor Choice Payout Wizard

WebSolo designed and implemented a custom Donor Choice Payout Wizard to help automate donor designation payout workflows.

The solution supported campaign-year-based processing, donor choice accounts, payment reductions, fee handling, payout records, partial payouts, full payouts, and write-off scenarios. A key part of the design was improving audit visibility by tracking the relationship between payments and payout records.

• Campaign-year filtering and payout selection.
• Donor Choice account and agency designation handling.
• Support for partial and full payout scenarios.
• Fee handling by campaign year.
• Payment-to-payout relationship tracking for audit support.
• UAT feedback, refinements, and production deployment support.

Custom Batch Data Entry

United Way Simcoe Muskoka received pledge forms from workplace campaigns and needed to enter many opportunities efficiently. The standard NPSP Batch Data Entry tool was helpful, but the organization needed more control over client-specific validation rules and data entry behavior.

WebSolo created a custom Batch Data Entry solution using Salesforce Visualforce and Apex. The tool allowed staff to create many related opportunity records in a controlled workflow while reusing common field values and supporting administrator-configurable layouts.

• Custom batch entry interface for high-volume opportunity creation.
• Support for workplace campaign pledge entry.
• Reusable pinned values for repeated fields.
• Field-set driven layouts for more flexible administration.
• Ability to create, edit, view, delete, and list batch-created records.
• Support for testing, user feedback, deployment, and post-deployment fixes.

Batch Payment Processing

WebSolo implemented a custom Batch Payment Processing solution to improve how payments were entered and allocated across multiple open opportunities.

The solution allowed users to select an account, campaign year, and transaction types, then distribute payment amounts proportionally across eligible opportunities. The logic prevented overpayment, handled remaining balances, and addressed rounding differences so the total created payments matched the original payment amount.

• Account and campaign-year based payment processing.
• Support for multiple transaction types.
• Proportional payment allocation across open opportunities.
• Payment amount override and remaining-balance handling.
• No-overpayment protection.
• Rounding-balance handling for cheque and EFT totals.
• Pagination and support for large opportunity batches.

Accounting Write-Off Process

To support finance and accounting cleanup, WebSolo created a custom write-off process for opportunities with remaining balances.

The write-off wizard allowed users to select an account and campaign year, review eligible opportunities, select records to write off, and create written-off payment records. This helped standardize the process and reduce manual work for accounting users.

• Account and campaign-year based filtering.
• Opportunity list with remaining balance review.
• Selectable write-off records.
• Creation of written-off payment records.
• Testing and production deployment support.

Call-Center and Energy Conservation Workflows

WebSolo supported Salesforce workflow enhancements for call-center and energy conservation programs, including LEAP Applications, Energy Conservation Program records, OESP Applications, Winterproofing, and Weatherization workflows.

The work included moving housing and household income values to contact-level data, then making those values available to application records without unintentionally overwriting user-entered information later. The solution also supported prepopulation and manual refresh behavior where required.

• Contact-level household and housing data support.
• Application prepopulation logic.
• Manual fetch or refresh behavior for selected records.
• Support for LEAP, Energy Conservation, OESP, Winterproofing, and Weatherization workflows.
• Delivery-agent assignment logic tied to address and program data.

Automated Emails and PDF Application Generation

WebSolo helped automate communication workflows by supporting email generation and PDF application attachment logic for different program scenarios.

The solution supported different messages and PDF documents for clients and delivery agents, including Home Winterproofing and Home Weatherization application flows. This helped reduce repetitive manual communication and made program delivery more consistent.

• Automated email workflow support.
• PDF application generation using Salesforce templates.
• Different message scenarios for clients and delivery partners.
• Template updates and testing support.
• Production deployment and validation.

Multi-Organization Sharing and Data Segmentation

As the Salesforce environment evolved, United Way Simcoe Muskoka needed to support multiple United Way organizations inside the same Salesforce org while keeping records properly segmented.

WebSolo helped implement a more secure multi-organization sharing model using role hierarchy updates, organization-wide default changes, user role assignments, and Apex logic updates. The work supported private or controlled access to key operational objects while allowing staff to continue using the custom fundraising tools.

• Multi-organization operating model support.
• Role hierarchy and user role updates.
• Organization-wide default sharing changes.
• Custom logic to associate new opportunity records with the appropriate United Way account.
• Updates to Batch Data Entry, Batch Payment Processing, Donor Choice, and Write-Off tools for the new sharing model.
• Full sandbox testing and production deployment support.

Deployment, UAT, and Production Support

Across the engagement, WebSolo supported requirements review, estimates, solution design, development, testing, UAT feedback, production deployment, post-deployment fixes, and Salesforce metadata backup.

The project was delivered through multiple workstreams over time, allowing United Way Simcoe Muskoka to continuously improve Salesforce while keeping the system aligned with day-to-day fundraising, finance, and program operations.

Project Timeline

Results and Benefits

The engagement helped United Way Simcoe Muskoka improve Salesforce as a practical operations platform for fundraising, finance, call-center, and multi-organization work.

• Improved Salesforce data quality through migration support and cleanup activities.
• Reduced manual work in Donor Choice payout processing.
• Improved audit visibility between payments and payout records.
• Created a custom Batch Data Entry experience for high-volume workplace campaign pledge entry.
• Improved batch payment allocation across multiple open opportunities.
• Reduced payment processing errors through no-overpayment and rounding logic.
• Standardized accounting write-off processing.
• Supported call-center and energy conservation application workflows.
• Reduced repetitive communication work through automated emails and PDF application generation.
• Enabled a more secure multi-organization Salesforce sharing model.
• Supported UAT, production deployment, post-deployment fixes, and long-term maintainability.

Platform and Technologies

• Salesforce
• Salesforce Nonprofit Success Pack
• Apex
• Visualforce
• Salesforce triggers
• Custom Salesforce controllers and controller extensions
• Salesforce tabs and custom pages
• Salesforce role hierarchy and sharing model
• Organization-wide defaults
• Salesforce data migration and ETL support
• Salesforce payment and opportunity automation
• PDF generation
• Automated email workflows
• Sandbox testing and production deployment

WebSolo Services Provided

• Salesforce Consulting
• Salesforce Implementation and Enhancements
• Custom Salesforce Development
• Salesforce Integration and Data Migration
• Salesforce Support and Training

Frequently Asked Questions

What type of Salesforce work did WebSolo perform for United Way Simcoe Muskoka?

WebSolo supported Salesforce and NPSP customization, fundraising data migration, Donor Choice payout automation, Batch Data Entry, Batch Payment Processing, accounting write-offs, call-center workflow support, automated emails, PDF generation, sharing model updates, testing, deployment, and production support.

Was this a standard Salesforce configuration project?

No. The engagement included significant custom Salesforce development using Apex and Visualforce, because several workflows required more control than standard Salesforce or managed package functionality provided.

Why was a custom Batch Data Entry tool needed?

The organization needed a high-volume opportunity entry process for workplace campaign pledge forms, with custom validation behavior, reusable field values, and flexible page layouts that matched its fundraising workflow.

What was the purpose of the Donor Choice Payout Wizard?

The Donor Choice Payout Wizard helped process donor-designated payments, campaign-year logic, fees, payout records, partial payouts, and audit visibility between payments and payouts.

Did WebSolo help with data migration?

Yes. WebSolo supported Salesforce data migration and cleanup activities involving accounts, contacts, affiliations, transactions, opportunities, payments, and mapping from legacy fundraising data into Salesforce.

Can WebSolo help with similar Salesforce nonprofit projects?

Yes. WebSolo can help nonprofit organizations customize Salesforce and NPSP, automate fundraising operations, migrate data, build custom payment and donation workflows, improve sharing models, and support long-term Salesforce enhancements.