Beverage-StockTake-Template

Document Sample
Beverage-StockTake-Template Powered By Docstoc
					                       Beverage Stock Take
                                  For more small business templates visit:
                                                                   © 2008 Spreadsheet123.com


                            Inventory Settings
                   Unit               UOM                  Cost
Spirits            Bottle           25ml Shots   Per Bottle       Per Shot
Teachers            70cl               28.0       £21.35           £0.76
Bells               70cl               28.0        £9.97           £0.36
Bells              1.5ltr              60.0       £20.06           £0.33
Glenfiddich         75cl               30.0       £14.45           £0.48
Glenmorangie        70cl               28.0       £17.85           £0.64
Jack Daniels        70cl               28.0       £12.06           £0.43
Jack Daniels       1.5Ltr              60.0       £25.17           £0.42
Jim Beam            70cl               28.0       £11.39           £0.41
Jameson's Irish     70cl               28.0       £10.28           £0.37
Jameson's Irish    1.5Ltr              60.0       £20.77           £0.35
Southern Comfort    70cl               28.0       £10.91           £0.39
Southern Comfort   1.5ltr              60.0       £22.57           £0.38
Gordons' Gin        70cl               28.0        £8.84           £0.32
Gordons' Gin       1.5Ltr              60.0       £18.23           £0.30
Bombay Sapphire     70cl               28.0       £10.17           £0.36
Smirnoff Red        70cl               28.0        £8.96           £0.32
Smirnoff Red       1.5Ltr              60.0       £18.46           £0.31
Absolut             70cl               28.0        £9.46           £0.34
Captain Morgan      70cl               28.0        £8.51           £0.30
Bacardi             70cl               28.0        £9.42           £0.34
Bacardi            1.5Ltr              60.0       £20.58           £0.34
Martell ***         70cl               28.0       £11.58           £0.41
Martell ***        1.5Ltr              60.0       £24.71           £0.41
Remy Martin         70cl               28.0       £18.36           £0.66
Baileys             70cl               28.0        £8.70           £0.31
Baileys            1.5Ltr              60.0       £17.84           £0.30
Cointreau           70cl               28.0       £11.51           £0.41
Drambuie            70cl               28.0       £12.92           £0.46
Malibu              70cl               28.0        £7.82           £0.28
Malibu             1.5Ltr              60.0       £16.23           £0.27
Archers             70cl               28.0        £7.60           £0.27
Archers             70cl               28.0       £15.01           £0.54
Tequila             70cl               28.0       £10.27           £0.37
Luxardo Sambuca     70cl               28.0        £8.97           £0.32
Tia Maria           70cl               28.0        £9.83           £0.35
Tia Maria          1.5ltr              60.0       £20.71           £0.35
Fortified Wines            Bottle                       50ml Shots   Per Bottle   Per Shot
Cinzano Bianco              75cl                           15.0        £3.44        £0.23
Martini Dry                 75cl                           15.0        £3.55        £0.24
Martini Rosso               75cl                           15.0        £3.46        £0.23
Campari                     75cl                           15.0        £8.30        £0.55
Cockburns Ruby              75cl                           15.0        £5.50        £0.37
Bristol Cream               75cl                           15.0        £5.22        £0.35
Club Classic                75cl                           15.0        £4.42        £0.29
Harveys Dune                75cl                           15.0        £4.40        £0.29




Table Wines                Bottle       Bottle Size       Each       Per Case     Per Bottle
35º South Red             Case 12Bt        750ml           12.0       £34.68        £2.89
Lindemans' Chardonnay     Case 6Bt         750ml           6.0         £3.21        £0.54
Arniston Bay              Case 6Bt         750ml           6.0         £2.87        £0.48
Côtes du Rhône            Case 12Bt        750ml           12.0        £2.47        £0.21
Jacobs Creek            Case 12Bt Sm.      750ml           12.0        £4.45        £0.37
Louis Raymond           Case 12Bt Sm.      750ml           12.0        £7.82        £0.65
Castletorre             Case 12Bt Sm.      750ml           12.0        £2.00        £0.17
Muscadet                  Case 6Bt         750ml           6.0         £2.36        £0.39
Piesporter                Case 6Bt         750ml           6.0         £2.13        £0.36
Piesporter (Small)        Case 6Bt         375ml           6.0         £1.15        £0.19
Pinot Grigio              Case 6Bt         750ml           6.0         £2.55        £0.43
Faustino Crianza          Case 12Bt        750ml           12.0        £3.59        £0.30
35º South White           Case 12Bt        750ml           12.0        £2.99        £0.25




Draught Beer                Keg         Size in Pints                 Per Keg      Per Pint
Boddingtons               22 Gallon         176                       £95.38        £0.54
Murphy's                  10 Gallon          80                       £53.25        £0.67
Draught Lager               Keg       Size in Pints          Per Keg     Per Pint
Hoegaarden               7.1 Gallon       56.8                £35.00      £0.62
Stella Artois             22 Gallon       176                 £95.46      £0.54
Stella Artois             10 Gallon        80                 £55.40      £0.69




Bottled Beer             Bottle/Can   Bottle Size     Each   Per Case   Per Bottle
Labatt Ice                Case 24Bt      330ml        24.0    £13.32      £0.56
Stella Artois             Case 24Bt      330ml        24.0    £10.56      £0.44
Budweiser                 Case 24Bt      330ml        24.0    £17.22      £0.72
Becks                     Case 24Bt      275ml        24.0    £14.10      £0.59
Old Speckled Hen          Case 12Bt      500ml        12.0    £26.34      £2.20
Bacardi Breezer           Case 24Bt      275ml        24.0    £19.20      £0.80
WKD Blue/Iron Brew        Case 24Bt      275ml        24.0    £19.44      £0.81
Smirnoff Ice/Black Ice    Case 24Bt      275ml        24.0    £21.86      £0.91




Cider                    Bottle/Can   Bottle Size     Each   Per Case   Per Bottle
Strongbow                 Case 24Bt      275ml        24.0    £10.92      £0.46
Woodpecker                Case 24Bt      275ml        24.0    £11.16      £0.47




Minerals                 Bottle/Can   Bottle Size     Each   Per Case   Per Bottle
Britvic J20               Case 24Bt      275ml        24.0    £10.08      £0.42
Coke/Diet Coke            Case 36Bt      330ml        36.0    £19.08      £0.53
Fruit Juices              Case 36Bt      180ml        36.0    £2.40       £0.07
Fruit Juices              Case 48Bt      113ml        48.0    £1.82       £0.04
Minerals                  Case 36Bt      180ml        36.0    £1.84       £0.05
Minerals                  Case 48Bt      113ml        48.0    £1.38       £0.03
Tango Diet                Case 36Bt      180ml        36.0    £2.12       £0.06
Strathmore                Case 12Bt       1Ltr        12.0    £4.91       £0.41
Strathmore                Case 24Bt      330ml        24.0    £2.54       £0.11
Red Bull                  Case 24Bt      250ml        24.0    £7.67       £0.32
Squash/Cordial            Case 12Bt       1Ltr        12.0    £0.77       £0.06
Lime Cordial              Case 12Bt       1Ltr        12.0    £0.77       £0.06
Coke/Diet Coke (Cans)   Case 24Bt         330ml            24.0       £12.22        £0.51




Post-Mix Drinks         Cartons     Portion Size in ml   Portions   Per Carton   Per Portion
Post-Mix Pepsi/Diet       10Ltr            20             500.0       £15.25        £0.03
Post-Mix Lemonade         10Ltr            20             500.0       £14.43        £0.03
Post-Mix Tango            10Ltr            20             500.0       £12.30        £0.02
Sprite                    5Ltr             25             200.0       £15.53        £0.08




Containers
Cases                     Each                             1.0        £1.00
Bottles - Small           Each                             1.0        £0.04
Suregas B                 Each                             1.0        £15.75
Suremix 30/50             Each                             1.0        £28.30
e                                       Buy unlocked version!

plates visit: Spreadsheet123.com          Cost: $24.95USD
      © 2008 Spreadsheet123.com




                      Retail
             Per Shot     Per Bottle
              £1.89            £52.92
              £1.94            £54.32
              £1.94        £116.40
              £2.56            £76.80
              £2.79            £78.12
              £2.06            £57.68
              £2.06        £123.60
              £2.06            £57.68
              £2.06            £57.68
              £2.06        £123.60
              £2.06            £57.68
              £2.06        £123.60
              £1.89            £52.92
              £1.89        £113.40
              £2.45            £68.60
              £1.89            £52.92
              £1.89        £113.40
              £2.45            £68.60
              £1.89            £52.92
              £1.89            £52.92
              £1.89        £113.40
              £2.56            £71.68
              £2.56        £153.60
              £3.12            £87.36
              £2.06            £57.68
              £2.06        £123.60
              £2.06            £57.68
              £2.06            £57.68
              £1.89            £52.92
              £1.89        £113.40
              £1.89            £52.92
              £1.89            £52.92
              £2.06            £57.68
              £2.06            £57.68
              £2.06            £57.68
              £2.06        £123.60
Per Shot     Per Bottle
  £1.89       £28.35
  £1.89       £28.35
  £1.89       £28.35
  £1.89       £28.35
  £2.34       £35.10
  £2.34       £35.10
  £2.27       £34.05
  £2.34       £35.10




Per Bottle   Per Case
 £10.75       £129.00
 £11.25       £67.50
 £10.75       £64.50
  £9.95       £119.40
 £15.40       £184.80
 £20.00       £240.00
  £9.95       £119.40
  £9.95       £59.70
 £10.25       £61.50
  £5.40       £32.40
 £11.25       £67.50
 £11.75       £141.00
 £10.75       £129.00




 Per Pint     Per Keg
  £2.68       £471.68
  £2.92       £233.60
 Per Pint    Per Keg
  £2.55      £144.84
  £2.92      £513.92
  £2.92      £233.60




Bottle/Can   Per Case
  £2.72       £65.28
  £2.64       £63.36
  £2.93       £70.32
  £2.72       £65.28
  £2.85       £34.20
  £2.85       £68.40
  £2.85       £68.40
  £2.98       £71.52




Bottle/Can   Per Case
  £1.99       £47.76
  £1.99       £47.76




Bottle/Can   Per Case
  £1.74       £41.76
  £1.65       £59.40
  £1.10       £39.60
  £1.02       £48.96
  £1.10       £39.60
  £1.02       £48.96
  £1.10       £39.60
  £3.15       £37.80
  £1.33       £31.92
  £2.53       £60.72
  £0.33       £3.96
  £4.83       £57.96
   £1.65        £39.60




Per Portion   Per Carton
   £1.65       £825.00
   £1.65       £825.00
   £1.10       £550.00
   £1.65       £330.00
                        Beverage Stock Take
                                      For more small business templates visit:   Spreadsheet123.com
                                                                         © 2008 Spreadsheet123.com


                                  Budget Settings
Weeks in month                                4
Forecasted Monthly Revenue
Forecasted Growth Profit %                  74%


                                            Budget
                                   Week 1         Week 2     Week 3     Week 4     Week 5
Budgeted Revenue (Less Tax/VAT)       £0.00          £0.00      £0.00      £0.00

Actual Revenue (Less Tax/VAT)         £0.00          £0.00      £0.00      £0.00

Variance                              £0.00          £0.00      £0.00      £0.00

                                       Delivery Cost
Actual Delivery Cost                  £0.00          £0.00      £0.00      £0.00

Forecasted Spending Allowance         £0.00          £0.00      £0.00      £0.00

Actual Spending Allowance             £0.00          £0.00      £0.00      £0.00

Variance                              £0.00          £0.00      £0.00      £0.00

                                     Growth Profit %
Budgeted GP %                        74.00%         74.00%     74.00%     74.00%

Actual GP %
Variance
                          Buy unlocked version!

     Spreadsheet123.com     Cost: $24.95USD
008 Spreadsheet123.com




                 £0.00
                 £0.00
                 £0.00


                 £0.00
                 £0.00
                 £0.00
                 £0.00


               74.00%
                   Beverage Stock Take
                              For more small business templates visit:    Spreadsheet123.com
                                                                  © 2008 Spreadsheet123.com


                             Stock Opening
                                               Bottles
Spirits             Bottle           Cellar     Front      Opened    Cost Of Stock
Teachers            70cl                                                 £0.00
Bells               70cl                                                 £0.00
Bells               1.5ltr                                               £0.00
Glenfiddich         75cl                                                 £0.00
Glenmorangie        70cl                                                 £0.00
Jack Daniels        70cl                                                 £0.00
Jack Daniels        1.5Ltr                                               £0.00
Jim Beam            70cl                                                 £0.00
Jameson's Irish     70cl                                                 £0.00
Jameson's Irish     1.5Ltr                                               £0.00
Southern Comfort    70cl                                                 £0.00
Southern Comfort    1.5ltr                                               £0.00
Gordons' Gin        70cl                                                 £0.00
Gordons' Gin        1.5Ltr                                               £0.00
Bombay Sapphire     70cl                                                 £0.00
Smirnoff Red        70cl                                                 £0.00
Smirnoff Red        1.5Ltr                                               £0.00
Absolut             70cl                                                 £0.00
Captain Morgan      70cl                                                 £0.00
Bacardi             70cl                                                 £0.00
Bacardi             1.5Ltr                                               £0.00
Martell ***         70cl                                                 £0.00
Martell ***         1.5Ltr                                               £0.00
Remy Martin         70cl                                                 £0.00
Baileys             70cl                                                 £0.00
Baileys             1.5Ltr                                               £0.00
Cointreau           70cl                                                 £0.00
Drambuie            70cl                                                 £0.00
Malibu              70cl                                                 £0.00
Malibu              1.5Ltr                                               £0.00
Archers             70cl                                                 £0.00
Archers             70cl                                                 £0.00
Tequila             70cl                                                 £0.00
Luxardo Sambuca     70cl                                                 £0.00
Tia Maria           70cl                                                 £0.00
Tia Maria           1.5ltr                                               £0.00
                                                 Bottles
Fortified Wines         Bottle          Cellar    Front    Opened   Cost Of Stock
Cinzano Bianco          75cl                                            £0.00
Martini Dry             75cl                                            £0.00
Martini Rosso           75cl                                            £0.00
Campari                 75cl                                            £0.00
Cockburns Ruby          75cl                                            £0.00
Bristol Cream           75cl                                            £0.00
Club Classic            75cl                                            £0.00
Harveys Dune            75cl                                            £0.00




                                                 Bottles
Table Wines             Bottle          Cellar    Front    Opened   Cost Of Stock
35º South Red           Case 12Bt                                       £0.00
Lindemans' Chardonnay   Case 6Bt                                        £0.00
Arniston Bay            Case 6Bt                                        £0.00
Côtes du Rhône          Case 12Bt                                       £0.00
Jacobs Creek            Case 12Bt Sm.                                   £0.00
Louis Raymond           Case 12Bt Sm.                                   £0.00
Castletorre             Case 12Bt Sm.                                   £0.00
Muscadet                Case 6Bt                                        £0.00
Piesporter              Case 6Bt                                        £0.00
Piesporter (Small)      Case 6Bt                                        £0.00
Pinot Grigio            Case 6Bt                                        £0.00
Faustino Crianza        Case 12Bt                                       £0.00
35º South White         Case 12Bt                                       £0.00




                                                  Kegs
Draught Beer            Keg              Full              Opened   Cost Of Stock
Boddingtons             22 Gallon                                       £0.00
Murphy's                10 Gallon                                       £0.00
                                                   Kegs
Draught Lager            Keg           Full                     Opened   Cost Of Stock
Hoegaarden               7.1 Gallon                                          £0.00
Stella Artois            22 Gallon                                           £0.00
Stella Artois            10 Gallon                                           £0.00




                                               Bottles (Each)
Bottled Beer             Bottle/Can   Cellar       Front                 Cost Of Stock
Labatt Ice               Case 24Bt                                           £0.00
Stella Artois            Case 24Bt                                           £0.00
Budweiser                Case 24Bt                                           £0.00
Becks                    Case 24Bt                                           £0.00
Old Speckled Hen         Case 12Bt                                           £0.00
Bacardi Breezer          Case 24Bt                                           £0.00
WKD Blue/Iron Brew       Case 24Bt                                           £0.00
Smirnoff Ice/Black Ice   Case 24Bt                                           £0.00




                                               Bottles (Each)
Cider                    Bottle/Can   Cellar       Front                 Cost Of Stock
Strongbow                Case 24Bt                                           £0.00
Woodpecker               Case 24Bt                                           £0.00




                                               Bottles (Each)
Minerals                 Bottle/Can   Cellar       Front                 Cost Of Stock
Britvic J20              Case 24Bt                                           £0.00
Coke/Diet Coke           Case 36Bt                                           £0.00
Fruit Juices             Case 36Bt                                           £0.00
Fruit Juices             Case 48Bt                                           £0.00
Minerals                 Case 36Bt                                           £0.00
Minerals                 Case 48Bt                                           £0.00
Tango Diet               Case 36Bt                                           £0.00
Strathmore               Case 12Bt                                           £0.00
Strathmore               Case 24Bt                                           £0.00
Red Bull                 Case 24Bt                                           £0.00
Squash/Cordial           Case 12Bt                                           £0.00
Lime Cordial            Case 12Bt                                      £0.00
Coke/Diet Coke (Cans)   Case 24Bt                                      £0.00




                                             Cartons
Post-Mix Drinks         Cartons     Cellar               Opened    Cost Of Stock
Post-Mix Pepsi/Diet     10Ltr                                          £0.00
Post-Mix Lemonade       10Ltr                                          £0.00
Post-Mix Tango          10Ltr                                          £0.00
Sprite                  5Ltr                                           £0.00




Containers                          Cellar                         Cost Of Stock
Cases                   Each                                           £0.00
Bottles - Small         Each                                           £0.00
Suregas B               Each                                           £0.00
Suremix 30/50           Each                                           £0.00




                                                Total Value of Opening Stock @ Cost Price
                                               Total Value of Opening Stock @ Retail Price
                         Buy unlocked version!

                           Cost: $24.95USD
   Spreadsheet123.com
8 Spreadsheet123.com




            Per Bottle
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
              £0.00
             Spirits
              £0.00    Cost Value
              £0.00    Retail Value

Per Bottle
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00




             Fort.
             £0.00     Cost Value
             £0.00     Retail Value

Per Case
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00




             Wine
             £0.00     Cost Value
             £0.00     Retail Value


  £0.00
  £0.00


             Beer
             £0.00     Cost Value
             £0.00    Retail Value


  £0.00
  £0.00
  £0.00
            Lager
            £0.00     Cost Value
            £0.00     Retail Value

Per Dozen
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00




            Bottled
             £0.00    Cost Value
             £0.00    Retail Value

Per Dozen
  £0.00
  £0.00




            Cider
            £0.00     Cost Value
            £0.00     Retail Value

Per Dozen
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
  £0.00
               £0.00
               £0.00




                          Mineral
                           £0.00    Cost Value
                           £0.00    Retail Value


               £0.00
               £0.00
               £0.00
               £0.00        Mix
                           £0.00    Cost Value
                           £0.00    Retail Value


               £0.00
               £0.00     Containers
               £0.00       £0.00    Cost Value
               £0.00                Retail Value



ng Stock @ Cost Price      £0.00
g Stock @ Retail Price     £0.00
                                       Beverage Stock Take
                                                                             For more small busines




                                                          Week 1
                                  Delivery          Total Stock                Weekly Stock Count
Spirits            Bottle   Delivery         Cost                 Cellar   Front
Teachers           70cl                                 0.0
Bells              70cl                                 0.0
Bells              1.5ltr                               0.0
Glenfiddich        75cl                                 0.0
Glenmorangie       70cl                                 0.0
Jack Daniels       70cl                                 0.0
Jack Daniels       1.5Ltr                               0.0
Jim Beam           70cl                                 0.0
Jameson's Irish    70cl                                 0.0
Jameson's Irish    1.5Ltr                               0.0
Southern Comfort   70cl                                 0.0
Southern Comfort   1.5ltr                               0.0
Gordons' Gin       70cl                                 0.0
Gordons' Gin       1.5Ltr                               0.0
Bombay Sapphire    70cl                                 0.0
Smirnoff Red       70cl                                 0.0
Smirnoff Red       1.5Ltr                               0.0
Absolut            70cl                                 0.0
Captain Morgan     70cl                                 0.0
Bacardi            70cl                                 0.0
Bacardi            1.5Ltr                               0.0
Martell ***        70cl                                 0.0
Martell ***        1.5Ltr                               0.0
Remy Martin        70cl                                 0.0
Baileys            70cl                                 0.0
Baileys            1.5Ltr                               0.0
Cointreau          70cl                                 0.0
Drambuie           70cl                                 0.0
Malibu             70cl                                 0.0
Malibu             1.5Ltr                               0.0
Archers            70cl                                 0.0
Archers            70cl                                 0.0
Tequila            70cl                                 0.0
Luxardo Sambuca    70cl                                 0.0
Tia Maria          70cl                                 0.0
Tia Maria          1.5ltr                               0.0
                                        0.0
Fortified Wines         Bottle                      Cellar   Front
Cinzano Bianco          75cl                  0.0
Martini Dry             75cl                  0.0
Martini Rosso           75cl                  0.0
Campari                 75cl                  0.0
Cockburns Ruby          75cl                  0.0
Bristol Cream           75cl                  0.0
Club Classic            75cl                  0.0
Harveys Dune            75cl                  0.0




                                        0.0
Table Wines             Bottle                      Cellar   Front
35º South Red           Case 12Bt             0.0
Lindemans' Chardonnay   Case 6Bt              0.0
Arniston Bay            Case 6Bt              0.0
Côtes du Rhône          Case 12Bt             0.0
Jacobs Creek            Case 12Bt Sm.         0.0
Louis Raymond           Case 12Bt Sm.         0.0
Castletorre             Case 12Bt Sm.         0.0
Muscadet                Case 6Bt              0.0
Piesporter              Case 6Bt              0.0
Piesporter (Small)      Case 6Bt              0.0
Pinot Grigio            Case 6Bt              0.0
Faustino Crianza        Case 12Bt             0.0
35º South White         Case 12Bt             0.0




                                        0.0
Draught Beer            Keg                         Cellar   Front
Boddingtons             22 Gallon             0.0
Murphy's                10 Gallon             0.0
                                      0.0
Draught Lager            Keg                      Cellar   Front
Hoegaarden               7.1 Gallon         0.0
Stella Artois            22 Gallon          0.0
Stella Artois            10 Gallon          0.0




                                      0.0
Bottled Beer             Bottle/Can               Cellar   Front
Labatt Ice               Case 24Bt          0.0
Stella Artois            Case 24Bt          0.0
Budweiser                Case 24Bt          0.0
Becks                    Case 24Bt          0.0
Old Speckled Hen         Case 12Bt          0.0
Bacardi Breezer          Case 24Bt          0.0
WKD Blue/Iron Brew       Case 24Bt          0.0
Smirnoff Ice/Black Ice   Case 24Bt          0.0




                                      0.0
Cider                    Bottle/Can               Cellar   Front
Strongbow                Case 24Bt          0.0
Woodpecker               Case 24Bt          0.0




                                      0.0
Minerals                 Bottle/Can               Cellar   Front
Britvic J20              Case 24Bt          0.0
Coke/Diet Coke           Case 36Bt          0.0
Fruit Juices             Case 36Bt          0.0
Fruit Juices             Case 48Bt          0.0
Minerals                 Case 36Bt          0.0
Minerals                 Case 48Bt          0.0
Tango Diet               Case 36Bt          0.0
Strathmore               Case 12Bt          0.0
Strathmore               Case 24Bt          0.0
Red Bull                Case 24Bt               0.0
Squash/Cordial          Case 12Bt               0.0
Lime Cordial            Case 12Bt               0.0
Coke/Diet Coke (Cans)   Case 24Bt               0.0




                                          0.0
Post-Mix Drinks         Cartons                       Cellar   Front
Post-Mix Pepsi/Diet     10Ltr                   0.0
Post-Mix Lemonade       10Ltr                   0.0
Post-Mix Tango          10Ltr                   0.0
Sprite                  5Ltr                    0.0



                                    0.0
Containers                                            Cellar   Front
Cases                   Each                    0.0
Bottles - Small         Each                    0.0
Suregas B               Each                    0.0
Suremix 30/50           Each                    0.0
                                    0.0




                                                                Total Value of Stock on
                                                               Total Value of Stock on W


                                                                  Total Weekly Sales fro
ck Take                                                          Buy unlocked version!

  For more small business templates visit:  Spreadsheet123.com     Cost: $24.95USD
                                    © 2009 Spreadsheet123.com




   Weekly Stock Count                       Retail   Value of
        Opened   Variance   Cost Of Stock   Value    Variance
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                                                        Spirits
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00



                                                        Fort.
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Wine
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                                                        Beer
                                                        £0.00     Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00    Lager
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Bottled
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Cider
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00




                                                                   Mineral
                                                                    £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00       Mix
                    0.0         £0.00        £0.00       £0.00      £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00                    £0.00    Containers
                    0.0         £0.00                    £0.00      £0.00    Cost Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value of Variance



                      Total Cost of Delivered Items                 £0.00
 Total Value of Stock on Week Closing @ Cost Price                  £0.00
Total Value of Stock on Week Closing @ Retail Price                 £0.00
             Total Value of Variance @ Retail Price                 £0.00
   Total Weekly Sales from POS Including Tax/VAT
            Total Weekly Sales Excluding Tax/VAT                    £0.00
                                Cost of Sale Margin
                                        Actual G.P.%
                                       Beverage Stock Take
                                                                             For more small busines




                                                          Week 2
                                  Delivery          Total Stock                Weekly Stock Count
Spirits            Bottle   Delivery         Cost                 Cellar   Front
Teachers           70cl                                 0.0
Bells              70cl                                 0.0
Bells              1.5ltr                               0.0
Glenfiddich        75cl                                 0.0
Glenmorangie       70cl                                 0.0
Jack Daniels       70cl                                 0.0
Jack Daniels       1.5Ltr                               0.0
Jim Beam           70cl                                 0.0
Jameson's Irish    70cl                                 0.0
Jameson's Irish    1.5Ltr                               0.0
Southern Comfort   70cl                                 0.0
Southern Comfort   1.5ltr                               0.0
Gordons' Gin       70cl                                 0.0
Gordons' Gin       1.5Ltr                               0.0
Bombay Sapphire    70cl                                 0.0
Smirnoff Red       70cl                                 0.0
Smirnoff Red       1.5Ltr                               0.0
Absolut            70cl                                 0.0
Captain Morgan     70cl                                 0.0
Bacardi            70cl                                 0.0
Bacardi            1.5Ltr                               0.0
Martell ***        70cl                                 0.0
Martell ***        1.5Ltr                               0.0
Remy Martin        70cl                                 0.0
Baileys            70cl                                 0.0
Baileys            1.5Ltr                               0.0
Cointreau          70cl                                 0.0
Drambuie           70cl                                 0.0
Malibu             70cl                                 0.0
Malibu             1.5Ltr                               0.0
Archers            70cl                                 0.0
Archers            70cl                                 0.0
Tequila            70cl                                 0.0
Luxardo Sambuca    70cl                                 0.0
Tia Maria          70cl                                 0.0
Tia Maria          1.5ltr                               0.0
                                        0.0
Fortified Wines         Bottle                      Cellar   Front
Cinzano Bianco          75cl                  0.0
Martini Dry             75cl                  0.0
Martini Rosso           75cl                  0.0
Campari                 75cl                  0.0
Cockburns Ruby          75cl                  0.0
Bristol Cream           75cl                  0.0
Club Classic            75cl                  0.0
Harveys Dune            75cl                  0.0




                                        0.0
Table Wines             Bottle                      Cellar   Front
35º South Red           Case 12Bt             0.0
Lindemans' Chardonnay   Case 6Bt              0.0
Arniston Bay            Case 6Bt              0.0
Côtes du Rhône          Case 12Bt             0.0
Jacobs Creek            Case 12Bt Sm.         0.0
Louis Raymond           Case 12Bt Sm.         0.0
Castletorre             Case 12Bt Sm.         0.0
Muscadet                Case 6Bt              0.0
Piesporter              Case 6Bt              0.0
Piesporter (Small)      Case 6Bt              0.0
Pinot Grigio            Case 6Bt              0.0
Faustino Crianza        Case 12Bt             0.0
35º South White         Case 12Bt             0.0




                                        0.0
Draught Beer            Keg                         Cellar   Front
Boddingtons             22 Gallon             0.0
Murphy's                10 Gallon             0.0
                                      0.0
Draught Lager            Keg                      Cellar   Front
Hoegaarden               7.1 Gallon         0.0
Stella Artois            22 Gallon          0.0
Stella Artois            10 Gallon          0.0




                                      0.0
Bottled Beer             Bottle/Can               Cellar   Front
Labatt Ice               Case 24Bt          0.0
Stella Artois            Case 24Bt          0.0
Budweiser                Case 24Bt          0.0
Becks                    Case 24Bt          0.0
Old Speckled Hen         Case 12Bt          0.0
Bacardi Breezer          Case 24Bt          0.0
WKD Blue/Iron Brew       Case 24Bt          0.0
Smirnoff Ice/Black Ice   Case 24Bt          0.0




                                      0.0
Cider                    Bottle/Can               Cellar   Front
Strongbow                Case 24Bt          0.0
Woodpecker               Case 24Bt          0.0




                                      0.0
Minerals                 Bottle/Can               Cellar   Front
Britvic J20              Case 24Bt          0.0
Coke/Diet Coke           Case 36Bt          0.0
Fruit Juices             Case 36Bt          0.0
Fruit Juices             Case 48Bt          0.0
Minerals                 Case 36Bt          0.0
Minerals                 Case 48Bt          0.0
Tango Diet               Case 36Bt          0.0
Strathmore               Case 12Bt          0.0
Strathmore               Case 24Bt          0.0
Red Bull                Case 24Bt               0.0
Squash/Cordial          Case 12Bt               0.0
Lime Cordial            Case 12Bt               0.0
Coke/Diet Coke (Cans)   Case 24Bt               0.0




                                          0.0
Post-Mix Drinks         Cartons                       Cellar   Front
Post-Mix Pepsi/Diet     10Ltr                   0.0
Post-Mix Lemonade       10Ltr                   0.0
Post-Mix Tango          10Ltr                   0.0
Sprite                  5Ltr                    0.0



                                    0.0
Containers                                            Cellar   Front
Cases                   Each                    0.0
Bottles - Small         Each                    0.0
Suregas B               Each                    0.0
Suremix 30/50           Each                    0.0
                                    0.0




                                                                Total Value of Stock on
                                                               Total Value of Stock on W


                                                                  Total Weekly Sales fro
ck Take                                                          Buy unlocked version!

                                                                   Cost: $24.95USD
  For more small business templates visit:  Spreadsheet123.com
                                    © 2009 Spreadsheet123.com




   Weekly Stock Count                       Retail   Value of
        Opened   Variance   Cost Of Stock   Value    Variance
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                                                        Spirits
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00



                                                        Fort.
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Wine
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                                                        Beer
                                                        £0.00     Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00    Lager
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Bottled
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Cider
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00




                                                                   Mineral
                                                                    £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00       Mix
                    0.0         £0.00        £0.00       £0.00      £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00                    £0.00    Containers
                    0.0         £0.00                    £0.00      £0.00    Cost Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value of Variance



                      Total Cost of Delivered Items                 £0.00
 Total Value of Stock on Week Closing @ Cost Price                  £0.00
Total Value of Stock on Week Closing @ Retail Price                 £0.00
             Total Value of Variance @ Retail Price                 £0.00
   Total Weekly Sales from POS Including Tax/VAT
            Total Weekly Sales Excluding Tax/VAT                    £0.00
                                Cost of Sale Margin
                                        Actual G.P.%
                                       Beverage Stock Take
                                                                             For more small busines




                                                          Week 3
                                  Delivery          Total Stock                Weekly Stock Count
Spirits            Bottle   Delivery         Cost                 Cellar   Front
Teachers           70cl                                 0.0
Bells              70cl                                 0.0
Bells              1.5ltr                               0.0
Glenfiddich        75cl                                 0.0
Glenmorangie       70cl                                 0.0
Jack Daniels       70cl                                 0.0
Jack Daniels       1.5Ltr                               0.0
Jim Beam           70cl                                 0.0
Jameson's Irish    70cl                                 0.0
Jameson's Irish    1.5Ltr                               0.0
Southern Comfort   70cl                                 0.0
Southern Comfort   1.5ltr                               0.0
Gordons' Gin       70cl                                 0.0
Gordons' Gin       1.5Ltr                               0.0
Bombay Sapphire    70cl                                 0.0
Smirnoff Red       70cl                                 0.0
Smirnoff Red       1.5Ltr                               0.0
Absolut            70cl                                 0.0
Captain Morgan     70cl                                 0.0
Bacardi            70cl                                 0.0
Bacardi            1.5Ltr                               0.0
Martell ***        70cl                                 0.0
Martell ***        1.5Ltr                               0.0
Remy Martin        70cl                                 0.0
Baileys            70cl                                 0.0
Baileys            1.5Ltr                               0.0
Cointreau          70cl                                 0.0
Drambuie           70cl                                 0.0
Malibu             70cl                                 0.0
Malibu             1.5Ltr                               0.0
Archers            70cl                                 0.0
Archers            70cl                                 0.0
Tequila            70cl                                 0.0
Luxardo Sambuca    70cl                                 0.0
Tia Maria          70cl                                 0.0
Tia Maria          1.5ltr                               0.0
                                        0.0
Fortified Wines         Bottle                      Cellar   Front
Cinzano Bianco          75cl                  0.0
Martini Dry             75cl                  0.0
Martini Rosso           75cl                  0.0
Campari                 75cl                  0.0
Cockburns Ruby          75cl                  0.0
Bristol Cream           75cl                  0.0
Club Classic            75cl                  0.0
Harveys Dune            75cl                  0.0




                                        0.0
Table Wines             Bottle                      Cellar   Front
35º South Red           Case 12Bt             0.0
Lindemans' Chardonnay   Case 6Bt              0.0
Arniston Bay            Case 6Bt              0.0
Côtes du Rhône          Case 12Bt             0.0
Jacobs Creek            Case 12Bt Sm.         0.0
Louis Raymond           Case 12Bt Sm.         0.0
Castletorre             Case 12Bt Sm.         0.0
Muscadet                Case 6Bt              0.0
Piesporter              Case 6Bt              0.0
Piesporter (Small)      Case 6Bt              0.0
Pinot Grigio            Case 6Bt              0.0
Faustino Crianza        Case 12Bt             0.0
35º South White         Case 12Bt             0.0




                                        0.0
Draught Beer            Keg                         Cellar   Front
Boddingtons             22 Gallon             0.0
Murphy's                10 Gallon             0.0
                                      0.0
Draught Lager            Keg                      Cellar   Front
Hoegaarden               7.1 Gallon         0.0
Stella Artois            22 Gallon          0.0
Stella Artois            10 Gallon          0.0




                                      0.0
Bottled Beer             Bottle/Can               Cellar   Front
Labatt Ice               Case 24Bt          0.0
Stella Artois            Case 24Bt          0.0
Budweiser                Case 24Bt          0.0
Becks                    Case 24Bt          0.0
Old Speckled Hen         Case 12Bt          0.0
Bacardi Breezer          Case 24Bt          0.0
WKD Blue/Iron Brew       Case 24Bt          0.0
Smirnoff Ice/Black Ice   Case 24Bt          0.0




                                      0.0
Cider                    Bottle/Can               Cellar   Front
Strongbow                Case 24Bt          0.0
Woodpecker               Case 24Bt          0.0




                                      0.0
Minerals                 Bottle/Can               Cellar   Front
Britvic J20              Case 24Bt          0.0
Coke/Diet Coke           Case 36Bt          0.0
Fruit Juices             Case 36Bt          0.0
Fruit Juices             Case 48Bt          0.0
Minerals                 Case 36Bt          0.0
Minerals                 Case 48Bt          0.0
Tango Diet               Case 36Bt          0.0
Strathmore               Case 12Bt          0.0
Strathmore               Case 24Bt          0.0
Red Bull                Case 24Bt               0.0
Squash/Cordial          Case 12Bt               0.0
Lime Cordial            Case 12Bt               0.0
Coke/Diet Coke (Cans)   Case 24Bt               0.0




                                          0.0
Post-Mix Drinks         Cartons                       Cellar   Front
Post-Mix Pepsi/Diet     10Ltr                   0.0
Post-Mix Lemonade       10Ltr                   0.0
Post-Mix Tango          10Ltr                   0.0
Sprite                  5Ltr                    0.0



                                    0.0
Containers                                            Cellar   Front
Cases                   Each                    0.0
Bottles - Small         Each                    0.0
Suregas B               Each                    0.0
Suremix 30/50           Each                    0.0
                                    0.0




                                                                Total Value of Stock on
                                                               Total Value of Stock on W


                                                                  Total Weekly Sales fro
ck Take                                                          Buy unlocked version!

                                                                   Cost: $24.95USD
  For more small business templates visit:  Spreadsheet123.com
                                    © 2009 Spreadsheet123.com




   Weekly Stock Count                       Retail   Value of
        Opened   Variance   Cost Of Stock   Value    Variance
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                                                        Spirits
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00



                                                        Fort.
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Wine
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                                                        Beer
                                                        £0.00     Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00    Lager
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Bottled
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Cider
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00




                                                                   Mineral
                                                                    £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00       Mix
                    0.0         £0.00        £0.00       £0.00      £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00                    £0.00    Containers
                    0.0         £0.00                    £0.00      £0.00    Cost Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value of Variance



                      Total Cost of Delivered Items                 £0.00
 Total Value of Stock on Week Closing @ Cost Price                  £0.00
Total Value of Stock on Week Closing @ Retail Price                 £0.00
             Total Value of Variance @ Retail Price                 £0.00
   Total Weekly Sales from POS Including Tax/VAT
            Total Weekly Sales Excluding Tax/VAT                    £0.00
                                Cost of Sale Margin
                                        Actual G.P.%
                                       Beverage Stock Take
                                                                             For more small busines




                                                          Week 4
                                  Delivery          Total Stock                Weekly Stock Count
Spirits            Bottle   Delivery         Cost                 Cellar   Front
Teachers           70cl                                 0.0
Bells              70cl                                 0.0
Bells              1.5ltr                               0.0
Glenfiddich        75cl                                 0.0
Glenmorangie       70cl                                 0.0
Jack Daniels       70cl                                 0.0
Jack Daniels       1.5Ltr                               0.0
Jim Beam           70cl                                 0.0
Jameson's Irish    70cl                                 0.0
Jameson's Irish    1.5Ltr                               0.0
Southern Comfort   70cl                                 0.0
Southern Comfort   1.5ltr                               0.0
Gordons' Gin       70cl                                 0.0
Gordons' Gin       1.5Ltr                               0.0
Bombay Sapphire    70cl                                 0.0
Smirnoff Red       70cl                                 0.0
Smirnoff Red       1.5Ltr                               0.0
Absolut            70cl                                 0.0
Captain Morgan     70cl                                 0.0
Bacardi            70cl                                 0.0
Bacardi            1.5Ltr                               0.0
Martell ***        70cl                                 0.0
Martell ***        1.5Ltr                               0.0
Remy Martin        70cl                                 0.0
Baileys            70cl                                 0.0
Baileys            1.5Ltr                               0.0
Cointreau          70cl                                 0.0
Drambuie           70cl                                 0.0
Malibu             70cl                                 0.0
Malibu             1.5Ltr                               0.0
Archers            70cl                                 0.0
Archers            70cl                                 0.0
Tequila            70cl                                 0.0
Luxardo Sambuca    70cl                                 0.0
Tia Maria          70cl                                 0.0
Tia Maria          1.5ltr                               0.0
                                        0.0
Fortified Wines         Bottle                      Cellar   Front
Cinzano Bianco          75cl                  0.0
Martini Dry             75cl                  0.0
Martini Rosso           75cl                  0.0
Campari                 75cl                  0.0
Cockburns Ruby          75cl                  0.0
Bristol Cream           75cl                  0.0
Club Classic            75cl                  0.0
Harveys Dune            75cl                  0.0




                                        0.0
Table Wines             Bottle                      Cellar   Front
35º South Red           Case 12Bt             0.0
Lindemans' Chardonnay   Case 6Bt              0.0
Arniston Bay            Case 6Bt              0.0
Côtes du Rhône          Case 12Bt             0.0
Jacobs Creek            Case 12Bt Sm.         0.0
Louis Raymond           Case 12Bt Sm.         0.0
Castletorre             Case 12Bt Sm.         0.0
Muscadet                Case 6Bt              0.0
Piesporter              Case 6Bt              0.0
Piesporter (Small)      Case 6Bt              0.0
Pinot Grigio            Case 6Bt              0.0
Faustino Crianza        Case 12Bt             0.0
35º South White         Case 12Bt             0.0




                                        0.0
Draught Beer            Keg                         Cellar   Front
Boddingtons             22 Gallon             0.0
Murphy's                10 Gallon             0.0
                                      0.0
Draught Lager            Keg                      Cellar   Front
Hoegaarden               7.1 Gallon         0.0
Stella Artois            22 Gallon          0.0
Stella Artois            10 Gallon          0.0




                                      0.0
Bottled Beer             Bottle/Can               Cellar   Front
Labatt Ice               Case 24Bt          0.0
Stella Artois            Case 24Bt          0.0
Budweiser                Case 24Bt          0.0
Becks                    Case 24Bt          0.0
Old Speckled Hen         Case 12Bt          0.0
Bacardi Breezer          Case 24Bt          0.0
WKD Blue/Iron Brew       Case 24Bt          0.0
Smirnoff Ice/Black Ice   Case 24Bt          0.0




                                      0.0
Cider                    Bottle/Can               Cellar   Front
Strongbow                Case 24Bt          0.0
Woodpecker               Case 24Bt          0.0




                                      0.0
Minerals                 Bottle/Can               Cellar   Front
Britvic J20              Case 24Bt          0.0
Coke/Diet Coke           Case 36Bt          0.0
Fruit Juices             Case 36Bt          0.0
Fruit Juices             Case 48Bt          0.0
Minerals                 Case 36Bt          0.0
Minerals                 Case 48Bt          0.0
Tango Diet               Case 36Bt          0.0
Strathmore               Case 12Bt          0.0
Strathmore               Case 24Bt          0.0
Red Bull                Case 24Bt               0.0
Squash/Cordial          Case 12Bt               0.0
Lime Cordial            Case 12Bt               0.0
Coke/Diet Coke (Cans)   Case 24Bt               0.0




                                          0.0
Post-Mix Drinks         Cartons                       Cellar   Front
Post-Mix Pepsi/Diet     10Ltr                   0.0
Post-Mix Lemonade       10Ltr                   0.0
Post-Mix Tango          10Ltr                   0.0
Sprite                  5Ltr                    0.0



                                    0.0
Containers                                            Cellar   Front
Cases                   Each                    0.0
Bottles - Small         Each                    0.0
Suregas B               Each                    0.0
Suremix 30/50           Each                    0.0
                                    0.0




                                                                Total Value of Stock on
                                                               Total Value of Stock on W


                                                                  Total Weekly Sales fro
ck Take                                                          Buy unlocked version!

                                                                   Cost: $24.95USD
  For more small business templates visit:  Spreadsheet123.com
                                    © 2009 Spreadsheet123.com




   Weekly Stock Count                       Retail   Value of
        Opened   Variance   Cost Of Stock   Value    Variance
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                   0.0          £0.00        £0.00     £0.00
                                                        Spirits
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00



                                                        Fort.
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Wine
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                                                        Beer
                                                        £0.00     Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00    Lager
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Bottled
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Cider
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00




                                                                   Mineral
                                                                    £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00
                    0.0         £0.00        £0.00       £0.00       Mix
                    0.0         £0.00        £0.00       £0.00      £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                    0.0         £0.00                    £0.00    Containers
                    0.0         £0.00                    £0.00      £0.00    Cost Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value
                    0.0         £0.00                    £0.00      £0.00    Retail Value of Variance



                      Total Cost of Delivered Items                 £0.00
 Total Value of Stock on Week Closing @ Cost Price                  £0.00
Total Value of Stock on Week Closing @ Retail Price                 £0.00
             Total Value of Variance @ Retail Price                 £0.00
   Total Weekly Sales from POS Including Tax/VAT
            Total Weekly Sales Excluding Tax/VAT                    £0.00
                                Cost of Sale Margin
                                        Actual G.P.%
                                       Beverage Stock Take
                                                                             For more small busines




                                                          Week 5
                                  Delivery          Total Stock                Weekly Stock Count
Spirits            Bottle   Delivery         Cost                 Cellar   Front
Teachers           70cl
Bells              70cl
Bells              1.5ltr
Glenfiddich        75cl
Glenmorangie       70cl
Jack Daniels       70cl
Jack Daniels       1.5Ltr
Jim Beam           70cl
Jameson's Irish    70cl
Jameson's Irish    1.5Ltr
Southern Comfort   70cl
Southern Comfort   1.5ltr
Gordons' Gin       70cl
Gordons' Gin       1.5Ltr
Bombay Sapphire    70cl
Smirnoff Red       70cl
Smirnoff Red       1.5Ltr
Absolut            70cl
Captain Morgan     70cl
Bacardi            70cl
Bacardi            1.5Ltr
Martell ***        70cl
Martell ***        1.5Ltr
Remy Martin        70cl
Baileys            70cl
Baileys            1.5Ltr
Cointreau          70cl
Drambuie           70cl
Malibu             70cl
Malibu             1.5Ltr
Archers            70cl
Archers            70cl
Tequila            70cl
Luxardo Sambuca    70cl
Tia Maria          70cl
Tia Maria          1.5ltr
                                        0.0
Fortified Wines         Bottle                Cellar   Front
Cinzano Bianco          75cl
Martini Dry             75cl
Martini Rosso           75cl
Campari                 75cl
Cockburns Ruby          75cl
Bristol Cream           75cl
Club Classic            75cl
Harveys Dune            75cl




                                        0.0
Table Wines             Bottle                Cellar   Front
35º South Red           Case 12Bt
Lindemans' Chardonnay   Case 6Bt
Arniston Bay            Case 6Bt
Côtes du Rhône          Case 12Bt
Jacobs Creek            Case 12Bt Sm.
Louis Raymond           Case 12Bt Sm.
Castletorre             Case 12Bt Sm.
Muscadet                Case 6Bt
Piesporter              Case 6Bt
Piesporter (Small)      Case 6Bt
Pinot Grigio            Case 6Bt
Faustino Crianza        Case 12Bt
35º South White         Case 12Bt




                                        0.0
Draught Beer            Keg                   Cellar   Front
Boddingtons             22 Gallon
Murphy's                10 Gallon
                                      0.0
Draught Lager            Keg                Cellar   Front
Hoegaarden               7.1 Gallon
Stella Artois            22 Gallon
Stella Artois            10 Gallon




                                      0.0
Bottled Beer             Bottle/Can         Cellar   Front
Labatt Ice               Case 24Bt
Stella Artois            Case 24Bt
Budweiser                Case 24Bt
Becks                    Case 24Bt
Old Speckled Hen         Case 12Bt
Bacardi Breezer          Case 24Bt
WKD Blue/Iron Brew       Case 24Bt
Smirnoff Ice/Black Ice   Case 24Bt




                                      0.0
Cider                    Bottle/Can         Cellar   Front
Strongbow                Case 24Bt
Woodpecker               Case 24Bt




                                      0.0
Minerals                 Bottle/Can         Cellar   Front
Britvic J20              Case 24Bt
Coke/Diet Coke           Case 36Bt
Fruit Juices             Case 36Bt
Fruit Juices             Case 48Bt
Minerals                 Case 36Bt
Minerals                 Case 48Bt
Tango Diet               Case 36Bt
Strathmore               Case 12Bt
Strathmore               Case 24Bt
Red Bull                Case 24Bt
Squash/Cordial          Case 12Bt
Lime Cordial            Case 12Bt
Coke/Diet Coke (Cans)   Case 24Bt




                                          0.0
Post-Mix Drinks         Cartons                 Cellar   Front
Post-Mix Pepsi/Diet     10Ltr
Post-Mix Lemonade       10Ltr
Post-Mix Tango          10Ltr
Sprite                  5Ltr



                                    0.0
Containers                                      Cellar   Front
Cases                   Each
Bottles - Small         Each
Suregas B               Each
Suremix 30/50           Each
                                    0.0




                                                          Total Value of Stock on
                                                         Total Value of Stock on W


                                                            Total Weekly Sales fro
ck Take                                                          Buy unlocked version!

  For more small business templates visit:  Spreadsheet123.com     Cost: $24.95USD
                                    © 2009 Spreadsheet123.com




   Weekly Stock Count                       Retail   Value of
        Opened   Variance   Cost Of Stock   Value    Variance
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                                        Spirits
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00



                                                        Fort.
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00




                                                        Wine
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00
                                                        Beer
                                                        £0.00     Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00              Lager
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00




                                                        Bottled
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00




                                                        Cider
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                        £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00




                                                                   Mineral
                                                                    £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                                £0.00        £0.00
                                £0.00        £0.00
                                £0.00        £0.00                   Mix
                                £0.00        £0.00                  £0.00    Cost Value
                                                                    £0.00    Retail Value
                                                                    £0.00    Retail Value of Variance
                                            Retail     Value of
        Opened   Variance   Cost Of Stock    Value     Variance
                                £0.00                             Containers
                                £0.00                               £0.00    Cost Value
                                £0.00                               £0.00    Retail Value
                                £0.00                               £0.00    Retail Value of Variance



                      Total Cost of Delivered Items
 Total Value of Stock on Week Closing @ Cost Price
Total Value of Stock on Week Closing @ Retail Price
             Total Value of Variance @ Retail Price
   Total Weekly Sales from POS Including Tax/VAT
            Total Weekly Sales Excluding Tax/VAT
                                Cost of Sale Margin
                                        Actual G.P.%
                                         Beverage Stock Take
                                                                                 For more small busines




                                                        Stock Closing
                            Open Stock       Delivery   Total Stock            End of the Month Stock C
Spirits            Bottle                                             Cellar   Front
Teachers           70cl                  0     0.0          0.0
Bells              70cl                  0     0.0          0.0
Bells              1.5ltr                0     0.0          0.0
Glenfiddich        75cl                  0     0.0          0.0
Glenmorangie       70cl                  0     0.0          0.0
Jack Daniels       70cl                  0     0.0          0.0
Jack Daniels       1.5Ltr                0     0.0          0.0
Jim Beam           70cl                  0     0.0          0.0
Jameson's Irish    70cl                  0     0.0          0.0
Jameson's Irish    1.5Ltr                0     0.0          0.0
Southern Comfort   70cl                  0     0.0          0.0
Southern Comfort   1.5ltr                0     0.0          0.0
Gordons' Gin       70cl                  0     0.0          0.0
Gordons' Gin       1.5Ltr                0     0.0          0.0
Bombay Sapphire    70cl                  0     0.0          0.0
Smirnoff Red       70cl                  0     0.0          0.0
Smirnoff Red       1.5Ltr                0     0.0          0.0
Absolut            70cl                  0     0.0          0.0
Captain Morgan     70cl                  0     0.0          0.0
Bacardi            70cl                  0     0.0          0.0
Bacardi            1.5Ltr                0     0.0          0.0
Martell ***        70cl                  0     0.0          0.0
Martell ***        1.5Ltr                0     0.0          0.0
Remy Martin        70cl                  0     0.0          0.0
Baileys            70cl                  0     0.0          0.0
Baileys            1.5Ltr                0     0.0          0.0
Cointreau          70cl                  0     0.0          0.0
Drambuie           70cl                  0     0.0          0.0
Malibu             70cl                  0     0.0          0.0
Malibu             1.5Ltr                0     0.0          0.0
Archers            70cl                  0     0.0          0.0
Archers            70cl                  0     0.0          0.0
Tequila            70cl                  0     0.0          0.0
Luxardo Sambuca    70cl                  0     0.0          0.0
Tia Maria          70cl                  0     0.0          0.0
Tia Maria          1.5ltr                0     0.0          0.0
Fortified Wines         Bottle                          Cellar   Front
Cinzano Bianco          75cl            0   0.0   0.0
Martini Dry             75cl            0   0.0   0.0
Martini Rosso           75cl            0   0.0   0.0
Campari                 75cl            0   0.0   0.0
Cockburns Ruby          75cl            0   0.0   0.0
Bristol Cream           75cl            0   0.0   0.0
Club Classic            75cl            0   0.0   0.0
Harveys Dune            75cl            0   0.0   0.0




Table Wines             Bottle                          Cellar   Front
35º South Red           Case 12Bt       0   0.0   0.0
Lindemans' Chardonnay   Case 6Bt        0   0.0   0.0
Arniston Bay            Case 6Bt        0   0.0   0.0
Côtes du Rhône          Case 12Bt       0   0.0   0.0
Jacobs Creek            Case 12Bt Sm.   0   0.0   0.0
Louis Raymond           Case 12Bt Sm.   0   0.0   0.0
Castletorre             Case 12Bt Sm.   0   0.0   0.0
Muscadet                Case 6Bt        0   0.0   0.0
Piesporter              Case 6Bt        0   0.0   0.0
Piesporter (Small)      Case 6Bt        0   0.0   0.0
Pinot Grigio            Case 6Bt        0   0.0   0.0
Faustino Crianza        Case 12Bt       0   0.0   0.0
35º South White         Case 12Bt       0   0.0   0.0




Draught Beer            Keg                             Cellar   Front
Boddingtons             22 Gallon       0   0.0   0.0
Murphy's                10 Gallon       0   0.0   0.0
Draught Lager            Keg                          Cellar   Front
Hoegaarden               7.1 Gallon   0   0.0   0.0
Stella Artois            22 Gallon    0   0.0   0.0
Stella Artois            10 Gallon    0   0.0   0.0




Bottled Beer             Bottle/Can                   Cellar   Front
Labatt Ice               Case 24Bt    0   0.0   0.0
Stella Artois            Case 24Bt    0   0.0   0.0
Budweiser                Case 24Bt    0   0.0   0.0
Becks                    Case 24Bt    0   0.0   0.0
Old Speckled Hen         Case 12Bt    0   0.0   0.0
Bacardi Breezer          Case 24Bt    0   0.0   0.0
WKD Blue/Iron Brew       Case 24Bt    0   0.0   0.0
Smirnoff Ice/Black Ice   Case 24Bt    0   0.0   0.0




Cider                    Bottle/Can                   Cellar   Front
Strongbow                Case 24Bt    0   0.0   0.0
Woodpecker               Case 24Bt    0   0.0   0.0




Minerals                 Bottle/Can                   Cellar   Front
Britvic J20              Case 24Bt    0   0.0   0.0
Coke/Diet Coke           Case 36Bt    0   0.0   0.0
Fruit Juices             Case 36Bt    0   0.0   0.0
Fruit Juices             Case 48Bt    0   0.0   0.0
Minerals                 Case 36Bt    0   0.0   0.0
Minerals                 Case 48Bt    0   0.0   0.0
Tango Diet               Case 36Bt    0   0.0   0.0
Strathmore               Case 12Bt    0   0.0   0.0
Strathmore               Case 24Bt    0   0.0   0.0
Red Bull                Case 24Bt   0   0.0   0.0
Squash/Cordial          Case 12Bt   0   0.0   0.0
Lime Cordial            Case 12Bt   0   0.0   0.0
Coke/Diet Coke (Cans)   Case 24Bt   0   0.0   0.0




Post-Mix Drinks         Cartons                     Cellar   Front
Post-Mix Pepsi/Diet     10Ltr       0   0.0   0.0
Post-Mix Lemonade       10Ltr       0   0.0   0.0
Post-Mix Tango          10Ltr       0   0.0   0.0
Sprite                  5Ltr        0   0.0   0.0




Containers                                          Cellar   Front
Cases                   Each        0   0.0   0.0
Bottles - Small         Each        0   0.0   0.0
Suregas B               Each        0   0.0   0.0
Suremix 30/50           Each        0   0.0   0.0




                                                              Total Value of Stock on
                                                             Total Value of Stock on M


                                                                Total Monthly Sales fr
ck Take                                                              Buy unlocked version!

      For more small business templates visit:  Spreadsheet123.com     Cost: $24.95USD
                                        © 2009 Spreadsheet123.com


ing
 End of the Month Stock Count                   Retail   Value of
            Opened   Variance   Cost Of Stock   Value    Variance
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                       0.0          £0.00        £0.00     £0.00
                                                        Spirits
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00



                                                        Fort.
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Wine
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                                                        Beer
                                                        £0.00     Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00    Lager
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Bottled
                                                         £0.00    Cost Value
                                                         £0.00    Retail Value
                                                         £0.00    Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00




                                                        Cider
                                                        £0.00     Cost Value
                                                        £0.00     Retail Value
                                                        £0.00     Retail Value of Variance
                                    Retail   Value of
Opened   Variance   Cost Of Stock   Value    Variance
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
           0.0          £0.00        £0.00     £0.00
                     0.0         £0.00        £0.00       £0.00
                     0.0         £0.00        £0.00       £0.00
                     0.0         £0.00        £0.00       £0.00
                     0.0         £0.00        £0.00       £0.00




                                                                    Mineral
                                                                     £0.00    Cost Value
                                                                     £0.00    Retail Value
                                                                     £0.00    Retail Value of Variance
                                             Retail     Value of
         Opened   Variance   Cost Of Stock    Value     Variance
                     0.0         £0.00        £0.00       £0.00
                     0.0         £0.00        £0.00       £0.00
                     0.0         £0.00        £0.00       £0.00       Mix
                     0.0         £0.00        £0.00       £0.00      £0.00    Cost Value
                                                                     £0.00    Retail Value
                                                                     £0.00    Retail Value of Variance
                                             Retail     Value of
         Opened   Variance   Cost Of Stock    Value     Variance
                     0.0         £0.00                    £0.00    Containers
                     0.0         £0.00                    £0.00      £0.00    Cost Value
                     0.0         £0.00                    £0.00      £0.00    Retail Value
                     0.0         £0.00                    £0.00      £0.00    Retail Value of Variance



 Total Value of Stock on Month Closing @ Cost Price                  £0.00
Total Value of Stock on Month Closing @ Retail Price                 £0.00
              Total Value of Variance @ Retail Price                 £0.00
   Total Monthly Sales from POS Including Tax/VAT                    £0.00
            Total Monthly Sales Excluding Tax/VAT
                                 Cost of Sale Margin
                                         Actual G.P.%
                          Beverage Stock Take
                                             For more small business templates visit: Spreadsheet123.com
                                                                              © 2009 Spreadsheet123.com


                               End of the Month Total
Actual Revenue                                                           £0.00

Actual Revenue (Less Tax/VAT)

Actual Delivery Cost                                                     £0.00

Total Value of Stock on Month Opening @ Cost Price                       £0.00

Total Value of Stock on Month Closing @ Cost Price                       £0.00

Growth Profit %

Variance vs. Budgeted GP%

Variance vs. Forecasted Cost                                             £0.00

Variance vs. Actual Revenue (Less Tax/VAT)                               £0.00

Total Value of Stock Loss @ Retail Price                                 £0.00
        Buy unlocked version!

3.com     Cost: $24.95USD
3.com
                                                       Beverage Stock Tak

                                                                 Key Lines Checklist
                                  Week 1                  Week 2                  Week 3
Spirits            Bottle   25ml Shots   Variance   25ml Shots   Variance   25ml Shots
Teachers           70cl                    0.0                     0.0
Bells              70cl                    0.0                     0.0
Bells              1.5ltr                  0.0                     0.0
Glenfiddich        75cl                    0.0                     0.0
Glenmorangie       70cl                    0.0                     0.0
Jack Daniels       70cl                    0.0                     0.0
Jack Daniels       1.5Ltr                  0.0                     0.0
Jim Beam           70cl                    0.0                     0.0
Jameson's Irish    70cl                    0.0                     0.0
Jameson's Irish    1.5Ltr                  0.0                     0.0
Southern Comfort   70cl                    0.0                     0.0
Southern Comfort   1.5ltr                  0.0                     0.0
Gordons' Gin       70cl                    0.0                     0.0
Gordons' Gin       1.5Ltr                  0.0                     0.0
Bombay Sapphire    70cl                    0.0                     0.0
Smirnoff Red       70cl                    0.0                     0.0
Smirnoff Red       1.5Ltr                  0.0                     0.0
Absolut            70cl                    0.0                     0.0
Captain Morgan     70cl                    0.0                     0.0
Bacardi            70cl                    0.0                     0.0
Bacardi            1.5Ltr                  0.0                     0.0
Martell ***        70cl                    0.0                     0.0
Martell ***        1.5Ltr                  0.0                     0.0
Remy Martin        70cl                    0.0                     0.0
Baileys            70cl                    0.0                     0.0
Baileys            1.5Ltr                  0.0                     0.0
Cointreau          70cl                    0.0                     0.0
Drambuie           70cl                    0.0                     0.0
Malibu             70cl                    0.0                     0.0
Malibu             1.5Ltr                  0.0                     0.0
Archers            70cl                    0.0                     0.0
Archers            70cl                    0.0                     0.0
Tequila            70cl                    0.0                     0.0
Luxardo Sambuca    70cl                    0.0                     0.0
Tia Maria          70cl                    0.0                     0.0
Tia Maria          1.5ltr                  0.0                     0.0
Fortified Wines         Bottle          50ml Shots         50ml Shots         50ml Shots
Cinzano Bianco          75cl                         0.0                0.0
Martini Dry             75cl                         0.0                0.0
Martini Rosso           75cl                         0.0                0.0
Campari                 75cl                         0.0                0.0
Cockburns Ruby          75cl                         0.0                0.0
Bristol Cream           75cl                         0.0                0.0
Club Classic            75cl                         0.0                0.0
Harveys Dune            75cl                         0.0                0.0




Table Wines             Bottle          Per Bottle         Per Bottle         Per Bottle
35º South Red           Case 12Bt                    0.0                0.0
Lindemans' Chardonnay   Case 6Bt                     0.0                0.0
Arniston Bay            Case 6Bt                     0.0                0.0
Côtes du Rhône          Case 12Bt                    0.0                0.0
Jacobs Creek            Case 12Bt Sm.                0.0                0.0
Louis Raymond           Case 12Bt Sm.                0.0                0.0
Castletorre             Case 12Bt Sm.                0.0                0.0
Muscadet                Case 6Bt                     0.0                0.0
Piesporter              Case 6Bt                     0.0                0.0
Piesporter (Small)      Case 6Bt                     0.0                0.0
Pinot Grigio            Case 6Bt                     0.0                0.0
Faustino Crianza        Case 12Bt                    0.0                0.0
35º South White         Case 12Bt                    0.0                0.0




Draught Beer            Keg              Per Pint           Per Pint           Per Pint
Boddingtons             22 Gallon                    0.0                0.0
Murphy's                10 Gallon                    0.0                0.0
Draught Lager            Keg           Per Pint           Per Pint           Per Pint
Hoegaarden               7.1 Gallon                0.0                0.0
Stella Artois            22 Gallon                 0.0                0.0
Stella Artois            10 Gallon                 0.0                0.0




Bottled Beer             Bottle/Can   Per Bottle         Per Bottle         Per Bottle
Labatt Ice               Case 24Bt                 0.0                0.0
Stella Artois            Case 24Bt                 0.0                0.0
Budweiser                Case 24Bt                 0.0                0.0
Becks                    Case 24Bt                 0.0                0.0
Old Speckled Hen         Case 12Bt                 0.0                0.0
Bacardi Breezer          Case 24Bt                 0.0                0.0
WKD Blue/Iron Brew       Case 24Bt                 0.0                0.0
Smirnoff Ice/Black Ice   Case 24Bt                 0.0                0.0




Cider                    Bottle/Can   Per Bottle         Per Bottle         Per Bottle
Strongbow                Case 24Bt                 0.0                0.0
Woodpecker               Case 24Bt                 0.0                0.0




Minerals                 Bottle/Can   Per Bottle         Per Bottle         Per Bottle
Britvic J20              Case 24Bt                 0.0                0.0
Coke/Diet Coke           Case 36Bt                 0.0                0.0
Fruit Juices             Case 36Bt                 0.0                0.0
Fruit Juices             Case 48Bt                 0.0                0.0
Minerals                 Case 36Bt                 0.0                0.0
Minerals                 Case 48Bt                 0.0                0.0
Tango Diet               Case 36Bt                 0.0                0.0
Strathmore               Case 12Bt                 0.0                0.0
Strathmore               Case 24Bt                 0.0                0.0
Red Bull                 Case 24Bt                 0.0                0.0
Squash/Cordial           Case 12Bt                 0.0                0.0
Lime Cordial            Case 12Bt               0.0               0.0
Coke/Diet Coke (Cans)   Case 24Bt               0.0               0.0




Post-Mix Drinks         Cartons     Per Glass         Per Glass         Per Glass
Post-Mix Pepsi/Diet     10Ltr                   0.0               0.0
Post-Mix Lemonade       10Ltr                   0.0               0.0
Post-Mix Tango          10Ltr                   0.0               0.0
Sprite                  5Ltr                    0.0               0.0
ge Stock Take
                                   For more small business templates visit: Spreadsheet123.com
                                                                   © 2009 Spreadsheet123.com


Lines Checklist
    Week 3               Week 4                  Week 5                     End of the Month
        Variance   25ml Shots   Variance   25ml Shots   Variance   25ml Shots   Variance   Retail
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
             0.0                  0.0                                 0.0         0.0      £0.00
      50ml Shots         50ml Shots   50ml Shots
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00




      Per Bottle         Per Bottle   Per Bottle
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00




       Per Pint           Per Pint     Per Pint
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
       Per Pint           Per Pint     Per Pint
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00




      Per Bottle         Per Bottle   Per Bottle
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00




      Per Bottle         Per Bottle   Per Bottle
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00




      Per Bottle         Per Bottle   Per Bottle
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0                0.0                   0.0       0.0   £0.00
0.0               0.0                              0.0      0.0      £0.00
0.0               0.0                              0.0      0.0      £0.00




      Per Glass         Per Glass               Per Glass
0.0               0.0                              0.0      0.0      £0.00
0.0               0.0                              0.0      0.0      £0.00
0.0               0.0                              0.0      0.0      £0.00
0.0               0.0                              0.0      0.0      £0.00




                                    Total Value of Stock Loss @ Retail Price
             Buy unlocked version!

eet123.com     Cost: $24.95USD
 et123.com
£0.00
                                                 Buy unlocked version!
Tax/VAT
VAT                          17.50%      1.175     Cost: $24.95USD



Units Of Measure
Spirits                          25 ml
Fortified Wines                  50 ml



Spirits
Bottle Size         70cl                  700
Bottle Size         75cl                  750
Bottle Size         1.5Ltr               1500
Fortified Wines
Bottle Size         70cl                  700
Bottle Size         75cl                  750
Bottle Size         1.5Ltr               1500
Table Wines
Bottle Size 750ml   Case 12Bt
Bottle Size 750ml   Case 6Bt             750ml
Bottle Size 375ml   Case 12Bt Sm.        375ml
Bottle Size 375ml   Case 24Bt Sm.
Draught Beer
22 Gallon Keg       22 Gallon               22
10 Gallon Keg       10 Gallon               10
4 Gallon Keg        7.1 Gallon             7.1
Draught Lager
22 Gallon Keg       22 Gallon               22
10 Gallon Keg       10 Gallon               10
4 Gallon Keg        7.1 Gallon             7.1
Bottled Beer
Case 12Bt           500ml                  12
Case 24Bt           330ml                  24
                    275ml
Cider
Case 12Bt           500ml                  12
Case 24Bt           330ml                  24
                    275ml
Minerals
Case 12Bt           2Ltr                   12
Case 24Bt           1.5Ltr                 24
Case 36Bt           1Ltr                   36
Case 48Bt           330ml                  48
                    275ml
                    250ml
                  180ml
                  113ml
Post-Mix Drinks
5Ltr Cartons      5Ltr     5000
10Ltr Cartons     10Ltr   10000
                   END-USER LICENSE AGREEMENT
                                                            For more small business templates visit:
                                                                                                    © 2009 Spreadsheet123.com




IMPORTANT—READ CAREFULLY:
This End-User License Agreement (”EULA”) is a legal agreement between you and Spreadsheet123.com that
covers all Microsoft Excel and OpenOffice.org templates or spreadsheets (”TEMPLATES”) made by Spreadsheet123.com.

By downloading, copying, accessing or otherwise using any TEMPLATES, you agree to be bound by the terms
of this EULA.

TEMPLATES LICENSE

This TEMPLATE is protected by copyright laws and international copyright treaties, as well as other intellectual
property laws and treaties. Each TEMPLATE is licensed, not sold.

1. GRANT OF LICENSE.
This EULA grants you the right to download the TEMPLATES free of charge for personal use or for your company use.
You may customize this Beverage Stock Take Template with you personal or company information and use it for
calculations but you may not remove or alter any logo, trademark, copyright, hyperlinks, disclaimers, terms of use,
or other proprietary notices within the TEMPLATES.
You may not sell, resell, license, rent, lease, lend, or place on the public server (Internet) or otherwise transfer for value
without written permission of SPREADSHEET123.COM

2. TERMINATION.
Without prejudice to any other rights, Spreadsheet123.com may terminate this EULA if you fail to comply with the
terms and conditions of this EULA. In such event, you must destroy all copies of any TEMPLATE.

3. NOTICE SPECIFIC TO TEMPLATES.
SPREADSHEET123.COM MAKE NO REPRESENTATIONS
ABOUT THE SUITABILITY OF THE TEMPLATES FOR ANY PURPOSE. ALL TEMPLATES ARE PROVIDED
 “AS IS” WITHOUT WARRANTY OF ANY KIND. SPREADSHEET123.COM HEREBY DISCLAIM ALL
WARRANTIES AND CONDITIONS WITH REGARD TO THE TEMPLATES, INCLUDING ALL IMPLIED
WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE
AND NON-INFRINGEMENT. IN NO EVENT SHALL SPREADSHEET123.COM BE LIABLE FOR ANY SPECIAL,
INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS
OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS

4. MISCELLANEOUS.
Some states do not allow the limitation or exclusion of liability for incidental or consequential
damages, so the above limitation may not apply to you.
REEMENT                                  Buy unlocked version!
                    Spreadsheet123.com
             © 2009 Spreadsheet123.com     Cost: $24.95USD




preadsheet123.com that
 ES”) made by Spreadsheet123.com.

 o be bound by the terms




 well as other intellectual




onal use or for your company use.
any information and use it for
 s, disclaimers, terms of use,

et) or otherwise transfer for value




f you fail to comply with the
EMPLATE.




LATES ARE PROVIDED
 DISCLAIM ALL
 NG ALL IMPLIED
TICULAR PURPOSE, TITLE
ABLE FOR ANY SPECIAL,
RESULTING FROM LOSS
 ENCE OR OTHER TORTIOUS


uential

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:22
posted:6/21/2012
language:English
pages:85
Mleek rafat Mleek rafat Mr
About like all Hr&finance formes