cancel
Showing results for 
Search instead for 
Did you mean: 
AndreBu
Level 1

Chart of Accounts and Import

I got a quick question.

if you are doing an import from another application into Quickbooks, must All the account names from the program you importing from match that in quickbooks ? or is it that the only the account numbers have to match ? or both ?

 

Solved
Best answer April 06, 2020

Best Answers
Fiat Lux - ASIA
Level 15

Chart of Accounts and Import

QB only checks the name of Account. Account Number is a mere complementary data.

View solution in original post

6 Comments 6
Fiat Lux - ASIA
Level 15

Chart of Accounts and Import

QB only checks the name of Account. Account Number is a mere complementary data.

View solution in original post

BigRedConsulting
Community Champion

Chart of Accounts and Import

When importing transactions, use the account name.  If you use a new name without setting up the account first, then it will be added as a Bank account, the default.  (At least if you are importing using an IIF file.)

For help creating an IIF file that automatically adds new accounts with a more appropriate type, or a type you specify, use our BRC IIF Transaction Creator  or BRC IIF Transaction Creator Pro 

AndreBu
Level 1

Chart of Accounts and Import

Thanks for the reply. will look either renaming those fields in the application or adding new ones to quickbooks.

lsj246
Level 1

Chart of Accounts and Import

How do you fix that once it has been imported to the default bank account?

 

lsj246
Level 1

Chart of Accounts and Import

So how do I fix the accounts if imported without using correct account name and imported  to default?

DivinaMercy_N
QuickBooks Team

Chart of Accounts and Import

Hello there, @lsj246. I've come to help you fix the accounts when importing Intuit Interchange Format (IIF) files in QuickBooks.

 

In QuickBooks Desktop (QBDT), when importing an IIF file, transactions will be automatically posted to their designated account if an account already exists. If the account is not recognized by the program, it will create a new account.

 

In the meantime, I suggest reviewing your IIF file by opening it on excel to check if the accounts there are correct. You can edit it if you're seeing an incorrect account. This way, we can ensure that QBDT will recognize it. If verified they are correct, I'd recommend checking with your third-party service provider to make sure that accounts are mapped properly when importing.

 

For more information about importing IIF files in QBDT, feel free to visit this article: Export, import, and edit IIF files.

 

I've also added this helpful link to give you options on how you can import and export info in QBDT: Import and export data in QuickBooks Desktop. 

 

Just in case you'll have to add, edit, or delete an account in your QBDT program, here's the article that can help you: Add, edit, or delete accounts in QuickBooks Desktop. 

 

You can always get back here if you have any other IIF file importing concerns. I'd be glad to assist you further. Keep safe. 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up