cancel
Showing results for 
Search instead for 
Did you mean: 
Zoomnbyu
Level 2

Custom Report POs versus invoice versus inventory by product

1.  Yes I hate QBO.

2.  QB Tech support is about as useful as oxygen in a coffin.

 

That said, one of our companies biggest struggles is making sure product gets invoiced.  Many hands in the pot, lots of moving parts, etc...  Open to other suggestions but what I'd at least like to do, I think, is have a report that shows what we've ordered in a given time period, what was sold, and what total should still be in stock.  Dream world would be to do this by class.

 

Tried to create a custom report but because the requirements person for QBs with the pocket protector, visor, and HP calculator doesn't talk to the sales people or the users QB seems stuck in we're only credits and debits and never the twain shall meet in anything outside a balance sheet.  If I select anything sales related it greys out the expense.  Any suggestions?

3 Comments 3
CamelleT
QuickBooks Team

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. 

custom report builder expenses-greyed out sales.PNG


sales- greyed out expenses.PNG

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.

    reports- purcahse by vendor detail.PNG

 

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.

    reports-transaction list by vendor.PNG

  3. Choose your Report Period from the dropdown.
  4. Click Run report.


report-transaction list vendor report period run report.PNG

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.

    reports-inventory valuation detail.PNG

  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.

Zoomnbyu
Level 2

Custom Report POs versus invoice versus inventory by product

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.

sandy98758
Level 1

Custom Report POs versus invoice versus inventory by product

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.  

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us