How can i convert an annual budget to a monthly budget?

Hi @qbo14,

Welcome to the Community. I appreciate the number of details you've included in your post.

What you can do in this situation is to create a new budget in QuickBooks Online (QBO). Once you save a budget in QBO, you can get back and edit the amounts, but the Interval is set, and can no longer be changed. 

Open this article for additional information about budgeting in QBO: Create and import budgets into QuickBooks Online. It includes the steps on how you can copy existing budgets, as well as how to delete them. 

Get back to me in the comments below if you have other questions about budgets in QBO. I'll be around to help you out. 

Ryan

Thanks for your reply.

I cannot find in the link you supplied below a way to IMPORT a budget from EXCEL to QBO. I see that I can create a budget report and EXPORT to excel. I assume I can then edit that budget, and then I'd like to IMPORT the edited budget to EXCEL. 

Doug

Hi there, qbo14.

I'm here to share additional information about how budgets work in QuickBooks.

Please know that the option to import a budget is only available in the Advanced version of QuickBooks Online. To be guided in performing the process, you can open the article provided by my colleague, Ryan_M. Then, click the In QuickBooks Advance link.

On the other hand, if you're using QuickBooks Online Plus, you'll have to manually create a new monthly budget. This way. you'll be able to track how well your company is performing and compare your actual revenues and expenses to your company's budgeted amounts. I'll show you how:

1. Click the Gear icon.
2. Under Tools, select Budgeting.
3. Click the Add budget button.
4. Choose the appropriate fiscal year, then set the interval to Monthly.
5. From the Subdivide by drop-down menu, select Class and then enter the appropriate class.
6. Enter the amounts for each account. You may also choose to pre-fill the data.
7. When you're done, click the Create Budget button.

I'm also adding this article to help set more manageable budget targets for each segment of your business: Set budget targets for each class.

Drop me a comment below if you have any other concerns or follow-up questions. I'll always have your back.