cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
CarolB
Level 3

Item List 14500 limit reached

Hi

 

I am based in the UK and today I tried to enter a non stock item but I cannot enter anymore as I have reached my 14,500 limit. I did not realise there was a limit!!! Basically I have been told i have two options:

1. Switch to Quickbooks Online

2. Set up a new company from scratch entering opening balances

Neither option is good for me

 

Any suggestions. Thanks x

 

Solved
Best answer August 03, 2018

Accepted Solutions
Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi Carol B,

Thanks for posting on the community again!

I'm afraid that having reached the list limit of 14,500 in QuickBooks desktop your options are limited. The 2 options which have been mentioned to you so far are possibilities, namely...

 

1) Exporting your company data to QuickBooks online, where there is theoretically no list limit

2) Starting a brand new QuickBooks company file in QuickBooks desktop, with opening balance and creating only customers/suppliers/ items you need at this time


Of course I know you would much rather keep your current company file, and there is a method by which this may be achieved, albeit a pretty manual one.

Your Names, such as Customers/Suppliers/ employees, and items such as Stock items/non stock items cannot be deleted from QuickBooks if there are any transactions relating to them (Which in most cases there are) without deleting these transactions themselves.

But instead, what you can do is find old names/ Items which are no longer used, and change two of them at a time to have the same name E.G changing two not used stock items in the item list to 'unused'. Once you do this on two old records QuickBooks desktop will ask you if you want to merge the two. If you select yes and merge them, you are effectively turning 14,500 items/names to 14,499 items freeing up another one to be created.

I do appreciate the method suggested is manual, and will take time, but it would allow you to keep running your current company file.

If you have any questions on the above, please don't hesitate to post back.

Thanks.

Chris.
 

View solution in original post

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi CarolB,

No need to apologise for asking questions on the community, that's what we're here for! :)

I understand it does sound like a daunting task starting with a brand new file, but don't worry! We will assist you with everything we possibly can to help get you up and running, and moving forward.

Firstly, you are indeed correct. If you were to export your list items from your current desktop file, and then import them into the new desktop file you will be able to delete the list items as you please as there will be no transactions attached. You can also do this for other list items/names such as 'Customers'/ Suppliers.

A Quick way to do this would be the following.

1. In your current desktop company file click 'File,' 'Utilities' 'Export' then 'Lists to IIF files'

image.png

2. In the next pane, select what you would like to export E.G, Customers, suppliers, and items.

image.png

3. Then on the next pane, give your IIF file a name, and save it somewhere locally on your computer like the desktop.

4. Once you have saved this file, open up your new QuickBooks desktop company file, and click 'File' 'utilities' 'Import' 'IIF files'

image.png

5. Choose the IIF file you have saved, and QuickBooks will import your data. As you say, this will make your clean up of items and names far more efficient, as you will be able to delete at will without having to merge.

Entering opening VAT balances

 

Firstly you are correct, the outstanding VAT liability account balance in your file will be from any potential VAT owed/ reclaimable vat against any open customer or supplier balances.

There is no easy automatic way to do this in QuickBooks Desktop when moving file, but I would advise the below method to be the most thorough.


1. Run supplier and customer balance summary reports in your old QuickBooks file to check the open balances of each.

2. For your customers, create invoices against the relevant ones who have anything outstanding which contains VAT. if you apply the relevant VAT code to these transactions, and you are on a cash basis of VAT, mark them as paid when the customer pays the outstanding balance and they will then populate your return.

3. For your Suppliers, create Bills against the ones who have anything outstanding which contains VAT. if you apply the relevant VAT code to these transactions, and you are on a cash basis of VAT, mark them as paid when you pay the supplier the outstanding balance and they will then populate your return. 

I hope the above helps. Again though, if you have any further questions please don't hesitate to post back.

Thanks!

 

Chris.

View solution in original post

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi Carol,

 

Not a problem at all, most happy to help.

The method described would be best used if the balance on the Vat liability account was left as '0.00' upon the beginning of the new file. This way, the liability account will populate upon the creation of the outstanding invoices/ bills (with the relevant VAT code applied) to represent the outstanding potential Output and Input VAT.

 

You are correct, these would need to be created individually if there are some invoice lines with VAT considerations, and some lines without.

In terms of date, there should be no problem with creating the invoices and bills used to represent the outstanding balances on the original invoice or Bill date, as they will only be applicable to your VAT 100/ return when you mark the outstanding balance as paid.

Thanks,

Chris.

View solution in original post

13 REPLIES 13
ClayJ
QuickBooks Team

Item List 14500 limit reached

Hello, @CarolB

 

Thanks again for stopping by the QuickBooks Community. I'm going to get you over to the UK Community team. 

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi Carol B,

Thanks for posting on the community again!

I'm afraid that having reached the list limit of 14,500 in QuickBooks desktop your options are limited. The 2 options which have been mentioned to you so far are possibilities, namely...

 

1) Exporting your company data to QuickBooks online, where there is theoretically no list limit

2) Starting a brand new QuickBooks company file in QuickBooks desktop, with opening balance and creating only customers/suppliers/ items you need at this time


Of course I know you would much rather keep your current company file, and there is a method by which this may be achieved, albeit a pretty manual one.

Your Names, such as Customers/Suppliers/ employees, and items such as Stock items/non stock items cannot be deleted from QuickBooks if there are any transactions relating to them (Which in most cases there are) without deleting these transactions themselves.

But instead, what you can do is find old names/ Items which are no longer used, and change two of them at a time to have the same name E.G changing two not used stock items in the item list to 'unused'. Once you do this on two old records QuickBooks desktop will ask you if you want to merge the two. If you select yes and merge them, you are effectively turning 14,500 items/names to 14,499 items freeing up another one to be created.

I do appreciate the method suggested is manual, and will take time, but it would allow you to keep running your current company file.

If you have any questions on the above, please don't hesitate to post back.

Thanks.

Chris.
 

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi CarolB,

Just to clarify further, When merging list items or names, you do not have to use a different name every singe time.

For example, if you were culling a lot of customers from a while back who you no longer have a need to hold in your books, you could go to the customer list and then change one of the customer names to 'Merged' and save it, then change any other old customer name to also be 'Merged' and you will be asked to merge this customer into the name 'Merged' each time.


You can do the same for old and unused accounts, and stock/non stock items/ services which you no longer require.

Thanks,

Chris.

CarolB
Level 3

Item List 14500 limit reached

Hi Chris

I have decided to set up a new company which scares me slightly.

If I import the item list to the new company will I be able to delete those I do not want as surely then they will not have any transactions against the?

Also struggling with how to account for VAT. We are on cash accounting basis and I filed a VAT return at the end of July Month End which is now showing in Accounts Payable so I am fine with that bit. However how do I enter opening balances for customers and suppliers and account for the VAT element so the VAT 100 report is correct when invoices are paid. Also on my balance sheet I have a balance in VAT Liability which I assume is those invoices VAT element that has not been paid yet. 

When I set up the new company at what point do I import my lists? Will it ask me if I want to import at some point in the set up process.

 

Sorry for all the questions but pulling my hair out here Thanks x

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi CarolB,

No need to apologise for asking questions on the community, that's what we're here for! :)

I understand it does sound like a daunting task starting with a brand new file, but don't worry! We will assist you with everything we possibly can to help get you up and running, and moving forward.

Firstly, you are indeed correct. If you were to export your list items from your current desktop file, and then import them into the new desktop file you will be able to delete the list items as you please as there will be no transactions attached. You can also do this for other list items/names such as 'Customers'/ Suppliers.

A Quick way to do this would be the following.

1. In your current desktop company file click 'File,' 'Utilities' 'Export' then 'Lists to IIF files'

image.png

2. In the next pane, select what you would like to export E.G, Customers, suppliers, and items.

image.png

3. Then on the next pane, give your IIF file a name, and save it somewhere locally on your computer like the desktop.

4. Once you have saved this file, open up your new QuickBooks desktop company file, and click 'File' 'utilities' 'Import' 'IIF files'

image.png

5. Choose the IIF file you have saved, and QuickBooks will import your data. As you say, this will make your clean up of items and names far more efficient, as you will be able to delete at will without having to merge.

Entering opening VAT balances

 

Firstly you are correct, the outstanding VAT liability account balance in your file will be from any potential VAT owed/ reclaimable vat against any open customer or supplier balances.

There is no easy automatic way to do this in QuickBooks Desktop when moving file, but I would advise the below method to be the most thorough.


1. Run supplier and customer balance summary reports in your old QuickBooks file to check the open balances of each.

2. For your customers, create invoices against the relevant ones who have anything outstanding which contains VAT. if you apply the relevant VAT code to these transactions, and you are on a cash basis of VAT, mark them as paid when the customer pays the outstanding balance and they will then populate your return.

3. For your Suppliers, create Bills against the ones who have anything outstanding which contains VAT. if you apply the relevant VAT code to these transactions, and you are on a cash basis of VAT, mark them as paid when you pay the supplier the outstanding balance and they will then populate your return. 

I hope the above helps. Again though, if you have any further questions please don't hesitate to post back.

Thanks!

 

Chris.

CarolB
Level 3

Item List 14500 limit reached

Hi Chris

 

That is most helpful.

 

So when you say I need to create invoices for customers/suppliers...the ones that make up the balances do you mean I need to raise an invoice/bill as I would normally but date these as before my opening date. What will this do to my balances in the VAT liability account because some of those invoices will already be included in that balance. I take it also I have to do each one individually and not as a whole balance as they all contain VAT

 

Thank you

 

Carol

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi Carol,

 

Not a problem at all, most happy to help.

The method described would be best used if the balance on the Vat liability account was left as '0.00' upon the beginning of the new file. This way, the liability account will populate upon the creation of the outstanding invoices/ bills (with the relevant VAT code applied) to represent the outstanding potential Output and Input VAT.

 

You are correct, these would need to be created individually if there are some invoice lines with VAT considerations, and some lines without.

In terms of date, there should be no problem with creating the invoices and bills used to represent the outstanding balances on the original invoice or Bill date, as they will only be applicable to your VAT 100/ return when you mark the outstanding balance as paid.

Thanks,

Chris.

CarolB
Level 3

Item List 14500 limit reached

Thank you for all your help. I have set up the new company...working late into the night but all sorted. Thank you so much for talking me through it

Chris_H
QuickBooks Team

Item List 14500 limit reached

Hi Carol,

No problem at all. Glad to hear your all sorted out and ready to go with your new company file.

If there is anything else we can help with, please don't hesitate to post back to the community.

Thanks,
 

Chris.

Jess W
Intuit

Item List 14500 limit reached

Hi, @CarolB

 

Welcome to the QB Community!

 

Amazing news that you set up a new company :) The Community is here to support you! In QB Community, you’ll never feel intimidated asking a question, sharing about a struggle or celebrating a win. Our members love sharing what they know, commiserating about a tough day and cheering madly when things go well.

 

I would love to know more about what you do? Smiley Very Happy

 


QB Community Home          Talk About Your Business 

         Find Inspiration     

GGM
Level 2

Item List 14500 limit reached

Another good reason for quickbooks enterprise to be made available in uk there is almost no limits with this.

These limits apply to to all chart of accounts items, cutomers, suppliers ,list etc in quickbooks desktop.

Also thought quickbooks recommends desk top if you have lots of items and not online.

Just a few thoughts

RAY15
Level 3

Item List 14500 limit reached

This is an awful situation to be in, we experienced it too. Its not an answer to start a new company because you can no longer look up customers and their history with you. Basic CRM!

 

Support for this is poor from intuit.

 

The only answer is to move to a different software completely.

GGM
Level 2

Item List 14500 limit reached

Hi yes I have this you need to delete items

You can of course only delete items that have not been used.

So make up an item once this is done you then select old items you have and merge them to this new one you can do this over and over.

then the new item can be deleted because it hasn't been used or just keep it there.

This may affect some historic data but if you make sure it is outside current year you should be OK.

Having said all this if you go to online I am told the number of items is unlimted we will see ,it would seem all desktop versions are finishing 30th June 23 so no options.

D

Need to get in touch?

Contact us