auto dealer in black and red logo
MenuMENU
SearchSEARCH

Columnar Pads Or Computerized Accounting

David Keller - The independent dealer has many choices when deciding what their accounting department should look like...

September 7, 2006
5 min to read


The independent dealer has many choices when deciding what their accounting department should look like. Most dealers start out small with a minimal accounting staff usually their spouse or a family member employed on a part time basis. As the dealership grows, the need for additional office and accounting help increases along with increased number of hours to complete the job. My parents started their used dealership with this same format in 1972 and existed that way until 1992, when they bought the Chevrolet Chrysler Dodge franchises and re-located them next to their used vehicle facility. Their need for outside financing for their growing inventory and sales in the mid 1980’s required them to submit financial information about their business to the bank. At that time, fresh out of college with an accounting degree, I got involved in the financial side of their business preparing monthly financial statements on a computer the size of a suitcase. The books were still kept manually by my mom on columnar sheets of accounting paper. Those column totals for the month were entered into software and financial statements were produced from them. Weekly payroll, W-2’s and other payroll reports were calculated manually.

My dad prepared his used vehicle Inventory sheet on loose-leaf paper and kept track of reconditioning on index cards or in his head. He manually re-wrote it each week. They managed their dealership like many still do, by reviewing their cash balance on a daily basis to see if they could buy more cars and still pay their bills. Seems very primitive now, doesn’t it? Is this some version of your accounting department? I am not demeaning anyone by saying this method doesn’t work. It does, but it is also very time consuming and can be costly in many ways. Yes, you can save money by not having the most current or “best” version of accounting software and you may also save money by not hiring the most qualified person to manage the accounting at your store. You can get by for now, but may not be able to grow and effectively manage your business as your volume increases. Your accounting department should be efficient and staffed well enough to gather all of the different accounting transactions, compile them into something that resembles a financial statement and makes some business sense to you and possibly your banker. If you are not accomplishing this, you need to review how you are staffing the accounting department, what you are using to record your transactions, how timely you can receive the month end information and how accurately you think it resembles your business that month. Also, you should not overlook the ability to react to your current financial statements in a timely manner to improve next month’s activity. Accounting has progressed rapidly in the past five years. Accounting software comes in every variety and price. Dealers are using many different types of software to generate their accounting transactions. When speaking with dealers about the various types of accounting, front end F & I, service and parts, customer followup and retention software they are currently using, I get dizzy. Often when I review their accounting records, a disaster appears to have happened in their accounting department and financial information preparation. When a banker reviews these financial statements, they shake their head and wonder how some dealers have made it as far as they have in this business. The dealer has no idea if they have made a profit or incurred a loss. The banker realizes the dealership probably exists only because it currently has enough cash to buy some cars and pay their bills. This means there are many dealerships out there that could use additional accounting help and training in the basics of bookkeeping. They could also use additional training in how to use their accounting software to the fullest. Improving your accounting department can be manageable. Classes are offered by local high schools and colleges, technical schools, and from associations such as NIADA. Ask your current accountant or bookkeeping firm to train your personnel in the basics of accounting theory, such as adjusting and reconciling your accounting records. The biggest obstacle to overcome is the idea that your accounting records are OK, and if you sell more cars everything will straighten itself out. You may survive for the short term, but your future growth and profitability depends on accurate accounting records and how you react to them. My parents were no different than many independent dealers operating today. Many would profit from improved accounting records that are accurate, timely and tell the true story of the financial condition of their dealership. Your accounting department needs to be able to recognize when there is a problem with a general ledger balance. Additionally they should know how to correct the errors and record the transactions correctly the next time. It’s not too late to get your accounting department and records in order! Don’t let the dealer down the street pass you by because they were able to obtain additional financing for future growth. Feel free to email me any questions you may have regarding improving your accounting department. This article is dedicated to my father, Eugene Keller, a man who made the car business his life. He was an independent dealer for 20 years and a new franchise dealer for another 13 years, who passed away quietly from cancer last August at home with his family by his side. Vol 3, Issue 6

Subscribe to Our Newsletter

More Dealer Ops

Auto Dealer Today, Dealer Debrief, 09/02/2026, with Lauren Lawrence
Dealer Opsby Lauren LawrenceSeptember 2, 2026

Dealer Debrief: August Auto Sales

Gas-powered engines still dominate the U.S. vehicle market, but hybrids are gaining ground as consumers look for ways to cut their gas costs.

Read More →
red, black, and yellow car in a car dealership showroom, Growth Beyond Sales text box, Auto Dealer Today logo
Dealer Opsby Lauren LawrenceJuly 31, 2026

Dealership Profits Decline

While new and used retail sales stagnated, dealerships have been particularly supported by fixed operations and finance-and-insurance profits, according to a new report.

Read More →
Auto Dealer Today, Dealer Debrief, 07/15/2026, with Lauren Lawrence
Dealer Opsby Lauren LawrenceJuly 15, 2026

Dealer Debrief: Defection Data & EV Updates

In this week's debrief, host Lauren Lawrence discusses how to use defection data to your advantage and the latest on EV sales and charging infrastructure.

Read More →
Ad Loading...
Two professionals shake hands while exchanging a car key fob beside a vehicle, symbolizing a vehicle sale, lease agreement, or dealership transaction.
SponsoredJuly 8, 2026

How Defection Data is Bridging the Dealership Conversion Gap

Lead volume is flat, cross-shopping is up and brand loyalty is in retreat. As confident sales teams keep losing buyers they thought they had, daily industry sales data is showing dealers exactly where their funnel is breaking and how to fix it without buying a single new lead.

Read More →
Auto Dealer Today, Dealer Debrief, 07/02/2026 with Lauren Lawrence
Dealer Opsby Lauren LawrenceJuly 2, 2026

Dealer Debrief: Where are you losing customers?

In this week's debrief, host Lauren Lawrence discusses the hidden leaks in dealerships where you might be losing customers without even realizing it.

Read More →
Auto Dealer Today, Dealer Debrief, 06/25/2026, with Lauren Lawrence
Dealer Opsby Lauren LawrenceJune 26, 2026

Dealer Debrief: Improving Your Inventory Management

In this week's debrief, host Lauren Lawrence covers a new survey that shows what service technicians really want and two launches that could help improve your inventory and vehicle life cycle management.

Read More →
Ad Loading...
group of people standing in a circle holding puzzle pieces together
Dealer OpsJune 1, 2026

Ladies and Gentlemen, This Is a Dealership: Why the Fundamentals Still Decide Who Wins

A teaching moment by a legendary football coach happens to apply perfectly in the auto retail space. Learn what it is and how to use it to your store’s advantage.

Read More →
two cars on a billboard, No Hidden Fees
ComplianceMay 1, 2026

Dealer Ads and the FTC

The agency has made it clear in recent enforcement actions and warnings, in auto retail and other industries, that advertised prices must include all nonoptional costs to the consumer.

Read More →
Closeup of white car's headlight, front end
Dealer Opsby Hannah MitchellApril 17, 2026

Used Autos Supply Dwindles

The March shopping surge, despite high prices, cut into inventory by the most since the thick of the pandemic, Cox Automotive analysts calculated.

Read More →
Ad Loading...
hands making protective frame over red car, Risk Reality Check, Be Proactive, Auto Dealer Today logo
Dealer OpsApril 1, 2026

Managing Risk Effectively Through Changing Times

The variables influencing risk pricing have changed significantly over the past five years. Being proactive and responsive to emerging trends is not optional but essential.

Read More →