Spreadsheet: 869864d1716404473-formula-to-extract-every-tenth-transaction-audit-sample
Sheet: Sales

 | Date | I.D Number | Account Number | Group Code | Group | Description | Invoice | Reference | Term | Amount
 | 2024-01-03 00:00:00 | Cash - US$ | CT 395 | Fees | 2000 | C1 | Cash receipts from customers | 16521 | First Term | 1381994.284
 | 2024-01-03 00:00:00 | Cash - US$ | CT 361 | Fees | 2000 | C1 | Cash receipts from customers | 16522 | First Term | 1381994.284
 | 2024-01-03 00:00:00 | Cash - US$ | CT 149 | Fees | 2000 | C1 | Cash receipts from customers | 16523 | First Term | 1381994.284
 | 2024-01-03 00:00:00 | Cash - US$ | CT 142 | Fees | 2000 | C1 | Cash receipts from customers | 16524 | First Term | 1381994.284
 | 2024-01-03 00:00:00 | Cash - US$ | CT 481 | Fees | 2000 | C1 | Cash receipts from customers | 16525 | First Term | 1381994.284
 | 2024-01-04 00:00:00 | Cash - US$ | CT 394 | Fees | 2000 | C1 | Cash receipts from customers | 16527 | First Term | 1398902.56
 | 2024-01-04 00:00:00 | Cash - US$ | CT 482 | Fees | 2000 | C1 | Cash receipts from customers | 16528 | First Term | 2797805.12
 | 2024-01-04 00:00:00 | Cash - US$ | CT 120 | Fees | 2000 | C1 | Cash receipts from customers | 16529 | First Term | 1398902.56
 | 2024-01-04 00:00:00 | Cash - US$ | CT 076 | Fees | 2000 | C1 | Cash receipts from customers | 16530 | First Term | 2797805.12
 | 2024-01-04 00:00:00 | Cash - US$ | CT 449 | Fees | 2000 | C1 | Cash receipts from customers | 16531 | First Term | 699451.28
 | 2024-01-04 00:00:00 | Cash - US$ | CT 163 | Fees | 2000 | C1 | Cash receipts from customers | 16532 | First Term | 279780.512
 | 2024-01-04 00:00:00 | Cash - US$ | CT 346 | Fees | 2000 | C1 | Cash receipts from customers | 16533 | First Term | 1398902.56
 | 2024-01-04 00:00:00 | Cash - US$ | CT 067 | Fees | 2000 | C1 | Cash receipts from customers | 16534 | First Term | 1748628.2
 | 2024-01-04 00:00:00 | Cash - US$ | CT 137 | Fees | 2000 | C1 | Cash receipts from customers | 16535 | First Term | 1748628.2
 | 2024-01-05 00:00:00 | Cash - US$ | CT 362 | Fees | 2000 | C1 | Cash receipts from customers | 16536 | First Term | 2267982.2176
 | 2024-01-05 00:00:00 | Cash - US$ | CT 459 | Fees | 2000 | C1 | Cash receipts from customers | 16537 | First Term | 2834977.772
 | 2024-01-05 00:00:00 | Cash - US$ | CT 483 | Fees | 2000 | C1 | Cash receipts from customers | 16538 | First Term | 2834977.772
 | 2024-01-05 00:00:00 | Cash - US$ | CT 440 | Fees | 2000 | C1 | Cash receipts from customers | 16539 | First Term | 708744.4430000001
 | 2024-01-05 00:00:00 | Cash - US$ | CT 440 | Fees | 2000 | C1 | Cash receipts from customers | 16540 | First Term | 708744.4430000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 431 | Fees | 2000 | C1 | Cash receipts from customers | 16541 | First Term | 711371.6940000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 165 | Fees | 2000 | C1 | Cash receipts from customers | 16542 | First Term | 711371.6940000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 467 | Fees | 2000 | C1 | Cash receipts from customers | 16543 | First Term | 1422743.388
 | 2024-01-08 00:00:00 | Cash - US$ | CT 461 | Fees | 2000 | C1 | Cash receipts from customers | 16544 | First Term | 2845486.776000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 407 | Fees | 2000 | C1 | Cash receipts from customers | 16545 | First Term | 711371.6940000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 004 | Fees | 2000 | C1 | Cash receipts from customers | 16546 | First Term | 320117.2623000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 087 | Fees | 2000 | C1 | Cash receipts from customers | 16547 | First Term | 391254.4317000001
 | 2024-01-08 00:00:00 | Cash - US$ | CT 432 | Fees | 2000 | C1 | Cash receipts from customers | 16549 | First Term | 1422743.388
 | 2024-01-04 00:00:00 | US$ | CT 422 | Fees | 2000 | C1 | Cash receipts from customers | 16554 | First Term | 1119122.048
 | 2024-01-05 00:00:00 | US$ | CT 455 | Fees | 2000 | C1 | Cash receipts from customers | 16555 | First Term | 2834977.772
 | 2024-01-09 00:00:00 | Cash - US$ | CT 404 | Fees | 2000 | C1 | Cash receipts from customers | 16556 | First Term | 2279965.446
 | 2024-01-09 00:00:00 | Cash - US$ | CT 413 | Fees | 2000 | C1 | Cash receipts from customers | 16561 | First Term | 2279965.446
 | 2024-01-09 00:00:00 | Cash - US$ | CT 108 | Fees | 2000 | C1 | Cash receipts from customers | 16562 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 111 | Fees | 2000 | C1 | Cash receipts from customers | 16563 | First Term | 3039953.928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 019 | Fees | 2000 | C1 | Cash receipts from customers | 16564 | First Term | 1519976.964
 | 2024-01-08 00:00:00 | Cash - US$ | CT 478 | Fees | 2000 | C1 | Cash receipts from customers | 16565 | First Term | 1422743.388
 | 2024-01-09 00:00:00 | Cash - US$ | CT 376 | Fees | 2000 | C1 | Cash receipts from customers | 16566 | First Term | 1139982.723
 | 2024-01-09 00:00:00 | Cash - US$ | CT 480 | Fees | 2000 | C1 | Cash receipts from customers | 16567 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 208 | Fees | 2000 | C1 | Cash receipts from customers | 16568 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 166 | Fees | 2000 | C1 | Cash receipts from customers | 16569 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 439 | Fees | 2000 | C1 | Cash receipts from customers | 16570 | First Term | 3039953.928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 442 | Fees | 2000 | C1 | Cash receipts from customers | 16571 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 436 | Fees | 2000 | C1 | Cash receipts from customers | 16572 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 446 | Fees | 2000 | C1 | Cash receipts from customers | 16573 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 036 | Fees | 2000 | C1 | Cash receipts from customers | 16574 | First Term | 759988.4820000001
 | 2024-01-09 00:00:00 | Cash - US$ | CT 464 | Fees | 2000 | C1 | Cash receipts from customers | 16575 | First Term | 455993.0892
 | 2024-01-09 00:00:00 | Cash - US$ | CT 114 | Fees | 2000 | C1 | Cash receipts from customers | 16576 | First Term | 3039953.928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 389 | Fees | 2000 | C1 | Cash receipts from customers | 16577 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 172 | Fees | 2000 | C1 | Cash receipts from customers | 16578 | First Term | 1291980.4194
 | 2024-01-09 00:00:00 | Cash - US$ | CT 390 | Fees | 2000 | C1 | Cash receipts from customers | 16579 | First Term | 1519976.964
 | 2024-01-09 00:00:00 | Cash - US$ | CT 057 | Fees | 2000 | C1 | Cash receipts from customers | 16580 | First Term | 1139982.723
 | 2024-01-09 00:00:00 | Cash - US$ | CT 411 | Fees | 2000 | C1 | Cash receipts from customers | 16581 | First Term | 303995.3928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 410 | Fees | 2000 | C1 | Cash receipts from customers | 16582 | First Term | 303995.3928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 412 | Fees | 2000 | C1 | Cash receipts from customers | 16583 | First Term | 303995.3928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 065 | Fees | 2000 | C1 | Cash receipts from customers | 16584 | First Term | 3039953.928
 | 2024-01-09 00:00:00 | Cash - US$ | CT 037 | Fees | 2000 | C1 | Cash receipts from customers | 16586 | First Term | 1519976.964
 | 2024-01-10 00:00:00 | Cash - US$ | CT 063 | Fees | 2000 | C1 | Cash receipts from customers | 16587 | First Term | 1691225.184
 | 2024-01-10 00:00:00 | Cash - US$ | CT 468 | Fees | 2000 | C1 | Cash receipts from customers | 16588 | First Term | 1691225.184
 | 2024-01-10 00:00:00 | Cash - US$ | CT 429 | Fees | 2000 | C1 | Cash receipts from customers | 16589 | First Term | 3382450.368
 | 2024-01-10 00:00:00 | Cash - US$ | CT 420 | Fees | 2000 | C1 | Cash receipts from customers | 16590 | First Term | 1268418.888
 | 2024-01-10 00:00:00 | Cash - US$ | CT 448 | Fees | 2000 | C1 | Cash receipts from customers | 16591 | First Term | 1268418.888
 | 2024-01-05 00:00:00 | US$ | CT 116 | Fees | 2000 | C1 | Cash receipts from customers | 16592 | First Term | 1417488.886
 | 2024-01-07 00:00:00 | US$ | CT 417 | Fees | 2000 | C1 | Cash receipts from customers | 16593 | First Term | 2126233.329
 | 2024-01-07 00:00:00 | US$ | CT 125 | Fees | 2000 | C1 | Cash receipts from customers | 16594 | First Term | 2834977.772
 | 2024-01-08 00:00:00 | US$ | CT 168 | Fees | 2000 | C1 | Cash receipts from customers | 16595 | First Term | 1422743.388
 | 2024-01-08 00:00:00 | US$ | CT 348 | Fees | 2000 | C1 | Cash receipts from customers | 16596 | First Term | 1422743.388
 | 2024-01-08 00:00:00 | US$ | CT 026 | Fees | 2000 | C1 | Cash receipts from customers | 16597 | First Term | 2845486.776000001
 | 2024-01-10 00:00:00 | US$ | CT 117 | Fees | 2000 | C1 | Cash receipts from customers | 16598 | First Term | 1691225.184
 | 2024-01-10 00:00:00 | US$ | CT 152 | Fees | 2000 | C1 | Cash receipts from customers | 16599 | First Term | 1691225.184
 | 2024-01-11 00:00:00 | Cash - US$ | CT 397 | Fees | 2000 | C1 | Cash receipts from customers | 16600 | First Term | 453214.7345000001
 | 2024-01-11 00:00:00 | Cash - US$ | CT 383 | Fees | 2000 | C1 | Cash receipts from customers | 16601 | First Term | 906429.4690000003
 | 2024-01-11 00:00:00 | Cash - US$ | CT 056 | Fees | 2000 | C1 | Cash receipts from customers | 16602 | First Term | 1812858.938000001
 | 2024-01-11 00:00:00 | Cash - US$ | CT 448 | Fees | 2000 | C1 | Cash receipts from customers | 16603 | First Term | 725143.5752000002
 | 2024-01-11 00:00:00 | Cash - US$ | CT 420 | Fees | 2000 | C1 | Cash receipts from customers | 16604 | First Term | 725143.5752000002
 | 2024-01-11 00:00:00 | Cash - US$ | CT 438 | Fees | 2000 | C1 | Cash receipts from customers | 16605 | First Term | 1812858.938000001
 | 2024-01-11 00:00:00 | Cash - US$ | CT 374 | Fees | 2000 | C1 | Cash receipts from customers | 16608 | First Term | 906429.4690000003
 | 2024-01-11 00:00:00 | Cash - US$ | CT 380 | Fees | 2000 | C1 | Cash receipts from customers | 16609 | First Term | 2266073.672500001
 | 2024-01-11 00:00:00 | Cash - US$ | CT 400 | Fees | 2000 | C1 | Cash receipts from customers | 16610 | First Term | 2266073.672500001
 | 2024-01-11 00:00:00 | Cash - US$ | CT 007 | Fees | 2000 | C1 | Cash receipts from customers | 16611 | First Term | 2719288.407000001
 | 2024-01-15 00:00:00 | Cash - US$ | CT 437 | Fees | 2000 | C1 | Cash receipts from customers | 16612 | First Term | 935141.1630000001
 | 2024-01-15 00:00:00 | Cash - US$ | CT 005 | Fees | 2000 | C1 | Cash receipts from customers | 16613 | First Term | 1683254.0934
 | 2024-01-15 00:00:00 | Cash - US$ | CT 208 | Fees | 2000 | C1 | Cash receipts from customers | 16614 | First Term | 1870282.326
 | 2024-01-16 00:00:00 | Cash - US$ | CT 427 | Fees | 2000 | C1 | Cash receipts from customers | 16615 | First Term | 2278377.3144
 | 2024-01-18 00:00:00 | Cash - US$ | CT 412 | Fees | 2000 | C1 | Cash receipts from customers | 16616 | First Term | 1955825.85
 | 2024-01-18 00:00:00 | Cash - US$ | CT 410 | Fees | 2000 | C1 | Cash receipts from customers | 16617 | First Term | 1955825.85
 | 2024-01-18 00:00:00 | Cash - US$ | CT 411 | Fees | 2000 | C1 | Cash receipts from customers | 16618 | First Term | 1955825.85
 | 2024-01-18 00:00:00 | Cash - US$ | CT 423 | Fees | 2000 | C1 | Cash receipts from customers | 16619 | First Term | 1955825.85
 | 2024-01-22 00:00:00 | Cash - US$ | CT 172 | Fees | 2000 | C1 | Cash receipts from customers | 16621 | First Term | 700903.1183000001
 | 2024-01-22 00:00:00 | Cash - US$ | CT 408 | Fees | 2000 | C1 | Cash receipts from customers | 16622 | First Term | 1001290.169
 | 2024-01-25 00:00:00 | Cash - US$ | CT 442 | Fees | 2000 | C1 | Cash receipts from customers | 16623 | First Term | 1044942.03
 | 2024-01-25 00:00:00 | Cash - US$ | CT 446 | Fees | 2000 | C1 | Cash receipts from customers | 16624 | First Term | 522471.0150000001
 | 2024-01-25 00:00:00 | Cash - US$ | CT 438 | Fees | 2000 | C1 | Cash receipts from customers | 16625 | First Term | 2089884.06
 | 2024-01-26 00:00:00 | Cash - US$ | CT 056 | Fees | 2000 | C1 | Cash receipts from customers | 16626 | First Term | 531265.2345
 | 2024-01-29 00:00:00 | Cash - US$ | CT 465 | Fees | 2000 | C1 | Cash receipts from customers | 16627 | First Term | 2158457.026
 | 2024-01-29 00:00:00 | Cash - US$ | CT 452 | Fees | 2000 | C1 | Cash receipts from customers | 16628 | First Term | 2590148.4312
 | 2024-01-29 00:00:00 | Cash - US$ | CT 431 | Fees | 2000 | C1 | Cash receipts from customers | 16629 | First Term | 1079228.513
 | 2024-01-29 00:00:00 | Cash - US$ | CT 464 | Fees | 2000 | C1 | Cash receipts from customers | 16630 | First Term | 1079228.513
 | 2024-01-29 00:00:00 | Cash - US$ | CT 484 | Fees | 2000 | C1 | Cash receipts from customers | 16631 | First Term | 2158457.026
 | 2024-01-29 00:00:00 | Cash - US$ | CT 420 | Fees | 2000 | C1 | Cash receipts from customers | 16632 | First Term | 431691.4052
 | 2024-01-29 00:00:00 | Cash - US$ | CT 448 | Fees | 2000 | C1 | Cash receipts from customers | 16633 | First Term | 431691.4052
 | 2024-01-29 00:00:00 | Cash - US$ | CT 411 | Fees | 2000 | C1 | Cash receipts from customers | 16634 | First Term | 1446166.20742
 | 2024-01-29 00:00:00 | Cash - US$ | CT 412 | Fees | 2000 | C1 | Cash receipts from customers | 16635 | First Term | 1435373.92229
 | 2024-01-29 00:00:00 | Cash - US$ | CT 410 | Fees | 2000 | C1 | Cash receipts from customers | 16636 | First Term | 1435373.92229
 | 2024-01-29 00:00:00 | Cash - US$ | CT 064 | Fees | 2000 | C1 | Cash receipts from customers | 16637 | First Term | 2158457.026
 | 2024-01-29 00:00:00 | Cash - US$ | CT 411 | Fees | 2000 | C1 | Cash receipts from customers | 16638 | First Term | 179907.3931171
 | 2024-01-29 00:00:00 | Cash - US$ | CT 412 | Fees | 2000 | C1 | Cash receipts from customers | 16638 | First Term | 179907.3931171
 | 2024-01-29 00:00:00 | Cash - US$ | CT 410 | Fees | 2000 | C1 | Cash receipts from customers | 16638 | First Term | 179907.3931171
 | 2024-01-29 00:00:00 | Cash - US$ | CT 441 | Fees | 2000 | C1 | Cash receipts from customers | 16639 | First Term | 1079228.513
 | 2024-01-30 00:00:00 | Cash - US$ | CT 397 | Fees | 2000 | C1 | Cash receipts from customers | 16640 | First Term | 1097060.36
 | 2024-01-30 00:00:00 | Cash - US$ | CT 407 | Fees | 2000 | C1 | Cash receipts from customers | 16641 | First Term | 1097060.36
 | 2024-01-31 00:00:00 | Cash - US$ | CT 056 | Fees | 2000 | C1 | Cash receipts from customers | 16642 | First Term | 223352.6526
 | 2024-01-31 00:00:00 | Cash - US$ | CT 074 | Fees | 2000 | C1 | Cash receipts from customers | 16643 | First Term | 4467053.052
 | 2024-01-07 00:00:00 | US$ | CT 165 | Fees | 2000 | C1 | Cash receipts from customers | 16654 | First Term | 708744.4430000001
 | 2024-01-26 00:00:00 | US$ | CT 051 | Fees | 2000 | C1 | Cash receipts from customers | 16801 | First Term | 2125060.938
 | 2024-01-28 00:00:00 | US$ | CT 152 | Fees | 2000 | C1 | Cash receipts from customers | 16802 | First Term | 2125060.938
 | 2024-01-30 00:00:00 | US$ | CT 051 | Fees | 2000 | C1 | Cash receipts from customers | 16803 | First Term | 2194120.72
 | 2024-01-03 00:00:00 | Swipe - ZWL | CT 395 | Fees | 2000 | C1 | Cash receipts from customers | 16055 | First Term | 450000
 | 2024-01-03 00:00:00 | Swipe - ZWL | CT 361 | Fees | 2000 | C1 | Cash receipts from customers | 16056 | First Term | 450000
 | 2024-01-06 00:00:00 | ZWL | CT 440 | Fees | 2000 | C1 | Cash receipts from customers | 15841 | First Term | 1451000
 | 2024-01-08 00:00:00 | ZWL | CT 417 | Fees | 2000 | C1 | Cash receipts from customers | 15842 | First Term | 725500
 | 2024-01-08 00:00:00 | ZWL | CT 407 | Fees | 2000 | C1 | Cash receipts from customers | 15843 | First Term | 725500
 | 2024-01-08 00:00:00 | ZWL | CT 431 | Fees | 2000 | C1 | Cash receipts from customers | 15844 | First Term | 700000
 | 2024-01-10 00:00:00 | ZWL | CT 007 | Fees | 2000 | C1 | Cash receipts from customers | 15845 | First Term | 725500
 | 2024-01-15 00:00:00 | ZWL | CT 001 | Fees | 2000 | C1 | Cash receipts from customers | 15846 | First Term | 1666400
 | 2024-01-17 00:00:00 | ZWL | CT 441 | Fees | 2000 | C1 | Cash receipts from customers | 15847 | First Term | 725500
 | 2024-01-19 00:00:00 | ZWL | CT 432 | Fees | 2000 | C1 | Cash receipts from customers | 15848 | First Term | 863100
 | 2024-01-22 00:00:00 | ZWL | CT 157 | Fees | 2000 | C1 | Cash receipts from customers | 15849 | First Term | 335327.6
 | 2024-01-22 00:00:00 | ZWL | CT 449 | Fees | 2000 | C1 | Cash receipts from customers | 15850 | First Term | 2062736
 | 2024-01-30 00:00:00 | ZWL | CT 064 | Fees | 2000 | C1 | Cash receipts from customers | 15851 | First Term | 2194400