• DD-Square-Logo_resized
  • ATTEND LAS VEGAS
    • Attendee
      • Registration & Pricing
      • Hotel & Travel
      • FAQ
    • Exhibitor
      • Exhibit/Sponsor
      • Advertising Opportunities
      • Exhibitor Console
    • Education
      • Overview
      • Show Schedule
  • ABOUT
    • Conference Overview
    • Testimonials
    • Become a Speaker
    • Press Inquiries
    • Partnership Programs
    • Health & Safety
    • Contact Us
    • Get Updates
  • RESOURCES
    • Webinars
    • Downloads
  • NEWS
    • Auto Retail News
    • Digital Editions
    • Press Releases
    • Submit Editorial
    • Subscribe
  • .
  • ATTEND LAS VEGAS
    • Attendee
      • Registration & Pricing
      • Agenda Summary
      • Show Schedule
      • Hosted Dealer Program
      • Hotel & Travel
      • FAQ
    • Exhibitor
      • Exhibit/Sponsor
      • Advertising Opportunities
      • Exhibitor Console
      • Exhibitor Services Manual
    • Education
      • Conference Overview
      • Conference Speakers
      • Session Schedule
  • RESOURCES
    • Webinars
    • Downloads
  • ABOUT
    • Conference Overview
    • Testimonials
    • Become a Speaker
    • Press Inquiries
    • Partnership Programs
    • Health & Safety
    • Get Updates
  • NEWS
    • AUTO RETAIL NEWS
    • PRESS RELEASES
    • DIGITAL EDITIIONS
    • SUBMIT EDITORIAL
    • SUBSCRIBE

Las Vegas: Oct 17-19, 2023

REGISTER NOW EXHIBIT / INQUIRE
Q

NEWS:

Dealer/GM News | Digital Dealer | Finance & Insurance News | Inventory Management | Lead Management & CRM | Pre-Owned Sales & Marketing Strategies | Sales & Marketing | Technology
October 1, 2010

Dynamic Heat Sheet Automation

Posts:
Dealer/GM News | Digital Dealer | Finance & Insurance News | Inventory Management | Lead Management & CRM | Pre-Owned Sales & Marketing Strategies | Sales & Marketing | Technology
October 1, 2010

Dynamic Heat Sheet Automation

One of the first tasks that I had in a dealership was typing the daily heat sheet. The fact that I “typed” the heat sheet indicates how old I am and that I still remember this task shows how much of an impact this daily heat sheet had on me.

For a young person, the control over the heat sheet meant a considerable amount of power. Throughout the day, in this large dealership, people would stop by my desk and say, “Add this to the heat sheet,” or “Take this off the heat sheet.”

I was a popular person first thing in the morning as key managers would come to me to find out if it was one page or less. A two-page heat sheet meant a terrible screaming session by our general manager. I would do my best to squeeze as many items onto a single page. For those of you new to our industry, the heat sheet is a list of all past due vehicle receivables. The term “heat” comes from the level of pressure put on by the dealer and general manager when the list is excessive.

Today, the most common heat sheet is still manually typed – but in Excel. For some it is a burdensome task to spend hours updating it with recent payments and notes, and creating additions from various past due schedules. Many DMS systems have a heat sheet as an F&I report, but it doesn’t really do the job of a custom Excel spreadsheet. Some of this is due to a lack of utilization – and the rest of the blame comes from the DMS system’s lack of flexibility. For example, it might show vehicle receivables from the car deals, but not a shortage from a difference in payoff or NSF check. Some dealerships like to put missing titles or paperwork on the heat sheet. Even if you download a custom report from your DMS system and then import into Excel, you might get some of the items, but not everything.

How can you get your heat sheet to be more automated? The key is for it to be dynamic.

Oddly enough, dynamic comes from the Greek word for power, but a better term would be, “continuous and productive activity.” Compared to my static and typed heat sheet, a dynamic heat sheet would not only have an element of automation, but also enable users throughout the day to update the heat sheet with notes, payments, and additions.  The automation can come from importing data from your DMS system into a shared Excel spreadsheet on your server. The dynamic part comes from the sharing of this spreadsheet by various users on the server.

The Excel guru, Jack Ross, wrote a great technical article about sharing workbooks in my newsletter. E-mail me at sjerome@dealer-communications.com if you’d like a copy.  Instead of just printing in the morning and handing it out, employees can open it during the day and update notes. When they see a customer in the shop that they think still owes them money, they don’t need to search for this week’s printed heat sheet. Instead they can open the file on the server and see if the customer is still on the past due list.

Cashiers can be taught that when they receipt monies for car deals that they also update the heat sheet notes. Title clerks can also update it as they get titles in the mail or from customers. F&I managers can update their notes from phone calls with the customers.

This is being dynamic; continuous and productive activity.  If you’d like more information on how to have a dynamic and automated heat sheet, just send me an email. By making it dynamic you’ll have more power and control over the heat sheet and save the cost of printing, shredding and maybe a future screaming session

 

Dealer/GM News•Digital Dealer•Finance & Insurance News•Inventory Management•Lead Management & CRM•Pre-Owned Sales & Marketing Strategies•Sales & Marketing•Technology

SHARE

Share on Email
Share on Linkedin
Share on Facebook
Share on Pinterest
Share on Twitter
← Previous Article Next Article →
Posts Dealer Ops & LeadershipTrending Industry News

Standing Too Close to the Elephant

Posts Sales & Variable OpsTrending Industry News

Enhancing and Transforming the Automotive Sales/Service/Parts Lifecycle with ChatGPT

Posts Dealer Ops & LeadershipTrending Industry News

Standing Too Close to the Elephant

Posts Dealer Ops & LeadershipTrending Industry News

Four Steps for Successful Digital Retail Adoption

Posts Dealer Ops & LeadershipTrending Industry News

The Who, What, Where and How of AI-Built Solutions

Posts Sales & Variable OpsTrending Industry News

The Sales Objections You Need to Master in 2023

Posts Dealer Ops & LeadershipTrending Industry News

The Tale of Two Advisors

Posts Dealer Ops & LeadershipTrending Industry News

147,348 Reasons Why Customer Experience & Dealership Loyalty Matter – The Power of a Point

NEWSLETTER

SUBSCRIBE

DEALER MAGAZINE

Dealer Magazine March/April 2023 Issue Featuring an Interview with NADA 2023 Chairman
MAGAZINE
Digital Dealer Logo White
FOLLOW US ON
  • Follow
  • Follow
  • Follow
  • Follow
  • Follow
© 2023 Emerald X, LLC. All Rights Reserved.
ABOUT    CAREERS    AUTHORIZED SERVICE PROVIDERS    TERMS OF USE    PRIVACY POLICY