Scribd
Upload
11 views13 pages

16-09-2019

The document provides detailed sales and financial data for various products including MS, HSD, and CNG across multiple tanks and sales categories. It includes opening and closing balances, total sales, losses, and cash transactions for the month. Additionally, it summarizes bank deposits, payments, and overall financial status, highlighting total sales and cash in hand.

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
11 views13 pages

16-09-2019

The document provides detailed sales and financial data for various products including MS, HSD, and CNG across multiple tanks and sales categories. It includes opening and closing balances, total sales, losses, and cash transactions for the month. Additionally, it summarizes bank deposits, payments, and overall financial status, highlighting total sales and cash in hand.

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 1095945 1297944 1499031 554941


CLOSING 1096575 1299634 1500251 555537
SALE 630 1690 1220 596
TESTING 5 5 5 5
TOTAL MS SALE 625 1685 1215 591

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


OPNING 395427 631822 411786 578801
CLOSING 395839 631822 412268 580280
SALE 412 0 482 1479
TESTING 5 0 5 5
TOTAL SPEED SALE 407 0 477 1474

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


OPNING 1480713 1618056 1105679 902778
CLOSING 1482135 1619097 1107171 904029
SALE 1422 1041 1492 1251
TESTING 5 5 5 5
TOTAL HSD SALE TANK-1 1417 1036
TOTAL HSD SALE TANK-2 1487 1246

TOTAL HSD SALE TANK(1+2) 2463 6204

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


OPENING 13155 6515 13941 9679
PURCHASE 15000 10000 0 10000
TOTAL 28155 16515 13941 19679
SALE 6708 4902 2453 6184
LOSS 1522 -10 -4 11
CLOSING 19925 11623 11492 13484

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


OPNING 1198631.6 1200464.27 1204228.07 1306872.87
CLOSING 1198789.01 1200766.87 1204434.27 1307220.75
SALE 157.409999999916 302.6000000001 206.2 347.88
CREDIT SALE 0 0 0 0
TOTAL MS SALE 157.409999999916 302.6000000001 206.2 347.88

PRODUCT SALE PRISE RUPEES


MS 11610 69.45 806314.50
HSD 8637 68.45 591202.65
CNG 1622.50 55.95 90778.87
MAK 2T 40 ML POUCH 7 12.0 84
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 0 240.0 0
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 1488380.02


CREDIT SALE 0.00
NOVEMBER MONTH SALARY 0
ALL CARD SALE 400209.82
CASH IN HAND 1088170.20

1088170.20
BATCH AXIS BATCH HDFC
475 77465.10
476 80909.70
107 60340.00
477 30391.17
1996.00

TOTAL 0.00 TOTAL 251101.97

PARTY NAME DATE SLIP WHC.NO HSD LTR

0.00
0.00
0.00
0.00
0.00
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 -2202361.14 1088170.20 -1114190.94 0
-2201760.94

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


759868 597685 1218982 762095 1574875 2174136
760161 598359 1219274 762255 1575301 2174913
293 674 292 160 426 777
5 5 5 5 5 5
288 669 287 155 421 772

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


1705994 1341230 1758904 1658582
1706733 1341686 1759839 1659016
739 456 935 434 4937
5 5 5 5 35
734 451 930 429 4902

HSD-5 HSD-6 TOTAL HSD SALE


1534756 1485908
1536600 1487525
1844 1617
5 5
2453
1839 1612 6184

8667 8637

PRODUCT MS HSD CNG


PRICE 69.45 0.00 68.45 55.95

CNG-5 CNG-6 TOTAL CNG SALE


565849.77 814530.85
566048.67 814940.36
198.90 409.51

198.90 409.51 1622.50

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


689157.69 117156.81 806314.50
505301.41 85901.24 591202.65
78938.15 11840.72 90778.87
71.19 6.41 6.41 84.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 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
71.19 6.41 6.41 0.00 0.00 84.00

AXIS 0.00 0 0 0.00


HDFC 251101.97 0 0 251101.97
BPCL 94220.00 0 0 94220.00
PAYTM 24556.00 0 0 24556.00
NEW PAYTM 30331.85 0 0 30331.85
TOTAL 400209.82 400209.82
BATCH BPCL BATCH PAYTM
1114 33020.00 9708
1115 15200.00 14254
1116 46000.00 594

TOTAL 94220.00 24556

RATE PETROL RATE RUPEES

68.45 0.00 69.45 0.00


68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00
68.45 0.00 69.45 0.00

0.00 0.00

700 9700 1840 13040 TOTAL


JCB AND
HARILAL NI TOTAL CASH
CIMENT INTO TRACTOR
MAJURI EXP
WORK 1075130.20
MAHESHANA TOTAL DIFF CLOSING
1087570 1087570 -2201760.94 -2201760.94

PAYMENT/WITHDRAWAL
CHEQUE PAYMENT PARTY NAME DESCRIPTION AMT
38 BPCL 2622486
37 CANCLED

PAYMENT/WITHDRAWAL
CHEQUE PAYMENT PARTY NAME DESCRIPTION AMT
PETROL
DIESEL
CNG
POUCH
6758 SCOOTEK
50 NXT
6708 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
25062.85
5269.00

TOTAL 30331.85
DINOMATION
2000 185 370000
500 1181 590500
200 192 38400
100 748 74800
50 167 8350
20 54 1080
10 444 4440

1087570
PRODUCT RATE TOTAL
11610 69.45 806314.5
8637 68.45 591202.65
1622.50 55.95 90778.87
7 12.0 84
0 220.0 0
0 240.0 0
0 295.0 0
0 180.0 0
0 148.0 0
0 230.0 0
0 290.0 0
0 100.0 0

1488380.02
BPCL PETRO CARD SALE 94220.00
HDFC CREDIT CARD SAL 251101.97
ACCOUNT 0.00
axis 0
paytm 24556
icici 30331.85
1088170.20

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