Bill Details File-Gst

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

BILL DETAILS FROM: 01/08/2020

HOLD AMOUNT
SL TOTAL NET RECEIBLE RECEIVED DATE OF PEYMENT GST PAID GST PAID
NO BILL DATE WORK ORDER NO SAC CODE Case ID BILL NO BILL AMOUNT GST 18% AMOUNT TDS AMOUNT DEDUCTION AMOUNT RECEIPT WORK DESCRIPTION RECV. DATE AMOUNT CHALLAN NO REASON FOR DEDUCTION MONTH
Gratuity,lea STATUS
GST ve& Bonus

1 8/1/2020 998519 SG01200800042 SCW/01 2584.26 465 3049 19 3030 0 0 0 3049 10.08.2020 PP Emputy Bag Handling Line 1&2 (24/05/20 TO 31/05/20) Y
2 8/1/2020 998519 SG01200900182 SCW/02 59468.75 10704 70173 446 69727 0 12661 0 57065 04.09.2020 Loading cost as per work order (24/05/20 TO 31/05/20) Y
3 8/1/2020 998519 SG01200800043 SCW/04 29939.70 5389 35329 225 35104 0 0 0 35329 10.08.2020 PP Emputy Bag Handling Line 1&2 (01/06/20 TO 30/06/20) Y
4 8/1/2020 998519 SG01200800265 SCW/05 688969.53 124015 812984 5167 807817 0 0 750000 62984 10.08.2020 Loading cost as per work order (01/06/20 TO 30/06/20) Y
5 8/1/2020 998519 SG01200800269 SCW/06 510400.60 91872 602273 3828 598445 0 0 572766 29507 10.08.2020 Idle Payment (01/06/20 TO 30/06/20) Y
6 8/4/2020 998519 SG01200800308 SCW/07 1122451.83 202041 1324493 8418 1316075 0 0 0 1316074 12.08.2020 Loading cost as per work order (01/07/20 TO 31/07/20) Y
7 8/4/2020 998519 SG01200800781 SCW/08 409956.49 73792 483749 3075 480674 0 150890 195959 133545 21.08.2020 Idle Payment (01/07/20 TO 31/07/20) Y
8 8/4/2020 998519 SG01200800314 SCW/09 43509.90 7832 51342 326 51015 0 0 0 51015 12.08.2020 PP Emputy Bag Handling Line 1&2 (01/07/20 TO 31/07/20) Y
9 8/28/2020 998519 SG01200901189 SCW/10 61103.00 10999 72102 458 71643 0 0 0 71643 29.09.2020 EPF REIMBURSMENT FOR THE MONTH OF JUNE-2020 Y
10 9/2/2020 998519 SG01200901191 SCW/11 91464.00 16464 107928 686 107242 0 0 0 107242 29.09.2020 EPF REIMBURSMENT FOR THE MONTH OF JULY-2020 Y
11 9/2/2020 998519 SG01200900429 SCW/12 400201.56 72036 472238 3002 469236 0 63556 47863 357817 11.09.2020 Loading cost as per work order (01/08/20 TO 31/08/20) Y
12 9/2/2020 998519 SG01200901132 SCW/13 241134.83 43404 284539 1809 282731 0 0 0 282729 29.09.2020 Idle Payment (01/08/20 TO 31/08/20) Y
13 9/2/2020 998519 SG01200900419 SCW/14 15513.12 2792 18305 116 18189 0 0 1000 17189 11.09.2020 PP Emputy Bag Handling Line 1&2 (01/08/20 TO 31/08/20) Y
14 9/3/2020 998519 SG01201000021 SCW/15 13433.00 2418 15851 101 15750 0 0 0 15750 01.10.2020 WC POLICY REIMBURSMENT OF LOADING & UNLOADING WORK Y
15 9/30/2020 998519 SG01201000200 SCW/16 43680.00 7862 51542 328 51215 0 0 1000 50214 07.10.2020 EPF REIMBURSMENT FOR THE MONTH OF AUG-2020 Y
16 10/1/2020 998519 SG01201000368 SCW/17 823069.94 148153 971223 6173 965050 0 128022 0 837027 16.10.2020 Loading cost as per work order (01/09/20 TO 30/09/20) Y
17 10/14/2020 998519 SG01201001030 SCW/18 478031.38 86046 564077 3585 560492 0 0 0 560491 26.10.2020 Idle Payment (01/09/20 TO 30/09/20) Y
18 10/1/2020 998519 SG01201000276 SCW/19 31904.88 5743 37648 239 37408 0 0 0 37408 12.10.2020 PP Emputy Bag Handling Line 1&2 (01/09/20 TO 30/09/20) Y
19 10/18/2020 998519 SG01201001049 SCW/20 77326.00 13919 91245 580 90665 0 0 0 90665 26.10.2020 EPF REIMBURSMENT FOR THE MONTH OF SEPT-2020 Y
20 11/2/2020 998519 SG01201100331 SCW/21 837489.16 150748 988237 6281 981956 0 107753 0 887887 13.11.2020 Loading cost as per work order (01/10/20 TO 31/10/20) Y
21 11/2/2020 998519 SG01201200141 SCW/22 269758.85 48557 318315 2023 316292 0 0 316291 07.12.2020 Idle Payment (01/10/20 TO 31/10/20) Y
22 11/2/2020 998519 SG01201100258 SCW/23 32463.82 5843 38307 243 38064 0 1300 23077 10.11.2020 PP Emputy Bag Handling Line 1&2 (01/10/20 TO 31/10/20) Y
23 11/25/2020 998519 SG01201200034 SCW/24 73406.00 13213 86619 551 86069 0 0 1300 84768 07.12.2020 EPF REIMBURSMENT FOR THE MONTH OF OCT-2020 Y
24 12/1/2020 998519 SG01201200405 SCW/25 698922.51 125806.05 824728.56 5242 819487 0 80480 0 739007 11.12.2020 Loading cost as per work order (01/11/20 TO 30/11/20) Y
25 12/25/2020 998519 SG01201201677 SCW/26 137294.93 24713.09 162008.02 1030 160978 0 0 0 160978 04.01.2021 Idle Payment (01/11/20 TO 30/11/20) Y
26 12/1/2020 998519 SG01201200332 SCW/27 27092.52 4876.65 31969.17 203 31766 0 0 0 31765 11.12.2020 PP Emputy Bag Handling Line 1&2 (01/11/20 TO 30/11/20) Y
27 12/21/2020 998519 SCW/28 54459 9802.62 64261.62 408 63853 0 0 0 63853 29.12.2020 EPF REIMBURSMENT FOR THE MONTH OF NOV-2020 Y
28 1/2/2021 998519 SG01210100332 SCW/29 864752.19 155655.39 1020407.58 6486 1013922 0 117352 0 896570 12.01.2021 Loading cost as per work order (01/12/20 TO 31/12/20) Y
29 1/2/2021 998519 SG01210100330 SCW/30 33520.62 6033.71 39554.33 251 39303 0 0 0 39302 12.01.2021 Idle Payment (01/12/20 TO 31/12/20) Y
30 1/22/2021 998519 SG01210200034 SCW/31 63822 11487.96 75309.96 479 74831 0 0 1300 73531 04.02.2021 EPF REIMBURSMENT FOR THE MONTH OF DEC-2020 Y
31 1/28/2021 998519 SG01210200259 SCW/32 321660.72 57898.93 379559.65 2412 377147 0 0 0 377147 05.02.2021 Idle Payment DEC-2020 Y
32 2/2/2021 998519 SG01210200556 SCW/33 1057235.96 190302.47 1247538.43 7929 1239609 0 127233 0 1112375 15.02.2021 Loading cost as per work order JAN-2021 Y
33 2/2/2021 998519 SG01210200458 SCW/34 40981.92 7376.75 48358.67 307 48051 7377 0 0 48051 10.02.2021 PP Emputy Bag Handling Line 1&2 JAN-2021 Y
34 2/17/2021 998519 SG01210201295 SCW/35 80143 14425.74 94568.74 601 93968 14426 0 1300 92667 25.02.2021 EPF REIMBURSMENT FOR THE MONTH OF JAN-21 Y
35 2/19/2021 998519 SG01210201401 SCW/36 105387 18969.66 124356.66 790 123566 0 0 0 124357 02.03.2021 LEAVE PAYMENT 2020 Y
36 2/25/2021 998519 SG01210300096 SCW/37 238545.31 42938.16 281483.47 1789 279694 0 0 0 279694 08.03.2021 Idle Payment JAN-202 Y
37 3/2/2021 998519 SG01210300612 SCW/38 938126.81 168862.83 1106989.64 7036 1099954 0 101695 0 998259 15.03.2021 Loading cost as per work order Feb-2021 Y
38 3/2/2021 998519 SG01210300517 SCW/39 36364.86 6545.67 42910.53 273 42638 0 0 1300 41338 10.03.2021 PP Emputy Bag Handling Line 1&2 FEB-2021 Y
39 3/18/2021 998519 SG01210301800 SCW/40 74527 13414.86 87941.86 559 87383 0 0 65580 30.03.2021 EPF REIMBURSMENT FOR THE MONTH OF FEB-21 Y
40 3/30/2021 8137016735 998519 SG01210400424 SCW/41 258418.24 46515.28 304933.52 1938 302995 0 0 304934 12.04.2021 Idle Payment FEB-2021 Y
41 3/31/2021 8137016208 998519 SG01210400287 SCW/42 877981.72 158036.71 1036018.43 6585 1029434 0 117044 918973 12.04.2021 Loading cost as per work order MAR-2021 Y
42 3/31/2021 998519 SG01210400308 SCW/43 34033.44 6126.02 40159.46 255 39904 0 0 10412 29747 09.04.2021 PP Emputy Bag Handling Line 1&2 MAR-2021 Y
43 3/31/2021 8137016805 998519 SG01210400425 SCW/44 217519.46 39153.50 256672.96 1631 255042 0 0 256673 12.04.2021 Idle Payment Mar-2021 Y
44 4/9/2021 998519 SG01210400965 SCW/45 78043 14047.74 92090.74 585 91505 0 0 92091 23.04.2021 EPF REIMBURSMENT FOR THE MONTH OF MAR-21 Y
45 5/4/2021 998519 SG01210500674 SCW/46 556649.01 100196.82 656845.83 5566 651279 0 0 67682 583597 12.05.2021 Loading cost as per work order Apr-2021 Y
46 5/10/2021 998519 SG01210501133 SCW/47 144814.58 26066.62 170881.20 1448 169433 0 0 169432 21.05.2021 Idle Payment Apr-2021 Y
47 5/10/2021 998519 SG01210500931 SCW/48 18811.02 3385.98 22197.00 188 22009 0 0 22008 19.05.2021 WC POLICY REIMBURSMENT OF LOADING & UNLOADING WORK Y
48 5/13/2021 998519 SG01210501134 SCW/49 20735.48 3732.39 24467.87 207 24261 0 0 24260 21.05.2021 PP Emputy Bag Handling Line 1&2 Apr-2021 Y
49 5/26/2021 998519 SG01210601036 SCW/50 52553 9459.54 62012.54 526 61487 0 0 61487 18.06.2021 EPF REIMBURSMENT FOR THE MONTH OF APR-21 Y
50 6/2/2021 998519 SG01210600930 SCW/51 558664.98 100559.70 659224.68 5587 653638 0 0 1300 652338 17.06.2021 Loading cost as per work order May-2021 Y
51 6/2/2021 998519 SG01210600929 SCW/52 20810.58 3745.90 24556.48 208 24348 0 0 24347 16.06.2021 PP Emputy Bag Handling Line 1&2 May-2021 Y
52 6/7/2021 998519 SG01210700822 SCW/53 128693.03 23164.75 151857.78 1287 150571 0 0 1300 149271 15.07.2021 Idle Payment May-2021 Y
53 7/1/2021 998519 SG01210701068 SCW/54 45296 8153.28 53449.28 453 52996 0 0 52996 19.07.2021 EPF REIMBURSMENT FOR THE MONTH OF MAY-21 Y
54 7/2/2021 998519 SG01210701044 SCW/55 817832.13 147209.78 965041.91 8178 956864 0 0 104351 852513 26.07.2021 Loading cost as per work order June-2021 Y
55 7/2/2021 998519 SG01210700695 SCW/56 30464.7 5483.65 35948.35 305 35644 0 0 35643 14.07.2021 PP Emputy Bag Handling Line 1&2 June-2021 Y
56 7/29/2021 8137017719 998519 SG01210800510 SCW/57 244080.28 43934.45 288014.73 2441 285574 0 0 285574 12.08.2021 Idle Payment June-2021 Y
57 7/30/2021 998519 SG01210801239 SCW/58 74137 13344.66 87481.66 741 86740 0 0 86740 25.08.2021 EPF REIMBURSMENT FOR THE MONTH OF JUNE-21 Y
58 8/3/2021 998519 SG01210800508 SCW/59 634139.83 114145.17 748285.00 6341 741944 0 0 97736 644208 12.08.2021 Loading cost as per work order July-2021 Y
59 8/3/2021 998519 SG01210800510 SCW/60 23622.06 4251.97 27874.03 236 27638 0 0 27637 12.08.2021 PP Emputy Bag Handling Line 1&2 July-2021 Y
60 8/12/2021 998519 SG01210801230 SCW/61 342801.09 61704.20 404505.29 3428 401077 0 0 1300 399776 27.08.2021 Idle Payment July-2021 Y
61 8/30/2021 998519 SG01210900829 SCW/62 75652 13617.36 89269.36 757 88513 0 0 757 87755 16.09.2021 EPF REIMBURSMENT FOR THE MONTH OF JULY-21 Y
62 9/2/2021 8137017724 998519 SG01210900501 SCW/63 578238.38 104082.91 682321.29 5782 676539 0 0 85671 590868 16.09.2021 Loading cost as per work order Aug-2021 Y
63 9/2/2021 998519 SG01210900419 SCW/64 21539.7 3877.15 25416.85 215 25201 0 0 25201 14.09.2021 PP Emputy Bag Handling Line 1&2 Aug-2021 Y
64 9/11/2021 998519 SG01211000247 SCW/65 64960 11692.80 76652.80 650 76003 0 0 76003 08.10.2021 EPF REIMBURSMENT FOR THE MONTH OF AUGUST-21 Y
65 9/16/2021 998519 SG01210901464 SCW/66 270271.95 48648.95 318920.90 2703 316218 0 0 316218 01.10.2021 Idle Payment August-2021 Y
66 10/4/2021 998519 SG01211000530 SCW/67 410928.65 73967.16 484895.81 4109 480787 0 0 82148 398638 21.10.2021 Loading cost as per work order Sept-2021 Y
67 10/4/2021 998519 SG01211000531 SCW/68 15307.32 2755.32 18062.64 153 17910 0 0 17909 12.10.2021 PP Emputy Bag Handling Line 1&2 Sept-2021 Y
68 10/11/2021 998519 SG01211000764 SCW/69 503383 90608.94 593991.94 5034 588958 0 0 593992 18.10.2021 Bonus 2020-21 Y
69 10/16/2021 998519 SG01211001282 SCW/70 60850 10953.00 71803.00 609 71195 0 0 71194 26.10.2021 EPF REIMBURSMENT FOR THE MONTH OF SEPT-21 Y
70 10/25/2021 998519 SG01211200949 SCW/71 34838.14 6270.87 41109.01 348 40761 0 0 40760 30.12.2021 WC POLICY REIMBURSMENT OF LOADING & UNLOADING WORK Y
71 10/26/2021 998519 SG01211100001 SCW/72 390701.12 70326.20 461027.32 3907 457120 0 0 457119 09.11.2021 Idle Payment Sept-2021 Y
72 11/1/2021 998519 SG01211100947 SCW/73 687650.98 123777.18 811428.16 6877 804552 0 111224 693327 26.11.2021 Loading cost as per work order Oct-2021 Y
73 11/1/2021 998519 SG01211100927 SCW/74 25615.38 4610.77 30226.15 256 29970 0 0 1300 28669 24.11.2021 PP Emputy Bag Handling Line 1&2 Oct-2021 Y
74 11/29/2021 998519 SG01211200727 SCW/75 60417 10875.06 71292.06 604 70688 0 0 70678 07.01.2022 EPF REIMBURSMENT FOR THE MONTH OF OCT-21 Y
75 12/3/2021 998519 SG01211200588 SCW/76 467033.05 84065.95 551099.00 4670 546429 0 65426 481002 17.12.2021 Loading cost as per work order Nov-2021 Y
76 12/3/2021 998519 SG01211200590 SCW/77 17397.24 3131.50 20528.74 174 20355 0 0 2246 18109 15.12.2021 PP Emputy Bag Handling Line 1&2 Nov-2021 Y
77 12/4/2021 998519 SG01211200594 SCW/78 428093.22 77056.78 505150.00 4281 500869 0 0 500869 17.12.2021 Idle Payment Oct-2021 Y
78 12/15/2021 998519 SG01220100138 SCW/79 51386 9249.48 60635.48 514 60122 0 0 60121 06.01.2022 EPF REIMBURSMENT FOR THE MONTH OF NOV-21 Y
79 1/1/2022 998519 SG01220100912 SCW/80 726930.82 130847.55 857778.37 7269 850509 0 108447 742061 21.01.2022 Loading cost as per work order Dec-2021 Y
80 1/1/2022 998519 SG01220100888 SCW/81 27078.58 4874.14 31952.72 271 31682 0 0 31682 24.01.2022 PP Emputy Bag Handling Line 1&2 Dec-2021 Y
81 1/7/2022 998519 SG01220100886 SCW/82 188884.32 33999.18 222883.50 1889 220995 0 0 220994 28.01.2022 Idle Payment Nov-2021 Y
82 1/7/2022 998519 SG01220100887 SCW/83 330423.1 59476.16 389899.26 3304 386595 0 0 386594 28.01.2022 Idle Payment Dec-2021 Y
83 1/10/2022 998519 SG01220101055 SCW/84 71501 12870.18 84371.18 715 83656 0 0 3793 79862 08.02.2022 EPF REIMBURSMENT FOR THE MONTH OF DEC-21 Y
84 2/3/2022 998519 SG01220200572 SCW/85 921029.95 165785.39 1086815.34 9210 1077605 100000 117703 859901 22.02.2022 Loading cost as per work order Jan-2022 Y
85 2/3/2022 998519 SG01220200506 SCW/86 34308.88 6175.60 40484.48 343 40141 0 0 40140 11.02.2022 PP Emputy Bag Handling Line 1&2 Jan-2022 Y
86 2/11/2022 998519 SG01220300004 SCW/87 258950.33 46611.06 305561.39 2590 302972 0 0 302971 10.03.2022 Idle Payment Jan-2022 Y
87 2/23/2022 998519 SG01220300014 SCW/88 81272 14628.96 95900.96 813 95088 0 0 95088 07.03.2022 EPF REIMBURSMENT FOR THE MONTH OF JAN-22 Y
88 3/4/2022 998519 SG01220300733 SCW/89 722253.95 130005.71 852259.66 7223 845037 0 0 845037 21.03.2022 Loading cost as per work order Feb-2022 Y
89 3/4/2022 998519 SG01220300734 SCW/90 26904.36 4842.78 31747.14 269 31478 0 0 1838 29639 21.03.2022 PP Emputy Bag Handling Line 1&2 Feb-2022 Y
90 3/21/2022 998519 SCW/91 69636 12534.48 82170.48 696 81474 0 0 EPF REIMBURSMENT FOR THE MONTH OF FEB-22
91 3/21/2022 998519 SCW/92 228046.48 41048.37 269094.85 2280 266814 0 0 Idle Payment Feb-2022
24161680 4349102 28510783 210127 28300656 121803 1409486 2036922 24409885
Hi,
Pls find GST mismatch details for Vendor 820662.
We will check and release, once you will provide print screen of GSTR 1 (Showing Bill NO) against our GST Number 24AAACL64
GST Mismatch and holded
PR Gstin PR Document Number PR Document Date PR Taxable Value
24ADYPL6936H3ZV SCW/01 8/1/2020 2584.26
24ADYPL6936H3ZV SCW/04 8/1/2020 29939.7
24ADYPL6936H3ZV SCW/05 8/1/2020 688969.53
24ADYPL6936H3ZV SCW/06 8/1/2020 510398.8
24ADYPL6936H3ZV SCW/07 8/4/2020 1122451.83
24ADYPL6936H3ZV SCW/08 8/4/2020 409718.23
24ADYPL6936H3ZV SCW/09 8/4/2020 43509.9

GST Mismatch and yet not holded


PR Gstin PR Document Number PR Document Date PR Taxable Value
24ADYPL6936H3ZV SCW/02 8/1/2020 59468.75
24ADYPL6936H3ZV SCW/10 8/28/2020 61103
24ADYPL6936H3ZV SCW/11 9/2/2020 91464
24ADYPL6936H3ZV SCW/12 9/2/2020 400201.56
24ADYPL6936H3ZV SCW/13 9/2/2020 241134.15
24ADYPL6936H3ZV SCW/14 9/2/2020 15513.12
GST Number 24AAACL6442L1ZG for below bills.

PR Rate PR Cgst Amount PR Sgst Amount


18 232.58 232.58
18 2694.57 2694.57
18 62007.26 62007.26
18 45935.89 45935.89
18 101020.66 101020.66
18 36874.64 36874.64
18 3915.89 3915.89
252681.49 252681.49

PR Rate PR Cgst Amount PR Sgst Amount


18 5352.19 5352.19
18 5499.27 5499.27
18 8231.76 8231.76
18 36018.14 36018.14
18 21702.07 21702.07
18 1396.18 1396.18

78199.61 78199.61

You might also like