The most memorable local eateries along the highways and back roads of America
Sign In | Register for Free!
Restaurants Recipes Forums EatingTours Merchandise FAQ Maps Insider

 cash register till sheet...

Author Message
GoTTi

  • Total Posts: 106
  • Joined: 4/9/2008
  • Location: Los Angeles, CA
cash register till sheet... Mon, 03/2/09 12:26 AM (permalink)
im looking for a cash register sheet template. the paper that has columns with denominations of the papers and how many we write are in the register. im looking for something like that.
 
thanks
 
#1
    GoTTi

    • Total Posts: 106
    • Joined: 4/9/2008
    • Location: Los Angeles, CA
    Re:cash register till sheet... Tue, 03/3/09 12:00 PM (permalink)
    so no1 has any information on this???
     
    #2
      pdxyyz

      • Total Posts: 411
      • Joined: 5/30/2003
      • Location: not here, OR
      Re:cash register till sheet... Tue, 03/3/09 12:18 PM (permalink)
      I have  a spreadsheet that you enter each denomination and it calculates the totals.

      Enter the float you want to keep in the till and it will calculate your nightly deposit.

      Unfortunately the file attachment function in the forum only allows gif and jpg files of 25K or less so the attached picture may be a bit small.





      Attached Image(s)
       
      #3
        konnie

        • Total Posts: 334
        • Joined: 2/10/2008
        • Location: Neodesha, KS
        Re:cash register till sheet... Tue, 03/3/09 2:15 PM (permalink)
        GoTTi


        im looking for a cash register sheet template. the paper that has columns with denominations of the papers and how many we write are in the register. im looking for something like that.
         
        thanks


        I'm not sure exactly what you are looking for.  I have a Microsoft Excel spreadsheet that I built.  It lists all the products I sell and the food cost on each.  At the end of the day I plug in the # sold and the Gross amounts.  It then gives me a average sale per unit and the gross profit per menu item.  Of course I still have other fixed expenses but it takes them into account also.  It is far too large to post on here but if you have Microsoft Excel on Windows XP and would like a copy, PM me with your email address and I will attach a copy for you.  You will need to modify it to fit your products and food cost but if it will work, I'll be glad to send it to you.
         
        Mike S.
         
        #4
          edwmax

          • Total Posts: 2012
          • Joined: 1/1/2007
          • Location: Cairo, GA
          Re:cash register till sheet... Tue, 03/3/09 2:20 PM (permalink)
          A spreadsheet is easy to build.    …..But, it needs to track and report sales & taxes in the same manner as recorded by the cash register, as these should be your weekly, monthly and yearly sales & tax summary.     ……. A good cash register ($200 -$300) can give a close-of-day report, totaling the number of sales; average amount of sales; and break down of sales by each product category; as well as total cash & checks collected and sales taxes collected to be paid to the gov.  Some of these cash registers can connect to a computer system to make a complete inventory system.
           
           
          For those that may be interested, here is a POS/cash register program that can run on a computer.   This might make a laptop ideal for use in trailer concessions or hot dog cart (??).  It's free.
          http://pages.prodigy.net/daleharris/pos.htm
           

          <message edited by edwmax on Tue, 03/3/09 2:46 PM>
           
          #5
            JayL

            • Total Posts: 213
            • Joined: 11/11/2008
            • Location: Charleston, SC
            Re:cash register till sheet... Tue, 03/3/09 2:40 PM (permalink)
            Most registers can be programmed for different departments (at least I think that's what you call them).  You can program each department for different items such as appetizers, entrees, drinks, alcohol/wine, desserts, take-out, or anything else you want to calculate separately.  Your X and Z will give you this information at the end of the shift/day.

            I did not do that in my business, but I did do a very simple Excel spreadsheet that totaled my daily lunch, dinner, credit cards, cash & checks, and take out.  All I did was input the sales figures and my daily totals and monthly total was automatically updated in the spreadsheet.

            I've never gotten into the daily "profit" reports as food costs are continually changing.  Unless you're willing to update your entire food cost list once or twice a week you aren't going to get a true profit report.  I believe food cost/profit reports are more accurately looked at on a monthly basis.  But that's only my opinion.  Do what works best for your business.
             
            #6
              GoTTi

              • Total Posts: 106
              • Joined: 4/9/2008
              • Location: Los Angeles, CA
              Re:cash register till sheet... Thu, 03/5/09 11:12 PM (permalink)
              ya thats not what im looking for. i use quickbooks POS to process my orders, i input them at the end of each day.

              what im looking for is:

              i count the money i have on me. 1,5,10,20,50,100 bills and my quarters.

              if i have 95-$1, 150-$5, etc,....i write that in the field/line on the piece of paper in each column you know...

              then at the bottom it has a total line where i figure out the total after im done counting the cash and writing the values.

              then it has another line for the amount i started the day with, the cash i started with so i write that in and deduct that from the total cash and another line has the actual amount of cash i should have compared to the sales i had.

              thats what im looking for    
               
              #7
                edwmax

                • Total Posts: 2012
                • Joined: 1/1/2007
                • Location: Cairo, GA
                Re:cash register till sheet... Fri, 03/6/09 1:25 PM (permalink)
                Like this:

                Currency        Count                Total

                $100’s          ______        =    _____
                $50’s            ______        =    _____
                $20’s            ______        =    _____
                $10’s            ______        =    _____
                $ 5’s             ______        =    _____
                $  1’s            ______        =    _____

                Coins

                50               ______        =    _____
                25               ______        =    _____
                10               ______        =    _____
                5                 ______        =    _____
                1                 ______        =    _____

                            TOTAL Cash        =    ______

                            Total Checks       =    ______

                        TOTAL Drawer        =    ______

                A spreadsheet is still easy to build. I did this with pencil as I counted down the drawer.

                 
                #8
                  BigSlicks

                  • Total Posts: 235
                  • Joined: 9/7/2008
                  • Location: Goodyear, AZ
                  Re:cash register till sheet... Fri, 03/6/09 8:24 PM (permalink)
                  My wife is a Payroll manager and does all my spread sheets and uses excel if there is anyone that would like a template let me now I can email one to you.


                  Big Slick
                   
                  #9
                    Online Bookmarks Sharing: Share/Bookmark

                    Jump to:

                    Current active users

                    There are 0 members and 1 guests.

                    Icon Legend and Permission

                    • New Messages
                    • No New Messages
                    • Hot Topic w/ New Messages
                    • Hot Topic w/o New Messages
                    • Locked w/ New Messages
                    • Locked w/o New Messages
                    • Read Message
                    • Post New Thread
                    • Reply to message
                    • Post New Poll
                    • Submit Vote
                    • Post reward post
                    • Delete my own posts
                    • Delete my own threads
                    • Rate post

                    2000-2014 ASPPlayground.NET Forum Version 3.9
                    What is Roadfood?  |   Privacy Policy  |   Contact Roadfood.com   Copyright 2011 - Roadfood.com