Home: Message List - Large Quickbooks File

Re: Large Quickbooks File

GitaFaust — Sun, 27 Sep 2009 20:39:58 GMT

You have couple options:

1. Archive the QuickBooks file
2. Create a portable file and reopen the file - this may reduce the size
3. Delete old transactions
4. Transfer the current year data into a new data file OR
5. Upgrade to Enterprise version +10% off on the software

Before you proceed with any of the above options, always make a backup.

Re: Large Quickbooks File

BCRSoftware — Wed, 23 Sep 2009 14:39:29 GMT

Many QuickBooks users have experienced the same issue and except for archiving data there is not a solution. Even if you repair the file, the problem will return.

BCR has helped many small distribution businesses move to software that grows with you for no more money than "low end packages" cost when you consider the year after year upgrade cost, their low level of support you receive for your dollar, their lack of functionality, and their user limits for scalability.

BCR Software is in use by distribution companies throughout the US and Canada. Our support personnel are second to none.

Now for the great news! BCR Software has introduced Genesis that allows "low end package" users with a cost effective and easy upgrade path. Most low end package data can be transferred directly into Genesis.

BCR Software is a solid ERP and Distribution Software solution that offers fully integrated Wireless Warehouse Management, E-Commerce, Order Entry / POS, Inventory management (with min/max, extended EOQ and service level functions), manufacturing assemblies, extensive product pricing functionality, job tracking, payroll, time clock / job clock systems, and much more. www.BCRSoftware.com
Steve@bcrsoftware.com
(800) 231-4340

Re: Large Quickbooks File

quickbooksgal — Wed, 05 Aug 2009 01:54:00 GMT

Hi Doug,
Perhaps you have been misguided by tech support and there might be other issues. I have seen files well over 1 and 2GB with no issues. I have also worked with clients that have been told the same thing and it ended up being other things that were happening such as network issues, backup issues, file corruptions, etc. There are many components that can affect file intengrity. Starting a new file is not alway the best an unless you actally start a new file and transfer the opening balances over, you will only be increasing your audit trail. I own and have used the tools for moving data and creating new files but before you go that route, consider the possability that it may not be needed. If you want to discuss this further, check out our site at www.qualityconsultingandbilling.com.

I hope this helps,
Denise

Re: Large Quickbooks File

sechelt — Thu, 14 May 2009 04:47:15 GMT

We have the same issue, I came across a site that looks very good, am going to try it out, the software is $150 and looks like it does what I (and you) need - I have not used it yet so I can't say if it is any good.

http://www.q2q.us/How%20to%20start%20a%20new%20QuickBooks%20file.htm

Did you find a soultion?

Cheers

Re: Large Quickbooks File

QB_Doctor — Mon, 26 Jan 2009 15:51:33 GMT

Good luck and I'd love to hear if it works out for you.

Re: Large Quickbooks File

wb1234 — Mon, 26 Jan 2009 14:05:59 GMT

Because there was a transaction associated with the item, customer, or

vendor. You can't delete it [using qb automated processes].

Thanks for the confirmation. I just wanted to make sure I wasn't missing something obvious. I wonder why they have their "Clean up company data" if it doesn't really work?

I'll look into the paid service I found online and see how that works.

It isn't reasonable to force customers to hold data forever, nor is it reasonable to force them to start over, and not have the benefit of my last five years data entry for sales comparison reports. I'm sure Intuit will fix this someday.

Re: Large Quickbooks File

QB_Doctor — Sat, 24 Jan 2009 15:23:11 GMT

.....What I need is a process that posts "beginning balance" entries as of 1/1/05, and then deletes everything prior.

Even when you clean the data or archive in older versions. It does not get rid of everything. Because there was a transaction associated with the item, customer, or vendor. You can't delete it. The only thing you can do is start a new QB file and transfer over the begining balances. Sorry. Hope this helps.

Re: Large Quickbooks File

roblew — Thu, 22 Jan 2009 21:13:45 GMT

You May want to hire an accountant with kowledge about large Quickbooks File.

Re: Large Quickbooks File

wb1234 — Sat, 17 Jan 2009 20:47:28 GMT

Did you try to archive the data with all items checked.

I don't see an archive option. I did the "File>Utilties>Clean Company Data" but it didn't clean anything as far as I can see.

However if you are looking to clean up

...click on the sub menu item call
inactivate.

They've been inactive for 5 years. But the data is still there. If I hit Ctrl-Q and then All I can see all that old garbage, thousands of entries, just sitting there in my 2009 file.

What I need is a process that posts "beginning balance" entries as of 1/1/05, and then deletes everything prior.

Any chance of that, or might Intuit have added such a feature in newer versions? I found a service online that says they may be able to do it for "starting at $500". Also about 20 answers on Intuit forums that says at least through April 2008 the function doesn't exist...

Re: Large Quickbooks File

QB_Doctor — Sat, 17 Jan 2009 20:34:43 GMT

Did you try to archive the data with all items checked. It won't get rid of chart of account names. However if you are looking to clean up your chart of accounts, customers list, vendor and employee list....then you need to go to the appropriate list. Right mouse click on the name, then with the left mouse click on the sub menu item call inactivate. Although you can't delete items completely you can get them off your main active list so that you don't see them anymore or are not reminded of them ... Let me know if this helps.