Inventory Roll Forward By Item Export

The Inventory Roll Forward by Item Report provides a detailed summary of inventory movements and balances for specific items over a selected date range. This report helps track opening and ending balances, along with all transaction categories such as sales, purchases, transfers, and adjustments. It’s a valuable tool for understanding inventory trends and making data-driven decisions.

How to generate the report?

1. Go to Utilities →  Export → Inventory Roll Forward by Item.
2. Apply Filters:

• Date Range: Select the Start Date and End Date for the report.
• Venue, Store, Team, and Item: Use these filters to narrow down the report to specific locations or items.
• All Option: Each filter includes an "ALL" option to include data across all venues, stores, teams, or items. If you select a specific venue, the corresponding stores will automatically populate in the Stores filter.

3. Enter your email address where the completed report will be sent.
4. Click Export to generate the report. Once the process is completed, a status update will be sent to the provided email address.

The report includes the following details for each item:

• Location: Location of the Item (Venue/Warehouse/Store).
• Item Description: Name of the item.
• Item #: Unique identifier for the item (Item ID).
• Begin Qty: Opening balance of the item, this will not be the current QOH but the quantity available for the item at the selected start date of the report.
• Begin Value: Beginning total cost of the item.
• Purchases Qty: The quantity of the item received to the selected location.
• Purchases Value: The cost of the item received to the selected location.
• Qty Transferred: The total quantity of the item transferred in and transferred out. A positive QTY reflects transfers into the location.
• Amount Transferred: The cost of the item transferred.
• Sold Qty: The quantity of the item sold from the selected location. A sold negative quantity (-30) reflects the sale of 30 items reducing QOH.
• Sold Value: The cost of the item sold from the selected location.
• Spoilage/Adjustment Qty: The total quantity of the item adjusted in the selected location.
• Spoilage/Adjustment Value: The cost of the item adjusted.
• Order Qty: The quantity of the item in the store credit sale transaction.
• Order Value: The cost of the item in the store credit sale transaction.
• End QTY: The final inventory balance, considering the opening balance, purchases, transfers, sales, adjustments, and orders during the selected period.
• End Value: The final cost of inventory after accounting for beginning value, purchases, transfers, sales, adjustments, and orders.
• Variance: The difference between the opening and closing quantities, highlighting any changes during the selected period.
• Report Dates: Start and End Date of the report.

The report will be sent as a CSV file to your specified email address. This report enables you to track inventory movements across locations, identify trends and variances in inventory, ensure accuracy in stock levels and costs, and make informed decisions regarding replenishment and adjustments.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more