Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I recently viewed a video describing how to upload an Excel budget file into QB Desktop using the Utilities export/import function. However, it is not clear to me how I do this with classes. One account will be spread by month by 6 classes. Can this be done using the iff template?
pmac
Hello there, @pmac.
Thanks for choosing QuickBooks Pro as your accounting tool. I can help you upload a budget into QB Pro from Excel using classes.
Great news! Aside from being able to upload budget, you can also assign classes to them. There are specific heading for the budget template. Just make sure to follow the heading and map the information correctly.
You can refer to the screenshot and articles below for more insights.
Here are the steps in uploading Intuit Interchange Format (.IIF) files:
That should keep you going today, @pmac.
Let me know if there's anything else you need or you have follow up questions about IFF. I'm still here to help you more. Just drop a comment. Wishing you all the best!
Do I upload a different budget by month for each class?
Hi there, @pmac.
Thanks for getting back to us. I'd like to share some additional information about uploading a budget in QuickBooks Desktop.
To answer your question, yes. You can upload the budget for each class by month or one budget per class to to ensure you imported the correct transactions and to avoid issues in the future.
You can follow the steps provided by my colleague above on how to upload using the .IFF files.
For future reference, you may want to check this article: Create a budget in QuickBooks Desktop.
Please know that you're always welcome to post if you have any other questions about the budget. Wishing you and your business continued success.
Hi There - I see the comments on here saying that it is possible to export and import a budget by class by month, but I would appreciate more guidance. The links provided didn't discuss classes really, just the budget and forecasting overall.
We typically base our budget by month by class (we have 20 classes) and use the last 12 months that we closed (for example we are a 9/30 year end and use 8/1-7/31 for our budget period, because we prepare our budget in Aug/Sept and obviously can't use the entire current FY when Sept is not available yet and August isn't hard closed.
Can you provide further technical insight here? Whenever I revisit this functionality of importing and IIF files and exporting/uploading, it does not seem to be made to work with classes, by month.
Thank you in advance for your help!
Hi - Can you please provide further guidance for exporting a budget by class by month using the prior 12 months of closed data (not necessarily a fiscal year) and then importing/uploading that budget by class?
I can be more specific with dates and times, but I cannot figure out how to use the budget import/export and IIF files with our 20 class budget process by month.
Thank you in advance for your help :)
Thanks for joining the thread, @lbrown-citymission.
In QuickBooks Desktop (QBDT), we can customize the budget report to the specific month.
Here's how:
Once done, click the Print drop-down arrow from the Profit & Loss Budget vs. Actual. Then, choose Save as PDF. After that, create the File name and then click Save.
To import those PDF, you can visit to this link: Export or import Intuit Interchange Format (.IIF) files.
I've also added these articles for additional reference:
As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.
Don't hesitate to drop a comment below if you have other questions. I'm always happy to help. Take care!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here