Jack Roffel & Associates    
"Software Designed With Rebuilders in Mind"
   
   <%=Session("UserName")%>  
dot
dot dot
dot
dot  
Home
Shop Trac
IMS/ACTR/ACTP
Online Price Lists
Internet
Links
Privacy Policy
Login/Logout
Change Password
Change Profile
Shop Trac Introduction

Shop Trac is as the name suggests a software package designed to keep "Trac of your Shop". It has been designed specifically for the rebuilding industry. There are actually 2 distinct versions of Shop Trac, one for the "Diesel Injection" rebuilders, and another for the "Automotive Electric" rebuilders. They share most features, but each also has features that are peculiar to the business it was designed for.

Shop Trac is written in C and Assembler. All file and record indexing is done in real time using a b-tree type of index. This enables any record to be retrieved in a split second, and eliminates the need to constantly rebuild file indexes. Shop Trac is available as a single user program, or as a multi-user program for most popular network operating systems.

Shop Trac includes 4 main modules: General Ledger, Accounts Receivable, Accounts Payable and Inventory. Each of these is available separately, although they have been designed to operate as an integrated unit. Shop Trac also includes some additional sub-modules, again all designed to make your job more enjoyable and easier. All features are accessed via a single pull down menu system. It is impossible to highlight all of the features available with Shop Trac in a simple introduction such as this. What is included here however should provide a basic idea of what Shop Trac can do for you and your company.

General Ledger

The Shop Trac General Ledger is a simple, but effective system.
bulletDouble Entry: Shop Trac accounting modules use the "Double Entry" posting system. This makes out of balance situations impossible and acts as a check-sum to trap operator entry errors.
bulletAudit Trail: All Shop Trac accounting modules maintain a complete audit trail. For the General Ledger this means that the audit trail can be traced by GL Number, by Date or even by both.
bulletHistorical Data: All accounting history is maintained on-line and is limited only by disk space.
bulletAccounting Cycles: With Shop Trac it is possible to start a new accounting period, or even a new accounting year without closing out the previous period or year. This can be a real bonus when a new accounting period or year has started, but all data to complete the previous period or year is not yet available.
bulletReports: The General Ledger module produces all expected reports, including General Journal, GL Account List, Trial Balance, Balance Sheet, Income Statement and GL Activity.
bulletIntegration: All accounting entries made anywhere else in Shop Trac are automatically posted to the General Ledger. Shop Trac works in real time meaning the moment a transaction is entered and/or created all affected data files are updated.

Accounts Receivable

The Shop Trac Accounts Receivable includes all Repair Order, Invoicing as well as all other Receivable functions.
bulletDouble Entry: Shop Trac accounting modules use the "Double Entry" posting system. This makes out of balance situations impossible and acts as a check-sum to trap operator entry errors.
bulletAudit Trail: All Shop Trac accounting modules maintain a complete audit trail. For the Receivable module this means that the audit trail can be traced by Customer Number, by Date or even by both.
bulletHistorical Data: All accounting history is maintained on-line and is limited only by disk space.
bulletReports: The Receivable module produces all expected reports, including Aging Summary, Aging Detail., Receivable Journal, Open Document Journal, Current and/or Previous Year(s) History.
bulletLabour Tracking: Shop Trac maintains a database of employees, and accumulates the hours of 'billable' time produced by each employee.
bulletRepair Orders: The Repair Order option is used to create a repair order (work order) when a job arrives at your shop. A number is assigned to this job, and this number is used to access this order for the purpose of adding inventory items as well as other charges. When the job is complete, the resulting invoice uses the data from the repair order, thus eliminating a lot of data entry. An estimate can be produced from a repair order at the press of a key! Repair orders can also include a user defined message, and are printed on user defined forms.
bulletInvoicing: The Invoicing option can either create an invoice from scratch, or use an existing repair order as a basis for an invoice. This option updates all affected data files, as well as transferring the invoice amounts to the Receivable database. An estimate can be produced from an invoice at the press of a key. The invoice can include a user defined message, and is printed on user defined forms.
bulletStatements: Statements can be printed at any time. They include user defined messages as well as system generated service charges. The print format of the statement is user defined.
bulletService Charges: Service charges for past due accounts can be applied automatically based on a user defined percentage rate, as well as a user defined minimum charge. Service charges are applied only to selected accounts.
bulletLabel Printing: User defined labels can be printed using the data provided in the customer database.

Accounts Payable

The Shop Trac Accounts Payable module includes all payable and purchasing functions.
bulletDouble Entry: Shop Trac accounting modules use the "Double Entry" posting system. This makes out of balance situations impossible and acts as a check-sum to trap operator entry errors.
bulletAudit Trail: All Shop Trac accounting modules maintain a complete audit trail. For the Payable module this means that the audit trail can be traced by Vendor Number, by Date or even by both.
bulletHistorical Data: All accounting history is maintained on-line and is limited only by disk space.
bulletReports: The Payable produces all expected reports, including Aging Summary, Aging Detail., Payable Journal, Open Document Journal, Current and/or Previous Year(s) History.
bulletPurchase Orders: This option is used to produce purchase orders. Order points can be either user supplied, or supplied by a "Suggested Order" routine. Orders, back orders and core values are maintained automatically. The purchase order can include a user defined message, and the actual print format of is defined by the user.
bulletCore Returns: The Purchase Order option also functions as a method of generating a parts and/or core return. This will update inventory levels as well as the outstanding core database. As with the purchase order, the print format is user defined.
bulletStatements: Payables statements can be produced at any time. These can include a user defined message. The statement form is user defined.
bulletCheques: Shop Trac supports both a cheque or voucher system. This allows you to use any existing forms, or if you prefer to print a voucher and hand write your cheques. Both the cheque and voucher form are user defined.
bulletLabel Printing: User defined labels can be printed using the data provided in the vendor database.

Inventory

The Inventory module is the heart of the Shop Trac system. It includes all features you would expect in a full featured inventory system, as well as many features that are unique to the rebuilding industry.
bulletCore Control: Cores are probably one of the biggest problems faced by rebuilders. Shop Trac keeps 'trac' of the cores your customers owe you, as well as the cores that you owe to your vendors. It is also possible to maintain a core bank for any of your customers.
bulletMultiple Price/Discount Levels: With 3 selling price levels, and almost unlimited discount levels Shop Trac can insure you that your pricing to a specified customer is consistent, and still provides you with adequate margins on ALL items.
bulletMultiple Purchase Points: Each part number can be assigned multiple purchase points. A suggested order report will flag these items, and advise if they are available elsewhere, or at a better price.
bulletSupersessions: All supersessions are maintained right in the inventory database. If a number is keyed in that has been superseded it is automatically updated for you.
bulletSales History: Shop Trac maintains sales history for the last 12 months, and the last 4 years. In addition a user specified number of sales for each part number is also maintained in greater detail.
bulletPurchase History: Shop Trac maintains a user specified number of purchases for each part number in detail.
bulletLost Sales: If you lose a sale because you could not supply a specific inventory item, Shop Trac will keep 'trac' of this for you. This data will be a great help when deciding what inventory you should keep in stock.
bulletLost Purchases: If a vendor cannot supply an item when you need it, Shop Trac will keep 'trac' of this information.
bulletIn House Rebuilds: Next to cores, this is probably another headache that rebuilders have to cope with. The Shop Trac Assembly routine will process your in house rebuilds for you. Parts used in the build are removed from inventory, and the item being built is added to inventory. The cost price is adjusted to reflect the part and labour inputs.
bulletIntegrated Kits: An integrated kit allows you to invoice a single part number, but have the Shop Trac system update any quantity of part numbers. This allows you to invoice related items as a kit, yet stock them as individual pieces. This not only eliminates a lot of data entry at invoice time, but also reduces user error due to missed items in lengthy lists of parts.
bulletQuick Quote: Shop Trac removes the headaches associated with quoting customers. Simply keying in the customer number and the part number will give all pricing information as it applies to the prices and discounts offered to this customer. The quote routines also show if inventory is available as well as any additional core charges. Quotes can be saved, to eliminate any questions at a later date.
bulletPrice Changes: Price changes are simple, and can be done from either an on-line price list, a vendor supplied price disk, or by applying a formula to existing prices. Options are available to change any or all prices maintained by the Shop Trac system.
bulletLabel Printing: User defined labels can be printed using the data provided in the inventory database.

Other Sub-Modules

Shop Trac also includes some additional sub-modules: These are optional modules that are accessed via one of the main modules. These include Job History, On-Line Price Lists, Contact Manager, Application Database, Breakdowns Database and a Cross Reference Database.

Job History

Shop Trac maintains a database of job history by serial number. When an invoice (or an in-house rebuild) is processed by the system, a summary of this transaction is added to the job history database. If this item is ever returned for service, a simple scan by serial number can provide all job history.

On-Line Price Lists

If your suppliers can provide you with a price list on diskette, this price list can be loaded into Shop Trac and then be available at all times. Looking up a price from an on-line price list is as simple as pressing a single key. We have agreements with some suppliers (Shop Trac ships with some price lists already included providing you are authorized for the product included in a price list) to include and/or provide their price lists to our users.

Shop Trac also includes and import/export feature so that users with multiple branches can share their data files for purposes of checking prices and availability.

Contacts

This module (actually part of the customer/vendor database) can be used to keep 'trac' of sales calls, phone calls etc. It allows you to keep an electronic notebook on your activities with a contact. Fields for "Next Call" and "Last Call" dates help to insure that you never miss a promised phone call and/or visit. This is information that most managers want to keep, but never had a place where they could keep 'trac' of it ... with Shop Trac you do!

Applications

Our customers have requested a way to keep 'trac' of application data. It seems that they may receive this information from a supplier when looking for an item, but it seems to be a problem to keep this information in a form where it can be retrieved when needed. This simple database allows you to specify application data such as 'Year, Make and Model' and then add to this information the part numbers of any components used on this application. When the time comes that this information is again needed you know where to look ...in Shop Trac of course!

Breakdowns

This database maintains parts breakdowns. Information included is an assembly number and a description, as well as the individual numbers, quantities and descriptions that make up that assembly.

Cross Reference

The cross reference module is used to keep 'trac' of part number cross references. This could include substitutions between manufactures, as well as aftermarket replacement items. Our diesel injection customers use (among other things) this for injection nozzle cross references between manufactures.

Common Features

Shop Trac includes many other features that are not part of any module, but do help to make your job all the easier.
bulletIndexing: Shop Trac utilizes the Btrieve database engine, the long standing king of database management. All indexes are maintained in real time, but not noticeable to the user. Any record, regardless of file size can be retrieved with the absolute minimum in disk access in a fraction of a second. Database integrity between files is maintained via transaction processing. If the update to one file fails for whatever reason, all other files in this transaction will also remain unchanged.
bulletUser Fields: Many of the Shop Trac data files include user defined fields. In some cases these fields are also included as a key index. For example the 'Master Inventory' database includes 2 fields that can be user defined. One of these fields can be used as a search key when scanning the database looking for a particular record.
bulletHelp: Shop Trac includes on-line case sensitive help for almost every data entry prompt. This helps to eliminate screen clutter, but when needed it is there at the press of a key.
bulletCustomer/Vendor Phone Book: Both of these are available anywhere at the press of a few keys.
bulletCheck Stock: You can check stock on an inventory item, again from almost anywhere within the Shop Trac system.
bulletNotes: Shop Trac uses a 'Note' feature where you can attach a free form note to almost any record in any data file. A user notepad (unique for each user name) is also available at the press of a key. We hope that this will eliminate all the 'post-it' notes we always see stuck to computer monitors. Shop Trac also includes a user 'Help File' where you can add your own help instructions. Last but not least is a 'Comment' note file. This file is used to leave comments and suggestions to us! We do not want to have any cases where a good idea has been lost because it was never was written down!
bulletPop-Up Functions: Shop Trac includes a 'Pop-up Calculator' and a 'Pop-up Calendar', and again these are accessible from almost anywhere within the system.
bulletMacros: A built in macro editor can be used to assign a key or key sequence to repetitive tasks and phrases.
bulletExternal Programs: Shop Trac includes built in support for other software that you may also be using on a regular basis. Our diesel injection customers use it to access parts and service information on CD ROM, while our automotive electric customers use it to access parts and application databases. This allows you to access these types of programs without leaving the Shop Trac system.
bulletPrinting: Shop Trac includes its own "Printer Definition" files. This makes it compatible with almost any printer on the market, as well as capable supporting multiple printers, even if they are different. Output for all printed reports can be directed to either a printer, a disk file or to the console screen. Shop Trac printer routines are compatible with most major network operating systems.
bulletUser Forms: Shop Trac supports almost any pre-printed form since all printer output that is directed to these forms is user defined. This allows you to make changes to the way a form prints without having to change any actual program code.
bulletSecurity: System security is controlled by passwords and different access levels. One user with 'Supervisor' rights controls other users and the modules that they have access to.

Supported Environments

Shop Trac is designed to take maximum advantage of your hardware. Shop Trac runs fine on a Pentium class computer.

Shop Trac has been tested with all current Windows 95/98/Me/XP configurations.

Minimum System Requirements

bulletPentium processor with 64MB RAM
bulletWindows 95 or higher
bulletApproximately 60M of hard drive space
bulletCD drive

 
Introduction
Downloads
Price Lists
Whats New 01/2005
Whats New 04/2004
Whats New 12/2003
Tech Tips
Tips & Traps
FAQ
Bugs
Latest Beta
Bug Report

Web Site News! 

This box will always give you the latest news about changes to this site.

The Shop Trac FAQ has been updated!

New Shop Trac  Tech Tips, including the changes for the Canadian July 2010 HST rate changes.

Many new 2010 price lists have been posted.

The latest Shop Trac Update is dated 01/10/2007.  The latest (and final)  IMS/ACTR/ACTP Update is dated 11/30/2003.

  dot
dot
dot Copyright © 2002 by Jack Roffel & Associates   
9101 MCDowell Line   
Chatham, Ontaro.  Canada   
Phone:  519-351-7083  Fax:  519-351-7571   
Email: jroffel@jra.on.ca