Detailed settlement report

135
Settlement ID Job ID Job Date Resource Name Job Price Salary Cash Collected
STN00647 209357 26 Feb 2019 Gabriel.Driver 105.00 50.00 105.00
STN00647 209086 26 Feb 2019 Gabriel.Driver 400.00 250.00 0.00
STN00647 209310 27 Feb 2019 Gabriel.Driver 164.80 100.00 0.00
STN00647 209466 27 Feb 2019 Gabriel.Driver 98.00 43.50 0.00
STN00647 209467 27 Feb 2019 Gabriel.Driver 92.00 39.90 0.00
STN00647 209468 27 Feb 2019 Gabriel.Driver 97.00 42.90 0.00
STN00647 209411 27 Feb 2019 Gabriel.Driver 101.00 45.30 0.00
STN00647 209477 28 Feb 2019 Gabriel.Driver 170.00 50.00 0.00
STN00647 209309 27 Feb 2019 Gabriel.Driver 75.00 34.80 0.00
STN00647 209509 28 Feb 2019 Gabriel.Driver 110.00 50.70 110.00
STN00647 209308 01 Mar 2019 Gabriel.Driver 75.00 34.80 0.00
STN00647 209222 25 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 208933 26 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 209312 26 Feb 2019 Guneet 10T 112.00 37.20 0.00
STN00647 209352 26 Feb 2019 Guneet 10T 77.00 25.80 0.00
STN00647 209385 27 Feb 2019 Guneet 10T 95.00 29.89 95.00
STN00647 209384 27 Feb 2019 Guneet 10T 120.00 40.64 120.00
STN00647 209383 27 Feb 2019 Guneet 10T 185.00 61.28 0.00
STN00647 209510 02 Mar 2019 Guneet 10T 75.00 24.94 0.00
STN00647 209364 27 Feb 2019 Guneet 10T 95.00 29.89 0.00
STN00647 209395 27 Feb 2019 Guneet 10T 247.50 57.50 0.00
STN00647 209327 26 Feb 2019 Guneet 10T 182.00 59.99 0.00
STN00647 209320 25 Feb 2019 Guneet 10T 111.00 36.77 0.00
STN00647 209305 25 Feb 2019 Guneet 10T 85.00 29.24 0.00
STN00647 208945 26 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 208985 25 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 208980 25 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 208934 25 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 208644 25 Feb 2019 Guneet 10T 75.00 24.94 0.00
STN00647 209416 27 Feb 2019 Prabh.Pargat 92.00 26.60 0.00
STN00647 209328 27 Feb 2019 Prabh.Pargat 100.00 29.80 100.00
STN00647 209392 27 Feb 2019 Prabh.Pargat 88.00 25.00 0.00
STN00647 208826 01 Mar 2019 Gabriel.Driver 75.00 34.80 0.00
STN00647 209660 01 Mar 2019 Gabriel.Driver 100.00 44.70 0.00
STN00647 209535 01 Mar 2019 Gabriel.Driver 70.00 31.80 0.00
STN00647 209597 02 Mar 2019 Prabh.Pargat 110.00 27.00 110.00
STN00647 209489 01 Mar 2019 Gabriel.Driver 70.00 31.80 0.00
STN00647 209587 02 Mar 2019 Prabh.Pargat 110.00 27.00 110.00
STN00647 209582 02 Mar 2019 Prabh.Pargat 110.00 27.00 110.00
STN00647 209598 02 Mar 2019 Prabh.Pargat 165.00 40.50 165.00
STN00647 209602 02 Mar 2019 Prabh.Pargat 110.00 27.00 0.00
STN00647 209518 28 Feb 2019 Gabriel.Driver 111.00 51.30 0.00
STN00647 209440 28 Feb 2019 Guneet 10T 125.00 42.79 115.00
STN00647 209423 28 Feb 2019 Guneet 10T 85.00 29.24 0.00
STN00647 209593 03 Mar 2019 Prabh.Pargat 110.00 27.00 110.00
STN00647 209433 28 Feb 2019 Guneet 10T 95.00 29.89 0.00
STN00647 209592 02 Mar 2019 Prabh.Pargat 200.00 27.00 110.00
STN00647 209451 28 Feb 2019 Guneet 10T 95.00 29.89 95.00
STN00647 209446 28 Feb 2019 Guneet 10T 150.00 49.88 120.00
STN00647 209354 26 Feb 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209355 26 Feb 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209445 28 Feb 2019 Guneet 10T 95.00 29.89 95.00
STN00647 208981 26 Feb 2019 Ankush.mms 85.00 28.90 0.00
STN00647 209408 26 Feb 2019 Ankush.mms 92.00 28.26 0.00
STN00647 209389 27 Feb 2019 Guneet 10T 95.00 29.89 0.00
STN00647 209407 02 Mar 2019 Guneet 10T 77.00 25.80 0.00
STN00647 209435 28 Feb 2019 Ankush.mms 121.00 40.59 0.00
STN00647 209436 28 Feb 2019 Ankush.mms 83.00 28.05 0.00
STN00647 209437 28 Feb 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209438 28 Feb 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209517 01 Mar 2019 Ankush.mms 105.00 33.79 0.00
STN00647 209666 02 Mar 2019 Guneet 10T 92.00 28.60 0.00
STN00647 209695 02 Mar 2019 Guneet 10T 90.00 27.74 0.00
STN00647 209092 02 Mar 2019 Guneet 10T 110.00 36.34 0.00
STN00647 209705 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209704 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209703 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209702 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209749 02 Mar 2019 Guneet 10T 70.00 22.79 0.00
STN00647 209636 03 Mar 2019 Guneet 10T 95.00 29.89 95.00
STN00647 209643 03 Mar 2019 Guneet 10T 95.00 29.89 0.00
STN00647 209646 03 Mar 2019 Guneet 10T 120.00 40.64 0.00
STN00647 209707 02 Mar 2019 Ankush.mms 85.00 28.90 0.00
STN00647 209357 26 Feb 2019 Gabriel.Own.Helper 105.00 20.00
STN00647 209086 26 Feb 2019 Gabriel.Own.Helper 400.00 100.00
STN00647 209310 27 Feb 2019 Gabriel.Own.Helper 164.80 40.00
STN00647 209466 27 Feb 2019 Gabriel.Own.Helper 98.00 25.50
STN00647 209467 27 Feb 2019 Gabriel.Own.Helper 92.00 25.50
STN00647 209468 27 Feb 2019 Gabriel.Own.Helper 97.00 25.50
STN00647 209411 27 Feb 2019 Gabriel.Own.Helper 101.00 25.50
STN00647 209477 28 Feb 2019 Gabriel.Own.Helper 170.00 20.00 0.00
STN00647 209309 27 Feb 2019 Gabriel.Own.Helper 75.00 17.00
STN00647 209509 28 Feb 2019 Gabriel.Own.Helper 110.00 25.50
STN00647 209518 28 Feb 2019 Gabriel.Own.Helper 111.00 25.50
STN00647 209489 01 Mar 2019 Gabriel.Own.Helper 70.00 17.00
STN00647 209535 01 Mar 2019 Gabriel.Own.Helper 70.00 17.00
STN00647 209660 01 Mar 2019 Gabriel.Own.Helper 100.00 25.50
STN00647 209308 01 Mar 2019 Gabriel.Own.Helper 75.00 17.00
STN00647 208826 01 Mar 2019 Gabriel.Own.Helper 75.00 17.00
STN00647 209651 03 Mar 2019 Guneet 10T 95.00 29.89 95.00
STN00647 208987 25 Feb 2019 Pavleen 82.40 28.35 0.00
STN00647 209626 03 Mar 2019 Guneet 10T 105.00 34.19 105.00
STN00647 209771 03 Mar 2019 Guneet 10T 190.00 63.43 190.00
STN00647 209380 27 Feb 2019 Pavleen 170.00 57.38 170.00
STN00647 209381 27 Feb 2019 Pavleen 165.00 58.95 135.00
STN00647 209495 27 Feb 2019 Prabh.Pargat 75.00 23.20 0.00
STN00647 209366 27 Feb 2019 Pavleen 150.00 52.20 150.00
STN00647 209599 02 Mar 2019 Prabh.Pargat 110.00 27.00 0.00
STN00647 209400 28 Feb 2019 Pavleen 283.25 65.00 0.00
STN00647 209585 02 Mar 2019 Prabh.Pargat 110.00 27.00 110.00
STN00647 209432 28 Feb 2019 Pavleen 103.00 33.53 0.00
STN00647 209588 02 Mar 2019 Prabh.Pargat 110.00 27.00 110.00
STN00647 209595 02 Mar 2019 Prabh.Pargat 110.00 27.00 0.00
STN00647 209572 03 Mar 2019 Prabh.Pargat 180.00 40.50 180.00
STN00647 209678 02 Mar 2019 Prabh.Pargat 2500.00 600.00 0.00
STN00647 209202 25 Feb 2019 Ankush.mms 100.00 31.66 100.00
STN00647 208537 25 Feb 2019 Ankush.mms 101.00 32.09 0.00
STN00647 209631 03 Mar 2019 Pavleen 135.00 49.28 135.00
STN00647 209649 03 Mar 2019 Pavleen 160.00 56.70 160.00
STN00647 209664 03 Mar 2019 Pavleen 110.00 38.03 0.00
STN00647 209625 03 Mar 2019 Pavleen 95.00 31.28 95.00
STN00647 209346 26 Feb 2019 Ankush.mms 113.00 37.19 113.00
STN00647 209287 28 Feb 2019 Ankush.mms 112.00 36.76 0.00
STN00647 209286 28 Feb 2019 Ankush.mms 77.00 25.50 0.00
STN00647 209431 01 Mar 2019 Ankush.mms 73.00 23.80 0.00
STN00647 209682 01 Mar 2019 Ankush.mms 82.00 27.63 0.00
STN00647 209706 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209701 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209700 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 209699 02 Mar 2019 Ankush.mms 100.00 31.66 0.00
STN00647 209698 02 Mar 2019 Ankush.mms 70.00 22.53 0.00
STN00647 208661 25 Feb 2019 Pavleen 275.00 65.00 0.00
STN00647 208444 26 Feb 2019 Pavleen 924.65 221.00 0.00
STN00647 209331 25 Feb 2019 Pavleen 220.00 52.00 0.00
STN00647 209375 27 Feb 2019 Pavleen 110.00 38.03 110.00
STN00647 209368 27 Feb 2019 Pavleen 200.00 67.05 150.00
STN00647 209266 27 Feb 2019 Pavleen 102.00 34.43 0.00
STN00647 209238 28 Feb 2019 Pavleen 100.00 33.53 100.00
STN00647 209574 02 Mar 2019 Prabh.Pargat 113.30 27.00 0.00
STN00647 209603 03 Mar 2019 Prabh.Pargat 110.00 27.00 0.00
STN00647 209006 02 Mar 2019 Pavleen 841.33 182.00 0.00
STN00647 209658 03 Mar 2019 Pavleen 95.00 31.28 95.00
STN00647 209529 28 Feb 2019 Pavleen 77.00 27.00 0.00
STN00647 209545 28 Feb 2019 Pavleen 180.00 61.88 0.00
STN00647 207871 01 Mar 2019 Pavleen 1166.55 273.00 0.00
settlementrefbooking_idjob_datenametotal_job_pricesalarycash
STN0064720935726 Feb 2019Gabriel.Driver105.0050.00105.00
STN0064720908626 Feb 2019Gabriel.Driver400.00250.000.00
STN0064720931027 Feb 2019Gabriel.Driver164.80100.000.00
STN0064720946627 Feb 2019Gabriel.Driver98.0043.500.00
STN0064720946727 Feb 2019Gabriel.Driver92.0039.900.00
STN0064720946827 Feb 2019Gabriel.Driver97.0042.900.00
STN0064720941127 Feb 2019Gabriel.Driver101.0045.300.00
STN0064720947728 Feb 2019Gabriel.Driver170.0050.000.00
STN0064720930927 Feb 2019Gabriel.Driver75.0034.800.00
STN0064720950928 Feb 2019Gabriel.Driver110.0050.70110.00
STN0064720930801 Mar 2019Gabriel.Driver75.0034.800.00
STN0064720922225 Feb 2019Guneet 10T75.0024.940.00
STN0064720893326 Feb 2019Guneet 10T75.0024.940.00
STN0064720931226 Feb 2019Guneet 10T112.0037.200.00
STN0064720935226 Feb 2019Guneet 10T77.0025.800.00
STN0064720938527 Feb 2019Guneet 10T95.0029.8995.00
STN0064720938427 Feb 2019Guneet 10T120.0040.64120.00
STN0064720938327 Feb 2019Guneet 10T185.0061.280.00
STN0064720951002 Mar 2019Guneet 10T75.0024.940.00
STN0064720936427 Feb 2019Guneet 10T95.0029.890.00
STN0064720939527 Feb 2019Guneet 10T247.5057.500.00
STN0064720932726 Feb 2019Guneet 10T182.0059.990.00
STN0064720932025 Feb 2019Guneet 10T111.0036.770.00
STN0064720930525 Feb 2019Guneet 10T85.0029.240.00
STN0064720894526 Feb 2019Guneet 10T75.0024.940.00
STN0064720898525 Feb 2019Guneet 10T75.0024.940.00
STN0064720898025 Feb 2019Guneet 10T75.0024.940.00
STN0064720893425 Feb 2019Guneet 10T75.0024.940.00
STN0064720864425 Feb 2019Guneet 10T75.0024.940.00
STN0064720941627 Feb 2019Prabh.Pargat92.0026.600.00
STN0064720932827 Feb 2019Prabh.Pargat100.0029.80100.00
STN0064720939227 Feb 2019Prabh.Pargat88.0025.000.00
STN0064720882601 Mar 2019Gabriel.Driver75.0034.800.00
STN0064720966001 Mar 2019Gabriel.Driver100.0044.700.00
STN0064720953501 Mar 2019Gabriel.Driver70.0031.800.00
STN0064720959702 Mar 2019Prabh.Pargat110.0027.00110.00
STN0064720948901 Mar 2019Gabriel.Driver70.0031.800.00
STN0064720958702 Mar 2019Prabh.Pargat110.0027.00110.00
STN0064720958202 Mar 2019Prabh.Pargat110.0027.00110.00
STN0064720959802 Mar 2019Prabh.Pargat165.0040.50165.00
STN0064720960202 Mar 2019Prabh.Pargat110.0027.000.00
STN0064720951828 Feb 2019Gabriel.Driver111.0051.300.00
STN0064720944028 Feb 2019Guneet 10T125.0042.79115.00
STN0064720942328 Feb 2019Guneet 10T85.0029.240.00
STN0064720959303 Mar 2019Prabh.Pargat110.0027.00110.00
STN0064720943328 Feb 2019Guneet 10T95.0029.890.00
STN0064720959202 Mar 2019Prabh.Pargat200.0027.00110.00
STN0064720945128 Feb 2019Guneet 10T95.0029.8995.00
STN0064720944628 Feb 2019Guneet 10T150.0049.88120.00
STN0064720935426 Feb 2019Ankush.mms70.0022.530.00
STN0064720935526 Feb 2019Ankush.mms70.0022.530.00
STN0064720944528 Feb 2019Guneet 10T95.0029.8995.00
STN0064720898126 Feb 2019Ankush.mms85.0028.900.00
STN0064720940826 Feb 2019Ankush.mms92.0028.260.00
STN0064720938927 Feb 2019Guneet 10T95.0029.890.00
STN0064720940702 Mar 2019Guneet 10T77.0025.800.00
STN0064720943528 Feb 2019Ankush.mms121.0040.590.00
STN0064720943628 Feb 2019Ankush.mms83.0028.050.00
STN0064720943728 Feb 2019Ankush.mms70.0022.530.00
STN0064720943828 Feb 2019Ankush.mms70.0022.530.00
STN0064720951701 Mar 2019Ankush.mms105.0033.790.00
STN0064720966602 Mar 2019Guneet 10T92.0028.600.00
STN0064720969502 Mar 2019Guneet 10T90.0027.740.00
STN0064720909202 Mar 2019Guneet 10T110.0036.340.00
STN0064720970502 Mar 2019Ankush.mms70.0022.530.00
STN0064720970402 Mar 2019Ankush.mms70.0022.530.00
STN0064720970302 Mar 2019Ankush.mms70.0022.530.00
STN0064720970202 Mar 2019Ankush.mms70.0022.530.00
STN0064720974902 Mar 2019Guneet 10T70.0022.790.00
STN0064720963603 Mar 2019Guneet 10T95.0029.8995.00
STN0064720964303 Mar 2019Guneet 10T95.0029.890.00
STN0064720964603 Mar 2019Guneet 10T120.0040.640.00
STN0064720970702 Mar 2019Ankush.mms85.0028.900.00
STN0064720935726 Feb 2019Gabriel.Own.Helper105.0020.00 
STN0064720908626 Feb 2019Gabriel.Own.Helper400.00100.00 
STN0064720931027 Feb 2019Gabriel.Own.Helper164.8040.00 
STN0064720946627 Feb 2019Gabriel.Own.Helper98.0025.50 
STN0064720946727 Feb 2019Gabriel.Own.Helper92.0025.50 
STN0064720946827 Feb 2019Gabriel.Own.Helper97.0025.50 
STN0064720941127 Feb 2019Gabriel.Own.Helper101.0025.50 
STN0064720947728 Feb 2019Gabriel.Own.Helper170.0020.000.00
STN0064720930927 Feb 2019Gabriel.Own.Helper75.0017.00 
STN0064720950928 Feb 2019Gabriel.Own.Helper110.0025.50 
STN0064720951828 Feb 2019Gabriel.Own.Helper111.0025.50 
STN0064720948901 Mar 2019Gabriel.Own.Helper70.0017.00 
STN0064720953501 Mar 2019Gabriel.Own.Helper70.0017.00 
STN0064720966001 Mar 2019Gabriel.Own.Helper100.0025.50 
STN0064720930801 Mar 2019Gabriel.Own.Helper75.0017.00 
STN0064720882601 Mar 2019Gabriel.Own.Helper75.0017.00 
STN0064720965103 Mar 2019Guneet 10T95.0029.8995.00
STN0064720898725 Feb 2019Pavleen82.4028.350.00
STN0064720962603 Mar 2019Guneet 10T105.0034.19105.00
STN0064720977103 Mar 2019Guneet 10T190.0063.43190.00
STN0064720938027 Feb 2019Pavleen170.0057.38170.00
STN0064720938127 Feb 2019Pavleen165.0058.95135.00
STN0064720949527 Feb 2019Prabh.Pargat75.0023.200.00
STN0064720936627 Feb 2019Pavleen150.0052.20150.00
STN0064720959902 Mar 2019Prabh.Pargat110.0027.000.00
STN0064720940028 Feb 2019Pavleen283.2565.000.00
STN0064720958502 Mar 2019Prabh.Pargat110.0027.00110.00
STN0064720943228 Feb 2019Pavleen103.0033.530.00
STN0064720958802 Mar 2019Prabh.Pargat110.0027.00110.00
STN0064720959502 Mar 2019Prabh.Pargat110.0027.000.00
STN0064720957203 Mar 2019Prabh.Pargat180.0040.50180.00
STN0064720967802 Mar 2019Prabh.Pargat2500.00600.000.00
STN0064720920225 Feb 2019Ankush.mms100.0031.66100.00
STN0064720853725 Feb 2019Ankush.mms101.0032.090.00
STN0064720963103 Mar 2019Pavleen135.0049.28135.00
STN0064720964903 Mar 2019Pavleen160.0056.70160.00
STN0064720966403 Mar 2019Pavleen110.0038.030.00
STN0064720962503 Mar 2019Pavleen95.0031.2895.00
STN0064720934626 Feb 2019Ankush.mms113.0037.19113.00
STN0064720928728 Feb 2019Ankush.mms112.0036.760.00
STN0064720928628 Feb 2019Ankush.mms77.0025.500.00
STN0064720943101 Mar 2019Ankush.mms73.0023.800.00
STN0064720968201 Mar 2019Ankush.mms82.0027.630.00
STN0064720970602 Mar 2019Ankush.mms70.0022.530.00
STN0064720970102 Mar 2019Ankush.mms70.0022.530.00
STN0064720970002 Mar 2019Ankush.mms70.0022.530.00
STN0064720969902 Mar 2019Ankush.mms100.0031.660.00
STN0064720969802 Mar 2019Ankush.mms70.0022.530.00
STN0064720866125 Feb 2019Pavleen275.0065.000.00
STN0064720844426 Feb 2019Pavleen924.65221.000.00
STN0064720933125 Feb 2019Pavleen220.0052.000.00
STN0064720937527 Feb 2019Pavleen110.0038.03110.00
STN0064720936827 Feb 2019Pavleen200.0067.05150.00
STN0064720926627 Feb 2019Pavleen102.0034.430.00
STN0064720923828 Feb 2019Pavleen100.0033.53100.00
STN0064720957402 Mar 2019Prabh.Pargat113.3027.000.00
STN0064720960303 Mar 2019Prabh.Pargat110.0027.000.00
STN0064720900602 Mar 2019Pavleen841.33182.000.00
STN0064720965803 Mar 2019Pavleen95.0031.2895.00
STN0064720952928 Feb 2019Pavleen77.0027.000.00
STN0064720954528 Feb 2019Pavleen180.0061.880.00
STN0064720787101 Mar 2019Pavleen1166.55273.000.00