Scribd
Upload
5 views13 pages

20 10 2019

The Anjani Petroleum report details the opening and closing balances, sales, and testing data for various fuel types including MS, HSD, and CNG. It includes total sales figures, losses, and financial transactions, highlighting a total sale of 2,069,663.00 and cash in hand of 1,226,259.60. Additionally, the report outlines bank deposits and withdrawals, along with specific product sales and prices.

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

20 10 2019

The Anjani Petroleum report details the opening and closing balances, sales, and testing data for various fuel types including MS, HSD, and CNG. It includes total sales figures, losses, and financial transactions, highlighting a total sale of 2,069,663.00 and cash in hand of 1,226,259.60. Additionally, the report outlines bank deposits and withdrawals, along with specific product sales and prices.

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

ANJANI PETROLEUM REPORT

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


OPNING 1113272 1365614 1524214 581358
CLOSING 1113684 1368732 1524528 582278
SALE 412 3118 314 920
TESTING 5 5 5 5
TOTAL MS SALE 407 3113 309 915

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


OPNING 411648 655113 424507 614423
CLOSING 411987 656119 425220 615580
SALE 339 1006 713 1157
TESTING 5 5 5 5
TOTAL SPEED SALE 334 1001 708 1152

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


OPNING 1554190 1664195 1159618 935797
CLOSING 1556634 1665601 1160762 936506
SALE 2444 1406 1144 709
TESTING 5 5 5 5
TOTAL HSD SALE TANK-1 2439 1401
TOTAL HSD SALE TANK-2 1139 704

TOTAL HSD SALE TANK(1+2) 3850 6610

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


OPENING -5977 -11441 -35696 -47428
PURCHASE 10000 0 10000
TOTAL 4023 -11441 -35696 -37428
SALE 9162 5033 3840 6590
LOSS 1582 19 31 -12
CLOSING -6721 -16493 -39567 -44006

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


OPNING 1221222.87 1232511.12 1233877.7 1342711.07
CLOSING 1221863.79 1233557.72 1234930.33 1343720.15
SALE 640.919999999926 1046.6 1052.63 1009.08
CREDIT SALE 0 0 0 0
TOTAL MS SALE 640.919999999926 1046.6 1052.63 1009.08

PRODUCT SALE PRISE RUPEES


MS 14195 70.69 1003444.55
HSD 10430 69.26 722381.80
CNG 6259.99 54.82 343172.65
MAK 2T 40 ML POUCH 17 12.0 204
MAK CLASSIC 20W50 - 3 LTR 0 410.0 0
MAK CLASSIC 20W50 - 1 LTR 0 290.0 0
ATF - 1LTR 0 260.0 0
MAK HYDRO 5 LTR. 0 1050.0 0
MAK PLATINIUM 15W40 - 5 LTR 0 0
MAK MG 20W40 - 1LTR 0 270.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
HONDA POWER 2 230.0 460
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 2069663.00


CREDIT SALE 46793.44
NOVEMBER MONTH SALARY 0
ALL CARD SALE 796609.96
CASH IN HAND 1226259.60

1226259.60
BATCH AXIS BATCH HDFC
203 26706.09
155 98522.39
202 78205.28
201 101442.00
154 27077.15

TOTAL 0.00 TOTAL 331952.91

PARTY NAME DATE SLIP WHC.NO HSD LTR


UMIYA 20/10/2019 1715 GJ01HT5533 284.16
UMIYA 20/10/2019 1734 GJ27X1660 222.57
UMIYA 20/10/2019 1713 GJ18AZ5522 140.01
RAMANI DEVLOPERS 20/10/2019 4773 GJ1KS1880 28.88
20/10/2019 0.00
20/10/2019 0.00
20/10/2019 0.00
20/10/2019 0.00
20/10/2019 0.00
20/10/2019 0.00
20/10/2019 0.00
20/10/2019 0.00

TOTAL 675.62

40 200 0 160 0

REFRESHMENT EXP TANKAR DIEVER BHADU UNLODING EXP MIS.EXP DEPO EXP
BANK DIPOSIT DATE OPNING TODAY TOTAL DENA
26/07/2019 1719407.43 1226259.60 2945667.03 0
-202.97

BANK DETAILS RECEIPT/DEPOSIT/BATCH


MAHESHANA CHEQUE/CASH DEPOSIT CH.NO BANK,BRANCH PARTY NAME AMT
RAMANI DEVLOPERS 1426 ICICI 29001

BANK DETAILS RECEIPT/DEPOSIT/BATCH


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

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


780380 626154 1234808 777072 1590954 2196321
781233 626899 1235623 777594 1591619 2197169
853 745 815 522 665 848
5 5 5 5 5 5
848 740 810 517 660 843

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


1733704 1356339 1782531 1672811
1734439 1356414 1783227 1673163
735 75 696 352 5073
5 5 5 5 40
730 70 691 347 5033

HSD-5 HSD-6 TOTAL HSD SALE


1628997 1556887
1631560 1559081
2563 2194
5 5
3840
2558 2189 6590

10460 10430

PRODUCT MS HSD CNG


PRICE 70.69 0.00 69.26 54.82

CNG-5 CNG-6 TOTAL CNG SALE


592584.25 857451.26
593638.6 858907.67
1054.35 1456.41

1054.35 1456.41 6259.99

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


857644.91 145799.64 1003444.55
617420.34 104961.46 722381.80
298411.00 44761.65 343172.65
172.88 15.56 15.56 204.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
389.83 35.08 35.08 460.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00
562.71 50.64 50.64 0.00 0.00 664.00

AXIS 0.00 0 0 0.00


HDFC 331952.91 0 0 331952.91
BPCL 404074.29 0 0 404074.29
PAYTM 36783.46 0 0 36783.46
NEW PAYTM 23799.30 0 0 23799.30
TOTAL 796609.96 796609.96
BATCH BPCL BATCH PAYTM
1235 8541.44 2270.73
1232 130769.85 723
1233 150000.00 21063.73
1234 108300.00 12726
1231 6463.00

TOTAL 404074.29 36783.46

RATE PETROL RATE RUPEES


69.26 0.00 70.69 19680.92
69.26 0.00 70.69 15415.20
69.26 0.00 70.69 9697.09
69.26 0.00 70.69 2000.23
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00
69.26 0.00 70.69 0.00

0.00 46793.44

6000 200 100 6700 TOTAL


LOKAND NO TOTAL CASH
FOOD AUTO RIKSHWA
ZAPO EXP 1219559.60
MAHESHANA TOTAL DIFF CLOSING
2945870 2945870 -202.97 -202.97

PAYMENT/WITHDRAWAL
CHEQUE PAYMENT PARTY NAME DESCRIPTION AMT
175 BPCL RTGS 1486952

PAYMENT/WITHDRAWAL
CHEQUE PAYMENT PARTY NAME DESCRIPTION AMT
ANJANI PETROLEUM

PETROL
DIESEL
CNG
POUCH
9212 SCOOTEK
50 NXT
9162 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
1974.00
2321.66
19503.64

TOTAL 23799.30
DINOMATION
2000 542 1084000
500 3111 1555500
200 333 66600
100 2173 217300
50 198 9900
20 226 4520
10 805 8050

2945870
JANI PETROLEUM 20/10/2019
PRODUCT RATE TOTAL
14195 70.69 1003444.55
10430 69.26 722381.80
6259.99 54.82 343172.65
17 12.0 204
2 230.0 460
0 240.0 0
0 270.0 0
0 180.0 0
0 148.0 0
0 230.0 0
0 290.0 0
0 100.0 0

2069663.00
BPCL PETRO CARD SALE 404074.29
HDFC CREDIT CARD SAL 331952.91
ACCOUNT 46793.44
axis 0
paytm 36783.46
icici 23799.3
1226259.60

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