Using Excel As Cash Register/POS

[Pembo]

Hi There

Has anyone seen a neat solution where Excel has been set up like a touch screen Point Of Sale/Cash Register?

Im looking for a simple solution to use excel as a cash register type app where it tracks the sales of ice creams (about 40 products)

Ideally the screen could be used as a touch screen pressing some buttons for each of the items sold.
Then press other buttons to say how much cash received while instantly calculating the amount of change to be given

Once transacted this record gets written to an excel list that can be used for business analysis/record keeping

Look forward to any handy hints on how to achieve this

Thanks in advance

Pembo (Queensland - Australia)

 

[rs2k]

Hi Pembo, Welcome to the board,

I have had a play and set up a basic cash register for you to start with. There is a fair bit of code with it, so it doesn't really seem appropiate to post it all here.

PM me with your email and I will send you the workbook, hopefully it may get you started. If you have any questions then post back here on the board, and there's a good chance we will be able to help out.

Cheers
Colin

 

[roybrazil]

Hi Guys
I've been looking for that for ages!!! Could you post it to {mod removed email} ? I'm currently in Brazil and just cant find a simple soft to do that job!
Thanks
Roy

Mod note: I have removed your email address.

 

[lexasharma]

can you please email me this workbook
am in the caribbean and i have been tryin really hard to get my excel cash register to work

 

[roybrazil]

Hi Colin
Could you please send me the cash register you mentioned?
My email is {mod removed email}
Thank you soooo much
Roy

Mod note: I have removed your email address

 

[SMB Cooper]

Have you already tried this?


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.


EPOS 4 Excel - Home

 

[roybrazil]

Have you already tried this?


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.


EPOS 4 Excel - Home

Tried it and loved it, thing is I own a small pub and need to keep "bar tabs" for patrons... apparently the only thing EPOS doesnt do ... any advice? Thanks.

 

[asicili1]

Hi can you please email me this workbook?
I have been tryin really hard to get my excel cash register to work

 

[roybrazil]

You can download it from their own website... EPOS 4 Excel - Home

 

[MonioDee]

Hi rs2k

Can you please help me with my problem im runnin a small restaurant to which i have 300 more menus available i been lookin for many templates and at the same time a POS like system to which allowas me to choose the menu base on food category and outlet i have three outlets, BAR, CAFE, & GARDEN each outlet consist of drinks and foods and at the same time can generate daily sales base on receipt printing hoping for your help many thanks!