Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
We just migrated from QB destop to QBO and our memorized reports did not migrate over so I'm trying to rebuild them.
I am trying to rebuild a Budget v Actual report that includes the following columns - Current Month Acutal, Current Month Budget, YTD Actual, YTD Budget, Total Annual Budget.
I've run the Budget v Actual report but it will not allow me to add all the columns I want.
Hello, @Starbuck1123.
You can customize a report to pull up the Current Month report and YTD actual and YTD budget. Let me help you with that
Moreover, export the YTD report and combine them in Excel to add columns on it.
I'll be adding some related articles to help you get your way around the Reports feature in QBO:
If you have further questions about any reports in QBO, you can comment below, and we'll respond to you as soon as possible.
Just to be clear - using this method, I have to manipulate the columns and rebuild the report in Excel? There is nothing to create a report with the data straight from QB? I had a saved report in QB dekstop with all of the columns I need. Is this not possible in QBO?
As my colleague mentioned, @Starbuck1123. We can customize your report in Excel and export the year-to-date report to add to the columns.
However, adding the customization report you've shared with us will enhance our report list. I recommend submitting Feedback to our Product Engineers.
Here's how to submit:
Additionally, I would like to share an article that provides more information on customizing reports: Common custom reports in QuickBooks Online.
I'll be here if you still have questions about your reports. Take care, and have a great day!
Can this be done in QBO Advanced?
I'd like to officially welcome you here in the forum, kimaslone. I'll answer your question about running and customizing reports in QuickBooks Online.
The Budget vs Actual report comes with default columns, which are:
At this time, there's no option to add any other columns aside from the default ones.
As a workaround, you can export the Budget vs Actual report to Excel. Then, customize it so you can add the columns that you need.
Here's what you need to do:
If you need more options to customize financial reports, you can send a feature request to our product engineers. Customer feedback is important in shaping the future development of QuickBooks Online (QBO).
Here's how to send your request or product suggestions in QBO:
Just in case you need additional resources when analyzing reports, I'll share these articles as well:
You can always drop by the Community anytime you need further help when running reports, gathering data, and maintaining bookkeeping records in QBO. The QuickBooks Team is standing by, ready to help you address any questions or concerns that you might have.
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