Excel Laptop Backup Cash Register for 77 items [Download]

If you have Microsoft Excel on your laptop (Professional Preferred), this app will make your laptop into a backup cash register for 77 items.

The Cash Register and Buttons already work, just add item names and prices.

First when file is downloaded, click in browser buttons, if they appear, Enable Edition and Enable this Content, if anything else is done like clicking buttons first, file will lock up and a new download will be needed.

Save file on your computer with little different name, then Click in Browser, right hand corner, Ribbon Display options, then click, Auto Hide Ribbon. This will get the Ribbon out of way and all button will be on screen. When finished, always resave file, by putting curser in right hand corner on Auto hide Ribbon icon or (dots), click. Then click, Show tabs and Commands, so you can resave file.

In cell A36 put the tax you charge. For first item put, name of item in cell A1 and price in cell D1, continue and put names of item and prices in each row. The Blue button adds to total column, the Red Button removes it, if a mistake is made. A zero will be put in cell of erased item and zero will saved in records of sales on sheet 2. The big Blue button by total column puts all sales on sheet 2 and each sale on sheet 3 for printing, it might be possible to print receipt for each sale. If print isn’t set up, an icon will appear, click ok or cancel and Cash Register will return to Sheet 1 for next order. This is designed as backup Cash Register for 24 hour restaurants that when they turn off computer to do reading.

If name of item is too big (about 25 letters or spaces), when button is clicked, an error will occur. Also, only about 19 items can be rang up at a time, if more are, it will stop entering.

If restaurant gets busy while main computer is off, this is a big help, not having to look up item prices and figure totals by hand.

This software will do more but basically selling it as backup Cash Register.

Not only does it give total price but also total weight if weight is added to column B1 (for first item). Column B is collapsed to very thin line. Put cursor to top of column B and right click. An icon will appear, click column width, change from .42 to 3 and put in weight. Put cursor at top of column B and put in .42 for column width to return it to be thin out of the way form. Column C1 (for first item) is for drink weight. If item is a soda, put drink weight in same way weight was put in for column B. Continue adding weights for each item in row below, (B2, B3…C2, C3…).

Then, weights are printed on receipt when totaled, for a Drive thru, weight bag of food to be sure it’s right before handing it out to customer, to be sure all items are in bag! Also check drink weights. This keeps mistakes from being made on drive thru!

If it is possible to get printer working, put name of your restaurant on Sheet 3, replace Restaurant Name with your Restaurant Name in B1 and Leave D.W. (for Drink Weight, alone). Some printers have Cash Drawer Kick out voltage. A line from that can be connected to Cash Drawer and when sale is finished and total button is click, the printer will print receipt and send kick out voltage to cash drawer and it will open! This will make a normal Cash Register. In this case, use a desktop touch screen to press buttons and after software has been set up, remove key board to keep software from being messed with.

Find receipt printer company that says it will work in Excel, buy printer (they are unusually expensive due to low volume of sales compared to regular printers), delete any printer software on computer and add new software from printer receipt company.

To put your print code in.

First you need to what your print code is.

Click View in Browser, just below Macros the down arrow, click on that and icon appears that says, View Macros, Record Macro. Click on Record Macro. Icon will appear that will give number to Macro, remember that number and click okay (maybe Macro 157).

Then in Excel, click file and then print

Then click on down arrow under Macros in Browser, icon will appear, click stop recording.

The click on Macros, View Macros and then scroll down and click on Macro 157, then step into or edit.

Once in Macro 157, copy print code.

Put Cursor on Big Blue Button, Right click.

Put cursor on assign Macro and click.

When Icon appears, scroll down to Macro 700.

Click on Macro 700, then In corner of icon, click edit.

Scroll down in the code of Macro 700, till you see 2 rows of green stars.

Erase what is in their and paste your code to print between rows of stars.

Click right corner of screen to close the Integrated Development Environment (IDE).

Save file. This will save your print code.

If there is any problem printing, contact help desk of receipt printer company.

To do reading

When Cashier starts, click Button 78 (the one that says Change Cashier) and ring up order with big blue button. This will put the word Change Cashier on sheet 2. Then Cashier starts and cash register will put orders on Sheet 2, When Cashier is finished taking orders, click Button 78 (Change Cashier), this will put the word Change Cashier on sheet 2 where Cashier finished.

Go to sheet 2 and sum up totals from the first order number cashier started (After the first words Change Cashier) at too final order number cashier finished, just before the last words Change Cashier on Sheet 2.

OR

Use Data Base Access, link to Excel file and Query from first order number cashier started at too final order number cashier finished.

Save file and connect Data Base to Excel file and do Query that will sum Totals for you.

This is new generation, disposable software. Once sheet 2 is filled up, which could take many, many years, especially if Professional Microsoft Excel is used as Professional has the largest Sheet 2, just buy another download and start over.