Job Expense Report - Actual and Future (Committed)

Welcome to the Community, @skoz5555. I can see your question in a different post.

I'll route you to the thread where my colleague answered your question so you can continue discussing more should you have further concerns related to the topic. 

Please click this link: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/job-expense-report-actual-a.... 

Always know the Community is always around to help you some more. Stay safe. 

Thank you, but the Planning and Budgeting is for my company budget.  I need to input future costs for a job.

Any other suggestions?

Thank you, but the Planning and Budgeting is for my company.  I need to input and report on future costs for a job.

Any other suggestions?

Hello there, skoz5555. 

When entering a future or committed job expense we can either create an estimate or a budget as suggested by my colleagues. If we use estimates we have multiple reports that can show the actuals and future costs the job has. Here are a few: 

• Job estimates vs. actuals summary report
• Job estimates vs. actuals detail report
• Estimates by Job

Here's how to pull that up:

1. Go to the Reports menu.
2. Choose Jobs, Time & Mileage.
3. Then, select Job Estimates vs. Actuals Detail.

Here are a few articles that will help create estimates and customize reports:

• Tracking job costs in QuickBooks Desktop
• Create an estimate
• Customize reports in QuickBooks Desktop

I'll be here if you need more help. Take care!

Thank you for the response.  I must have misread your colleague's reply, for I just found the Setup Forecast menu for jobs.  The problem though is that it appears that I can only assign it to the chart of accounts and I need to assign it to items.  Here is an example of what I'm looking for:

Today's date is 4/23/20 and I need a report for 4/1/20 - 4/30/20.  The following occurred.

• On 4/21/20, I purchased 2x4's at Home Depot for 10.00
• I have a contract with subcontractor Joe's Concrete to pay him 30.00 on 4/26/20 and then 20.00 on 4/28/20

I'm looking for a report that shows the following information in some format (I've used Purchase Order's to track subcontractor contracts, but I'm fine with a different method)

Date                Source Name            Memo                                   Item                Amount          Type

4/21/20          Home Depot              2x4's                                     Framing        10.00                Credit Card

4/26/20          Joe's Concrete         Concrete first payment      Concrete       30.00                Purchase Order

4/28/20          Joe's Concrete         Concrete first payment      Concrete       20.00               Purchase Order

Thanks again in advance.

Thanks for the detailed information, skoz5555.

Based on the information you've provided, we can customize the Purchases by Item Detail report. Here's how to do it:

1. Click Reports at the top menu and select Purchases > Purchases by Item Detail.
2. Click the Customize Report button and go to the Display tab in the Modify Report window.
3. Change the Date range From and To.
4. Go to the COLUMNS section and add the following columns:
      • Pay Meth
      • Account
      • Account Type
   Note: You can remove other columns if necessary.
5. Click OK.

You can also use this link to know more about customizing the report.

Feel free to get back to us if you need other reports.

Thanks James, but it does not show Purchase Orders.  In fact, when I create a blank Custom Transaction Detail report and set Filters to

             TransactionType - Purchase Order

This report doesn't even show the Purchase Orders.  The only thing I find that will show PO's is the PO report under Purchases; however, this won't show other transaction types.

Thoughts?

Thanks for getting back, skoz5555.

Aside from those reports, you can also customize the Transaction List by Vendor report to show the purchase orders. Here's how:

1. Click Reports at the top menu and select Vendors & Payables > Transaction List by Vendor.
2. Click the Customize Report button and go to the Filters tab.
3. Search TransactionType and filter it to Purchase Order.
4. Click OK.

Make sure the date range is correct.

Let us know if you need a different report so we can review it for you. Have a great day!

Is there a way to have purchase orders be shown against the budget in QB Pro? Like in the Reports > Budgets > Budget vs Acutal, I like how that is set up, but I would like to have include my purchase orders so I know my running available budget remaining.

Any suggestions?

I appreciate you for joining the thread, @Austin FF.

I'm happy to share some information about the budget reports in QuickBooks Desktop (QBDT) Pro.

The Budget vs. Actual report lets you compare your company’s actual revenues and expenses to your company’s budgeted amounts. It gives you your variance, so you know whether you are over or under budget. In QBDT Pro, the Profit and Loss Budget vs. Actual displays all of your income and expense accounts on one page. That said, we won't be able to add the purchase order transactions on this report.

At this time, you can follow the steps provided by JamesDuanT above to open a report for your purchase orders.

This article gives you more details on how to manage reports in QBDT, you can read the details from here as additional references.

Once done, you can also check out the topics from our help articles in case you need related resources while working with QuickBooks.

You're always welcome to come by the Community if you have additional concerns. It's my pleasure to help. Keep safe!

So, basically, you cannot have POs as a committed cost, even though they are a committed cost.  We still have to wait for the Invoice to come in to receive to that PO for it to be committed.  Thanks for listening to us and making this change.  I've been asking for this change since 2013.  Here we are 8 years later and we still cannot commit the PO to the costing report.

Time to research another accounting system.

I dont think you are the only one. I think it is available on enterprise though. Frustrating