Spreadsheet: 726403d1617211380-extract-data-from-cells-in-row-based-on-most-recent-date-in-column-a-to-sheet2-samplebook
Sheet: Sheet1

Activity Date | Payout/Settle Date | Total Deposit Count | Total Deposit Amount | Return $ Amount Before Settlement | Return count before settlement | Reserve Amount Withheld | Billing Amount Withheld | Net Settle Amount | Reserve $ [NAME] | Date Reserve Released | Return Amount After Settlement | Return Count After Settlement | Total [NAME] | Total Reg Return Amount | Unauth Count | Month to Date Unauth Percentage | Refund Count | Refund $ [NAME] | Return Credit Count | Returned Credit Dollar Amount | Micros | Daily Reg % | Daily Reg % After Micros | Daily Admin Returns | Daily Admin % | Daily Admin % After Micros | Daily Unauth % | Daily Unauth % After Micros
2020-05-01 00:00:00 | 2020-05-08 00:00:00 | 60 | 1669.75 | 47 | 1 | 166.98 | 96.69 | 1359.08 | 166.98 | 2020-12-03 00:00:00 | 0 | 0 | 1 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-04 00:00:00 | 2020-05-11 00:00:00 | 1 | 47 | 0 | 0 | 4.7 | 2.57 | 39.73 | 4.7 | 2020-09-07 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0
2020-05-05 00:00:00 | 2020-05-12 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-08-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 |  |  | 0
2020-05-05 00:00:00 | 2020-05-12 00:00:00 | 29 | 212.75 | 0 | 0 | 21.28 | 17.02 | 174.45 | 21.28 | 2020-11-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0
2020-05-06 00:00:00 | 2020-05-13 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-07 00:00:00 | 2020-05-14 00:00:00 | 28 | 165.75 | 0 | 0 | 16.58 | 14.45 | 134.72 | 16.58 | 2020-11-18 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-08 00:00:00 | 2020-05-15 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-11 00:00:00 | 2020-05-18 00:00:00 | 26 | 71.75 | 0 | 0 | 7.18 | 9.31 | 55.26 | 7.18 | 2020-11-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-12 14:01:00 | 2020-05-19 00:00:00 | 27 | 118.75 | 0 | 0 | 11.88 | 11.88 | 94.99 | 11.88 | 2020-11-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-13 15:04:00 | 2020-05-20 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 141 | 0 | 0 | 25 |  |  | 0
2020-05-14 15:38:00 | 2020-05-21 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-15 14:09:00 | 2020-05-22 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-09 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-18 12:38:00 | 2020-05-26 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-19 13:52:00 | 2020-05-27 00:00:00 | 72 | 2233.75 | 47 | 1 | 223.38 | 127.53 | 1835.84 | 223.38 | 2020-12-03 00:00:00 | 0 | 0 | 1 | 47 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-20 17:15:00 | 2020-05-28 00:00:00 | 38 | 635.75 | 0 | 0 | 63.58 | 40.15 | 532.02 | 63.58 | 2020-12-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-21 17:15:00 | 2020-05-29 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-11 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-22 13:36:00 | 2020-06-01 00:00:00 | 35 | 494.75 | 0 | 0 | 49.48 | 32.44 | 412.83 | 49.48 | 2020-11-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-25 17:15:00 | 2020-06-02 00:00:00 | 32 | 353.75 | 0 | 0 | 35.38 | 24.73 | 293.64 | 35.38 | 2020-12-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-26 14:04:00 | 2020-06-02 00:00:00 | 44 | 917.75 | 0 | 0 | 91.78 | 55.57 | 770.4 | 91.78 | 2020-12-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-27 17:15:00 | 2020-06-03 00:00:00 | 25 | 24.75 | 0 | 0 | 2.48 | 6.74 | 15.53 | 2.48 | 2020-09-14 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-28 13:11:00 | 2020-06-04 00:00:00 | 35 | 494.75 | 0 | 0 | 49.48 | 32.44 | 412.83 | 49.48 | 2020-12-04 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
2020-05-29 12:59:00 | 2020-06-05 00:00:00 | 34 | 447.75 | 94 | 2 | 44.78 | 29.87 | 279.1 | 44.78 | 2020-09-14 00:00:00 | 0 | 0 | 2 | 94 | 0 | 0 | 0 | 0 | 0 | 0 | 25 |  |  | 0
30 Day Totals