Interesting Data Findings for Client Feedback
Interesting Data Findings for Client Feedback
XYZ Operating Account
For the Period 05/01/11 through 12/31/14
Data Findings 1| Loans | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
1A | 01/20/14 | 11/21/14 | ALLY | 11 | 13,841.52 |
1B | 06/15/12 | 06/15/12 | AMERICAN HERITAGE BANK | 1 | 614.47 |
1C | 07/23/14 | 12/04/14 | BMW BANK OF NORTH AMERICA | 5 | 12,353.00 |
1D | 04/18/12 | 08/31/12 | FIRST OKLAHOMA BANK | 5 | 253,329.71 |
1E | 05/12/11 | 11/19/14 | LOAN CARE | 38 | 2,379,186.80 |
1F | 05/18/12 | 05/12/14 | LOAN PAYMENT | 3 | 87,416.01 |
1G | 09/26/11 | 12/31/14 | SPIRIT BANK | 75 | 160,606.24 |
Data Findings 2|Wires | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
05/27/11 | 05/01/12 | WIRE | 10 | 50,062.46 |
Data Findings 3|Withdrawals | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
07/27/11 | 10/31/14 | 3 | 3,574.25 |
Data Findings 4|Credit Cards | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
4A | 03/26/14 | 11/20/14 | CHASE CARD SERVICES | 15 | 354,581.97 |
4B | 12/31/13 | 12/15/14 | CITICARD | 14 | 191,671.43 |
Data Findings 5|Transfers | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
5A | 07/20/11 | 12/04/14 | TRANSFER | 60 | 389,760.12 |
Data Findings 6|Outliers | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
6B | 08/31/13 | 08/31/13 | AES CERTIFIED LLC | 1 | 58,425.01 |
6C | 12/30/13 | 12/30/13 | AUMANN & ASSOCIATES | 1 | 83,796.31 |
6D | 04/04/12 | 04/04/12 | CONCRETE ENTERPRISES, INC. | 1 | 66,853.03 |
6E | 11/07/11 | 12/23/11 | CONSTRUCTION ASSOCIATES UNLIMITED, I | 3 | 223,860.00 |
6F | 07/22/14 | 07/22/14 | DON ELLIS ENGINE SERVICE, INC. | 1 | 73,850.00 |
6G | 06/01/12 | 06/01/12 | EMPLOYEE | 1 | 152,046.58 |
6H | 03/29/13 | 03/29/13 | ENERGY FLUIDS, INC. | 1 | 58,712.10 |
6I | 05/06/11 | 03/03/14 | EQUIPMENT | 2 | 387,246.73 |
6K | 08/31/13 | 10/25/14 | INLAND MACHINE & WELDING CO. | 2 | 173,439.65 |
6L | 05/31/12 | 05/31/12 | KRUSE ENERGY & EQUIPMENT, LLC | 1 | 296,301.60 |
6N | 08/30/13 | 08/30/13 | MC PETROLEUM | 1 | 90,222.15 |
6O | 04/12/13 | 04/12/13 | OK TOOL COMPANY | 1 | 74,006.13 |
6R | 11/30/13 | 11/30/13 | PRECISION ENERGY SERVICES, INC. | 1 | 66,752.19 |
6S | 04/02/13 | 04/02/13 | REDDY PIPE & SUPPLY, INC. | 1 | 59,348.70 |
6W | 11/15/12 | 11/15/12 | VENDOR | 1 | 100,010.00 |
6X | 10/25/14 | 10/25/14 | VORTEX FLUID SYSTEMS, INC. | 1 | 60,650.00 |
6Y | 04/17/13 | 04/17/13 | WARREN CAT | 1 | 85,440.00 |
Data Findings 7|Even Dollar | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
7B | 10/07/13 | 10/07/13 | BERENDSEN FLUID POWER | 1 | 9,000.00 |
7D | 05/23/12 | 05/23/12 | CAGLE OILFIELD SERVICES, INC. | 1 | 4,000.00 |
7E | 12/17/12 | 07/16/13 | CASH | 2 | 6,000.00 |
7F | 07/22/11 | 07/22/11 | CERTIFICATE OF DEPOSIT | 1 | 20,000.00 |
7G | 11/07/12 | 01/20/14 | CLEVELAND WELL SERVICE, INC. | 4 | 108,000.00 |
7H | 09/15/11 | 12/07/11 | CONSTRUCTION ASSOCIATES UNLIMITED, I | 2 | 26,000.00 |
7I | 09/16/11 | 07/15/14 | CONTRACT LABOR | 13 | 58,000.00 |
7J | 01/22/14 | 01/22/14 | DEAN'S CASING SERVICE | 1 | 18,000.00 |
7K | 02/25/13 | 03/20/13 | DEPARTMENT OF ENVRIONMENTAL QUALI | 2 | 2,000.00 |
7L | 09/14/11 | 09/14/11 | DEQ AIR QUALITY DIVISION | 1 | 1,000.00 |
7M | 07/14/11 | 07/14/11 | DUNLAP HVAC | 1 | 3,000.00 |
7N | 06/01/12 | 06/01/12 | EARL-LE DOZER SERVICE LLC | 1 | 40,000.00 |
7O | 09/06/13 | 11/25/14 | EMPLOYEE I | 3 | 3,000.00 |
7P | 07/18/12 | 07/18/12 | EMPLOYEE J | 1 | 2,000.00 |
7Q | 08/01/13 | 08/01/13 | EMPLOYEE L | 1 | 1,000.00 |
7R | 07/16/13 | 07/16/13 | ENERGY FLUIDS, INC. | 1 | 15,000.00 |
7S | 05/06/11 | 08/09/14 | EQUIPMENT | 4 | 1,146,000.00 |
7T | 04/18/13 | 01/20/14 | EVCO SERVICE CO., INC. | 2 | 50,000.00 |
7U | 11/27/12 | 11/27/12 | HERITAGE-CRYSTAL CLEAN, LLC | 1 | 1,000.00 |
7V | 07/03/14 | 07/03/14 | HOSCHEIT, MCGUIRK, MCCRAKEN & CUSA | 1 | 1,000.00 |
7W | 09/20/11 | 09/20/11 | INDIAN ELECTRIC COOPERATIVE | 1 | 2,000.00 |
7X | 09/16/14 | 09/16/14 | INLAND MACHINE & WELDING CO. | 1 | 30,000.00 |
7Y | 12/21/11 | 12/21/11 | KROLL AG & CONSTRUCTION | 1 | 8,000.00 |
7AA | 09/11/12 | 08/31/13 | NATIONAL OILWELL VARCO, L.P. #773 | 4 | 36,000.00 |
7AB | 03/27/12 | 03/27/12 | O-K BIT SERVICE, INC. | 1 | 8,000.00 |
7AC | 09/15/11 | 09/15/11 | OK TOOL COMPANY | 1 | 8,000.00 |
7AG | 03/12/12 | 08/29/12 | POGUE ELECTRIC INC. | 4 | 40,000.00 |
7AH | 09/14/12 | 09/14/12 | POLITICIAN FOR CONGRESS | 1 | 1,000.00 |
7AI | 11/01/11 | 11/01/11 | RC DOZER SERVICE LLC | 1 | 2,000.00 |
7AJ | 01/11/12 | 01/11/12 | RENT A CRANE OF OKLAHOMA, INC. | 1 | 1,000.00 |
7AM | 08/31/13 | 08/31/13 | SOLAZYME, INC. | 1 | 8,000.00 |
7AN | 07/16/13 | 07/16/13 | SOURCE ONE ENGINE EQUIPMENT LLC | 1 | 15,000.00 |
7AO | 09/02/11 | 02/17/12 | SPIRIT BANK | 1 | 5,000.00 |
7AP | 08/18/14 | 08/18/14 | TOTAL QUALITY LOGISTICS | 1 | 6,000.00 |
7AS | 09/07/11 | 09/07/11 | WOODS PUMPING SERVICE, INC. | 1 | 28,000.00 |
Data Findings 8|Other from S&U | |||||
Date Range | |||||
Key | From | To | Payee | No. of Recs. | Amount |
01/31/13 | 12/04/14 | 14 | 469,251.72 | ||
8B | 06/13/12 | 12/17/14 | ATTORNEY | 18 | 43,775.00 |
8C | 03/09/12 | 04/04/12 | BRET BARNHART CONST. CO. | 3 | 77,125.00 |
8D | 08/05/11 | 04/20/12 | BUILDERS WAREHOUSE | 7 | 4,469.92 |
8E | 02/08/13 | 06/04/14 | CITY OF EDMOND | 4 | 365.24 |
8F | 11/25/14 | 11/25/14 | FRONTIER CHEVROLET | 1 | 16,380.00 |
8G | 11/25/14 | 11/25/14 | HUDIBURG CHEVROLET INC. | 1 | 17,899.00 |
8H | 12/31/13 | 12/31/13 | JACKIE COOPER IMPORTS | 1 | 29,989.00 |
8I | 12/07/11 | 12/30/11 | LIGHTFOOT CONSTRUCTION | 2 | 7,896.00 |
8J | 07/25/11 | 12/30/14 | PARTNER A | 87 | 695,618.53 |
8K | 05/13/11 | 12/31/14 | PARTNER B | 104 | 2,162,713.01 |
8L | 04/03/14 | 12/03/14 | PARTNER B LOAN PAYMENT | 19 | 64,229.32 |
8M | 07/29/11 | 12/01/14 | PARTNER C | 59 | 801,657.84 |
8N | 01/08/13 | 11/05/14 | PROFIT SHARING | 4 | 119,852.52 |
8O | 08/23/13 | 05/15/14 | SCOTT | 7 | 16,220.00 |
8P | 08/16/11 | 12/01/14 | SCOTT'S PROPERTY INVESTMENTS, LLC | 136 | 874,274.14 |
06/28/12 | 08/15/14 | 14 | 534,045.89 |