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 | | | | | | | | | | | | | |
