Version 1.8.1 released 26th March 2016!!
A recent Microsoft Update has caused problems with Excel please see my post on the forums (click here) if you are experiencing problems using the EPOS 4 Excel worksheet.
What is EPOS 4 Excel?
EPOS 4 Excel (E4E) is a Microsoft Excel macro enabled workbook released as free opensource software under the GNU Lesser General Public License 3. E4E provides a basic electronic point of sale (EPOS) system. It is programmed in Excel VBA and uses Excel worksheets as the basis of its user interface.
E4E was originally written to be used in conjunction with an internet based computerised accounting / stock management / sales system. In this case E4E enables sales to be made off-line when an internet connection is not available. However as it develops, E4E is becoming more multi-purpose.
Main Features:
- Making sales
- Save a sale and come back to it later
- Quick Products buttons on the sale screen
- Print and redeem your own gift vouchers
- Optional Fast Pay and item autocomplete windows
- Printing receipts (narrow for receipt printers AND wide for ordinary printers)
- Send duplicate receipt automatically to a second printer attached to the till
- Product prices can be stored including sales tax (which prints receipts in eg. UK format) or excluding sales tax (which prints receipts in eg. US format)
- Simple stock management and stock re-order reports
- Basic security: sales, supervisor and administrator passwords
- Sales reports
- Customor orders (including printing / searching / order statuses)
- Sales promotions (monetary discounts, % discounts, buy X get Y free, buy X for £ Y, buy X or more of the same product then change item price to £Y)
- The sales data is stored in a customisable .CSV (comma separated values) format which can be then uploaded to your separate computerised accounting / stock management system at a later convenient moment. The .CSV file can be saved in ASCII format or Unicode format (Unicode format allows the use of non-english letters)
- Option to check for updates to the EPOS 4 Excel worksheet automatically over the internet
- Being opensource, the sourcecode for EPOS 4 Excel is fully accessible. See Appendix E of the user manual for details.
For more information of the capabilities of E4E see the user manual on the download page.
Does it work?
E4E began development in early 2011 and has been tested extensively by an internet book seller that also sets up temporary bookstalls. Versions of E4E have been used in environments with single tills and multiple tills networked together.
Martin Stokley
E4E was originally written to be used in conjunction with an internet based computerised accounting / stock management / sales system. In this case E4E enables sales to be made off-line when an internet connection is not available. However as it develops, E4E is becoming more multi-purpose.
Main Features:
- Making sales
- Save a sale and come back to it later
- Quick Products buttons on the sale screen
- Print and redeem your own gift vouchers
- Optional Fast Pay and item autocomplete windows
- Printing receipts (narrow for receipt printers AND wide for ordinary printers)
- Send duplicate receipt automatically to a second printer attached to the till
- Product prices can be stored including sales tax (which prints receipts in eg. UK format) or excluding sales tax (which prints receipts in eg. US format)
- Simple stock management and stock re-order reports
- Basic security: sales, supervisor and administrator passwords
- Sales reports
- Customor orders (including printing / searching / order statuses)
- Sales promotions (monetary discounts, % discounts, buy X get Y free, buy X for £ Y, buy X or more of the same product then change item price to £Y)
- The sales data is stored in a customisable .CSV (comma separated values) format which can be then uploaded to your separate computerised accounting / stock management system at a later convenient moment. The .CSV file can be saved in ASCII format or Unicode format (Unicode format allows the use of non-english letters)
- Option to check for updates to the EPOS 4 Excel worksheet automatically over the internet
- Being opensource, the sourcecode for EPOS 4 Excel is fully accessible. See Appendix E of the user manual for details.
For more information of the capabilities of E4E see the user manual on the download page.
Does it work?
E4E began development in early 2011 and has been tested extensively by an internet book seller that also sets up temporary bookstalls. Versions of E4E have been used in environments with single tills and multiple tills networked together.
Martin Stokley
Acknowledgements:
The green basket logo was created by http://www.newidols.ru
Excel is © Microsoft Corporation
Find_Range VBA function was created by Aaron Blood, December 2004 (www.ozgrid.com/forum/showthread.php?t=27240&page=1)
The green basket logo was created by http://www.newidols.ru
Excel is © Microsoft Corporation
Find_Range VBA function was created by Aaron Blood, December 2004 (www.ozgrid.com/forum/showthread.php?t=27240&page=1)