The historical asset report lets you see the value of your assets on a particular date. This is useful when filing taxes. Retail POS exports the historical asset report to a CSV file, which you can then use for your calculations.

Accounts with many locations and a very large number of inventory items may generate a CSV file that is too large to open. Most spreadsheet programs have a limit of around 1 million rows. If your file exceeds that limit, you can either export files for each shop location individually, or use a CSV splitter application to split your CSV file into smaller files.

Exporting the historical asset report

To export the CSV file:

1. Navigate to Reports.
2. Click Asset History.

3. Use the date dropdown to select your date, then click Apply.

   

4. Use the location dropdown to choose the location.

   A user can only select shops they have access to for report generation and won't see shops they don't have access to in the list. If a user is restricted from some shop locations, the All shops option will only include the locations the user has permission to view. You can edit a user's location access permissions at any time.

5. Click Generate report.

Retail POS will begin generating the requested report. You can queue up multiple reports for generation at a time.

If the report is very large, it may take some time to generate. You can navigate away from this page, continue working in Retail POS, and return to the report later to download the results.

When you return to the History report, you'll see a list of recently generated reports. For each report, you will see:

• the shop(s) selected for the report
• the user who generated the report
• the date and time that the user initiated the generation of the report (in the local time zone of the shop location currently logged into)
• a download button
• a timer indicating how long the report will remain available for download

To download a report, click Download.

Once generated, a report will only be available for 24 hours. Afterwards, it will appear on this page with an Expired status and you'll need to regenerate the report.

If something went wrong during the report generation process, the report will show an Error status. You'll need to regenerate the report to fix this issue.

Reports are only available for download on the device used to generate the report.

Understanding the report

Once the report has been downloaded, you can open it with any spreadsheet viewing software.

For a given item, you will see what the values were on the date you selected for the following:

• The item's System ID.

  An item's system ID never changes. This is included in the report only to help identify items in your inventory.

• The item's Description, or name.
• The Category the item was under.
• The Brand assigned to the item.
• The Vendor assigned to the item.
• The item's UPC.
• The item's EAN code.
• The quantity on hand (QOH).
• The total Cost value of the item for that quantity.