Think about this scene:
[FADE IN ON A BOARD MEETING]
DEVELOPMENT DIRECTOR: As of June 30, we’ve raised $9.2 million.
FINANCE DIRECTOR: Fiscal year-end numbers haven’t been totally reviewed but, however acknowledged income from fundraising shall be near $7 million
DEVELOPMENT DIRECTOR: What?!?
EXECUTIVE DIRECTOR: Ugh.
[Executive Director throws head in hands. FADE OUT.]
Administrators of Growth and Administrators of Finance usually discover themselves working in a love/hate relationship. Not with one another, sometimes, however reasonably with the important thing metrics they’re every chargeable for.
Growth and Finance each love when fundraising stories and monetary statements present will increase over final yr, over targets, and over budgets. Equally, neither enjoys reporting that revenues are down. However even when fundraising is routinely exceeding targets and the presents can’t be processed—nor the donors thanked—quick sufficient, Growth and Finance each hate it when their numbers don’t match.
The Govt Director additionally hates it when the numbers don’t match, as a result of finally, the buck stops with them.
Change the Scene with a Related Fundraising and Fund Accounting System
No matter which workforce you’re on (and I’ve been on each), you wish to love your numbers whether or not they’re up or down, figuring out you could confidently get them to reconcile with these of the opposite workforce.
And neither workforce desires to spend numerous, pointless hours trying to find reconciling gadgets, or reformatting monetary information generated by the fundraising system in order that it may be pushed into the finance system with out exceptions.
You’ll be able to change the situation—together with the dramatic scene above—by successfully integrating information out of your fundraising CRM and your accounting system. Incorporating know-how options that act as bridges between your methods can make sure that no person on both workforce is required to format transactions, add or delete rows or columns, or convert information to a distinct format.
So, let’s have a look at the highest seven causes to combine your fundraising CRM along with your common ledger:
- Decreasing Errors
- Decreasing Effort
- Sustaining Correct Management Over Knowledge
- Decreasing Litter
- Simpler Ongoing Reconciliation
- Widespread Understanding of ‘The Numbers’
- Selling Collaboration Throughout Capabilities and Groups
1. Decreasing Errors
When methods are built-in, you solely have to enter information one time and in a single place, whether or not manually keying or by way of an import. It follows then, that if transactions are solely entered as soon as, it cuts the chance for errors in half. If transactions are entered precisely the primary time into an built-in system, there needs to be no concern about accuracy when they’re posted, as a result of no additional human hand will contact them.
Even when your fundraising CRM generates a file to be imported into the accounting system, that output sometimes should be manually formatted by one workforce or each to make sure that it incorporates the correct columns, headers, and summarization. Plus, the fundraising output file usually should be transformed to a different format earlier than it may be introduced into the accounting system. All of this presents the potential for errors.
Lastly, integration can implement some accounting inner controls that can additional cut back the chance of errors. For instance, an built-in posting course of can mark transactions as ‘posted’ within the fundraising CRM to allow them to’t be inadvertently posted once more. This locks a posted reward transaction in order that it can’t be edited with out producing adjusted journal entries.
2. Decreasing Effort
Decreasing effort means decreasing the time, power, and stress concerned in getting fundraising monetary information into the final ledger. There are a number of ways in which integrating your methods can cut back effort general:
- Getting into information (manually or by way of an import) into just one system as an alternative of into two methods reduces the general quantity of information entry, saving time.
- Not having to govern output information, manually summarize transactions, or convert information to a different format may also cut back the time spent on the posting course of and can make posting transactions from the fundraising CRM extra environment friendly general.
- When there are few or no errors, workforce members have to spend little or no time on detective work, and the ensuing corrective motion. And your workforce can save much more time by not having to analyze and remediate hard-to-identify gadgets that hinder reconciliation.
3. Sustaining Correct Management Over Knowledge
One much less apparent cause to combine methods is to make sure that every workforce continues to keep up management over their very own information—the information essential to run their division of the group.
When methods are built-in, every workforce will be assured that they don’t have to be over-involved within the different workforce’s work, or that the opposite workforce will have to be overly concerned in theirs.
Growth stays accountable for fundraising recording and reporting, whereas Finance continues to supervise accounting recording and reporting. However, with inner controls in place, everyone seems to be assured that methods can simply align with one another.
4. Decreasing Litter
Decreasing muddle goes to the idea of the built-in fundraising CRM serving as a real subsidiary ledger to the final ledger—the identical manner that Accounts Payable or Payroll is structured. In that case, most if not all fundraising transactional particulars stay within the fundraising system. From there, solely abstract transactions are posted from the CRM to the final ledger in order that the latter doesn’t grow to be unnecessarily cluttered.
The caveat on this situation is that it’s vital to make sure that the element within the fundraising CRM all the time agrees with totals within the common ledger. At any time, a fundraising system report of transaction element and totals by account or fund for a selected date (or date vary) ought to all the time have the ability to tie to the corresponding account totals or balances within the common ledger for a similar interval.
5. Simpler Ongoing Reconciliation
Every thing mentioned to date informs simpler ongoing reconciliation between methods. As a regular rule-of-thumb, there needs to be a three-way-match between the fundraising system reward or income entry, the posting to the final ledger, and the deposit to the financial institution.
Built-in methods can guarantee error-free and low-effort posting from the CRM to the final ledger corresponding to every financial institution deposit, whether or not that happens each day, a number of occasions every week, and even a number of occasions every day. If each CRM reward batch can hyperlink again to what’s posted to the final ledger and to what’s deposited within the financial institution for that batch, end-of-period reconciliations needs to be a snap.
Even for non-depositable income—suppose pledges and gifts-in-kind—built-in methods make it simple to publish and reconcile each day, or as usually as is required.
6. Widespread Understanding of ‘the Numbers’
Within the dramatic scene originally of this text, there was clearly no frequent understanding of the numbers between Growth and Finance. Built-in methods drive that frequent understanding as a result of they help and encourage ongoing reconciliation—and customary understanding when numbers don’t correspond.
In that situation, the explanation that the numbers had been off was as a result of a number of the bigger marketing campaign pledges had been conditional, and due to this fact not instantly recognizable as income. As well as, low-dollar one-time pledges had been solely recorded as income after they had been paid, not pledged.
An built-in posting course of and routine reconciliation would haven’t solely recognized these things on each side, but in addition would have prompted correct inner communication to make sure that each groups reported constantly. Flexibility, effectivity, and accuracy are all key supporters of efficient reconciliation, and inner communication is the pathway to make sure these three important components are high of thoughts.
Free obtain from the Blackbaud Institute: Your Information to Making a Cohesive Constituent Expertise
7. Selling Collaboration Throughout Capabilities and Staff
A few of these high causes for integrating methods are extra tactical and others extra strategic—or, maybe, some quantitative and a few qualitative. Long run, the qualitative can’t be ignored.
On the floor, integration resolves a tactical concern: precisely and effectively getting income transactional information from the supply system into the group’s monetary system of document. The result of profitable integration is extra time, much less stress, and extra confidence and belief, each within the course of and within the numbers.
It goes again to that love/hate relationship. When you’ll be able to constantly belief course of and love the numbers, stronger cross-functional collaboration will naturally evolve. Staff members shall be pleased to cooperate within the uncommon situations the place one thing needs to be investigated on one facet or the opposite. Every have a tendency to make certain information are aligned and coordinated when speaking with government or exterior stakeholders.
Built-in Techniques and Higher Transparency
Let’s see how that situation would play out with an built-in fundraising CRM and common ledger.
[FADE IN ON A BOARD MEETING]
DEVELOPMENT DIRECTOR: As you’ll be able to see, as of June 30, we’ve raised $6.9 million in money and short-term pledges and one other $2 million in conditional and long-term pledges. We’ve additionally recorded about $300,000 in smaller telemarketing pledges that, traditionally, we don’t rely as reward income till they’re paid.
FINANCE DIRECTOR: That’s proper. As you’ll be able to see on the June 30 earnings assertion, fundraising income for the yr is only a hair over $6.9 million.
EXECUTIVE DIRECTOR: Thanks. Any questions from the Board?
[Executive Director smiles as a board member begins to make an innocuous statement – FADE OUT.]
Integrating your fundraising CRM and common ledger with purpose-built software program will make sure that funds recorded as raised correctly correspond with the cash recorded as income from fundraising on monetary statements—or moderately clarify after they don’t.
However alongside the best way, you’ll save time, be extra correct, take away muddle, and construct belief and confidence among the many groups and their management. And, a totally aligned pair of built-in methods will drive improved transparency, insights, operations, and, finally, accountability to each leaders and donors for delivering your mission.
Able to see an built-in CRM and fund accounting system in motion? Take a look at our on-demand product tour with Blackbaud Raiser’s Edge NXT and Blackbaud Monetary Edge NXT.
