:: Products
:: Data Extraction
:: DMS Consulting
:: Training & Seminars
:: CRM resources
:: Order Form
:: Free Downloads
:: Digital Dealer
:: About Us-Sandi's Blog
:: Contact Us

:: Products  I learned so much from the first book that I ordered two more. The knowledge in your books surpasses any class I've ever taken. Thanks again for doing what you do...helping others do their job better." Michelle Clemens McMahon Ford

:: New - Cash for Clunkers Matching Database                                      
:: New - Super Excel learn Excel 2007 and use data from your DMS system!
:: New - Data Miner Want to replace your costly CRM software?  
:: Super Controller Guide  - now emailed to you!     
:: Pay Plan Wizard- now emailed to you! 
:: Power R+R ERALink - now emailed to you! 
:: Super Controller II - Expense and Employee Guide
:: Power ADP Reflection - now emailed to you! 
:: Advanced ADP Reflection Programming- now emailed to you! 
:: Back Issues of Profit Retention Newsletter - new price!
:: Safeguards Rule Training - now emailed to you! 
:: Profit Retention Newsletter
:: Ultimate Campaign/CRM/BDC Guide- now emailed to you! 
:: Print the Order Form
:: DMS Decision White Paper $199  - now emailed to you! 

Super Controller II - Employees and Expenses

I learned so much from the first guide that I ordered two more. The knowledge in your books surpasses any class I've ever taken. Thanks again for doing what you do...helping others do their job better." Michelle Clemens McMahon Ford

Expenses and Employees are the toughest challenges of a Super Controller. Learn Sandi’s “item Expense” method of tackling expenses. Hundreds of ideas on how to reduce every expense in the dealership! What about employees? How many people do you need in your accounting office. How can make them more productive? This guide helps you with job descriptions (for the whole dealership too!) Bonus plans for accounting office, reviews, and staffing guidelines.  This 101 page guide in Word (emailed to you) also includes the related files containing forms, spreadsheets and job descriptions. You learn to use Sandi's Item method to reduce expenses.  Written by former controller, Sandi Jerome (editor of Digital Dealer magazine) contains detailed information on how to

In the Expense Control section you’ll learn how to;

?	Use technology like Excel to find out how much is being charged to an account
?	Use my “item” method of attacking expenses
?	Decide what should be in each account and create a metric 
?	Make a plan and budget to reduce expenses.

In the Employee section you’ll learn how to;

?	Create job descriptions using the samples I’ve included
?	Develop pay plans that work
?	Use tools like reviews and bonuses to get the results you want
?	Determine the staffing of your office or centralized accounting department

Click HERE to view contents

Our Price: $495 USD
Buy with Super Controller I, the PRN Newsletter and Save!
Our Price: $990.00 USD
Buy with PRN Newsletter and Save! Our Price: $590 USD
Buy Super Controller II with the PRN Newsletter and Pay Plan Wizard and Save!
Our Price: $740.00 USD
Power EraLink with Super Controller II, Pay Plan Wizard, Newsletter and Save!
Our Price: $1095 USD
Power EraLink with Super Controller II, Newsletter and Save!
Our Price: $930 USD
Power ADP Reflection with Super Controller II, Newsletter and Save!
Our Price: $930 USD
Power ADP Ref with Super Controller II, Pay Plan Wizard, Newsletter and Save!
Our Price: $1095 USD

Super Controller Guide I

I learned so much from the first book that I ordered two more. The knowledge in your guides surpasses any class I've ever taken. Thanks again for doing what you do...helping others do their job better." Michelle Clemens McMahon Ford

Do you want to switch from being a “bean counter” to a “Super Controller", Office Manager, or CFO?

This 116 page Word guide (emailed to you) and emailed Excel files lets you learn step-by-step on how to do things - like measure technician productivity, reconcile parts inventory and find shortages, create benchmarks, understand the sales department and for the accounting office - ways to make your job easier - how to reconcile floor plan, close the books in 3 days, calculate days supply of used vehicles - and so much more! This total reference book - written by former controller, Sandi Jerome (editor of Digital Dealer magazine) contains detailed information on how to control, manage and understand:

  • Sales Department
  • Service Department
  • Parts Department
  • Accounting Office
  • DMS Computer System

New to the industry? Are you a CFO of a dealership group? Use this reference as part of your training program, policy manual - even cut and paste sections to make super memos! The reference is in a Word document - so you can update and add to it - a must for dealerships.

Click HERE to view contents.

Our Price: $395 USD
Buy with the PRN Newsletter and Save!
Our Price: $490.00 USD
Buy Super Controller with the PRN Newsletter and Pay Plan Wizard and Save!
Our Price: $640.00 USD
Power EraLink with Super Controller, Pay Plan Wizard, Newsletter and Save!
Our Price: $995 USD
Power EraLink with Super Controller, Newsletter and Save!
Our Price: $830 USD
Power ADP Reflection with Super Controller, Newsletter and Save!
Our Price: $830 USD
Power ADP Ref with Super Controller, Pay Plan Wizard, Newsletter and Save!
Our Price: $995 USD
 

Pay Plan Wizard

Uses Excel and YOUR objectives to develop a pay plan that works! Decide how much to pay in Salary, Commissions, and Bonus based on how much weight you put on the employee reaching your objectives. Comes loaded with actual suggestions for each employee based on our study of existing pay plans. After you use the Wizard to create your pay plan, it flows into a worksheet for your employee to have and forecast their pay each month. Use the Wizard to make bonus payroll a snap! Includes pay plans for GM, GSM, Sales mgr, BDC, salespeople, Internet, F&I, Service mgr, Advisors, Body Shop mgr., Parts mgr, Parts counter, Warranty

Click HERE to view a case study and Contents.

Pay Plan Wizard contains over 30 Pay Plan Spreadsheets! Emailed to you!

Our Price: $250 USD
Buy with the PRN Newsletter and Save!
Our Price: $345.00 USD
Buy Super Controller with the PRN Newsletter and Pay Plan Wizard and Save!
Our Price: $640.00 USD
Power EraLink with Super Controller, Pay Plan Wizard, Newsletter and Save!
Our Price: $995 USD
Power ADP Ref with Super Controller, Pay Plan Wizard, Newsletter and Save!
Our Price: $995 USD

 

Power R+R ERALink

The ultimate training guide written in Word and emailed to you to help you learn ERALink - over 75 pages of step-by- step instructions. The Queries that you need to run to get the data you need - and how to run them (over 15 included in the email-create over 100 reports!) Instructions on how to bring the information into Excel, and sample spreadsheets (included in the email). Learn the advanced features of Excel like AutoFilter, Pivot tables and Vlookup. Includes the step-by-step Automated Bank Reconciliation and sample spreadsheet! Find the "Why" instead of the "What" with Sandi's Power Tips!

"I just wanted to tell you that I absolutely LOVE the information in the Power R&R ERAlink for Dealership Management. I've only gone through the new vehicle inventory reports and was in awe! What a great tool! I was so excited I immediately forwarded the information to the GM, NC sales manager and the ordering department."  Michelle Clemens - McMahon Ford

Click HERE to view contents.

Our Price: $495 USD
Buy Power EraLink with the PRN Newsletter and Save!
Our Price: $590.00 USD
Power EraLink with Super Controller, Pay Plan Wizard, Newsletter and Save!
Our Price: $995 USD

 

Power ADP Reflection

I learned so much from the first book that I ordered two more. The knowledge in your guide surpasses any class I've ever taken. Thanks again for doing what you do...helping others do their job better." Michelle Clemens McMahon Ford

The ultimate training guide to help you learn ADP's Reflection - over 75 pages in a Word file of step-by-step instructions.

  • The Macros and Queries that you need to run to get the data you need—and how to run them (over 15 included in the email - create over 100 reports!)
  • Instructions on how to bring the information into Excel, and sample spreadsheets (included in the email).
  • Learn the advanced features of Excel like AutoFilter, Pivot tables and Vlookup.
  • Includes the step-by-step Automated Bank Reconciliation and sample spreadsheet!
  • Find the “Why” instead of the “What” with Sandi’s Power Tips!

Click HERE to view contents.

Our Price: $495 USD
Buy Power ADP Ref with the PRN Newsletter and Save!
Our Price: $590.00 USD
Power ADP Ref with Super Controller, Pay Plan Wizard, Newsletter and Save!
Our Price: $995 USD

Advanced ADP Reflection Programming

With an Excel DOC workbook on CD - Take your Reflection skills to the next level!

Learn how to use the programming capabilities of Reflection to create powerful and professional applications. Advanced Reflection Programming teaches you the basics of VBA, the language used in Reflection and Excel. Using real-life examples, you'll see how you can automate much of your workload, guarantee correct data entry, pull data for your own custom reports, and work hand-in-hand with Excel.

You'll learn:
  • How Reflection VBA can be used to eliminate repetitive tasks
  • How to go beyond simple macro recording and take full control of Reflection
  • How to harness Reflection to create programs that make your life easier
Also included: the Excel DOC workbook, a fully-functional spreadsheet you
can use to present a snapshot of your dealership's performance during the
month, complete with interactive, at-a-glance charts and graphs that show
each department's and total dealership's numbers compared to prior year
and budget.  Used in conjunction with the Reflection macro also included,
once you've prepared the spreadsheet for your dealership, you'll be able to
present this DOC to your managers in minutes!

See Screenshots

 

Advanced ADP Programming - Our Price: $395 USD

DMS Decision White Paper

Picking a new DMS System?

Are you confused by the choices available today in DMS systems? Do you need to make a quick decision about your GM IDMS contract today? Written by Sandi Jerome while she was the editor of Digital Dealer Magazine, this white paper compares the most popular DMS systems. It includes a decision test to help you decide today whether to stay with your current system or make the leap to an alternative system. The "Big 5 DMS Systems" covered in this White Paper are;

  • Autosoft
  • ASI
  • Arkona
  • Auto/Mate
  • ACS
  • Quorum

Buy now and it will be emailed to you !

Contents of the 20 Page Guide Should you Change DMS Systems? Test #1 - Can you switch systems? Test #2- Are you paying too much? The 5 Top Alternative DMS Systems ACS - Windows Based System Auto/Mate - Stable Unix System Arkona - an ASP Solution ASP or Dealership Server AutoSoft - ASI Quorum - from Canada After the Contract is Signed Appendix A - Full DMS Provider List and pricing Appendix B - DMS Tiers

For those of you who might question whether or not I'm independent after designing DealerStar - I'm not, but I do know these systems and I haven't met another consultant that has spent the time that I have consulting with dealers on these systems. In one month last year, I was on an AutoSoft system helping them use the dispatching and flagging system, then over to an ACS system to help them download to Excel, and finishing up with an office manager during their Arkona installation. I like all these systems and they do the job, so the challenge will be for you to read this guide, see the systems, and pick the one best for you! Buy now and it will be emailed to you !

Our Price: $199 USD

 

Safeguards Rule Training

  • Employee Training for Safeguarding Customer Data
  • Advanced Manager and IT Training to prepare your dealership for the Safeguards Rule

One of the elements of the Safeguards Rule is to provide training for your employees on how to protect Customer Data - Avoid $11,000 per day fines!

Included in your emailed files:

  • What is the Safeguards Rule?
  • What data must be protected: Examples
  • Why Customer Data must be protected
  • Protecting your system from the Internet
  • Viruses, Firewalls, Passwords
  • Working with Service providers
  • Performing a dealership checkup
  • Plus: Specific Jobs you Need to Run on ADP, R+R, EDS and UCS Systems

Click HERE to view contents.

Our Price: $995 USD
More Info

 

Sandi Jerome's  Profit Retention Newsletter

Written by former controller, CFO, office manager, F&I manager, fixed ops manager and assistant GM, Sandi Jerome, this newsletter gives you ways to retain your profit and increase your sales.

A quality profit building newsletter, with a focus on Automotive Dealership Technology, Customer Retention, Marketing, Profit Retention and Business Development.  Emailed in a PDF file that can be forwarded to other personnel in your dealership monthly, this newsletter is for:

  • Dealers
  • General Managers, GSM, Sales Managers
  • Controllers and Office Managers
  • BDC departments - Customer Service Managers
  • IT managers and System Administrators
  • Internet managers and Marketing Directors

In each issue, you will find:

  • How to Create a Marketing Campaign
  • BDC and CRM Quick ideas
  • Techno Tips
  • Ways to Reduce your Computer Expenses
  • Time Savers
12 Issues - 1 Year
Our Price: $195 USD
Buy 2 years and Save!
Our Price: $350 USD
Buy 3 years and Save!
Our Price: $495 USD
Renew - For current subscribers
Our Price: $195 USD
Back Issues - Almost 4 years worth in a binder
Our Price: $295 USD

 

Back Issues of Sandi's Profit Retention Newsletter

Download Contents of the Back Issues – Special Offer $295 - 4 years in a binder, over 200 articles with BDC/CRM ideas, controller training, and hundreds of ways to save money!  Limited quantity available – first come, first served! Hint: search on “Saving”

  Back Issues - Almost 4 years worth in a binder Our Price: $295 USD

View contents

back to top

 

Cash for Clunkers Database  of Qualifying Vehicles

Are you ready to get the jump on finding the "clunkers" in your customer database?  This Excel file hasover 8,000 vehicles identified as potential clunkers. 

$499 - for the "do it yourself" techie. Download the sample database and instructions and see if you can do this yourself (advanced level)  Order now, it will be emailed to you.  This doesn't include YOUR customers, rather the extensive list of qualifying vehicles for you to match to your database.  If you buy the database and can't do it, we'll apply the price to one of the "we "do it for you packages below.

Click HERE download sample database and instructions

Cash for Clunkers DMS Database Matching Services

 $799 - you email us your DMS database and we'll send you back the ones that qualify and their MPG.  This price is good for up to 20,000 records in your database (you might want to only grab 3-5 years of recent service history to save money)  Download the sample file above to see the fields we need.  Contact  Chip King at clunkerlist@yahoo.com  for help, or by phone at 860-777-5471.

Bigger Databases

 $1099 - 20001 - 40,000 records

 $1599 - 40001 - 75,000 records

 $1999 - 75001 - 100,000 records

 $2599 - 100001 - 150,000 records

Over 150,000 records - or for more info, email Chip King at clunkerlist@yahoo.com. King is also available by phone at 860-777-5471.

 

 

Ultimate Campaign/CRM Guide

This Ultimate Campaign/CRM Guide comes with over 25 campaigns ready for you to create – that’s over two years worth of monthly campaigns to help you sell more cars and service them. This step-by-step guide created in Word and emailed to you with instructions and worksheets helps you use your existing DMS system or your CRM software to increase sales today. Using the 5 step process, you’ll find the best products to sell, how to contact your customers, and measure your results. This is a perfect project for your Internet, Inventory, CSI, BDC, or CRM manager. 50% off for owners of CRS or Data Miner! Campaign Software. $100 off for subscribers to Sandi Jerome’s Profit Retention Newsletter.  

 View Contents

Buy the Ultimate Campaign Guide with the Pay Plan Wizard and Save!
Our Price: $745.00 USD
Ultimate Campaign Guide Only- Our Price: $595.00 USD
Buy the Ultimate Campaign Guide with the PRN Newsletter and Save!
Our Price: $690.00 USD
For Existing PRN Subscribers Only: $495.00 USD
Consulting Services - 1/2 day Price: $1375.00 USD
 
   

 

 

Data Miner - Campaign Software

Do you really need CRM software?  Are you tired of having 2-3 databases?  Data Miner uses your ADP/R+R/UCS database and puts it in Microsoft Access (requires Microsoft Access 2003 or 2007) and enables you to do mail merge letters, automated emails, call sheets for sales people, labels, and more! When you order, make sure you specify in the PayPal notes the ADP or R+R - or the generic version to be used with ACS, Auto/Mate, ADAM, Arkona, UCS, EDS (ADP ARG) etc.  The ADP and R+R versions come with the query/macro instructions to run your data files.  The other versions have the empty csv files for you to populate with an extraction from your DMS system.  If you have one these other systems and can provide us with remote access to your data files, we can create your interface for the Data Miner Customization price below.

 View Manual

Data Miner
Our Price: $995.00 USD
PRN current subscribers only- Our Price: $895.00 USD
Data Miner Customization $1250 USD (current owners only) - order form below
Data Miner for other DMS systems (requires customization) Price $2245

Download Data Miner Order and Customization form

 

Super Excel for Dealerships

Want to learn Excel 2007 fast but don't have time to take night classes or online tutorials?  This guide has almost 150 pages of dealership specific examples, tutorials, and lessons for all levels of Excel users - from beginner to advanced - using data from your DMS system. Along the way, we’ll be covering some topics that will hopefully enlighten you as to some of the capabilities of Excel including Super Formulas -- handy formulas such as OFFSET and multiple-condition AND/OR statements, how to use arrays in formulas, quick little tips on Excel shortcuts, and more.  It includes Super workbooks like;

  • Gross Book Analysis. This workbook will use information from a gross book report file and allow the end-user to view and analyze the performance of the salespeople. We’ll also begin building a salesperson commission workbook which will allow us to enter our commission information in an efficient way by building a workbook with a good foundation and flexibility

  • Excel and Outlook Sales Commission- a two-part application, where Excel creates workbooks on its own based on a master workbook. We’ll be continuing with our commission workbook and adding some code to it. A simple Outlook macro then takes those newly created spreadsheets and emails them to the designated recipients.   What a time-saver!!!

Included is an Excel 2007 simple tutorial that includes a Pivot Table and the AutoFilter with the instructions for both 97-2003 and the new Excel 2007. This enables those of you who are still using the older Excel to have a tutorial, but those of you who are struggling with Excel 2007 – to have “quick start” method to convert to the newer version.

Need to extract from a DMS system? Contains information on getting data out of ADP’s new Web Suite 2007, websuite 1000 (Alliance,) ARG (former EDS,) Arkona, ACS, Auto/Mate, DPC, Dubuque, R+R Eralink, and R+R Power (UCS). There are two versions; a PDF file (eBook) to read on screen and the files that are zipped and emailed (you need to be able to receive a 7MB file) and the regular printed copy and CD containing the files and eBook pdf file.  Works with Excel 97-2003 and the new 2007 Excel.

 View Contents             See Screenshots

 

Super Excel - eBook (pdf), files emailed
Our Price: $295.00 USD
PRN current subscribers only, eBook (pdf) files emailed- Our Price: $245.00 USD
Super Excel - Printed book and CD - shipped to you
Our Price: $395.00 USD
PRN current subscribers only Printed Book & CD- Our Price: $345.00 USD