Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have two separate company files that we consolidate for month end reporting. I am needing to find a solution that will allow me to consolidate the two companies budgets (MTD and YTD) in excel. As of right now this being done manually and is time consuming.
I appreciate you joining the QuickBooks Community forum and sharing the details of your concerns. I see you're looking for a way to consolidate the budgets of two separate companies in Excel. I'll share information about this matter.
As of now, in QuickBooks Desktop, the current process of manually exporting data from different company files and consolidating reports in Excel is the primary method for consolidating reports from different company files. While QuickBooks Desktop provides the ability to export data to Excel and offers some customization options for reports, the process of consolidating budgets from multiple company files in Excel still requires manual effort.
I'm adding these articles you can use in the future:
If you have any further questions or need additional information, feel free to ask! I'll be around to answer them ASAP. Have a great day!
Consider to use a BI app.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here