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 "
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
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
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
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
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
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!
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:
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.
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.
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.)
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:
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.