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 Outlet 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
The name of the product / variant, ie shirt, size small
SKU/Bar-code of the product is also listed next to the Product name
The first number listed displays On-hand stock, but if you hover the mouse over this box, will see three units displayed for each outlet, in order of
Reorder qty column
Reorder point column
Unit cost column
The cost of the individual product unit, excluding any taxes. In
Hike we use the Weighted Average cost which is the most commonly used
when inventory are intertwined. It is the average of all the history
The formula behind is divide the cost of
goods available to sale by the number of unites available for sale.
Taking an example if you have a phone accessory store, and you purchase
10 phone cases for $10/unit. Next month, you purchase another 5 phone
cases for $5/unit. At the end of the accounting period, you sold 4 phone
cases; the weighted average cost will be calculated like this: (10qty* $10/unit + 5qty *$5/unit)/(10qty+5qty)= $8.33/unit
Please Note, the average cost will only be
updated based on PO, manually change of the cost price under product
detail page or via product file upload will not affect the average
Total cost column
The cost of the total inventory of product units held, excluding any taxes
The retail sale price of the individual product unit, excluding any taxes
Retail value (Ex. tax) column
The retail sale price of the total inventory of product units held, excluding any taxes.
Retail value (inc. tax) column
The retail sale price of the total inventory of product units held, including taxes.
NOTE: Current Inventory will only be available for the current date. No past data will be available on this report. Hence, you do not have option to select the time-frame on this report.
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.
The Purchase Order number
The supplier associated with the Purchase Order
The original stock level ordered
Qty received column
The actual stock level recorded as received
The 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 of the inventory adjustment along with the product name and SKU of the product adjusted.
User that performed the inventory adjustment
Adjustment reason column
Details which product was adjusted
Spoilage/Lost cost column
The cost and notes for the Spoilage/Lost product when performing the stock-take
What the adjustment amount was
Before and After column
What the stock level before and after the adjustment was
Data can be filtered based on Sales, Purchase orders, Stock takes, Inventory transfers, Manual adjustments, Data Import, Transition from integrated apps by click on the filter icon on the top right corner of the table.
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.
The product name of the item sold
Quantity sold column
The number of units of the product sold within the set time frame
Sale (Ex. tax) column
Displays 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 column
The cost price of the individual good, before tax
Average cost column
The average cost price of the individual good. This is applicable when you selected wheighted average cost option in your General settings.
Discounts given column
The monetary total of all discounts applied to that type of product
Spillage / Lost cost column
The monetary total of all losses applied to that type of product due to refunds without returning goods or from inventory adjustments
Gross profit column
Gross profit = revenue - cost of goods sold
Margin % column
The percentage difference between the cost for acquiring products and the selling price
To make your data easier to understand, Hike breaks down all the sales activities into these key reports. All sales reports share the same fields below. Outlet As with any report, choose the outlet you wish to see from the drop-down list. You can ...
User Report - Timecards
If you are not the only person to run the business, you may need to keep track of your employees' working hours by features like timesheets. The feature of clocking in/out in Hike allows your employees to clock in/out with their PIN and calculates ...
Creating & Completing Inventory Counts in Hike
Inventory counts (or stock takes, depending on where you live) are an essential part of any business – helping retailers keep track of their inventory. The basic premise of an inventory count involves recording the quantity of each product in your ...
To make your data easier to understand, Hike breaks down all the activity to these key reports. All reports share the same fields below. Outlet. As per all reports, choose the outlet you wish to see from the Find... drop down menu. Date range Click ...
My Inventory page lists all the inventory you currently have. You can filter the results by Outlet name, or by Product name, SKU, bar-code, brand, product type, supplier, season and tag. Inventory table The table displays all products with the ...