cancel
Showing results for 
Search instead for 
Did you mean: 
crhambrick
Level 2

Importing Invoices via IIF--why are they out of balance? (QB Desktop 2018)

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
Best answer March 15, 2024

Best Answers
crhambrick
Level 2

Importing Invoices via IIF--why are they out of balance? (QB Desktop 2018)

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.

 

 

View solution in original post

3 Comments 3
VoltF
QuickBooks Team

Importing Invoices via IIF--why are they out of balance? (QB Desktop 2018)

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:

 

  • When importing invoices via IIF files, it is possible to use a sales tax group, but there are specific fields like ADDR2 and ADDR3 that need to be added to ensure billing addresses are recognized by QuickBooks Desktop.
  • To import transactions to a Sub-GL (Sub-Genera Ledger), it is essential to ensure that the ACCNT field in the import file states the Sub-GL name correctly. If transactions are not showing up in the General Ledger report, it might be due to missing information in the import file.
  • There are resources available, like the IIF Overview, that provide sample files, headers, and definitions for IIF fields, which can help understand the import process and mapping fields correctly.
  • It is possible to import sub-accounts to the General Ledger, but for detailed guidance, consulting with an IT specialist or using integrated third-party apps is recommended.

 

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!

4Gal
Level 10

Importing Invoices via IIF--why are they out of balance? (QB Desktop 2018)

@crhambrick 

Run the Verify/Rebuild Data utility. Did you encounter any error message?

crhambrick
Level 2

Importing Invoices via IIF--why are they out of balance? (QB Desktop 2018)

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.

 

 

Need to get in touch?

Contact us