I want to consolidate multiple separate QB companies. Clearly this isn't possible with QB functionality.
My work around was to download QB trial balances into 1 spread sheet and then to pivot these, but the QB TB can only be cumulative, which is fine for the cumulative consolidation, but not for the monthly one, so how do I get this monthly data?
Do I need to download a cumulative TB for each month and then deduct one from the other to get a single month, or is there another way to extract monthly data?
