Category

Audit

Mar 05
0

Financial Audits Improve Nonprofit Operations

By | Abila, Accounting, Audit, Data, MIP Fund Accounting, Nonprofit | No Comments

Are you getting the most from your nonprofit’s annual audit? Financial audits aren’t just a necessary exercise to meet the requirements for keeping your nonprofit organization’s status or to please donors and board members. They provide valuable, useful information that can help you improve many areas of your organization.

A study conducted by Deloitte and reprinted in the Journal of Accountancy surveyed 300 executives and 100 members of audit committees nationwide. Their findings point to the usefulness of audits as a business evaluation tool.

  • 79% of executives and 91% of audit committee members agree that financial audits help them identify opportunities to improve business performance;
  • 46% of executives and 62% of the audit committee members believe that audits helped them identify business issues that they might have missed without the audit information;
  • Companies that review and utilize audit information achieved strong growth over a three to five year period (as noted by self-observation.)

Clearly, there is value not just in the audit process itself but in the use of the audit findings for analysis of current operations,

Quality Counts When It Comes to Choosing an Auditor

Throughout the survey, respondents cited the quality of the audit as a key element of a useful business improvement tool later on. A good-quality audit starts with selecting an auditing firm with experience helping nonprofits both through the auditing process and to improve later on.

Audits can provide more than information into the company’s financial state. They can provide market and industry comparisons and analysis. Process analysis, identification of gaps and potential for improvement can also be part of the audit findings. Each of these elements provides an item that can be used as a springboard for action later.

When selecting an auditing firm, look for one with experience working in the nonprofit world. It may also be helpful to find a company that provides more than auditing services. Business consulting, nonprofit consulting, and other related services offered by the auditors mean that they can infuse additional insights into the audit process and continue working with your nonprofit after the audit to implement the changes that you wish to make.

Data and Analytics

Another new area in which nonprofits are finding useful information is the data and analytics that are derived from the audit. Many aspects of a nonprofit’s business can be analyzed. Examining items such as expenses like leases, long-term contracts and expenditures can reveal places in which money can be saved. Long-term donor patterns, grant analysis, and areas where the nonprofit’s work has shifted over the years may also be revealed from an analysis of data patterns found within the audit and the nonprofit’s financial statements.

It takes a special auditor to be able to analyze and detect such patterns. If you aren’t looking for them or for places from which you can derive such information, it can easily be overlooked. Again, choosing an auditor with the insight and experience in the nonprofit world to assist you with your business improvements it the key to success.

Are You Using Your Audit Information?

Are you using all of the information that can be obtained from your most recent audit? According to the previously mentioned Deloitte study, about 35% of the nonprofits responding to the study rarely or never use the information obtained through the audit for improvement. Talk about a missed opportunity!

Why aren’t they using the information? Approximately 48% percent of executives surveyed state that they do not have a process in place to use the information post-audit.

Therein lies the key – process. Develop a process now to use the information obtained from this year’s audit to improve your nonprofit. Begin now to find an auditor who can partner with you to develop a series of action items for follow up. Put in place the teams, groups, committees or leaders within your company who will be accountable for following up on the audit information.

By using these techniques, you can use the annual audit as both a financial document and the start of process improvement.

Welter Consulting

Welter Consulting bridges people and technology together for effective solutions for nonprofit organizations. We offer software and services that can help you with your accounting needs. Please contact Welter Consulting at 206-605-3113 for more information.

 

Jan 29
0

Getting Your Staff Ready for the Annual Audit

By | Accounting, Audit, Nonprofit | No Comments

As the manager of a nonprofit organization, you’re probably all-too familiar with the paperwork aspect of the annual nonprofit audit. Documents must be managed, maintained, and updated, and everything prepared for the auditors.

There’s a second part of managing the audit process that’s equally as important: managing the people who are part of the audit. To help you with this aspect of auditing, we’ve put together the following tips.

Schedules

  • Make sure you schedule the audit well in advance of any deadlines. Be sure to set aside enough time for your staff so that they can be available to assist the auditors in any way necessary.
  • Contact the auditing firm and confirm that the dates for the audit are available. Auditors’ schedules may be booked months in advance. Be sure to confirm again the week prior to the scheduled audit to ensure nothing has slipped through the cracks.
  • When scheduling your audit, offer three days and times that work for all. Allow the auditors to choose the one that works best for them.
  • Clear calendars to make sure no offsite or other meetings will interfere with the audit schedule.

Logistics

  • Provide a clean, private, well-lit workspace for the auditors to use while they are at your company.
  • Create the necessary computer and WIFI access in advance so it is ready for the auditors immediately.
  • Ensure that a telephone line is also available for the auditors.
  • If parking spaces are reserved at your building, make sure you take the necessary steps to secure parking spots for the auditors.
  • Provide them with directions on how to get to your building.

Communications

  • Inform the internal staff that an audit is taking place. Reassure them that it is both a necessary and beneficial aspect of nonprofit management – it’s not like a personal IRS audit, but more of a consultation to ensure that your nonprofit is operating correctly.
  • Make sure that staff understands they can’t use conference rooms or other workspaces that the auditors are using during the week.
  • Ask staff not to interrupt the auditors while they are working.

Following Up on the Audit

Once the audit is over, it will take your firm several weeks to prepare the materials and provide them to you. Take time to review them and discuss the findings with the auditors. The final report can then be presented to your Board of Directors.

As a final step, share the audit with your entire team. Although not required as part of a nonprofit audit, the more information that you can share with your staff, the better they will understand what’s going on within the organization as a whole. They’ll feel invested in the outcomes and better informed about the financial aspects of the organization. The more information they have, the better they can do their jobs.

Preparing for an audit can be stressful, but if you’re organized and take the appropriate steps, you can ensure that the entire audit process from start to finish goes smoothly. Both your auditors and your Board will thank you for the extra effort made to ensure a streamlined process.

Welter Consulting offers auditing as one of our core services for nonprofits. Our experience encompasses audits, consulting, software selection and more for the nonprofit industry. Please contact Welter Consulting at 206-605-3113 for an appointment.

Jan 15
0

How Good Are You at Detecting Nonprofit Fraud?

By | Accounting, Audit, Fraud, Nonprofit | No Comments

The average nonprofit fraud loss averages around $600,000, according to the NonProfit Times. With so much at stake, understanding your fraud IQ is important. How much do you know about nonprofit fraud?

Principles of Fraud Risk Management

The principles of fraud risk management include:

  1. Fraud risk governance: Establishing and communicating a fraud risk management program demonstrates expectations to all stakeholders. A written program which can be shared is a great idea.
  2. Fraud risk assessment: This includes items such as employment checks, ensuring people take vacation time and more.
  3. Fraud control activity: Selecting, developing, and deploying fraud risk management activities. A good example is a set of internal controls.
  4. Fraud investigation and corrective action: Establishing a communication process to investigate and correct any suspected fraud. Also includes a written, established and coordinated approach to the investigation.
  5. Fraud risk management and monitoring: Every organization should select, develop, and perform ongoing fraud risk management evaluations. Look at these five principles and see how they apply throughout the organization. Any gaps should be addressed immediately.

Data can, and should, be used throughout all of the fraud risk assessment and analysis activities. As we’ve shown in a previous article, Benford’s Curve is one example of how data can be used, albeit a simple use, to indicate possible fraud. CPAs, auditors, and others can use more sophisticated techniques to detect errors and fraudulent activities.

Whose Responsibility Is It, Anyway?

Who on staff is responsible for fraud detection, management, and corrective actions? Your senior management team is ultimately responsible for all of these actions. The Board of Directors provides oversight and guidance, but the “buck stops” at the desk of your senior leadership team.

Fraud Risk Assessment

Fraud risk assessment includes considering all potential routes of fraud. This includes internal and external areas at risk as well as personnel who might have access to materials which enables them to commit fraud.

Even with the best risk assessment and controls in place, it may be impossible to prevent all types of fraud. It is still critical for nonprofit organizations to have fraud risk assessment measures in place, internal controls, and other measures enacted to prevent, limit, and detect fraud.

Stopping Fraud Starts with You

Much is at risk when it comes to nonprofit fraud. It’s not just the potential loss of $600,000 or so, which is, of course, a substantial number. It’s also the risk of losing the trust and faith of the public.

Nonprofit organizations are under heavy scrutiny now from a public who has grown weary of extravagant spending. People want to donate to their favorite charities, causes, and membership organizations, but they won’t do so if they feel their money is wasted. Fraud is one example of waste that many  donors feel can be prevented.

Your organization works hard on behalf of its members, donors, and beneficiaries. Ensuring that you take all necessary steps to prevent fraud and detect it if it occurs is essential to building and keeping the public trust.

For more information on fraud prevention, see:

About Welter Consulting

Welter Consulting bridges people and technology together for effective solutions for nonprofit organizations. We offer software and services that can help you with your accounting needs. Please contact Welter Consulting at 206-605-3113 for more information.

Jan 08
0

How a Slippery Slope Can Help You Detect Nonprofit Fraud

By | Accounting, Audit, Fraud, Nonprofit | No Comments

Think about the term “slippery slope” for a moment. What do you imagine when you read it? How about a water slide? An article in the Journal of Accountancy compared Bedford’s Law with a theme park water slide, an apt image, and one that’s easy to keep in mind. Keep the concept of a curve in mind when looking at your data and you’ll be able to detect nonprofit fraud more easily.

A Picture of Nonprofit Fraud

In 1938, Frank Benford discovered a naturally occurring numerical law that predicts the frequency of digits in any number set. According to Bedford’s Law, an authentic data set includes the following frequency of digits:

  • the numeral 1 will be the leading digit in a genuine data set of numbers 30.1% of the time;
  • the numeral 2 will be the leading digit 17.6% of the time;
  • and each subsequent numeral, 3 through 9, will be the leading digit with decreasing frequency.

Using Excel data and some simple calculations, you can chart your nonprofit’s numbers on a Benford curve. If the numbers don’t resemble the curve, it’s time to investigate, as something may be amiss.

Using Benford’s Law in Nonprofit Accounting

Benford’s Law works best with large data sets, typically groups of numbers with more than 100 entries. Fewer numbers provide too small a data set to chart accurately. Some recommend 500 or more numbers for improved accuracy.

Other tips include:

  • The numbers must have an equal chance of starting with 1 through 9. If the dataset limits the numbers, Benford’s Law won’t work. Thus, calculating the average height of the Rockettes, the Radio City Dance troupe, doesn’t work because all Rockettes must be between 5’ 6” and 5” 10 1/2” tall; all digits begin with 5, therefore the curve won’t work. Think about this if your products are all priced with the same starting digit. Entering them into the spreadsheet and generating a curve won’t work to detect fraud, i.e., if all conferences run by your nonprofit have a fee of $199 for example.
  • Don’t use it as definitive proof of fraud. Benford’s curve cannot prove or disprove fraud. It’s like a clue that leads you to investigate more deeply into potential fraud. It’s not a good idea to use it to accuse someone of fraudulent activity. It can, however, point to a problem requiring further investigation or the addition of an outside consultant to your team.

To use Excel to plot a Benford Curve:

  1. Use the Column Chart, LEFT, and COUNTIF functions.
  2. Enter the data by name in column A, and numerically in subsequent columns.
  3. Use the LEFT function to extract the first digit of each number in a column.
  4. Copy and use the same formula to extract all the first digits.
  5. Use the =COUNTIF function to count the occurrence of the first digit from each number that you extracted in the step above.
  6. Copy the results to a new cell.
  7. Chart the results.

The previously linked Journal of Accountancy article provides an Excel spreadsheet already set up with relevant formulas that you can download.

By charting the numbers, you’ll either see the Benford curve or a random graph. Some graphs look like straight lines with slight bumps in the middle. This tends to indicate that the data was artificially produced, in which case, fraud may be occurring.

It also may not be an example of fraudulent activity. That’s why it’s important to perform additional checks and investigate potential fraud before making accusations. Sometimes, a bell curve is just a bell curve.

About Welter Consulting

Welter Consulting bridges people and technology together for effective solutions for nonprofit organizations. We offer software and services that can help you with your accounting needs. Please contact Welter Consulting at 206-605-3113 for more information.