Spreadsheet: 735990d1623310125-payment-time-between-invoice-and-payments-test-data-2-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FORMULA
2021-05-26 00:00:00 | Inv | 007846 |  |  | 320 | CR |  |  | 320 | CR | Q30012 |  |  | result to be
2021-05-26 00:00:00 | O/Bal |  |  |  |  |  |  |  | 320 | CR | Q30012
2021-05-27 00:00:00 | Pay | 002466 | layerEFT |  |  |  | 320 |  | 0 |  | Q30012
2021-03-22 00:00:00 | Inv | 072102 |  |  | 121.07 | CR |  |  | 121.07 | CR | Q30014
2021-03-31 00:00:00 | O/Bal |  |  |  |  |  |  |  | 121.07 | CR | Q30014
2021-04-01 00:00:00 | Pay | 002450 | layerEFT |  |  |  | 121.07 |  | 0 |  | Q30014
2021-05-19 00:00:00 | Inv | 072105 |  |  | 93.35 | CR |  |  | 93.35 | CR | Q30014
2021-05-19 00:00:00 | O/Bal |  |  |  |  |  |  |  | 93.35 | CR | Q30014
2021-05-20 00:00:00 | Pay | 002464 | layerEFT |  |  |  | 93.35 |  | 0 |  | Q30014
2020-12-23 00:00:00 | Inv | 006275 |  |  | 156.27 | CR |  |  | 11798.26 |  | Q30018
2020-12-23 00:00:00 | Inv | 006282 |  |  | 98.73 | CR |  |  | 11216.7 |  | Q30018
2020-12-23 00:00:00 | Inv | 006286 |  |  | 178.34 | CR |  |  | 11038.36 |  | Q30018
2020-12-23 00:00:00 | Inv | 024006 |  |  | 1016.64 | CR |  |  | 9725.56 |  | Q30018
2020-12-23 00:00:00 | Inv | 024008 |  |  | 629 | CR |  |  | 7843.93 |  | Q30018
2020-12-23 00:00:00 | Inv | 053777 |  |  | 1149.6 | CR |  |  | 1256.74 |  | Q30018
2020-12-23 00:00:00 | Inv | 053778 |  |  | 212.12 | CR |  |  | 1044.62 |  | Q30018
2020-12-29 00:00:00 | Inv | 006232 |  |  | 265.2 | CR |  |  | 11954.53 |  | Q30018
2020-12-29 00:00:00 | Inv | 024007 |  |  | 1252.63 | CR |  |  | 8472.93 |  | Q30018
2020-12-29 00:00:00 | Inv | 024009 |  |  | 5037.33 | CR |  |  | 2806.6 |  | Q30018
2020-12-29 00:00:00 | Inv | 024010 |  |  | 144.45 | CR |  |  | 2662.15 |  | Q30018
2020-12-29 00:00:00 | Inv | 053910 |  |  | 787.56 | CR |  |  | 257.06 |  | Q30018
2020-12-29 00:00:00 | Inv | 053911 |  |  | 257.06 | CR |  |  | 0 |  | Q30018
2020-12-30 00:00:00 | Pay | 015222 | PAYMENT |  |  |  | 12219.73 |  | 12219.73 |  | Q30018 |  |  | 7 | Result needed
2021-01-29 00:00:00 | Inv | 007683 |  |  | 550 | CR |  |  | 550 | CR | Q30012
2021-02-03 00:00:00 | O/Bal |  |  |  |  |  |  |  | 550 | CR | Q30012
2021-02-04 00:00:00 | Pay | 002554 | layerEFT |  |  |  | 550 |  | 0 |  | Q30012
2021-02-23 00:00:00 | Inv | 007725 |  |  | 320 | CR |  |  | 320 | CR | Q30012
2021-02-24 00:00:00 | O/Bal |  |  |  |  |  |  |  | 320 | CR | Q30012
2021-02-25 00:00:00 | Pay | 002560 | layerEFT |  |  |  | 320 |  | 0 |  | Q30012
2021-03-23 00:00:00 | Inv | 007746 |  |  | 320 | CR |  |  | 320 | CR | Q30012
2021-03-24 00:00:00 | O/Bal |  |  |  |  |  |  |  | 320 | CR | Q30012
2021-03-25 00:00:00 | Pay | 002568 | layerEFT |  |  |  | 320 |  | 0 |  | Q30012
2021-04-09 00:00:00 | Inv | 007769 |  |  | 1315.5 | CR |  |  | 1315.5 | CR | Q30012
2021-04-14 00:00:00 | O/Bal |  |  |  |  |  |  |  | 1315.5 | CR | Q30012
2021-04-15 00:00:00 | Pay | 002454 | layerEFT |  |  |  | 1315.5 |  | 0 |  | Q30012
2021-04-16 00:00:00 | Inv | 007779 |  |  | 950.95 | CR |  |  | 950.95 | CR | Q30012
2021-04-21 00:00:00 | O/Bal |  |  |  |  |  |  |  | 950.95 | CR | Q30012
2021-04-22 00:00:00 | Pay | 002456 | layerEFT |  |  |  | 950.95 |  | 0 |  | Q30012
2021-04-27 00:00:00 | Inv | 007796 |  |  | 320 | CR |  |  | 320 | CR | Q30012
2021-04-28 00:00:00 | O/Bal |  |  |  |  |  |  |  | 320 | CR | Q30012
2021-04-29 00:00:00 | Pay | 002458 | layerEFT |  |  |  | 320 |  | 0 |  | Q30012
2021-05-05 00:00:00 | Inv | 007790 |  |  | 372.5 | CR |  |  | 372.5 | CR | Q30012
2021-05-05 00:00:00 | O/Bal |  |  |  |  |  |  |  | 372.5 | CR | Q30012
2021-05-06 00:00:00 | Pay | 002460 | layerEFT |  |  |  | 372.5 |  | 0 |  | Q30012
2021-05-19 00:00:00 | Inv | 007826 |  |  | 312.5 | CR |  |  | 312.5 | CR | Q30012
2021-05-19 00:00:00 | O/Bal |  |  |  |  |  |  |  | 312.5 | CR | Q30012
2021-05-20 00:00:00 | Pay | 002464 | layerEFT |  |  |  | 312.5 |  | 0 |  | Q30012
2021-01-06 00:00:00 | Inv | 006289 |  |  | 66.09 | CR |  |  | 9357.53 |  | Q30018
2021-01-06 00:00:00 | Inv | 006295 |  |  | 173.74 | CR |  |  | 9050.41 |  | Q30018
2021-01-06 00:00:00 | Inv | 006297 |  |  | 55.31 | CR |  |  | 8995.1 |  | Q30018
2021-01-06 00:00:00 | Inv | 006298 |  |  | 79.02 | CR |  |  | 8916.08 |  | Q30018
2021-01-06 00:00:00 | Inv | 006300 |  |  | 179.11 | CR |  |  | 8736.97 |  | Q30018
2021-01-06 00:00:00 | Inv | 006311 |  |  | 204.71 | CR |  |  | 8532.26 |  | Q30018
2021-01-06 00:00:00 | Inv | 006312 |  |  | 55.24 | CR |  |  | 8477.02 |  | Q30018
2021-01-07 00:00:00 | Inv | 024018 |  |  | 1082.33 | CR |  |  | 30976.91 |  | Q30018
2021-01-07 00:00:00 | Inv | 024019 |  |  | 1387.36 | CR |  |  | 29589.55 |  | Q30018
2021-01-07 00:00:00 | Inv | 053779 |  |  | 1279.03 | CR |  |  | 17853.64 |  | Q30018
2021-01-08 00:00:00 | Inv | 006313 |  |  | 9761.84 | CR |  |  | 59683.69 |  | Q30018
2021-01-11 00:00:00 | Inv | 053913 |  |  | 70.67 | CR |  |  | 15185.95 |  | Q30018
2021-01-12 00:00:00 | Inv | 005323 |  |  | 30.36 | CR |  |  | 70532.51 |  | Q30018
2021-01-12 00:00:00 | Inv | 006299 |  |  | 39.88 | CR |  |  | 70492.63 |  | Q30018
2021-01-12 00:00:00 | Inv | 006302 |  |  | 214.26 | CR |  |  | 70278.37 |  | Q30018
2021-01-12 00:00:00 | Inv | 006303 |  |  | 204.96 | CR |  |  | 70073.41 |  | Q30018
2021-01-12 00:00:00 | Inv | 006304 |  |  | 280.38 | CR |  |  | 69793.03 |  | Q30018
2021-01-12 00:00:00 | Inv | 006305 |  |  | 35.24 | CR |  |  | 69757.79 |  | Q30018
2021-01-12 00:00:00 | Inv | 006307 |  |  | 130.86 | CR |  |  | 69626.93 |  | Q30018
2021-01-12 00:00:00 | Inv | 006308 |  |  | 82.67 | CR |  |  | 69544.26 |  | Q30018
2021-01-12 00:00:00 | Inv | 006310 |  |  | 98.73 | CR |  |  | 69445.53 |  | Q30018
2021-01-12 00:00:00 | Inv | 006315 |  |  | 123.14 | CR |  |  | 59560.55 |  | Q30018
2021-01-12 00:00:00 | Inv | 006325 |  |  | 55.31 | CR |  |  | 59505.24 |  | Q30018
2021-01-12 00:00:00 | Inv | 006335 |  |  | 27446 | CR |  |  | 32059.24 |  | Q30018
2021-01-12 00:00:00 | Inv | 024022 |  |  | 2727 | CR |  |  | 26862.55 |  | Q30018
2021-01-12 00:00:00 | Inv | 024024 |  |  | 2321.7 | CR |  |  | 24540.85 |  | Q30018
2021-01-12 00:00:00 | Inv | 024025 |  |  | 1113.33 | CR |  |  | 23427.52 |  | Q30018
2021-01-12 00:00:00 | Inv | 024026 |  |  | 1040.52 | CR |  |  | 22387 |  | Q30018
2021-01-12 00:00:00 | Inv | 024027 |  |  | 1840.51 | CR |  |  | 20546.49 |  | Q30018
2021-01-12 00:00:00 | Inv | 024028 |  |  | 256.12 | CR |  |  | 20290.37 |  | Q30018
2021-01-12 00:00:00 | Inv | 053763 |  |  | 1157.7 | CR |  |  | 19132.67 |  | Q30018
2021-01-12 00:00:00 | Inv | 053783 |  |  | 2597.02 | CR |  |  | 15256.62 |  | Q30018
2021-01-12 00:00:00 | Inv | 053914 |  |  | 1497.26 | CR |  |  | 13688.69 |  | Q30018
2021-01-12 00:00:00 | Inv | 053915 |  |  | 13451.84 | CR |  |  | 1232.03 | CR | Q30018
2021-01-12 00:00:00 | Inv | 053916 |  |  | 265.23 | CR |  |  | 1497.26 | CR | Q30018
2021-01-13 00:00:00 | Pay | 015245 | PAYMENT |  |  |  | 70562.87 |  | 70562.87 |  | Q30018 |  |  | 7 | Result needed
2021-01-13 00:00:00 | Inv | 053914 |  |  | 1468.88 | CR |  |  | 12219.81 |  | Q30018
2021-01-13 00:00:00 | CR/No | N53914 |  |  |  |  | 1497.26 |  | 0 |  | Q30018
2021-01-18 00:00:00 | Inv | 006290 |  |  | 148.68 | CR |  |  | 27191.49 |  | Q30018
2021-01-18 00:00:00 | Inv | 006296 |  |  | 86.68 | CR |  |  | 27104.81 |  | Q30018
2021-01-18 00:00:00 | Inv | 006301 |  |  | 191.88 | CR |  |  | 26912.93 |  | Q30018
2021-01-18 00:00:00 | Inv | 006306 |  |  | 64.6 | CR |  |  | 26848.33 |  | Q30018
2021-01-18 00:00:00 | Inv | 006316 |  |  | 123.14 | CR |  |  | 26725.19 |  | Q30018
2021-01-18 00:00:00 | Inv | 006317 |  |  | 139.41 | CR |  |  | 26585.78 |  | Q30018
2021-01-18 00:00:00 | Inv | 006324 |  |  | 210.12 | CR |  |  | 26375.66 |  | Q30018
2021-01-18 00:00:00 | Inv | 006327 |  |  | 88.41 | CR |  |  | 26287.25 |  | Q30018
2021-01-18 00:00:00 | Inv | 006328 |  |  | 66.09 | CR |  |  | 26221.16 |  | Q30018
2021-01-18 00:00:00 | Inv | 006330 |  |  | 123.09 | CR |  |  | 26098.07 |  | Q30018
2021-01-18 00:00:00 | Inv | 006331 |  |  | 30.3 | CR |  |  | 26067.77 |  | Q30018
2021-01-18 00:00:00 | Inv | 006332 |  |  | 81.22 | CR |  |  | 25986.55 |  | Q30018
2021-01-18 00:00:00 | Inv | 006334 |  |  | 178.39 | CR |  |  | 25808.16 |  | Q30018
2021-01-18 00:00:00 | Inv | 006338 |  |  | 155.89 | CR |  |  | 25652.27 |  | Q30018
2021-01-18 00:00:00 | Inv | 006343 |  |  | 55.31 | CR |  |  | 25596.96 |  | Q30018
2021-01-18 00:00:00 | Inv | 024023 |  |  | 4225.14 | CR |  |  | 21371.82 |  | Q30018
2021-01-18 00:00:00 | Inv | 024029 |  |  | 1546.65 | CR |  |  | 19825.17 |  | Q30018
2021-01-18 00:00:00 | Inv | 024030 |  |  | 1879.6 | CR |  |  | 17945.57 |  | Q30018
2021-01-18 00:00:00 | Inv | 024032 |  |  | 325.49 | CR |  |  | 17620.08 |  | Q30018
2021-01-18 00:00:00 | Inv | 024033 |  |  | 1325.7 | CR |  |  | 16294.38 |  | Q30018
2021-01-18 00:00:00 | Inv | 024035 |  |  | 1095.48 | CR |  |  | 14581.33 |  | Q30018
2021-01-18 00:00:00 | Inv | 024036 |  |  | 1923.83 | CR |  |  | 12657.5 |  | Q30018
2021-01-18 00:00:00 | Inv | 033222 |  |  | 47.85 | CR |  |  | 8600.08 |  | Q30018
2021-01-18 00:00:00 | Inv | 033223 |  |  | 72.98 | CR |  |  | 8527.1 |  | Q30018
2021-01-18 00:00:00 | Inv | 033224 |  |  | 31.45 | CR |  |  | 8495.65 |  | Q30018
2021-01-18 00:00:00 | Inv | 053755 |  |  | 27.13 | CR |  |  | 8468.52 |  | Q30018
2021-01-18 00:00:00 | Inv | 053784 |  |  | 2184 | CR |  |  | 6284.52 |  | Q30018
2021-01-18 00:00:00 | Inv | 053789 |  |  | 1194.82 | CR |  |  | 5089.7 |  | Q30018
2021-01-19 00:00:00 | Inv | 005835 |  |  | 15161.18 | CR |  |  | 27340.17 |  | Q30018
2021-01-19 00:00:00 | Inv | 024034 |  |  | 617.57 | CR |  |  | 15676.81 |  | Q30018
2021-01-19 00:00:00 | Inv | 024039 |  |  | 4009.57 | CR |  |  | 8647.93 |  | Q30018
2021-01-19 00:00:00 | Inv | 053790 |  |  | 4954.02 | CR |  |  | 135.68 |  | Q30018
2021-01-19 00:00:00 | Inv | 053919 |  |  | 135.68 | CR |  |  | 0 |  | Q30018
2021-01-20 00:00:00 | Pay | 015273 | PAYMENT |  |  |  | 42501.35 |  | 42501.35 |  | Q30018 |  |  | 2 | Result needed