Skip to main content
Movement Analytics Report

How to see the full history of invoices, returns, depletions and more for each item in your venue

Nick Neale avatar
Written by Nick Neale
Updated over 6 months ago

Article Contents

Introduction

The Movement Analytics page is a powerful tool that shows the complete movement history of items in your venue as they are:

  • Brought in via invoices

  • Moved between areas via transfers and

  • Removed via returns or depletions

Just select a time period, and filter by the following options:

  • Invoices

  • Transfers between areas

  • Returns

  • Depletions

By default, this data is sorted by year > month.

You can further refine what you want to see by using the search, or creating custom views to group and sort the data. Learn more here:

After refining your data, you can also export it to a spreadsheet if needed.

Note: This page shows the details of every action. The Invoices / Returns, Depletions, and Returns pages on the WISK Web Portal each have an "Analytics" tab that filters to only show those specific actions.

The Depletions Analytics section is highlighted by default

Viewing Item Data Example - Invoices

A common use of this page is to see how much of an item you’ve ordered over a period of time.

In the example below, we’ll check to see how much Grey Goose 750ml we’ve ordered so far in the current year.

Note: This number is based on your invoices, so make sure that you are every invoice to WISK.

  1. Under “Reports / Analytics” click “Movement Analytics”

    The "Movement Analytics" button is highlighted.

  2. By default, it displays all movements for all items in the venue for the current year. You can use the search bar to find a specific item, or you can create custom grouping to show individual items

    All items in the venue display. The "Search" field is highlighted for emphasis.
  3. Click into the “Date Range” field to select a time period from the drop-down menu. There are a variety of options, but you can also set a custom range

    The "Date Range" drop-down has been clicked and the current year is selected.
  4. At this point, it shows all types of movements. Select a movement type from the “Predefined Filters” drop-down to narrow it down. In this example, we’ll select Invoices

    The "Predefined filters" drop-down has been clicked.

    Note: You can only filter by movement types that exist in the venue. For example, if you haven’t created any returns they won’t appear as a filter option

  5. All movements of the selected type display. In this example, we can see every invoice we added for the item, along with the total dollar value and number of units ordered (Displayed in the Item Total, and Line Measurement columns).

    The page displays all of the invoices for Grey Goose 750ml for the current year.

Export Data to Spreadsheet

At any time, you can export the information that is currently displaying in the table by clicking the "Export" icon.

An arrow points to the 'Export" icon.

This is a quick way to see your invoices and the amount spent on all items in the current year, but doesn’t provide the same flexibility as the page.

Other Uses

There are countless ways to manipulate and display the data on this page. Through use of custom views and even custom fields, you can create your own custom reports.

Some examples include:

Learn more:

Did this answer your question?