Keeping an accurate record of your inventory is key to running your business well. Before, reconciling inventory in QuickBooks took a lot of time and work. All inventory showed as 1 lump sum in reports, even when it was stored in different warehouses.
The Inventory Summary Report fixes this by breaking down inventory by warehouse, so reconciling is faster, easier and more accurate.
How to view the Inventory Summary Report
Go to Reports, click Inventory, then click Inventory Summary Report.
Pick the date you want to see inventory for.
Click Run Report.
What the report shows
Item name: Listed in the first column.
Total value and quantity: Shown in the next column for each item.
Breakdown by warehouse: The other columns show the item's value and quantity in each warehouse.
How the Inventory Summary Report works
Assign a warehouse on bills or inventory adjustments: The Warehouse column on bills and the Warehouse field on adjustments only show when Warehouse Tracking is on. Go to Stores & Files, then Inventory Files, and click your file. Click Edit, open Inventory & Warehouse, turn on Warehouse Tracking and click Save. Then pick a warehouse in the Warehouse column on each bill line, or in the Warehouse field on the adjustment.
Items shipped to Amazon: When the FBA Shipments setting is turned on, ConnectBooks automatically moves items sent to Amazon from the local warehouse to the in transit warehouse. This setting needs Warehouse Tracking on.
Inventory updates as it arrives: When items arrive at Amazon's warehouse, ConnectBooks automatically moves the inventory to the FBA warehouse when the FBA Shipments setting is turned on. To learn more about how ConnectBooks automates FBA shipments, click here.
Customizing the report
You can set up the report to fit your needs:
Pick the date you want to see inventory for.
Group the data in different ways.
Show only the warehouses you pick.
For any other questions, please reach out to support. We're here to help!
Frequently asked questions
Can I see inventory for a date range?
No. The report shows inventory on 1 date. Pick the date you want to see inventory for, then click Run Report.
Why is my inventory not split by warehouse?
Each bill line and adjustment needs a warehouse. The Warehouse column on bills and the Warehouse field on adjustments only show when Warehouse Tracking is on. Go to Stores & Files, then Inventory Files, and click your file. Click Edit, open Inventory & Warehouse, turn on Warehouse Tracking and click Save. Then pick a warehouse in the Warehouse column on each bill line, or in the Warehouse field on the adjustment.