merge 2 quick books databases

I have a Quick Book database that the accountant update last week but our business office processed a lot of checks while the accountants were working on the database. Is there a way to merge both database so we don't have to re-enter the data the business office or the accountants entered. Quick books 2014.
Thank you.
jodyreidIT ManagerAsked:
Who is Participating?

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

x
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.

Andrew LeniartIT Consultant & Freelance JournalistCommented:
The only way it's possible to merge two QuickBooks databases back together is if the copy you sent to your accountant was an Accountants Review copy  (.QBX - compressed copy) (.QBA - extracted copy)  If this is the scenario, then yes, changes can be imported.

If what you sent to your accountant was just a copy of your QuickBooks working file (.QBW) or a QuickBooks created backup (.QBB) then there is no way to merge the two together.  You can shorten the time you have to spend by entering a journal transaction to make everything balance as of a certain date, but I'd suggest you ask your accountant to help you with that.

More likely than not, all of the changes your accountant made to your file will be in the form of Journal entries at certain dates. These are relatively easy to reproduce and your accountant will be able to just give you the required entries to bring your QuickBooks working file up to date with a minimal amount of time needing to be spent.

Hope that helps.
JohnBusiness Consultant (Owner)Commented:
You would probably need a third party transaction tool to create a file of transactions from one database to import into the other. Look in the Intuit Marketplace.

http://www.q2q.us/ and http://www.qbconvert.com/ are two.

There is no native QB combine company capabilities to do this even up to QB V2018 which I am using.   (Combine Accountant changes is a different thing).

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
jodyreidIT ManagerAuthor Commented:
Thank you
jodyreidIT ManagerAuthor Commented:
Thank you
JohnBusiness Consultant (Owner)Commented:
You are very welcome and I was happy to help you with this.
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
Microsoft Office

From novice to tech pro — start learning today.