Skip to main content
All CollectionsConnectBooks Inventory
The Inventory Summary Report explained
The Inventory Summary Report explained

This article explains the power of the inventory summary report.

C
Written by Chava Teller
Updated over a month ago

Keeping an accurate record of your inventory is crucial for running an effective business. Previously, reconciling inventory in QuickBooks was a time-consuming and complex process. All inventory appeared as a single lump sum in reports, regardless of being stored in different warehouses.

The Inventory Summary Report simplifies this by breaking down inventory by warehouse, making reconciliation faster, easier, and more accurate.

How to view the Inventory Summary Report

Navigate to the Inventory Reports and select the Inventory Summary Report.

What the Report Shows:

  • Item Name: Listed in the first column.

  • Total Value and Quantity: Displayed in the next column for each item.

  • Breakdown by Warehouse: The remaining columns show the item's value and quantity divided by warehouse.

How the Inventory Summary Report Works

  1. Assign a Warehouse on Bills or Inventory adjustments
    When creating a bill or adjustment, assign the warehouse in the details section.

  2. Items shipped to Amazon
    ConnectBooks automatically transfers items sent to Amazon from the local warehouse to the In-Transit warehouse.

  3. Update Inventory as It Arrives
    When items arrive at Amazon's warehouse, ConnectBooks automatically moves the inventory to the FBA warehouse.
    To learn more how ConnectBooks automates FBA Shipments, click here.

Customizing the Report

Adapt the report to your specific needs using the customization options available:

  • Selecting a specific date range.

  • Grouping data by various criteria.

  • Displaying data for selected warehouses only.

For any additional questions, please reach out to support. We're here to help!

Did this answer your question?