Purchase Report
The purchase report enables you to get a full view of your purchase expenses. You can choose to see the report By SKU, By Partner, By order, etc.
- Click Purchase in the top menu and select Purchase in the report section in the drop-down menu.
- Use the filter search on the left. (If you are working from a small screen, you can find the filters by clicking the magnifying glass by the Printer friendly button on the right.) You can filter by Country, Order Tags, Supplier, Supplier Tags, Stock Keeping Units, SKU Tags, etc. Click Apply to activate the filters.
- In the tabs of the table you can limit the shown information. You can select By SKU, By SKU Tag, By Country, By Partner, By Order By Month or Extraction.
- You can click Printer friendly to get a simpler version for print, or
- Click XLSX to export the report as a spreadsheet file.
Below, you can se a description of each column per tab.
By SKU
| Column name | Explanation |
|---|---|
| SKU | Global name and SKU number of the purchased Stock Keeping Unit. |
| Units | This is the unit of the SKU eg. Colli, kg, liter etc. The unit of measure is selected when setting up the SKU. Read more about units of measure here. |
| Free Units, UoM | This is the number of free Units of Measure on purchase orders in the selected unit of measure of the SKU. |
| Purchase Value of Free Units | This is the value of the free units of measure based on the price of the other units of the same SKU on the purchase order. |
| Quantity | This is the sold quantity of the SKU. |
| Quantity, UoM | This is the number of sold units in the entered unit of measure of the SKU. |
| Goods Purchase: Expected | This is the expected purchase price of the specific SKU |
| Cost Price: Expected | This is the expected cost price entered in the lot lines of purchase orders, or automatically obtained from a linked price list. Read more about price lists here. |
| Cost Price: Actual | This is the actual cost price from the linked expenses imported from your accounting system. |
By SKU Tag
| Column name | Explanation |
|---|---|
| Tags | The Column is divided by tags added to SKUs. Read more about Tags here |
| Goods Purchase: Expected | This is the expected purchase price of SKUs with the specific tag. |
| Cost Price: Expected | This is the expected cost price entered in the lot lines of purchase orders, or automatically obtained from a linked price list. Read more about price lists here. |
| Cost Price: Actual | This is the actual cost price from the linked expenses imported from your accounting system. |
By Country
| Column name | Explanation |
|---|---|
| Country | This column is divided by supplier country. |
| Goods Purchase: Expected | This is the expected purchase price of goods from the specific country. |
| Service Lines: Expected | This is the expected price of service lines on purchase orders from the specific country |
| Purchase: Total | This is the total amount of purchased goods and service lines from orders placed to partners in the specific country. |
| Cost Price: Expected | This is the sum of expected cost prices from purchase orders to the specific country. |
| Cost Price: Actual | This is the actual cost price of purchase orders imported from your accounting system. |
By Partner
| Column name | Explanation |
|---|---|
| Partner No. | This is the unique partner number in tracezilla. |
| Creditor no. | This is the creditor number of the partner. |
| Name | This is the company name of the supplier (partner). The supplier name appears on each purchase order. |
| Goods Purchase: Expected | This is the expected purchase price of SKUs ordered from the specific partner. |
| Service Lines: Expected | This is the expected expenses of service lines on purchase orders from the specific partner. |
| Purchase: Total | This is the total expenses of purchased goods and service lines from orders placed to the specific partner. |
| Cost Price: Expected | This is the sum of expected cost prices from purchase orders to the specific partner. |
| Cost Price: Actual | This is the actual cost price of purchase orders imported from your accounting system. |
By Order
| Column name | Explanation |
|---|---|
| Order # | This is the number of the purchase order. You can use this number to search for the specific purchase order in the order view. |
| Supplier | This is the supplier specified on the order header of the purchase order. |
| Status | This is the status of the order. Here, you can see if the orders is received, in transit, cancelled, etc. |
| Del. date | This is the delivery date specified under Delivery Details in the order header of the sales order. |
| Goods Purchase: Expected | This is the expected purchase price of SKUs on the purchase order. |
| Service Lines: Expected | This is the expected purchase price of lot lines on the purchase order. |
| Purchase: Total | This is the sum of purchased lots and service lines on the purchase order. |
| Cost Price: Expected | The expected cost price is the sum of expenses on the purchase order. |
| Cost Price: Actual | This is the actual cost price of the purchase order. The data is imported from your accounting system. |
By Month
| Column name | Explanation |
|---|---|
| Month | This column is divided into months in which the orders were created according to order date. The order date is specified in the Order Details of the purchase order. |
| Goods Purchase: Expected | This is the expected purchase price of SKUs on the purchase orders. |
| Service lines: Expected | This is the expected purchase price of lot lines on the purchase orders. |
| Purchase: Total | This is the sum of purchased lots and service lines on purchase orders. |
| Cost Price: Expected | The expected cost price is the sum of expenses on purchase orders. |
| Cost Price: Actual | This is the actual cost price of purchase orders. The data is imported from your accounting system. |
Extraction
If you want to create your own purchase report which contains the exact information of your needs, you can create a pivot table. Your data is already in tabulated form - which means, that every single type of data is in separate columns, to ensure the data is compatible when generating a pivot table.
Click the tab Extraction in the purchase report, and click XLSX in the upper right corner. By this, a spreadsheet is generated for download, which can then be adjusted to your needs.
Most spreadsheets has a pivot function. It varies from sheet to sheet, how the pivot table is generated. You can do an internet search, by entering e.g. “Pivot table excel” into your search engine.