Initial Set up
1. The very first thing you should do is to gather as many recent receipts and invoices as possible.
2. Then you should start to add items. Click on "Add Item" and fill out at least the Item Name, the Group, the Unit of count, and the Cost Price (ex VAT/MOMs). You can also add the Sale Price (ex VAT/MOMs), but that is optional.
Let's give an example:
You have an invoice from a wholesaler for 10 kegs of Carlsberg for 500kr a keg (ex VAT/MOMs)
You have receipt for Budweiser from a local supermarket for 240kr for 24 bottles (inclusive of VAT/MOMs). And you have a receipt for a bottle of Smirnoff vodka from a local supermarket for 99kr.
You enter this:
Item Name: Carlsberg
Group: Draught Beer
Unit of Count: Keg
Cost Price per Unit (ex VAT/MOMs): 500
and this...
Item Name: Budweiser
Group: Bottle Beer
Unit of Count: Bottle
Cost price per unit (ex VAT/MOMs): 8
So where does this 8 come from? The cost per bottle is 10kr (inclusive of MOMs). The MOMs rate is 25%. Therefore the ex MOMs price is 10/1.25 = 8
and add this:
Item Name: Smirnoff
Group: Spirits
Unit of Count: Bottle
Cost price per unit (ex VAT/MOMs): 79.2 (this is 99/1.25 = 79.2)
Keep on adding more items until you are happy your product range has been entered into your item list. This is possibly the most time consuming aspect of anything. Do it over several sittings if necessary. Once you have got the item list set up, your life becomes easier.
3. If you make any mistakes you can use "Amend Item" to correct them. You can also use Amend Item to add Sale Price (ex VAT) to an item (if you haven't done so already). Sale price is necessary for items to appear in the "Item GPs" display. It is not essential to your stock count, or stock count result.