Dealer reports: aging, profit, sources, days to sell: how it works
Stock aging with the landed cost per band, profit per car and per salesperson, leads and purchases by source, average days to sell and the margin-scheme VAT of the period.
Lesson 13 of 22 · How it works
How it works
Stock aging lists every car on the lot with days in stock, band and Landed cost The cost of goods delivered to your door: purchase price + freight, insurance, duty, clearing, port, inland and bank costs, spread to each product. More words in the glossary, oldest first.
The sales report for a period shows each invoiced Deal A sale you are trying to win. It has a value, a stage and an expected close date. In the end you close it as won, or as lost with a reason. More words in the glossary with price, cost, gross profit, VAT scheme and days to sell, and totals per salesperson.
Lead sources compare leads, won leads and cars bought per source.
The period's margin-scheme VAT is the figure to enter in the VAT return The report you file with the FTA for each tax period (form VAT 201). The boxes are worked out from your invoices and expenses, and you can open the documents behind each figure. More words in the glossary.
Where to find it
- Reports
/admin/car-dealer/reports
Checklist
Before you move on, check that you can:
- Open Reports
- Stock aging lists every car on the lot with days in stock, band and landed cost, oldest first.
- The sales report for a period shows each invoiced deal with price, cost, gross profit, VAT scheme and days…
- Lead sources compare leads, won leads and cars bought per source.
- The period's margin-scheme VAT is the figure to enter in the VAT return.
Tips and common mistakes
- Cars over 90 days are the ones to reprice or wholesale.
- Profit is taken from the deal at invoicing; a later credit note does not change it.