To setup, the Management Accounts, first, open the Management Accounts Application which is an Excel Spreadsheet titled 01mail.xlsm.
When opened, the spreadsheet looks as follows:-
Click on the “Parameters” sheet (as shown above).
At the top, fill in the Company and Location (Dealership) name. These are used for headings when printing out the Management Accounts.
Fill in the months/years for the Period end dates for the current year (eg if the year-end is December, this will be January through to December).
Fill in the Navigator Branch no and API Key (which will be supplied by the Navigator Helpdesk or your DMS Project Manager). The branch no can be any Navigator branch no within the company that is being reported on.
Fill in the descriptions of the Car models that require analysis on the Vehicle section of the Management Accounts (eg for a Ford dealership this may be KA, Fiesta, Focus, Mondeo, etc).
Next to each of the models is the Navigator Make.Model for the model in question. This should be able to obtain from the Navigator Trial balance (it is the last two parts of the nominal code). Please refer to you Navigator Implementation consultant or Project Manager.
Loading the Initial Accounts Mapping Table
The Management Accounts spreadsheet relies on “mapping” of Navigator nominal codes to codes used on the Management Accounts sheets. For example, looking at the New Car – Retail (NR) sheet:-
The codes are in the first column – Ie 01NR005 is the code relating to the sales of Car Model 1.
Navigator is supplied with a “standard” accounting setup, and as such, there is a standard mapping for all possible nominal codes to the relevant lines on the Management Accounts.
This is loaded by clicking the “Initial Map” button on the Parameter Sheet:-
This takes a few seconds and will then display the following:-
Updating for Make & Model mapping list
To apply a conversion to the Make.Model mappings to the standardised map you will then need to click the “Remap Makes and Models” button on the Parameter Sheet.
This takes a minute or two to process.
This may display a message when complete:-
