Why your Nonprofit should consider using Nonprofit Accounting Software?

Why your Nonprofit should consider using Nonprofit Accounting Software?

By Jim Simpson, CPA and director, Financial Technologies & Management

Your organization like every other nonprofit is feeling the pressure to deliver more transparency. The demand for more timely information is coming from a multitude of interested parties: board members, major donors, potential funders, and watch dog organizations.

The goal of transparency can’t be easily accomplished without sound nonprofit accounting software-financial reporting is the foundation upon which transparency is achieved.

As the number of nonprofits have proliferated, accounting software is more tailored and can help manage these complexities. But taking the time to select the right software for your nonprofit is critical.

Before your purchase, start with a software evaluation and assessment to see if you’re a good candidate for nonprofit accounting software. The software evaluation and assessment will review your current system to determine its level or utilization and functionality. It is probably a good idea to perform a software evaluation any time there is a major change within the organization either positive or negative.

Here are seven reasons Nonprofit’s should consider Nonprofit Accounting Software.

  1. Flexible report writer
  2. Grants Management capability
  3. Cost-allocation functionality
  4. Strong audit trails
  5. Integration with payroll, fundraising, and other applications
  6. Expanded capabilities as organization grows
  7. Various financial segment or element tracking to include funding sources, programs, projects, locations, and other essential financial information.

Here are features and functionality of the software that can provide optimum efficiency.

The flexible report writer allows you to use the accounting software to meet the internal and external complex reporting requirements. Generating reports should be able to be varied to meet the board, program, and funder reporting requirements and easily modified to meet the changing program and funder needs. Accounting Solutions for your Nonprofit

The grants management capability allows you to track the financial results for each grant, and report back to the funder in the required format, using one accounting system.

Cost-allocation functionality allows you to easily allocate transactions on a real-time basis to multiple programs and funding sources all within the system. It should allow to you to pool various cost pools like facilities and overhead and allocate these to the various program and funding sources to provide a full-cost accounting.

Strong audit trails keep track of what users are doing within the accounting system. The system should allow you to provide your annual auditors and program monitors with the financial information they need to meet their requirements and reduce the chances of fraud. Those involved in the finance function should have segregated permissions in the accounting system to protect the organization and its staff.

As organizations look to be more efficient, it is important they look at software that allows them to integrate their critical functions like payroll, fundraising, human resources, and other areas. Nonprofit accounting software typically has this functionality built into its various modules or it allows for third party product integration. It is typically modular based, which allows your organization to add functions and capabilities as the organization grows and needs additional tools.

One of the most important reasons to look into nonprofit accounting software is the ability track financial information different ways.

For example, an organization may want to track its various funding sources to see what funds are available. It may want to track my various programs and projects to see what the programs costs are and how the organization is doing financially. It might have various locations and want to know how each location is doing. It might have donor and endowments restricted assets and wants to do a separate accounting for these donations to know what assets are left and make sure donor restrictions are met.

It is important, too, that staff remains efficient and effective, enabling them to focus on the long-term planning of the organization and not just keeping up with the day-to-day-accounting.

There are several purchase options that include direct purchase or subscription pricing to pay-as-you-go.

You will need to insure that you include software advisory services to include planning, implementing, and training. In some cases, you will need to also include data conversion and integration services.

Common audit pitfalls and misperceptions

By Jim Simpson, CPA and director, Financial Technologies & Management

While not required by Indiana law, one reason a nonprofit might conduct an audit is to demonstrate the organization’s commitment to financial transparency and accountability.

And while a nonprofit can spend considerable resources for its annual audit, it is important that it consider the following to ensure the audit is a success.

No delays: An audit needs to avoid any major delays. It is important that an auditor schedule significant time to complete most of the audit during fieldwork. The nonprofit needs to prepare for the auditor and have all the major items ready prior to the start of the audit. An auditor and the nonprofit should work together to complete any open-audit items prior to the audit.

Minimal accrual and year-end adjustments: The nonprofit needs to ensure that all accrual and year-end adjustments are completed prior to the start of the audit and to verify that last year’s audit adjustments have been recorded and reconciled with the prior audit. It is also important to understand and record any adjustment so that auditor is not performing the nonprofit’s responsibilities.

Minor board and management comments: It is a good idea to have an exit interview after the fieldwork to review the audit’s results and any remaining open issues that need to resolution to complete the audit. An auditor should provide written and verbal feedback of results.

Here are items that might be addressed in a written communication:

 significant new accounting policies

 significant or unusual transactions

 significant accounting estimates

 audit adjustments

 management disagreements

 significant issues or difficulties

No material weakness or significant deficiency: This is a deficiency in internal controls that could negatively impact financial integrity. A significant deficiency is also a falling of internal controls that is less severe than a material weakness, yet important to mention to those charged with the organization’s governance. An example would be investment reconciliation that was not performed on a consistent basis and led to investments not being properly reported.

Nonprofit should prepare audited financial statements and related disclosures: The organization should have the ability and accounting systems to prepare the audited financial statements and related footnotes and disclosures. The auditor’s focus should be to test financial statements prepared by management and provide an independent, expert opinion that the nonprofit’s financial statements are properly presented.

Fraud detection is not purpose of audit: While nonprofit leaders may believe the annual audit will uncover fraud, it is very unlikely this will occur. It may be surprising, but the external audit is only likely to detect fraud about three percent of the time. The top fraud detection methods are the responsibility of the nonprofit and not the auditor. It is important that the organization be diligent, and not over rely on the audit to deter and detect fraud.

Auditor does not guarantee financial statement accuracy: While auditor does issue an opinion on the nonprofit’s financial statements, the auditor does not certify or guarantee its accuracy. The auditor just represents that the financial statements fairly present the financial statements of the nonprofit.

If your nonprofit has one of these audit pitfalls or misperceptions, you should take action to bring expertise and capacity to your organization to remedy it. Eliminating these pitfalls and concerns later can require significant resources and can have an adverse impact on the reputation of your organization. It is much better to focus on putting corrective and proactive measures in place, rather than the time-consuming process of responding to an auditor’s findings. Accounting Solutions for your Nonprofit

Jim Simpson, CPA and director of Financial Technologies & Management, is a nonprofit financial leader and trainer, CFO, controller, forensic consultant and software advisor, including Abila MIP Fund Accounting since 1999. He has served CFO, controller and software advisor for over 25 years to over 350 nonprofit organizations.

Contact Financial Technologies & Management to see how we can help your nonprofit with accounting solutions. You can schedule an appointment directly from the website at WWW.FTMLLC.COM, email info@ftmllc.com or phone at 317-819-0780.

Developing an effective dashboard and key performance indicators

By Jim Simpson, CPA and director, Financial Technologies & Management

Nonprofits are complex organizations that are built around mission and outcomes, which must be supported by the right revenue and expense models.

Dashboards are one way to simply communicate and give an overview of the organization by using a graphical summary of important information. It is an easy way for decision-makers to see where and whether the organization is on the planned financial path, and additionally can be used with funders and stakeholders to transparently show progress towards desired goals.

But a dashboard without metrics is useless to the organization, it is important to develop the associated metrics and constantly review to ensure you are actually measuring success for the organization.

Effective dashboards

Charts and graphs are not considered a dashboard unless that have the following characteristics:

 Align success definitions across organization

 Encourage communication regarding progress towards goals

 Identify successes and challenges

 Actual data and evidence to make decisions

 Strengthen relationships between different activities

A properly designed dashboard allows a nonprofit to monitor its effectiveness as evidenced by the financial health along with the impact of the programs and services provided. Board and staff should develop strategy and goals to create dashboards with focused conversation and collaboration.

When you select the dashboard elements, you should understand the data you will track and how that data will influence decision making. Questions to ask include: Are the metrics for the organization or particular function? Is the tool for the board, staff, or funders?

Successful dashboards achieve the following:

 Successfully communicate strategic-level results

 Present data in a user-friendly visual format

 Create snapshot of current status and trends over time

 Show performance against defined targets

 Highlight out-of-the-ordinary results

 Create a manageable set of key performance indicators

Consider each revenue and expense stream and the factors that influence the reliability and predictability and what contributes to the increasing or decreasing of these streams.

Performance indicators (KPIs)

it is important to determine the program-delivery mechanism that influences results. Different types of nonprofits have different organizational models with different drivers for success. It is important to select Key Performance Indicators (KPI’s) that focus the organization on data that will support decision-making. Consider whether you need a dashboard that reflects trends over time or performance against goals.

In order to get started, focus on the most important part of the process, which is to define the key drivers and metrics while focusing on the most pressing issues to start. This will help you start the process of developing your organization’s key performance indicators and the related dashboards to move your organization towards data driven decision-making.

When creating a dashboard and KPI’s, you should do the following:

 Start with the big picture

 Identify the audience and how to engage it

 Define business model drivers and key levers inherent in program delivery

 Choose KPIs in a thoughtful, team-based process that is inclusive

 Re-evaluating KPIs is an ongoing process

 Establish a culture of data driven decision making

Successful Key Performance Indicators (KPIs) achieve the following:

 Represent business model drivers

 Reflect progress towards intended outcomes

 Guides priorities and decisions

 Limited number of KPIs that can be realistically monitored

 Should be periodically reassessed

When putting the dashboard reporting into action make sure you consider the following:

 Where does data come from?

 Who is responsible to collect data?

 How will dashboard be updated and how often?

 What platform or tools should we use to update dashboard?

Jim Simpson, CPA and director of Financial Technologies & Management, is a nonprofit financial leader and trainer, CFO, controller, forensic consultant and software advisor, including Abila MIP Fund Accounting since 1999. He has served CFO, controller and software advisor for over 25 years to over 350 nonprofit organizations.

Contact Financial Technologies & Management to see how we can help your nonprofit with accounting solutions. You can schedule an appointment directly from the website at WWW.FTMLLC.COM, email info@ftmllc.com or phone at 317-819-0780.

Building a Superior Budget

By Jim Simpson, CPA and director, Financial Technologies & Management

A strong budget is an essential element for any nonprofit organization to achieve financial leadership. Superior budgets, though, have written plans about the core activities to include strategic, organizational, and program goals and how they will be financed.

Most financial leaders focus too much time on budget variance analysis and not enough time to anticipating or planning for the future. By anticipating or planning, organizations can focus on what’s upcoming regardless of its budget cycle or fiscal year end. A budget can be complemented with rolling forecasts to better anticipate upcoming financial results.

Budgets also need to include cash flow projections, which maybe outside of the finance departments capacity or capabilities. Financial leaders must have a direct role in developing useful cash flow projections and assumptions with frequent, detailed analysis.

Any cash flow shortage needs to be further evaluated to determine if it is just a timing difference or an actual cash deficit. Shortfalls created by deficits need to be solved by budget adjustments or strategic choices to absorb a shortfall. An organization can determine timing or actual deficits by reviewing the budget to see if it had planned for or not.

Financial sustainability can only be achieved with a well-prepared and continuously monitored budget. Conversely, a poorly developed budget can diminish mission focused activities opportunities and threaten long-term success.

Typically, the budgeting process should begin three months before the end of the fiscal year to ensure the budget is approved before the start of the fiscal year. It is important that each of the following budget process practices is used to develop the budget.

 Under current financial status, including review income and expenses, compared to existing budget, forecast remainder of year, then analyze to understand variances.

 Establish a timeline that allows each step to have time for review, discussion and revisions.

 Set up goals to determine organizational and program goals and desired financial outcomes.

 Agree on budget approach to include budget team’s roles and responsibilities along with authority.

 Draft expense budget to attain strategic, organizational and program goals. It is important to break expenses into variable expenses, fixed expenses, incremental expenses and indirect expenses.

 Develop draft income budget to identify expected income from funding sources, including any new activities.

 Review draft budget to ensure it meets organizational and program goals. Distribute draft budget to the budget team to develop consensus and collect recommendations. Modify budget with budget team input to ensure everyone understands and approves the revised draft budget.

 After presentation of the budget to the board, committee and internal stakeholders, approve proposed budget. The proposed budget may need to be revised, so include this possibility in your timeline.

 Implement budget to communicate budget, assign management responsibilities, implement in accounting system, monitor and respond to changes to the budget. It is important that you document budget decisions including writing down all budget assumptions.

A budget should be implemented with monthly distributions to anticipate the changes to monthly income and expenses.

Take a strategic approach to your budget, which might include a multi-year approach to create a better budget. A budget is a living document and narrative that tells the nonprofit’s story using numbers.

Sometimes a zero-based budget approach can help you to understand a budget from the ground up and provide a fresh perspective and generate new possibilities.

Jim Simpson, CPA and director of Financial Technologies & Management, is a nonprofit financial leader and trainer, CFO, controller, forensic consultant and software advisor, including Abila MIP Fund Accounting since 1999. He has served CFO, controller and software advisor for over 25 years to over 350 nonprofit organizations.

Contact Financial Technologies & Management to see how we can help your nonprofit with accounting solutions. You can schedule an appointment directly from the website at WWW.FTMLLC.COM, email info@ftmllc.com or phone at 317-819-0780.

Assess Your Organization’s Vulnerability to Fraud

It’s a people problem, so combat it with governance.   

Purchasing schemes, cash skimming, and financial statement fraud are three very different types of fraud that nonprofits must prevent, detect, and insure against. Still, behind each of them – and every variety of deliberate, deceptive act against nonprofits – there’s a fundamental and shared dynamic at play.

Fraud isn’t just an operational or financial risk. It’s inherently a human risk, meaning it often crosscuts numerous functions and departments within a nonprofit organization. Not only that, but the people behind these acts are complex. They’re pressured by varying circumstances, motivated by different opportunities, and self-assured by their own unique rationales. Making matters more complicated, fraud isn’t always a solo act. In fact, a report by the Association of Certified Fraud Examiners (ACFE) found that 46% of fraud cases involve multiple perpetrators. When fraud occurs, the web of nefarious activity often extends to surprising depths within an organization.

To combat this threat, nonprofits face a critical need to address fraud, starting with more guidance and engagement from leaders and boards to create an anti-fraud environment and oversee a fraud risk management function. One of the most important deterrents of fraud is knowing that the organization’s leaders have no tolerance for it, will act accordingly to detect it, and will take appropriate action if they find it. Begin by focusing on these four steps:

1. Find a Catalyst

You need a high-ranking sponsor to get fraud risk management off the ground. This leader’s first order of business should be deciding whether the organization’s fraud risk management will be integrated into the existing risk management function (which typically focuses on strategic, operational, reporting, and compliance risks) – or whether it will be separate. Either way, the goal is the same: Embed a risk management element into the daily activities of all your personnel.

2. Create Responsibilities & Structures

With your management process in place, establish a governance structure for it, including designated oversight responsibilities at the board level, such as an audit committee. Keep in mind, this framework and the tools your organization uses should be scaled to fit both your size and your available resources. It’s impossible to completely “fraud-proof” any organization, so understand the weak points in your infrastructure and organization, and then work backwards to execute your anti-fraud processes. Also, while fraud prevention is ideal, many nonprofits have to weigh the costs and practicality of preventive processes versus detective measures.

3. Engage & Educate

Especially when faced with resource constraints, nonprofits should engage all their staff in an ongoing system of fraud deterrence. Above all, provide your employees with workshops and trainings in which you educate them on why people perpetrate fraud, which red f lags to watch for, and what resources – such as whistleblower policies, reporting systems, and hotlines – are available to them. Awareness throughout your organization can be the single most effective fraud deterrent and vehicle for detection, but it has to start from the top.

4. Craft Dynamic Risk Assessments

People are dynamic, so your risk assessments must keep pace. With roles and responsibilities identified, use your team to pinpoint which inherent risks exist. Then prioritize these risky situations based on their impact, likelihood, and the speed at which they’re apt to occur. Finally, use those priority rankings to map the best preventive and detective controls.

Source: “Assess Your Organization’s Vulnerability to Fraud”. Nonprofit World. October/November/December 2017. Vol. 35, No. 4: 20 – 21. Print.

Why Nonprofits Should Stop Hoarding Cash?

Take a close look at your cash reserves.  You may be able to put your cash to much better use. 

As you prepare your financial plans for the year ahead, be sure to examine your cash position. It’s important not to amass cash at the expense of much-needed investment income.

Many nonprofits believe they should maintain a cash reserve of three to 12 months of operating expenses. However, while it’s certainly prudent to keep a sensible amount of cash on hand for payroll, for expenses, and to cover financial shocks and surprises, many nonprofits routinely hold too much cash in money market accounts.

The underlying reason to hold cash – to keep funds safe and available for a rainy day – is a sensible one. But most cash holdings can be held instead in short-term investments that can provide additional yield without taking on significant risk.

Seeking to find the right balance should start with a detailed analysis that reveals when cash flows come in and when payments and distributions are needed. For example, organizations funded via regular scheduled payments or grants don’t need as large a cash cushion as an organization that generates a great deal of its cash through seasonal fundraising. Once the minimum cash reserve (including some money for surprises) is calculated, the excess balance should be invested unless there are financial reasons, such as a loan covenant, that demands a certain cash position.

While cash is invested, it should be maintained in vehicles that carry minimal risk, such as mutual funds, with the duration of those investments matched against when the cash will be needed. While an organization doesn’t typically need all its cash tomorrow, it might need some of those funds in six months, one year, or two years, and these monies should be invested accordingly. Many ultra-short-duration products, which invest in bonds that mature in a year or less, and short-term bond funds (with maturities of 1-3.5 years) will capture some additional yield for taking on minimal interest rate risk. Nonprofits can also consider short-duration TIPS (Treasury Inflation-Protected Securities).

Rates are expected to rise after being held close to zero for the years following the financial crisis. Although fixed income investments will temporarily lose money if interest rates rise, losses are likely to be very limited given the short-term nature of the investment. Ultrashort funds are able to reinvest maturing debt at higher yields as rates rise. Still, it’s possible that such funds could suffer short-term losses in the rare event of interest rates rising rapidly or in the case of a credit event. It’s extremely rare, however, that such vehicles lose money over extended periods of time.

A decade ago when cash deposits paid as much as 4%, many organizations saw little reason to chase an extra percentage point of yield by investing their cash reserves. Fast forward to today, with the rate of inflation now exceeding the return on money market accounts and yields on investment portfolios challenged by a low-yield environment. Being smart with cash makes more sense than ever.

Source: “Why Nonprofits Should Stop Hoarding Cash”. Nonprofit World. October/November/December 2017. Vol. 35, No. 4: 30. Print.