Solved

Bulk import of Customer / Supplier Opening Balances (Desktop Premier)

Forum|Forum|5 years ago
November 23, 2020
3 replies
0 views

Hello,

I currently use QuickBooks Enterprise Version and have recently purchased the QuickBooks desktop Premier 2021 Version.

In the current Enterprise Version, I do have approx. 4K customers & 1K suppliers – and most of the accounts have an opening balance – Either a Debit / Credit.

Is there a Sample file structure or a template available wherein I can import the same using IIF files or Excel onto QuickBooks Desktop Premier? I have tried using the custom template that’s available on the desktop premier version – but that does not provide an option to enter an opening balance.

Do I need to first import the customer/supplier list and then import the opening balances via journal entry?

I will not be in a position to manually update the opening balances for an individual client as of X date.

Any help or some guidance on how to do it will be helpful. I also did check with QB support but in Vain.

Many Thanks

Chris.

QuickBooks Desktop

Best answer by JonpriL

Hello @shaun gonsalves,

Let me help share information about how you use an IIF file to transfer your list entry in both QuickBooks version.

To start with, you'll have to download a kit containing all the tasks you need to do in creating an IIF file of your list entry. Also, the article has listed a sample file you can create based on the list entry you need to transfer.

That being said, here's an article where you can find the link to download the IIF kit: IIF Overview: import kit, sample files, and headers.

Once done, this article will show you the steps on how to transfer the IFF file in each QuickBooks version: Export, import, and edit IIF files.

Additionally, I've got you this helpful article for the troubleshooting steps in case you'll bump into an error while importing your IFF file: Improved IIF Import in QuickBooks.

If there's anything else that I can help you with, please let me know in the comments. I'll be here to lend a hand. Stay safe!

A

Ashleigh1

Hello Chris,

Welcome to the Community page,

If you go to customise you can add in the opening balance field and as for the template as long as it matches the layout in Quickbooks it should be fine to upload without any issues. You can recognise Quickbooks order as well if you would prefer not to change the excel file.

You can try the IIF if you want but it's not supported by us as it's not a file type we can modify so it's at your own risk. It may work, it may not.

We would recommend using Excel to upload instead.

S

shaun gonsalvesAuthor

Many thanks..

Fiat Lux - ASIA

@shaun gonsalves

Consider having one of these migration tool to speed up your works. You may import the opening balance as Journal Entry.

https://transactionpro.grsm.io/qbd

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

J

JonpriLAnswer

Hello @shaun gonsalves,

Let me help share information about how you use an IIF file to transfer your list entry in both QuickBooks version.

To start with, you'll have to download a kit containing all the tasks you need to do in creating an IIF file of your list entry. Also, the article has listed a sample file you can create based on the list entry you need to transfer.

That being said, here's an article where you can find the link to download the IIF kit: IIF Overview: import kit, sample files, and headers.

Once done, this article will show you the steps on how to transfer the IFF file in each QuickBooks version: Export, import, and edit IIF files.

Additionally, I've got you this helpful article for the troubleshooting steps in case you'll bump into an error while importing your IFF file: Improved IIF Import in QuickBooks.

If there's anything else that I can help you with, please let me know in the comments. I'll be here to lend a hand. Stay safe!

S

shaun gonsalvesAuthor

Hello Jonpril

Many thanks for sharing the file, that was very much useful.

With the customer and vendor, I was able to import using IIF file, but the opening balances never got imported and showed '0.00'

As am exporting the opening balances from my current 'QB Enterprise' and importing it to 'QB Desktop Premier' version by making the necessary changes to the structure format - should i be importing it by hitting the Chart of Accounts - Accounts Receivable / Accounts Payable or import all customers / vendors opening balances as a journal entry ?

It's the same with Chart of Accounts - When i imported the data of my old company file to QB Desktop Premier, it never took the opening balances and showed everything as - 0.00.

Any idea, how do i go about it?

Kind Regards,

Chris.

A

Ashleigh1

Hello Chris,

So if you are creating a new customer then you will be able to put an open balance in for that new customer.

If it is for customers that already exist in your account then you would need to put the opening balance in via a journal entry.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded