All Collections
Reports
Item Movements (Invoices, Returns, Depletions)
Movement Analytics Report
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 a week 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 a "Movements Analytics" tab that filters to only show those specific actions.

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.

Download Invoices Report

If you’d like to see the total amount of invoices for all items for the current year, you can also download a spreadsheet that shows your invoices by month, or by week for each item:

  1. Click the “Actions” button

  2. Select either the monthly or weekly report

  3. In the downloaded file, you’ll see the record of invoices for every item by month or week, showing the amount of each item, and the cost. You’ll also see a grand total of the year to date so far

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?