cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Quickbooks 2019 iif format question

Hi -

 

After upgrading to 2019 part of my IIF is failing, it imports the bulk, but these lines are rejected with the error: "The sum of the amounts in the transaction header and distribution line must be zero [11087]"

 

When I sum the line it looks correct, but I am not an accountant, I am a small business owner and a programmer. Can someone tell me why this IIF is invalid in QB 2019?  Thanks!

 

 

!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM CLEAR TOPRINT MEMO
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM CLEAR MEMO
!ENDTRNS

TRNS T186348A DEPOSIT 05/06/2019 Trust Checking 1022 N N Property One 2019-05-06 #186348
SPL S186348A1 DEPOSIT 05/06/2019 Client Deposits Collected Client One -1054 N Property One 2019-05-06 #186348
SPL S186348A2 DEPOSIT 05/06/2019 Client Deposits Collected Client One -128.83 N Property One 2019-05-06 #186348
SPL S186348A3 DEPOSIT 05/06/2019 Merchant Fees Client One 32 N Property One 2019-05-06 #186348
SPL S186348A4 DEPOSIT 05/06/2019 MGDC Booking Fees Client One 128.83 N Property One 2019-05-06 #186348
ENDTRNS
TRNS T153311A DEPOSIT 05/15/2019 Trust Checking 905 N N Property Two 2019-05-15 #153311
SPL S153311A1 DEPOSIT 05/15/2019 Client Deposits Collected Client One -933 N Property Two 2019-05-15 #153311
SPL S153311A2 DEPOSIT 05/15/2019 Client Deposits Collected Client One -111.39 N Property Two 2019-05-15 #153311
SPL S153311A3 DEPOSIT 05/15/2019 Merchant Fees Client One 28 N Property Two 2019-05-15 #153311
SPL S153311A4 DEPOSIT 05/15/2019 MGDC Booking Fees Client One 111.39 N Property Two 2019-05-15 #153311
ENDTRNS
TRNS T183938A DEPOSIT 05/06/2019 Trust Checking 2668 N N Property Three 2019-05-06 #183938
SPL S183938A1 DEPOSIT 05/06/2019 Client Deposits Collected Client Two -2750 N Property Three 2019-05-06 #183938
SPL S183938A2 DEPOSIT 05/06/2019 Client Deposits Collected Client Two -360.25 N Property Three 2019-05-06 #183938
SPL S183938A3 DEPOSIT 05/06/2019 Merchant Fees Client Two 83 N Property Three 2019-05-06 #183938
SPL S183938A4 DEPOSIT 05/06/2019 MGDC Booking Fees Client Two 360.25 N Property Three 2019-05-06 #183938
ENDTRNS
TRNS T188363A DEPOSIT 05/02/2019 Trust Checking 1916 N N Property Four 2019-05-02 #188363
SPL S188363A1 DEPOSIT 05/02/2019 Client Deposits Collected Client Three -1975 N Property Four 2019-05-02 #188363
SPL S188363A2 DEPOSIT 05/02/2019 Client Deposits Collected Client Three -255.78 N Property Four 2019-05-02 #188363
SPL S188363A3 DEPOSIT 05/02/2019 Merchant Fees Client Three 59 N Property Four 2019-05-02 #188363
SPL S188363A4 DEPOSIT 05/02/2019 MGDC Booking Fees Client Three 255.78 N Property Four 2019-05-02 #188363
ENDTRNS

 

 

5 Comments 5
Highlighted
QuickBooks Team

Quickbooks 2019 iif format question

Thanks for choosing QuickBooks as your accounting software, MarkG2.

 

The IIF import feature will recognize an error if the information isn't mapped properly. I recommend downloading the Import Kit and following the set format. For your reference and guidance, check the articles below:

After that, import the IIF file once again.

 

If you get the same error message, I suggest reaching out to our phone team to conduct a screen sharing session with you. Checking your setup and that imported transaction would require thorough investigations.

 

Refer to this link for their contact details: Contact the QuickBooks Desktop Customer Support Team.

 

That's it. Be sure to let me know how this works for you, @MarkG2. I'm still here to help you more if you need further assistance. Have a good one!

Highlighted
Level 1

Quickbooks 2019 iif format question

I've used the import kit and I believe it is set up correctly. This was working on previous versions of Quickbooks. Most recently 2016.  I upgraded to 2019 and this is my first import. I have transactions that appear identical in format going though in this same IIF. This particular file I cut just the failed transactions from contained 15 of these identically formatted split transactions. 11 were accepted, 4 were rejected (those shown) with this message that seems to indicate the splits don't total the transaction, however the split does total the transaction. 

 

I've made it easier to read formatting the tab stops on a jpg:

Here is an example of a rejected and an accepted transaction from the same file:

 

Untitled-1.jpg

 

 

Highlighted
Moderator

Quickbooks 2019 iif format question

Hello there, MarkG2.

 

I appreciate you taking the time to keep us updated and for the screenshots you have provided.

 

To properly check and investigate this issue with importing QuickBooks Desktop, I recommend contacting our Customer Care Team. They can further investigate this issue and provide additional troubleshooting steps.

  1. Click Help at the top menu and select QuickBooks Desktop Help.
  2. In the Have a Question? window, click Contact us.
  3. Enter the details of your concern and click Continue.
  4. Choose how you want to reach them and enter the needed information.​

Stay in touch with me if there's anything else you need. The Community always has your back and I'd be delighted to help should you have any QuickBooks related questions.

Highlighted
Level 1

Quickbooks 2019 iif format question

Is it possible that someone who can help would be looking at this thread? Because I can not contact your support via this manner currently and I do believe I have narrowed it down further. 

 

I can submit two transactions in IIF, both with identical format and data other than "amount" column numbers, with both summing to 0 (though the error indicates otherwise) - I can have one fail, and one not fail. This narrows down the possibilities of error cause to only one thing I can imagine: a bug in your IIF processing. 

 

For example, if you take that first transaction in the example that fails as-is, but change nothing but the following in the "amount" columns, it goes though:

TRNS line: AMOUNT: 2668

SPL LINE 1: AMOUNT: -2750

SPL LINE 2: Unchanged

SPL LINE 3: AMOUNT: 82

SPL LINE 4: Unchanged

 

Normally this would indicate to me that I made a math error, however both, including the one that fails, sum to zero. 

 

(note that in my third example rejected transaction has an error from our end. The other three examples appear to suffer from this above.)

Highlighted
Anonymous
Not applicable

Quickbooks 2019 iif format question

Thank you for reaching out in the Community, @MarkG2.

 

I'm here to help share some updated information about the IIF format for QuickBooks 2019.

 

In QuickBooks 2019, if the import is unsuccessful it automatically creates a new .IIF file for failed records with error info. You then have 3 options to move forward:

 

  • Review now opens the new .IIF created. Proceed to "How to review the errors in .IIF" section below.
  • Open in folder opens the folder where the new .IIF file is located.
  • Close closes the window and ignores the Lists and Transactions that weren't imported.

You can refer to this article for more information: Improved IIF Import in QuickBooks 2019.

 

Additionally, since we only have limited tools in supporting the .IIF import, I'd still suggest reaching out to our Desktop Specialists for help. They'll be able to access your account and help you further if the issue persists.

 

Keep me posted if you have other questions with other errors you're encountering in QuickBooks. I'm here to help however I can.

Need to get in touch?

Contact us