BLUE FOX | Accounting for Nonprofits and Social Enterprises
  • Accounting Services
    • Employee Retention Credit (ERC) Eligibility
  • Tax Preparation
    • Tax Deadlines
  • About
    • Our Founder & CEO
    • Our Team
    • Our Clients
    • Now Hiring: Bookkeeper
    • Our Philosophy
    • Benefits of Outsourced Accounting Services for Nonprofits
    • Technology Solutions
    • Testimonials
    • FAQs
    • Join the Team >
      • Now Hiring: Tax Specialist (Remote)
  • Blog
  • Freebies
  • Contact
  • Subscribe

5 Steps to Solving Complex Workflow Problems: How We Designed and Built a Smart Workflow for a Tuition-Based Client

9/23/2019

0 Comments

 

[A Must Read for Nonprofits with Tuition Revenues]

Picture
Over the years, I’ve worked with several nonprofit schools. One thing they all have in common when we come on scene? The accounting is a nightmare.
 
If you’ve ever worked at a school (or been a parent who’s paid school fees) you understand that capturing the ins and outs of daily, weekly, monthly, or annual tuition can be confusing. Throw in scholarships, holidays, and seasonal breaks and you get accounting mayhem.
 
Last year, one of our clients with an adult day program rolled out a redesign of their tuition and fee structure. They moved from a pay-as-you go model to standardized fee rates, regular invoicing for families, and they also added a subsidy (i.e. scholarship) program to assist families who could not afford the full fare of the program.
 
Unfortunately, we were brought into the loop a little too late – and after the new process and payment structure was rolled out to the community. The result was one huge, hot mess for everyone involved – the staff, the Blue Fox team, and the participant families as well.
 
We’ll spare you the details, but as this past academic year wrapped up, the staff and Blue Fox were determined to work together to unpack the issues with the inaugural process and streamline the workflow. In the words of ME Parker, the Keeper of Books from the Blue Fox team assigned to this client, “The overall goal was to make this process not only much more simplified, but to make it a shared process… so everyone is working on the same page.”
 
It was paramount to Blue Fox that we have a collaborative and inclusive redesign of the workflow. Here’s how the process unfolded… it’s a roadmap anyone can use to work through a challenging workflow scenario.
  
Step 1. Gather data and analyze the challenges with the current process. 
As soon as we realized that year 1 was a giant beast of a learning curve, we began to gather data on what was working and not working (for everyone involved). We made notes throughout the year on the issues we were having on the accounting side, and issues the staff were dealing with as they communicated with parents and managed their own recordkeeping related to the program.
 
Every time there was “an exception” made on the billing side, we kept a record of that in particular. Participants of the program have a level of intimacy with staff that, while a wonderful endorsement of the organization, created its own set of challenges as the staff tried to (understandably) bend to accommodate different needs and requests throughout the year.  A beautiful intention that was followed by a brutal accounting process.
 
We also developed a spreadsheet to track gross fees and true subsidy amounts per participant, since this information was often incorrectly computed on site and incorrectly accounted for in the accounting software. At year end, we analyzed this information to ascertain the root causes of miscalculations and headaches, and we identified accounting and program policies and procedures that could be implemented to eliminate or avoid those accounting land mines.
  
Step 2. Determine recommendations and sketch out revamped process.  
As this client’s virtual CFO, we were asked to take the lead and design the new workflow and identify the best technology to use in that workflow. We identified the core issues in play and made suggestions on how to prevent those issues going forward. We suggested things like: 
  • Standardize pay rates AND subsidy levels – a set system of tiered fees
  • A change in invoicing frequency to support regular, recurring transactions
  • Additional policies and procedures regarding those “exceptions” that came into play – credits for absences, for example
  • We actually drafted several of these policies since this was new territory for the client
  • Use online forms to automate the workflow around participant interest and registration
  • Make changes to the accounts in use in QuickBooks (more on that in Step 4 below)
  
Step 3. Collect feedback from staff and TEST the new process. 
After we settled on our recommendations, we presented them to the staff and asked for feedback. We had some very deep, meaningful conversations with the client to ensure that our ideas were aligned with their needs. The critiques we received allowed us to further tweak and refine the workflow.
 
Once our framework was set and agreed upon by all parties, we ran some tests of the new process. These tests revealed a few shortcomings in the revamped approach and gave us time to adjust and adapt the process prior to rollout.
 
I *cannot* overstate how important the testing component was – the Blue Fox team ran tests on our proposed systems based on the most complicated variables and scenarios that we had encountered in year 1. When we stumbled, we analyzed and clarified why and then refined the workflow (and/or our tools in use) further.
 
This is the kind of behind-the-scenes value add that we live to provide, and that really makes a difference to our clients.
  
Step 4. Implement technology solutions to streamline the workflow. 
Most of our process improvements revolved around technology that would: 
  1. Take the guesswork out of the workflow for the staff
  2. Eliminate (or at least significantly limit) staff improvisation or deviation from the process
  3. Create a paperless, but seamless, record for all involved – the family, the staff, and us
  4. Automate the workflow as much as possible
 
This laser focus on really leveraging the technology at our disposal was key. We all have tech in use at work – but does it really WORK for us? We were determined that should be the case.
 
So, we did things like: 
  • Drafted two online forms for the client to use and distribute (on their own website) detailing the new payment structure, rates, etc. When this form is completed, we get copies of the form emailed to us automatically.
  • Created a spreadsheet for our own Blue Fox use to track gross fees, subsidies, and yes, the few exceptions here and there.
  • Created two online forms that integrate with our internal project management software (Hive). These forms are used by staff when registration is complete and the forms immediately trigger new tasks for us. This allows us to stay on top of new registrations, invoicing, and troubleshooting in real-time rather than scramble to catch up with staff ad hoc.
  • Refined the Chart of Accounts in QuickBooks and restricted the staff use to certain income lines only so we could run quick reports and spot anomalies/errors efficiently.
  • Set up recurring invoices, sales receipts, and journal entries in QuickBooks to ensure real-time, accurate reporting on tuition and subsidies – a huge help to the client for grant writing, too!
  
Step 5. Communicate the changes with staff and stakeholders to ensure unity in approach.  
The final and, arguably, most important step was to communicate with and educate staff on the new workflow. The executive director took the lead here as you might expect, and we were on hand to answer questions after the staff had a chance to digest the new workflow.
 
Did a few additional changes/needs arise after those conversations? You betcha. Were they as onerous or numerous as the prior year? Not by a longshot – at most, we have 5-10% of the curve balls we had last year.
 
And while the staff was busy taking these changes to their participants and other stakeholders, we were busy developing staff training materials to ensure accounting data entry accuracy throughout the year. These how-to docs sit on staff desks and guide them through every step of the payment receipt process.
  
You can’t argue with the results. 
This consultation was a huge investment of Blue Fox time – candidly, we billed less than half the time we spent on this project. But for us, it was 100% worth it – this was a short-term project with long-term impact across the organization. And critically, efficiency has soared. It’s hard to estimate the amount of time saved this year versus last year, but we think our processing time is down by half or more.
 
The staff is no longer using paper forms to collect registrations, nor are they using disparate spreadsheets to track data and payments. Winning!!
 
We spotted the challenges, used our 20/20 hindsight to analyze them in granular detail, and then applied our macro-view foresight to innovate our way to success. Through sheer willpower and a won’t-quit-until-it’s-right mentality, we have iterated our pants off until, as ME says, “we assured consistency across the organization in complex scenarios… we brought fusion to a very disjointed process.”
 
Does your accountant do that? If not – you might want to email or  call us at (321) 233-3311 to find out how we can help solve your back-office workflow problems. Go ahead. We have lots of free time now. ;) 
Picture
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Our Blog

    Welcome to the Blue Fox Blog! A fairly entertaining source of info and news related to our company, nonprofits, social sector trends, and, of course, accounting. Enjoy!

    Subscribe

    Top Articles

    Back to Basics: How to Set Up Your Nonprofit Chart of Accounts

    How "Small" Payroll Mistakes Cause Multi-Year S#!t Storms for Nonprofits


    Behind the Scenes, New Client Onboarding Call

    When to Hire a Tax Professional - 10 Factors to Consider

    40+ Ideas to Light a Fundraising Fire Under Your Nonprofit Board Members

    Why Outsource Your Nonprofit Accounting to Blue Fox?  Ask One of Our Newest Clients

    Client CASE STUDY: One of The Most Financially Sustainable Nonprofit Orgs We Know

    The Magical Nonprofit Financial Ratio Matrix

    10 Reasons to Outsource Your Nonprofit Accounting
    ​
    How to Make Your Nonprofit Recession-Proof


    ​How to Engage Your Board of Directors in Financial Conversations

    QB Tip of the Month: How to Use Classes for Painless Grant Writing
    ​
    When to Hire an Accountant for Your Social Impact Org

    Are You Paying Too Much for Payroll?

    Company News

    Blue Fox Teams Up With Bloomerang to Develop Nonprofit Resources

    Blue Fox Earns Better Business Bureau Accreditation

    Blue Fox Launches Protected By Logo
    ​
    Blue Fox - The Origin Story
     

    Categories

    All
    Blue Fox Foundation
    Company News
    For Individuals
    For Nonprofits
    For Social Enterprises
    Press Announcements

    Archives

    March 2023
    January 2023
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    November 2018
    October 2018
    September 2018

    RSS Feed

Request A Quote

Services

Subscribe

Contact

Disclaimer


Picture
Picture
NTEN Nonprofit Technology Network Member
QuickBooks Certified ProAdvisor
Picture
Picture
Picture
Picture
Picture
Picture
Certified Financial Planner
Picture

BLUE FOX
Phone:
(321) 233-3311, Email: hello@yourbluefox.com
Mailing Address: 2542 Woodfield Circle, Melbourne, FL 32904
Copyright © 2023 - All Rights Reserved
​
​Holiday office closures:
To give our employees time to unplug and refresh with their family and friends, the Blue Fox virtual office closes 
for all federal holidays, the week of Thanksgiving, and the week between Christmas and New Year's Day.
  • Accounting Services
    • Employee Retention Credit (ERC) Eligibility
  • Tax Preparation
    • Tax Deadlines
  • About
    • Our Founder & CEO
    • Our Team
    • Our Clients
    • Now Hiring: Bookkeeper
    • Our Philosophy
    • Benefits of Outsourced Accounting Services for Nonprofits
    • Technology Solutions
    • Testimonials
    • FAQs
    • Join the Team >
      • Now Hiring: Tax Specialist (Remote)
  • Blog
  • Freebies
  • Contact
  • Subscribe