Skip to main content
D
dclfcc
November 16, 2023
Question

Is the a way for Budget vs Actual report to run on a monthly date range and see the comparison to annual budget? Right now the report breaks the budget down monthly.

  • November 16, 2023
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

R
rvrfrf
November 16, 2023

Thanks for becoming part of the Community, dclfcc.

 

When creating budgets, you can choose their intervals you want them to display in as Monthly, Quarterly, or Yearly. If you'd like things broken down in a different way, you can create a new budget to display quarterly or yearly.

 

Here's how:
 

  1. Use the Gear icon, then go to Budgeting.
  2. Find your budget on the list.
  3. In the Options column, click View/Edit.
  4. Edit each account one month at a time.
  5. Specify your preferred time period, Monthly, Quarterly, or Yearly.
  6. Select Save or Save and close.

 

I've also included a detailed resource about working with budgets which may come in handy moving forward: Create & manage budgets

 

Please feel welcome to send a reply if there's any additional questions. Have a wonderful Thursday!

D
dclfccAuthor
November 19, 2023

Thanks, the budget is put in as yearly but if I run a report for only one month it does not show the annular budget amount it shows monthly. I would like the report to show the month(s) I am running and the percentage of the annual budget at that point in time. The desktop version was able to display the report that way.

For example if my annual budget for a line item is $1,200 and the beginning if the fiscal year is July and the actual is $300 it shows the budget as $100 because QB has divided the budget amount by 12.

I woukd like to see Juky actual as $300 with the budget $1,200 and the percentage based on the $1,200 (not $100).

JoesemM
JoesemM
November 19, 2023

Thank you for sharing additional details about your concern, @dclfcc. Allow me to assist you in sending feedback so that it may be considered for future enhancements.

 

I understand the significance of having the ability to generate a budget report according to your preferences. Rest assured that our engineers are working nonstop to enhance the product and deliver the best experiences for all QuickBooks users.

 

While it's not possible to see the actual for July as $300 with a budget of $1,200 and a percentage based on $1,200 (not $100), I recommend submitting a feature request directly to our product developers. This way, they can evaluate the possibility of incorporating this in future updates.

 

Here's how:

 

  1. Click the Gear icon⚙, then Feedback.
  2. Enter your comments or product suggestions. 
  3. Then select Next to submit feedback.

 

Once done, your valuable suggestion goes to our Product Development team to help improve your QBO experience. You can track feature requests through the QuickBooks Online Feature Requests website.

 

Additionally, I will be sharing these links to guide you in running custom reports and creating budgets using spreadsheets:

 

 

Please let me know if there's anything I can help you with regarding running budget reports and managing your financial data in QBO. You can drop your reply below, and I'll get back to assist you. Stay safe.

Terms & ConditionsAccessibility statement