22 hotel stores inventory

8/10/2019 22 Hotel Stores Inventory

1/75

Data input only in columns with headings marked to color

No input of data, amounts are derived by formulae

Statement showing Earnings for the month of April-09

Particulars Total Veg. Non-Veg.

Gross Sales 1,251 1,251 - Sales amount will be populated

Less VAT 58 58 -

Net Sales 1,193 1,193 -

Opening Stock -

Add Purchases

S420 #REF! Amounts for these purchase cat

Chicken #REF!

Coal, Fuel & Gas #REF!

Colddrinks #REF!

Dairy Products #REF!

Egg, Fish & Prowns #REF!

Groceries #REF!

Ice-Cream #REF!

Milk Products #REF!

Mutton #REF!

Vegetables #REF!

Water #REF!

Less Closing Stock -

Consumption for the month #REF!

Gross Margin #REF!

Gross Margin % to net sales #REF!


2/75

once daily sales are entered in Daily Sales sheet.

egories will be populated once entries are made in vendor invoices sheet.


3/75

Hotel Soul Curry

Daily Sales Statement for the Month of: April-09

Data input only in columns with headings marked to color

No input of data, amounts are derived by formulae

Date

Ground Party Veg. Sales

Second /

Non-Veg. Total

Veg.

Sales

Non-Veg.

Sales Total Veg. Sales

Non-Veg.

Sales Total

1 1 1,250 1,251 - 1,251 58 - 58 1,193 - 1,193

2 - - - - - - - - - - -

3 - - - - - - - - - - -

4 - - - - - - - - - - -

5 - - - - - - - - - - -

6 - - - - - - - - - - -

7 - - - - - - - - - - -

8 - - - - - - - - - - -

9 - - - - - - - - - - -

10 - - - - - - - - - - -11 - - - - - - - - - - -

12 - - - - - - - - - - -

13 - - - - - - - - - - -

14 - - - - - - - - - - -

15 - - - - - - - - - - -

16 - - - - - - - - - - -

17 - - - - - - - - - - -

18 - - - - - - - - - - -

19 - - - - - - - - - - -

20 - - - - - - - - - - -

21 - - - - - - - - - - -

22 - - - - - - - - - - -

23 - - - - - - - - - - -

24 - - - - - - - - - - -

25 - - - - - - - - - - -26 - - - - - - - - - - -

27 - - - - - - - - - - -

28 - - - - - - - - - - -

29 - - - - - - - - - - -

30 - - - - - - - - - - -

31 - - - - - - - - - - -

Total 1 1,250 1,251 - 1,251 58 - 58 1,193 - 1,193

Floor wise sales VAT on sales Net Sales


4/75

Summary of Purchases from Vendors during the month of April-09

This pivot is based on data in vendor invoices sheet.

Refresh Data

Sum of Amount

Supplier Category Name of the Vendor Date Number Purchase Type

Grand Total


5/75

Summary of Purchases from Vendors for Accounts during the month of April-09

Sum of Amount

Total Supplier Category Name of the Vendor Number Date Total

Grand Total


6/75

Statement showing invoice wise Purchases from Vendors for the month of

Material

Received

Date PO No.

Purchase

Type Name of the Vendor

Credit harish


7/75


8/75


9/75


10/75


11/75


12/75


13/75


14/75


15/75


16/75


17/75


18/75


19/75


20/75


21/75


22/75


23/75


24/75


25/75


26/75


27/75


28/75


29/75

Name of the Supplier

harish

Accord Housekeeping Slutions

Agarwal Trading Company

Amit Market

Atish Gas Supply

B L Thorat

Bhalekar Enterprises

Brahma Griha Udyog

Supplier Master


30/75

Chandrama Enterprises

Charcoal Depot

Dairy Rich Icce Cream

Dairy Rich Kulfi

Deep Backery & General Stores

Enercon Solutions P. Ltd.

Green Agro

Harsh Enterprises

Ice King

Jawahar Provision Stores

Kohli Gas Services

Kwality Chicken Centre

L M Marketing

P&T Associates

Piyush Suppliers

Poona Modern Trade

Rajpal Charcoal Depot

Ramdeo Computers

Rangnath Kudale

Raviraj Mutton Shop

Rawat Brothers Dairy Farm

Recepie 7

Sai Angencies

Sanjay Somaji Kale

Shree Distribution & Marketing Services

Unique Delta Force Secuirty Ltd.Vinayak H. Jaware

xyz

Zzzzzzzzzz

Supplier Categories

S420

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00


31/75

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00

0-Jan-00

0

Purchase Type

Cash

Credit


32/75

April-09

Vendor Invoices'!E998

Supplier Category Number Date Amount

Cumulative

Amount

S420 1145 11-Nov-14 1,524.00 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

#N/A 1,524.00

Invoice details


33/75


34/75


35/75


36/75


37/75


38/75


39/75


40/75


41/75


42/75


43/75


44/75


45/75


46/75


47/75


48/75


49/75


50/75


51/75


52/75


53/75


54/75


55/75

Supplier Category

S420

Housekeeping

Groceries

Groceries

Coal, Fuel & Gas

Vegetables

Colddrinks

Vegetables


56/75

Colddrinks

Coal, Fuel & Gas

Ice-Cream

Ice-Cream

Backery Products

Milk Products

Dairy Products

Groceries

Ice-Cream

Groceries

Coal, Fuel & Gas

Chicken

Water

Colddrinks

Groceries

Groceries

Coal, Fuel & Gas

Housekeeping

Vegetables

Mutton

Milk Products

Groceries

Groceries

Vegetables

Ice-Cream

SecurityMutton

Chicken

Zzzzz


57/75

Petty Cash Register for the month of April-09

Date Particulars Name of supplier

1-Apr-09 Opening Petty Cash balance

Cash I mprest receipts during month:

Cash Pur chase dur ing month:

Cash From the supplier list

30-Apr-09 Closing Petty Cash balance


58/75

Inv/Vch Amount Remarks

Number

10,000.00

-

Total of all cash purchases

from Vendor Invoices sheets

will be pulled directly.

Other small cash expenses /

payments to be entered here.

10,000.00


59/75

Inventory Summary for the month of April-09

Inventory Category

Opening Receipts Issues Closing

Grocery Items 0 0 0 0

Chat Items 0 0 0 0

Colddrinks 0 0 0 0

Ice-Cream 0 0 0 0

Dairy Products 0 0 0 0

Backery 0 0 0 0

Vegetables 0 0 0 0

Fruits 0 0 0 0

Non-Veg. 0 0 0 0

Housekeeping 0 0 0 0

Coal, Fuel & Gas 0 0 0 0

Total 0 0 0 0

Value of Stock


60/75


61/75

Issue Issue Issue

Qty. Value Qty. Qty. Value Qty. Qty. Value Qty.

Receipt

3

Receipt

2

Receipt

1


62/75


63/75

Issue Issue Issue


Receipt Receipt Receipt

987


64/75

Issue Issue Issue



1110 12


65/75

Issue Issue Issue


Receipt ReceiptReceipt

151413


66/75

Issue Issue Issue



1716 18


67/75

Issue Issue Issue



212019


68/75

Issue Issue Issue



242322


69/75

Issue Issue Issue



272625


70/75

Issue Issue Issue


Receipt

30

Receipt Receipt

2928


71/75

Issue

Qty. Value Qty. Qty. Value Qty. Value Qty. Value

- - - -

- - - -

- - - -

- - - -

- - - -

- - - -

- - - -

- - - -

- - - -

- - - -

- - -

- - -

Closing Stock

Receipt

31 Total

Receipts Issues


72/75

Average

Rate for

Isssues


73/75


74/75

Total Total Total Total Total Total Total Total

Chat Dosa N. Indian Pantry S. Indian Starters Staff Non-Veg


75/75

Total

Party Veg. Non-Veg. Party Staff

Section wise Issue Pricing

22 hotel stores inventory

Documents