7 Effective Types of Reconciliation to Help Verify Your Dealership's Accounting

Article

By Glen McMahon

Have you experienced inconsistencies in your systems? For instance, your floorplan lender may have 174 vehicles, yet your floorplan schedule may indicate 172. While these minor differences are not necessarily incorrect, it is important to identify and resolve these inconsistencies.

As a dealership owner, we know you have a lot on your plate. Verifying your dealership’s accounting is critical to confidence in your systems and ultimately, long-term success. Reconciliation is a simple, yet effective method of verifying your dealership’s accounting. Reconciliations can be completed wherever there are two systems that should reflect the same information.

Typically, there are three steps in the reconciliation process:

  • Identify any inconsistencies between the two systems
  • Analyze and provide an explanation for the inconsistencies in the systems
  • Use the discovered information to correct inconsistencies where appropriate

1. Bank Reconciliation

Keeping your bank account reconciled is the most basic and critical reconciliation. Many dealerships have a large volume of outstanding checks which can cause your balance to fluctuate frequently. This means the balance you see in your account may not be accurate and up-to-date. Some businesses compensate for poor cash control with overdraft lines of credit or hold larger amounts of cash in a checking account. In this case, you should consider the impacts of interest and other fees.

Reconciling your bank account on a regular basis is a simple, yet valuable method of making sure your accounting processes are in order and current. We recommend dealerships complete daily bank reconciliations - monthly at a minimum.

2. Floorplan Reconciliation

Your floorplan is often the largest cost, source of funding, and potential for lost inventory. Quick payoffs can limit interest needed to be paid on your floorplan, which is especially important with rising rates. Additionally, many dealerships lose floorplan funding and have even gone bankrupt due to repeat violations. By keeping your floorplan reconciled effectively, you can avoid many negative financial consequences for your dealership.

We recommend floorplans be reconciled monthly. It’s common for dealerships to reconcile at year end or rely on floorplan auditors; however, this will not identify misstatements in the general ledger.

3. Factory Reconciliation

A franchised dealership’s business relationship with its OEM is key. The open account is used as a receivable and payable for every business line at the dealership. With many different programs and payments flowing through the open account, it is very possible that some may be missed or mis-posted. Since payments are typically deducted or paid automatically, without any intervention or reconciliation, the balance of the open account may differ significantly from the actual value. 

You should reconcile parts statements to your open account monthly or whenever statements are released. Regular reconciliation helps keep the workload manageable and your information accurate.

4. Parts Pad Reconciliation

Parts are kept in a perpetual inventory system and the balance of the parts account on your manufacturer’s statement isn’t calculated based on what parts you have on hand. Therefore, it is critical that you re-calculate the value of all inventories on hand from your parts pad and reconcile it to your parts inventory account(s) on a regular basis.

To help ensure your parts inventory is reflected accurately, we suggest you reconcile between your parts pad and parts inventory account(s) each month. You should also consider comparing the difference to prior periods and set a percentage difference to take action – full inventory, third-party inventory, or compensation adjustment.

5. Retail Delivery Reporting (RDR) Reconciliation

RDR reconciliation is a comparison between what and when your accounting system reflects the sale of a vehicle and when it is reported to the factory. These reconciliations are useful secondary checks to confirm a vehicle has been reported sold and ensure incentives on the sale were received. RDR reconciliations can be done for new and CPO units. Additionally, these reconciliations are important in any stair-step program, particularly those that pay retro where the difference of one vehicle sale can be thousands.

Consider preparing a monthly reconciliation between monthly deliveries from your factory website or factory representative, and list of deals posted in the current month. Once completed, you should share this with your sales department to ensure corrections are made while the OEM is accepting changes.

6. Inventory Reconciliation 

As an alternative to an RDR reconciliation, your factory portal will have a separate list or units reflecting your on-hand inventory. You can compare this to your inventory schedule as a method of reconciliation. While this method will not be as direct as an RDR reconciliation for double-checking incentive program earnings, it can ensure dealer trades are recorded. 

We recommend you prepare a reconciliation between the inventory schedules and an inventory list from the factory monthly. It is easiest to choose one method and use that moving forward. However, you can reconcile both RDRs and inventory, there will just be some overlap of information. 

7. Fixed Asset Reconciliation

If you use a separate fixed asset management program, you should ensure all changes have been posted and nothing extra has been recorded that did not get entered into your management system. A fixed asset management system, such as BNA, can provide reports with balances that should be in your accounts. From there, you can compare and analyze any differences.

For most dealerships, we recommend monthly reconciliations. However, single stores or smaller businesses may only need to reconcile quarterly as the IRS has different depreciation requirements for assets depending on what quarter it enters service. In that case, it’s a good idea to plan ahead to ensure a clear cutoff.

We know you work incredibly hard to keep your dealership functioning successfully. With so many areas of your business requiring your attention, these different types of reconciliations, while important, might seem daunting. Eide Bailly’s dealership advisors are here to guide you and answer all your questions throughout the process. 

Let us help you get started with these simple, yet effective reconciliations to verify your dealership's accounting and put you on a path towards long-term success.

Stay current on your favorite topics

SUBSCRIBE

Learn More

See what more we can bring to organizations just like yours.

Dealerships