Truck dealer optimizes inventory and financial reporting with Klipfolio

The good people at Upper Canada Truck Sales have been high-end transport truck retailers for over 23 years, helping thousands of customers with financing and inventory purchases. They specialize in late model, premium quality transport trucks.

Their goal is to be the best place in Canada to buy a used truck, built on the quality of their inventory and the experience they give every customer.

Meet the dynamic duo: Shaun and Pat

Shaun Boughen is the President and Founder of Upper Canada Truck Sales.

He started Upper Canada in November 1995 with enough funds to purchase a single vehicle. There was no business plan, no vision document. Shaun was tired of building someone else's dream in the truck business and wanted to be his own boss. He took the risk, and it paid off. But the growth came with its share of hard lessons.

Today, Shaun's focus is on sourcing vehicles, managing coast-to-coast transportation logistics, and overseeing full-cycle production.

"With Pat Tatchell's guidance as our GM we have built a successful management structure."

Shaun Boughen and Pat Tatchell became friends while working together in the trucking industry, and that friendship grew into an important partnership. In the early years of the business, Shaun was badly injured in a snowmobile accident in the Yukon. Pat stepped in and ran day-to-day operations, keeping the business alive. To this day, Pat manages things on the ground while Shaun leads from the front.

The struggle of gaining better business insight

A while back, Shaun and Pat set a new corporate goal:

"We wanted to have better insights into the business so we could shorten sales cycles and acquire more new business."

When you run your own company, gut instinct goes a long way. But Shaun knew that continued growth meant becoming a more data-driven organization, combining analytics with intuition rather than relying on one alone.

"This may sound ridiculous, but I tracked a lot in my head. Somehow, I seemed to just know 'by feel' how we were doing by looking at a monthly P&L statement. However, over the years we started to fall behind."

As tight processes began to loosen, Shaun was receiving his profit and loss reporting three or four weeks late. That delay made it nearly impossible to act on problems from the previous month before they turned into real financial losses. By the time the numbers arrived, the window to do something about them had already closed.

"Bottom line: we did not do a great job of measuring which of our team's efforts were creating success, and our financial reporting was rudimentary at best. Klipfolio has changed all of this for us as an organization and has become a core part of Upper Canada's financial reporting reality."

Start simple, test, then scale

Upper Canada needed a reporting solution they could access anywhere, at any time, without waiting for someone to pull a number or compile a spreadsheet. It was time to move on from delayed P&L processes.

Shaun knew he had access to a lot of data and that the right move was to start simple, keep the budget lean, and grow from there. He connected his Salesforce integration and Dealer Spike data to Klipfolio and began building dashboards with a little help from a familiar face.

"I reached out to a long-time friend from university who works on Klipfolio's success team and asked them for help."

After trying the product, Shaun knew Klipfolio was exactly what Upper Canada needed.

Looking at inventory and sales over time

Now, Shaun starts each day with a snapshot of his sales pipeline dashboard, pulling live data from Salesforce and Dealer Spike. He knows where things stand without having to ask anyone.

"Klipfolio allowed us to connect seamlessly with our data in Dealer Spike and Salesforce."

Before Klipfolio, Shaun had no way to analyze truck inventory over time. That changed as soon as Dealer Spike was connected. The historical view that was missing is now always available, and it directly shapes buying decisions.

"I can now see a history of my inventory over time: a mix of truck brands, inventory flow in and out of a certain location, the average cost per truck, and age of the vehicle. Klipfolio has helped me make better buying decisions now that I have access to these historical trends."

Industry metrics that fuel growth

"We find it highly motivational to see in real-time how we are trending as an organization and which sales staff are meeting or exceeding their goals."

Here are some of the metrics Upper Canada tracks in real-time:

• Inventory: stock levels, flow, age, and average cost per vehicle

• Web traffic: site visits and engagement trends

• Sales rep performance: individual results against targets

• Profit and loss: broken down by truck and by location

• Lead source: where new business is coming from

• Sales trends: filtered by geography, buyer type, and truck type

• Social engagement: likes and impressions across Facebook and Instagram

"Our Klipfolio dashboards tell us how we are doing and what we should be doing next to drive better outcomes."

The data-driven way to share information

Upper Canada sends weekly PDF snapshot emails to everyone who needs access to the numbers, delivered to their inbox every Monday morning. The team also uses financial reporting dashboards in meetings, so decisions get made from a shared, reliable view of the business rather than competing versions of the truth.

"Being able to pull out my phone and see all my Klipfolio data in real time is amazing. Having all my information at a glance 24/7 has given me new eyes on the business, allowing me to make better decisions on-the-fly."

The next big data project at Upper Canada

Shaun, with support from the Klipfolio team, is working on a project that will give Upper Canada a complete historical view of every sale made over the past ten years. The data lives in Salesforce and a large spreadsheet of historical records. Once connected, the team will be able to filter that full history by truck type, location, lead source, sales rep performance metrics, and buyer profile.

"Our new Klipfolio dashboards will allow us the ability to streamline our marketing, sales processes, and overall business practices to optimize the business."

Shaun's advice for those just getting started with Klipfolio

"The Klipfolio team was super helpful in guiding us through the process of connecting the years of data we had accumulated. They taught us how to create meaningful dashboards that show us if we were moving in the right direction with our company decisions. Invest the upfront time into learning Klipfolio, it's worth every minute. The support team is there every step of the way."