Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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:
If you want to see your Purchase Orders (PO), run a Transaction List by Vendor report. Please refer to the steps below:
Then, generate an Inventory Valuation Detail report to track sales and quantity on hand. Here's how:
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.
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