Paypal vs Integrated Donation form

From 80 Spreadsheets to 1 Database: How Boston Children’s Theatre Got Their Data Under Control

With 63 years under their belt, Boston Children’s Theatre (BCT) is the longest continuous running children’s theatre in the country. Their mission is divided between outreach and training, so they spend a lot of time traveling to Boston public schools to perform and run workshops. BCT produces professional quality plays and musicals throughout the year and provides theater training for students from 4 – 19 years old as well as college preparatory classes.

Buried in Spreadsheets

According to BCT Executive Director Toby Schine, before they moved to a database, they were managing everything using spreadsheets: events, class registration, and donor relations. Altogether, there were over 80 spreadsheets. “It was pretty chaotic,” he says. “We were entering and re-entering addresses for contacts again and again, and there was no way to get their data to talk to each other.”

Consolidating Data in One Membership Database

When he came on as the ED, Schine knew things had to change, but there were few solutions out there that handled ticketing, class registration and donors in one system. Then he found Sumac. It could do it all, and it even offered online ticketing, and ticket printing.

“It was incredibly easy to set up.” Schine says. “The Sumac staff took our 80 spreadsheets, created an architecture that made sense for us, and imported all of our data into our new database. They were wonderful at consulting which made the process really smooth.”

Now, Schine says with excitement, “We can get a complete picture of what is going on at the organization: our events, classes, and donors are all in one system. Data is speaking to each other, we can see what other staff members are doing, and we only have to update data in one place. Also, we no longer need to use OvationTix box office software which charged a percentage of each ticket sale, so we’re saving money.”

Boston Children’s Theatre has now been using Sumac for almost two years and Schine says, “We keep uncovering more ways to use it.” Recently they discovered custom reports that allowed them to see what promotion efforts are working. What they found was surprising: direct mail worked for promoting summer workshops and email worked for promoting their shows. So, now they can use time and resources more efficiently. In the end, Schine says, “We are operating much more efficiently, and that’s what people expect even if you are a small non-profit on a limited budget.”

Download Your Free Guide on Choosing CRM Software for Your Nonprofit!

  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.

GET MORE CONTENT LIKE THIS DELIVERED TO YOUR INBOX!

Sign up for our newsletter packed full of nonprofit help!

  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.
Scroll to Top

Included in the Premium Case Management Package:

All Basic features:

  • Phone & email support
  • Case management intake, screening, assessment
  • Service tracking
  • Workflows
  • Email marketing
  • Event management
  • Cloud-based access
  • Reporting

All Standard features:

  • Specialized Case Management (pre-configured for Mental Health, Hospice, Shelter)
  • Webforms

PLUS:

  • Donations
  • Pledges

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Included in the Premium Memberships Package:

All Basic features:

  • Phone & email support
  • Member & membership tracking
  • Payment processing
  • Receipting
  • Email marketing
  • Event management
  • Cloud-based access
  • Reporting

All Standard features:

  • Donation webforms

PLUS:

  • Donations
  • Pledges

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Included in the Standard Memberships Package:

All Basic features:

  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

Plus:

  • Membership webforms

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Premium Donations Package

Manage complex donations for planned giving and larger gifts.

What's included:

All Basic features:

  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

All Standard features:

  • Donation webforms

Plus:

  • Grant Management
  • Proposals
  • Prospecting
  • Volunteer management

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Standard Donations Package

Donations flow from your website forms straight through payment processing and to your database, so there's less effort and less errors.
What's Included
All Basic features:
  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Plus:
  • Donation webforms
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Included in the Basic Memberships Package:

  • Manage member lifecycles
  • Member & membership tracking
  • Custom membership level definition
  • Email marketing
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Basic Donations Package

Manage your donations and fundraising campaigns, engage donors, and increase revenue.
What's Included
  • Donor & donation tracking
  • Email marketing
  • Fundraising campaigns
  • Event management
  • Receipting
  • Reporting
  • Communication tracking
  • Workflow management
  • Quickbooks integration
  • Cloud-based access
  • Phone & email support
Includes: Up to 750 contacts; Up to 5GB of storage capacity
(cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Included in the Standard
Case Management Package:

All Basic features:

  • Phone & email support
  • Case management intake, screening, assessment
  • Service tracking
  • Workflows
  • Email marketing
  • Event management
  • Cloud-based access
  • Reporting

PLUS:

  • Specialized Case Management (pre-configured for Mental Health, Hospice, Shelter)
  • Webforms

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Included in the Basic Case Management Package:

  • Phone & email support
  • Case management intake, screening, assessment
  • Service tracking
  • Workflows
  • Email marketing
  • Event management
  • Cloud-based access
  • Reporting

Includes: Up to 750 contacts; Up to 5GB of storage capacity (cloud-based); Up to 3 concurrent users
Need more contacts, storage, or users? Just ask us!

Wait, don't go away empty handed.

Join 50,000 other nonprofits in getting the BEST nonprofit tips, tools, and how-to guides delivered right to your inbox!

Subscribe to our newsletter: