Who says that you cannot have the best of both worlds? Well, we say you can, and by both worlds we mean QuickBooks and Excel. Everyone understands that it can be a bit more difficult to edit and create files on QuickBooks but less safe to create important files, like budgets, onto an excel spreadsheet so, why not integrate both together?
Here is how you could create and edit a budget file for QuickBooks in Excel:
If you want to create a file, you should go create a new budget list inside the QuickBooks program by clicking on “Company†located in the top menu, go to “planning and budgetingâ€, and click on “setup budgetâ€. You should then follow the standard procedures of choosing what this file is for.
Once that is set up, the next step is to export the file as an IIF file. This can be done by going to the “file†menu, click on “utilitiesâ€, “export†and then “list to IIF files.†After this is done, make sure to uncheck all the irrelevant file options, and click on the one that best fits your file type.
If you are looking to simply edit a file already made, then you could skip the first step and move onto the exporting step.
You would then want to open the file in Excel by going to open file option, or simply dragging the file into an excel spreadsheet.
Once the exporting step is complete, you can make all the desired edits.
The final step would be to transfer the edited IIF version of the file back to QuickBooks by going to the program, clicking on the files menu, then utilities, and, finally, import and IIF budget list.
Before going ahead and attempting to integrate QuickBooks with Excel, make sure that this is being done with the following Windows versions of QuickBooks: Premier, Pro, Enterprise, and Accountant.
Categorised in: data management