	Questions & Suggestions Call 716-445-9721

Used Vehicle Sales Analysis Excel Workbook
Lifetime End User License

Download a Customized Excel workbook, designed and written by IntactAuto®

Password Required to Log into the Excel Workbook: Previously Assigned
You may change the user password on the Default Set-up worksheet

Workbook Created & Updated: February 02, 2011

Please download within 24 hours,
This available Microsoft Excel workbook does become inaccessible after 24 hours and will require you to contact IntactAuto® for access to another downloadable, working copies.

Unauthorized Downloads
Will not receive free services, updates or support when made available. Any services required for unauthorized downloads may be denied or programming services and the required purchase of a user license will be billable at the current market rate determined by IntactAuto Holdings, LLC.

Download your Customized Excel Workbook,
  *  Right-Click your mouse on this link: Download Retail Sales Analysis Workbook
  *  Right-Click your mouse on this link: Download Wholesaler Sales Analysis Workbook
  *  Select, "Save Target as"
  *  Select either, "Desktop" or "My Documents"
  *  Click, "Save" with your mouse
Customized Software Package will now download to your selected location.

Changes made to previously released workbook

Dec 15, 2010	The addition of an Inventory Management Report (See Main Menu) which always the user to View, Analysis and Print a detailed analysis of all transaction types, being Sold Vehicles, Pending Sales or Unassigned Transactions ~ Inventory. The report allows the user to analysis vehicle sales profitability for both Sales and Purchasing Agents and is sorted by Age of Inventory. Multiple Display options are available within this report.
Dec 6, 2010	Added a Sales Record Search ~ Forms Button to the sales reporting worksheet which allows the user to entered the last 6 of the VIN.# to locate a specific transaction which then permits entry to Detailed Entry Screen for review or updating. Search Sales Records at a later date may allow multiple searching options.
Nov 5, 2010	Completed All Core Analysis Reports and Extensive Workbook Testing, required changes made. Base Excel Workbook complete. Started developing Purchasing and Sales Agent Performance and Commission Reports. Project on hold until final approval of Base Workbook and a detailed outline as to what the performance report requires, including layout and data.
Oct 27, 2010	Completed Workbook Directions rewrite and made minor modifications to analysis reports. Have begun the process of developing Purchasing and Sales Agent performance and commission reports. Still in need of a detailed outline as to what the performance report requires, layout and data. Items Pending completion; Vehicle Sale Summary Reports requires some modifications and corrections.
Oct 24, 2010	Redesigned Sales Log to display all required data fields and removed unnecessary information columns. Adding Vin.#, Title # and State of Origin. Modified all the Sales Analysis Reports which interact with the completely redesigned data table; this also included the Backup, Import and Export Data Tables. Redesigned the data entry screen to reflect the requested changes; Model Description field, Color, Destination, Sold/Sale Price, Purchase Agent, Vin.# Field and Miscellaneous Expense and Sales field for future updates. Changed terminology, replacing Finalized Transactions (F) with Sold Vehicles (S) Removed all reference to Automotive Finance & Insurance Sales and Income Expanded Model Year Selection and Reporting Capabilities Items Pending completion; Performance Reports and Commissioning Reports based on pending outline, the rewriting of workbook directions and addition report testing.
Oct 3, 2010	Redesigned complete workbook to include a Used Vehicle Sales Report which displays up-to 500 Used Vehicle Sales Transactions with a print routine.
Oct 3, 2010	Totally redesigned the transaction entry process, making it extremely user-friendly and correcting previous data entry program error. To enter a transaction, simply access the Used Vehicle Sales Report and Check the Blue Box of the transaction you would like to enter or edit.
Oct 3, 2010	Totally redesigned the Transaction Entry Screen to include 3 User Defined Comment fields which are defined on the Default Set-up Screen. Also, added to the Transaction Entry Screen are input cells which allow you to record Sales Agent Fees-Commissions Paid and the Date Paid. These input cells will eventually be used to create Sales Agent Performance Reports.
Sept 22, 2010	Data Table Export Macro routine added on Default Set-up worksheet which creates a New Workbook on the users Desktop for e-mailing as an attachment and/or Data Table backup
Sept 22, 2010	Added a Detailed one-page Used Vehicle Analysis Summary Report which summarizes the currently available 4 hard coded analysis reports, which also required a modification to the Main Menu Screen.
Sept 22, 2010	Updated the Default Set-up Help Screen - Requiring a review
Sept 22, 2010	Updated core data storage routine correcting Age-in-Days calculation error
Sept 22, 2010	Redesigned and Edited workbook message boxes with added usage instructions
Sept 22, 2010	Added a worksheet Zoom function to the Default Set-up page, allowing the user to modify report screen display sizes without modifying the Computer display resolution

Excel® must be installed on your system & Macros must be Enabled to actively use worksheets.

Disclaimer of Warranty.
This software is provided "AS IS" and with all faults. With No expressed warranties, guarantees or conditions made. You cannot recover any damages, including consequential, lost profits, special, indirect or incidental damages beyond your actual purchase price. This software does require you to accept an End User Licenses Agreement prior to usage.

Helpful Tips....
Be sure to make a Master Copy of this workbook and use the Master Copy for creating new months, eliminating the need to remove the prior months data before starting a new month.E.g. Change and Save each new month under a filename like SalesLog-12-2010

Want to speed-up the learning process? Request a personalize demonstration.....
You may at anytime request and schedule a private on-line, shared screen demonstration of this Cash flow Analysis workbook. Online demo services are provided by Adobe® ConnectNow, requiring no software download on your behalf.

All Rights Reserved, 2011 Copyright Pending, IntactAuto Holdings, LLC Contact Phone: 716-445-9721 | Privacy & Legal Notice