Solved

How to import fiscal year budget (Apr-Mar) into QB Premier 2020 Desktop

Forum|Forum|5 years ago
April 21, 2021
3 replies
0 views

I've tried exporting from QB the budget into an IFF file, then making updates to it in Excel and then trying to import the updated IFF file back into QB, but I continually receive this error for EVERY line item in the budget: [ERROR] It's a list or transaction that is not supported by the IIF import process

QuickBooks Desktop

Best answer by BigRedConsulting

@bjgorski @Althepal3 @bjgorski

RE: [ERROR] It's a list or transaction that is not supported by the IIF import process

Yes, this is happening because the new "improved" import was not coded to include budgets. It's as if the development team in India didn't even know they existed.

I don't know why the intuit employees posting here don't know this. All they had to do was try it and they'd get the same error message. Everyone does.

This is just one of many errors with the reviewed import process. To import budgets, use the old method, which Intuit left in the code, but you have to access using the little link at the bottom of the import window.

For steps, see BRC QuickBooks 2019+ IIF Import Changes and Recommendations

MaryLandT

Let's get rid of the error so you can import budgets in QuickBooks, bjgorski.

You'll receive this error when a specific field on the IIF file isn't mapped correctly. Check out this link to get a sample template of the file: IIF Overview: import kit, sample files, and headers.

Once you have the file ready, here's how to upload the budget:

Click File.
Choose Utilities.
Select Import.
Click IFF Files.

For more details about creating a budget, check out this article: Create a budget or forecast in QuickBooks Desktop.

I'm adding these articles to learn more about Intuit Interchange Format (IIF) files, check out these articles:

Keep me posted if you have any additional questions or concerns about importing budgets in QuickBooks. I'll be glad to assist you with this.

B

bjgorskiAuthor

Unfortunately, none of the information you provided deals with Budgets.

Further, I tried successfully EXPORTING an existing budget from Quickbooks to an IIF file. Then, (without making any changes to the IIF file, and not even opening the IIF file, attempted to import the file back into Quickbooks. This was unsuccessful, and I received the same error message that I have been receiving all along...

JasroV

I appreciate you for sharing the details of your concern with us, Brian.

I want to ensure I provide you the right resolution to fix the issue you’re having with importing an IIF file. Can you share with me the specific error message you received? Any additional information can help us narrow things down.

Also, you’ll want to make sure your QuickBooks Desktop (QBDT) is updated to the latest release. An outdated program can cause unusual behavior that prevents you from importing your file. Allow me to walk you through the steps.

Go to the Help menu and select Update QuickBooks Desktop.
Click the Update Now tab.
Select Get Updates to start the download.
When the download finishes, restart QuickBooks.
Then accept the option to install the new release.

For more insights, you can also check this article: Update QuickBooks Desktop to the latest release.

If the issue persists, I recommend running the Verify Rebuild tool. This tool scans your company file for errors and fixes it right away.

I’m also adding this link that you can utilize to learn more about importing IIF files. This provides complete information on the task you can do using IIF.

Keep me posted if you need further assistance importing your files in QBDT. I’ll be around to back you up. Have a good one!

BigRedConsultingAnswer

@bjgorski @Althepal3 @bjgorski

RE: [ERROR] It's a list or transaction that is not supported by the IIF import process

Yes, this is happening because the new "improved" import was not coded to include budgets. It's as if the development team in India didn't even know they existed.

I don't know why the intuit employees posting here don't know this. All they had to do was try it and they'd get the same error message. Everyone does.

This is just one of many errors with the reviewed import process. To import budgets, use the old method, which Intuit left in the code, but you have to access using the little link at the bottom of the import window.

For steps, see BRC QuickBooks 2019+ IIF Import Changes and Recommendations

C

chrissmck

I used the old method and it did import but for some odd reason it imported only half the fiscal year and with the wrong data. So, the July through December populated with January through June data. Our fiscal year is 7/01 to 6/30 and I dated the beginning date in the file to 7/01/2021

JoesemM

I can help you correct your uploaded transactions, @chrissmck.

You can delete those incorrectly imported files in QuickBooks since importing IIF files or data in QuickBooks Desktop is an irreversible process.

You can either delete them one at a time, restore a backup copy dated before the import happened, or use a third-party tool to remove them for you.

I've listed the solutions below, so you can choose which way you'd go for:

Solution 1: Manually deleting transactions or lists.

To remove transactions, click on Lists from the top menu bar and then select Chart of Accounts.
Click to open the account that contains the transactions you want to delete.
Scroll to the transaction in the account screen. QuickBooks displays transactions in date order, with the most recent at the top of the screen.
Click to select the transaction you want to remove.
Press Edit in the main menu and then click Delete.
Click OK to confirm the action.
Repeat this procedure for each transaction you want to delete.
To delete lists, go back to the Lists menu and select the listing you want to remove.

Solution 2: Find the most recent backup of the company file before the import and restore it. For the steps to find the third-party app, backup, and how to restore it, refer to the links below:

Make sure to review the data before reimporting. Then, ensure to update QBDT to its latest release. Most of the time, performing this action can fix data issues.

I've collected these articles for reference with importing files in QuickBooks:

Keep me posted if you have any other concerns or questions about importing or exporting your data. I’ll be around ready to help you. Take good care, @chrissmck.

L

ladae007

Using QB Desktop Enterprise 2021.

With 5+ hours of trial and error I was able to import excel FY budget for Oct 2021 - Sept 2022 successfully.

-In the IIF file enter the Startdate as 10/1/2021 for the portion of the FY for Oct 2021 - Dec 2021 and left the remaining 9 months of cells blank.

-For Jan 2022 - Sept 2022 I entered the Startdate as 1/1/2022 and only entered 9 months of the budget and left the remainding 3 months blank. I even used the class.

I was able to import it by prompting QB to ignore errors.

V

vittoverd

Hi, I am having the same issues with importing the FY budget and it would be great if you could find some time to answer some questions that I have about your import.

- Did you use the "import now for me and I will fix it later" method?

- Did you import the first 3 months and and then the remaining 9 months using two different IIF template? Or did you use the same template, but just changing the content?

Thank you in advance

Sign up

Login with SSO

Login to the community

Login with SSO