IIF Validation Troubleshooting

Fix common IIF validation errors with step-by-step solutions and examples.

Quick Troubleshooting Tips

Use our IIF Viewer to see exactly which line has the error
Open the file in a plain text editor to see tab characters
Verify account names match your QuickBooks® Chart of Accounts exactly
Test with a single transaction before importing a large batch

Common Errors & Solutions

Missing !ENDTRNS Header

Cause:

The transaction block doesn't have an ENDTRNS row at the end.

Solution:

Add an ENDTRNS row after the last SPL line for each transaction.

❌ Wrong:TRNS\tGENERAL JOURNAL\t...\nSPL\tGENERAL JOURNAL\t...

✓ Correct:TRNS\tGENERAL JOURNAL\t...\nSPL\tGENERAL JOURNAL\t...\nENDTRNS

Transaction Does Not Balance

Cause:

The sum of TRNS and SPL amounts doesn't equal zero.

Solution:

Ensure all amounts in a transaction block sum to exactly zero. Debits should be positive, credits negative.

❌ Wrong:TRNS: -100.00, SPL: 99.00 (sum = -1.00)

✓ Correct:TRNS: -100.00, SPL: 100.00 (sum = 0.00)

Invalid Date Format

Cause:

Date is not in the required MM/DD/YYYY format.

Solution:

Convert all dates to MM/DD/YYYY format. Two-digit years may work but four digits are recommended.

❌ Wrong:2024-01-15 or 15/01/2024

✓ Correct:01/15/2024

Missing Account Name

Cause:

The ACCNT field is empty for a transaction line.

Solution:

Every TRNS and SPL line must have an account name that exists in QuickBooks® or will be created on import.

❌ Wrong:TRNS\tGENERAL JOURNAL\t01/15/2024\t\t-100.00

✓ Correct:TRNS\tGENERAL JOURNAL\t01/15/2024\tChecking\t-100.00

Mismatched Headers

Cause:

!TRNS and !SPL headers don't have the same column structure.

Solution:

Both header rows must list the same columns in the same order.

❌ Wrong:!TRNS: TRNSTYPE, DATE, ACCNT\n!SPL: TRNSTYPE, DATE (missing ACCNT)

✓ Correct:!TRNS: TRNSTYPE, DATE, ACCNT\n!SPL: TRNSTYPE, DATE, ACCNT

Invalid Transaction Type

Cause:

TRNSTYPE value is not recognized by QuickBooks®.

Solution:

Use valid types: GENERAL JOURNAL, CHECK, DEPOSIT, INVOICE, BILL, PAYMENT, TRANSFER, etc.

❌ Wrong:TRNSTYPE: EXPENSE

✓ Correct:TRNSTYPE: GENERAL JOURNAL or CHECK

Special Characters in Memo

Cause:

Memo field contains characters that break the tab-delimited format.

Solution:

Remove or replace tabs, newlines, and certain special characters from memo fields.

❌ Wrong:MEMO: Line 1\nLine 2 (contains newline)

✓ Correct:MEMO: Line 1 - Line 2

Amount Contains Currency Symbol

Cause:

Amount field includes $ or thousands separators.

Solution:

Use plain decimal numbers only. No currency symbols, commas, or parentheses for negatives.

❌ Wrong:$1,500.00 or (1500.00)

✓ Correct:1500.00 or -1500.00

QuickBooks® Import Errors

Sometimes IIF files pass validation but still fail when importing into QuickBooks®. Here are common reasons:

Account Does Not Exist

QuickBooks® can auto-create accounts, but the account type must be determinable. Use standard account names or create accounts in QuickBooks® first.

File is Read-Only

Ensure the company file is not in single-user mode or open by another user.

Date is in Closed Period

If you've closed your books for a period, transactions dated in that period will be rejected.

Duplicate Transaction

QuickBooks® may detect duplicates based on date, amount, and memo. Review for duplicates.

Still Having Issues?

Use our free IIF Viewer to get detailed error messages with line numbers.

Validate Your IIF File

Loading tool...

All Guides

IIF Validation Troubleshooting

Fix common IIF validation errors with step-by-step solutions and examples.

Quick Troubleshooting Tips

Use our IIF Viewer to see exactly which line has the error
Open the file in a plain text editor to see tab characters
Verify account names match your QuickBooks® Chart of Accounts exactly
Test with a single transaction before importing a large batch

Common Errors & Solutions

Missing !ENDTRNS Header

Cause:

The transaction block doesn't have an ENDTRNS row at the end.

Solution:

Add an ENDTRNS row after the last SPL line for each transaction.

❌ Wrong:TRNS\tGENERAL JOURNAL\t...\nSPL\tGENERAL JOURNAL\t...

✓ Correct:TRNS\tGENERAL JOURNAL\t...\nSPL\tGENERAL JOURNAL\t...\nENDTRNS

Transaction Does Not Balance

Cause:

The sum of TRNS and SPL amounts doesn't equal zero.

Solution:

Ensure all amounts in a transaction block sum to exactly zero. Debits should be positive, credits negative.

❌ Wrong:TRNS: -100.00, SPL: 99.00 (sum = -1.00)

✓ Correct:TRNS: -100.00, SPL: 100.00 (sum = 0.00)

Invalid Date Format

Cause:

Date is not in the required MM/DD/YYYY format.

Solution:

Convert all dates to MM/DD/YYYY format. Two-digit years may work but four digits are recommended.

❌ Wrong:2024-01-15 or 15/01/2024

✓ Correct:01/15/2024

Missing Account Name

Cause:

The ACCNT field is empty for a transaction line.

Solution:

Every TRNS and SPL line must have an account name that exists in QuickBooks® or will be created on import.

❌ Wrong:TRNS\tGENERAL JOURNAL\t01/15/2024\t\t-100.00

✓ Correct:TRNS\tGENERAL JOURNAL\t01/15/2024\tChecking\t-100.00

Mismatched Headers

Cause:

!TRNS and !SPL headers don't have the same column structure.

Solution:

Both header rows must list the same columns in the same order.

❌ Wrong:!TRNS: TRNSTYPE, DATE, ACCNT\n!SPL: TRNSTYPE, DATE (missing ACCNT)

✓ Correct:!TRNS: TRNSTYPE, DATE, ACCNT\n!SPL: TRNSTYPE, DATE, ACCNT

Invalid Transaction Type

Cause:

TRNSTYPE value is not recognized by QuickBooks®.

Solution:

Use valid types: GENERAL JOURNAL, CHECK, DEPOSIT, INVOICE, BILL, PAYMENT, TRANSFER, etc.

❌ Wrong:TRNSTYPE: EXPENSE

✓ Correct:TRNSTYPE: GENERAL JOURNAL or CHECK

Special Characters in Memo

Cause:

Memo field contains characters that break the tab-delimited format.

Solution:

Remove or replace tabs, newlines, and certain special characters from memo fields.

❌ Wrong:MEMO: Line 1\nLine 2 (contains newline)

✓ Correct:MEMO: Line 1 - Line 2

Amount Contains Currency Symbol

Cause:

Amount field includes $ or thousands separators.

Solution:

Use plain decimal numbers only. No currency symbols, commas, or parentheses for negatives.

❌ Wrong:$1,500.00 or (1500.00)

✓ Correct:1500.00 or -1500.00

QuickBooks® Import Errors

Sometimes IIF files pass validation but still fail when importing into QuickBooks®. Here are common reasons:

Account Does Not Exist

QuickBooks® can auto-create accounts, but the account type must be determinable. Use standard account names or create accounts in QuickBooks® first.

File is Read-Only

Ensure the company file is not in single-user mode or open by another user.

Date is in Closed Period

If you've closed your books for a period, transactions dated in that period will be rejected.

Duplicate Transaction

QuickBooks® may detect duplicates based on date, amount, and memo. Review for duplicates.

Still Having Issues?

Use our free IIF Viewer to get detailed error messages with line numbers.

Validate Your IIF File