Skip to main content
Shirleyruth
April 26, 2024
Question

In creating a budget, when I enter the annual value in the first column it automatically spreads it out across the year. How do I prevent that?

  • April 26, 2024
  • 8 replies
  • 0 views
Original commenter did not share additional details

8 replies

LouiseG12
April 26, 2024

I'm here to help you achieve your goal of preventing the annual value from spreading across the year, Shirley.

 

To prevent from spreading the annual value across the year, make sure to enter the value for each month separately. When you enter the amount in the first column, it will automatically divide it by twelve. This means that you'll have to calculate the specific value for each month based on the total annual amount, rather than simply dividing it by twelve. 

 

Furthermore, in case you want to set budget targets for each class, check out this article for reference: Set budget targets for each class in QuickBooks Online.

 

You can always revisit this page if you have additional concerns or questions about budgeting in QBO. I'll get back to you as soon as possible. 

ShirleyruthAuthor
April 26, 2024

See, that's the thing. I don't want any amounts in the monthly columns. I've been creating budgets in QBO for 7 years and this has never been a problem. What has changed? It really messes with my budget report and causes a lot of manual work for me that I shouldn't have to do.

FateCandylaneT
April 26, 2024

I appreciate you getting back here on this thread, Shirleyruth. 

 

As QuickBooks aims to provide a seamless process when completing budget tasks, the annual value entered will automatically be divided for the entire twelve months. As a workaround, you can export the budgets to an Excel file and manually input specific values for the year, then import them to your account. To do this:

 

  1. Go to Settings and choose Budgeting.
  2. From the Budgets page, click on the Export/Print dropdown and select Export to Excel.
  3. Save the file to your local documents.
  4. Manually input the value required for each month.

 

Once everything looks good, you can import the modified Excel file from the Budgeting center. I've added a screenshot below for reference.

 

 

I'm also including this guide to help you track and review business finances in your account: Run reports in QuickBooks Online.

 

I'll keep an eye on this thread for any additional queries you may have when managing budgets in your file. Just reply to this post, and I'll make sure to get the help you need. Stay safe and have a good one.

Terms & ConditionsAccessibility statement