Company overview
Ben Franklin Technology Partners of Northeastern Pennsylvania (Ben Franklin Northeast) is a nonprofit organization that helps Pennsylvania businesses grow through investment, business guidance, and strategic partnerships.
By providing early-stage technology companies and established manufacturers with access to capital, expertise, and connections, the organization helps businesses launch, grow, and compete. Its work has supported job creation and retention, advanced new technologies, and strengthened the regionβs economy.
Industry: Nonprofit
Customer Since: 2021
Products: Enterprise Suite
Features: Forms, Document Generation, Portals
Challenge
Ben Franklin Northeast manages investments and grants that require detailed reporting to the state. The team tracks funding, collects matching investment information, and reports outcomes such as jobs created and research and development spending.
Previously, the organization relied on a custom SQL Server system. As the team began migrating from SQL Server to Salesforce, it needed to preserve its existing reporting formats, including one-page project summaries that show grant amounts, investment totals, project goals, and projected outcomes.
The Annual Impact survey presented another challenge. For more than three decades, the organization mailed seven-page survey packets to clients, scanned completed forms, and manually entered responses into its database and Excel.
The process later moved to fillable PDFs, but employees still had to transfer responses into Salesforce. Clients also sometimes skipped important questions, requiring additional follow-up.
With approximately 160 surveys to collect by a fixed deadline, the manual process placed significant pressure on the employee responsible for annual impact reporting.
Preparing other client reports also required retrieving information from the previous database, while clients could take several weeks to return documents for finalization.
Ben Franklin Northeast needed a cost-effective way to manage nonprofit grant reporting in Salesforce, replace a fillable PDF with a Salesforce web form, and generate documents while preserving the reporting formats its board relied on.
Solution
Ben Franklin Northeast uses Titan Enterprise Suite to collect annual impact data from clients inside Salesforce, give clients secure access to their information, and generate documents using Salesforce data.
| Solution | Description |
| Salesforce Web Forms | Ben Franklin Northeast uses a Salesforce web form for nonprofits to collect annual impact data. Clients receive a multi-step form in Salesforce with web forms with conditional questions and required fields on a Salesforce web form to prevent skipped questions. They can save their progress and return later, while submitted forms can be reopened for corrections. Responses update Salesforce automatically, eliminating manual data entry. |
| Secure Salesforce Client Portal | The secure Salesforce client portal uses SmartV authentication and aΒ portal login with emailed verification code to give clients secure access to their survey history. Clients can review previous responses and update information through a form that updates Account and Contact records in Salesforce, along with a custom object. |
| Salesforce Document Generation | The team uses Salesforce document generation from Word templates to create board reports while preserving familiar layouts. Using Word templates with Salesforce fields, employees can generate documents from a Salesforce Opportunity with a button, based on their permissions. Around 12 documents are available, including a report that combines budget and Project s/b Summary Report (PSR) data from two Salesforce objects for state reporting and client contracts. |
| Leadership Reporting | The marketing team uses Titan to generate investment summaries, letters, and flashcards for state legislators. Before meetings, the CEO can access up-to-date figures pulled directly from Salesforce, without manually preparing reports. |
| Self-Service Reporting | Employees can generate budget reports, risk score pages, and other documents from Salesforce Opportunities using Titan’s document library, without relying on colleagues to prepare them. |
Impact
240x Faster Survey Prep
Preparing the Annual Impact survey previously took 120 hours. With Titan, the team expects future preparation to take just 30 minutes, a projected 240x improvement.
160+ Surveys Sent in 15 Minutes
The team sends more than 160 survey emails in approximately 15 minutes, with completed responses flowing directly into Salesforce without manual data entry.
Weekly Survey Reviews Down to 1 Hour
Reviewing submissions previously took a full workday each week. Now, the team spends about one hour checking for issues, such as incorrect values.
50% Less Time to Complete Surveys
Clients previously spent an estimated four hours completing the survey, compared to two hours now. Those with their information ready can finish in as little as 30 minutes.Β
83% Less Report Prep Time
Preparing client reports now takes roughly 15 minutes, down from approximately 90 minutes with the previous process.
Clean Salesforce Data
Required fields help prevent incomplete submissions, while client responses update Salesforce without manual retyping.
Secure Access to Historical Data
Email verification gives clients secure access to previous survey responses, supporting state reporting requirements.
Familiar Document Formats Preserved
The team generates documents using Salesforce data while keeping the Word layouts its board already knows.
βTitan was honestly a lifesaver. The software was really quick to use, and we could design all of our forms in Word. Itβs invaluable to us now because we save a ton of time. If I can think of a Salesforce project, Iβll figure out a way to do it in Titan!β
Sara Breisch | Business Analyst at Ben Franklin Technology Partners of Northeastern Pennsylvania
Workflows for Salesforce. Fast. Reliable. Connected.