cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Using QBO- would like report for actual vs budget with open po's.

 
1 Comment
Highlighted
Moderator

Using QBO- would like report for actual vs budget with open po's.

Thanks for posting here in the Community, QBOAirportUser.

 

I can help you run a Budget vs. Actuals report.

 

The Budget vs. Actuals report will give you a comparison of your budgeted income and expenses to the actual amounts, so you can tell whether you're over or under budget.


Right now, we are unable to include the open purchase orders in it. Instead, you can run the Budget vs. Actuals report and Open Purchase Order List and export them to Excel.

 

Let me show you how:

 

To run the Budget vs. Actuals report:

  1. Click Reports on the left pane.
  2. Enter and select Budget vs. Actuals in the search box.
  3. Set the date range in the Report period.
  4. Click Run report.

To run the Open Purchase Order List:

  1. Choose Reports on the left pane.
  2. Enter and select Open Purchase Order List in the search box.
  3. Set the date range in the Report period.

To export the report:

  1. Open the report.
  2. Click the Export icon.
  3. Select Export to Excel (see the screenshot below).

image.png

Once you've exported the reports to Excel, you can merge them so the open purchase orders will be added to the Budget vs. Actuals report.

 

You can also save this report for future use. Just click the Save customization button at the top. Enter a Custom report name, and click Save.

 

I also think that having an option to add the open purchase orders in the Budget vs. Actuals report can help you run your business better. I've sent your idea to our Product Developers so they might consider adding this feature in the future. I'd also like to invite you to share your thoughts on how we can improve the reports in QuickBooks Online. Most of our new features come from our customers' suggestions.

 

Click the Gear icon at the top and select Feedback to send one.

 

Thanks for your input. Should you have more questions, feel free to let me know. I’ll be here if you need me. Have a great week.

 

 

 

 

 

 

Need to get in touch?

Contact us