Spreadsheet: 773357d1647811386-add-and-delete-rows-from-tables-mock-up-invoice_database_sheet
Sheet: Transactions_Database

Claim Number | Recovery Agent | Agent's Ref | Portfolio Code | Third-Party | Invoice Number | Invoice Date | Amount | Ex Commission | GST | Inc Commission | Net Amount | File Reference 2
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | Wayne Enterprise | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
6754WCE | Wayne Enterprise | 89994 | WEAI | Customer 2 | Wayne Enterprise | 2022-01-31 00:00:00 | 100 | 12.5 | 1.25 | 13.75 | 86.25
6524WCE | Wayne Enterprise | 85378 | WEAI | Customer 3 | Wayne Enterprise | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
6548WCE | Wayne Enterprise | 54782 | WEAI | Customer 5 | TX7282 | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX7282 | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX7282 | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
6050WCE | Wayne Enterprise | 82822 | WEAI | Customer 8 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
5208WCE | Wayne Enterprise | 54771 | WEAI | Customer 9 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX7282 | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX7282 | 2022-01-31 00:00:00 | 100 | 12.5 | 1.25 | 13.75 | 86.25
6053WCE | Wayne Enterprise | 55063 | WEAI | Customer 12 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
4834WCE | Wayne Enterprise | 54541 | WEAI | Customer 13 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
5568WCE | Wayne Enterprise | 59998 | WEAI | Customer 14 | TX7282 | 2022-01-31 00:00:00 | 100 | 12.5 | 1.25 | 13.75 | 86.25
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7282 | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
5729WCE | Wayne Enterprise | 85378 | WEAI | Customer 16 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7282 | 2022-01-31 00:00:00 | 30 | 3.75 | 0.38 | 4.13 | 25.87
5774WCE | Wayne Enterprise | 85701 | WEAI | Customer 18 | TX7282 | 2022-01-31 00:00:00 | 50 | 6.25 | 0.63 | 6.88 | 43.12
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7282 | 2022-01-31 00:00:00 | 10 | 1.25 | 0.13 | 1.38 | 8.620000000000001
6999WCE | Wayne Enterprise | 84664 | WEAI | Customer 20 | TX7282 | 2022-01-31 00:00:00 | 25 | 3.13 | 0.31 | 3.44 | 21.56
5951WCE | Wayne Enterprise | 84664 | WEAI | Customer 21 | TX7282 | 2022-01-31 00:00:00 | 25 | 3.13 | 0.31 | 3.44 | 21.56
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7282 | 2022-01-31 00:00:00 | 20 | 2.5 | 0.25 | 2.75 | 17.25
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX3662 | 2022-03-17 00:00:00 | 1969 | 492.25 | 49.225 | 541.475 | 1427.525
6754WCE | Wayne Enterprise | 89994 | WEAI | Customer 2 | TX3662 | 2022-03-17 00:00:00 | 1964 | 491 | 49.1 | 540.1 | 1423.9
6524WCE | Wayne Enterprise | 85378 | WEAI | Customer 3 | TX3662 | 2022-03-17 00:00:00 | 1199 | 299.75 | 29.975 | 329.725 | 869.275
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX3662 | 2022-03-17 00:00:00 | 1102 | 275.5 | 27.55 | 303.05 | 798.95
6548WCE | Wayne Enterprise | 54782 | WEAI | Customer 5 | TX3662 | 2022-03-17 00:00:00 | 43 | 10.75 | 1.075 | 11.825 | 31.175
4626WCE | Wayne Enterprise | 55122 | WEAI | Customer50 | TX3662 | 2022-03-17 00:00:00 | 1550 | 387.5 | 38.75 | 426.25 | 1123.75
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX3662 | 2022-03-17 00:00:00 | 1504 | 376 | 37.6 | 413.6 | 1090.4
6050WCE | Wayne Enterprise | 82822 | WEAI | Customer 8 | TX3662 | 2022-03-17 00:00:00 | 709 | 177.25 | 17.725 | 194.975 | 514.025
5208WCE | Wayne Enterprise | 54771 | WEAI | Customer 9 | TX3662 | 2022-03-17 00:00:00 | 1723 | 430.75 | 43.075 | 473.825 | 1249.175
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX3662 | 2022-03-17 00:00:00 | 1996 | 499 | 49.90000000000001 | 548.9 | 1447.1
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX3662 | 2022-03-17 00:00:00 | 1297 | 324.25 | 32.425 | 356.675 | 940.325
6053WCE | Wayne Enterprise | 55063 | WEAI | Customer 12 | TX3662 | 2022-03-17 00:00:00 | 1455 | 363.75 | 36.375 | 400.125 | 1054.875
4834WCE | Wayne Enterprise | 54541 | WEAI | Customer 13 | TX3662 | 2022-03-17 00:00:00 | 1508 | 377 | 37.7 | 414.7 | 1093.3
5568WCE | Wayne Enterprise | 59998 | WEAI | Customer 14 | TX3662 | 2022-03-17 00:00:00 | 492 | 123 | 12.3 | 135.3 | 356.7
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX3662 | 2022-03-17 00:00:00 | 1805 | 451.25 | 45.125 | 496.375 | 1308.625
5729WCE | Wayne Enterprise | 85378 | WEAI | Customer 16 | TX3662 | 2022-03-17 00:00:00 | 1535 | 383.75 | 38.375 | 422.125 | 1112.875
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX3662 | 2022-03-17 00:00:00 | 671 | 167.75 | 16.775 | 184.525 | 486.475
5774WCE | Wayne Enterprise | 85701 | WEAI | Customer 18 | TX3662 | 2022-03-17 00:00:00 | 1074 | 268.5 | 26.85 | 295.35 | 778.65
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX3662 | 2022-03-17 00:00:00 | 1294 | 323.5 | 32.35 | 355.85 | 938.15
6999WCE | Wayne Enterprise | 84664 | WEAI | Customer 20 | TX3662 | 2022-03-17 00:00:00 | 706 | 176.5 | 17.65 | 194.15 | 511.85
5951WCE | Wayne Enterprise | 84664 | WEAI | Customer 21 | TX3662 | 2022-03-17 00:00:00 | 516 | 129 | 12.9 | 141.9 | 374.1
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX3662 | 2022-03-17 00:00:00 | 379 | 94.75 | 9.475 | 104.225 | 274.775
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX6188 | 2022-01-18 00:00:00 | 241 | 60.25 | 6.025 | 66.275 | 174.725
6754WCE | Wayne Enterprise | 89994 | WEAI | Customer 2 | TX6188 | 2022-01-18 00:00:00 | 1176 | 294 | 29.4 | 323.4 | 852.6
6524WCE | Wayne Enterprise | 85378 | WEAI | Customer 3 | TX6188 | 2022-01-18 00:00:00 | 1802 | 450.5 | 45.05 | 495.55 | 1306.45
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX6188 | 2022-01-18 00:00:00 | 19 | 4.75 | 0.475 | 5.225 | 13.775
6548WCE | Wayne Enterprise | 54782 | WEAI | Customer 5 | TX6188 | 2022-01-18 00:00:00 | 370 | 92.5 | 9.25 | 101.75 | 268.25
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX6188 | 2022-01-18 00:00:00 | 208 | 52 | 5.2 | 57.2 | 150.8
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX6188 | 2022-01-18 00:00:00 | 1514 | 378.5 | 37.85 | 416.35 | 1097.65
6050WCE | Wayne Enterprise | 82822 | WEAI | Customer 8 | TX6188 | 2022-01-18 00:00:00 | 1122 | 280.5 | 28.05 | 308.55 | 813.45
5208WCE | Wayne Enterprise | 54771 | WEAI | Customer 9 | TX6188 | 2022-01-18 00:00:00 | 250 | 62.5 | 6.25 | 68.75 | 181.25
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX6188 | 2022-01-18 00:00:00 | 1471 | 367.75 | 36.775 | 404.525 | 1066.475
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX6188 | 2022-01-18 00:00:00 | 873 | 218.25 | 21.825 | 240.075 | 632.925
6053WCE | Wayne Enterprise | 55063 | WEAI | Customer 12 | TX6188 | 2022-01-18 00:00:00 | 744 | 186 | 18.6 | 204.6 | 539.4
4834WCE | Wayne Enterprise | 54541 | WEAI | Customer 13 | TX6188 | 2022-01-18 00:00:00 | 459 | 114.75 | 11.475 | 126.225 | 332.775
5568WCE | Wayne Enterprise | 59998 | WEAI | Customer 14 | TX6188 | 2022-01-18 00:00:00 | 983 | 245.75 | 24.575 | 270.325 | 712.675
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX6188 | 2022-01-18 00:00:00 | 46 | 11.5 | 1.15 | 12.65 | 33.35
5729WCE | Wayne Enterprise | 85378 | WEAI | Customer 16 | TX6188 | 2022-01-18 00:00:00 | 1291 | 322.75 | 32.275 | 355.025 | 935.975
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX6188 | 2022-01-18 00:00:00 | 1632 | 408 | 40.8 | 448.8 | 1183.2
5774WCE | Wayne Enterprise | 85701 | WEAI | Customer 18 | TX6188 | 2022-01-18 00:00:00 | 664 | 166 | 16.6 | 182.6 | 481.4
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX6188 | 2022-01-18 00:00:00 | 1837 | 459.25 | 45.925 | 505.175 | 1331.825
6999WCE | Wayne Enterprise | 84664 | WEAI | Customer 20 | TX6188 | 2022-01-18 00:00:00 | 1247 | 311.75 | 31.175 | 342.925 | 904.075
5951WCE | Wayne Enterprise | 84664 | WEAI | Customer 21 | TX6188 | 2022-01-18 00:00:00 | 1427 | 356.75 | 35.675 | 392.425 | 1034.575
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX6188 | 2022-01-18 00:00:00 | 1283 | 320.75 | 32.075 | 352.825 | 930.175
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX7389 | 2022-11-24 00:00:00 | 200 | 50 | 5 | 55 | 145
6754WCE | Wayne Enterprise | 89994 | WEAI | Customer 2 | TX7389 | 2022-11-24 00:00:00 | 620 | 155 | 15.5 | 170.5 | 449.5
6524WCE | Wayne Enterprise | 85378 | WEAI | Customer 3 | TX7389 | 2022-11-24 00:00:00 | 1306 | 326.5 | 32.65 | 359.15 | 946.85
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX7389 | 2022-11-24 00:00:00 | 1713 | 428.25 | 42.825 | 471.075 | 1241.925
6548WCE | Wayne Enterprise | 54782 | WEAI | Customer 5 | TX7389 | 2022-11-24 00:00:00 | 749 | 187.25 | 18.725 | 205.975 | 543.025
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX7389 | 2022-11-24 00:00:00 | 155 | 38.75 | 3.875 | 42.625 | 112.375
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX7389 | 2022-11-24 00:00:00 | 401 | 100.25 | 10.025 | 110.275 | 290.725
6050WCE | Wayne Enterprise | 82822 | WEAI | Customer 8 | TX7389 | 2022-11-24 00:00:00 | 1625 | 406.25 | 40.625 | 446.875 | 1178.125
5208WCE | Wayne Enterprise | 54771 | WEAI | Customer 9 | TX7389 | 2022-11-24 00:00:00 | 1473 | 368.25 | 36.825 | 405.075 | 1067.925
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX7389 | 2022-11-24 00:00:00 | 1767 | 441.75 | 44.175 | 485.925 | 1281.075
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX7389 | 2022-11-24 00:00:00 | 318 | 79.5 | 7.95 | 87.45 | 230.55
6053WCE | Wayne Enterprise | 55063 | WEAI | Customer 12 | TX7389 | 2022-11-24 00:00:00 | 288 | 72 | 7.2 | 79.2 | 208.8
4834WCE | Wayne Enterprise | 54541 | WEAI | Customer 13 | TX7389 | 2022-11-24 00:00:00 | 1785 | 446.25 | 44.625 | 490.875 | 1294.125
5568WCE | Wayne Enterprise | 59998 | WEAI | Customer 14 | TX7389 | 2022-11-24 00:00:00 | 568 | 142 | 14.2 | 156.2 | 411.8
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7389 | 2022-11-24 00:00:00 | 1072 | 268 | 26.8 | 294.8 | 777.2
5729WCE | Wayne Enterprise | 85378 | WEAI | Customer 16 | TX7389 | 2022-11-24 00:00:00 | 1005 | 251.25 | 25.125 | 276.375 | 728.625
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7389 | 2022-11-24 00:00:00 | 937 | 234.25 | 23.425 | 257.675 | 679.325
5774WCE | Wayne Enterprise | 85701 | WEAI | Customer 18 | TX7389 | 2022-11-24 00:00:00 | 830 | 207.5 | 20.75 | 228.25 | 601.75
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7389 | 2022-11-24 00:00:00 | 291 | 72.75 | 7.275 | 80.025 | 210.975
6999WCE | Wayne Enterprise | 84664 | WEAI | Customer 20 | TX7389 | 2022-11-24 00:00:00 | 1716 | 429 | 42.90000000000001 | 471.9 | 1244.1
5951WCE | Wayne Enterprise | 84664 | WEAI | Customer 21 | TX7389 | 2022-11-24 00:00:00 | 648 | 162 | 16.2 | 178.2 | 469.8
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX7389 | 2022-11-24 00:00:00 | 758 | 189.5 | 18.95 | 208.45 | 549.55
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX1923 | 2022-03-08 00:00:00 | 1685 | 421.25 | 42.125 | 463.375 | 1221.625
6754WCE | Wayne Enterprise | 89994 | WEAI | Customer 2 | TX1923 | 2022-03-08 00:00:00 | 41 | 10.25 | 1.025 | 11.275 | 29.725
6524WCE | Wayne Enterprise | 85378 | WEAI | Customer 3 | TX1923 | 2022-03-08 00:00:00 | 1033 | 258.25 | 25.825 | 284.075 | 748.925
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX1923 | 2022-03-08 00:00:00 | 1869 | 467.25 | 46.725 | 513.975 | 1355.025
6548WCE | Wayne Enterprise | 54782 | WEAI | Customer 5 | TX1923 | 2022-03-08 00:00:00 | 688 | 172 | 17.2 | 189.2 | 498.8
4625WCE | Wayne Enterprise | 55122 | WEAI | Customer 1 | TX1923 | 2022-03-08 00:00:00 | 1397 | 349.25 | 34.925 | 384.175 | 1012.825
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX1923 | 2022-03-08 00:00:00 | 1678 | 419.5 | 41.95 | 461.45 | 1216.55
6050WCE | Wayne Enterprise | 82822 | WEAI | Customer 8 | TX1923 | 2022-03-08 00:00:00 | 1347 | 336.75 | 33.675 | 370.425 | 976.575
5208WCE | Wayne Enterprise | 54771 | WEAI | Customer 9 | TX1923 | 2022-03-08 00:00:00 | 22 | 5.5 | 0.55 | 6.05 | 15.95
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX1923 | 2022-03-08 00:00:00 | 1519 | 379.75 | 37.975 | 417.725 | 1101.275
6808WCE | Wayne Enterprise | 54866 | WEAI | Customer 7 | TX1923 | 2022-03-08 00:00:00 | 1280 | 320 | 32 | 352 | 928
6053WCE | Wayne Enterprise | 55063 | WEAI | Customer 12 | TX1923 | 2022-03-08 00:00:00 | 661 | 165.25 | 16.525 | 181.775 | 479.225
4834WCE | Wayne Enterprise | 54541 | WEAI | Customer 13 | TX1923 | 2022-03-08 00:00:00 | 153 | 38.25 | 3.825 | 42.075 | 110.925
5568WCE | Wayne Enterprise | 59998 | WEAI | Customer 14 | TX1923 | 2022-03-08 00:00:00 | 1702 | 425.5 | 42.55 | 468.05 | 1233.95
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX1923 | 2022-03-08 00:00:00 | 1460 | 365 | 36.5 | 401.5 | 1058.5
5729WCE | Wayne Enterprise | 85378 | WEAI | Customer 16 | TX1923 | 2022-03-08 00:00:00 | 1710 | 427.5 | 42.75 | 470.25 | 1239.75
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX1923 | 2022-03-08 00:00:00 | 392 | 98 | 9.8 | 107.8 | 284.2
5774WCE | Wayne Enterprise | 85701 | WEAI | Customer 18 | TX1923 | 2022-03-08 00:00:00 | 1587 | 396.75 | 39.675 | 436.425 | 1150.575
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX1923 | 2022-03-08 00:00:00 | 916 | 229 | 22.9 | 251.9 | 664.1
6999WCE | Wayne Enterprise | 84664 | WEAI | Customer 20 | TX1923 | 2022-03-08 00:00:00 | 963 | 240.75 | 24.075 | 264.825 | 698.175
5951WCE | Wayne Enterprise | 84664 | WEAI | Customer 21 | TX1923 | 2022-03-08 00:00:00 | 1520 | 380 | 38 | 418 | 1102
6900WCE | Wayne Enterprise | 85377 | WEAI | Customer 4 | TX1923 | 2022-03-08 00:00:00 | 265 | 66.25 | 6.625 | 72.875 | 192.125