Custom Report POs versus invoice versus inventory by product

Having a customized report that aligns with your specific needs in QuickBooks Online (QBO)is essential for effective inventory management and informed decision-making. This offer tailored insights that help businesses streamline operations, optimize inventory levels, and make strategic decisions based on precise data. I'll share insights about how to create the reports you need, Zoom. 

Before we proceed, I'd like to know the options you selected when you created the report.

The QBO Custom report builder has some limitations. You can't add all types of data columns to this. For instance, if you're creating a report for the products you ordered, such as Purchase Orders or Expenses, you won't be able to add data columns related to sales. This is because they represent opposite transactions. Similarly, if you create a custom report about sales, QBO won't allow data columns linked to expenses. 

A workaround I can share is generating specific reports to track the items ordered, sold, and the total stock remaining for a given period. Then, to consolidate all of these data, you can export them to Excel.

To view the items ordered for a specific period, run a Purchase by Vendor Detail report. Here's how:

1. Go to Reports.
2. In the search bar, type Purchase by Vendor Detail.
3. Choose your Report Period from the dropdown.
   
   
   

If you want to see your Purchase Orders (PO), run a Transaction List by Vendor report. Please refer to the steps below:

1. Tap the Reports menu.
2. In the search bar, enter Transaction List by Vendor.
   
   
   
   
3. Choose your Report Period from the dropdown.
4. Click Run report.

Then, generate an Inventory Valuation Detail report to track sales and quantity on hand. Here's how:

1. Go to Reports.
2. Type Inventory Valuation Detail in the search bar.
   
   
   
   
3. Choose a report period, then tap Run Report.
   
   

After running the reports mentioned above, you'll now have the option to export them to Excel. 

If you encounter any challenges while running reports in QBO or have specific scenarios you’d like to explore, feel free to leave a comment. We can provide guidance on how to utilize various report templates, customize them to fit your needs, and interpret the data to make informed business decisions, Zoom.

Pulling up transactions such as purchasing and customer invoicing aren't opposite transaction.  They're points on the same transaction path that if we can't match we can't verify our what our people are doing.  Once again QB pitches that it's the small business ERP solution for accounting, sales, inventory, etc... but fails in the actual execution.  Maybe we can get another great update where you move the left hand nav bar names around but don't actually fix anything like search being broken, the Advanced app not working for random users, etc, etc, etc....  The old saying about the only think more painful than QB is leaving QBs gets a little less likely every day.

Hi,

I would start with making sure your product/service items list is current.  Next, I would use a PO for inventory purchases.  When items are received, I would turn the PO into a bill and then when you pay the bill use bill payment.  Next, I would add items to a sales receipt or sales invoice when the item is sold.  Finally, you would be able to run an inventory report showing items purchased and sold.     All the above forms can be accessed under the +New button.  The inventory and sales by item reports can all be accessed under the REPORT menu.  

I would check to make sure all items were sold by running a vendor summary report.  The total paid out for to vendor for inventory should equal the amount you recorded as inventory for the month.  Beginning inventory + purchases made - cost of goods sold should equal your ending inventory amount.  The cost of goods sold should equal your inventory report items sold.