Automotive Accounting & Mapping Analyst

Jackson Dawson•Dearborn, MI

18d•Hybrid

About The Position

Jackson Dawson is seeking an Automotive Accounting & Mapping Analyst to translate dealership financial data into clear, accurate reporting within TrueTrack. This customer-facing role analyzes dealership General Ledgers and maps accounts to TrueTrack’s standardized Chart of Accounts, helping Controllers and Dealer Principals understand how financial information is organized and presented. The role combines hands-on accounting analysis with customer education and consultative support. It involves explaining mapping decisions, reconciling TrueTrack reporting to dealership financial statements, and helping dealership leadership use the data to understand departmental performance and identify improvement opportunities. Success requires sound accounting judgment, critical thinking, attention to detail, and the ability to explain complex financial concepts in practical business terms. The work environment is hybrid, with three days on-site at the Dearborn office. Travel of up to 15% is required for in-person dealership meetings.

Requirements

Bachelor’s degree in Accounting or Finance, or equivalent work experience.
2–4 years of experience in accounting or financial statement preparation and review.
Understanding of balance sheets, income statements, GL account relationships, and reconciliation practices.
Knowledge of dealership financial statements, departmental profit and loss statements, and common account schedules.
Familiarity with metrics including departmental gross profit, fixed absorption, expense-to-gross ratios, inventory days’ supply, and F&I income per vehicle retailed; ability to identify financial anomalies and performance outside expected benchmark ranges.
Demonstrated experience presenting financial information to business owners or senior leaders, explaining accounting decisions, leading consultative discussions, and addressing questions with confidence and diplomacy.
Proficiency in Excel, including lookups, pivot tables, and reconciliations; Power BI or similar business intelligence tools; Microsoft Outlook, PowerPoint, and Teams; and Zoom.
Strong critical thinking, problem-solving, attention to detail, and documentation skills, with the ability to manage follow-up and communicate practical solutions to dealership and internal teams.
Ability to prepare concise, effective emails, mapping documentation, and customer-facing educational materials.
Ability to travel up to 15% for in-person dealership meetings and to walk short distances and stand for short periods, with or without reasonable accommodation.

Nice To Haves

Automotive dealership accounting experience, including experience in a dealership accounting office, on a Controller’s team, at a CPA firm serving dealerships, or in OEM or 20 Group financial analysis.
Experience with a dealership management system (DMS) and its GL structure.

Responsibilities

Review GL accounts, trial balances, OEM financial statements, and account schedules to understand how dealerships record revenue, cost of sales, expenses, and balance sheet activity across New Vehicle, Used Vehicle, F&I, Service, Parts, and Body Shop departments.
Identify accounts shared across departments or locations, interdepartmental activity, and store-specific allocations; document combined accounts, misclassified expenses, inactive accounts, and other nonstandard practices; and consult Controllers or Office Managers to clarify account purpose before mapping.
Map dealership accounts to appropriate TrueTrack categories based on accounting purpose and underlying financial activity, and maintain dealership-specific records explaining material judgment-based decisions and mappings.
Reconcile mapped results to dealership trial balances and OEM financial statements, investigate variances, resolve missing or incomplete data, and follow data-integrity and security standards.
Update mappings as dealerships add, retire, or restructure accounts, and document changes that affect comparisons with prior periods.
Guide Controllers and Dealer Principals through how accounts flow into TrueTrack categories, departments, and KPIs; explain differences from dealership or OEM reporting; address questions; and obtain leadership approval of mappings.
Demonstrate how consistent mapping supports departmental profitability analysis, benchmarking, and trend reporting, and help dealership leaders use TrueTrack to monitor performance, identify underperforming departments, and track business goals.
Conclude review meetings with prioritized and documented next steps, clear owners, and follow-up; coordinate accounting corrections and mapping adjustments; and quantify potential weekly time savings for accounting teams.
Flag misposted entries, inconsistent cost allocations, unreconciled balances, and other reporting issues; explain findings to Controllers; and recommend corrective and preventive steps.
Deliver live and recorded training on TrueTrack reports, KPIs, and departmental performance; present virtually and in person to groups of approximately 1–10 participants; and develop mapping guides, COA references, and KPI explanations.
Share dealership feedback and recurring mapping challenges with product, design, and development teams; help improve mapping automation, validation, and documentation; and maintain standards, playbooks, and DMS-specific reference materials.
Explain accounting issues in plain language to dealership liaison teams, provide accounting insight for sales discussions, and respond to helpdesk tickets and dealer questions.