To make your data easier to understand, Hike breaks down all the activity to these key reports.
All reports share the same fields below.
As per all reports, choose the outlet you wish to see from the Find... drop down menu.
Search & select one or more products, brands, product types, suppliers, seasons or tags to filter your results. This will only provides inventory reports for the particular data you are after.
Click on the date range box to choose to see data from Today, Yesterday, Last 7 days, Last 30 days, This month, Last month or a Custom range.
Click the APPLY button to data from that date period.
Click the EXPORT button to export the current report you are viewing for the date range selected.
Choose between PDF or Excel (.XLSX) format.
We will now go through the sections available on screen exclusively for Inventory Reports.
CURRENT INVENTORY REPORT
Current inventory report lists details of the current inventory. Use the search box to only display details of a particular product within the date range selected.
Use the tick box Show low inventory items only (that has reached reorder level) to only display specific data, if you have completed the settings in the Products settings
Product columnThe name of the product / variant, ie shirt, size small
Inventory columnThe first number listed displays available stock, but if you hover the mouse over this box, will see three units displayed for each outlet, in order of
- Current stock available
- stock on back order, layby or parked
- Available stock for sale
Reorder qty columnThe preset stock level suggested to reorder when stock levels hit the reorder point (if no settings made, will default to 0)
Reorder point columnThe preset stock level suggested to trigger an alert if stock levels ever reached this level (if no settings made, will default to 0)
Unit cost columnThe cost of the individual product unit, excluding any taxes
Total cost columnThe cost of the total inventory of product units held, excluding any taxes
Retail price columnThe retail sale price of the individual product unit, excluding any taxes
Retail value (Ex. tax) columnThe retail sale price of the total inventory of product units held, excluding any taxes
INVENTORY PURCHASE REPORT
Inventory purchase report lists details of Purchase Order activity. Use the search box to only display details of a particular Purchase Order number within the date range selected.
PO# columnThe Purchase Order number
Supplier columnThe supplier associated with the Purchase Order
Qty columnThe original stock level ordered
Qty received columnThe actual stock level recorded as received
Cost columnThe total cost of the stock on the Purchase Order
INVENTORY ADJUSTMENT REPORT
Inventory adjustment report lists details of changes to stock level activity, typically by adjusting the stock levels in the Product details.
Date columnDate of the inventory adjustment
User columnUser that performed the inventory adjustment
Adjustment reason columnDetails which product was adjusted
Change columnWhat the adjustment amount was
Opening columnWhat the stock level before the adjustment was
Closing columnWhat the stock level after the adjustment was
COST OF GOODS SOLD (COGS) REPORT
Cost of goods sold report lists details of of the cost of goods sold. Use the search box to only display details of a particular product within the date range selected.
Item columnThe product name of the item sold
Quantity sold columnThe number of units of the product sold within the set time frame
Revenue (Ex. tax) columnDisplays the amount of money that a company actually receives during a specific period, including discounts and refunds, paid by cash, card, gift card, on account, for the total sales of the particular item
Purchase cost columnThe cost price of the individual good, before tax
Discounts given columnThe monetary total of all discounts applied to that type of product
Spillage / Lost cost columnThe monetary total of all losses applied to that type of product due to refunds without returning goods or from inventory adjustments
Gross profit columnGross profit = revenue - cost of goods sold
Margin % columnThe percentage difference between the cost for acquiring products and the selling price