Scribd
Upload
7 views13 pages

17-09-2019

The document contains detailed sales and financial data for various products, including MS, HSD, and CNG, with opening and closing balances, sales figures, and losses. It also outlines bank deposits, withdrawals, and total amounts for different transactions. Overall, the total sales amount to 1,842,876.59 with a credit sale of 4,732.78.

Uploaded by

satishpatelzerodha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
7 views13 pages

17-09-2019

The document contains detailed sales and financial data for various products, including MS, HSD, and CNG, with opening and closing balances, sales figures, and losses. It also outlines bank deposits, withdrawals, and total amounts for different transactions. Overall, the total sales amount to 1,842,876.59 with a credit sale of 4,732.78.

Uploaded by

satishpatelzerodha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 13

PERTICULAR MS-1 MS-2 MS-3 MS-4

OPNING 1096575 1299634 1500251 555537


CLOSING 1097228 1301660 1501490 556332
SALE 653 2026 1239 795
TESTING 5 5 5 5
TOTAL MS SALE 648 2021 1234 790

PERTICULAR MS-11 MS-12 MS-13 MS-14


OPNING 395839 631822 412268 580280
CLOSING 396271 631822 412459 581309
SALE 432 0 191 1029
TESTING 5 0 5 5
TOTAL SPEED SALE 427 0 186 1024

PERTICULAR HSD-1 HSD-2 HSD-3 HSD-4


OPNING 1482135 1619097 1107171 904029
CLOSING 1483995 1620430 1108826 905148
SALE 1860 1333 1655 1119
TESTING 5 5 5 5
TOTAL HSD SALE TANK-1 1855 1328
TOTAL HSD SALE TANK-2 1650 1114

TOTAL HSD SALE TANK(1+2) 3193 8180

PRODUCT MS-2 MS-1 HSD-1 HSD-2


OPENING 19925 11623 11492 13484
PURCHASE 5000 5000 5000 10000
TOTAL 24925 16623 16492 23484
SALE 8287 3471 3183 8160
LOSS -1515 9 22 42
CLOSING 18153 13143 13287 15282

PERTICULAR CNG-1 CNG-2 CNG-3 CNG-4


OPNING 1198789.01 1200766.87 1204434.27 1307220.75
CLOSING 1199277.34 1201798.58 1205031.98 1307897.99
SALE 488.330000000075 1031.71 597.71 677.24
CREDIT SALE 0 0 0 0
TOTAL MS SALE 488.330000000075 1031.71 597.71 677.24

PRODUCT SALE PRISE RUPEES


MS 11758 69.61 818474.38
HSD 11343 68.63 778470.09
CNG 4387.92 55.95 245504.12
MAK 2T 40 ML POUCH 14 12.0 168
MAK CLASSIC 20W50 - 3 LTR 0 410.0 0
MAK CLASSIC 20W50 - 1 LTR 0 290.0 0
HONDA POWER 1 LTR. 0 210.0 0
MAK HYDRO 5 LTR. 0 1050.0 0
MAK PLATINIUM 15W40 - 5 LTR 0 0
MAK MG 20W40 - 1LTR 0 295.0 0
MAK MG 20W40 - 5LTR 0 1250.0 0
MAK GOLD 4 LTR 0 1000.0 0
mak classic 500ml 0 150.0 0
MAK BRACK FLUE 0 148.0 0
MAK GOLD 1 LTR 0 250.0 0
MAK 2T - 500ML 0 100.0 0
MAK GE - 1LTR 0 230.0 0
MAK MULTIGREAD 1LTR 0 270.0 0
MAK MP 3 - 500GRM 0 180.0 0
MAK 4T SCOOTECH - 800ML 0 220.0 0
MAK 4T NXT - 900ML 1 260.0 260
MAK DZL ZENITH - 4LTR 0 1200.0 0
MAK PETROL ZENITH - 3.50LTR 0 1250.0 0
MAK PETROL ZENITH - 1LTR 0 370.0 0
mak ready cool 1/2 0 100.0 0
MAK READY COOL - 1LTR 0 180.0 0
MAK GE -. IN BARREL 1 LTR 0 140.0 0

TOTAL SALE 1842876.59


CREDIT SALE 4732.78
NOVEMBER MONTH SALARY 0
479 42708.23
110 75131.60
480 57718.16
111 4175.00

TOTAL 0.00 TOTAL 179732.99

PARTY NAME DATE SLIP WHC.NO HSD LTR

0.00
0.00
0.00
0.00

TOTAL 0.00

40 0 600 160 0

REFRESHMENT EXP TANKAR DIEVER BHADU UNLODING EXP MIS.EXP DEPO EXP
BANK DIPOSIT DATE OPNING TODAY TOTAL DENA
26/07/2019 -2202360.98 0.00 -2202360.98 0
-2202360.98

BANK DETAILS RECEIPT/DEPOSIT/BATCH


MAHESHANA CHEQUE/CASH DEPOSIT CH.NO BANK,BRANCH PARTY NAME AMT

BANK DETAILS RECEIPT/DEPOSIT/BATCH


DENA BANK CHEQUE/CASH DEPOSIT CH.NO BANK,BRANCH PARTY NAME AMT
DATE:

MS-5 MS-6 MS-7 MS-8 MS-9 MS-10


760161 598359 1219274 762255 1575301 2174913
760384 599386 1220120 762660 1575705 2175632
223 1027 846 405 404 719
5 5 5 5 5 5
218 1022 841 400 399 714

MS-15 MS-16 MS-17 MS-18


1706733 1341686 1759839 1659016
1707250 1341919 1760545 1659414
517 233 706 398 3506
5 5 5 5 35
512 228 701 393 3471

HSD-5 HSD-6 TOTAL HSD SALE


1536600 1487525
1539773 1489758
3173 2233
5 5
3183
3168 2228 8160

11373 11343

PRODUCT MS HSD CNG


PRICE 69.61 0.00 68.63 55.95

CNG-5 CNG-6 TOTAL CNG SALE


566048.67 814940.36
566460.27 816121.69
411.60 1181.33

411.60 1181.33 4387.92

BASIC AMT 17% 9.00% 9.00% 15.00% 2.50% TOTAL AMT


699550.75 118923.63 818474.38
665359.05 113111.04 778470.09
213481.85 32022.28 245504.12
142.37 12.81 12.81 168.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
220.34 19.83 19.83 260.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
362.71 32.64 32.64 0.00 0.00 428.00

0.00 0 0 0.00
179732.99 0 0 179732.99
80522.56 0 0 80522.56
25675.10 0 0 25675.10
50723.74 0 0 50723.74
336654.39 336654.39
BATCH PAYTM
11639
pending 500
1118 59637.50 12228.1
110.00 pending 200
1119 20775.06 1108

TOTAL 80522.56 25675.1

RATE PETROL RATE RUPEES


0.00 69.61 0.00
22.98 69.61 1599.64
45.01 69.61 3133.15
0.00 69.61 0.00
0.00 69.61 0.00
0.00 69.61 0.00
0.00 69.61 0.00
0.00 69.61 0.00
68.63 0.00 69.61 0.00
68.63 0.00 69.61 0.00
68.63 0.00 69.61 0.00
68.63 0.00 69.61 0.00

67.99 4732.78

1150 0 40 1990 TOTAL


JCB ROOM TOTAL CASH
curior cupon
SWIFTING EXP -1990.00
MAHESHANA TOTAL DIFF CLOSING
0 0 -2202360.98 -2202360.98

PAYMENT/WITHDRAWAL
CHEQUE PAYMENT PARTY NAME DESCRIPTION AMT

PAYMENT/WITHDRAWAL
CHEQUE PAYMENT PARTY NAME DESCRIPTION AMT
PETROL
DIESEL
CNG
POUCH
8337 SCOOTEK
50 NXT
8287 MULTI
COOLANT
BREAK OIL
GE
CLASSIC
RADY COOLANT

MAHESANA BANK
OPENING BALANCE 4063208.16
HDFC CR. 198456.02
CASH CR. 1718500

5980164.18
withdrwal 50000
rtgs 1502857

4427307.18
cc paytm
17328.83
33394.91

TOTAL 50723.74
0
PRODUCT RATE TOTAL
11758 69.61 818474.38
11343 68.63 778470.09
4387.92 55.95 245504.12
14 12.0 168
0 220.0 0
1 260.0 260
0 295.0 0
0 180.0 0
0 148.0 0
0 230.0 0
0 290.0 0
0 100.0 0

1842876.59
BPCL PETRO CARD SALE 80522.56
HDFC CREDIT CARD SAL 179732.99
ACCOUNT 4732.78
axis 0
paytm 25675.1
icici 50723.74
1501489.42

DENA BANK
-183981.22
axis 107847.71
paytm 27273.71
icici 3800.24

-45059.56
ram sewak yadav 113075
modi enterprise 1593

-159727.56

You might also like