Spreadsheet: 836522d1689443818-payments-allocation-to-bills-in-fifo-basis-fifo-sample-data-001-harshit8999-
Sheet: BILLS

payments allocation to bills in fifo basis (excelforum.com) |  |  |  |  | payment date | 2015-06-16 00:00:00 | 2015-07-09 00:00:00 | 2015-07-09 00:00:00 | 2018-05-05 00:00:00 | 2019-04-30 00:00:00 | 2018-06-07 00:00:00 | 2019-07-19 00:00:00
 |  |  |  |  | payment number | 125/JNL/37 | 139/JNL/45 | 141/JNL/47 | 2077/JNL/66 | 3656/JNL/73 | 2162A/Pay133 | 4086A/Pay118
 |  |  |  |  | payment vendor name | ALMT Legal | ALMT Legal | ALMT Legal | [NAME] (Photographer) | [NAME] (Photographer) | [NAME] (Photographer) | [NAME] (Photographer)
 |  |  |  |  | payment amount | 3550 | 1600 | 3375 | 1000 | 580.29 | 102252.05 | 5049
Rows | [NAME] | [NAME] | [NAME] | Total
 | 2015-06-16 00:00:00 | ALMT Legal | 124//Journal/36 | 35500
 | 2015-07-09 00:00:00 | ALMT Legal | 138//Journal/44 | 16000
 | 2015-07-09 00:00:00 | ALMT Legal | 140//Journal/46 | 33750
 | 2018-01-05 00:00:00 | [NAME] (Photographer) | 1574//Journal/239 | 19500
 | 2018-02-07 00:00:00 | [NAME] (Photographer) | 1685//Journal/275 | 1700
 | 2018-03-06 00:00:00 | [NAME] (Photographer) | 1792//Journal/311 | 55920
 | 2018-03-06 00:00:00 | [NAME] (Photographer) | 1816//Journal/335 | 67122
 | 2018-04-07 00:00:00 | [NAME] (Photographer) | 1961//Journal/7 | 17820
 | 2018-04-25 00:00:00 | [NAME] (Photographer) | 1989//Journal/15 | 17820
 | 2018-04-30 00:00:00 | [NAME] (Photographer) | 2024//Journal/46 | 61429.5
 | 2018-05-31 00:00:00 | [NAME] (Photographer) | 2132//Journal/104 | 1757.25
 | 2018-05-31 00:00:00 | [NAME] (Photographer) | 2133//Journal/105 | 3366
 | 2018-05-31 00:00:00 | [NAME] (Photographer) | 2134//Journal/106 | 4722.3
 | 2018-05-31 00:00:00 | [NAME] (Photographer) | 2143//Journal/115 | 44599.5
 | 2018-05-31 00:00:00 | [NAME] (Photographer) | 2144//Journal/116 | 48807
 | 2018-06-30 00:00:00 | [NAME] (Photographer) | 2221//Journal/150 | 49648.5
 | 2018-06-30 00:00:00 | [NAME] (Photographer) | 2223//Journal/152 | 54697.5
 | 2018-06-30 00:00:00 | [NAME] (Photographer) | 2232//Journal/161 | 7573.5
 | 2018-06-30 00:00:00 | [NAME] (Photographer) | 2235//Journal/164 | 8860.5
 | 2018-06-30 00:00:00 | [NAME] (Photographer) | 2236//Journal/165 | 10098
 | 2018-07-31 00:00:00 | [NAME] (Photographer) | 2323//Journal/204 | 2243
 | 2018-07-31 00:00:00 | [NAME] (Photographer) | 2324//Journal/205 | 85882.5
 | 2018-08-31 00:00:00 | [NAME] (Photographer) | 2453//Journal/290 | 38709
 | 2018-09-30 00:00:00 | [NAME] (Photographer) | 2584//Journal/371 | 63571.5
 | 2018-10-31 00:00:00 | [NAME] (Photographer) | 2727//Journal/470 | 46098
 | 2018-11-30 00:00:00 | [NAME] (Photographer) | 2858//Journal/556 | 19354.5
 | 2018-12-31 00:00:00 | [NAME] (Photographer) | 3037//Journal/677 | 841.5
 | 2018-12-31 00:00:00 | [NAME] (Photographer) | 3067//Journal/707 | 25245
 | 2019-01-31 00:00:00 | [NAME] (Photographer) | 3203//Journal/798 | 15988.5
 | 2019-02-28 00:00:00 | [NAME] (Photographer) | 3350//Journal/914 | 5890.5
 | 2019-02-28 00:00:00 | [NAME] (Photographer) | 3351//Journal/915 | 5049
 | 2019-02-28 00:00:00 | [NAME] (Photographer) | 3358//Journal/922 | 7920
 | 2019-03-31 00:00:00 | [NAME] (Photographer) | 3490//Journal/1015 | 12624
 | 2019-03-31 00:00:00 | [NAME] (Photographer) | 3491//Journal/1016 | 13464
 | 2019-04-30 00:00:00 | [NAME] (Photographer) | 3657//Journal/74 | 2524.5
 | 2019-04-30 00:00:00 | [NAME] (Photographer) | 3658//Journal/75 | 5890.5
 | 2019-05-31 00:00:00 | [NAME] (Photographer) | 3847//Journal/211 | 2524.5
 | 2019-05-31 00:00:00 | [NAME] (Photographer) | 3848//Journal/212 | 9256.5
 | 2019-06-30 00:00:00 | [NAME] (Photographer) | 4009//Journal/338 | 5049
 | 2019-07-31 00:00:00 | [NAME] (Photographer) | 4106//Journal/403 | 841.5
 | 2019-07-31 00:00:00 | [NAME] (Photographer) | 4115//Journal/412 | 5940
 | 2019-08-31 00:00:00 | [NAME] (Photographer) | 4216//Journal/473 | 35640
 | 2019-10-01 00:00:00 | [NAME] (Photographer) | 4369//Journal/581 | 25260
 | 2019-11-01 00:00:00 | [NAME] (Photographer) | 4476//Journal/627 | 11880
 | 2019-12-31 00:00:00 | [NAME] (Photographer) | 4673//Journal/717 | 15840
 | 2020-01-31 00:00:00 | [NAME] (Photographer) | 4771//Journal/774 | 23760
 | 2020-01-31 00:00:00 | [NAME] (Photographer) | 4789//Journal/792 | 1980
 | 2020-01-31 00:00:00 | [NAME] (Photographer) | 4794//Journal/797 | 39600
 | 2020-02-29 00:00:00 | [NAME] (Photographer) | 4902//Journal/869 | 63360
 | 2020-03-31 00:00:00 | [NAME] (Photographer) | 5052//Journal/939 | 7920
 | 2022-05-01 00:00:00 | [NAME] (Photographer) | 7912//Journal/57 | 22275
 | 2022-06-01 00:00:00 | [NAME] (Photographer) | 8021//Journal/129 | 25740
 | 2022-07-01 00:00:00 | [NAME] (Photographer) | 8169//Journal/235 | 19305
 | 2022-09-04 00:00:00 | [NAME] (Photographer) | 8475//Journal/460 | 12870
 | 2022-10-10 00:00:00 | [NAME] (Photographer) | 8661//Journal/570 | 6435
 | 2022-11-01 00:00:00 | [NAME] (Photographer) | 8748//Journal/638 | 12870
 | 2022-11-30 00:00:00 | [NAME] (Photographer) | 8962//Journal/807 | 6435
 | 2023-01-06 00:00:00 | [NAME] (Photographer) | 9193//Journal/946 | 19305
 | 2023-02-28 00:00:00 | [NAME] (Photographer) | 9447//Journal/1107 | 59400
 | 2023-03-31 00:00:00 | [NAME] (Photographer) | 9665//Journal/1240 | 6435