UPDATED 11/06/2016 with this video:

The purpose of this article is to walk you though the process of creating an initial budget in QuickBooks, exporting it to IIF, then editing it in Excel, and lastly importing it back into QuickBooks.    Also it is important to point out this whole process as decribed here only works in the WINDOWS versions of QuickBooks: Pro, Premier, Accountant, and Enterprise.

Why do this if I can just create the entire budget in QuickBooks?
Well, most avid excel users feel that working the budget within Excel is much faster because of their ability to use formulas to project increases or decreases in the income and expense accounts.

So, therefore here are the steps

  1. First you need to CREATE the Budget inside QuickBooks by going into the Company Menu and then Planning & Budgeting: Set Up Budgets
    SETUP BUDGET
  2. Secondly, follow the standard process to select the year and type of budget.
    Screen Shot 2014-02-16 at 3.20.28 AM
    Screen Shot 2014-02-16 at 3.20.39 AM
  3. Then Export the budget as an IIF File, clicking on File, Unitizes Export, List to IIF Files…
    list to iif
  4. You need to choose only, Budget as the check marked option to avoid confusion on the Excel file
    Screen Shot 2014-02-16 at 3.25.30 AM
  5. The next part is a bit tricky, you must open Excel and then open the file in excel directly by going into the File, Open File option or Drag-and-drop the file into the excel spreadsheet, it will look like this:
    Screen Shot 2014-02-16 at 3.31.29 AM
  6. Then replace all the Zeroes with the desired amount, please keep in mind that income accounts need to be in negative (since they are credits) and expense accounts in positive, after you are done just save the file… do not do “Save As”, simple just save.
    Screen Shot 2014-02-16 at 3.36.55 AM
  7. Last step is to import the IIF file back into QuickBooks, by going into File, Utilities, Import, List from IIF…   Then go back to the Set Up Budgets windows to see your imported budget.
    Screen Shot 2014-02-16 at 3.37.41 AM

If you enjoyed this tutorial, I have another article related to importing transactions from excel into QuickBooks, that you may like.

Share →

2 Responses to Create or Edit your QuickBooks Budget in Excel

  1. bryan says:

    Thank you for the information

  2. Mike van de Water says:

    When you’re manipulating the IIF data in Excel, can you link the IIF cells to supporting data in other sheets in the workbook? For example, let’s say your step 6 was the only sheet in the workbook. Can we add sheet 2, populate all the customers that make up our “Accounting and Services Income” figure, and then link the total back to sheet 1, row 4?

Leave a Reply

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



For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net