

How many years of data to you have in your company file?ĭo your computers all meet the system requirements? So lets say I condensed around November 2016 (FY end June 30), I think I kept the current year and the last two fiscal years just in case. We were about half way throgh our fiscal year. The only reason I condensed it was because I got tired of moving the large backups around and I was pretty certain we weren't going to need data from 3 years ago (still had a backup just in case I did). We are also running Pro, which isn't supposed to be over 150mb but somehow it just kept working well into the 200's. I might have forced it to reconsile without matching and just documented exactly why the rec was off. I can't remember exactly what I did to fix it. I can't remember exactly what it was, but when I did a reconsiliation it was off by the total amount of transactions from before the date that I set that never cleared. Some weird things occured with my monthly bank recs.

Make a backup beforehand and save it somewhere just in case you ever need to go back into it again. You will set a date and it will condense everything before that into summary journal entries. There is a CONDENSE DATA utility under FILE->UTILITIES. Ours got to about 2XXmb after about 5 years of data. We're running the latest updates, but I'm not in the office to check the version. We will be upgrading to 2017 sometime this year due to the (frankly stupid) rules regarding credit card processing in QB. My boss is breathing down my neck, but I'm out of ideas.įrom what I remember we use QB 2015 Premier Wholesale and Mfg. There's several hundred customers, over 10,000 invoices, Purchase orders, receiving, etc, and I'm assuming the problem would be lessened if we compacted the company file. We've been using the same company file since the business opened in 1999. I'm assuming the problem lies with the file size, and the fact the company's accountant has put the fear of god into the owners that if they ever compact / clean up the company file they'll have issues they won't be able to fix. We have two users logged in at the same time on different PCs. Our company file is currently around 325mb according to my quick check of my backup files. I've tried faster networking, a more powerful server, and putting SSD's in every PC, however I've gotten maybe a 5% reduction in load times, running reports locks quickbooks up until it's finished, and if we get a phone call and need to pull up company info, it takes forever to get it on the screen. I'm trying to figure out why Quickbooks is taking several minutes to load on our network.
