Spreadsheet: 41863d1240404576-vlookup-several-sheets-in-another-workbook-purchase-invoice-board-june-08-may-09
Sheet: Jan 09

MONTH: | Jan 09
INVOICE NO | DATE | COMPANY INVOICE NO | NETT | VAT | GROSS | COMPANY | CODE | COMMENTS | PD
41384 | 02.01.09 | 272387 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41385 | 02.01.09 | 272392 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41386 | 02.01.09 | 272383 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41387 | 02.01.09 | 272384 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41388 | 02.01.09 | 272385 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41389 | 02.01.09 | 272389 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41390 | 02.01.09 | 272394 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41391 | 02.01.09 | 272386 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41392 | 02.01.09 | 272390 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41393 | 02.01.09 | 272382 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41394 | 02.01.09 | 272391 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41395 | 02.01.09 | 272393 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41396 | 02.01.09 | 272388 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41397 | 16.01.09 | 275672 | 151.2 | 22.68 | 173.88 | TEST LTD | 1660 |  | pd
41398 | 16.01.09 | 275673 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41399 | 16.01.09 | 275674 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41400 | 16.01.09 | 275675 | 143.64 | 21.55 | 165.19 | TEST LTD | 1660 |  | pd
41401 | 16.01.09 | 275676 | 151.2 | 22.68 | 173.88 | TEST LTD | 1660 |  | pd
41402 | 16.01.09 | 275677 | 30.24 | 4.54 | 34.78 | TEST LTD | 1660 |  | pd
41403 | 16.01.09 | 275678 | 151.2 | 22.68 | 173.88 | TEST LTD | 1660 |  | pd
41404 | 16.01.09 | 275679 | 151.2 | 22.68 | 173.88 | TEST LTD | 1660 |  | pd
41405 | 16.01.09 | 275680 | 90.72 | 13.61 | 104.33 | TEST LTD | 1660 |  | pd
41406 | 09.01.09 | 273847 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41407 | 09.01.09 | 273846 | 168.21 | 25.23 | 193.44 | TEST LTD | 1660 |  | pd
41408 | 09.01.09 | 273845 | 117.18 | 17.58 | 134.76 | TEST LTD | 1660 |  | pd
41409 | 09.01.09 | 273844 | 62.37 | 9.36 | 71.72999999999999 | TEST LTD | 1660 |  | pd
41410 | 09.01.09 | 273843 | 107.73 | 16.16 | 123.89 | TEST LTD | 1660 |  | pd
41411 | 09.01.09 | 273838 | 117.18 | 17.58 | 134.76 | TEST LTD | 1660 |  | pd
41412 | 09.01.09 | 273837 | 168.21 | 25.23 | 193.44 | TEST LTD | 1660 |  | pd
41413 | 09.01.09 | 273836 | 107.73 | 16.16 | 123.89 | TEST LTD | 1660 |  | pd
41414 | 23.01.09 | 277734 | 181.44 | 27.22 | 208.66 | TEST LTD | 1660 |  | pd
41415 | 23.01.09 | 277735 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41416 | 23.01.09 | 277736 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41417 | 23.01.09 | 277732 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41418 | 23.01.09 | 277733 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41419 | 30.12.08 | L0013648 | 286.56 | 42.98 | 329.54 | TEST LTD | 1650 |  | pd
41420 | 07.01.09 | L0013658 | 222.88 | 33.43 | 256.31 | TEST LTD | 1650 |  | pd
41421 | 09.01.09 | INV58426 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41422 | 09.01.09 | INV58427 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41423 | 09.01.09 | INV58428 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41424 | 09.01.09 | INV58429 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41425 | 09.01.09 | INV58430 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41426 | 09.01.09 | INV58431 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41427 | 09.01.09 | INV58432 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41428 | 09.01.09 | INV58433 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41429 | 09.01.09 | INV58434 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41430 | 09.01.09 | INV58435 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41431 | 09.01.09 | INV58436 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41432 | 09.01.09 | INV58437 | 100 | 13.8 | 113.8 | TEST LTD | 1625 |  | pd
41433 | 09.01.09 | 273848 | 206.01 | 30.9 | 236.91 | TEST LTD | 1660 |  | pd
41434 | 09.01.09 | 273839 | 226.8 | 34.02 | 260.82 | TEST LTD | 1660 |  | pd
41435 | 09.01.09 | 273840 | 228.69 | 34.3 | 262.99 | TEST LTD | 1660 |  | pd
41436 | 09.01.09 | 273841 | 228.69 | 34.3 | 262.99 | TEST LTD | 1660 |  | pd
41437 | 09.01.09 | 273842 | 168.21 | 25.23 | 193.44 | TEST LTD | 1660 |  | pd
41438 | 20.01.08 | 59370 | 2655.61 | 0 | 2655.61 | TEST LTD | 1625 |  | pd
41439 | 14.01.09 | 267 | 1200 | 0 | 1200 | TEST LTD | 1625 |  | pd
41440 | 29.01.09 | 15380 | 1367.83 | 205.17 | 1573 | TEST LTD | 1625 |  | pd
41441 | 01.10.08 | 15381 | 140.87 | 21.13 | 162 | TEST LTD | 1625 |  | pd
41442 | 18.01.09 | 00100286/90186538 | 132.77 | 19.92 | 152.69 | TEST LTD | 1625 |  | pd
41443 | 19.01.09 | 00100286/90196594 | 663.85 | 99.6 | 763.45 | TEST LTD | 1625 |  | pd
41444 | 15.01.09 | NA2287 | 7736 | 0 | 7736 | TEST LTD | 1625 |  | pd
41445 | 20.01.09 | GL10630 | 2370.89 | 0 | 2370.89 | TEST LTD | 1625 |  | pd
41446 | 02.12.09 | 4804 | 1218 | 0 | 1218 | TEST LTD | 1625 |  | pd
41447 | 29.12.08 | INV45939 | 1129.44 | 169.42 | 1298.86 | TEST LTD | 1625 |  | pd
41448 | 22.01.09 | 54759 | 512 | 0 | 512 | TEST LTD | 1625 |  | pd
41449 | 20.01.09 | 22551 | 1755 | 0 | 1755 | TEST LTD | 1625 |  | pd
41450 | 21.01.09 |  | 1708.28 | 0 | 1708.28 | TEST LTD | 1625 |  | pd
41451 | 21.01.09 | 1674 | 1565.85 | 0 | 1565.85 | TEST LTD | 1625 |  | pd
41452 | 20.01.09 | OL47508 | 2901.6 | 0 | 2901.6 | TEST LTD | 1625 |  | pd
41453 | 13.01.09 | 10562 | 162 | 0 | 162 | TEST LTD | 1625 |  | pd
41454 | 14.01.09 | 10576 | 810 | 0 | 810 | TEST LTD | 1625 |  | pd
41455 | 15.01.09 | 2557 | 280 | 0 | 280 | TEST LTD | 1625 |  | pd
41456 | 01.01.09 | 2074 | 748.76 | 0 | 748.76 | TEST LTD | 1625 |  | pd
41457 | 01.01.09 | 2073 | 1404 | 0 | 1404 | TEST LTD | 1625 |  | pd
41458 | 05.01.09 | 22168 | 769.24 | 0 | 769.24 | TEST LTD | 1625 |  | pd
41459 | 06.01.09 | 16830 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41460 | 06.01.09 | 16829 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41461 | 06.01.09 | 16828 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41462 | 06.01.09 | 16827 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41463 | 06.01.09 | 16826 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41464 | 06.01.09 | 16825 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41465 | 06.01.09 | 16824 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41466 | 06.01.09 | 16823 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41467 | 06.01.09 | 16822 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41468 | 06.01.09 | 16821 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41469 | 03.01.09 | 16781 | 164.54 | 0 | 164.54 | TEST LTD | 1625 |  | pd
41470 | 01.01.09 | 56312 | 703.05 | 105.46 | 808.51 | TEST LTD | 1625 |  | pd
41471 | 06.01.09 | 1562 | 1080 | 0 | 1080 | TEST LTD | 1625 |  | pd
41472 | 02.01.09 | 22403 | 425 | 0 | 425 | TEST LTD | 1625 |  | pd
41473 | 09.01.09 | BC28068 | 1053 | 0 | 1053 | TEST LTD | 1625 |  | pd
41474 | 09.01.09 | 8112 | 1650 | 0 | 1650 | TEST LTD | 1625 |  | pd
41475 | 07.01.09 | IN107520 | 11000 | 1650 | 12650 | TEST LTD | 3022 |  | pd
41476 | 12.01.09 | IN107564 | 5500 | 825 | 6325 | TEST LTD | 3022 |  | pd
41477 | 23.01.09 | 682C00503 | 1045 | 156.75 | 1201.75 | TEST LTD | 2142 |  | pd
41478 | 14.01.09 | [PHONE] | 322.31 | 0 | 322.31 | TEST LTD | 1635 |  | pd
41479 | 14.01.09 | [PHONE] | 1482 | 0 | 1482 | TEST LTD | 1636 |  | pd
41480 | 15.01.09 | [PHONE] | 2521.06 | 0 | 2521.06 | TEST LTD | 1635 |  | pd
41481 | 06.01.09 |  | 1420 | 0 | 1420 | TEST LTD | 2101 |  | pd
41482 | 09.01.09 | 3911 | 60 | 9 | 69 | TEST LTD | 1625 |  | pd
41483 | 16.01.09 | 3931 | 60 | 9 | 69 | TEST LTD | 1625 |  | pd
41484 | 18.01.09 | 96380921 | 119.17 | 17.88 | 137.05 | TEST LTD | 2709 |  | pd
41485 | 11.01.09 | 96375973 | 119.17 | 17.88 | 137.05 | TEST LTD | 2709 |  | pd
41486 | 04.01.09 | 96373214 | 119.17 | 17.88 | 137.05 | TEST LTD | 2709 |  | pd
41487 | 25.01.09 | 96384262 | 119.17 | 17.88 | 137.05 | TEST LTD | 2709 |  | pd
41488 | 14.01.09 | 96377664 | 2150 | 322.5 | 2472.5 | TEST LTD | 2709 |  | pd
41489 | 27.01.09 | 58165 | 541.17 | 81.18 | 622.3499999999999 | TEST LTD | 2166 |  | pd
41490 | 27.01.09 | 58163 | 491.83 | 73.78 | 565.61 | TEST LTD | 2057 |  | pd
41491 | 14.01.09 | [NAME] | 191.04 | 28.66 | 219.7 | TEST LTD | 1650 |  | pd
41492 | 20.01.09 | L0013705 | 127.36 | 19.1 | 146.46 | TEST LTD | 1750 |  | pd
41493 | 15.01.09 |  | 73.3 | 0 | 73.3 | TEST LTD | 2121 | D.D due on 15.01.09 | pd
41494 | 16.01.09 | POS/AV 209 | 300 | 0 | 300 | TEST LTD | 1725 |  | pd
41495 | 16.01.09 | 6226719 | 1370 | 205.5 | 1575.5 | TEST LTD | 2101 | Copy (RFC) 02.02.09 | pd
41496 | 07.01.09 | 978143993 | 150.9 | 17.39 | 168.29 | TEST LTD | Various |  | pd
41497 | 01.01.09 | B7759189 | 37.95 | 2.54 | 40.49 | TEST LTD | 2128 | D.D due on 18.01.09 | pd
41498 | 15.01.09 | 20920 | 770 | 115.5 | 885.5 | TEST LTD | 2609 |  | pd
41499 | 22.01.09 | 177048900 | 606.17 | 0 | 606.17 | TEST LTD | 2501 |  | pd
41500 | 22.01.09 | 893101020 | 472.11 | 0 | 472.11 | TEST LTD | 2146 |  | pd
41501 | 01.01.09 | SLINV/00036569 | 96.15 | 14.42 | 110.57 | TEST LTD | 2145 |  | pd
41502 | 01.01.09 | SLINV/00036911 | 127.89 | 19.18 | 147.07 | TEST LTD | 2411 |  | pd
41503 | 16.01.09 | [PHONE] | 701.99 | 105.3 | 807.29 | TEST LTD | 2056 | D.D due on 16.01.09 | pd
41504 | 31.01.09 | 860340 | 404.28 | 60.64 | 464.92 | TEST LTD | Various |  | pd
41505 | 26.01.09 | 63803 | 12.18 | 1.83 | 14.01 | TEST LTD | 2156 |  | pd
41506 | 30.01.09 | 3072 | -7.35 | -1.29 | -8.64 | TEST LTD | 1621 |  | pd | c
41507 | 30.01.09 | 3073 | -10.5 | -1.84 | -12.34 | TEST LTD | 1720 |  | pd | c
41508 | 06.01.09 | 3013 | -195.78 | -29.37 | -225.15 | TEST LTD | 1621/1720 |  | pd | c
41509 | 13.01.09 | 3037 | -8.75 | -1.31 | -10.06 | TEST LTD | 1720 |  | pd | c
41510 | 26.01.09 | 63801 | 25.72 | 3.86 | 29.58 | TEST LTD | 2156 |  | pd
41511 | 26.01.09 | 63800 | 54.47 | 8.17 | 62.64 | TEST LTD | 2156 |  | pd
41512 | 26.01.09 | 63799 | 168 | 25.2 | 193.2 | TEST LTD | 2217 |  | pd
41513 | 26.01.09 | 63798 | 15.98 | 2.4 | 18.38 | TEST LTD | 2048 |  | pd
41514 | 26.01.09 | 63802 | 63.33 | 9.5 | 72.83 | TEST LTD | 2448 |  | pd
41515 | 26.01.09 | 63797 | 13.07 | 1.96 | 15.03 | TEST LTD | 2156 |  | pd
41516 | 26.01.09 | 63796 | 51.6 | 7.74 | 59.34 | TEST LTD | 2156 | Query file
41517 | 07.01.09 | PSI206044 | 159.43 | 23.91 | 183.34 | TEST LTD | 2156 |  | pd
41518 | 26.01.09 | PSI206679 | 455.85 | 68.38 | 524.23 | TEST LTD | 2156 |  | pd
41519 | 28.01.09 | PSI206794 | 106.9 | 16.04 | 122.94 | TEST LTD | 2156 |  | pd
41520 | 29.01.09 | [NAME] | 135.76 | 20.36 | 156.12 | TEST LTD | 2436 |  | pd
41521 | 29.01.09 | PSI206867 | 428.37 | 64.26 | 492.63 | TEST LTD | 2156 |  | pd
41522 | 26.01.09 | 149915 | 31.84 | 4.77 | 36.61 | TEST LTD | 1710 |  | pd
41523 | 29.01.09 | 149849 | 15 | 2.25 | 17.25 | TEST LTD | 1710 |  | pd
41524 | 25.01.09 | CFS0671272 | 120.94 | 294.98 | 415.92 | TEST LTD | 1631 |  | pd
41525 | 23.01.09 | 613C68857 | 210.44 | 31.57 | 242.01 | TEST LTD | 2142 |  | pd
41526 | 26.01.09 | 011833 | -76 | -11.4 | -87.4 | TEST LTD | 1620 |  | pd | c
41527 | 30.01.09 | 279806 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41528 | 30.01.09 | 279807 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41529 | 30.01.09 | 279808 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41530 | 30.01.09 | 279809 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41531 | 30.01.09 | 279810 | 60.48 | 9.07 | 69.55 | TEST LTD | 1660 |  | pd
41532 | 30.01.09 | 279811 | 120.96 | 18.14 | 139.1 | TEST LTD | 1660 |  | pd
41533 | 19.01.09 | 065956 | 1436.62 | 215.49 | 1652.11 | TEST LTD | 1720 |  | pd
41534 | 22.01.09 | 066191 | 91.62 | 13.74 | 105.36 | TEST LTD | 1621 |  | pd
41535 | 22.01.09 | 066173 | 337.5 | 50.63 | 388.13 | TEST LTD | 1720 |  | pd
41536 | 19.01.09 | 066029 | 39.36 | 5.9 | 45.26 | TEST LTD | 1720 |  | pd
41537 | 19.01.09 | 066019 | 92.93 | 13.94 | 106.87 | TEST LTD | 1621 |  | pd
41538 | 19.01.09 | 065984 | 31.86 | 4.78 | 36.64 | TEST LTD | 1720 |  | pd
41539 | 16.01.09 | 065899 | 195 | 29.25 | 224.25 | TEST LTD | 1720 |  | pd
41540 | 21.01.09 | 066158 | 4436 | 665.4 | 5101.4 | TEST LTD | 1720 |  | pd
41541 | 21.01.09 | 066089 | 80.75 | 12.11 | 92.86 | TEST LTD | 1720 |  | pd
41542 | 21.01.09 | 066148 | 49.35 | 7.4 | 56.75 | TEST LTD | 1621 |  | pd
41543 | 01.01.09 | Internal Credit | -528.8 | -92.54 | -621.3399999999999 | TEST LTD | 2428 |  | …. | c
41544 | 31.01.09 | 1667 | 481 | 0 | 481 | TEST LTD | 1625 |  | pd
41545 | 31.01.09 | 21173323 | 8271.45 | 1240.72 | 9512.17 | TEST LTD | 1634 | Query file | pd
41546 | 31.01.09 | 21694977 | 7019.67 | 1052.95 | 8072.62 | TEST LTD | 1730 |  | pd
41547 | 31.01.09 | 21694976 | 3150.11 | 472.52 | 3622.63 | TEST LTD | 1632 |  | pd
41548 | 23.01.09 | 3952 | 40 | 6 | 46 | TEST LTD | 1625 |  | pd
41549 | 31.01.09 | 77144659 | 2.5 | 0.38 | 2.88 | TEST LTD | 1630 |  | pd
41550 | 26.01.09 | 63795 | 28.2 | 4.23 | 32.43 | TEST LTD | 2048 |  | pd
41551 | 01.01.09 | Internal Credit | -97.65 | 0 | -97.65 | TEST LTD | 1625 |  | …. | c
41552 | 01.01.09 | Internal Invoice | 19.2 | 0 | 19.2 | TEST LTD | 1625 |  | ….
41553 | 01.01.09 | Internal Invoice | 298.62 | 52.26 | 350.88 | TEST LTD | 2145 |  | ….
41554 | 30.01.09 | 3219 | 24310 | 3646.5 | 27956.5 | TEST LTD | 1626 |  | pd
41555 | 22.01.09 | 066195 | 3806.31 | 570.95 | 4377.26 | TEST LTD | 1720 |  | pd
41556 | 23.01.09 | 066230 | 1554.99 | 233.25 | 1788.24 | TEST LTD | 1720 |  | pd
41557 | 23.01.09 | 066235 | 1632.19 | 244.83 | 1877.02 | TEST LTD | 1720 |  | pd
41558 | 22.01.09 | 066192 | 189.49 | 28.42 | 217.91 | TEST LTD | 1720 |  | pd
41559 | 30.01.09 | 066509 | 429 | 64.35 | 493.35 | TEST LTD | 1720 |  | pd
41560 | 22.01.09 | 066198 | 177.99 | 26.7 | 204.69 | TEST LTD | 1621 |  | pd
41561 | 31.01.09 | I0451474 | 10474.85 | 1571.35 | 12046.2 | TEST LTD | 1633 |  | pd
41562 | 31.01.09 | 50273883 | 33530.54 | 5029.58 | 38560.12 | TEST LTD | 1630 |  | pd
41563 | 31.01.09 | 50497677 | 125 | 18.75 | 143.75 | TEST LTD | 1632 |  | pd
41564 | 31.01.09 | 50497676 | 7136.92 | 1070.54 | 8207.46 | TEST LTD | 1632 |  | pd
41565 | 31.01.09 | 50273884 | 10.3 | 1.55 | 11.85 | TEST LTD | 1634 |  | pd
41566 | 29.01.09 | I0450312 | 48.48 | 0 | 48.48 | TEST LTD | 1631 |  | pd
41567 | 29.01.09 | I0451473 | 127.46 | 0 | 127.46 | TEST LTD | 1633 | Copy (F1) 10.02.09 | pd
41568 | 29.01.09 | I0450313 | 531.46 | 79.74 | 611.2 | TEST LTD | 1631 |  | pd
41569 | 29.01.09 | I0450092 | 696.04 | 104.41 | 800.4499999999999 | TEST LTD | 1633 |  | pd
41570 | 29.01.09 | I0450091 | 40.4 | 0 | 40.4 | TEST LTD | 1633 |  | pd
41571 | 28.01.09 | 81920999 | 451.29 | 66.05 | 517.34 | TEST LTD | Various |  | pd
41572 | 01.05.08 | 053/07/0193245 | 700.96 | 122.66 | 823.62 | TEST LTD | 2148 | Old invoice for POA | pd
41573 | 28.01.09 |  | 1560 | 0 | 1560 | TEST LTD | 1625 |  | pd
41574 | 22.01.09 | 13225 | 1500 | 225 | 1725 | TEST LTD | 1625 |  | pd
41575 | 15.01.09 | 11669 | 845 | 126.75 | 971.75 | TEST LTD | 1625 |  | pd
41576 | 22.01.09 | 14670 | 138.62 | 20.79 | 159.41 | TEST LTD | 1625 |  | pd
41577 | 23.01.09 | NC4709 | 235.12 | 0 | 235.12 | TEST LTD | 1625 |  | pd
41578 | 01.01.09 | 11132162-T | 693.34 | 104 | 797.34 | TEST LTD | 2609 | D.D due on 01.01.09 | pd
41579 | 01.01.09 | 11104095-7 | 745.33 | 111.8 | 857.13 | TEST LTD | 2056 | D.D due on 01.01.09 | pd
41580 | 28.01.09 | 2393991 | 736.67 | 110.5 | 847.17 | TEST LTD | 2056 | D.D due on 28.01.09 | pd
41581 | 28.01.09 | 2393990 | 736.67 | 110.5 | 847.17 | TEST LTD | 2509 | D.D due on 28.01.09 | pd
41582 | 21.01.09 | AR2009/01/POS | 500 | 75 | 575 | TEST LTD | 2145 |  | pd
41583 | 31.01.09 |  | 2354.47 | 268.82 | 2623.29 | TEST LTD | Various | D.D due on 10.02.09 | pd
41584 | 12.12.08 | 5156619 | 192.99 | 28.95 | 221.94 | TEST LTD | 1621 |  | pd
41585 | 19.12.08 | 5186291 | 409.93 | 61.49 | 471.42 | TEST LTD | 1621 |  | pd
41586 | 22.01.09 | CN7809173 | -20.31 | -1.41 | -21.72 | TEST LTD | 1720 |  | pd | c
41587 | 01.01.09 | Internal Credit | -98 | -17.15 | -115.15 | TEST LTD | 1626 | C.S ellis older invoice | ….. | c
41588 | 01.01.09 | Internal Invoice | 480.88 | 83.49 | 564.37 | TEST LTD | Various | Use against POA | ….
41589 | 01.01.09 | Internal Credit | -480.88 | -83.49 | -564.37 | TEST LTD | Various |  | …. | c
41590 | 01.01.09 | Internal Invoice | 330 | 0 | 330 | TEST LTD | 2093 |  | ….
41591 | 01.01.09 | Interal Credit | -330 | 0 | -330 | TEST LTD | 2093 |  | …. | c
41592 | 01.01.09 | Internal Credit | -45 | 0 | -45 | TEST LTD | 1625 |  | …. | c
41593 | 01.01.09 | Internal Invoice | 45 | 0 | 45 | TEST LTD | 1625 | Use against POA | ….
41594 | 01.01.09 | Internal Invoice | 395 | 59.25 | 454.25 | TEST LTD | 1621 |  | ….
41595 | 01.01.09 | Internal Credit | -395 | -59.25 | -454.25 | TEST LTD | 1621 |  | …. | c
41596 | 30.01.09 | 9471 | 117.92 | 17.69 | 135.61 | TEST LTD | 1625 |  | pd
41597 | 31.01.09 | 25406850 | 1522.05 | 228.31 | 1750.36 | TEST LTD | Various |  | pd
41598 | 16.01.09 | 3918 | 315 | 47.25 | 362.25 | TEST LTD | 1621 |  | pd
41599 | 16.01.09 | 3916 | 1885.73 | 282.9 | 2168.63 | TEST LTD | 1620 |  | pd
41600 | 31.01.09 |  | 973.88 | 142.77 | 1116.65 | TEST LTD | Various | D.D due on 17.02.09 | pd
41601 | 07.11.08 | 07712098 | 21.27 | 3.72 | 24.99 | TEST LTD | 1621 |  | pd
41602 | 21.11.08 | 07743954 | 95.81 | 16.77 | 112.58 | TEST LTD | 1621 |  | pd
41603 | 28.11.08 | 07759998 | 23.37 | 4.09 | 27.46 | TEST LTD | 1621 |  | pd
41604 | 29.01.09 | [PHONE] | 701.99 | 105.3 | 807.29 | TEST LTD | 2428 | D.D due on 29.01.09 | pd
41605 | 31.01.09 | [PHONE] | 820.43 | 123.06 | 943.49 | TEST LTD | Various | D.D due on  31.01.09 | pd
41606 | 31.01.09 | 101742 | 530 | 0 | 530 | TEST LTD | Various |  | pd
41607 | 30.01.09 | 128355 | 38.75 | 5.81 | 44.56 | TEST LTD | Various |  | pd
41608 | 27.01.09 | 58164 | 303.33 | 45.5 | 348.83 | TEST LTD | 2441 |  | pd
41609 | 22.10.08 | [PHONE] | 450 | 0 | 450 | TEST LTD | 1635 | D.D due on 21.11.08 - Already paid | pd
41610 | 23.01.09 | 3936 | 965 | 144.75 | 1109.75 | TEST LTD | 1621 |  | pd
41611 | 16.01.09 | 3927 | 575 | 86.25 | 661.25 | TEST LTD | 1620 |  | pd
41612 | 09.01.09 | 3899 | 2565 | 384.75 | 2949.75 | TEST LTD | 1620 |  | pd
41613 | 15.01.09 | 9066 | 100 | 0 | 100 | TEST LTD | 1625 |  | pd
41614 | 21.01.09 | I01079120 | 62.13 | 9.32 | 71.45 | TEST LTD | 1620 |  | pd
41615 | 27.01.09 | SIN18631 | 310 | 46.5 | 356.5 | TEST LTD | 1621 |  | pd
41616 | 28.01.09 | SIN18681 | 197.5 | 29.63 | 227.13 | TEST LTD | 1621 |  | pd
41617 | 13.01.09 | SIN18386 | 232.5 | 34.88 | 267.38 | TEST LTD | 1621 |  | pd
41618 | 13.01.09 | SIN18401 | 542.5 | 81.38 | 623.88 | TEST LTD | 1621 |  | pd
41619 | 15.01.09 | SIN18444 | 232.5 | 34.88 | 267.38 | TEST LTD | 1621 |  | pd
41620 | 19.01.09 | SIN18532 | 296.25 | 44.44 | 340.69 | TEST LTD | 1621 |  | pd
41621 | 13.01.09 | SIN18381 | 296.25 | 44.44 | 340.69 | TEST LTD | 1621 |  | pd
41622 | 23.01.09 | SIN18586 | 80 | 12 | 92 | TEST LTD | 1621 |  | pd
41623 | 23.01.09 | SIN18589 | 197.5 | 29.63 | 227.13 | TEST LTD | 1621 |  | pd
41624 | 19.01.09 | SIN18517 | 232.5 | 34.88 | 267.38 | TEST LTD | 1621 |  | pd
41625 | 20.01.09 | SIN18540 | 155 | 23.25 | 178.25 | TEST LTD | 1621 |  | pd
41626 | 31.01.09 | 066643 | 292.83 | 43.92 | 336.75 | TEST LTD | 1621 |  | pd
41627 | 31.01.09 | 066645 | 192.17 | 28.83 | 221 | TEST LTD | 1720 |  | pd
41628 | 31.01.09 | 066650 | 276.4 | 41.46 | 317.86 | TEST LTD | 1720 |  | pd
41629 | 31.01.09 | 066646 | 1078.53 | 161.78 | 1240.31 | TEST LTD | 1720 |  | pd
41630 | 31.01.09 | 066644 | 1140.36 | 171.05 | 1311.41 | TEST LTD | 1720 |  | pd
41631 | 05.01.09 | [PHONE] | 285.79 | 42.88 | 328.67 | TEST LTD | Various |  | pd
41632 | 12.01.09 | [PHONE] | 133.91 | 20.09 | 154 | TEST LTD | various |  | pd
41633 | 19.01.09 | 066028 | 62.48 | 9.37 | 71.85 | TEST LTD | 1621 |  | pd
41634 | 30.01.09 | 066431 | 70 | 10.5 | 80.5 | TEST LTD | 1720 |  | pd
41635 | 31.01.09 | 066604 | 146.89 | 22.03 | 168.92 | TEST LTD | 1621 |  | pd
41636 | 31.01.09 | 066609 | 156.96 | 23.54 | 180.5 | TEST LTD | Various |  | pd
41637 | 20.01.09 | L116250 | 89 | 13.35 | 102.35 | TEST LTD | 1620 |  | pd
41638 | 27.01.09 | [NAME] | 45 | 6.75 | 51.75 | TEST LTD | 1620 |  | pd
41639 | 30.09.08 | L513081 | 490 | 85.75 | 575.75 | TEST LTD | 1620 |  | pd
41640 | 31.01.09 | L116328 | 76 | 11.4 | 87.4 | TEST LTD | 1620 |  | pd
41641 | 21.01.09 | 066149 | 69.41 | 10.41 | 79.82 | TEST LTD | 1720 | Query file
41642 | 31.01.09 | 64312 | 47.76 | 7.16 | 54.92 | TEST LTD | 2429 |  | pd
41643 | 31.01.09 | 64311 | 39.09 | 5.86 | 44.95 | TEST LTD | 2156 |  | pd
41644 | 31.01.09 | 64313 | 45.42 | 6.81 | 52.23 | TEST LTD | 2156 |  | pd
41645 | 19.01.09 | 011667 | 309 | 46.35 | 355.35 | TEST LTD | 1620
41646 | 26.01.09 | 011789 | 491 | 73.65 | 564.65 | TEST LTD | Various |  | pd
41647 | 08.01.09 | 011516 | 240 | 36 | 276 | TEST LTD | 1620 |  | pd
41648 | 07.01.09 | 49621071/09 | 72.7 | 3.64 | 76.34 | TEST LTD | 2025 | Use 41273 as a credit. | ….
41649 | 13.01.09 | 49875193/09 | 631.96 | 94.79 | 726.75 | TEST LTD | 2144 |  | pd
41650 | 08.01.09 | 49700084/09 | 683.84 | 102.58 | 786.4200000000001 | TEST LTD | 2144 |  | ….
41651 | 08.01.09 | 49700073/09 | 1586.9 | 252.7 | 1839.6 | TEST LTD | 2504 |  | ….
41652 | 13.01.09 | 49875204/09 | 313.84 | 47.08 | 360.92 | TEST LTD | 2504 |  | pd
41653 | 22.01.09 | 90108473 | -30 | -5.25 | -35.25 | TEST LTD | 1630 |  | pd | c
41654 | 28.01.09 | 90108718 | -254.05 | -44.46 | -298.51 | TEST LTD | 1630 |  | pd | c
41655 | 16.01.09 | 90108072 | -74 | -11.1 | -85.1 | TEST LTD | 1632 |  | pd | c
41656 | 15.01.09 | 90107950 | -10 | -1.5 | -11.5 | TEST LTD | 1632 |  | pd | c
41657 | 15.01.09 | 90107980 | -26.31 | -3.95 | -30.26 | TEST LTD | 1632 |  | pd | c
41658 | 07.01.09 | 90107413 | -212.41 | -37.17 | -249.58 | TEST LTD | 1630 |  | pd | c
41659 | 06.01.09 | 90107388 | -15.41 | -2.31 | -17.72 | TEST LTD | 1730 |  | pd | c
41660 | 28.01.09 | 92897226/1000 | 45 | 6.75 | 51.75 | TEST LTD | 2165 |  | pd
41661 | 30.01.09 | 3963 | 40 | 7 | 47 | TEST LTD | 1625 |  | pd
41662 | 11.01.09 | 1763019 | 138.02 | 20.7 | 158.72 | TEST LTD | 2045 |  | pd
41663 | 06.01.09 | 1759739 | 131.45 | 19.72 | 151.17 | TEST LTD | 2045 |  | pd
41664 | 08.01.09 | 90379612 | 445.45 | 66.82 | 512.27 | TEST LTD | 2217
41665 | 30.01.09 | 3959 | 390 | 58.5 | 448.5 | TEST LTD | 1620 |  | pd
41666 | 30.01.09 | 3957 | 410 | 61.5 | 471.5 | TEST LTD | 1621 |  | pd
41667 | 30.01.09 | 3958 | 1364 | 204.6 | 1568.6 | TEST LTD | 1620 |  | pd
41668 | 08.01.09 | 1724739 | 3452.16 | 517.82 | 3969.98 | TEST LTD | 2217 |  | pd
41669 | 30.01.09 | 1726981 | 625 | 93.75 | 718.75 | TEST LTD | 2217 |  | pd
41670 | 22.01.09 | 21415 | 1932 | 289.8 | 2221.8 | TEST LTD | 2217 |  | pd
41671 | 15.01.09 | 21362 | 238 | 35.7 | 273.7 | TEST LTD | 2156 |  | pd
41672 | 12.01.09 | 115258 | 170 | 25.5 | 195.5 | TEST LTD | 2026 |  | pd
41673 | 16.01.09 | 714676 | 94 | 14.1 | 108.1 | TEST LTD | 2145 |  | pd
41674 | 16.01.09 | 714672 | 89 | 13.35 | 102.35 | TEST LTD | 2508 |  | pd
41675 | 16.01.09 | 44247 | 4417.5 | 662.63 | 5080.13 | TEST LTD | 2414 |  | pd
41676 | 23.01.09 | 44089 | -124 | -18.6 | -142.6 | TEST LTD | 2414 |  | pd | c
41677 | 14.01.09 | 91298 | 52.6 | 0 | 52.6 | TEST LTD | 2050 |  | pd
41678 | 26.01.09 | 297894 | 320 | 48 | 368 | TEST LTD | 2173 |  | pd
41679 | 30.01.09 | 714725 | 109.54 | 16.43 | 125.97 | TEST LTD | 2145 | Copy (F1) 17.02.09 | pd
41680 | 26.01.09 | 978178019 | -18.9 | 1.37 | -17.53 | TEST LTD | 2154 |  | pd | c
41681 | 26.01.09 | 978178051 | 9.1 | 1.37 | 10.47 | TEST LTD | 2050 |  | pd
41682 | 28.01.09 | 90399112 | 85.49 | 12.82 | 98.31 | TEST LTD | 2048
41683 | 19.01.09 | 532 | 190 | 28.5 | 218.5 | TEST LTD | 2145 |  | pd
41684 | 15.01.09 | 00147655 | 534.75 | 80.21 | 614.96 | TEST LTD | 1710 |  | pd
41685 | 12.01.09 | 21144 | 98 | 14.7 | 112.7 | TEST LTD | 1611 |  | pd
41686 | 09.01.09 | 5239440 | 120.82 | 18.12 | 138.94 | TEST LTD | 1621 |  | pd
41687 | 23.01.09 | 5295332 | 59.3 | 8.9 | 68.2 | TEST LTD | 1621 |  | pd
41688 | 02.01.09 | 5219262 | 66.29 | 9.94 | 76.23 | TEST LTD | 1621 |  | pd
41689 | 16.01.09 | 5267083 | 182.34 | 27.35 | 209.69 | TEST LTD | 1621 |  | pd
41690 | 16.01.09 | 07850543 | 136.85 | 20.53 | 157.38 | TEST LTD | 1720 |  | pd
41691 | 09.01.09 | 07836543 | 157.09 | 23.56 | 180.65 | TEST LTD | 1720 |  | pd
41692 | 30.01.09 | 07878966 | 24.21 | 3.63 | 27.84 | TEST LTD | 1720 |  | pd
41693 | 23.01.09 | 07864696 | 108.51 | 0 | 108.51 | TEST LTD | 1720 |  | pd
41694 | 16.01.09 | 07847813 | 33.32 | 5 | 38.32 | TEST LTD | 1621 |  | pd
41695 | 26.01.09 | 87194 | 49 | 7.35 | 56.35 | TEST LTD | 2157 |  | pd
41696 | 08.01.09 | 85947 | 49 | 7.35 | 56.35 | TEST LTD | 2211 |  | pd
41697 | 20.01.09 | 127218 | 59.88 | 8.98 | 68.86 | TEST LTD | 2057 |  | pd
41698 | 06.01.09 | C0056012 | -8.08 | -1.41 | -9.49 | TEST LTD | 1633 |  | pd | c
41699 | 06.01.09 | [NAME] | -8 | -1.4 | -9.4 | TEST LTD | 1633 |  | pd | c
41700 | 06.01.09 | C0056015 | -8.08 | -1.41 | -9.49 | TEST LTD | 1633 |  | pd | c
41701 | 06.01.09 | C0056016 | -8 | -1.4 | -9.4 | TEST LTD | 1633 |  | pd | c
41702 | 21.01.09 | I01079118 | 62.13 | 9.32 | 71.45 | TEST LTD | 1620 |  | pd
41703 | 23.01.09 | 3950 | 610 | 91.5 | 701.5 | TEST LTD | 1620 |  | pd
41704 | 09.01.09 | 3897 | 2275.5 | 341.34 | 2616.84 | TEST LTD | 1620 |  | pd
41705 | 09.01.09 | 3898 | 395 | 59.25 | 454.25 | TEST LTD | 1621 |  | pd
41706 | 06.01.09 | 2039683 | -44.68 | -6.7 | -51.38 | TEST LTD | Various |  | …. | c
41707 | 06.01.09 | 2039682 | -12.75 | -2.23 | -14.98 | TEST LTD | 2143 |  | …. | c
41708 | 19.01.09 | 0069 | 690 | 103.5 | 793.5 | TEST LTD | 2503 |  | pd
41709 | 20.01.09 | 294 | -1.01 | -0.15 | -1.16 | TEST LTD | 1621 |  | pd | c
41710 | 22.01.09 | 20628 | 1009.8 | 151.47 | 1161.27 | TEST LTD | 1621 |  | pd
41711 | 31.01.09 | 20712 | 377.4 | 56.61 | 434.01 | TEST LTD | 1621 |  | pd
41712 | 15.01.09 | 20593 | 1213.8 | 182.07 | 1395.87 | TEST LTD | 1621 |  | pd
41713 | 31.01.09 | 602157 | 793.58 | 119.04 | 912.62 | TEST LTD | 1611 |  | pd
41714 | 31.01.09 | 602158 | 2254.3 | 338.15 | 2592.45 | TEST LTD | 1710 |  | pd
41715 | 30.01.09 | SIN18722 | 260 | 39 | 299 | TEST LTD | 1621 |  | pd
41716 | 28.01.09 | SIN18657 | 190 | 28.5 | 218.5 | TEST LTD | 1621 |  | pd
41717 | 28.01.09 | SIN18656 | 190 | 28.5 | 218.5 | TEST LTD | 1621 |  | pd
41718 | 27.01.09 | L116302 | 46 | 6.9 | 52.9 | TEST LTD | 1620 |  | pd
41719 | 31.01.09 | 11925 | 229 | 34.35 | 263.35 | TEST LTD | 1620 |  | pd
41720 | 08.01.09 | 20556 | 938.4 | 140.76 | 1079.16 | TEST LTD | 1621 |  | pd
41721 | 16.01.09 | 0888059 | 83.95 | 12.59 | 96.54 | TEST LTD | 2048 |  | pd
41722 | 23.01.09 | OP/C317978 | -537.59 | -94.08 | -631.6700000000001 | TEST LTD | 2042 |  | pd | c
41723 | 19.01.09 | OP/I282306 | 537.59 | 80.64 | 618.23 | TEST LTD | 2042 |  | pd
41724 | 16.06.08 | 16156 | 495 | 86.63 | 581.63 | TEST LTD | 2026 |  | pd
41725 | 14.01.09 | 01/1699 | 56 | 8.4 | 64.4 | TEST LTD | 1720 |  | pd
41726 | 29.01.09 | 25720 | 595 | 89.25 | 684.25 | TEST LTD | 2217 |  | pd
41727 | 29.01.09 | 20664 | 1466.76 | 220.01 | 1686.77 | TEST LTD | 1621 |  | pd
41728 | 26.01.09 | 11788 | 461 | 69.15 | 530.15 | TEST LTD | 1620 |  | pd
41729 | 23.01.09 | 3933 | 4797.5 | 719.64 | 5517.14 | TEST LTD | 1620 |  | pd
41730 | 12.01.09 | 011571 | 170 | 25.5 | 195.5 | TEST LTD | 1620 |  | pd
41731 | 26.01.09 | 063-6693 | 529.23 | 79.38 | 608.61 | TEST LTD | Various | D.D due on 26.01.09 | pd
41732 | 31.01.09 | 42657 | 418.2 | 62.74 | 480.94 | TEST LTD | 1621 |  | pd
41733 | 31.01.09 | 117376 | 2931.5 | 439.73 | 3371.23 | TEST LTD | 1625 | See Int Invoice 41866 | ….
41734 | 11.01.09 | P57297Y | 92.34 | 13.85 | 106.19 | TEST LTD | 2045 |  | pd
41735 | 08.01.09 | C0056113 | -16.16 | 0 | -16.16 | TEST LTD | 1631 |  | pd | c
41736 | 31.01.09 | 066605 | 228.69 | 34.3 | 262.99 | TEST LTD | 1720 |  | pd
41737 | 27.01.09 | I01079227 | 68 | 10.2 | 78.2 | TEST LTD | 1620 |  | pd
41738 | 31.01.09 | 066590 | 1193.39 | 179.01 | 1372.4 | TEST LTD | 1720 |  | pd
41739 | 26.01.09 | [PHONE] | 436.15 | 65.41 | 501.5599999999999 | TEST LTD | Various | D.D due on 09.02.09 | pd
41740 | 19.01.09 | [PHONE] | 475.46 | 71.32 | 546.78 | TEST LTD | Various | D.D due on 02.02.09 | pd
41741 | 01.01.09 | Internal Credit | -1560 | 0 | -1560 | TEST LTD | 1625 |  | ….. | c
41742 | 01.01.09 | Internal Invoice | 1064.8 | 0 | 1064.8 | TEST LTD | 2604 |  | ….
41743 | 23.01.09 | 07861876 | 26.07 | 3.91 | 29.98 | TEST LTD | 1620 |  | pd
41744 | 21.01.09 | 00322 | 1939.37 | 290.91 | 2230.28 | TEST LTD | 2704 | Query file
41745 | 01.01.09 | Internal Credit | -46.97 | 0 | -46.97 | TEST LTD | 2609 |  | …. | c
41746 | 13.01.09 | SIN18431 | 150 | 22.5 | 172.5 | TEST LTD | 1621 |  | pd
41747 | 30.01.09 | SIN18736 | 65 | 9.75 | 74.75 | TEST LTD | 1720 |  | pd
41748 | 30.11.08 | 065125 | 350 | 61.25 | 411.25 | TEST LTD | 1620 |  | pd
41749 | 16.10.08 | IN106978 | 1894 | 331.45 | 2225.45 | TEST LTD | 2026 |  | pd
41750 | 31.01.09 | 602159 | 3558.03 | 533.7 | 4091.73 | TEST LTD | 1610 |  | pd
41751 | 08.01.09 | 2527 | -40 | -7 | -47 | TEST LTD | 1621 |  | pd | c
 |  |  | 274183.5600000002 | 34755.55000000002 | 308939.1100000002
 | NET & VAT: |  |  |  | 308939.1100000003