Ticket sales, donations, and member dues are just a few examples of payments that choruses receive. Keeping track of all these payments can be burdensome and that's why many choruses turn to accounting software to do the trick. But even with accounting software, manual data entry in the system is still the norm. In our final #AutomationApril post, we will focus on setting up integrations to push your payments data into your accounting software automatically!
Before you start connecting everything, you'll want to consider whether you will be creating duplicate data entries in your accounting software by linking all of your various platforms to it. Discuss with your accountant or financial advisor to ensure you are pulling over the data you need in order to create accurate reports in your accounting software. Let's begin!
Accounting Software for Choruses
Here are a few popular accounting platforms with integration options for choruses:
Connect Your Bank and Payment Processors to Your Accounting Software
The first step to avoid manual data entry into your accounting software is to sync your bank data and/or payment processors like Stripe or PayPal to your accounting software.
Connect Your Bank Account to Accounting Software
Here are a few tutorials on connecting your bank account to your accounting software:
Connect Payment Processors to Accounting Software
And here are options for integrating some payment processors:
- PayPal > QuickBooks
- PayPal > Xero
- PayPal > Zoho Books
- PayPal > Wave
- Stripe > QuickBooks (via Commerce Sync)
- Stripe > Xero
- Stripe > Zoho Books
- Stripe > Zapier > Wave (via automation software)
Push Ticket Sales Data to Accounting Software
Integrations with Automation Software
Automation tools like Automate.io, IFTTT, Workato, PieSync, and Zapier can help integrate thousands of applications that don't offer direct integrations. (Note: Automation tools sometimes come with their own subscription fee.)
Here are a few integrations you can make using automation tools:
- Eventbrite > Zapier > QuickBooks
- Eventbrite > Zapier > Xero
- Eventbrite > Zapier > Zoho Books
- Eventbrite > Zapier > Wave
- Universe > Zapier > QuickBooks
- Universe > Zapier > Xero
- Universe > Zapier > Zoho Books
- Universe > Zapier > Wave
- Ticketbud > Zapier > QuickBooks
- Ticketbud > Zapier > Xero
- Ticketbud > Zapier > Zoho Books
- Ticketbud > Zapier > Wave
- Eventzilla > Zapier > QuickBooks
- Eventzilla > Zapier > Xero
- Eventzilla > Zapier > Zoho Books
- Eventzilla > Zapier > Wave
- Ticket Tailor > Zapier > QuickBooks
- Ticket Tailor > Zapier > QuickBooks
- Ticket Tailor > Zapier > Zoho Books
- Ticket Tailor > Zapier > Wave
Third-Party Integrations
There are also third-party app integration solutions built by developers in the marketplace. These solutions cost money but, if they work, can save your chorus manager or accountant plenty of time.
- Eventbrite > OneSaas > Xero
- Brown Paper Tickets > Apiant > QuickBooks
- Brown Paper Tickets > Apiant > Xero
Sync Donor Data to Accounting Software
Similarly, only a few donor management platforms are built to support integrations. If you're lucky enough to have one of these platforms you can sync your data with ease!
Direct Integrations
- CiviCRM > Xero
- DonorSnap > QuickBooks
- DonorPerfect > QuickBooks
- Kindful > QuickBooks
- Salesforce > QuickBooks
Integrations With Automation Tools
- DonorPerfect > Apiant > Xero
- Salesforce > Zapier > QuickBooks
- Salesforce > Zapier > Xero
- Salesforce > Zapier > Zoho Books
- Salesforce > Zapier > Wave
- eTapestry > Apiant > Xero
Third-Party Integrations
- Salesforce > AppExchange > QuickBooks
- Salesforce > AppExchange "BreadWinner" > Xero
- Salesforce > AppExchange "Commercient Sync" > Xero
- eTapestry > Sidekick Solutions > QuickBooks
Whether you can integrate one or more of your systems, any little bit of automation can help you save time and money for the chorus.
That's a wrap on #AutomationApril - we hope you've been able to use this information for bettering your chorus's data management!
Tori Cook is the former Director of Sales & Marketing at Chorus Connection, an active board member of the Greater Boston Choral Consortium, and a soprano with the Tanglewood Festival Chorus. In a past life, she was the Music Director of the Harborlight Show Chorus and President of Chorus pro-Musica. When not making music, she daydreams about adopting a golden retriever puppy and scuba diving to exotic locations around the world.