While reports can be viewed on Vend at any time you may wish to customise, merge or manipulate this data by exporting it onto a spreadsheet. To export your reporting data, head to the reporting tab on the left and select the type of report you wish to export.
Once here, you can specify the Reporting Type, Measure and Date Range for the reporting data you wish to report. You can also click the Filter button to narrow your selection by keyword.
Once you are happy with the data shown below, click on the Export Data button on the right.
This will then download the report as a .CSV file that can be opened in a spreadsheet application such as Excel or OpenOffice
Below are a couple of suggestions on how to make the most of Vend Reporting's Export Data tool:
Comparing and Merging Reports
Comparing reports is easy when using the Export Data tool. Not only will you be able to look at multiple exported reports side by side but also merge these reports to benchmark their values against one another.
Keeping a Running Record of your Stock on Hand
While Vend Reporting does cater for historical inventory records, you may still want to keep a regular record of your stock on hand over a certain period. By frequently exporting Inventory on Hand reports you will be able to maintain a running record of your inventory levels.
Creating Customised Graphs
You can also look into using this exported data to create your graphs in your spreadsheet application. To learn how to do this in Excel check out this article here.
