Ivan Makshakov Email & Phone Number

Canberra, Act, Au

Australia

Notable Achievements at National Capital Motors:• Developed Floorplan reconciliation and payouts report reducing the reconciliation time from 1 day to 15 minutes and floorplan payouts from 2 hours to 15 minutes.• Created finance income model that allowed stock-specific allocation which resulted in quicker EOFY audits, improved accuracy of management accounts and more detailed management reporting. • Conducted a comprehensive review of chart of accounts to align the payroll cost centers setup with more advanced capabilities of Dealer Management System (DMS). Made necessary changes that improved the mapping efficiencies for external and internal reporting.• Created data-scraping model for registration certificates for automated filing in SharePoint and easier posting to General Ledger which allowed for easier reconciliations of corporate credit cards and faster document retrievals.• Prepared and ran education session for sales managers on deal costing practices to improve gross profit and efficient use of DMS which resulted in better quality sales packs arriving to administration department for processing and overall improved costing practices.• Integrated commission data input for payroll processing to improve the accuracy and speed of commission data entry.• Timely rectified IT emergency that prevented the companies in the group from accessing DMS while IT manager was unavailable.• Created Pre-delivery mobile app for vehicle intake and tracking.• Promoted to run both National Capital Motors and National Capital Toyota in 2021.• Led Tune migration project from start to finish.

Australia

Notable Achievements at National Capital Toyota:• Improved quality and timing of factory and management reporting which helped to secure 2021 and 2022 Toyota Business Excellence Awards.• Set up end of months processes that Improved reporting timeliness from 10 working days on average to up to 7 days.• Configured DMS for automatic vehicle purchases reducing the processing time from hours to seconds.• Promoted to run National Capital Motors in 2020.

Melbourne, Australia

Notable Achievements:• Optimized floorplan payouts report to predict cash outflow more accurately.• Developed report for daily floorplan reconciliations and floorplan audit outcome estimation.• Improved quality of factory reporting.• Significantly improved payroll cost center structure.• Reduced time spent on allocation of factory payments by 30% through use of SQL and Power Query.• Taught accounts receivable officer VLOOKUP, which allowed for greater accuracy and efficiency of parts and service debtor payment allocations.• Automated data input for payroll processing.Key Responsibilities:• General Ledger reconciliations (130+ Balance Sheet accounts).• Reconciliation of sub-ledger to the general ledger (Warranty, Vehicle debtors).• Daily cash flow forecasting and reporting.• Preparation, projection, and processing of floorplan payouts.• Used vehicles bailment.• Floorplan reconciliations.• Deal processing.• Bank statement processing and reconciliation.• Factory payments allocations (Holdback, Dealer claims, Warranties, Factory Parts & Service Debtors) – Mazda, Hyundai, Audi, Volkswagen, Suzuki.• Payroll processing (UNIPAY) including end of month reporting (Payroll tax, superannuation, end of month payroll accruals).• Monthly factory reporting for two Audi dealerships and one Volkswagen dealership.• Creditor invoices processing.• Processing of payouts to financial companies.• Attending to vendor and debtor queries.

Accounting

Master’S Degree, Accounting

Bachelor'S Degree, Management