Contents - Index

Quotes Reports

Button from main screen

Purpose
To provide reports for the Quotes system.

Layout / How To
The top of the screen is used to set the date range for the desired report. You may set the date range manually on the two calendars or you may set it from the speed buttons presented.

The list of reports available are underneath the date range settings. To run a report, click down the report you want and then press one of the buttons in the Report Controls box. 

Reports Available
Master Log. This shows all vehicles in inventory which are not actively being quoted. The date that the vehicle was active in inventory is used for the report date range.

Incentive Report and Summary. These are used to show deals by representative for the date range provided. The report shows contents from the Lease Log and the summary shows tallies for the same data, as well as including referrals. If you need to calculate incentives for your representatives, then the summary can be programmed to do so. Contact Support if you need special calculations to provide incentives to your sales reps.

Lease Control Log. This shows all leases which have been finalized. The date of the lease is used for the report date range. The Lease Control Log by Rep will sort, break, and subtotal by rep code.

Profit and Loss Statement. This shows all vehicles from the Sales Log File whose post date falls in the date range provided. The profit/loss calculation is simply Sales Price minus Purchase Price (which is set from ACV). The Gross Profit column is a running tally of profit/loss. Please note that this report uses the post date from the sales log record, and is displayed as m/yyyy on the report. To include vehicles that were re-leased from inventory, provide the name of your leasing company (exactly as it appears in the lease log records) in the space provided. The report will pull any lease in the date range that has this name as the selling dealer. It will then pull the corresponding quote (matching by control number) and then retrieve the inventory record for the profit/loss calculation.

Referral Log. This shows all records from the Referral Log whose date falls into the date range provided.

Resale Products Log. This shows all records from the Resale Products Log File whose sold date falls in the date range provided. The report is grouped and tallied by product.

Service Contract Remittance Log. This shows all service contracts from the Warranty Log File whose warranty sold date falls in the date range provided.

Sales Tax Reports. There are three sales tax reports. Each report extracts 1) Service Contracts sold in the date range, 2) finalized Leases with lease dates in the date range, 3) Warranty refunds in the date range, 4) retail sales and buyouts in the date range (from the Sales Log and uses the Post Date field), 5) lease payments from the daily payments interface that have been posted to the ALMSys External Payments Taxes screen, and 6) Resale Products sold in the date range. The Sales Tax by County shows a summary by the county descriptions provided and is to be used to facilitate sales tax filing. The Sales Tax Cross Reference is merely a cross reference to see which codes were used together.

Vehicle Logbook. This shows the official logbook of vehicles sold or leased. The report date range is used to report vehicle inventory records with any activity (date in or date out) in the range specified. This report is location sensitive and may be limited to one specific location. Location zero is always assumed to be the home (main) location, and all vehicles that come in off of leases or trades go to this location for safety checks.