Fresh Start for old Quickbooks file?

I have a Quickbooks Pro file that I've been using since 2005, when I started my company. I'm currently using QB Pro 2010. The file is basically current, but it's getting big, and is full of all sorts of junk from things I've tried to do, over the years, that just didn't quite work the way I intended. Things like, the Sales Tax is carrying over stuff that was paid already, because it wasn't entered properly; There are things still stuck in my PO queue, because I never used them; there are accounts that no longer exist, that still have money listed in them. Things like that.

What I'd like to do is start fresh for 2012, with a new file, and all the accounts essentially zeroed out. But I would like to carry over things like my customers, vendors, chart of accounts, etc.

Complicating the equation is that I have the Quickbooks Enhanced Payroll and Quickbooks Merchant Processing services associated with the old file.

So now I'm not sure what to do. I don't want to continue adding data to the old file, because if I do change over, it's going to cause problems. But I don't know what else to do. Any thoughts?
David SpigelmanPresident / CEOAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony GiangrecoCommented:
You can export lists to iif files from QB 2005, then import them right into 2010. I use 2010 and it works very well. I haven't used 2005 for a while.

In 2005, Go to File, Utilities, Export, IIF Files, then select the tables you want to export into a new folder.
In 2010, go to File, Utilities, Import, IIF Files and bouwse to the folder used above.
David SpigelmanPresident / CEOAuthor Commented:
It seems I was unclear. I have QB Pro 2010, and have been using it for years. My QB data file has been around since 2005, but it's currently functioning fine within 2010.

The problem is that I don't know how to set it up and still be sure that the Payroll subscription and Merchant Processing accounts get associated with the new account.
Tony GiangrecoCommented:
It's virtually impossible to determine if those portions of your accounting system is setup properly without logging into your QB company file and reviewing the data. I suggest having a CPA review it for a professional opinion.
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

David SpigelmanPresident / CEOAuthor Commented:
Again, I understand that, and am not looking for a fix. I'm looking to jump ship; to start a new file with the same chart of accounts, and the same customer, vendor & item lists. I am prepared to reset any open balances, as necessary. I just need it to be empty.

But again, there are what I understand to be complications in that I have the Payroll and Merchant Processing services associated with the existing data file. If they aren't really problematic, that would be great to know.

For some reason I had thought there was a way to just do a copy of the existing file, with no data. I could've sworn I tried to do that in advance of all this, and that I got a message saying something about how it would transfer my Payroll, etc. to a new file (which was why I couldn't do it at the time). But I can't seem to even find such an option anymore.
David SpigelmanPresident / CEOAuthor Commented:
The answer that I found, after speaking with a Quickbooks Pro Advisor, was not to do what I was considering, at all. Instead, he recommended that I mark the accounts, etc. that are no longer being used as Inactive, and then Archive all the data back to 12/31/2010. Doing this enabled me to remove all sorts of old things that were choking my QB file, without having to go through the hassle of redefining the entire file. So I got the results I was looking for.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David SpigelmanPresident / CEOAuthor Commented:
I found the solution. The responses I got weren't really helpful.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.