I can't for the life of me figure out why these 3 imports are getting an out of balance error.
I've successfully imported several invoices with this same format. All tax groups, customers, etc. are in Quickbooks and have correct values/settings.
!TRNS | TRNSID | TRNSTYPE | ACCNT | DOCNUM | NAME | DATE | DUEDATE | AMOUNT | TOPRINT | NAMEISTAXABLE | TERMS | MEMO | SHIPVIA |
!SPL | SPLID | TRNSTYPE | ACCNT | DOCNUM | NAME | DATE | INVITEM | AMOUNT | QNTY | TAXABLE | PRICE | MEMO | EXTRA |
!ENDTRNS |
|
|
|
|
|
|
|
|
|
| Due on |
|
|
TRNS |
| INVOICE | 1100 | INV-110 | Smith-939 | 5/2/2023 | 5/2/2023 | 3975.00 | N |
| Due on Receipt | INV-W7040 |
|
SPL |
| INVOICE | 4400 |
|
| 5/2/2023 | Widget | -155.00 | -1 | Y | 155 |
|
|
SPL |
| INVOICE | 4400 |
|
| 5/2/2023 | Widget | -885.00 | -1 | Y | 885 |
|
|
SPL |
| INVOICE | 4400 |
|
| 5/2/2023 | Widget | -20.00 | -1 | Y | 20 |
|
|
SPL |
| INVOICE | 4750 |
|
| 5/2/2023 | Item Discount | 0.44 | -1 | Y | 0.44 |
|
|
SPL |
| INVOICE | 4000 |
|
| 5/2/2023 | Widget | -1812.50 | -14.5 | Y | 125 |
|
|
SPL |
| INVOICE | 4400 |
|
| 5/2/2023 | Widget | -800.00 | -1 | Y | 800 |
|
|
SPL |
| INVOICE |
|
|
| 5/2/2023 | SOUTH TX | -302.94 |
|
| 8.25% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 5/2/2023 | TEXAS | -229.50 | 229.50 |
| 6.25% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 5/2/2023 | CITY 123456 | -73.44 | 73.44 |
| 2% |
| AUTOSTAX |
ENDTRNS |
|
|
|
|
|
|
|
|
|
|
|
|
|
TRNS |
| INVOICE | 1100 | INV-111 | Revo-914 | 5/3/2023 | 5/3/2023 | 398.00 | N |
| Due on Receipt | INV-W7041 |
|
SPL |
| INVOICE | 4400 |
|
| 5/3/2023 | Widget | -218.75 | -1.75 | Y | 125 |
|
|
SPL |
| INVOICE | 4400 |
|
| 5/3/2023 | Widget | -23.00 | -1 | Y | 23 |
|
|
SPL |
| INVOICE | 4400 |
|
| 5/3/2023 | Widget | -20.00 | -1 | Y | 20 |
|
|
SPL |
| INVOICE | 4750 |
|
| 5/3/2023 | Item Discount | 0.66 | -1 | Y | 0.66 |
|
|
SPL |
| INVOICE | 4400 |
|
| 5/3/2023 | Widget | -110.00 | -1 | Y | 110 |
|
|
SPL |
| INVOICE |
|
|
| 5/3/2023 | WEST TX | -26.91 |
|
| 7.25% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 5/3/2023 | TEXAS | -23.20 | 23.20 |
| 6.25% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 5/3/2023 | SPD 5177777 | -3.71 | 3.71 |
| 1% |
| AUTOSTAX |
ENDTRNS |
|
|
|
|
|
|
|
|
|
|
|
|
|
TRNS |
| INVOICE | 1100 | INV-112 | Dematas-401 | 6/21/2023 | 6/21/2023 | 1060.50 | N |
| Due on Receipt | INV-W7041 |
|
SPL |
| INVOICE | 4400 |
|
| 6/21/2023 | Item Discount | -350.00 | -1 | Y | 350 |
|
|
SPL |
| INVOICE | 4750 |
|
| 6/21/2023 | Item Discount | 0.10 | -1 | Y | 0.1 |
|
|
SPL |
| INVOICE | 4400 |
|
| 6/21/2023 | Item Discount | -687.50 | -5.5 | Y | 125 |
|
|
SPL |
| INVOICE | 4750 |
|
| 5/3/2023 | Invoice Discount | 62.50 | -1 | Y |
|
|
|
SPL |
| INVOICE |
|
|
| 6/21/2023 | PARIS TX | -85.60 |
|
| 8.25% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 6/21/2023 | TEXAS | -64.86 |
|
| 6.25% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 6/21/2023 | TRANSIT 121212 | -10.37 |
|
| 1% |
| AUTOSTAX |
SPL |
| INVOICE | 2500 |
| Texas State Comptroller | 6/21/2023 | CITY 343434 | -10.37 |
|
| 1% |
| AUTOSTAX |
ENDTRNS |
|
|
|
|
|
|
|
|
|
|
|
|
|
Solved! Go to Solution.
Well I provided incorrect information.
As it turns out
-1 of the invoices was off by a penny.
- the other invoices had sales tax groups that had not existed so they got added as service items
Once I inspected more thoroughly I found the issues.
Hi there, @crhambrick! I totally understand how frustrating it can be when an issue impacts your business tasks. No worries, I'm here to provide you with some insights into what's causing this issue.
Based on the provided sources related to importing invoices via IIF files in QuickBooks Desktop 2018, here is a summary of the key information:
In summary, when working with IIF files to import invoices in QuickBooks Desktop 2018, attention to specific fields, proper mapping, and consulting additional resources can help ensure a successful import process.
Moreover, please note that Intuit does not provide technical support for importing and exporting IIF files. However, if the IIF file you are using came from a third-party application, please contact the technical support of that application for assistance.
Additionally, you might find it helpful to check out these articles and with some videos to get more information:
Feel free to comment below if you have more questions about the bank transactions related to QuickBooks Desktop. I'm sure to help. Have a great day!
Run the Verify/Rebuild Data utility. Did you encounter any error message?
Well I provided incorrect information.
As it turns out
-1 of the invoices was off by a penny.
- the other invoices had sales tax groups that had not existed so they got added as service items
Once I inspected more thoroughly I found the issues.
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