Purchase Orders by Job Reports

@Anonymous

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.

When will you be making reports that contractors actually use?  Having to pull 2 reports to get the information we want is a bit cumbersome, don't you think? 

IE  Purchase Orders:  they should be considered committed and to the project costing reports.  Otherwise costing reports are skewed (not accurate).  Invoices should not be the only thing that gets committed.

We here create purchase orders for every purchase where we expect an invoice, whether that be from a subcontractor or a supplier.  Credit Card Charges go directly to the costing report.  

I've been asking for this for over 6 years, and we are nary a step closer.

I use 2019 Premier.  Those 2 reports you note, I need to run multiple reports to get all the information I need.  Bonding companies would like to see the information from both on one report.  Therefore, I have to run them in excel and merge.  And for the cost of the program, and considering how long you have been in business, those reports should be able to seen in one report.  Let me choose the columns I want to see.

However, even if you have a background in Database programming, the nomenclature from report to report is different for the same information.

Also, you did not hit on the fact that the Purchase Order will only show the invoices applied to that purchase order.  The balance on that PO is not noted on that report.

PS  I ran a report such as those for projects I knew had costs associated with them and received no information at all.

There is a glitch somewhere in the system. 

I may have to switch to a program created by contractors for contractors, or go to an  Excel  Spreadsheet version.  At least there wouldn't be as many headaches.

Thanks for joining this conversation, donnagrail.

We acknowledge your opinion with the reports in QuickBooks Desktop. Each business is unique, along with their needs, so I can see how important online banking is for you.

As shared by my colleague Jen_D, you'll have to run multiple reports to get all the needed information.

The Job Estimates vs. Actuals Detail report let's you view the costs and revenues for each customers or job. Here's how:

1. Go to Reports at the top menu bar to open the list.
2. Under the Jobs, Time, & Mileage, select Job Estimates vs. Actuals Detail.
3. Click the drop-down arrow and select the appropriate customer or job.
4. Hit OK.

To shows the PO balance, you can run the Open Purchase Orders by Job. Please follow the steps provided by Jen_D above.

I assure you that I'm taking note of your suggestions and passing it along to our developers for consideration in the near future.

Once there are any updates about your request, I'll let you know by updating this thread.

You can also check out the Firm of the Future site to learn more about product enhancements and tips to efficiently manage your business.

If you have any questions, please let me know. I'll be here and ready to help anytime. Have a good one.