Payment Insights

Payment Insights is a reporting tool, built for the automotive finance industry. It shows the landscape of finance rates from all lenders for all car brands across Canada.

It’s built to help its users understand where their organization stands against the competition, where their winning rates are, and which vehicles they can offer the best financing options for.



Kevin - BMO Automotive Finance Rep.

Kevin’s job is to convince dealerships to use BMO as their main financing partner. Usually the dealerships will use their parent manufacturer’s lending wing (The Captive) as their default provider. Kevin wants to switch them over to BMO.

The product


The first version of the tool was an excel file. A large spreadsheet with thousands of cells, deep filtering, and complicated formulae baked into the multiple tabs.

As powerful as the original spreadsheet was, it had its pain points. The file was large and slow at times, and it lacked the mobility that it’s users required.

Users had to spend time generating reports, so they could print them and take them on the road when they met with dealers.


Version 2

The second version of Payment Insights would aim to remedy the painpoints of the original and build from the feedback of it’s customer base.

The main problems we needed to solve:


1 - Make the tool easier to understand

Instead of asking users to fumble through filters to find the best sales opportunities, our approach was to surface the most useful information in a visually driven dashboard. Show Kevin his best opportunities at a glance. This would let him focus on who he should visit that week and not the get lost in the numbers.


2 - Make it faster to work with.

Once Kevin had an understanding of where the best opportunities were, he would need the reports to prove it. In the previous version, he would have to sort through the cells, and complete a multi step process to generate the pdf’s needed for his meetings. With Version 2 we automated that process. Allowing him to get the robust reports he needed with a couple of clicks.


3- Make it portable but keep it powerful.

Although we wanted to make it easier to use we also wanted to give our users the same power to customise reports, compare rates and have all of the previous verion’s muscle, but take it on the road. This would let our users build reports on the fly and share them in real time with prospects.



With the redesigned tool we were able to hit some important KPI’s: increased number of reports generated per month. A 100% retainment rate with all of our existing relationships. 4 new signed accounts to yearly liscences.

Increased yearly revenue, drinks all around. 🍻


My contributions to this product


Next, learn how we created a system to help drive customer retention.