Posts Tagged ‘DealerTrack General Ledger’

How to run a Financial Analysis with DealerTrack DMS

November 20th, 2009  |  4 Comments  | 

share on facebook  | 

The Financial Analysis tool is a powerful reporting feature that allows you to build customized reports on any combination of general ledger accounts.  Use this tool to help build your budgets, forecast expenses, analyze trends, and much, much more.

With Financial Analysis reports, you can display up to 16 columns of customized information and print up to 12 columns. You can drill down to any dollar amount in the analysis, either to the GL journal or the source document. Other Dealer Management Software companies, including ADP and Reynolds and Reynolds, do not have this feature, making it unique to the DealerTrack Dealer Management System. You can also set up forecasts to see if you are meeting their goals throughout the month. Some owners may be interested in trended expense reports to monitor their expenses.

The Financial Analysis screen can be reached from the General Ledger application menu.

User Guide

After selecting “financial Analysis” from the General Ledger application menu, the screen that displays lists all Financial Analysis reports that have been created and saved.  The following Options and Functions are available from this screen:  Line options that are available from the Financial Analysis Report List Screen Are:

  • 1=Work With – Use this option to build or modify a report.
  • 2=Edit – Displays the Financial Analysis Report Definition Screen. Make changes to the Report Title and report lines from this screen.
  • 5=Display – Displays the report.
  • 6=Print – Prints the report selected. When this option is used, the Financial Analysis View Selection Screen will display.
  • 8=Forecast – Allows different forecast amounts/units to be entered for any G/L line in the report.
  • 9=Print Exception- Lists accounts not routed in a doc according to selected type and department, and lists accounts routed more than once in a doc. This can be used for troubleshooting purposes.
  • 10=Security – Add display/change security to different users. Use this option to display the Financial Analysis Report Security Window for the selected report.
  • OK – Confirms selection of the indicated option
  • Exit – Returns to the General Ledger application menu
  • Add – Displays the new report definition window, for building a new report. Previously built reports will display on the Financial Analysis list screen.

GL_Finanical_Analysis_List_screen

Quick Start Guides

For more information on using the Financial Analysis function please visit the DealerTrack Wiki by clicking on one of the links below.

    Tags: , , , , ,
    Posted in Best Practices, Tip of the Week | 4 Comments »

    Unit Counts not matching in Factory Financial

    November 10th, 2009  |  2 Comments  | 

    		share on facebook  | 

    If you are trying to submit your Factory Financial and are receiving a terminal error message telling you that you have Sales with no unit counts or Unit counts with no Sales, here are a few things to check.

    1. To view your error messages Go into the General ledger by selecting  Application GL
    2. Select Reports to Outside Parties (35)
    3. Tab down one and enter a 1 to select (or click on Factory Financials if in the GUI).
    4. Now go back up to the top and change your month to reflect the month you are working in.
    5. Now you will tab down to any line (right click next to any line if in the GUI) and type a 10.
      1. This will display your error message.  It will display the Page, Line, and Column of the error message, whether the error is T (terminal) or W (warning) and it will give you a brief description of the error message.  If you are receiving a terminal error message, this must be corrected before it can be transmitted.  If they are warnings, you do not have to fix them, but they are there so you can view them and change them if you wish to.
      2. If this terminal error message is Stating that you have Sales with no unit Counts or Unit Counts with No sales, the First place you are going to want to check is the General Ledger Chart of Accounts
      3. Back out of your error message, and continue to back out until you have reached the Main General Ledger Screen.  You will now go into 45 (Chart of Accounts).
      4. You will type in the account number you want to look at, and then you will type in a 6 (right click, select units if in the GUI).  This will display the unit counts for each individual month.  If the month in question has 0 in it or is blank, but you have sales for it, you will need do a 2 to change next to that month (right click, change) and type in the units.  You will then hit enter and make sure that it saves by backing out and going back into it.

    You can now go back to the GL/35 and complete steps 1-4.  If you are no longer receiving this error message, and all of your terminal errors are no longer showing up, you can now transmit your FF to the Manufacturer by doing a 9 next to Line 1 to Transmit.

    Tags: , , ,
    Posted in Tip of the Week | 2 Comments »