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

When importing journal entries, duplicate accounts were generated. Where did I go wrong?

I created a IIF file for year end journal entries.  Making sure that the accounts number or descriptions matched the QB chart of accounts.  When it was imported, duplicate accounts were created.  To solve the problem, I ended up deleting the entries and manually entering.  Where did I go wrong?

2 Comments 2
BigRedConsulting
Community Champion

When importing journal entries, duplicate accounts were generated. Where did I go wrong?

Generally QB won't create actual duplicate accounts, where duplicate means they have exactly the same  account name.  Nor will let you create two accounts with the same full name manually.

In the IIF file:

- You must use the account name in the IIF file, not the description or account number.

- When importing data for sub accounts you must use the entire account name like Parent:Sub

 

Did you do both of those things?  If not then that's why you got new unwanted accounts after import.

Fiat Lux - ASIA
Level 15

When importing journal entries, duplicate accounts were generated. Where did I go wrong?

@kwh8818 

QB only check Account Name. As an additional option, explore these 3rd party importer tools.

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us