Reports are an essential method of tracking profit and costs, reporting sales tax, and examining dealership trends. To that end, DeskManager Online offers customizable and comprehensive reporting tools, as well as a handful of common premade reports many dealers rely on.
How to Add Reports
Reports & Charts can be accessed from anywhere in DeskManager by clicking on a category on the sidebar.
Reports & Charts can also be found by clicking the Settings cogwheel located at the bottom of the leftmost sidebar.
To view our premade reports or create your own, first navigate to the Library Reports tab.
Read the description beneath each report for an idea of what it contains. To see what’s displayed within the report, click Preview.
If you’d like to add this report to your system, or if the report is close to a report you need, click the Add button so we can customize this report further.
You can change the Name and Description of this report if desired.
In the Scope section, you can choose if the report will appear for the entire Company, a Role, or only for you.
You can always edit these details at a later time. When ready, click Submit.
This report has now been added under your Inventory tab. Once a report has been added to this tab, it will be available under the corresponding Reports & Charts category.
To export your report, click Export in the top-left and choose between three format you desire.
Exporting reports as an Excel file typically utilizes the Microsoft Excel format.
Comma Delimited will be exported as a DOT CVS file.
Tab Delimited will be exported as a DOT TVS file.
To print your report, click Print in the top-left. This will open a preview in your current browser.
Customize allows you to alter reports to your specifications.
To easily access the report, mark it as a Favorite.
Once marked as a Favorite, the report will be defaulted to the Favorite section of Reports & Charts.
You can modify the filters by clicking the drop-down at the top. Quick Filters can be promptly used to filter reports.
You must customize a report to make permanent changes to the filter.
Lastly, you can group a report by a column, such as if you wanted to re-organize your report to display every entry by Buyer County, which may be helpful in a Sales Tax Report.
To do so, drag the column under the Modify Filter dropdown menu. This will reorganize the report.
To expand a newly-grouped column, click the gray box beside that column.
To return the report to its default organization, simply drag that column back into the report.
A brief overview of your data will appear at the bottom of the report in the Summary section, which can be customized as needed.
How to Customize Reports
On your Company Reports tab, click Customize to the right of the report.
In this example we will customize our Available Inventory report to display available vehicles from last month.
Under the Customize Report tab, you can change the Name, Description, and Scope of a report as well as whether the report is Lot Specific or not.
Under the Scope section you can choose if the report can viewed by the whole company, role, or only for you.
Filters determine the type of information pulled from the report category, which in this case is the Inventory. At the top, this Status filter is pulling all Available inventory into our report.
Let’s add an additional filter. To pull a report on vehicles we added last month that are still available, we can add an Inventory Date filter for last month. Click Add Rule in the top-right, then select a new rule.
There are several date range options. For example, we can select a date range Between two specific dates.
Alternatively, if we select a dynamic date range, this report will change according to the current date. For example, if we set this report to Last Month then it will always show us the month prior to the current month. Dynamic date ranges are preferable for reports you will view on a regular basis.
Pay attention to the AND/OR filter in the top-left of our group. If AND is selected, a vehicle has to meet the conditions of every rule to enter the report. If we change this filter to OR, a vehicle has to meet only one requirement to enter the report.
In our example, the OR filter would pull every available vehicle into the report, as well as every vehicle that was added within our Inventory Date range, whether or not it is available. Using the AND filter would only pull vehicles that are both available and added within our Inventory Date range.
In the Returned Data section below, you can add or remove columns to determine what information is displayed on this report.
The Selected Fields section contains the fields that will appear on your report. The order of the list determines the positions of the columns on the report. Drag a selected field to change your report’s column arrangement.
To remove a Selected Field, drag a field into the Available Fields column on the left.
And to add a new field to the report, search for an Available Field and drag it into the Selected Fields column on the right.
You can Save & Close or Save & Preview at any time while working with the report.
Comments
0 comments
Please sign in to leave a comment.