Spreadsheet: 690444d1597110570-best-formulas-method-for-spotting-recurring-payment-values-from-different-months-sample
Sheet: Source file

Doc Date | Posting Date | Vendor Invoice Number | Vendor Number | G/L Account No. | Invoice Amount(Group)
2020-04-28 00:00:00 | 2020-05-09 00:00:00 | [PHONE] | IC0003001 | 620300 | -87400
2020-06-01 00:00:00 | 2020-06-19 00:00:00 | MTC20200602-1 | MT0010001 | 620300 | -87400
2020-06-15 00:00:00 | 2020-06-24 00:00:00 | MTC20200615-1 | MT0010001 | 620300 | -87400
2020-05-22 00:00:00 | 2020-06-22 00:00:00 | 1611 | VM0001001 | 631100 | -33333.33
2020-05-22 00:00:00 | 2020-06-22 00:00:00 | 1610 | VM0001001 | 631100 | -33333.33
2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 70581 | AP0001001 | 647600 | -31186.26
2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 70581. | AP0001001 | 647600 | -31186.26
2020-03-31 00:00:00 | 2020-04-20 00:00:00 | 116791 | SM0012001 | 647200 | -24438.82
2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 117318 | SM0012001 | 647200 | -24438.82
2020-05-31 00:00:00 | 2020-06-22 00:00:00 | 117881 | SM0012001 | 647200 | -24438.82
2020-06-03 00:00:00 | 43996 | 97341186 | NC0007001 | 632000 | -24000
2020-06-02 00:00:00 | 2020-06-26 00:00:00 | 97340764 | NC0007001 | 510700 | -24000
2020-06-03 00:00:00 | 2020-06-26 00:00:00 | 97341186A | NC0007001 | 510700 | -24000
2020-05-01 00:00:00 | 2020-05-13 00:00:00 | 11446 | CA0001001 | 642400 | -22475
2020-06-01 00:00:00 | 2020-06-10 00:00:00 | 11500 | CA0001001 | 642400 | -22475
2020-04-06 00:00:00 | 2020-05-08 00:00:00 | 20200406-001 | IS0015001 | 510700 | -21600
2020-05-06 00:00:00 | 2020-05-08 00:00:00 | 20200506-001 | IS0015001 | 510700 | -21600
2020-04-05 00:00:00 | 2020-04-13 00:00:00 | 28169 | CT0019001 | 646200 | -17240
2020-05-05 00:00:00 | 2020-05-18 00:00:00 | 28388 | CT0019001 | 646200 | -17240
2020-06-05 00:00:00 | 2020-06-12 00:00:00 | 28590 | CT0019001 | 646200 | -17240
2020-05-15 00:00:00 | 2020-05-27 00:00:00 | [PHONE] | CB0001001 | 646200 | -16415.44
2020-06-15 00:00:00 | 2020-06-24 00:00:00 | [PHONE] | CB0001001 | 646200 | -16415.44
2020-04-01 00:00:00 | 2020-04-30 00:00:00 | 116754 | SM0012001 | 647200 | -16333
2020-05-01 00:00:00 | 2020-05-31 00:00:00 | 116769 | SM0012001 | 647200 | -16333
2020-04-01 00:00:00 | 2020-04-30 00:00:00 | 116763 | SM0012001 | 647200 | -13531
2020-05-01 00:00:00 | 2020-05-27 00:00:00 | 117170 | SM0012001 | 647200 | -13531
2020-04-19 00:00:00 | 2020-04-28 00:00:00 | [PHONE]-0420 | AT0039001 | 646200 | -12701.22
2020-05-19 00:00:00 | 2020-06-05 00:00:00 | [PHONE]-0520 | AT0039001 | 646200 | -12701.22
2020-06-19 00:00:00 | 2020-06-29 00:00:00 | [PHONE]-0620 | AT0039001 | 646200 | -12701.22
2020-04-01 00:00:00 | 2020-04-13 00:00:00 | M10510 | BP0008001 | 647400 | -12240
2020-05-01 00:00:00 | 2020-05-08 00:00:00 | M10689 | BP0008001 | 647400 | -12240
2020-06-01 00:00:00 | 2020-06-10 00:00:00 | M10860 | BP0008001 | 647400 | -12240
2020-04-30 00:00:00 | 2020-05-30 00:00:00 | FUS030660 | FU0001001 | 631100 | -11111.1
2020-05-31 00:00:00 | 2020-06-19 00:00:00 | FUS031449 | FU0001001 | 631100 | -11111.1
2020-05-31 00:00:00 | 2020-06-19 00:00:00 | FUS031449 | FU0001001 | 631100 | -11111.1
2020-03-16 00:00:00 | 43942 | BVA20200304 | BA0007001 | 649010 | -10870.39
2020-03-16 00:00:00 | 43942 | BVA20200304 | BA0007001 | 649010 | -10870.39
2020-03-15 00:00:00 | 2020-04-20 00:00:00 | 116758 | SM0012001 | 647200 | -10642
2020-05-15 00:00:00 | 2020-05-27 00:00:00 | 117174 | SM0012001 | 647200 | -10642
2020-04-15 00:00:00 | 2020-05-31 00:00:00 | 116842 | SM0012001 | 647200 | -10642
2020-04-13 00:00:00 | 2020-06-23 00:00:00 | INV357301 | GD0005001 | 644200 | -10500
2020-05-27 00:00:00 | 2020-06-12 00:00:00 | 6031 | HA0001001 | 631100 | -10500
2020-03-31 00:00:00 | 2020-04-24 00:00:00 | FUS029790 | FU0001001 | 631100 | -10000
2020-06-11 00:00:00 | 2020-06-24 00:00:00 | B11852376 | SI0010001 | 644200 | -10000
2020-03-31 00:00:00 | 2020-04-24 00:00:00 | FUS029790 | FU0001001 | 631100 | -9999.99
2020-03-31 00:00:00 | 2020-04-24 00:00:00 | FUS029790 | FU0001001 | 631100 | -9999.99
2020-04-01 00:00:00 | 2020-04-29 00:00:00 | 116755 | SM0012001 | 647200 | -9085
2020-05-01 00:00:00 | 2020-05-27 00:00:00 | 116770 | SM0012001 | 647200 | -9085
2020-04-01 00:00:00 | 2020-04-29 00:00:00 | 116751 | SM0012001 | 647200 | -8892
2020-05-01 00:00:00 | 2020-05-31 00:00:00 | 116762 | SM0012001 | 647200 | -8892
2020-02-29 00:00:00 | 2020-04-24 00:00:00 | FUS028704 | FU0001001 | 631100 | -8500
2020-04-09 00:00:00 | 2020-04-22 00:00:00 | 7174 | LG0007001 | 510700 | -8500
2020-06-04 00:00:00 | 2020-06-10 00:00:00 | IE494808 | CV0001001 | 645600 | -8058
2020-06-12 00:00:00 | 2020-06-12 00:00:00 | IE490381M | CV0001001 | 645600 | -8058
2020-05-01 00:00:00 | 2020-05-14 00:00:00 | 156 | MM0001001 | 631100 | -8000
2020-06-04 00:00:00 | 2020-06-17 00:00:00 | 161 | MM0001001 | 631100 | -8000
2020-05-26 00:00:00 | 2020-05-31 00:00:00 | [PHONE] | TM0003001 | 646000 | -7707.01
2020-05-26 00:00:00 | 2020-05-31 00:00:00 | 950614412-0520A | TM0003001 | 646000 | -7707.01
2020-04-15 00:00:00 | 2020-05-13 00:00:00 | SIN007831 | BT0204001 | 631100 | -7000
2020-05-05 00:00:00 | 2020-05-31 00:00:00 | 32376 | TP0006001 | 511400 | -7000
2020-04-03 00:00:00 | 2020-04-13 00:00:00 | ESPEK40027 | CM0013001 | 620300 | -6642.4
2020-04-09 00:00:00 | 2020-04-16 00:00:00 | ESPEK40027 | CM0013001 | 620300 | -6642.4
2020-05-01 00:00:00 | 2020-05-18 00:00:00 | 7321 | LG0007001 | 511400 | -5768.4
2020-06-16 00:00:00 | 2020-06-24 00:00:00 | 7632 | LG0007001 | 510580 | -5768.4
2020-02-06 00:00:00 | 2020-04-14 00:00:00 | [PHONE] | SM0001020 | 510700 | -5613.83
2020-02-06 00:00:00 | 2020-04-14 00:00:00 | [PHONE] | SM0001020 | 510700 | -5613.83
2020-04-07 00:00:00 | 2020-04-07 00:00:00 | 040720 | TF0006001 | 647400 | -5427
2020-05-04 00:00:00 | 2020-05-04 00:00:00 | 411667611 | TF0006001 | 647400 | -5427
2020-06-05 00:00:00 | 2020-06-18 00:00:00 | 416310738 | TF0006001 | 647400 | -5427
2020-05-19 00:00:00 | 2020-05-22 00:00:00 | B51920-3 | QD0003001 | 645800 | -5140
2020-06-01 00:00:00 | 2020-06-24 00:00:00 | B51920-3A | QD0003001 | 645800 | -5140
2020-04-01 00:00:00 | 2020-04-16 00:00:00 | 1405977 | AP0003001 | 511400 | -5022
2020-05-21 00:00:00 | 2020-05-29 00:00:00 | 1407924 | AP0003001 | 511400 | -5022
2020-06-02 00:00:00 | 2020-06-12 00:00:00 | 1408364 | AP0003001 | 511400 | -5022
2020-02-07 00:00:00 | 2020-06-12 00:00:00 | TT20200207 | CL0013001 | 644200 | -5000
2020-04-30 00:00:00 | 2020-06-17 00:00:00 | NA10778 | HA0002001 | 631100 | -5000
2020-03-24 00:00:00 | 2020-04-25 00:00:00 | 1129 | IE0004001 | 644200 | -5000
2020-04-13 00:00:00 | 2020-04-25 00:00:00 | 1153 | IE0004001 | 644200 | -5000
2020-02-05 00:00:00 | 43945 | 747943 | EN0001001 | 644200 | -4836
2020-04-01 00:00:00 | 43962 | 751191 | EN0001001 | 644200 | -4836
2020-04-01 00:00:00 | 2020-04-09 00:00:00 | 2004-SUP027-01 | PG0004001 | 646200 | -4639.68
2020-05-01 00:00:00 | 2020-05-11 00:00:00 | 2005-SUP027-01 | PG0004001 | 646200 | -4639.68
2020-04-09 00:00:00 | 43936 | 751862 | EN0001001 | 644200 | -4588
2020-04-22 00:00:00 | 43962 | 752787 | EN0001001 | 644200 | -4588
2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 6037 | HA0001001 | 631100 | -4500
2020-04-02 00:00:00 | 2020-04-21 00:00:00 | [PHONE] | LI0007001 | 631100 | -4500
2020-04-01 00:00:00 | 2020-04-30 00:00:00 | 116761 | SM0012001 | 647200 | -4446
2020-04-01 00:00:00 | 2020-04-30 00:00:00 | 116760 | SM0012001 | 647200 | -4446
2020-05-01 00:00:00 | 2020-05-31 00:00:00 | 117169 | SM0012001 | 647200 | -4446
2020-05-01 00:00:00 | 2020-05-31 00:00:00 | 117168 | SM0012001 | 647200 | -4446
2020-05-19 00:00:00 | 2020-05-22 00:00:00 | B51920-3 | QD0003001 | 645800 | -4375
2020-06-01 00:00:00 | 2020-06-24 00:00:00 | B51920-3A | QD0003001 | 645800 | -4375
2020-03-31 00:00:00 | 2020-04-21 00:00:00 | 2020CI-13120 | CP0016001 | 631100 | -4350
2020-04-30 00:00:00 | 2020-05-13 00:00:00 | 2020CI-13149 | CP0016001 | 631100 | -4350
2020-05-31 00:00:00 | 2020-06-09 00:00:00 | 2020CI-13179 | CP0016001 | 631100 | -4350
2020-02-03 00:00:00 | 2020-04-25 00:00:00 | [NAME] | ST0015001 | 644200 | -4350
2020-04-30 00:00:00 | 2020-04-30 00:00:00 | 22004143 | AT0010001 | 620300 | -4265.17
2020-06-15 00:00:00 | 2020-06-17 00:00:00 | 22004191 | AT0010001 | 620300 | -4265.17
2020-05-06 00:00:00 | 2020-05-12 00:00:00 | 11602213 | KI0008001 | 644200 | -4145.96
2020-06-06 00:00:00 | 2020-06-09 00:00:00 | 11614766 | KI0008001 | 644200 | -4145.96
2020-04-29 00:00:00 | 2020-06-09 00:00:00 | M-06887 | CC0038001 | 631100 | -4000
2020-04-29 00:00:00 | 2020-06-09 00:00:00 | M-06887 | CC0038001 | 631100 | -4000
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | M-06992 | CC0038001 | 631100 | -4000
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | M-06992 | CC0038001 | 631100 | -4000
2020-03-31 00:00:00 | 2020-04-10 00:00:00 | 4432 | MT0016001 | 510700 | -4000
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | 4528 | MT0016001 | 510700 | -4000
2020-03-31 00:00:00 | 2020-04-29 00:00:00 | 117014 | SM0012001 | 647200 | -3968.16
2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 117770 | SM0012001 | 647200 | -3968.16
2020-03-31 00:00:00 | 2020-04-10 00:00:00 | 4432 | MT0016001 | 510700 | -3800
2020-03-31 00:00:00 | 2020-04-10 00:00:00 | 4432 | MT0016001 | 510700 | -3800
2020-03-31 00:00:00 | 2020-04-10 00:00:00 | 4432 | MT0016001 | 510700 | -3800
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | 4528 | MT0016001 | 510700 | -3800
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | 4528 | MT0016001 | 510700 | -3800
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | 4528 | MT0016001 | 510700 | -3800
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | 4528 | MT0016001 | 510700 | -3800
2020-05-29 00:00:00 | 2020-06-12 00:00:00 | 4528 | MT0016001 | 510700 | -3800
2020-05-13 00:00:00 | 43964 | 754137 | EN0001001 | 644200 | -3720
2020-05-21 00:00:00 | 43973 | 754698 | EN0001001 | 644200 | -3720
2020-05-28 00:00:00 | 43980 | 754984 | EN0001001 | 644200 | -3720
2020-06-11 00:00:00 | 44007 | 756142 | EN0001001 | 644200 | -3720
2020-06-18 00:00:00 | 44007 | 756722 | EN0001001 | 644200 | -3720
2020-04-30 00:00:00 | 2020-05-12 00:00:00 | 4481 | MT0016001 | 510700 | -3627
2020-04-30 00:00:00 | 2020-05-12 00:00:00 | 4481 | MT0016001 | 510700 | -3627
2020-04-30 00:00:00 | 2020-05-12 00:00:00 | 4481 | MT0016001 | 510700 | -3627
2020-04-20 00:00:00 | 2020-04-22 00:00:00 | 22004075 | AT0010001 | 620300 | -3547.18
2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 22004078 | AT0010001 | 620300 | -3547.18
2020-03-09 00:00:00 | 2020-04-29 00:00:00 | 3792 | BB0004001 | 644200 | -3500
2020-03-17 00:00:00 | 2020-04-17 00:00:00 | 8144767 | IP0003001 | 631100 | -3500
2020-03-31 00:00:00 | 2020-04-10 00:00:00 | 4432 | MT0016001 | 510700 | -3500
2020-06-01 00:00:00 | 2020-06-05 00:00:00 | B51920-5A | QD0003001 | 645800 | -3500
2020-04-30 00:00:00 | 2020-04-30 00:00:00 | 22004143 | AT0010001 | 620300 | -3364.24
2020-06-15 00:00:00 | 2020-06-17 00:00:00 | 22004191 | AT0010001 | 620300 | -3364.24
2020-04-01 00:00:00 | 2020-04-29 00:00:00 | 116766 | SM0012001 | 647200 | -3335
2020-05-01 00:00:00 | 2020-05-27 00:00:00 | 117172 | SM0012001 | 647200 | -3335
2020-02-29 00:00:00 | 2020-04-06 00:00:00 | 116438 | SM0012001 | 647200 | -3300.72
2020-03-31 00:00:00 | 2020-04-29 00:00:00 | 117022 | SM0012001 | 647200 | -3300.72
2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 117771 | SM0012001 | 647200 | -3300.72
2020-05-15 00:00:00 | 43972 | [PHONE] | OD0001001 | 649010 | -3256.63
2020-05-15 00:00:00 | 43972 | [PHONE] | OD0001001 | 649010 | -3256.63
2020-05-15 00:00:00 | 43972 | [PHONE] | OD0001001 | 649010 | -3256.63
2020-05-15 00:00:00 | 43981 | [PHONE] | OD0001001 | 649010 | -3256.63
2020-05-18 00:00:00 | 43981 | [PHONE] | OD0001001 | 649010 | -3256.63
2020-03-31 00:00:00 | 2020-04-08 00:00:00 | 91259844 | KH0001001 | 511400 | -3230.96
2020-05-27 00:00:00 | 2020-05-30 00:00:00 | 91328125 | KH0001001 | 511400 | -3230.96
2020-06-24 00:00:00 | 2020-06-30 00:00:00 | 91362537 | KH0001001 | 510580 | -3230.96
2020-04-01 00:00:00 | 2020-04-21 00:00:00 | F-202004-011 | FI0004001 | 649040 | -3200
2020-03-17 00:00:00 | 2020-04-17 00:00:00 | 8144766 | IP0003001 | 631100 | -3200
2020-06-22 00:00:00 | 2020-06-24 00:00:00 | B51920-7 | QD0003001 | 645800 | -3200
2020-06-23 00:00:00 | 2020-06-24 00:00:00 | B51920-11 | QD0003001 | 645800 | -3200
2020-05-05 00:00:00 | 2020-05-18 00:00:00 | 7334 | LG0007001 | 511400 | -3172
2020-05-12 00:00:00 | 2020-05-18 00:00:00 | 7384 | LG0007001 | 511400 | -3172
2020-05-27 00:00:00 | 2020-05-29 00:00:00 | 7467 | LG0007001 | 511400 | -3172
2020-06-23 00:00:00 | 2020-06-30 00:00:00 | 7676 | LG0007001 | 511400 | -3172
2020-04-13 00:00:00 | 2020-04-17 00:00:00 | 7079 | LG0007001 | 511400 | -3092
2020-04-06 00:00:00 | 2020-04-17 00:00:00 | 7077 | LG0007001 | 511400 | -3092
2020-03-06 00:00:00 | 2020-04-15 00:00:00 | 10-0409 | AD0008001 | 620390 | -3000
2020-04-08 00:00:00 | 2020-04-15 00:00:00 | [PHONE] | AT0005001 | 647400 | -3000
2020-04-08 00:00:00 | 2020-04-15 00:00:00 | [PHONE] | AT0005001 | 647400 | -3000
2020-05-06 00:00:00 | 2020-05-26 00:00:00 | [PHONE] | AT0005001 | 647400 | -3000
2020-06-08 00:00:00 | 2020-06-22 00:00:00 | [PHONE] | AT0005001 | 647400 | -3000
2020-04-15 00:00:00 | 2020-05-13 00:00:00 | SIN007831 | BT0204001 | 631100 | -3000
2020-05-31 00:00:00 | 2020-06-19 00:00:00 | FUS031261 | FU0001001 | 631100 | -3000
2020-05-27 00:00:00 | 2020-06-12 00:00:00 | 6031 | HA0001001 | 631100 | -3000
2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 6037 | HA0001001 | 631100 | -3000
2020-03-24 00:00:00 | 2020-04-25 00:00:00 | 1129 | IE0004001 | 644200 | -3000
2020-04-13 00:00:00 | 2020-04-25 00:00:00 | 1153 | IE0004001 | 644200 | -3000
2020-06-15 00:00:00 | 2020-06-24 00:00:00 | SJ11072 | NB0006001 | 644200 | -3000
2020-06-23 00:00:00 | 2020-06-24 00:00:00 | B51920-9 | QD0003001 | 645800 | -3000
2020-03-17 00:00:00 | 2020-05-12 00:00:00 | [PHONE] | SM0001020 | 510700 | -3000
2020-03-17 00:00:00 | 2020-05-12 00:00:00 | [PHONE] | SM0001020 | 510700 | -3000
2020-03-17 00:00:00 | 2020-05-12 00:00:00 | [PHONE] | SM0001020 | 510700 | -3000
2020-03-17 00:00:00 | 2020-05-12 00:00:00 | [PHONE] | SM0001020 | 510700 | -3000
2020-03-17 00:00:00 | 2020-05-12 00:00:00 | [PHONE] | SM0001020 | 510700 | -3000
2020-04-10 00:00:00 | 2020-04-17 00:00:00 | 7129 | LG0007001 | 511400 | -2920
2020-05-26 00:00:00 | 2020-05-28 00:00:00 | 7429 | LG0007001 | 511400 | -2920
2020-06-08 00:00:00 | 2020-06-24 00:00:00 | 7503 | LG0007001 | 511400 | -2920