Download User Manual - EPOS 4 Excel
Transcript
2|Page Contents License Agreement ........................................................................................ 9 1. Introduction ............................................................................................. 10 What is EPOS 4 Excel? ....................................................................................................................... 10 System Requirements ....................................................................................................................... 10 2. Opening EPOS 4 Excel and Enabling Macros in Excel................................. 11 Opening the EPOS 4 Excel worksheet ............................................................................................... 11 Enabling macros in Excel ................................................................................................................... 11 Excel 2010 ......................................................................................................................................... 12 Excel 2007 ......................................................................................................................................... 12 3. Customising EPOS 4 Excel for your company ............................................ 13 Customising the logo on the sales screen ......................................................................................... 13 Customising the company logo and company details on the receipts ............................................. 14 Customising payment types, payment autofill and currency ........................................................... 15 Customising the sales data file settings ............................................................................................ 15 Choosing tax settings ........................................................................................................................ 15 Advanced Users: Cell protection and changing the E4E screen background colours ....................... 16 4. Setting up EPOS 4 Excel for use ................................................................ 17 EPOS 4 Excel data file settings (Essential) ......................................................................................... 17 Creating a product list (Essential) ..................................................................................................... 18 Installing the “Free3of9” barcode font (Optional)............................................................................ 19 Create an initial stock levels file (Optional) ...................................................................................... 19 Setting up a printer and printing receipts (Optional) ....................................................................... 19 Setting up E4E Security Settings (Optional) ...................................................................................... 21 Setting up Discount Reasons / Deals (Optional) ............................................................................... 21 5. Making sales with EPOS 4 Excel ................................................................ 22 Starting out ....................................................................................................................................... 22 Adding Products to the Sale.............................................................................................................. 23 Changing an item’s price ................................................................................................................... 24 Discounting an item’s price by a percentage .................................................................................... 25 Manually looking up a product’s code .............................................................................................. 26 Item Autocomplete ........................................................................................................................... 27 Using Quick Products Buttons........................................................................................................... 28 Deleting an Item from the Sale ......................................................................................................... 28 EPOS 4 Excel v1.7.3 Website: epos4excel.weebly.com ©Martin Stokley 2011-2015