How does Sumac integrate with accounting software? (QuickBooks, Simply Accounting, etc)
There are several ways that Sumac can integrate with accounting software:
a. You can instantly get a total of donations in any time period, so if you just need to put a "total donations" figure into the accounting software, you can do this as often as appropriate (weekly, monthly).
b. Every list in Sumac, including the Donations list, provides the ability to export anything you want into a file. This enables you to export any information (e.g. this week's donations) into a file, which can then be imported into your accounting software. Relatively few Sumac users do this: since Sumac holds all the transaction details (about 25 pieces of information about each donation) there is no need for a redundant subset of this data to also be stored in the accounting software.
c. Sumac maintains account codes in financially significant records like donations, payments, sales, etc. Sumac can then produce a summary of transactions by account code. You can then use this G/L-style summary report to enter (usually manually, since it is only a couple of numbers) the totals into your accounting package, perhaps weekly or monthly.
d. Sumac provides countless reports which can be exported to files. The report files can then be imported into accounting software.
e. Every installation of Sumac includes Ledger Entries. This is a separate list of accounting information, generated automatically by Sumac. You can tell Sumac which types of transactions (e.g. donations, ticket sales, etc.) you want automatically added to the ledger entries. Ledger Entries works like other lists in Sumac: the same search, sort, edit, export, and print features apply. These ledger entries can be used to produce reports within Sumac or can be exported to provide details for use in an accounting package.
f. Finally, if you are using QuickBooks Desktop or QuickBooks Online, Sumac supports an Accounting API that allows you to send general journal entries from Sumac to QuickBooks for financially significant transactions.
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
Sumac and QuickBooks: Setting Up Your Integration
Setting Things Up Sumac can integrate directly with Quickbooks to send General Ledger Entries from Sumac to Quickbooks for financially significant types of data. Before data can be transferred directly from the Sumac database to your accounting ...Importing Sumac Ledger Entries into Simply/Sage
To import into Simply accounting, do the following In Sumac, go to the Ledger Entries list. Search for the date range of entries you're interested in to find the list of entries to export. Under "Analyze & Report," click "Simply (Sage 50) Accounting" ...What happens if there are errors in the data Sumac exports to QuickBooks?
Before it sends any records to QuickBooks, Sumac needs to get QuickBooks account IDs. It does this by sending the codes of the accounts in Sumac, and getting the account IDs back from QuickBooks. If any of these fail, the whole export operation is ...Sumac and QuickBooks: an Introduction
Sumac can integrate directly with QuickBooks to send General Ledger Entries from Sumac to QuickBooks for financially significant types of data. What versions of QuickBooks can Sumac integrate with? Sumac can export to QuickBooks Online or QuickBooks ...Can Sumac integrate with other programs and applications?
Yes! Sumac was created to make the lives of non-profit professionals easier, so it works with all the other programs in your office environment like accounting systems, and desktop applications including: word processing, spreadsheet, email and ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.