Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
My Account Managers are requesting this. They need a report that shows all purchase orders by customer. It appears this is because there is not actually a customer associated directly with the PO, but with each line item. Does anyone know how to do this?
Hi there, Scobee. Currently, the customer's purchase order (PO) report is unavailable in QuickBooks Online (QBO). Let me discuss this in more detail.
Purchase orders are designed as vendor-centric documents. While customer-specific PO reports are unavailable. Nevertheless, you can still generate a Transaction List with Splits report as a workaround. Here's how:
After generating the report, you can export it from QBO for further personalization.
Additionally, I'm dropping this article to allow you to save your current customization report settings: Memorize reports in QBO.
Should you have any additional questions about PO reports, don't hesitate to leave a reply below. Have a great day!
Can you elaborate on using "the Estimate feature as a workaround". Assume I have zero business knowledge (I don't, I'm IT). We already create estimates. I don't understand how they can be used to "track purchase orders". The link you posted doesn't even mention POs.
(Also, thanks for the quick response. Sorry I can't edit my previous comment)
Hello Scobee! Thanks for reaching back out. As my colleague mentioned, purchase orders are vendor-centric and therefore is unavailable. However, are you trying to send the customer an estimate and process it once the customer approves your estimate? Thus wanting to see what they need? If so you can use the Estimate by Customer report to track these transactions. If you are more looking for the sales side of things, you can run the Sales by Customer Summary or Detail report.
I will be looking forward to your response. Please let me know if you need further assistance. We are here to help.
Thanks for the response. This is the original description from the user:
"One of the reports I liked to view on the previous version of QB was a purchase order by job.
This would show all Purchases for individual jobs."
Running a direct report that shows all the purchases for individual jobs is unavailable, Scobee. However, you can run the Transaction List with Splits report and customize it to show the details you want to pull up in QuickBooks. Let’s collaborate to obtain this report.
To begin, navigate to the Reports menu and enter Transaction List with Splits in the search field. From there, customize the report to display all purchase orders associated with a particular job. Follow the steps outlined below:
Then, export them to Excel to modify the data further. You can also memorize it, so you won't have to do the customization process.
I'm also including a reference guide that will help you in adding and removing purchase orders to a transaction: Add purchase orders to expenses, bills, or checks in QuickBooks Online.
If you have any questions about running the purchase order report or have concerns about QuickBooks, please feel free to contact me. I am always available to assist you. Take good care.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here