Interesting Data Findings for Client Feedback

Interesting Data Findings - Sneaky CFO FINAL_041123 
 


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


2A


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


3A


07/27/11


10/31/14


WITHDRAWAL


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


8A


01/31/13


12/04/14


ACH


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


8Q


06/28/12


08/15/14


XYZ CO


14


534,045.89