XCARS is a dealership that buys and sells used cars. Vehicles, purchase prices, expenses and which salesperson bought which car lived in separate spreadsheets and in people's heads; working out the real monthly profit and each person's commission took hours.
We brought all of it into a single panel.
What we built
- Vehicle inventory: every current and past vehicle with plate, model, mileage, purchase price and status (bought, consignment, reserved, sold), plus how many days it has been on the lot.
- Buying and selling: every step from adding a car to selling it is recorded; inspection and general notes stay attached to the vehicle.
- Accounting: monthly revenue, profit and expenses, with per-vehicle margin and a profit breakdown calculated automatically.
- Staff performance: each person's purchases this month, purchase and sale commissions and earnings on one screen.
- Activity log: who did what, on which car and when, filterable by person and date.
- Permissions: staff see only the cars they are responsible for; the manager oversees the whole lot and every change.
Result
The owner sees stock value, this month's purchases and profit on the first screen; month-end accounting and commissions now take a few clicks.
