Welcome to Simple Stock Control! It is best to start by adding items to your inventory using the "Add Item" button.
This will show you all items in your inventory. Each item shows the following: Name (e.g. Budweiser), Group (e.g. Beer), Unit of count (e.g. Bottle), Cost price (excluding VAT/MOMs), and Sales Price (excluding VAT/MOMs).
Add new items to your inventory. You'll need to provide the item name, group (category), and cost price per unit excluding VAT. Ideally you should also add a Unit of count (e.g. bottle, case, keg, pallet, shipping container, Tardis of infinite size), and the Sale Price. If necessary come back and update the item later.
Update existing items in your inventory. Search for the item by name and modify its details.
Record the quantity of each stock item you have. You can either search for items individually or go through them organized by group. This should be done regularly to track Gross Profit etc (e.g. once a week, once a month, once a quarter)
You will find this button within Stock Count
Record stock deliveries. Enter the date, Where from, and total cost (excluding VAT) of the delivery. Pay attention to the timing if the delivery coincides with a stock count day.
You will find this button within Delivery
Calculate your gross profit percentage. You need at least 2 stock counts to use this feature. The system will use your last 2 counts and ask for the sales revenue (ex VAT) between the dates to calculate GP%. Pause for 1 second to think when the revenue occured. e.g. If you did a count at end of business on Sunday, then you should include the sales from Sunday when clicking Calculate Result. But if your next count after that was Friday morning (before business), then the sales revenue you would enter would be Monday + Tuesday + Wednesday + Thursday. The time of day that the stock counts were done is showed in this display to help you. In practice we recommend consistancy. e.g. always do them in the morning before trade. That way it is easier to remember what sales belong between the counts.
You can go one step beyond calculating the Gross Profit (GP) from your sales, and actually calculate the Net Profit (bottom line profit). After you have done Calculate Result, there is a button to continue to calculate profitabilty. You will need to enter any fixed costs (excluding VAT/MOMs) and wages to calculate this. You can enter just your main costs for a broad idea, or you can include all costs by making a final cateogory called Other
Estimate your expected gross profit based on your sales mix and product margins of best selling items. Enter your top 3 sales groups, their percentage of total sales, and the details of best-selling items in each group.
Find out what are your lowest GP items, to highlight where price increase may be necessary, or cheaper suppliers
View all previously calculated stockcount results showing start/end values, deliveries, sales, and GP% for each period. This section also shows Expected GPs, and the Profitability Results
• Perform stock counts regularly (weekly or monthly)
• Record all deliveries promptly and accurately (or keep all delivery notes and receipts in a folder so they are easily available to enter accurately)
• Keep unit prices up to date when they change significantly
• Use consistent group names for easier organization
• Also use group names if you want very location-specific grouping.
• Use Unit of Count to ensure consistancy of what precisely you are counting
• All prices should be entered excluding VAT/MOMs (sales tax). Use the calculator below if you need help converting normal retail price (inclusive of VAT/MOMs) into prices Excluding VAT/MOMs. As a general tip you can convert from inclusive of VAT to exclusive of VAT by dividing by a number which includes the VAT rate. E.g. If VAT = 25%, then divide by 1.25. If VAT = 20%, then divide by 1.20