Purchase Orders by Job Reports

Hi there, @whyz2,

Thanks for your time joining the Community. I can add some information about your preferred report in QuickBooks Desktop.

At the moment, there isn't a report that shows all the information you need. You'll need to pull up 2 reports so you can compare the transactions and balances. Here's how:

1. Go to the Reports tab.
2. Choose Custom Reports.
3. Select Transaction Detail.
4. Click the Customize Report button.
5. In the Display tab, update the report date.
6. On the same page, click Paid from the Columns section.
7. Go to the Filters tab.
8. In the Filter section, click Posting Status then select Either from the options.
   
9. Click Transaction Type from the Filters, and choose Purchase Order from the Transaction Type drop-down.
   
10. Click OK.
11. In the Total By drop-down, select Customer.

This report will show the PO's received or billed. To view open PO's, you can use the Open Purchase Orders by Job. Follow the steps below:

1. Go to the Reports tab.
2. Click Purchases.
3. Choose Open Purchase Orders by Job.
4. Click the Customize Report button.
5. Go to the Display tab.
6. In the Columns section, click Debit and Credit.
7. Click OK.

That should do it, @whyz2. Let me know if you have any questions about the report. I'm here to lend you a hand whenever you needed me. Have a good one!

@196027

Please Learn from thin input.

@whyz2

You show you are using Enterprise Contractor Edition. Are you Not Using the WIP reporting or the Costs to Complete functions? That's how you get this: "It's not letting me know how much I have left to pay the purchase order amount."

For instance, if I list my two-sided Service item for Structural Engineering on the Estimate for the Scope of the project, I would list this as $16,500 for the $15,000 projected Cost to me + 10% markup for the Revenue.

Then, I list that same two-sided Service item on the PO; I swap Rate and Quantity. This is $1 each for Quantity = 15,000. Now I can process partial draw requests and track PO open status for fulfillment. Meanwhile, I run the Estimates Vs Actuals Detail reporting and update the Costs to Complete worksheet.

Please see my attachment.