Most bankers are so bad at problem-solving it’s funny.

I learned that within DAYS of entering the banking world.

It was late 2006 and I had joined GE’s ‘Pilot Project’ to try out for their Corporate Audit Staff.

The entire goal was to push you out of your comfort zone.

I had only been an engineer at that point,

So naturally, I had to join a team auditing a credit card business.

Something I knew nothing about.

In fact, that’s when I learned that a Kohl’s credit card isn’t actually run through Kohl’s…

Kohl’s just partners with a private-label card issuer that gives them a good deal. – some profit sharing or a formal JV.

Anyways…

My first assignment was a balance sheet audit on the fixed assets of the business.

Turns out, 97% of the fixed assets were the Verifone Terminals that we sent to businesses for them to process purchases.

$25M worth of them.

I had to make sure this was fairly stated on the balance sheet.

I asked around how I might do this and got some crazy suggestions.

“What if you took a sample of all of them,
Called them up,
Asked them to run a test transaction on their terminal,
See if it goes through,
Then extrapolate that out for an estimate of how many are active.”

Ya….
I think I’ll talk to IT instead.

It didn’t take long for me to figure out:

1️⃣ Every terminal has a unique ID
2️⃣ We had a list of all of these and who they belonged to
3️⃣ Every time one of them transacts, it gets logged into a database

So I got those 2 files,

Sent them to a friend that I knew had code to marry the sheets up to each other and within minutes I knew that 93% of the terminals transacted in the last 6 months.

4% had been sent out in the last 3 months.

And 3% were unaccounted for.

When it comes time to solve problems in your bank,

It’s usually best that you don’t think like a banker…


Digging deep on banks is what I do.

???? Follow Brian on Linkedin: Brian Pillmore

#banking

#ProblemSolving 

#CreditCards

 Get PDF Report

Learn more on this topic

Related Insights