Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 30, 2018
Solved

Create a project budget

  • October 30, 2018
  • 1 reply
  • 18 views

I am using Desktop Pro 2017 and I am trying to create a budget for an upcoming project.  I would like to be able to enter a total cost for each line item for the length of the project.  But, when I go in to create a budget, it only lets me enter monthly amounts.  Is there a way to change the format that I'm not seeing? 

Best answer by qbteachmt

Use an Estimate. The Project would be on the Customer Center list, and the Estimate spans the lifecycle of the job, and allows you to use items that include P&L and Balance Sheet accounts.

Budgets are limited to Fiscal Years.

1 reply

qbteachmt
qbteachmtAnswer
Level 11
October 30, 2018

Use an Estimate. The Project would be on the Customer Center list, and the Estimate spans the lifecycle of the job, and allows you to use items that include P&L and Balance Sheet accounts.

Budgets are limited to Fiscal Years.

March 2, 2019

Thanks for your reply.

 

Do i need also to make inputs for a project using Estimate for Balance Sheet accounts too?

 

Kindly explain please.

 

Best regards 

Mahmoud 

April 11, 2019

Hello @Mahmoud11 , 

 

I'm going to try to explain how I did this to make it show up on Actual vs Estimates and also the Balance Sheet.  Once you have it set up, it's easy to track and create reports.  

 

First, you need to create your Balance Sheet accounts.  For example, I have a construction project in process right now, so I have my "fixed asset" accounts set for Hard Costs with subaccounts (Phase I, II and III, Sitework, etc.) Soft Costs, with subaccounts (marketing, appraisals, architect, engineers, inspections, etc).  You may have these already set up for your business.  

 

Second, you need to set up Items.  When you set those up, be sure to choose "service" as the type and to check the box that says "This service is used in assemblies or is performed by a subcontractor or partner."  That will drop down a couple more options.  On the left side, choose the fixed asset account that you need that item to post to and on the right side, choose the income account that you would use once the sale goes through for your project.  If you do not have one, you can create a general income account such as construction services.  Create all your items and subitems that you want to track. 

 

Now, you are ready to create your estimate. Create your customer and create a "job" for that customer.   Then create an estimate for that job.  Choose from your item list and then enter the estimated (or budgeted) amount.  

 

When you receive an invoice or AIA, you will use the "item" tab instead of the "expenses" tab in the enter bill screen.   When you enter the charge, click on the "items" tab, choose the item from your list, enter any additional description, the cost and then under "customer:job" choose the job that it applies to.  

 

When you want to view a report for your project, go to Reports, Jobs Time Mileage, Job Estimates vs Actual Detail.  Choose the Job and then you can view the report and see how you are doing based on your original budget.  By using items and linking them to your balance sheet accounts, they will also show on your balance sheet report. 

 

I hope that helps!!  


Hoping you can help!! 

 

We have many (1,000) generic non-inventory items already set up in our QB file that are linked to our P&L accounts.  If I want to get more sophisticated in my project cost reporting and link expenses to a job's "phase" (which I set up as service items), do I need to create a new (duplicate) item that reports up to the new project "phase"?  I guess what I'm trying to figure out is if I need to blow away all of my item history because now I want to be more detailed in my project costing.