cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Explorer **

How do I create a budget by job, and run periodic budget v actual reports?

My boss wants to set up a budget or several budgets by job and these jobs go into multiple years how do I do this?  I can't seem to find any information on how to set up a budget by job and then for jobs that go into the following year or years

 

10 Comments
QuickBooks Team

Re: How do I create a budget by job, and run periodic budget v actual reports?

Thanks for checking in with us, missymarykay55.

Helping you create a budget by the job is my priority. Let's get started.

 

QuickBooks Desktop has an easy-to-navigate budgeting feature. Budgets help you plan so you can stay on top of your expenses and revenue.

 

After you set one up, use the Budget vs Actual report to help make informed decisions for your business. However, there isn't a way to set up a budget to go for years. You can make a budget at any time, but year-end is a great chance to start planning for the year ahead.

 

To set up a budget for a job, here's how:

 

  1. Click Company at the top menu bar.
  2. Choose Planning & Budgeting and select Set Up Budgets.
  3. Specify the budget year, then choose between Profit and Loss and Balance Sheet.
  4. Choose Customer: Job.
  5. Hit Next.
  6. (For the Profit and Loss Budget) Select whether you want to:
    • Create a budget from scratch: Manually enter amounts for each account that you want to track.
    • Create budget from the previous year's actual data: Let QuickBooks Desktop automatically enter the monthly totals from last year for each account in the budget.
  7. Select Finish.

z.PNG x.PNG c.PNG

 

To get more details regarding budgets in QuickBooks Desktop, you can visit this article: Create a budget or forecast in QuickBooks Desktop.

 

Don't hesitate to drop a reply below if you have any other budget concerns. I'm more than willing to lend a hand.

Frequent Explorer **

Re: How do I create a budget by job, and run periodic budget v actual reports?

I have done that but once I put the job in and put the figures in if the job starts in June 2018 do I put my figures in under June?  Also the job will end July 2019 so to pull in all those figures do I customize the report by changing the dates to pull in all of 2019?  Another thing how do you get to see one month on the report instead of all of the months?   Sorry for so many questions but never done this before and I need to get this right.  Thank you

QuickBooks Team

Re: How do I create a budget by job, and run periodic budget v actual reports?

We're always here to answer them, missymarykay55. 


Yes, enter the budget under June and when you pull up the Budget vs. Actual report, from there you can customize it by month. 

 

Here's how: 

  1. From the Reports menu, select Budgets & Forecasts
  2. Then, choose Budget vs. Actual
  3. Select the budget and click Next
  4. Choose Account by Month and then click Next again. 
  5. Then, Finish
  6. To customize it to a specific month, you can enter the date range.

Here's an article you'll want to check out for more details on how to customize reports

 

I'll be a post away if you need more help with running your budget reports. Have a great day!

Frequent Explorer **

Re: How do I create a budget by job, and run periodic budget v actual reports?

I have my budget in but still have some issues.  When I go to reports budget versus actual it asks to select budget  and my budget is named FY2018 - Profit & Loss by Account and Customer job then I hit next and it asks for you to choose a report layout account by month, account by customer job or customer job by month.  When I select account by customer job it gives all the jobs I only want the one job I budgeted how do I get just that one job for a report?

Frequent Explorer **

Re: How do I create a budget by job, and run periodic budget v actual reports?

When I do my budget report and put in the dates June 1 2018 to June 4, 2019 and do totals only under construction income it gives me the total income for all projects and I just want the income from the budgeted project how do I get that?

QuickBooks Team

Re: How do I create a budget by job, and run periodic budget v actual reports?

I appreciate the complete details about your concern, @missymarykay55.

 

Let’s filter your Budget vs Actual report to show only the income for a specific project.

 

Here’s how:

  1. Open the Budget vs Actual report.
  2. Select Profit & Loss by Account and Customer: Job report, then click Next.
  3. Choose Account by Customer: Job, then click Next.
  4. Click Finish.
  5. Go to the Customize Report button.
  6. Select the Filters tab.
  7. Search for Name in the Filter selection.
  8. Choose the name of the Customer or Project you want to include in the report.
  9. Click Ok.

For more detailed information, you may check out these articles:

Leave a comment below if you have other questions. I’m just a few posts away.

Frequent Explorer **

Re: How do I create a budget by job, and run periodic budget v actual reports?

Thank you JuVielL that helped me a lot.  I have another question for you if I want to go in and enter or change figures how do I do that in a budget that is already made up?  Once I memorize the budget report can I edit it?

Moderator

Re: How do I create a budget by job, and run periodic budget v actual reports?

It's good to see you in the Community again, missymarykay55,

 

Allow me to join the thread and provide additional information about your Budget concern.

 

You can edit the budget created, here's how:

  1. Go to Company menu at the top.
  2. Click Planning and Budgeting.
  3. Select Set up Budgets.
  4. Choose the budget created in Budget drop-down menu.
  5. Edit the changes you want.
  6. Click OK.

As for your other concern, you can edit an existing memorized report, here's how:

  1. Open the memorized report.
  2. Make the appropriate changes.
  3. Choose Memorize.
  4. When you get a prompt, you can either:
    • Select Replace if you want QuickBooks to overwrite the existing memorized report.
    • Select New if you want to keep the existing report and create another one.

For more detailed information, you can check this article: Create, access and modify memorized reports.

 

That will point you in the right direction!

 

If you have any additional questions in managing your account, you can leave a comment below. Take care.

Frequent Explorer **

Re: How do I create a budget by job, and run periodic budget v actual reports?

I opened up the memorized report and it won't let me make any changes I wanted to add a figure to an account and it won't let me type anything in.  I went to reports,memorized report list, chose my report and it opened up.  I can't do anything in the report in the way of changes, I go down to the account I want to enter the amount in and it won't let me.  Please tell me what I am doing wrong as I followed your directions as you stated.

QuickBooks Team

Re: How do I create a budget by job, and run periodic budget v actual reports?

Hey there, missymarykay55.

 

Thanks for coming back to the Community and adding more details about your concern.

 

In QuickBooks Desktop, the option to change the information for your memorized Budget Report is currently not available. You’ll have to open the report itself and update the details from there.

 

To modify:

 

  1. On the Company tab, scroll to the middle and select Planning & Budgeting.
  2. Choose the Set Up Budgets option.
  3. From the Budget drop-down, click the one you’re trying to edit.
  4. When QuickBooks displays the data, input the amount.
  5. Click on Save and OK.

I'm also adding screenshots for visual reference:

bud.png bud1.png


After modifying the report, you can memorize it again. I suggest following the steps provided by @MirriamM.


This should get you on the right track.

 

Let me know on the outcome after trying these steps. I'll be happy to assist further.