Solved

Importing Transactions via IIF File for past years

Forum|Forum|7 years ago
November 21, 2018
2 replies
0 views

I'm converting an old accounting system to QB Desktop and I want to preserve as much detail as possible. I've created an IIF file for G/L Transactions and an testing the import with data from 2003. In my test, Balance Sheet accounts import correctly. However, when a transaction which involves a P&L account in encountered, I receive a "The number is larger than the maximum allowed" error and the transaction is skipped. Can I not import transactions from previous years that involve P&L accounts?

QuickBooks Desktop

Best answer by AldrinS

Thanks for the clarification, Jim Culpepper.

Allow me to join this thread and help you import your transactions successfully to QuickBooks.

First, I'd like to provide a confirmation to your original question, which is yes, you can import transactions from previous years that involve income and expense accounts (P&L accounts). However, they should follow the right format.

Currently the maximum number allowed should only contain eight digits to the before the decimal point and 2 digits after it (99,999,999.99). With that said, I'd recommend you review the file and make sure that the Quantity, Rate, and Amount of these transactions follow this format.

Once you're done, go back to QuickBooks and try to import the file again. For more information about this process, and the maximum number of entries allowed, you may check out these articles:

I know you've got this. Keep in touch if you need more help with this, and I'll be here right away to assist you.

C

Charies_M

Hello there, Jim Culpepper.

I'd like to share with you some information about importing transactions via IIF file in QuickBooks.

In QuickBooks Desktop, you can importing transactions but there are certain limits that QuickBooks can only process. The error message you're getting when trying to import data from the year 2003 means that a quantity, rate, or amount is larger than what Quickbooks allows.

If wish to be more familiar about exporting or importing IIF files and it's limitations in QuickBooks, you can visit this article: Export or import IIF files.

Should there'll be anything else you need with importing transactions in QuickBooks, just let me know as I'm here to help.

J

Jim CulpepperAuthor

Thank you for your response, but I don't think that is my problem. I have 10 transactions. 8 that affect only balance sheet accounts post fine. 2 that affect 1 Balance Sheet account and 1 P&L account do not post. All dates are in 2003. The AMOUNT of the 2 transactions that do not post are both under $100. The only difference that I can see is that the transactions that do not post involve P&L accounts.

A

AldrinSAnswer

Thanks for the clarification, Jim Culpepper.

Allow me to join this thread and help you import your transactions successfully to QuickBooks.

First, I'd like to provide a confirmation to your original question, which is yes, you can import transactions from previous years that involve income and expense accounts (P&L accounts). However, they should follow the right format.

Currently the maximum number allowed should only contain eight digits to the before the decimal point and 2 digits after it (99,999,999.99). With that said, I'd recommend you review the file and make sure that the Quantity, Rate, and Amount of these transactions follow this format.

Once you're done, go back to QuickBooks and try to import the file again. For more information about this process, and the maximum number of entries allowed, you may check out these articles:

I know you've got this. Keep in touch if you need more help with this, and I'll be here right away to assist you.

J

Jim CulpepperAuthor

Thanks for the response. I kept looking and found a 1 character typo in the header row. Once corrected, all transactions imported correctly. thanks for the help.

Sign up

Login with SSO

Login to the community

Login with SSO