We have been running two separate company files for many years. They are reflecting two quite separate branches of the same company. Currently we use an Excel sheet to combine the two accounts for the purpose of tax, audit, etc.
We'd like to combine these two companies files now while still retaining some separation which would help with day to day financial management. I was thinking of something as simple as an additional hierarchy level in the charts of accounts for "Branch 1" and "Branch 2" with all the accounts below their branch and something similar for customers, etc.
I believe there is no automatic way to do this and also no third party tool available. But can I somehow export all data from QB Desktop into Excel or another editable format? I imagine I could then use VBA to go through all the entries and combine the companies, create the new hierarchy and import the resulting files back into QB.