Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
PKECharity
Level 1

Can I create an excel extract with current year reference data compared to next year's budget? I want to be able to extract that for a side by side in excel. How can I?

Budget view shows current year data as reference data. I then make adjustments to next years budget. I can see it online. However, when I extract it to excel I lose the reference data for a side by side comparison.

1 Comment 1
AntoniettaE
QuickBooks Team

Can I create an excel extract with current year reference data compared to next year's budget? I want to be able to extract that for a side by side in excel. How can I?

You can export the current year reference data and next year's budget separately from QuickBooks Online (QBO) and merge them in Excel for side-by-side comparison, @PKECharity.

Unfortunately, QBO does not currently have a built-in capability to directly export a side-by-side comparison report for the budget and reference data into Excel. Even so, merging the two sets of data in Excel can help you achieve the comparison you need.

If you have any additional questions, please don't hesitate to reply. We're here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us