Category

MIP Fund Accounting

5 Questions to Measure Fund Accounting System Effectiveness

By | Accounting, Budget, FASB, Grant Management, MIP Fund Accounting, Nonprofit | No Comments

Mandated reporting has become increasingly complex, due to multiple funding sources and programs within nonprofit organizations. You may find yourself having to rely on spreadsheets and workarounds, which can quickly become unmanageable and have a higher risk for error. As compliance, regulatory agencies, funding sources, and complexities grow, these issues can quickly hinder mission productivity and you may be exposed to larger burdens including:

  • System constraints limiting your ability to adapt other new and vital technology
  • Poor financial control which can lead to future loss of time and money
  • Lost opportunities for additional funding because your system is not flexible or robust enough to properly handle tracking and reporting requirements

Sound familiar? If so, you may need a more robust accounting system. Time to ask yourself the following five questions.

Are you facing an upgrade or needing software built for the complexity of nonprofit finance and accounting? Download “10 Reasons Why Nonprofits Need True Fund Accounting™.”

Does my current solution incorporate nonprofit-specific accounting rules?

Audited financial statements must present information in accordance with the Financial Accounting Standards Board (FASB) Statement of Financial Accounting Standards (SFAS) No. 116 and 117, or Governmental Accounting Standards Board (GASB) guidelines. If your reports need heavy customization to comply with these guidelines, you should consider software that easily provides compliance-ready reporting.

 Can I easily measure performance of a program or activity?

Nonprofits typically need to measure a program or activity outcome, and track beyond basic financial information – something off-the-shelf, which is something most commercial accounting software is not designed to do. Your software needs to be robust enough to track and report performance or outcome measures on financial statements, as well as budgeting outcome measures for accurate forecasting.

 Am I able to create reports for varying fiscal years?

While commercial accounting often assumes that fiscal years end in the same months each year, nonprofits often have to report to several different audiences, with different information requirements and reporting timelines. Thus, the ability to track and report across different time periods (cross-fiscal & grant-year reporting) is critical for nonprofits.

 Can I easily show how money is tracked or budgeted?

Funds must be treated as distinct entities with their own general ledger and individual revenue, expense, income, and balance sheet reports. Nonprofits need software that will automatically handle the offset postings to cash or payable accounts by fund, as well as the encumbrance processing, grant tracking, and budget controls.

 Can I perform allocations of indirect costs by grantors?

Accuracy of allocations is critical in providing auditors and grantors a complete audit trail, but these allocations typically are not handled well by a commercial accounting system not designed with nonprofits in mind. Allocations need to be performed on virtually any account balance at the program level, department level, or grant level, and across multiple segments at one time with advanced calculation options, including fixed or dynamic percentages, unit measures, and more.

 

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.

What Do Grant Organizations Look For? What Funders REALLY Want When They Make Decisions About Where the Money Goes

By | Budget, Fundraising, Grant Management, MIP Fund Accounting, Nonprofit | No Comments

Funders, defined as people at grant organizations, approve fund requests. They can be a nonprofit organization’s bane or best friend. A new report, called Social Solutions: Foundation Report Study, examined the metrics by which foundations and granting organizations determine which nonprofit organizations to awards funds. The results are surprising and tell us a lot about what nonprofits can do to increase their opportunities to receive funding.

The Three Most Important Considerations for Funding

Funders overwhelmingly agreed on the main consideration for granting an award: IMPACT.

98% of those responding to the survey picked “impact” – as in the award they gave would make an impact on the project or people – as the most important consideration for funding.

Lagging behind impact but coming in second is MISSION. How well does the project or request match the fulfillment of the nonprofit’s stated mission?

And third, legal nonprofit status was cited as the third most important consideration. That was surprising given that one would assume that anyone applying to a foundation or grant organization would already have legal nonprofit status before requesting such funds.

Evaluating Impact

It wasn’t just the overall impact that was important to these funding organizations. To evaluate impact, they look at several criteria. This included:

  • Outcomes
  • Detailed data
  • Consistency to mission
  • Outputs
  • Community
  • Financials
  • Other criteria

Funders are also seeking clear, concise reporting, as well as strong community outreach. Communication around projects and nonprofit goals are also important. The funding organizations wanted to be sure that organizations are “putting their money where their mouth is” and doing what they state they will do in their mission and materials.

Reports Are Important

Reports back to the foundation are also an important part of the process. What the foundations and granting organizations seek in reports includes plenty of stories about how the money is making an impact, as well as the data to back that up. Spreadsheets, paper-based reports, and other documentation lends credibility and credence to reports and supports the nonprofits’ assertions of how money is being used or will be used.

One thing is certain: more feedback is required from nonprofits as part of the grant process than ever before. Funds are one thing, but telling a story about the funds is important.

Donors Like to See Dollars in Action

Donors like to see their money in action, making an impact, effecting change, and supporting the mission of the nonprofit. That goes for individual donors as well as foundations and granting organizations.

Large or small, all funders preferred to see stories (82%) over other forms of reports. Why stories? Stories paint a great picture of how funds have made a difference. That doesn’t mean that stories have to be written out. They can be told through images, slideshow presentations, or videos, but illustrating the impact of the funds on the lives of others was deemed very import for the funders to decide to whom to give money..

Your Take Away: Get Your Ducks in a Row

The big takeaway for nonprofit organizations is to be sure that you have your entire package prepared as best as you can before sending it to a funder. If your nonprofit status isn’t fully documented, your application may be pushed to the bottom of the pile.

Documenting achievements in both qualitative and quantitative formats is also important. Qualitative documentation such as stories, testimonials, and presentations enhances the emotional impact of your nonprofit’s work, while quantitative data support assumptions about its effectiveness.

Funders have money to give to worthy causes. Knowing what they are looking for and tailoring your grant paperwork to their requests can help you achieve your nonprofit’s funding goals.

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.

 

Trust, But Verify: Avoid Fraud by Maintaining Internal Controls

By | Accounting, Fraud, Internal Controls, MIP Fund Accounting, Nonprofit | No Comments

Trust, so the experts tell us, must be earned over time. In the workplace, it is earned by consistently performing one’s duties well and by successfully accepting ever-increasing responsibilities.

The nonprofit workplace, like the for-profit workplace, works best in an atmosphere of trust and mutual respect among one’s colleagues. Without it, the workplace can be hostile, unfriendly, and uncomfortable.

But there is a fine line between suspicion and performing due diligence. Nonprofit organizations should guard against allowing trust to blindside them to the potential dangers of fraud and theft in the workplace.

A Cautionary Tale of the Ramifications of Blind Trust

One story that stands out is the story of Marge (not her real name), who worked at a large nonprofit organization. She was like a second mother to the staff. Honest, always willing to work extra hours, diligent in her job duties in the accounting department, Marge was trusted with managing many areas of the organization’s finances.

Although the organization had internal controls in place, they were often waived for Marge and other senior staff members who were so well-regarded and trusted that they weren’t questioned when they dodged the procedures. Marge was especially trusted and valued and did not have anyone present when she counted out petty cash or handled the checkbook.

One day it was discovered that money was missing from the petty cash. An audit revealed that small amounts of money had been taken from the petty cash box as well as from the checking account. Because Marge controlled both, she could make slight adjustments in the entry ledgers to avoid suspicion for a long time. It took the auditors only a short while to uncover the discrepancies and for Marge to confess that her lottery ticket habit had become a necessity and that she had been stealing ever increasing amounts to fuel an obsession with gambling.

Is Marge an isolated case? We think not, and a quick survey of the various nonprofit journals reveals similar patterns of fraud. Fraud doesn’t occur in isolation. It tends to occur when gaps are left within the internal controls that are intended to prevent such situations. In this case, trust and friendship overrode common sense. Exceptions were made that should not have been made. The result was an organization poorer for the loss of both money and a trusted employee who had to be let go when the truth was revealed.

Preventing and Identifying Fraud

Trust is a wonderful thing and a valued commodity in the workplace. That said, it should not preclude the use of standards, internal controls, and audits.

  • Preventing Fraud
    • Standards are the accepted norms for an industry. Accounting standards, security standards, and workplace standards can be codified and recorded in written manuals provided to all employees. Everyone can then be held to the same shared standard of conduct and behavior.
    • Internal controls are the processes and procedures put into place around access to the organization’s finances. These controls should be written down and shared among staff. Training sessions and refresher training session are also important to ensure consistent understanding of the controls among everyone.
  • Recognizing Fraud:
    • Audits bring in outside consultants such as CPA firms, well-versed in accounting for nonprofits to examine your organization’s financial records, provide recommendations, and discover discrepancies.
    • Provide staff with an anonymous method to report incidences of fraud to their supervisors or to the managers in your organization.

Trust doesn’t have to be blind. Assuring people that their work matters, listening to their ideas, implementing their suggestions and other positive examples of trust can build bonds among workers that engender loyalty to your organization. Don’t leave your nonprofit open to fraud or theft due to blind trust. Trust, but verify, and stick to accepted norms and standards of behavior and internal controls to prevent problems before they occur.

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.

Personalized Training Plans Offer More Meaningful Professional Development

By | Abila, Accounting, Government, Grant Management, HR, MIP Fund Accounting, Nonprofit, Professional Development, Training | No Comments

CPAs, like other professionals, need an additional 40 hours of continuing education units annually to maintain their certification. Even if your industry does not require taking continuing education courses, everyone benefits from refresher courses and keeping abreast of changes and developments in their industry.

There is great value to designing a personalized plan for continuing professional development. These plans build a customized training roadmap for individuals, so that instead of taking a prescribed set of courses to meet your continuing education requirements, you create your own curriculum. Here’s why they work.

The Benefits of Personalized Professional Development Plans

  1. Relevant: Personalized course plans are highly relevant. They take into consideration your currently level of skills, interests, and needs, as well as those of your employer or company. You can choose the courses that are right for you and fit your personal learning goals.
  2. Flexible: You choose when you wish to take the courses, creating a plan that lets you take courses on the weekends, at night, or even during your lunch hour. You aren’t locked into a set schedule.
  3. Higher completion rate: Because the courses in your personalized plan are relevant and on a schedule that meets your needs, they tend to have a higher completion rate than other courses.
  4. More feedback and interaction: Some personal development plans include interaction with a mentor or trainer, providing more personalized feedback and interaction from the one to one mentoring.
  5. Noticeable difference: Personal plans offer you the added bonus of being able to identify specific goals to work towards. You can document progress toward your goals through milestones and checkpoints. Not only does this help you achieve them, it also helps you see both the ‘before’ and ‘after’ picture. You can see just how far you’ve come.

Does Personalized Professional Development Stand Alone?

Most companies blend both personalized development with general professional development activities,  offering both the benefits of personalization and group interaction that’s valuable for team building and shared knowledge.

Why Professional Development Matters

Lifelong learning is important for all professions. While we tend to think of professional development for teachers, accountants, financial managers, others benefit from continually sharpening their skills.

Professions change over time. New governmental and IRS regulations, for example, may change how accountants and financial planners manage specific tasks and functions. Yes, you can read about these changes in professional journals or online bulletins from the managing organizations, but in some cases, in-depth professional development through workshops, conferences, or classes may be the best way to completely understand something new.

Technology is changing how CPAs manage data, how sales and marketing professionals do their jobs, and how human resources managers organize their files. By taking additional professional development courses in technology-enhanced areas, you’ll be able to maximize the use of such  developments to create a stronger, better organization.

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.