Is your business AI systems safe? Take the free AI Safety & Readiness Checklist  ·  Get your free action plan →
Positive Traction
Automotive business guide

Dealership Stock Reconciliation

A yard can look full while the stock report and the accounts tell different stories. Reconciliation brings the vehicles you hold, the costs recorded against them and the funding balances into one view. It also helps explain why a strong sale price does not always produce a strong margin.

Bookkeeping for car sales yards and dealers →

Start with one reliable stock list

Use a stock number or VIN to identify each vehicle across the dealer system, purchase paperwork and accounting records. Record whether it is dealer-owned, held on consignment, sold awaiting delivery or already delivered. Physical location alone does not establish ownership.

Agree a reporting date before comparing lists. A purchase posted after month-end, a delivered sale still marked in stock or a duplicated trade-in can create a difference even when the individual documents look correct.

  • Current dealer-system stock list and a physical stock check
  • Purchase invoices, auction statements and trade-in paperwork
  • Sales invoices, delivery records and settlement statements
  • Reconditioning invoices and vehicle-specific dealer fees

Reconcile movements, not just the closing total

Start with the opening stock list, add purchases and trade-ins, then remove vehicles sold or otherwise transferred. Compare the expected closing list with the yard and the accounting records. Investigate missing vehicles, duplicate entries and costs sitting against the wrong stock number rather than posting an unexplained adjustment.

Separate customer deposits from completed sales and follow the agreed treatment of undelivered vehicles. Your bookkeeper and accountant should confirm the cut-off and accounting treatment for your arrangements.

  • Match every addition to its purchase or trade-in evidence
  • Match removals to delivery and sale records
  • Check that reconditioning costs follow the correct vehicle
  • Keep an exceptions list with an owner and resolution date

Keep floorplan debt separate from stock cost

A floorplan statement is a funding record, not a substitute for the vehicle stock ledger. Reconcile advances, repayments, fees and interest to the loan account and bank movements. Check sold vehicles for unsettled funding and vehicles still held for funding recorded against the wrong unit.

Repaying loan principal is not another vehicle purchase cost. Bring funding charges into your management reporting without counting the original purchase twice. Review the treatment of fees, interest and stock costs with your accountant where needed.

  • Opening and closing lender balances
  • Advances and repayments matched to bank transactions
  • Sold units with outstanding funding highlighted
  • Fees and interest reviewed separately from principal

Use the differences to make better stock decisions

Once the lists reconcile, review days held, reconditioning spend and vehicle-level contribution before overheads. A recurring difference is often a workflow issue: paperwork arrives late, a stock number is missing or the sale is recorded in one system but not the other.

Set a regular review with the person responsible for purchases and sales. Smart matching can speed up repetitive work, while our team investigates exceptions and reviews the accounts. GST treatment of trade-ins, second-hand vehicles and consignment arrangements depends on the facts; our Registered BAS Agents check the agreed BAS work rather than relying on a generic software code.

A sale that looks better than its contribution

Illustrative example only—not a client result. All amounts exclude GST. The sale is $35,000, purchase cost $28,000, reconditioning $2,000 and directly allocated selling and holding charges $1,500. The initial $7,000 spread becomes $3,500 before general overheads and income tax. The point is to reconcile all costs, not treat the sale-minus-purchase figure as net profit.

Check which costs your stock report includes before using it to set prices or decide how long to hold a vehicle.

Keep the records behind the numbers

Keep source documents and a clear trail for adjustments. The ATO's business record-keeping guidance explains the importance of records supporting your business transactions. This guide is general information, not advice on your individual tax or accounting treatment.

Put it into practice

Ongoing bookkeeping keeps the source records current. Business advisory helps you use the reports in your next decision.

Book a complimentary 15-minute call →