BLUE FOX | Accounting for Nonprofits and Social Enterprises
  • Home
  • Services
    • Tax Services
  • About
    • Our Founder
    • Our Team
    • Our Philosophy
    • 10 Reasons to Outsource Your Nonprofit Accounting
    • Our Clients
    • Technology Solutions
    • Testimonials
    • FAQs
    • Join the Team - Bookkeeper
  • Blog
  • Freebies
  • Contact
  • Subscribe

QuickBooks Tip of The Month: How to Use Classes for Painless Grant Writing

6/16/2019

1 Comment

 

"Getting data you need for a grant request all comes down to the setup of your financial systems."

Picture
You sit at your laptop staring at the screen. You know that you need to finish this grant request, but you’re stuck. The narrative is coming along, but your roadblock is the financial justification for the grant. You flip through spreadsheets on your computer, you try to read the financials from the last month. But your eyes are crossed – you’re just not seeing what you need to make the case.
 
Grant writing is stressful enough without the added burden of working with bad (or at least useless) financial data. If you are an ED or a development professional who’s tasked with writing grant proposals, you’ve probably thought to yourself: there must be a better way. 
 
And you’re right.
 
Getting data you need for a grant request all comes down to the setup of your financial systems.
 
Most US-based small to medium-sized nonprofits use some version of QuickBooks for their accounting. It has its quirks, but it’s a solid piece of software. One of my favorite features of QuickBooks is chronically unsung and under-utilized. It’s called CLASSES. Prepare to be wowed.
 
In the for-profit world, classes are often used for cost center or location-based tracking of revenue and expenses. Easy example: a retailer with more than 1 store. The management needs to see what stores are profitable, right?
 
Here’s what a (very simplified) profit and loss report using classes might look like in that case: 
 
PROFIT & LOSS BY CLASS (LOCATION) YTD
Picture
Being able to analyze income and expenses according to location allows management to make better decisions about where to invest staff, time, and money to ensure profitability and sustainability.
 
Brilliantly, this same classes tool in QuickBooks can be used to track program revenue and expenses. (Can you feel the excitement building?? #nerdalert)
 
Using this method, you can allocate a percentage of staff salaries, general overhead, and direct program costs to each program WITHOUT adding a gazillion lines to your Chart of Accounts.
 
Here’s what that might look like for an environmental education nonprofit:
Picture
Do you see the leverage and empowerment that comes with this kind of accounting setup? If you were writing a grant for this organization’s adult programs, you’d be able to easily make the case for shortfall and demonstrate the need, right?
 
On the other hand, if you were writing a grant for the expansion of your K-12 programs, you could evaluate the estimated cost of that expanded reach based on the annual spend in that class.
 
Once you have your accounting system set up in this way, you can budget by class, run regular reports by class, and get valuable insights as to what is/is not sustainable from a revenue perspective. This not only assists with grant writing, but it will also lead you to have deeper and more honest conversations about things like program fees, fundraising goals and campaigns, and program budgets.
 
How game-changing would this type of reporting be for you? Imagine the possibilities.
 
A couple of caveats and words of caution: 
  • The use of classes can make reports unwieldy if your Chart of Accounts is large or, for lack of a better term, cluttered.
  • Classes as a feature are not available in all versions of QuickBooks. You may have to upgrade to turn that feature on. Call us if you’re not sure what version you need – we can help you sort it out.
  • When we onboard new clients, we often see classes in use. Unfortunately, they’re being used incorrectly. As a general rule, class labels and categories should be DIFFERENT from line items in your Chart of Accounts.
 
Does it sound like we know our stuff? We do! The Blue Fox team will help get those financials in order and make grant writing a breeze! 

Is your organization ready to outsource the accounting function (here’s how you know)?
 
If anything, let’s review your chart of accounts and class set up.  We are happy to include that in our free consultation?  Let’s schedule time! Call us at (321) 233-3311 or email hello@yourbluefox.com. 
1 Comment
Accounting Packages link
12/15/2020 02:33:30 pm

it depends on the effectiveness of the in-house payroll system. Is it integrated with the accounting system? Does it generate the reports required for statutory reporting purposes? It is worth conducting a cost-benefit analysis and considering the pros and cons of outsourcing, with clear objectives of what the real purpose of the exercise is, i.e. cost efficiency, downsizing

Reply



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

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

    Blue Fox + Bill.com = Clean Audits & Happy Clients
    ​
    What Fuels Financial Sustainability? 


    The Magical Nonprofit Financial Ratio Matrix

    Dear COVID-19, I'm Breaking Up With You

    The Latest COVID-19 Resources for Nonprofits

    10 Reasons to Outsource Your Nonprofit Accounting

    6 Step Guide To Build Donor Trust

    Our Favorite Resources for Nonprofit Fundraisers

    3 Vital Resources for Nonprofit Start-ups

    2020 Nonprofit Trend: The Virtual CFO
    ​
    How to Make Your Nonprofit Recession-Proof

    What Nonprofits Need to Know About the New Overtime Ruling

    Double-entry Accounting Made Easy - Essential Desktop Guide, Free Download

    Blue Fox CEO Named
    As Keynote Speaker for Nonprofit Hub's Cause Camp 2020
      
      

    5 Steps to Solving Complex Workflow Problems

    The Hidden Cost of Wearing Too Many Hats

    The Key to Workplace Success - Investments in Professional Development

    Accounts Payable Made Easy - The Marriage of Bill.com and QuickBooks Online

    Nonprofits - It's Time to Automate Your Back Office


    ​How to Engage Your Board of Directors in Financial Conversations

    How to Join the Social Enterprise Movement
    ​

    Kindness Leads to More Profit & Productivity
    ​

    Don’t Ignore This Nonprofit Management Advice

    ​Building Blocks for A More Just, Equitable, and Inclusive Work Environment

    QB Tip of the Month: How to Use Classes for Painless Grant Writing
    ​
    Nonprofit Leaders - Talk Finance and Empower Your Staff 

    When to Hire An Accountant for Your Social Impact Org

    Why Outsource Your Accounting?

    ​That Time I Went to Cause Camp 

    Impact Investments in Yourself
    ​

    Are You Paying Too Much for Payroll?

    Financial Dashboards - Capture Attention, Create Conversations, Drive Results!

    Don't Let FinTech Scare You - Our Top 4 Back Office Tech 

    The Wonderful World of Micro-Donating!

    The Case for Kindness in Business

    How Nonprofits Build Donor Trust: Be Transparent 
     

    5 New Year’s Resolutions for Sustainable Nonprofits  

    Why We’re on a Mission to Help Conservation Organizations  

    Money Matters - So Why Aren’t More Nonprofits Talking About It?  

    Tips to Get You A Clean Audit Every Year

    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

    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
    December 2018
    November 2018
    October 2018
    September 2018

    RSS Feed

Home

About

Services

Subscribe

Contact


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

BLUE FOX
Phone:
(321) 233-3311, Email: hello@yourbluefox.com
Mailing Address: 2263 W New Haven Ave #339, Melbourne, Florida 32904
Copyright © 2021 - All Rights Reserved
  • Home
  • Services
    • Tax Services
  • About
    • Our Founder
    • Our Team
    • Our Philosophy
    • 10 Reasons to Outsource Your Nonprofit Accounting
    • Our Clients
    • Technology Solutions
    • Testimonials
    • FAQs
    • Join the Team - Bookkeeper
  • Blog
  • Freebies
  • Contact
  • Subscribe