Question:
When importing IIF files into QuickBooks Desktop, the account numbers for Accounts Receivable (12000) and Sales Tax Payable (23000) were being duplicated in the description (e.g., “12000 AccountsReceivable”). Rundoo’s chart of accounts looked fine, so the user suspected the issue might be in the IIF file formatting.
Root Cause:
The NAME column in the .iif file was being populated with the account number (e.g., 12000 or 23000) on those lines. For system-sensitive accounts like A/R and Sales Tax, QuickBooks Desktop misinterprets this as extra data and appends it to the account name or causes import issues.
Solution:
Correct the Accounts Receivable Customer within the Rundoo system to something like “Customers”