News & Special Offers

QuickBooks Sale!

Dell All-in-One w/touchscreen

Dell Inspiron One All-In-One Computer / AMD Athlon II X2 Processor

How to Budget for Multi-Year Grants in QuickBooks for Nonprofits

Non profits receive several grants all of which are on different operational/reporting calendars. Quickbooks Pro 2008 seems to only allow budgets to be set on a monthly basis related to fiscal year. If you try to set a budget starting on a different day other than the 1st of the month, reports become flawed. Can I set unique budgets for each project. i.e. Project #1 budget start 01/18/09 end 11/21/09. Project #2 start 03/10/09 end 02/28/10. Does QuickBooks nonprofit version address this issue. Thanks for your help.
I have many nonprofit clients and I use Estimates for multi-year grant budgets. First, you need to turn on Estimates. Go to Edit > Preferences > Jobs & Estimates and select Yes under Do You Create Estimates. You may also want to select Yes under Do You Do Progress Invoicing if you think you’ll ever invoice any of your grants for expenses already incurred.

Then you can create estimates in Customers > Create Estimates. It’s based on Items, so it’s really important that they are setup correctly as two-sided entries (pointing to both revenue and expense) because you’ll need to enter your grant expenses using the Items tab instead of the Expenses tab. You won’t be able to enter any grant expenses via journal entry because there are no Items on that form. But you can enter a $0 check listing both the debit (positive $ amount) and credit (offsetting negative $ amount) using the Item tab.

To pull a budget vs. actual report, use the Job Estimates vs. Actuals report located under Reports > Jobs, Time & Mileage. If any grant expenses are entered as expenses instead of items, they’ll show up at the bottom of the report as uncategorized. You can click on the line to open up a list of these transactions and change them to Items.


If we helped solve your problem, please consider posting a review for us!

Ruth Perryman - QuickBooks Specialist Written by +Ruth Perryman, CMA, CFE, CFM, MBA

Ruth is the president of The QB Specialists, Inc. and has provided QuickBooks help to thousands of businesses around the world since 1996. She is an Intuit Solutions Provider, an Advanced Certified QuickBooks ProAdvisor, and a member of the Intuit Trainer/Writer Network. She is also certified in QuickBooks Point of Sale and QuickBooks Enterprise Solutions.

Buying QuickBooks for a client? Call us at 800-707-0940 to discuss what we can do to help!

QuickBooks price list | QuickBooks for sale | Free trial QuickBooks POS | Free trial QuickBooks Enterprise

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>