Spreadsheet: 879917d1727514825-formula-to-find-and-match-invoice-numbers-and-amount-compare-invoices
Sheet: CUSTOMER PAYMENT

InvoiceNumber | Date | [NAME] | Remarks
MLS23234 | 2024-04-30 00:00:00 | 59.95
MLS23235 | 2024-04-30 00:00:00 | 65.95
MLS23273 | 2024-05-02 00:00:00 | 288.44
MLS23275 | 2024-05-02 00:00:00 | 403.02
MLS23379 | 2024-05-16 00:00:00 | 480.57
MLS23381 | 2024-05-16 00:00:00 | 441.26
MLS23394 | 2024-05-20 00:00:00 | 4255.69
MLS23395 | 2024-05-20 00:00:00 | 2623.73
MLS23396 | 2024-05-20 00:00:00 | 3498.74
MLS23397 | 2024-05-20 00:00:00 | 5328.39
MLS23398 | 2024-05-21 00:00:00 | 575.52
MLS23399 | 2024-05-21 00:00:00 | 201.43
MLS23400 | 2024-05-21 00:00:00 | 1636.64
MLS23401 | 2024-05-21 00:00:00 | 1318.9
MLS23402 | 2024-05-21 00:00:00 | 19.18
MLS23403 | 2024-05-21 00:00:00 | 131.89
MLS23404 | 2024-05-21 00:00:00 | 17.44
MLS23405 | 2024-05-21 00:00:00 | 135.16
MLS23406 | 2024-05-21 00:00:00 | 3021.48
MLS23407 | 2024-05-21 00:00:00 | 726.11
MLS23408 | 2024-05-21 00:00:00 | 797.34
MLS23409 | 2024-05-21 00:00:00 | 799.43
MLS23410 | 2024-05-21 00:00:00 | 899.25
MLS23411 | 2024-05-21 00:00:00 | 44.96
MLS23412 | 2024-05-21 00:00:00 | 179.85
MLS23413 | 2024-05-21 00:00:00 | 3471.11
MLS23414 | 2024-05-21 00:00:00 | 2457.95
MLS23415 | 2024-05-21 00:00:00 | 1498.75
MLS23416 | 2024-05-21 00:00:00 | 59.95
MLS23417 | 2024-05-21 00:00:00 | 1199
[NAME] | 2024-05-21 00:00:00 | 959.2
MLS23419 | 2024-05-21 00:00:00 | 269.48
MLS23420 | 2024-05-21 00:00:00 | 147.81
MLS23421 | 2024-05-21 00:00:00 | 317.36
MLS23422 | 2024-05-21 00:00:00 | 296.71
MLS23423 | 2024-05-21 00:00:00 | 49.05
MLS23429 | 2024-05-28 00:00:00 | 2263.24
MLS23430 | 2024-05-28 00:00:00 | 1394.74
MLS23431 | 2024-05-28 00:00:00 | 2121.27
MLS23432 | 2024-05-28 00:00:00 | 2549.74
MLS23433 | 2024-05-28 00:00:00 | 2383.61
MLS23434 | 2024-05-28 00:00:00 | 2282.9
MLS23435 | 2024-05-28 00:00:00 | 1980.75
MLS23436 | 2024-05-28 00:00:00 | 1577.88
MLS23437 | 2024-05-28 00:00:00 | 1208.59
[NAME] | 2024-05-28 00:00:00 | 1189.41
MLS23439 | 2024-05-28 00:00:00 | 839.3
MLS23440 | 2024-05-28 00:00:00 | 1947.18
MLS23441 | 2024-05-29 00:00:00 | 268.69
MLS23442 | 2024-05-29 00:00:00 | 2182.18
MLS23443 | 2024-05-29 00:00:00 | 1750.54
MLS23444 | 2024-05-29 00:00:00 | 105.34
MLS23445 | 2024-05-29 00:00:00 | 270.32
MLS23446 | 2024-05-29 00:00:00 | 3117.4
MLS23447 | 2024-05-29 00:00:00 | 923.59
MLS23448 | 2024-05-29 00:00:00 | 797.34
MLS23449 | 2024-05-29 00:00:00 | 1041.59
MLS23450 | 2024-05-29 00:00:00 | 899.25
MLS23451 | 2024-05-29 00:00:00 | 2627.99
MLS23452 | 2024-05-29 00:00:00 | 2937.55
MLS23453 | 2024-05-29 00:00:00 | 5448.26
MLS23454 | 2024-05-29 00:00:00 | 2038.3
MLS23455 | 2024-05-29 00:00:00 | 839.3
MLS23456 | 2024-05-29 00:00:00 | 119.9
MLS23457 | 2024-05-29 00:00:00 | 3656.95
MLS23458 | 2024-05-29 00:00:00 | 839.3
MLS23459 | 2024-05-29 00:00:00 | 148.17 | Short paid $55.39/ Bal $92.78
[NAME] | 2024-05-29 00:00:00 | 122.58
MLS23461 | 2024-05-29 00:00:00 | 342.88
[NAME] | 2024-05-29 00:00:00 | 381.95
MLS23463 | 2024-05-29 00:00:00 | 1362.5
MLS23464 | 2024-05-29 00:00:00 | 550.01
MLS23465 | 2024-05-29 00:00:00 | 878.38 | Short paid $878.37/ Bal $0.01
MLS23466 | 2024-05-29 00:00:00 | 303.3
MLS23467 | 2024-05-29 00:00:00 | 899.02
MLS23468 | 2024-05-29 00:00:00 | 390.55
MLS23469 | 2024-05-29 00:00:00 | 1034.98
MLS23470 | 2024-05-29 00:00:00 | 83.35
MLS23471 | 2024-05-29 00:00:00 | 417.49
MLS23472 | 2024-05-30 00:00:00 | 1280.01
MLS23473 | 2024-05-30 00:00:00 | 1157.66
MLS23474 | 2024-05-30 00:00:00 | 1809.8
MLS23475 | 2024-05-30 00:00:00 | 3746.91
MLS23479 | 2024-05-30 00:00:00 | 201.63
[NAME] | 2024-05-30 00:00:00 | 1619.13
MLS23481 | 2024-05-30 00:00:00 | 68.13
[NAME] | 2024-05-30 00:00:00 | 72.75
MLS23516 | 2024-06-04 00:00:00 | 191.7
MLS23517 | 2024-06-04 00:00:00 | 1378.85
MLS23518 | 2024-06-04 00:00:00 | 1366.86
MLS23519 | 2024-06-04 00:00:00 | 201.96
[NAME] | 2024-06-04 00:00:00 | 659.45
MLS23521 | 2024-06-04 00:00:00 | 140.95
MLS23522 | 2024-06-04 00:00:00 | 337.9
MLS23523 | 2024-06-04 00:00:00 | 2733.72
MLS23524 | 2024-06-04 00:00:00 | 880.81
MLS23525 | 2024-06-04 00:00:00 | 797.34
MLS23526 | 2024-06-04 00:00:00 | 1578.2
MLS23527 | 2024-06-04 00:00:00 | 1258.95
MLS23528 | 2024-06-04 00:00:00 | 2623.82
MLS23529 | 2024-06-04 00:00:00 | 2398
MLS23530 | 2024-06-04 00:00:00 | 2628.21
MLS23531 | 2024-06-04 00:00:00 | 1798.5
MLS23532 | 2024-06-04 00:00:00 | 1019.15
[NAME] | 2024-06-04 00:00:00 | 899.25
MLS23534 | 2024-06-04 00:00:00 | 342.27
MLS23535 | 2024-06-04 00:00:00 | 281.63
MLS23536 | 2024-06-04 00:00:00 | 445.69
MLS23537 | 2024-06-04 00:00:00 | 404.4
MLS23538 | 2024-06-04 00:00:00 | 49.05
MLS23539 | 2024-06-04 00:00:00 | 49.05
MLS23540 | 2024-06-04 00:00:00 | 49.05
MLS23548 | 2024-06-05 00:00:00 | 2862.95
MLS23549 | 2024-06-05 00:00:00 | 1866.45
MLS23550 | 2024-06-05 00:00:00 | 2745.4
MLS23551 | 2024-06-05 00:00:00 | 3347.83
MLS23552 | 2024-06-05 00:00:00 | 559.61
MLS23553 | 2024-06-05 00:00:00 | 1711.41 | Short paid $1,580.96/ Bal $130.45
MLS23554 | 2024-06-05 00:00:00 | 949.84
MLS23555 | 2024-06-05 00:00:00 | 695.93
MLS23560 | 2024-06-13 00:00:00 | 278.17
MLS23561 | 2024-06-13 00:00:00 | 2260.12
MLS23562 | 2024-06-13 00:00:00 | 271.98
MLS23563 | 2024-06-13 00:00:00 | 593.51
MLS23564 | 2024-06-13 00:00:00 | 349.78
MLS23565 | 2024-06-13 00:00:00 | 540.64
MLS23566 | 2024-06-13 00:00:00 | 3309.24
MLS23567 | 2024-06-13 00:00:00 | 179.85
MLS23568 | 2024-06-13 00:00:00 | 1274.74
MLS23569 | 2024-06-13 00:00:00 | 1139.05
MLS23570 | 2024-06-13 00:00:00 | 1618.65
MLS23571 | 2024-06-13 00:00:00 | 59.95
MLS23572 | 2024-06-13 00:00:00 | 239.8
MLS23573 | 2024-06-13 00:00:00 | 3559.13
MLS23574 | 2024-06-13 00:00:00 | 3477.1
MLS23575 | 2024-06-13 00:00:00 | 3616.18
[NAME] | 2024-06-13 00:00:00 | 6834.3
MLS23577 | 2024-06-13 00:00:00 | 1199
MLS23578 | 2024-06-13 00:00:00 | 81.53 | Overpaid by $0.01
[NAME] | 2024-06-13 00:00:00 | 7733.55
MLS23580 | 2024-06-13 00:00:00 | 839.3
MLS23581 | 2024-06-13 00:00:00 | 2553.87
MLS23582 | 2024-06-13 00:00:00 | 1882.84
MLS23583 | 2024-06-13 00:00:00 | 536.78
MLS23584 | 2024-06-13 00:00:00 | 191.4
MLS23585 | 2024-06-13 00:00:00 | 594.26 | Short paid $410.32/ Bal $183.94
MLS23586 | 2024-06-13 00:00:00 | 551.92
MLS23587 | 2024-06-13 00:00:00 | 49.05
MLS23588 | 2024-06-13 00:00:00 | 49.05
MLS23589 | 2024-06-13 00:00:00 | 49.05
[NAME] | 2024-06-14 00:00:00 | 7048.51
MLS23591 | 2024-06-14 00:00:00 | 5935.05
MLS23592 | 2024-06-14 00:00:00 | 4739.37
MLS23593 | 2024-06-14 00:00:00 | 3776.85
MLS23594 | 2024-06-14 00:00:00 | 287.76
MLS23595 | 2024-06-14 00:00:00 | 2472.94
MLS23596 | 2024-06-14 00:00:00 | 4970.4
MLS23597 | 2024-06-14 00:00:00 | 119.9
MLS23598 | 2024-06-14 00:00:00 | 872
MLS23599 | 2024-06-14 00:00:00 | 120.4
[NAME] | 2024-06-14 00:00:00 | 436
MLS23601 | 2024-06-14 00:00:00 | 959.2
MLS23602 | 2024-06-14 00:00:00 | 6191.2
MLS23603 | 2024-06-14 00:00:00 | 1817.76
MLS23604 | 2024-06-14 00:00:00 | 1220.8
MLS23605 | 2024-06-14 00:00:00 | 49.05
MLS23606 | 2024-06-14 00:00:00 | 218
MLS23616 | 2024-06-21 00:00:00 | 4604.41
[NAME] | 2024-06-21 00:00:00 | 1701.86
MLS23618 | 2024-06-21 00:00:00 | 4061.65
MLS23619 | 2024-06-21 00:00:00 | 4792.28
[NAME] | 2024-04-19 00:00:00 | 15 | Previously short paid, full payment completed
MLS23173 | 2024-04-19 00:00:00 | 59.95 | Previously short paid, full payment completed
MLS23278 | 2024-05-06 00:00:00 | 1604.8 | Previously short paid, full payment completed
MLS23294 | 2024-05-07 00:00:00 | 260.7 | Previously short paid, full payment completed
[NAME] | 2024-06-13 00:00:00 | 2182.18 | Already paid in full in Sch-75
MLS23620 | 2024-06-24 00:00:00 | 143.88
MLS23621 | 2024-06-24 00:00:00 | 1169.03
MLS23622 | 2024-06-24 00:00:00 | 1846.46
MLS23623 | 2024-06-24 00:00:00 | 89.49
MLS23624 | 2024-06-24 00:00:00 | 365.7
[NAME] | 2024-06-24 00:00:00 | 220.06
MLS23626 | 2024-06-24 00:00:00 | 337.9
MLS23627 | 2024-06-24 00:00:00 | 2597.3
MLS23628 | 2024-06-24 00:00:00 | 943.69
MLS23629 | 2024-06-24 00:00:00 | 797.34
MLS23630 | 2024-06-24 00:00:00 | 1110.33
MLS23631 | 2024-06-24 00:00:00 | 899.25
MLS23632 | 2024-06-24 00:00:00 | 1741.75
MLS23633 | 2024-06-24 00:00:00 | 2038.3
MLS23634 | 2024-06-24 00:00:00 | 1969.96
MLS23635 | 2024-06-24 00:00:00 | 719.4
[NAME] | 2024-06-24 00:00:00 | 1079.1
[NAME] | 2024-06-24 00:00:00 | 719.4
MLS23638 | 2024-06-24 00:00:00 | 224.73
MLS23639 | 2024-06-24 00:00:00 | 148.02
MLS23640 | 2024-06-24 00:00:00 | 256.48
[NAME] | 2024-06-24 00:00:00 | 263.57
MLS23642 | 2024-06-24 00:00:00 | 49.05
[NAME] | 2024-06-24 00:00:00 | 1635
MLS23644 | 2024-06-24 00:00:00 | 1850.51
MLS23645 | 2024-06-24 00:00:00 | 1034.72
MLS23646 | 2024-06-24 00:00:00 | 2176.29
MLS23647 | 2024-06-24 00:00:00 | 2484.28
MLS23653 | 2024-06-26 00:00:00 | 105.51
MLS23654 | 2024-06-26 00:00:00 | 857.29
MLS23655 | 2024-06-26 00:00:00 | 1043.13
MLS23656 | 2024-06-26 00:00:00 | 376.94
MLS23657 | 2024-06-26 00:00:00 | 761.37
MLS23658 | 2024-06-26 00:00:00 | 186.02
MLS23659 | 2024-06-26 00:00:00 | 540.64
MLS23660 | 2024-06-26 00:00:00 | 4268.44
MLS23661 | 2024-06-26 00:00:00 | 627.53
MLS23662 | 2024-06-26 00:00:00 | 569.53
[NAME] | 2024-06-26 00:00:00 | 1027.27
[NAME] | 2024-06-26 00:00:00 | 899.25
MLS23665 | 2024-06-26 00:00:00 | 104.92 | over paid by $0.01
MLS23666 | 2024-06-26 00:00:00 | 239.8
MLS23667 | 2024-06-26 00:00:00 | 2603.47
[NAME] | 2024-06-26 00:00:00 | 2877.6
MLS23669 | 2024-06-26 00:00:00 | 4604.16
MLS23670 | 2024-06-26 00:00:00 | 4376.35
MLS23671 | 2024-06-26 00:00:00 | 1498.75
MLS23672 | 2024-06-26 00:00:00 | 359.7
MLS23673 | 2024-06-26 00:00:00 | 1978.35 | Actual amt $5755.20, Bal $3776.85
MLS23674 | 2024-06-26 00:00:00 | 1738.55
MLS23675 | 2024-06-26 00:00:00 | 182.23 | Actual amt $473.31, Bal $291.08
MLS23676 | 2024-06-26 00:00:00 | 195.71
MLS23677 | 2024-06-26 00:00:00 | 755.48
MLS23678 | 2024-06-26 00:00:00 | 532.29
MLS23679 | 2024-06-26 00:00:00 | 49.05
MLS23682 | 2024-06-28 00:00:00 | 749.7
MLS23684 | 2024-06-28 00:00:00 | 212.08
MLS23685 | 2024-06-28 00:00:00 | 726.84
MLS23686 | 2024-06-28 00:00:00 | 396.61
MLS23687 | 2024-06-28 00:00:00 | 388.73
MLS23688 | 2024-06-28 00:00:00 | 445.5
MLS23689 | 2024-06-28 00:00:00 | 151.51
MLS23725 | 2024-07-08 00:00:00 | 503.58
MLS23726 | 2024-07-08 00:00:00 | 1007.16
[NAME] | 2024-07-08 00:00:00 | 1242.16
MLS23728 | 2024-07-08 00:00:00 | 1141.45
MLS23729 | 2024-07-08 00:00:00 | 182.25
MLS23730 | 2024-07-08 00:00:00 | 1402.83
MLS23731 | 2024-07-08 00:00:00 | 1121.07 | Actual amt $2182.18, Bal $1061.11
MLS23732 | 2024-07-08 00:00:00 | 352.7
MLS23733 | 2024-07-08 00:00:00 | 509.58
MLS23734 | 2024-07-08 00:00:00 | 371.23
MLS23735 | 2024-07-08 00:00:00 | 473.06
MLS23737 | 2024-07-08 00:00:00 | 149.88
MLS23738 | 2024-07-08 00:00:00 | 1337.26
MLS23739 | 2024-07-08 00:00:00 | 1025.15
MLS23740 | 2024-07-08 00:00:00 | 1032.84
MLS23741 | 2024-07-08 00:00:00 | 899.25
[NAME] | 2024-07-08 00:00:00 | 153.64
[NAME] | 2024-07-08 00:00:00 | 299.75
MLS23744 | 2024-07-08 00:00:00 | 2083.85
MLS23745 | 2024-07-08 00:00:00 | 2158.2
MLS23746 | 2024-07-08 00:00:00 | 2510.71
[NAME] | 2024-07-08 00:00:00 | 3237.3
MLS23750 | 2024-07-08 00:00:00 | 19.18 | Actual amt $38.37, Bal $19.19
MLS23751 | 2024-07-08 00:00:00 | 3357.2
[NAME] | 2024-07-08 00:00:00 | 599.5
MLS23753 | 2024-07-08 00:00:00 | 1560 | Actual amt $2758.25, Bal $1198.25
[NAME] | 2024-07-08 00:00:00 | 1210.22
MLS23755 | 2024-07-08 00:00:00 | 2162.37 | Actual amt $3308.14, Bal $1145.77
[NAME] | 2024-07-08 00:00:00 | 198.28 | Actual amt $359.89, Bal $161.61
MLS23758 | 2024-07-08 00:00:00 | 126.58
MLS23759 | 2024-07-08 00:00:00 | 334.1 | Actual amt $459.71, Bal $125.61
MLS23760 | 2024-07-08 00:00:00 | 400.19
[NAME] | 2024-07-11 00:00:00 | 149.88
MLS23778 | 2024-07-11 00:00:00 | 436
MLS23779 | 2024-07-11 00:00:00 | 120.6
MLS23780 | 2024-07-11 00:00:00 | 697.6
MLS23781 | 2024-07-11 00:00:00 | 817.23
MLS23782 | 2024-07-11 00:00:00 | 5057.6
MLS23784 | 2024-07-11 00:00:00 | 784.8
MLS23785 | 2024-07-11 00:00:00 | 2393.91
MLS23786 | 2024-07-11 00:00:00 | 4708.8
MLS23791 | 2024-07-15 00:00:00 | 404.16
MLS23792 | 2024-07-15 00:00:00 | 2338.05
MLS23793 | 2024-07-15 00:00:00 | 1486.76
MLS23794 | 2024-07-15 00:00:00 | 309.63
MLS23795 | 2024-07-15 00:00:00 | 965.2
MLS23796 | 2024-07-15 00:00:00 | 173.75
MLS23797 | 2024-07-15 00:00:00 | 481.78
MLS23798 | 2024-07-15 00:00:00 | 4388.34
MLS23799 | 2024-07-15 00:00:00 | 44.96
MLS23800 | 2024-07-15 00:00:00 | 1171.1
MLS23801 | 2024-07-15 00:00:00 | 911.24
[NAME] | 2024-07-15 00:00:00 | 1718.4
MLS23803 | 2024-07-15 00:00:00 | 1258.95
MLS23804 | 2024-07-15 00:00:00 | 94.6
MLS23805 | 2024-07-15 00:00:00 | 239.8
MLS23806 | 2024-07-15 00:00:00 | 3208.01
MLS23807 | 2024-07-15 00:00:00 | 3417.15
MLS23808 | 2024-07-15 00:00:00 | 4240.86
MLS23809 | 2024-07-15 00:00:00 | 659.45
MLS23810 | 2024-07-15 00:00:00 | 59.95
MLS23811 | 2024-07-15 00:00:00 | 959.2
[NAME] | 2024-07-15 00:00:00 | 1738.55
MLS23813 | 2024-07-15 00:00:00 | 231.88 | Actual amt $340.30, Bal $108.42
MLS23815 | 2024-07-15 00:00:00 | 427.11 | Actual amt $589.74, Bal $162.63
MLS23821 | 2024-07-16 00:00:00 | 114.24
MLS23822 | 2024-07-16 00:00:00 | 451.6
MLS23823 | 2024-07-16 00:00:00 | 841
MLS23825 | 2024-07-16 00:00:00 | 55.63
MLS23826 | 2024-07-16 00:00:00 | 176.11
MLS23827 | 2024-07-17 00:00:00 | 1932.29 | Actual amt $2823.44, Bal $891.15
MLS23829 | 2024-07-17 00:00:00 | 3049.53 | Actual amt $4349.29, Bal $1299.76
MLS-CN0764 | 2024-07-18 00:00:00 | -34.17
MLS-CN0765 | 2024-07-19 00:00:00 | -59.95
MLS-CN757 | 2024-07-20 00:00:00 | -59.95
MLS-CN758 | 2024-07-21 00:00:00 | -20.56
MLS-CN759 | 2024-07-22 00:00:00 | -48.13
MLS-CN760 | 2024-07-23 00:00:00 | -11.99
MLS-CN761 | 2024-07-24 00:00:00 | -65.95