Skip to main content
April 14, 2025
Question

Purchase Order report

  • April 14, 2025
  • 1 reply
  • 0 views

I want to see details of all purchase orders in a single report for a specified time period, not just open POs, meaning even if a PO was raised during a period and all invoices have been received, the report should still show that in the PO list. Is this possible? Specific columns i want to see in the report are as follows:

1. PO date

2. PO number

3. Original amount

4. Invoice received

5. Open PO amount

6. GL PO was coded to

 

Thanks. 

1 reply

April 14, 2025

Hey Omer_S,

 

Thank you for reaching out to the QuickBooks Community! Currently, we do not have a single report that can do this. However, a workaround would be to export the different Purchase Order Reports in Excel and customize them to your liking. Here's how to export Reports into Excel:

 

  1. Go to Reports
  2. Search for and select the report you want to export.
  3. Select the Export/Print▼ dropdown, then select Export to Excel.
  4. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

For the other reports, choose Updating Existing Worksheet and customize the report. For more information, feel free to use this handy article. 

 

 

Please let me know if you have any questions or concerns. My team and I are happy to help.