Spreadsheet: 843090d1695052019-automation-with-vlookup-data-file
Sheet: Export

Seq | CustomerRefNum | Customer No | Customer Name | Invoice Date | Amt Billed | Amt Paid | [NAME] | Delivery Date | Days Old
PO3823928 | PDQ384909 | 5005 | Customer 5 | 2023-09-05 00:00:00 | 349.08 | 0 | 349.08 |  | 13
PO3821978 | PDQ383966 | 5005 | Customer 5 | 2023-08-30 00:00:00 | 774.73 | 0 | 774.73 |  | 19
PO3828171 | PDQ384235 | 10001 | Customer 1 | 2023-08-31 00:00:00 | 211.25 | 0 | 211.25 |  | 18
PO3815499 | PDQ377457 | 10001 | Customer 1 | 2023-07-26 00:00:00 | 566.42 | 0 | 566.42 |  | 54
PO3811671 | PDQ372345 | 10001 | Customer 1 | 2023-06-26 00:00:00 | 694 | 0 | 694 |  | 84
PO3816733 | PDQ377029 | 10001 | Customer 1 | 2023-07-24 00:00:00 | 794 | 0 | 794 |  | 56
PO3805539 | PDQ376588 | 10001 | Customer 1 | 2023-07-20 00:00:00 | 895.28 | 0 | 895.28 |  | 60
PO3829123 | PDQ386061 | 10001 | Customer 1 | 2023-09-12 00:00:00 | 919 | 0 | 919 |  | 6
PO3815518 | PDQ377027 | 10001 | Customer 1 | 2023-07-24 00:00:00 | 1184 | 0 | 1184 |  | 56
PO3814402 | PDQ376746 | 10001 | Customer 1 | 2023-07-21 00:00:00 | 1541 | 0 | 1541 |  | 59
PO3826731 | PDQ385034 | 10001 | Customer 1 | 2023-09-05 00:00:00 | 3441 | 0 | 3441 |  | 13
PO3760276 | PDQ332948 | 30003 | Customer 3 | 2022-11-30 00:00:00 | 2848 | 2698 | 150 |  | 292
PO3784252 | PDQ358659 | 30003 | Customer 3 | 2023-04-11 00:00:00 | 300 | 150 | 150 |  | 160
PO3739652 | PDQ326047 | 30003 | Customer 3 | 2022-10-24 00:00:00 | 250 | 0 | 250 |  | 329
PO3757190 | PDQ329565 | 30003 | Customer 3 | 2022-11-09 00:00:00 | 250 | 0 | 250 |  | 313
PO3757646 | PDQ329566 | 30003 | Customer 3 | 2022-11-09 00:00:00 | 250 | 0 | 250 |  | 313
PO3788824 | PDQ358228 | 30003 | Customer 3 | 2023-04-10 00:00:00 | 799 | 549 | 250 |  | 161
PO3821578 | PDQ382166 | 30003 | Customer 3 | 2023-08-22 00:00:00 | 250 | 0 | 250 |  | 27
PO3822138 | PDQ383976 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 250 | 0 | 250 |  | 19
PO3825622 | PDQ385852 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 250 | 0 | 250 |  | 7
PO3766689 | PDQ335493 | 30003 | Customer 3 | 2022-12-13 00:00:00 | 2873 | 2598 | 275 |  | 279
PO3818061 | PDQ380007 | 30003 | Customer 3 | 2023-08-09 00:00:00 | 300 | 0 | 300 |  | 40
PO3756713 | PDQ330164 | 30003 | Customer 3 | 2022-11-11 00:00:00 | 4243 | 3743 | 500 |  | 311
PO3822132 | PDQ382788 | 30003 | Customer 3 | 2023-08-24 00:00:00 | 519 | 0 | 519 |  | 25
PO3821896 | PDQ382472 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 524 | 0 | 524 |  | 26
PO3821897 | PDQ382787 | 30003 | Customer 3 | 2023-08-24 00:00:00 | 538 | 0 | 538 |  | 25
PO3823338 | PDQ383981 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 559 | 0 | 559 |  | 19
PO3826504 | PDQ385845 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 569 | 0 | 569 |  | 7
PO3826321 | PDQ385842 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 579 | 0 | 579 |  | 7
PO3826339 | [NAME] | 30003 | Customer 3 | 2023-09-11 00:00:00 | 579 | 0 | 579 |  | 7
PO3826703 | PDQ385846 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 579 | 0 | 579 |  | 7
PO3826707 | PDQ385847 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 579 | 0 | 579 |  | 7
PO3828725 | PDQ385190 | 30003 | Customer 3 | 2023-09-06 00:00:00 | 579 | 0 | 579 |  | 12
PO3823191 | PDQ384041 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 639 | 0 | 639 |  | 19
PO3823209 | PDQ383980 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 649 | 0 | 649 |  | 19
PO3774126 | [NAME] | 30003 | Customer 3 | 2023-02-21 00:00:00 | 3145 | 2495 | 650 |  | 209
PO3826826 | PDQ385848 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 669 | 0 | 669 |  | 7
PO3822184 | PDQ382789 | 30003 | Customer 3 | 2023-08-24 00:00:00 | 679 | 0 | 679 |  | 25
PO3820943 | PDQ382463 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 698 | 0 | 698 |  | 26
PO3823339 | PDQ384025 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 698 | 0 | 698 |  | 19
PO3825355 | PDQ384028 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 698 | 0 | 698 |  | 19
PO3826094 | PDQ384995 | 30003 | Customer 3 | 2023-09-05 00:00:00 | 698 | 0 | 698 |  | 13
PO3826379 | PDQ384996 | 30003 | Customer 3 | 2023-09-05 00:00:00 | 698 | 0 | 698 |  | 13
PO3820941 | PDQ382461 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 724 | 0 | 724 |  | 26
PO3820942 | [NAME] | 30003 | Customer 3 | 2023-08-23 00:00:00 | 724 | 0 | 724 |  | 26
PO3821588 | PDQ382470 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 729 | 0 | 729 |  | 26
PO3823450 | PDQ384026 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 729 | 0 | 729 |  | 19
PO3820939 | PDQ382460 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 739 | 0 | 739 |  | 26
PO3820946 | PDQ382464 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 739 | 0 | 739 |  | 26
PO3823451 | PDQ384027 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 739 | 0 | 739 |  | 19
PO3819952 | PDQ382456 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 844 | 0 | 844 |  | 26
PO3812784 | PDQ384328 | 30003 | Customer 3 | 2023-08-31 00:00:00 | 847 | 0 | 847 |  | 18
PO3815386 | PDQ381841 | 30003 | Customer 3 | 2023-08-18 00:00:00 | 847 | 0 | 847 |  | 31
PO3822060 | PDQ382474 | 30003 | Customer 3 | 2023-08-23 00:00:00 | 847 | 0 | 847 |  | 26
PO3823245 | PDQ386557 | 30003 | Customer 3 | 2023-09-14 00:00:00 | 847 | 0 | 847 |  | 4
PO3823503 | PDQ383485 | 30003 | Customer 3 | 2023-08-28 00:00:00 | 847 | 0 | 847 |  | 21
PO3824168 | PDQ384032 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 847 | 0 | 847 |  | 19
PO3824829 | PDQ384033 | 30003 | Customer 3 | 2023-08-30 00:00:00 | 847 | 0 | 847 |  | 19
PO3825681 | PDQ385839 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 847 | 0 | 847 |  | 7
PO3826394 | PDQ385844 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 847 | 0 | 847 |  | 7
PO3828385 | PDQ385913 | 30003 | Customer 3 | 2023-09-11 00:00:00 | 847 | 0 | 847 |  | 7
PO3828692 | PDQ385311 | 30003 | Customer 3 | 2023-09-06 00:00:00 | 847 | 0 | 847 |  | 12
PO3822496 | PDQ383086 | 30003 | Customer 3 | 2023-08-25 00:00:00 | 889 | 0 | 889 |  | 24
PO3767883 | PDQ342303 | 30003 | Customer 3 | 2023-01-19 00:00:00 | 5198 | 4298 | 900 |  | 242
PO3828691 | PDQ385064 | 30003 | Customer 3 | 2023-09-05 00:00:00 | 929 | 0 | 929 |  | 13
PO3820562 | PDQ381156 | 4004 | Cutstomer 4 | 2023-08-15 00:00:00 | 487 | 0 | 487 |  | 34
PO3825904 | PDQ384871 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 487 | 0 | 487 |  | 13
PO3826104 | PDQ384939 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 487 | 0 | 487 |  | 13
PO3826099 | PDQ385032 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 641 | 0 | 641 |  | 13
PO3822863 | PDQ385363 | 4004 | Cutstomer 4 | 2023-09-06 00:00:00 | 682 | 0 | 682 |  | 12
PO3799363 | PDQ384107 | 4004 | Cutstomer 4 | 2023-08-30 00:00:00 | 787 | 0 | 787 |  | 19
PO3822413 | PDQ382485 | 4004 | Cutstomer 4 | 2023-08-23 00:00:00 | 787 | 0 | 787 |  | 26
PO3823655 | PDQ383676 | 4004 | Cutstomer 4 | 2023-08-28 00:00:00 | 787 | 0 | 787 |  | 21
PO3825353 | [NAME] | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 787 | 0 | 787 |  | 13
PO3827752 | PDQ385931 | 4004 | Cutstomer 4 | 2023-09-11 00:00:00 | 787 | 0 | 787 |  | 7
PO3829168 | PDQ385921 | 4004 | Cutstomer 4 | 2023-09-11 00:00:00 | 787 | 0 | 787 |  | 7
PO3819058 | PDQ382063 | 4004 | Cutstomer 4 | 2023-08-21 00:00:00 | 819 | 0 | 819 |  | 28
PO3821448 | [NAME] | 4004 | Cutstomer 4 | 2023-08-23 00:00:00 | 1441 | 0 | 1441 |  | 26
PO3820589 | [NAME] | 4004 | Cutstomer 4 | 2023-08-15 00:00:00 | 2391 | 0 | 2391 |  | 34
PO3830010 | PDQ386073 | 4004 | Cutstomer 4 | 2023-09-12 00:00:00 | 2391 | 0 | 2391 |  | 6
PO3818686 | PDQ385209 | 4004 | Cutstomer 4 | 2023-09-06 00:00:00 | 2762 | 0 | 2762 |  | 12
PO3821863 | PDQ386285 | 4004 | Cutstomer 4 | 2023-09-12 00:00:00 | 2762 | 0 | 2762 |  | 6
PO3827924 | PDQ385304 | 4004 | Cutstomer 4 | 2023-09-06 00:00:00 | 2762 | 0 | 2762 |  | 12
PO3820555 | PDQ381154 | 4004 | Cutstomer 4 | 2023-08-15 00:00:00 | 3281 | 0 | 3281 |  | 34
PO3823653 | PDQ384282 | 4004 | Cutstomer 4 | 2023-08-31 00:00:00 | 3281 | 0 | 3281 |  | 18
PO3825553 | PDQ384973 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 3281 | 0 | 3281 |  | 13
PO3827393 | PDQ385923 | 4004 | Cutstomer 4 | 2023-09-11 00:00:00 | 3281 | 0 | 3281 |  | 7
PO3829649 | PDQ386223 | 4004 | Cutstomer 4 | 2023-09-12 00:00:00 | 3545 | 0 | 3545 |  | 6
PO3823465 | PDQ383971 | 4004 | Cutstomer 4 | 2023-08-30 00:00:00 | 3795 | 0 | 3795 |  | 19
PO3827394 | PDQ385017 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 3795 | 0 | 3795 |  | 13
PO3819075 | PDQ381146 | 4004 | Cutstomer 4 | 2023-08-15 00:00:00 | 4568 | 0 | 4568 |  | 34
PO3823452 | PDQ384906 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 4568 | 0 | 4568 |  | 13
PO3825065 | PDQ384965 | 4004 | Cutstomer 4 | 2023-09-05 00:00:00 | 4568 | 0 | 4568 |  | 13
[NAME] | PDQ383675 | 4004 | Cutstomer 4 | 2023-08-28 00:00:00 | 6390 | 0 | 6390 |  | 21
PO3825354 | PDQ384593 | 4004 | Cutstomer 4 | 2023-09-01 00:00:00 | 6390 | 0 | 6390 |  | 17