What You Will Learn in This Guide

How to give employees access to the Goods & Raw Materials report.

How to export the report for one or more stores by year.

How to understand the information in the downloaded report file.

Important Notes

This report and feature are specifically for business owners in Thailand to comply with the Thailand Revenue Code.

You can export reports for the year 2024 onwards.

The system can only process one export at a time for your business. You cannot start a new export if one is already in progress.

Ensure the employees who need this report have the correct permissions enabled in your BackOffice.

Step 1: Give Employees Access to the Report

Before exporting, you must ensure that any employee who needs to access this report has the correct permissions enabled.

To learn how to edit employee permissions, please follow the steps in our guide: Employees: How to Set Employee Access Controls

When following the guide, look for the 'Stock Management' section and tick the checkbox for 'Goods & Raw Materials Report' to grant access.

Note:

If an employee already has access to the entire Stock Management section, they will automatically be given access to this new report.

Step 2: How to Export the Report

Once permissions are set, you can export the report.

1. In your 'BackOffice', go to 'Stock Management', then click 'Goods & Raw Materials'.

2. On the report page, select the 'Store(s)' and the 'Year' you want to export. You can select one, multiple, or all stores.

3. Click the 'Export' button. A pop-up will appear confirming the process has started.

Notes:

The final report will be sent to your email address once it is ready.

Only one report can be exported at a time.

The report will be processed in the background. Once it's ready, you will receive an email with a download link.

The downloaded file will be a ZIP file.

Examples:

Single Store:

Multiple Stores:

Step 3: Understanding Your Report

After you download and open the ZIP file, you will find one or more CSV files inside. A new CSV file is created for every 500,000 rows of data.

Here is what each column in the CSV file means:

Column Name	What It Means
Product Name	The name of the product. If a product was deleted, its name will appear with (deleted).
SKU	The Stock Keeping Unit (SKU) of the product.
Store Name	The store where the stock change happened.
Ref. Document Number	The reference ID for the action (e.g., Receipt Number, Purchase Order ID). See the table below for details.
Date	The exact date and time the stock change happened (in 24-hour format).
Employee	The name of the employee who performed the action.
Action	The type of stock activity that occurred (e.g., Sales, Stock Take, Purchase Order). See the table below for details.
Quantity In	The number of items added to your stock.
Quantity Out	The number of items removed from your stock.
Balance	The final stock quantity of the product after the change was made.

Understanding the 'Ref. Document Number'

This number helps you trace where the stock movement came from.

Action in Report	Document Number Source	Example
Sales	Receipt Number
Returned	Receipt Number
Stock Transfer Sent	Stock Transfer ID
Stock Transfer Received	Stock Transfer ID
Purchase Order	P.O. ID
Stock Return	S.R. ID
Stock Take	Stock Take ID
Cancel	Receipt Number
Update	_Blank_	These will be left blank. If stock is updated manually, StoreHub cannot guarantee the reason for the change. You might need to provide this information yourself for compliance.
Bulk Import	_Blank_	These will be left blank. If stock is updated through bulk import, StoreHub cannot guarantee the reason for the change. You might need to provide this information yourself for compliance.

For more details on what the Action in Report means, refer to our Stock Management: How to Track Stock Movement using Audit Trail article.

Frequently Asked Questions (FAQ)

1. When can I download the report for the previous year?

Reports for the previous year become available on January 1st. For example, the report for 2025 will be ready to download on January 1st, 2026.

2. Why is the 'Export' button greyed out or says 'Exporting'?

This happens when another report for your business is already being generated. The system can only process one export at a time to ensure performance. Please wait for the current export to finish. You will receive an email once it is complete.

3. What happens if my export fails?

If there is a problem generating your report, you will receive an email notifying you of the failure. The email will have a "Try Again" button that will take you back to the report page to start the export again. If the problem continues, please contact our support team.

Stock Management: [TH] How to Export the Goods & Raw Materials Report