Skip to main content
F
FirebridgeJC
October 23, 2024
Question

Unbilled Costs included in calculation of actual costs

  • October 23, 2024
  • 1 reply
  • 0 views

I am trying to run a report showing where we are financially on specific jobs. I've run the Job Estimates Vs Actuals Detail which is basically all we're looking to see, however, I want it to include the committed costs. I ran the Unbilled Costs by Job report as well, but noticed that some of those unbilled costs are actually already accounted for in the Actuals report.

Why would some of the unbilled be captured in that report, but others not? I need something to show the overview of the job, but very simply. Any ideas?

1 reply

JoesemM
JoesemM
October 23, 2024

You can run two reports to get the information you need, FirebridgeJC. I'd be happy to share some insights about it as we work through this together.

 

Since you want to include the committed cost, you can run two reports the Job Estimates Vs Actuals Detail and Committed Cost by Job report. The Committed Costs by Job, shows the amount spent on each project, estimated costs to completion, and budget variance. Then, export the report to an Excel file and add the necessary details manually to streamline your reports.

 

Here's how:

 

  1. Go to Reports, then Reports Center.
  2. Look for and double-click the report you want to export.
  3. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
  4. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
  5. When you’re ready to export, select OK.

 

For detailed steps, click this link: Export reports as Excel workbooks in QuickBooks Desktop. It also contains excel-based payroll reports.

 

Also, Unbilled Costs by Job are costs associated with a specific job that hasn't been invoiced. Though, there's a bill payment check applied it still shows as Unbilled since you haven't applied it to your invoice. 

 

Then, let's ensure that the date range is filtered correctly so the unbilled transactions will show. It's also possible that it's already applied to an invoice that's why it doesn't captured when running the report.

 

Additionally, I'll be sharing these resources that will guide you in recording your job costs accurately and personalizing the report that you need to run in QBDT:

 

 

Get back to me if you still have questions or concerns with reports. I'll be around to assist you. Take care and have a good one.

F
FirebridgeJCAuthor
October 24, 2024

Thank you, though I can't find a report called Committed Costs by Job. Can you tell me where I'd see that?

M
Maybelle_S
October 24, 2024

Let me share details about the Committed Costs by Job report in QuickBooks Desktop (QBDT), Firebridge.

 

The Committed Costs by Job report is exclusive to QuickBooks Enterprise. This version is designed for businesses with more complex job costing needs and provides advanced reporting capabilities.

 

Furthermore, the report permits users to monitor expenditures associated with job duties, presenting significant benefits for the construction and project management sectors.

 

If you’re using a different version of QuickBooks, this specific report will not be accessible. However, QuickBooks Desktop Pro and Premier offer other reporting options that help you manage job costs effectively.

 

Here are a few alternative reports you can use instead of the Committed Costs by Job report:

 

  • Job Profitability Detail: It provides detailed insights into the costs and revenues for each job, helping to assess overall profitability.
  • Job Costs by Job Summary: It summarizes costs for each job, giving users a quick overview of total expenses.
  • Transaction Detail by Account: you can customize it by job to display all related transactions, including expenses and income.
  • Estimate vs. Actuals: This report compares estimated costs to actual costs for each job, which can help in budgeting and forecasting.

 

Additionally, you can customize the date range and other filters to suit your needs. It will show you the committed costs for each job, allowing you to analyze expenses effectively.

 

I want to help you explore other reports in your current version. Please let me know if you have further questions about Committed Costs by Job report in QuickBooks. I want to ensure everything is taken care of.

Terms & ConditionsAccessibility statement