Question: Quick question if you have time. Can data from Quickbooks for nonprofits be directly exported to the 990? Thanks a bunch.
Answer:
The only software I know of that can import QuickBooks info into a 990 is ProSeries. However, it’s designed for tax preparers so it’s pretty expensive.
Don’t forget that much of the information required on the 990 isn’t financial information contained in QuickBooks. Because of this, I usually recommend using QuickBooks reports instead of worrying having a direct import into the 990. If you’re using QuickBooks for Nonprofits, there’s a Statement of Functional Expenses (990). If not, you can use a Profit & Loss by Class report.
No matter what you decide, it’s critical that your classes are setup correctly to mimic the 990 information - at the very least you’ll need these three:
G&A
Fundraising
Programs
And if you have any temporarily or permanently restricted funds, these six:
Unrestricted:
G&A
Fundraising
Programs
Temporarily restricted
Permanently restricted
You can add additional sub-classes if you want to track particular programs, restricted funds, grants, etc.
If we helped solve your problem, please consider spending a minute or two posting a review for us.
____________________________________________________________
Written by Ruth Perryman, CMA, CFE, CFM, MBA, DPA (ABD)
Ruth is the president of The QB Specialists, an Intuit Solutions Provider that has helped thousands of businesses throughout the United States, Canada and even the Caribbean get the most out of QuickBooks since 1996. Ruth has over 20 years of industry experience, including 5 years as a Chief Financial Officer. She is an Advanced Certified QuickBooks ProAdvisor and a member of Intuit’s Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and Enterprise.
For more QuickBooks Tips & Tricks, subscribe to her monthly newslettter.
Looking for QuickBooks Point of Sale or Enterprise? Call 800-707-0940 or email us to save up to 46% off!

Enjoyed this post? Subscribe to QuickBooks Tips & Tricks via RSS Feed or via Email and receive free daily QuickBooks tips.