Spreadsheet: 133614d1324499862-vlookup-search-tick-and-bash-test
Sheet: Sheet1

Tick & Bash via Excel
Paste info from statement here |  |  |  |  | Paste info from cleared here |  |  |  |  | Paste info from register here |  |  |  | Paste info from 7i voucher in progress here
Invoice | Value (£) | Comments |  |  | Invoice | Value (£) | Comments |  |  | Invoice | Value (£) | Comments |  | Invoice | Value (£) | Comments
1247525 | 235.98 | Cleared for payement |  |  | 1248697 | 51.84 |  |  |  | 1246123 | 637.7 |  |  | 1231512 | 285.71
819288 | -4913.35 | Cleared for payement |  |  | 1070313 | 0.52 |  |  |  | 1246712 | 492 |  |  | 1234457 | 9.56
959084 | 261.56 | Cleared for payement |  |  | 1070318 | 224.64 |  |  |  | 1249012 | 1084.09 |  |  | 1246265 | 12.83
959509 | 11.21 | Cleared for payement |  |  | 1070342 | 224.64 |  |  |  | 947469 | 3203.36 |  |  | 1247534 | 93.44
959539 | 106.78 | Cleared for payement |  |  | 1070346 | 5.4 |  |  |  | 949669 | 1377.76 |  |  | 1247474 | 263.27
959606 | 320.32 | Cleared for payement |  |  | 1070367 | 10.84 |  |  |  | 950345 | 1159.3 |  |  | 1247616 | 107.81
959661 | 1261.34 | Cleared for payement |  |  | 1239577 | 27.91 |  |  |  | 951061 | 1118.15 |  |  | 1247839 | 51.92
1070313 | 0.52 | Cleared for payement |  |  | 1244860 | 25.74 |  |  |  | 951062 | 1117.26 |  |  | 1248163 | 178.7
1070318 | 224.64 | Cleared for payement |  |  | 1246123 | 637.7 |  |  |  | 1230412 | 329.29 |  |  | 1248293 | 9.23
100 | 224.64 | No match |  |  | 1246125 | -637.7 |  |  |  | 1231923 | 158.86 |  |  | 1248340 | 181.4
1070346 | 5.4 | Cleared for payement |  |  | 1246264 | 148.54 |  |  |  | 1233659 | 6.01 |  |  | 1248387 | 9.11
1070367 | 10.84 | Cleared for payement |  |  | 1246375 | 44.2 |  |  |  | 1236986 | 48.11 |  |  | 1248701 | 53.04
1244860 | 25.74 | Cleared for payement |  |  | 1246408 | 557.5 |  |  |  | 1237623 | 30.4 |  |  | 1248706 | 121.49
1244860 | 25.74 | Cleared for payement |  |  | 1246423 | 27.08 |  |  |  | 953160 | 6026.28 |  |  | 1248708 | 225.04
1246123 | 637.7 | Cleared for payement |  |  | 1246712 | 492 |  |  |  | 953078 | 2019.6 |  |  | 1248694 | 318.19
1246125 | -637.7 | Cleared for payement |  |  | 1246730 | 3.22 |  |  |  | 952450 | 3662.23 |  |  | 1248705 | 63.53
1246375 | 44.2 | Cleared for payement |  |  | 1247210 | 637.7 |  |  |  | 953183 | 7010.99 |  |  | 1237758 | 307.22
1246408 | 557.5 | Cleared for payement |  |  | 1247236 | 227.71 |  |  |  | 1239647 | 53.89 |  |  | 1238021 | 196.68
1246423 | 27.08 | Cleared for payement |  |  | 1247353 | 114.29 |  |  |  | 1240910 | 160.45 |  |  | 1241055 | 126.23
1246712 | 492 | Cleared for payement |  |  | 1247376 | 23.34 |  |  |  | 1242846 | 0.58 |  |  | 1241138 | 789.13
1247210 | 637.7 | Cleared for payement |  |  | 1247471 | 19.72 |  |  |  | 819142 | -5764.8 |  |  | 2079566 | 125.26
1247471 | 19.72 | Cleared for payement |  |  | 1247472 | 7.07 |  |  |  | 819143 | -5584.8 |  |  | 1241681 | 4.97
1247472 | 7.07 | Cleared for payement |  |  | 1247475 | 20.9 |  |  |  | 2082322 | 12062.4 |  |  | 1241680 | 451.62
1247475 | 20.9 | Cleared for payement |  |  | 1247479 | 16.3 |  |  |  | 1243974 | 30.58 |  |  | 2081839 | 690.36
1247489 | 19.72 | Cleared for payement |  |  | 1247489 | 19.72 |  |  |  | 1244095 | 427.93 |  |  | 1243338 | 1284.36
1247490 | 2.04 | Cleared for payement |  |  | 1247490 | 2.04 |  |  |  | 1244270 | 121.32 |  |  | 1243735 | 1150.15
1247501 | 3.47 | Cleared for payement |  |  | 1247491 | 46.54 |  |  |  | 1244271 | 30.58 |  |  | 1243752 | 1259.54
1247502 | 133.79 | Cleared for payement |  |  | 1247501 | 3.47 |  |  |  | 1244272 | 141 |  |  | 1243853 | 176.64
1247505 | 122.18 | Cleared for payement |  |  | 1247502 | 133.79 |  |  |  | 957744 | 167.3 |  |  | 1244859 | 176.64
1247525 | 235.98 | Cleared for payement |  |  | 1247505 | 122.18 |  |  |  | 1244756 | 121.32 |  |  | 1246074 | 322.21
1247533 | 16.44 | Cleared for payement |  |  | 1247518 | 274.26 |  |  |  | 1244821 | 121.32 |  |  | 1246319 | 74.59
1247541 | 463.57 | Cleared for payement |  |  | 1247519 | 17.39 |  |  |  | 1245022 | 79.45 |  |  | 1247277 | 48.68
1247547 | 156.98 | Cleared for payement |  |  | 1247525 | 235.98 |  |  |  | 1245411 | 132.46 |  |  | 1247503 | 2.04
1247550 | 7.6 | Cleared for payement |  |  | 1247528 | 385.64 |  |  |  | 1245414 | 411.58 |  |  | 1247688 | 267.37
1247551 | 82.97 | Cleared for payement |  |  | 1247533 | 16.44 |  |  |  | 1245415 | 617.47 |  |  | 1248382 | 6.36
1247554 | 23.39 | Cleared for payement |  |  | 1247541 | 463.57 |  |  |  | 1245416 | 617.47 |  |  | 1241983 | 4296.89
1247558 | 27.07 | Cleared for payement |  |  | 1247547 | 156.98 |  |  |  | 2084056 | 48 |  |  | 1246472 | 41.06
1247570 | 36.1 | Cleared for payement |  |  | 1247550 | 7.6 |  |  |  | 2084058 | 48
1247603 | 7.76 | Cleared for payement |  |  | 1247551 | 82.97 |  |  |  | 1245611 | -637.7
1247604 | 107.8 | Cleared for payement |  |  | 1247554 | 23.39 |  |  |  | 2084629 | 48
1247609 | 246.89 | Cleared for payement |  |  | 1247558 | 27.07 |  |  |  | 1246337 | 222.95
1247615 | 36.34 | Cleared for payement |  |  | 1247570 | 36.1 |  |  |  | 1236336 | 85.48
1247632 | 88.87 | Cleared for payement |  |  | 1247603 | 7.76 |  |  |  | 1246468 | 185.24
1247633 | 31.06 | Cleared for payement |  |  | 1247604 | 107.8 |  |  |  | 1246843 | -492
1247634 | 46.7 | Cleared for payement |  |  | 1247608 | 69.66 |  |  |  | 1246819 | -384
1247635 | 2.35 | Cleared for payement |  |  | 1247609 | 246.89 |  |  |  | 1246827 | -57.46
1247636 | 191.04 | Cleared for payement |  |  | 1247615 | 36.34 |  |  |  | 819255 | -8.28
1247637 | 11.88 | Cleared for payement |  |  | 1247617 | 96.1 |  |  |  | 1246970 | 51.74
1247643 | 25.62 | Cleared for payement |  |  | 1247632 | 88.87 |  |  |  | 1247073 | 76.99
1247653 | 2.1 | Cleared for payement |  |  | 1247633 | 31.06 |  |  |  | 1247418 | 103.5
1247686 | 369.78 | Cleared for payement |  |  | 1247634 | 46.7 |  |  |  | 1247487 | 235.21
1247687 | 31.19 | Cleared for payement |  |  | 1247635 | 2.35 |  |  |  | 1247724 | 45.91
1247693 | 49.39 | Cleared for payement |  |  | 1247636 | 191.04 |  |  |  | 1248300 | 195.38
1247716 | 259.61 | Cleared for payement |  |  | 1247637 | 11.88 |  |  |  | 1248367 | -420
1247735 | 32.62 | Cleared for payement |  |  | 1247643 | 25.62 |  |  |  | 958500 | 917.92
1247748 | 3.47 | Cleared for payement |  |  | 1247653 | 2.1 |  |  |  | 959248 | 69.05
1247750 | 259.61 | Cleared for payement |  |  | 1247686 | 369.78
1247771 | 86.64 | Cleared for payement |  |  | 1247687 | 31.19
1247774 | 208.79 | Cleared for payement |  |  | 1247693 | 49.39
1247778 | 2.22 | Cleared for payement |  |  | 1247716 | 259.61
1247779 | 201.64 | Cleared for payement |  |  | 1247735 | 32.62
1247780 | 284.52 | Cleared for payement |  |  | 1247748 | 3.47
1247803 | 102.65 | Cleared for payement |  |  | 1247750 | 259.6
1247804 | 33.19 | Cleared for payement |  |  | 1247753 | 246.12
1247805 | 112.44 | Cleared for payement |  |  | 1247771 | 86.64
1247807 | 86.7 | Cleared for payement |  |  | 1247774 | 208.79
1247816 | 16.39 | Cleared for payement |  |  | 1247778 | 2.22
1247820 | 60.55 | Cleared for payement |  |  | 1247779 | 201.64
1247837 | 204.91 | Cleared for payement |  |  | 1247780 | 284.52
1247838 | 20.68 | Cleared for payement |  |  | 1247803 | 102.65
1247841 | 16.57 | Cleared for payement |  |  | 1247804 | 33.19
1247874 | 35.94 | Cleared for payement |  |  | 1247805 | 112.44
1247875 | 2.22 | Cleared for payement |  |  | 1247807 | 86.7
1247876 | 11.78 | Cleared for payement |  |  | 1247808 | 55.02
1247914 | 288.28 | Cleared for payement |  |  | 1247816 | 16.39
1247918 | 11.71 | Cleared for payement |  |  | 1247820 | 60.55
1247945 | 6.98 | Cleared for payement |  |  | 1247824 | 63.38
1247950 | 19.24 | Cleared for payement |  |  | 1247825 | 458.27
1248006 | 167.59 | Cleared for payement |  |  | 1247837 | 204.91
1248007 | 6.19 | Cleared for payement |  |  | 1247838 | 20.68
1248016 | 60.28 | Cleared for payement |  |  | 1247841 | 16.57
1248019 | 63.2 | Cleared for payement |  |  | 1247867 | 86.51
1248020 | 258.64 | Cleared for payement |  |  | 1247874 | 35.94
1248025 | 312.08 | Cleared for payement |  |  | 1247875 | 2.22
1248026 | 252.41 | Cleared for payement |  |  | 1247876 | 11.78
1248027 | 461.22 | Cleared for payement |  |  | 1247914 | 288.28
1248029 | 7.67 | Cleared for payement |  |  | 1247917 | 25.55
1248030 | 34.44 | Cleared for payement |  |  | 1247918 | 11.71
1248043 | 60.28 | Cleared for payement |  |  | 1247945 | 6.98
1248044 | 18.17 | Cleared for payement |  |  | 1247950 | 19.24
1248057 | 3.71 | Cleared for payement |  |  | 1248006 | 167.59
1248058 | 102.17 | Cleared for payement |  |  | 1248007 | 6.19
1248080 | 268.51 | Cleared for payement |  |  | 1248016 | 60.28
1248081 | 583.01 | Cleared for payement |  |  | 1248019 | 63.2
1248088 | 190.75 | Cleared for payement |  |  | 1248020 | 258.64
1248089 | 62.69 | Cleared for payement |  |  | 1248025 | 312.08
1248114 | 74.78 | Cleared for payement |  |  | 1248026 | 252.41
1248115 | 139.68 | Cleared for payement |  |  | 1248027 | 461.22
1248116 | 279.36 | Cleared for payement |  |  | 1248029 | 7.67
1248117 | 279.36 | Cleared for payement |  |  | 1248030 | 34.44
1248144 | 285.56 | Cleared for payement |  |  | 1248031 | 166.42
1248164 | 309.6 | Cleared for payement |  |  | 1248043 | 60.28
1248165 | 59.68 | Cleared for payement |  |  | 1248044 | 18.17
1248166 | 44.45 | Cleared for payement |  |  | 1248057 | 3.71
1248193 | 41.3 | Cleared for payement |  |  | 1248058 | 102.17
1248198 | 148.38 | Cleared for payement |  |  | 1248060 | 113.96
1248199 | 5.6 | Cleared for payement |  |  | 1248080 | 268.51
1248249 | 27.83 | Cleared for payement |  |  | 1248081 | 583.01
1248250 | 280.46 | Cleared for payement |  |  | 1248088 | 190.75
1248251 | 2.12 | Cleared for payement |  |  | 1248089 | 62.69
1248273 | 75.04 | Cleared for payement |  |  | 1248114 | 74.78
1248294 | 553.39 | Cleared for payement |  |  | 1248115 | 139.68
1248303 | 41.64 | Cleared for payement |  |  | 1248116 | 279.36
1248326 | 38.17 | Cleared for payement |  |  | 1248117 | 279.36
1248331 | 18.05 | Cleared for payement |  |  | 1248144 | 285.56
1248333 | 5.64 | Cleared for payement |  |  | 1248154 | 36.42
1248334 | 205.78 | Cleared for payement |  |  | 1248164 | 309.6
1248337 | 357.47 | Cleared for payement |  |  | 1248165 | 59.68
1248339 | 89.46 | Cleared for payement |  |  | 1248166 | 44.45
1248341 | 3.47 | Cleared for payement |  |  | 1248193 | 41.3
1248350 | 103.08 | Cleared for payement |  |  | 1248198 | 148.38
1248377 | 173.05 | Cleared for payement |  |  | 1248199 | 5.6
1248378 | 46.69 | Cleared for payement |  |  | 1248249 | 27.83
1248401 | 68.96 | Cleared for payement |  |  | 1248250 | 280.46
1248404 | 270.36 | Cleared for payement |  |  | 1248251 | 2.12
1248405 | 14.64 | Cleared for payement |  |  | 1248273 | 75.04
1248430 | 119.35 | Cleared for payement |  |  | 1248294 | 553.39
1248445 | 196.57 | Cleared for payement |  |  | 1248303 | 41.64
1248446 | 11.96 | Cleared for payement |  |  | 1248309 | 1246.3
1248450 | 148.14 | Cleared for payement |  |  | 1248311 | 87.96
1248514 | 256.15 | Cleared for payement |  |  | 1248326 | 38.17
1248516 | 9.02 | Cleared for payement |  |  | 1248331 | 18.05
1248517 | 2.35 | Cleared for payement |  |  | 1248332 | 87.96
1248519 | 2.35 | Cleared for payement |  |  | 1248333 | 5.64
1248520 | 14.15 | Cleared for payement |  |  | 1248334 | 205.78
1248521 | 4.85 | Cleared for payement |  |  | 1248337 | 357.47
1248531 | 10.44 | Cleared for payement |  |  | 1248339 | 89.46
1248532 | 10.21 | Cleared for payement |  |  | 1248341 | 3.47
1248533 | 11.78 | Cleared for payement |  |  | 1248344 | 474.34
1248534 | 5.75 | Cleared for payement |  |  | 1248350 | 103.08
1248535 | 60.26 | Cleared for payement |  |  | 1248377 | 173.05
1248585 | 6.79 | Cleared for payement |  |  | 1248378 | 46.69
1248612 | 1.92 | Cleared for payement |  |  | 1248395 | 71.58
1248688 | 23.75 | Cleared for payement |  |  | 1248401 | 68.96
1248697 | 51.84 | Cleared for payement |  |  | 1248404 | 270.36
1248699 | 62.38 | Cleared for payement |  |  | 1248405 | 14.64
1248702 | 38.88 | Cleared for payement |  |  | 1248423 | 10.33
1248703 | 12.65 | Cleared for payement |  |  | 1248430 | 119.35
1248704 | 12.48 | Cleared for payement |  |  | 1248439 | 61.36
1248722 | 19.61 | Cleared for payement |  |  | 1248445 | 196.57
1248723 | 178.39 | Cleared for payement |  |  | 1248446 | 11.96
2081454 | 116.14 | Cleared for payement |  |  | 1248450 | 148.14
2084674 | 485.39 | Cleared for payement |  |  | 1248514 | 256.15
2084953 | 1895.36 | Cleared for payement |  |  | 1248516 | 9.02
2085015 | 15029.02 | Cleared for payement |  |  | 1248517 | 2.35
2085061 | 2882.24 | Cleared for payement |  |  | 1248518 | 116.71
2085386 | 348.67 | Cleared for payement |  |  | 1248519 | 2.35
2085496 | 584.66 | Cleared for payement |  |  | 1248520 | 14.15
2085774 | 1240.15 | Cleared for payement |  |  | 1248521 | 4.85
2085925 | 1281.73 | Cleared for payement |  |  | 1248522 | 13.38
2086015 | 412.68 | Cleared for payement |  |  | 1248530 | 19.07
2086188 | 1048.37 | Cleared for payement |  |  | 1248531 | 10.44
2086190 | 684.54 | Cleared for payement |  |  | 1248532 | 10.21
2086498 | 496.28 | Cleared for payement |  |  | 1248533 | 11.78
2086518 | 503.27 | Cleared for payement |  |  | 1248534 | 5.75
2086678 | 834.66 | Cleared for payement |  |  | 1248535 | 60.26
2086712 | 346.64 | Cleared for payement |  |  | 1248562 | 337.7
2086881 | 832.97 | Cleared for payement |  |  | 1248585 | 6.79
1243853 | 176.64 | Cleared for payement | 7i |  | 1248591 | 71.88
1244859 | 176.64 | Cleared for payement | 7i |  | 1248612 | 1.92
1248387 | 9.11 | Cleared for payement | 7i |  | 1248659 | 246.55
958486 | 686.87 | No match |  |  | 1248688 | 23.75
1237758 | 307.22 | Cleared for payement | 7i |  | 1248689 | 81.94
1238021 | 196.68 | Cleared for payement | 7i |  | 1248691 | 314.84
1241055 | 126.23 | Cleared for payement | 7i |  | 1248692 | 135.3
1243735 | 1150.15 | Cleared for payement | 7i |  | 1248693 | 377.26
1243735 | 1150.15 | Cleared for payement | 7i |  | 1248699 | 62.38
1243853 | 176.64 | Cleared for payement | 7i |  | 1248702 | 38.88
1244859 | 176.64 | Cleared for payement | 7i |  | 1248703 | 12.65
1245635 | 54 | No match |  |  | 1248704 | 12.48
1246074 | 322.21 | Cleared for payement | 7i |  | 1248721 | 237.17
1246265 | 12.83 | Cleared for payement | 7i |  | 1248722 | 19.61
1246319 | 74.59 | Cleared for payement | 7i |  | 1248723 | 178.39
1246336 | 85.48 | No match |  |  | 1248724 | 355.75
1247474 | 263.27 | Cleared for payement | 7i |  | 2081454 | 116.14
1247503 | 2.04 | Cleared for payement | 7i |  | 2084674 | 485.39
1247504 | 178.39 | No match |  |  | 2084953 | 1895.36
1247529 | 7.84 | No match |  |  | 2085015 | 15029.02
1247534 | 93.44 | Cleared for payement | 7i |  | 2085061 | 2882.24
1247688 | 267.37 | Cleared for payement | 7i |  | 2085386 | 348.67
1247730 | 5.24 | No match |  |  | 2085496 | 584.66
1247839 | 51.92 | Cleared for payement | 7i |  | 2085774 | 1240.15
1248163 | 178.7 | Cleared for payement | 7i |  | 2085925 | 1281.73
1248254 | 713.28 | No match |  |  | 2086015 | 412.68
1248293 | 9.23 | Cleared for payement | 7i |  | 2086188 | 1048.37
1248336 | 87.77 | No match |  |  | 2086190 | 684.54
1248338 | 34.66 | No match |  |  | 2086201 | 15.97
1248340 | 181.4 | Cleared for payement | 7i |  | 2086253 | 15.97
1248382 | 6.36 | Cleared for payement | 7i |  | 2086498 | 496.28
1248387 | 9.11 | Cleared for payement | 7i |  | 2086518 | 503.27
1248694 | 318.19 | Cleared for payement | 7i |  | 2086678 | 834.66
1248701 | 53.04 | Cleared for payement | 7i |  | 2086712 | 346.64
1248708 | 225.04 | Cleared for payement | 7i |  | 2086881 | 832.97
1248730 | 103.15 | No match |  |  | 2086960 | 337.1
1248731 | 21.38 | No match |  |  | 819283 | -0.58
1248732 | 45.36 | No match |  |  | 819288 | -4913.35
1248733 | 4.75 | No match |  |  | 959084 | 261.56
2079566 | 125.26 | Cleared for payement | 7i |  | 959509 | 11.21
2081839 | 690.36 | Cleared for payement | 7i |  | 959539 | 106.78
2085847 | 701.64 | No match |  |  | 959606 | 320.32
2086362 | 160.32 | No match |  |  | 959661 | 1261.34
1237623 | 30.4 | Cleared for payement
1240910 | 160.45 | Cleared for payement
819255 | -8.28 | Cleared for payement
947469 | 3203.36 | Cleared for payement
949669 | 1377.76 | Cleared for payement
950345 | 1159.3 | Cleared for payement
951061 | 1118.15 | Cleared for payement
951062 | 1117.26 | Cleared for payement
952450 | 3662.23 | Cleared for payement
953078 | 2019.6 | Cleared for payement
953160 | 6026.28 | Cleared for payement
953183 | 7010.99 | Cleared for payement
957744 | 167.3 | Cleared for payement
958500 | 917.92 | Cleared for payement
959248 | 69.05 | Cleared for payement
1230412 | 329.29 | Cleared for payement
1236986 | 48.11 | Cleared for payement
1237623 | 30.4 | Cleared for payement
1239647 | 53.89 | Cleared for payement
1240910 | 160.45 | Cleared for payement
1242846 | 0.58 | Cleared for payement
1245022 | 79.45 | Cleared for payement
1245411 | 132.46 | Cleared for payement
1245415 | 617.47 | Cleared for payement
1245416 | 617.47 | Cleared for payement
1245611 | -637.7 | Cleared for payement
1246337 | 222.95 | Cleared for payement
1246819 | -384 | Cleared for payement
1246827 | -57.46 | Cleared for payement
1246843 | -492 | Cleared for payement
1246970 | 51.74 | Cleared for payement
1247724 | 45.91 | Cleared for payement
1248300 | 195.38 | Cleared for payement
1248367 | -420 | Cleared for payement
2082322 | 712.8 | Cleared for payement
2084056 | 48 | Cleared for payement
2084629 | 48 | Cleared for payement