USER MANUAL
FOR
WORKSHOP MANAGER
Accounting, Management and Promotional Tools
for the
Automotive Repair Workshop
For Help or other Product Information contact:
Creative Accounts Management Systems: Ph (03) 9727 4566
Fax (03) 9727 4568
Freecall 1800 246 700
Email address
cams@camsoft.com.auProduction Date 20/11/97 3:53
Installation
*Program Fundamentals
*On-screen Help
*Pop-up features using Function Keys
*Software Support
*Software Disclaimer
*Copyright Notice ©
*Part One - Getting Started
*Part Two - Menus by Function
*B - Cash Sales
*C - Maintenance
*D - Receipts
*E - Journals
*F - Roadworthy
*G - Incomplete Jobs
*H - Sales
*I - Letters
*J - Analysis
*K - Customers
*L - All Transactions
*M - Aged Balance
*N - Statements
*O - Banking Report
*P - Post to GL
*Q - End of Period
*Suppliers Menu
*A - Maintenance
*B - Payments
*C - Journals
*D - Standing Transactions
*E - Suppliers
*F - All Transactions
*G - All Payments
*H - Aged Balance
*I - Statements
*J - Post to GL
*K - End of Period
*Parts Menu
*A - Maintenance
*B - Groups File Maintenance
*C - Kits File Maintenance
*D - Delete Group
*E - Tax Rate Change
*F - Price Update
*G - Reports
*H - Import Parts Disk
*I - Export Parts Disk
*J - Discount Codes
*K - Post to GL
*L - End of Month Processing
*General Ledger Menu
*A - Maintenance
*B - Journal Entries
*C - Transactions by Code
*D - Transactions by Date
*E - Profit and Loss
*F - Trial Balance
*G - Balance Sheet
*H - Bank Reconciliation
*I - Post to General Ledger
*J - End of Period Processing
*Utilities Menu
*A - Reindex Files
*B - Postcodes
*C - Mechanics
*D - Services
*E - Company Setup
*F - History Clear
*G - Tax Report
*H - Modify Codes
*I - Passwords
*J - Comments
*K - Payment Types
*L - Printers
*M - Car Yard Import
*N - User Access
*Help Menu
*Register Program
*Registration Info
*Help On Workshop Manager
*Update Information
*Tip For The Day
*Software Disclaimer
*About
*Exit Menu
*Exit Workshop Manager
*Change User Logon
*WORKUTIL
*Part Three - Appendices
*Common Error Messages and how to fix them
*Modify Files
*Support - Rates and Charges
*Software Upgrades
*Y2K - Year 2000 Bug
*Part 4 - Tips and Tricks
*Program Fundamentals 6
On-screen Help 7
Pop-up features using Function Keys 7
Software Support 7
Software Disclaimer 8
Copyright Notice © 8
Part One - Getting Started 9
Part Two - Menus by Function 15
B - Cash Sales 32
C - Maintenance 33
D - Receipts 35
E - Journals 37
F - Roadworthy 39
G - Incomplete Jobs 41
H - Sales 42
I - Letters 44
J - Analysis 46
K - Customers 47
L - All Transactions 48
M - Aged Balance 50
N - Statements 51
O - Banking Report 53
P - Post to GL 55
Q - End of Period 56
Suppliers Menu 58
A - Maintenance 59
B - Payments 64
C - Journals 64
D - Standing Transactions 64
E - Suppliers 64
F - All Transactions 64
G - All Payments 64
H - Aged Balance 64
I - Statements 64
J - Post to GL 64
K - End of Period 64
Parts Menu 64
A - Maintenance 64
B - Groups File Maintenance 64
C - Kits File Maintenance 64
D - Delete Group 64
E - Tax Rate Change 64
F - Price Update 64
G - Reports 64
H - Import Parts Disk 64
I - Export Parts Disk 64
J - Discount Codes 64
K - Post to GL 64
L - End of Month Processing 64
General Ledger Menu 64
A - Maintenance 64
B - Journal Entries 64
C - Transactions by Code 64
D - Transactions by Date 64
E - Profit and Loss 64
F - Trial Balance 64
G - Balance Sheet 64
H - Bank Reconciliation 64
I - Post to General Ledger 64
J - End of Period Processing 64
Utilities Menu 64
A - Reindex Files 64
B - Postcodes 64
C - Mechanics 64
D - Services 64
E - Company Setup 64
F - History Clear 64
G - Tax Report 64
H - Modify Codes 64
I - Passwords 64
J - Comments 64
K - Payment Types 64
L - Printers 64
M - Car Yard Import 64
N - User Access 64
Help Menu 64
Register Program 64
Registration Info 64
Help On Workshop Manager 64
Update Information 64
Tip For The Day 64
Software Disclaimer 64
About 64
Exit Menu 64
Exit Workshop Manager 64
Change User Logon 64
WORKUTIL 64
Part Three - Appendices 64
Common Error Messages and how to fix them 64
Modify Files 64
Support - Rates and Charges 64
Software Upgrades 64
Y2K - Year 2000 Bug 64
Part 4 - Tips and Tricks 64
The software is written, maintained and supported by Creative Accounts Management Systems who can be contacted during business hours on (03) 9727 4566. Further training or support can be arranged by calling C.A.M.S.. A rate sheet for these services appears in Appendices - Support rates and charges.
Please take note of any error messages displayed either on the screen or on the printer and notify us when ringing for assistance. Before calling refer to the Error Message appendix in Part 3 of this manual to see if you can easily solve the problem yourself.
Creative Accounts Management Systems have made every endeavour to produce a high quality, effective and powerful software package to meet the needs of the automotive service industry.
We will make all reasonable efforts to assist registered and prospective customers to set up their computer systems and software in a way that will maximise the benefit available from this package but make the following disclaimers:
No claims as to the functionality or usefulness of the package for any specific purpose are made by Creative Accounts Management Systems or its representatives.
Because of the divergent nature of personal computer systems and the end users, Creative Accounts Management Systems provide no guarantee of performance by way of speed or memory processes but will gladly advise customers on ways of improving or optimising the systems on which the software is installed.
Creative Accounts Management Systems actively promotes safe computer operating and data backup procedures through training courses and this manual. The application of these procedures and the backing up and storage of data disks or tapes will always be the sole responsibility of the user. No consideration will be given to claims against Creative Accounts Management Systems for loss of any kind due to loss or corruption of data for any reason.
Workshop Manager, Workshop Apprentice, Cycle Manager, Wrecker Manager and all associated literature, including this manual, invoices and other documentation are Copyright © to Creative Accounts Management Systems, 1985-1997.
You may use them for your own personal use within your business, but the material is not to be used by others without the express permission of Creative Accounts Management Systems. Such unauthorised use could result in prosecution.
The paragraphs in the next section of this manual will assist you in running your business effectively, and show you how to produce the paperwork required to satisfy your customers, suppliers and accountants!
Once you have learnt how to use the basics of Workshop Manager, you need to set up opening balances for your customers, suppliers, parts and general ledger. Unless the balances are set up before commencing your normal day to day data entry, you will not have a true picture of the current financial position of your business.
To set up a true and accurate picture of your business, the following steps need to be take.
How to Add a Customer or Vehicle or Change Details
New customers or vehicles are added and existing ones changed through Customers - Job Entry. All the details can be changed except the customers code and the registration number of the vehicle, as these are unique "link" codes. If you wish to change them see Utilities - Modify Codes.eg. a customer puts personalised plates on a car that you currently have in the computer, see Utilities - Modify Codes.
How to Add a Supplier or Change Details
New suppliers may be added or the details of existing suppliers may be changed from the Suppliers menu - Maintenance. If you need to change the account code of a supplier (if a supplier changes his business name, for example) you must use the Utilities - Modify Codes menu option.
Stock may be added to your database at four different times; when processing a customer invoice, a supplier invoice, a supplier credit or from the parts menu.
How to Raise a Customer Invoice
The Customers menu -Job Entry - Invoice menu item allows you to enter and print a detailed invoice and automatically updates the customer, and parts files. It also allows the entry of receipts before printing. An open invoice may be maintained for account customers, using Save and Exit. Repairs, parts and comments may be added to it until it is closed using the Finish menu. An open or incomplete invoice can be printed but has * printed on it, indicating the transaction has not been posted to any transaction files.
If an invoice is settled immediately, as for a cash sale, you can process the payment before printing the invoice, and a receipt will appear on the bottom of the invoice when it is printed. If the invoice goes on account, or is paid at a later date, the details can be entered through the Customers - Receipts menu.
The Customers - Aged Balance menu option indicates the outstanding money owed to you by your customers (ie. debtors).
The Suppliers - Aged Balance menu option indicates the outstanding money you owe to your suppliers (ie. creditors).
The Ledger - Trial Balance menu option indicates the health of your accounting procedures. It should normally produce a ZERO result indicating that all transactions have been correctly posted.
The Customers menu - Sales option creates a series of reports for the screen or printer, showing all invoices, receipts and credits for a nominated period, normally the current day. The report shows a gross profit figure for parts and labour, including subtotals. This is the excess potential income after the cost of the materials and labour sold has been subtracted.
The Customers - Statements menu option prints a statement of accounts for each account customer with a non-zero balance. Statements may be sent to all customers with outstanding balances, or selected customers. Statements are normally sent each month, prior to the end of month rollover.
What to do at the End of Each Month
To keep your databases small and easily managed, all transactions (where possible) should be completed and posted to the General Ledger at the end of each month. All invoices should be completed and printed and all sales reports printed. The Aged Balance reports should also be printed.
Once these operations have been completed for the Customers, Suppliers, Parts and Ledger files the Post to GL menu in the Ledger menu should be executed to write all temporary files to the General Ledger, and the Trial Balance report should be printed. The End of Period procedures can be performed. These procedures transfer all completed transactions (paid invoices) to a history file and "age" the Customer, Supplier, Parts and Ledger account balances from current to 30 days and from 30 days to overdue. The monthly sales are reset to zero. A complete list of all daily and monthly procedures is included as an Appendix in Part Three of this manual.
End of Month processing can be done at different times for each of Customers, Suppliers, Parts and Ledger, but don't do any further posting to the Ledger until after they have all been completed. Workshop Manager has a built-in safeguard to stop this from happening.
What to do at the End of the Year
At the end of the financial year the same procedures occur as for the end of month except that the year-to-date figures are also zeroed. All end of month processing for Customers, Suppliers, Parts and Ledger must be completed and no new transaction processing be done until the end of year processing is completed. NOTE: you must perform End of Month procedures FOLLOWED BY End of Year procedures at the end of your financial year.
End of Year processing can be done at different times for Customers, Suppliers, Parts and Ledger, but don't do any further posting to the Ledger until after they have all been completed.
The vehicle details displayed on the Job Entry screen are:
Job Entry SubmenuJob Entry Menu
To add new customers and their vehicles, press A (the first letter of the option Add) or navigate to the Add menu, using the y or z keys. Then press the e key. You will be presented with a blank screen into which you may enter as much, or as little information as you wish. Note that every vehicle must have an Acc Code and Reg. No. All other fields are optional.
Using the Find menu you may also display the customers details by entering the registration of a previously recorded vehicle. This is useful for finding details for a vehicle in the workshop about which you know only the registration number.
When you enter an unidentified code or registration number you will be shown a sorted list of existing customers or registration numbers starting with the nearest match to the data you entered.
You may then select the vehicle or customer using z and pressing e or press v to add a new customer. In this case you return to the data entry screen to create the new customers account code. (If you try to use an existing code the details of the existing customer will be displayed and your only option will be to add a vehicle. You must delete the first customers records before you can reuse an existing code. Please ensure you no longer wish to keep a record of the first customer if you intend deleting their information).
We will enter a new customer. Enter CAMS2 in the Account Code field and press e. If an account code of CAMS2 already exists, the computer will display all the details of this customer and his first vehicle. However, as this is a new customer, the computer will not find the customer and will try to help by giving you a list of the nearest matching customers. You can move up and down in this list to check that the customer is not already on file, and if you dont find him, press v to add the customer. You are given the chance to change the code if it is incorrect, but leave it as CAMS2. You will notice that the customer CAMS already exists. This has all the relevant information for contacting us and is set up on installation.
The Type field is used to group various types of customers, eg.CASH , ACC, or T for trade etc. This field is used in various reports and letters. Type ACC for account and press e.
You are then asked for the customers name. Enter his name exactly as you would write it on a letter, as this is the name that will be used for sending letters and invoices to all customers. Type MR COLIN GILLAM and press e. You can use upper and lower case by turning |l on or off.
The computer will automatically place Colin into the Contact field. Contact is used when sending letters to customers and is the salutation; ie. Dear Colin. If you wish to address the customer differently you can change the contact name ie. he may have a name that everybody knows him by such as Col. Otherwise press e to leave it as is.
If the customer is also a company, enter the company name. Type in CREATIVE ACCOUNTS MANAGEMENT SYS and press e. The full company name is too long to fit so you can abbreviate, you may even wish to type in just CAMS.
Type in the address as 16-18 WINYARD DRIVE and press e.
Next type the suburb as MOOROOLBARK and press e. You will notice the computer pause briefly and then automatically inserts the correct postcode for Mooroolbark. The computer contains almost all postcodes for Australia. If the postcode and suburb are not there, choose the nearest adjacent suburb, and come back later, after adding the one you want from the Utilities Postcodes menu option.
Next enter the customers Work and Home telephone numbers including STD area codes if appropriate. Type 03 9727 4566 press e, and the home phone number if you know it then press e. There is also provision to enter a Mobile Phone Number if required. Same steps as before.
The customer has now been successfully entered and saved.
Now enter a Registration Number for the vehicle. We suggest you enter the actual letters and numbers without "spaces", "-" or any other characters for the sake of consistency, making sure that a vehicle is not accidentally entered 2 or 3 times with slight variations of the Reg. No. Eg. ABC123, ABC-123, ABC 123 are all the same to you, but the computer treats them as 3 unique Reg. Nos. Type ABC123 and press e.
The Vehicle field is used to describe the particular type of vehicle, eg. Commodore, Falcon or Magna and Model is to describe the specific model eg. VL, VN, VK etc. as this is useful when ordering parts. To save some typing, because you know that a Commodore is a Holden, don't put Holden in the Vehicle field, same with a Ford Falcon etc. In the Vehicle field type COMMODORE and press e, then VT and e.
The Body type may be Sedan, Wagon, Coupe etc. Enter SEDAN and e.
Chass/VIN is used to enter the Chassis or vehicle identification number. Type in AIN12345 and press e.
Engine No. is the field used to enter the engine number. Type HGY7657N89 and press e.
Type in RED and press the e key, in the Colour field.
Month/Year is the date of manufacture of the vehicle. Type 0593 and press e.
Cylinders could be 6 and press e.
Capacity is the engine capacity (assume litres, or cubic inches if you prefer). Type 3.8 and then press e.
Letters is the number of reminder letters that have been sent to the owner of this particular vehicle about this vehicle. As this field is automatically updated when you send out service reminder letters leave it blank at this stage by pressing e.
Fuel is the type of fuel the car uses i.e. L for leaded, U for unleaded, G for gas, D for diesel and/or P for petrol. Choose the one you need and press e.
Transmiss(ion) M5 (Manual 5 speed) (Automatic 4 is entered as A4) and press e.
Driver is used when the vehicle is owned by someone other that the person that regularly drives it. This is particularly important in fleet work where the driver of the vehicle is required. On a statement to the account holder this information will be printed so that the customer can reconcile his/her account easily, with identification as to whom made the charge.
Other can be used to store additional brief details on the vehicle or if more space is required, a memo can be added to the vehicle (see further into this tutorial). Type AC (Air conditioning) and press e.
If at any stage you realise that you have made a mistake dont panic. Either use y and z to go back to the incorrect information or you can edit any of the details later as they become available.
* Short Cut - If you have entered all the information you have about the customer and vehicle or are editing the information at a later date, and get to a point where you don't need to add any further information, pressing the ) key will Save and Finish the section you are in.
Always try to gather as much information as possible from your customer as it can be very helpful if you need to contact them or send them promotional material, and always be consistent with the way you enter information.
The computer will automatically save this information and then present you with the full details on the customer and vehicle, and at the bottom of the screen display the available options you can select.
For more information see Customers menu - Job entry or Customers menu - Maintenance.
Credit, Invoice, Jobcard and Quote/Estimate Options
* The 'Invoice' descriptor used above should be read as 'Credit', 'Job' or 'Estimate' if that is the term appropriate to the menu option you are using.
Once you have completed the top part of the screen, the following options will appear across the bottom of the screen:
This option allows you to sell parts, goods and labour on a cash only basis without having to raise an account invoice. I.e. if somebody walks in off the street and you know you will never see them again you can use this option to process the transaction.
It works in much the same way as entering an account invoice, but bypasses the need to enter a customer and vehicle.
The computer still behaves as though you were raising an invoice and uses the next available number, which appears at the top centre of the screen. However, you dont have to enter any of the normal data details, which normally is displayed at the start of the Customer - Job Entry - Invoice screen.
Note: the program automatically creates and maintains an account code called "~~CASH" which holds all the cash sales information. DO NOT DELETE IT if you want to keep records of cash transactions. (Month-to-date, Year-to-date etc.)
Enter an invoice or credit in the same way, as you would do a normal account transaction. I.e. enter all your Labour, Parts and the Finish, Receipt or Save and Exit. Note that you MUST RECEIPT a cash sale invoice at the time of entering therefore eliminating the need to do a separate receipt. You will usually get paid by the customer immediately anyway. If you are not being paid immediately, you should enter the customer and their details into the main Job Entry screen so a separate record of their transaction can be kept.
This is where you can add, edit, and delete customers without doing a job entry. It also shows the customers account balance. When you choose this option the first item you are asked for is the customers account code. If you are unsure of the code, leave it blank and press e, a list of codes will come up for you to choose from. When you have inserted the code, the customer details will come up with options down the bottom.
You may modify customer details from this option and make notes if you wish. The use of most data entry fields is obvious; the following fields require a little more explanation:
Once the customer is displayed on the screen, the following options are available.
This menu option allows you to match receipts to invoices. You may enter individual receipts immediately or enter all the receipts together at the end of the day.
If you don't enter a receipt for your customer at the time of invoicing or if they don't pay in full, you will need to enter their payment details here.
The first thing you will need to do is type in an account code e.g. GILLC and the customers details will be displayed. Change the date if the displayed date is incorrect or accept the date by pressing e. You will notice the Last Payment to the right of Payment Date, which enables you to see when the last payment was made. Enter the amount being paid. Make sure you insert the full total of the invoice/s being paid, including any discounts. Discounts, if you wish to give one, can be given as either a percentage or a dollar amount, use w and x to highlight your choice (it defaults to None) and press e, then the amount of the discount.
You will next be offered a list of payment methods to appear on your banking summary. You must select one by using y and z and press e. These can be predetermined in the Other menu - Payment types option.
Insert the payment details cheque/card number (leave blank if paying cash), bank, etc.
Once youve finished these the programs asks if the details are correct. Highlight Yes to continue or No to change any details.
If you chose Yes, a list will then be displayed of all outstanding invoices for this Customer. To pay off an invoice, tag the invoice(s) you wish to pay by pressing e when the highlight square is adjacent to the correct invoice (a tagged invoice will have a
Ö next to it) to see more invoices use z. The balance left to pay off will appear in the top right hand corner and when this is 0 and you are sure that the invoices tagged are the invoices being paid press ). If you accidentally tag an invoice then highlight the Ö and untag it by pressing e. If the amount of the cheque is smaller than the invoice amount (i.e. a part payment), it reduces the balance outstanding.
You will be asked to confirm if OK to post. Select Yes or No. Yes will adjust all relevant balances and once posted you will be prompted to press } to continue. If you need to print a receipt you can do so now, but make sure you have paper loaded and your printer is on. Next is an option to enter more receipts for this customer. Choose Yes or No accordingly. If you choose Yes you go through the above procedure again. If you choose no then you return to the Entry of Receipts screen to allow you to either enter more receipts for other customers (same procedure described above, i.e. type in their account code etc.) or press v to return to the main customers menu.
Note - Selecting the invoices is useful if you have a dispute with a customer over a particular invoice and only wish to receive payment on agreed items. This form of accounting is known as Open Item as all unpaid invoices remain detailed in the computer until they have been individually receipted or credited.
From time to time you may need to adjust a customers account using a debit or credit journal because of a mistake on your part, on your customers part or as a result of some other circumstances. This menu option provides you with that opportunity. PLEASE USE THIS FEATURE CAREFULLY!
Debit Journals increase the amount the customer owes to you. If a customers cheque bounces after you have entered it as a receipt in the computer, you can do a Debit Journal to increase their account balance by the amount of the cheque. When they pay again and the cheque clears you can then enter a Credit Journal to offset the Debit Journal and balance their account.
Credit Journals reduce the amount the customer owes to you. You would mostly use a Credit Journal to balance a Debit Journal. If you are crediting a customer for returned parts, then you should enter a Credit through Job Entry, as this will adjust the stock levels and the sales figures.
To process a journal entry, choose this option and type in the account code you wish to raise the journal for, i.e.: GILLC and press e.
Next you will need to choose whether a debit or credit journal is required. Simply highlight your choice and press e.
A reference number will appear called the Journal number, press enter over this unless you have a specific reason for changing this number. It is being treated as an invoice so the next available invoice number is the default number chosen.
Type in the date for the journal and press e. The program will default to the current date but can be overridden to allow you to enter the appropriate date.
Next type in the amount that the journal is to be for and press e.
If you want to place a brief comment for this journal type it in the next field and press e or if no comment is required press e.
You will be asked for which age to post the journal to. This allows you to keep your monies owed or owing in the correct ageing. 0=current month. 1=30 days, 2=overdue. Choose which period to age the journal to and press e.
An option of OK to Post appears next. If you have made a mistake or are unsure choose the No option and begin the process again or press v to exit. If you are confident that all the details are correct then choose the Yes option. And the computer will post to all the relevant places and return to the beginning of the customer journal transactions screen allowing you to enter more journals or simply press v to exit to the main menu screen.
This option allows you to record the details of Roadworthy Tests done by your workshop. It does not replace your certificates but provided you keep an up-to-date file of printed copies of your reports this option will replace your RTA register. This is a requirement of the RTA.
The various details are taken direct from the recommended format from the RTA (Vic) and are all self-explanatory.
When you choose this option, you can either call up a vehicle by the roadworthy serial number it has, or by its registration. Once youve found a vehicle you get a display showing the following;
Date of Test Date the test was performed.
Pass/Fail/Withdrawn A simple P, F, or W as to the status of the roadworthy certificate.
Engine No. The engine identification number of the vehicle.
Chassis No. The chassis number of the vehicle.
Customer Address The address of the customer.
Comments Type in a brief comment for the vehicle.
Once all the details have been filled in the options will appear as usual across the bottom of the screen.
This option gives you a list of the incomplete jobs. You can select to display or print the list.
The display/print shows whether or not theyre an invoice or jobcard, their number, code, rego, date and amount.
This report quickly gives you an overview of the health of your business on a day to day basis. By comparing daily reports and end of week reports, you can gauge if you are on your sales targets for the current month. The other major benefit of this report is to ensure that all transactions on a given day have been processed correctly. If an invoice or receipt does not appear on this report, you should check to make sure it has been entered and posted correctly.
This option gives a summary of sales information. You can display or print a report giving you a complete list of all invoices receipts and credits between the two dates you specify.
If all three are left at the default Y then the report will be include all sections but is created as one report.
If you have chosen to include the Transaction report you will then be asked to select the type of transactions to report on. This is useful if you only want a list of all credits processed for a period of time, or receipts or invoices. The option will default to 1, being a list of all types of transactions.
You will next be asked to choose the order for the report to be generated in. With this option you may wish for all the invoices to be listed together, followed by the credits, etc. or to have it listed by the type of customer e.g. Trade, Account, COD etc. The default is the most commonly used and will list the transactions in order that they were done in.
After choosing the type of transaction and the order that you want to display the report you can then set a filter for the range of customers to report on. By default the first customer in alphabetical order will be displayed in the starting account code and the last customer in alphabetical order will be in the ending account code. Unless you want to limit the range of customers to display then simply press e over both these fields. If you want to limit the report to a specific type of customer, you can next select the type but for all customer types leave this field blank.
Next choose whether you want a detailed report listing all the transactions or a summary which simply lists the totals for each section. Choose by selecting either 1 for detailed (default) or 2 for a summary report.
If you have chosen a starting date that is in a month prior to the current month you will be asked to include transactions from a previous month. If you have not done an end of period and want information just for the period that you are working on then select no. If you want information in the report that relates to previous months and you have done an end of period then you will have to choose yes.
After all these choices have been made there is only one more option. Do you want the report to print to the printer or display on the screen? Make your choice and a report will be generated using the options selected above.
From this menu option you may print letters and labels of several types.
The options are:
For all options you are asked if you wish to edit or print.
If you select edit, a list of major services (in the case of Service Due Letters) or letter types (for Customer or General Letters) is displayed from which you choose the one you require. In the case of letters the selected one will be displayed on the screen for you to modify. Use the arrow keys to move around.
When you are finished writing or editing letters, press ) to save it. The old letter will be replaced with the new version. Keep in mind that the customers name, address and vehicle details will automatically print at the top of the letter, so only enter the information you want.
NOTE: When you are writing or editing letters you may use the WordStar commands; that is cF moves the cursor one word to the right, cA a word to the left, p and q move the screen up and down. cT deletes a word to the right and cY deletes the entire line you are on.
If you select print, a list of your major services or letter types is displayed from which you choose the one you require. This selection will relate back to letter file, you may have just edited or created a letter that is relative to the required service. Highlight the desired type and press e.
All options allow an alphabetic range to be specified for customer names and a postcode range to be specified for their business addresses. Type in the range of customers codes you require i.e. this month you may only want to send a letter to half of your customers, A to L, and the second half next month or only customers in a certain suburb. Do this by typing in the postcode you wish to send to in the starting and ending postcodes. If you want to select all customers then press e to move through all the fields.
A report is generated of all customers meeting your requirements. By default, letters will go to all names in the report unless you deselect them. Deselecting is done by pressing the e key, which removes a flag from the name in the list. After deselecting all the customers that you do not wish to receive a letter press v.
In all cases but Overdue Letters you will be offered the following options:
In all cases, once the letters have completed printing and a summary of who the letters went to is required you will be prompted to change the paper and press e to continue. If you press v then you will not get the summary printed and you will return to the main letters screen.
From this menu a series of reports show the activities of your business over a nominated period. The types of activities and mechanics performing the work are shown, as are statistics for each mechanics productivity.
To give an accurate report, all details must be entered correctly at the time of invoicing.
As each month and workshop varies in the number of days actually worked, the first thing you are asked when you choose this option is how many days worked this month? The program will calculate roughly how many days it should be, based on the idea of five working days in a week. You will need to enter the days-worked in total, although the computer estimates this for you.
You are asked to select either Active or All records. Active will report only those records where there has been work done during the current month. This gives a shorter report.
This report gives a comprehensive listing of all service work done during the current month and year to date. It lists all the major services and the percentages of the total workshop income.
This report also lists the mechanics and their individual contributions to the workshop.
This option displays a selected list of customers that may be displayed or printed. By default it will list all customers on file. If you wish, you can select customers by account code (e.g. if the printer ran out of paper after the "R-----" customers, you can restart printing from the "S-----" customers) or in a particular postcode area (e.g. a promotion for a new workshop in an area).
Select display or print, then you are then asked for the account code that you want to start from. By default the program will show the first customer on file.
Next you put in the account code you want to stop at, by default this will show the last customer on file.
Next you insert a starting and finishing postcode. The default will include all postcodes.
You can choose to list the customers for a specific account type, if you want all customers then leave blank.
The order the report prints or displays in can be selected next. Options are 1 for Account order, and 2 to list by customer type.
The program then asks if these details are correct and once you answer this it will display/print a list of the specified customers.
This option is used when you want to display or print the transactions for all your customers in the time period you specify. As you can see (when youve chosen All Transactions), you can choose to view invoices, receipts or credits. Once you chosen one of these options, the steps are the same.
First, choose whether you want to see All, Paid or Unpaid invoices/receipts/credits. Next you put in a starting date and ending date (the default is the current month), and finally, whether you want to print or display the invoices/receipts/credits. The report lists all transactions and then gives a summary of all transactions. If Receipts is selected, a banking summary is also listed.
Lastly you need to choose to display or print the report. If you chose display, the first page will show the transactions. You will be prompted to press any key to continue to display the totals for the selected transactions. A printed report will print this automatically.
The exception to the above is if you wish to find one invoice by its invoice number. In this case, select Invoice, One and then you are prompted to enter the invoice number you are searching for.
At any time this option will display or print all the current, 30-day and overdue amounts for all customers with an outstanding balance. A contact name and phone number is also provided to enable customer follow-up.
If you want to limit the range of customers to a particular type then you can choose the type here or leave blank to display all customers who owe you money.
There may be more information to the right of the screen. Use x to move across the screen to view this information if you chose display.
This menu option allows you to send statements to customers informing them of their transactions for the previous month and identifying any outstanding balances.
You can select to print statements for a range of customers who owe you money, or print individual statements (for people who conveniently lose theirs) by limiting the range of account code starting and finishing with the required code.
You may wish to only print statements for all Trade customers (or any other type of customer). This can be done by choosing the customer type required, or by leaving this field blank for all customer types.
Enter the Statement Date. You are usually sending statements one or two days into the next month, so it is good practice to back date the statements to the end of the previous month.
Current and Unpaid Transactions detail all invoices and receipts, whereas BBF with Current Transactions only shows an opening balance for the current month and the current months transactions.
Transaction summary gives a total of the different transactions at the end of the statement.
When youve selected which statements you are printing, you can also enter comments that will print at the bottom of these statements. This is useful for either promoting a particular service you have or reminding people of their overdue account.
You then get a list of all the customers who match the selection criteria you entered previously. You can then fine tune this list so that only the customers you want to receive statements get printed. Press e to untag or retag customers. Press ) to finish and print.
Before running statements please ensure that your printer is loaded with the correct forms, it is switched on and is on-line.
Press e to continue and v to exit if you are at all unsure.
By choosing this option you are able to generate a report that can act as a deposit summary for your Bank. Note: not all Banks will accept this as a deposit slip so please check with your Bank to confirm this.
Your first option is to choose the date that the receipts are to be banked. Todays date will be the default but it can be overridden if desired.
Your next choice is to display or print the Deposit summary.
If you choose to display be aware that you cannot clear the summary from here. You can only clear the deposits from the print option.
From this stage both display and print have the same options:
A list of receipts will be displayed on the screen. You will need to select which ones are to be banked by tagging or untagging the receipt. Press e to do this.
Once all the receipts are tagged to be banked press ) to continue.
It is at this stage that the print option has some differences: (the display option will show on screen how the report will look when printed and pressing v will return to the main customers menu.
Printing will ask if you want to print two copies. This will be required if you want to keep a stamped copy from the bank.
Next you will be asked if you want an EFTPos summary. Naturally this will only be applicable for those people who take EFTPos as a payment method.
If you are banking cash then a choice to print a cash count summary will be offered. This will print a cash break-up on your deposit slip so you can manually write the break-up of your cash.
Once the deposit summary has been printed you will be asked if you want to clear the receipts. If you say no then the receipts will be on the next deposit summary, and will remain so until you choose to clear them.
Please note: if you are running the General Ledger side of Workshop Manager and intend to use the Bank Reconciliation option then the only way that these receipts will get to the Bank Rec. and General Ledger is to print and clear the Banking Report. They will only get to the Ledger side of the program after Post to GL option is run in both Customers and General Ledger.
This option posts all transactions to a temporary General Ledger file in preparation for updating the General Ledger. It can be run at any time but must be run before updating the General ledger to give an accurate picture of your current business position. It is automatically run when you do an End of Month processing.
Note - to see the results of your work in the General Ledger, you will also need to Post to GL in the General Ledger Menu.
To run this option you will need to choose Yes to continue. If you choose No then you will return to the main menu screen.
If Yes is chosen then a message "Posting Customer Transactions" will flash on the screen and when all the posting is complete a further message will show that it has "Finished Posting Transactions".
Press } to return to the main menu.
Note - If the ageing of the General Ledger has not been completed for the previous period then to remove the accidental posting to GL and inclusion of these figures in the Profit and Loss, a message will appear and you will not be able to post until ageing has been completed.
This option closes all files for the month or year. In order to age customer accounts and to do some basic internal housekeeping, it is necessary to run this process at the end of each month. Ideally, it should be run in conjunction with the Supplier, Parts and General Ledger End of Month processing. The procedure updates the customer files, changes the aged balances from current to 30 days and 30 days to overdue and deletes all completed transactions, i.e. all invoices that have been paid are cleared along with the corresponding payment or credits.
All non-current transactions are shifted into archive files (from which they can be retrieved if necessary); i.e. all fully paid invoices for customers and suppliers and associated transactions.
When you select this option you will be greeted by this warning. If you havent printed all the options simply choose v and you will be returned to the main customer menu screen where you print the reports, do backups and then return to perform the End of Period.
You will be given a warning and will have to consciously choose continue to complete the process. If you choose to continue you will be see the first invoice number and the last invoice number. Current invoice number will be the transaction the computer is working on so you will see it counting up until the last invoice number is reached. The screen will show you that it is processing end of period details by flashing in red. This process may take several minutes, depending on the amount of work done during the period. You can see the stage it is up to by looking at the counter. When finished the program will automatically Reindex your files.
When the process is complete you will be advised and have to press } to continue and return to the main menu.
Refer to the End of Period sheet in the addendum section for all the correct procedures for running and completing an end of period.
Note - If the ageing of the General Ledger has not been completed for the previous period then to remove the accidental running of an End of Period therefore ageing your figures twice, a message will appear and you will not be able to post until ageing has been completed.
End of Year clears all year-to-date figures and must be run separately to the End of Period.
If it is June, July or August, you will automatically be reminded and prompted to do an End of Year. Make sure it is done before commencing to enter any transactions for the new financial year.
This is the suppliers main menu.
It allows you to keep a track of how much you owe to your suppliers. It also allows you to record any cash payments, wages or other expenses incurred by your business. It is basically the same as the customer section except in reverse. You enter all the supplier invoices as you receive them (you can even update your parts at the same time). As with the customers, you can post to the General Ledger and get an overall picture of your business expenses.
This program allows you to set up and maintain Suppliers. You can enter any details you wish to keep handy on your suppliers file.
Once a supplier has been created, you can enter invoices from and payments to this supplier. This will give a more accurate guide as to how your business is running.
This information is also used by the parts file to record where you would normally obtain a part and the normal supplier of that particular part/s.
Supplier Maintenance can be used to check suppliers details at a glance, or, add new suppliers, edit the ones that are already there or delete a supplier, make payments, process credits or simply check the transactions.
The first item you are asked for is an account code (e.g. BURSON). If you know the correct code it is simply a matter of typing it in. If you dont know the code or you misspell it, (you can leave it blank too). A list of suppliers will pop-up when you press e. When this list is up you can press v to add a new supplier or scroll through using y and z until you find the supplier you want. Or type the first couple of letters and press e to go to the nearest match then repeat the process again until you find the supplier you want.
If you press v you will be asked if you want to add a new supplier. If you say Yes, you can enter their details just like selecting Add from the menu bar at the bottom of the screen. Put in their address and phone details (you can even list up to three contacts with office and mobile phone numbers). You are asked to enter the last date you paid this supplier, the default ledger code for this supplier (usually 2001 for Cost of Sales or 5500 for Stock on Hand). Change this if it is to default to a different ledger code but you must have a valid code in this field. You can then set up a percentage mark up to retail on your part costs.
When you have entered all the details for the new supplier you will come to a screen that shows the suppliers details and also a list of options across the bottom. Most of them should be self-explanatory.
This option allows you to enter details of payments made to non account suppliers, or for any other payments such as wages, rent etc.
When you choose this option you are given a selection of payment or expense types.
From time to time you may need to enter a debit or credit journal because of a mistake on your part, on your suppliers part or as a result of some other circumstances. This menu option provides you with that opportunity. PLEASE USE THIS FEATURE CAREFULLY!
This may be necessary if you have overpaid an account accidentally in the computer or wish to reverse a transaction or part thereof for any reason.
To process a journal entry, choose this option and type in the account code you wish to raise the journal for i.e.: BURSON and press e.
Next you will need to choose whether a debit or credit journal is required.
Highlight your choice and press e.
A reference number will need to be allocated, (call this the Journal number), press e.
Type in the date for the journal and press e. The program will default to the current date but can be overridden to allow you to enter the appropriate date.
Next type in the amount that the journal is to be for and press e.
If you want to place a brief comment for this journal type it in the next field and press e or if no comment is required simply press e.
An option of OK to Post appears next. If you have made a mistake or are unsure choose the No option and begin the process again or press v to exit.
If you are confident that all the details are correct then choose the Yes option and the computer will post to all the relevant places and return to the beginning of the customer journal transactions screen allowing you to enter more journals. Or simply press v to exit to the main menu screen.
This option allows you to set up regular payments to post automatically each month, e.g. rent or lease repayments.
Enter the supplier code, general ledger code to post too, the amount, day to pay and a comment, then at the chosen date, each month the amount will be posted automatically to the ledger and deducted from the bank account.
* Note that no cheque numbers will be on the transaction.
The program displays the first record on file, and then offers you the choice of adding, deleting, editing or listing. To add or edit, you need to enter the date to start and finish automatically posting, e.g. a 12-month lease. Enter the date that the transaction is due each month, the ledger code to post too, the payee or person receiving the payment and the amount. You can also add a comment if you wish. Note also that this does not generate the cheques for you. It only saves you having to enter the same details every month.
The first screen you come to shows the details of the first transaction on file with a few options across the bottom of the screen.
This option gives a listing of a selection of your suppliers.
By default it will list all suppliers on file. If you wish, you can select suppliers by account code (e.g. if the printer ran out of paper after the "R-----" suppliers, you can restart printing from the "S-----" suppliers) or in a particular postcode area.
Choose display or print according to what you want, then put in a starting code (by default it will show the first supplier on file), and an ending code (by default this will show the last supplier on file). The same applies for the start and end postcodes.
Once you confirm that these details are correct, you will get a list of suppliers.
This option gives a list of the transactions youve had with all your suppliers between the dates you specify.
The first instruction you need to tell the program to do is whether you want to see Invoices, Payments, Credits, Direct Debits or Unallocated. After this the steps are the same for all options.
You put in a start date, end date, and then specify whether you want the information displayed or printed.
After that you get a printout or an on-screen list you can look through.
If you chose to have the information displayed, press v when youve finished looking at the details.
The All Payments report option will give you a list of payments made to all your suppliers between the dates you specify and in the order you choose. This gives you details on where your funds are going. It will list payments for wages and petty cash etc.
The ways of viewing these payments is the first screen you come to: there will be six options: Date, Cheque No., Supplier, As Entered, Cheque Summary, and by General Ledger code.
After choosing which way you want the information, you put in the start and end dates. Then choose whether you want to display or print the report and you will get the transactions you want in the form youve requested.
Note: if the dates are prior to the start of this month, the program will ask if you want to include non-current transactions which means you can access the archive file for the information prior to the current month. Therefore reports can be generated for any time frame that you choose.
This option will list all suppliers that you currently owe money to and details how much. This may not be a pretty sight, so be seated when you run this option.
Simply choose whether you want it displayed or printed and the computer does the rest. Once the report has been generated press v to return to the main supplier menu.
This option prints a remittance statement for the suppliers to whom you currently owe money. It lists all invoices and payments and allows you to attach a cheque and post it to your supplier. This gives your and your supplier a chance to check that all details of transactions for the month have been entered correctly.
You can choose whether you want all of your suppliers balances or just one.
This is done by entering the starting account code (the computer will default to the first and last account code in alphabetical order if you want to run them all), and the ending account code.
If you choose to leave the defaults, as they appear, the computer will print out your entire supplier balances, one per sheet.
This option posts all transactions to a temporary General Ledger file in preparation for updating the General Ledger. It can be run at any time but must be run before updating the General Ledger to give an accurate picture of your current business position. It is automatically run when you do an End of Month processing.
Note - to see the results of your work in the General Ledger, you will also need to Post to GL in the General Ledger Menu.
To run this option you will consciously need to choose Yes to continue. If you choose No then you will return to the main menu screen. If Yes is chosen then a message "Posting Supplier Transactions" will flash on the screen and when all the posting is complete a further message will show that it has "Finished Posting Transactions", press } to return to the main menu.
The procedure updates the supplier files, changes the aged balances from current to 30 days and 30 days to overdue and deletes all completed transactions, i.e. all invoices that have been paid are cleared.
All non-current transactions are shifted into archive files (from which they can be retrieved if necessary); i.e. all fully paid invoices from suppliers and associated transactions.
This option closes all files for the month. Ideally, it should be run in conjunction with the Customer, Parts and General Ledger End of Month processing.
You will be given a warning and will have to consciously choose continue to complete the process. If you choose to continue you will be asked for a Date to Age Prior to. Enter the date and the computer will roll all transactions prior to that date by one month. The screen will show you that it is processing end of month details by flashing in red and may stay like this for several minutes. When the process is complete you will be advised and have to press } to continue and return to the main menu.
As with Customers End-of-Period you will not be able to post or complete the process if the General Ledger has not been completed.
If it is June, July or August, you will automatically be reminded and prompted to do an End of Year. Make sure it is done before commencing to enter any transactions for the new financial year.
This is the parts main menu.
In this section you can record all the details of parts you carry, including amount in stock, re-order levels and so on. As parts are invoiced in the customer area, the amount in stock is reduced automatically, and if you enter supplier invoices, you can update the stock levels from there.
This option allows you to enter stock details.
It allows you to keep a check on prices and stock turnover. Even if you don't wish to monitor these things, having your major stock items listed here will make printing invoices quicker and more accurate, so it is a good idea to update the stock file as you find time.
To find a part, enter the part number (e.g. Z9) you wish to see. If you put in the correct number you will move to a screen showing this parts details with a few options down the bottom. If the part number is incorrect or left blank, a list of parts will pop up in a red search screen allowing you to choose the part you wish or add a new part (by pressing v).
You can also search for a part by description. Leave the part number field blank and type in the description (or even only part of it) of the part you are searching for. I.e. filter will list all parts with "filter" somewhere in its description, fil will find all parts with "fil" in the description including filters and files and filaments etc.. The part description doesnt have to be at the beginning of the description, but can be anywhere a match occurs. I.e. "fil" will be found in air filters, oil filters, fuel filters, filter elements, and gas filler valves.
You can search for parts by Generic or Bar Code as well. Leave the Part Number and Description blank, then either type in a Generic/Bar Code or use a bar code scanner to enter the code. This will then display the part if it is on file, or display a list of the nearest matching parts or those with the same or similar generic codes.
The options that are across the bottom of the screen are as follows.
This option allows you to set up various group numbers for your stock.
This is useful for categorising stock into e.g. brakes, shockers, mufflers, spark plugs, etc. When you print reports, they can be printed by group number, which helps locate parts quickly.
This is the place where you can edit those group numbers that you use every time you do something with parts.
The first thing you put in is the group number (i.e. BR for brakes) and press e. If you leave it blank the pop up list will be there for you. There is virtually no limit to the number of groups you can have but it will lose some of its significance if there are too many.
Then you get the group number and its description on screen with the usual options across the bottom.
This option allows the entry of kits made up from the parts in the stock file.
You are asked for the part number and the quantity used in the kit. To keep sales figures up to date, it also calculates the profit on each item based on the difference between the selling price of the kit and the cost of the kit. The % profit on the kit is transferred to each item making up the kit.
To setup a kit you first have to put in a new part number and description, (for example LPG kit, Gas Conversion kit), in the Parts - Maintenance option and as you are entering the details. At the section of the part screen where it asks if this part is a kit you enter Y (yes).
Then when you go to the Kits File Maintenance option, the program will filter through all the part codes looking for all the parts with yes in the kits field. The first thing you enter is the number of the kit.
If the number is incorrect or if you leave it blank, a pop up list displaying all the kits will come up. This process of filtering through all the part codes looking for the kits may take some time, please be patient, pressing keys and cursing the computer wont help.
Next you will see the chosen kits details with the line across the bottom showing some options.
This option will delete groups of parts that you no longer wish to keep.
You can enter the group number and supplier code to specify only those parts that you wish to delete.
This is useful if you regularly get parts updates on disk from your suppliers. You may get parts that you dont use or dont want to clutter up the hard disk.
Select the groups you dont want and the supplier code (leave blank for all suppliers) and then choose yes to continue. All parts that were in that group and from that supplier are no longer on your computer.
This option changes the existing OLD TAX RATE to the NEW TAX RATE. Unfortunately, this option will only help you with one of the two certainties in life, increased taxes.
Type in the old tax rate i.e. 21.00 and press e.
Next type in the new tax rate i.e. 22.00 and press e.
After choosing Yes to continue, a flashing message at the bottom of the screen will advise you that all tax rates are being updated.
Note that if this is a standard rate change you will also need to update the tax rate in company maintenance to enable all new parts created to have the new tax rate.
This option allows you to increase or decrease prices in line with changes made by your suppliers or other cost increases.
You can select a supplier code if the changes are only to parts supplied by one supplier or else leave blank if it's a global change.
You can select parts by group number. This allows you to change all of your brakes or shockers, irrespective of the supplier. By choosing both a supplier and a group number, you can change prices on for e.g. shockers supplied by Munroe. Note that you must have already set up your parts into the various group numbers.
Once you have selected which parts to change prices for, you can then choose to either increase by a percentage or by a set dollar amount. Select % or $ and then enter the % or $ amount to change. If it is a decrease, enter a - sign in front of the % or $ amount.
You can also choose to update only Cost prices, Retail prices or all of the prices by the amount specified.
If all details are correct, the parts selected are then updated.
If you have many parts, this process may require quite some time as it also adjusts prices in the kit file if you are using this option.
This option allows you to display or print various stock reports.
The reports you can choose from are:
Price list (complete with details of list, cost, retail and trade prices as well as the usual supplier) | |
Retail price list (to give to customers if you want or is handy for quickly calculating the cost of a job without having to worry about calculating list prices and tax.) | |
Kit price list (lists all your kits e.g. an LPG conversion kit or a complete exhaust system.) | |
Stock-take forms (for doing the workshop stock-take giving a list of all stock, its location and how many there should be. It leaves room to adjust the stock on hand figure if it is incorrect.) | |
Reorder report (what parts need reordering and the quantity listing all parts that you have less of than in the minimum stock level you set for each part. It generates a report by supplier so that you can send the report to all your suppliers without having to hand-write orders.) | |
Stock turnover report (only those parts that are being sold listing all parts and the number used month and year to date. This is useful when re-ordering stock as you can calculate your usage better.) | |
Stock value report (value of parts listing parts in stock and the cost value of these parts calculated on the last and average cost as well as retail.) | |
Top selling parts report (best sellers by $ and quantity listing the top 50 selling parts by quantity sold or by dollar value for either the current month or year-to-date.) | |
Buyin parts report (parts entered on customer invoices using the buy-in option.) |
This option allows you to export a standard format Parts Disk. There are two possibilities for the type of file to export. They are: DBF or TXT format. Most standard computer programs can read both formats and the choice of file format is up to you or the person you are giving the file too.
If you are giving the file to someone else, you are given the option of clearing your cost prices from the file.
You are then asked to enter the floppy drive to copy the file too. Make sure a disk is in the floppy drive before continuing.
Once the file has been copied, you are returned to the parts main menu.
If you are importing a parts disk in OPEA format (see importing parts), you can set up various discount structures to accurately get your cost on parts. The OPEA file contains the list prices only, so you need to enter your discount table to get accurate costs.
This option posts all transactions to a temporary General Ledger file in preparation for updating the General Ledger. It can be run at any time but must be run before updating the General ledger to give an accurate picture of your current business position. It is automatically run when you do an End of Month processing.
Note - to see the results of your work in the General Ledger, you will also need to Post to GL in the General Ledger Menu.
To run this option you will consciously need to choose Yes to continue. If you choose No then you will return to the main menu screen. If Yes is chosen then a message "Posting Stock Transactions" will flash on the screen and when all the posting is complete a further message will show that it has "Finished Posting Transactions", press } to return to the main menu.
The stock End of Month processing sets the month to date sales figures to 0 and posts the stock on hand figures to the General Ledger. As such, it is not critical to run this exactly at the end of the month, but you will be given a warning and will have to consciously choose continue to complete the process. If you choose to continue the screen will show you that it is processing end of month details by flashing in red and may stay like this for several minutes. When the process is complete you will automatically be returned to the main menu.
If it is June, July or August, you will automatically be reminded and prompted to do an End of Year. Make sure it is done before commencing to enter any transactions for the new financial year.
This is the General Ledger main menu.
This section is used if you wish to get an overall picture of your business's finances. It combines the income from your customers and the money you pay to your suppliers and tells you if you are making a profit or a loss. You can also enter other transactions such as payment of sales tax or transfer of money from one bank account to another. To use this option, you firstly need to do postings from your customer and supplier sections and then the Post to General Ledger option. This copies all the details from other parts of the program into the General Ledger.
This option allows you to set up the General Ledger codes and descriptions. You can display or print a list of the existing codes, add new codes or edit and delete existing ones. Please note that General Ledger Codes and descriptions have to be added according to Group Number and Group Description.
The following is a list of the groups and their descriptions.
Each General Ledger code has to start with the first number of the General Ledger Group, and consist of up to 8 numbers. For example Cost of Sales, Group Description number 20, therefore General Ledger Code could be 2101.
The following General Ledger codes need to be set up in the company setup option (refer to Other menu - Company setup). The following is a suggested code for them. Once they have been set, they should not be changed.
The following tables shows how transactions are posted in the General Ledger:
|
|
DEBTORS |
|
|
SALES |
DEBTOR |
BANK |
INVOICES |
- Cr |
+ Db |
|
RECEIPTS |
|
- Cr |
+ Db |
CREDITS |
+ Db |
- Cr |
|
|
|
CREDITORS |
|
|
EXPENSES |
CREDITORS |
BANK |
INVOICES |
+ Db |
- Cr |
|
PAYMENT (R) |
|
+ Db |
- Cr |
CREDIT |
- Cr |
+ Db |
|
OTHER PAYMENTS |
+ Db |
|
- Cr |
This option allows you to enter journal transactions.
You may need to do this if you have several bank accounts and transfer funds from one to another or wish to write off bad debts. Enter the date, a reference, the ledger code, a brief description of the transaction, if it is a debit or credit and the amount. The details will then move to the next line and you will be prompted for the balancing journal entry. The details will not be posted unless the amounts posted balance. As a rule, the amounts entered as journals should go as described in the table above.
Note that for every transaction, there is another transaction that balances the ledger, e.g. customer invoices make the sales account go down, but the customer outstanding amounts account goes up. When the customer pays, the customers outstanding account goes down, and the bank account goes up. The sales account does not change because it only records the total sales for the year and keeps on growing, while the customer and bank accounts go up and down as invoices and receipts are entered. The suppliers accounts and cost of sales are exactly the same, except in reverse.
To alter account balances to make corrections for accidental overcharging or undercharging, or any typing mistakes, etc. you must first you put in the entry date, this will show todays date by default but can be overwritten.
Next is the reference column, you can make any small notes here.
After that you put in the ledger code that this entry is for, if you leave this blank, a list of the codes on file will pop-up for you to choose from.
The next column shows the ledger codes description, there is also one line to put in your own description.
Then you put in whether its a debit or credit journal, this will default to debit the first time round, then if youve done a debit the next entry will default to credit. This works the other way around as well, if you do a credit the first time, the program defaults to debit on the next entry.
After deciding to debit or credit, you insert the amount the entry is for. To the right there is a balance column, this gives you a running balance of the journal entries you are making. You can then make another entry or press v
to exit.Note: If you try to exit whilst the balance is not equal to 0, the program will warn you that the journal entries do not balance. v will continue the exit process or } will return to the journal entry screen so you can rectify the balance problem.
Once you have entered any journals, to update the ledger balances, you must do a Post to GL, which is described below.
This option will print or display a detailed listing of your General Ledger.
It will list each ledger code and any transactions in the current month as well as month-to-date and year-to-date balances.
This will give you a list of all ledger codes transactions for this financial year in code order. You simply tell the program whether you want to display or print this information.
Then you get a display/printout of the codes in order showing dates, transaction numbers and types (e.g. debtor invoice), any reference notes made, the account code for each transaction, the cheque number or invoice number (depending which is appropriate), and finally, the transaction amounts and the ledger codes balance. Move around the report with the arrow keys.
This option also gives you a display or printout of ledger codes transactions.
First you put in the start and end dates for this report, then you specify whether you want the information in date order, ledger code order or as they were entered.
Next you say whether you want the information displayed or printed.
You then get the report you requested. If you displayed this report you can move around by using the arrow keys.
This option will display or print a list of all ledger codes sub- totalled by group. It will also give you a provisional Prime Margin and Profit or Loss.
First you tell the program whether you want this report to display or print. Then you get a display/printout showing the ledger codes, their descriptions, and then the Month-To-Date and Year-To-Date balances both as a dollar value and as a percentage of all the totals. If you chose to have a display, you use y and z to move around in the report and v to exit.
This option lists each ledger code and its balance, giving you a brief look at how your business is going. The income and expense balances should always result in an overall balance of 0.
Like the other reports in this menu, the first thing you need to do is choose whether you want the information displayed or printed. You then get a report showing the various ledger codes and their descriptions, then the debit and credit columns. You use y and z to move around in this report and at the end of the report you will see the totals.
Press v once youve finished viewing this report (thats if you chose display- not print).
This option lists your Assets and Liabilities, i.e. what you own or are owed against what you owe. It will list your bank accounts, outstanding debtors and other moneys or assets you have in the general ledger and then all your creditors accounts such as outstanding creditors accounts, overdraft or loans. The net result of this report should always be a 0 balance.
Once again, the first thing you choose whether you want to have this report displayed or printed. Then you get a report showing information in a similar layout to the trial balance.
You use the yzxw keys to move through the screen display, and if you want to move up or down a whole page you can use the p and q keys. Press v when you're finished.
This option allows you to manually reconcile all the transactions posted into and out of the bank account with your bank statement. It then checks the General Ledger Bank Balance, picks up all the uncleared transactions from Customer and Supplier transactions and produces an accurate statement of your banking situation.
NOTE: This menu selection will only show an accurate bank balance if you are properly and fully using the accounting system.
The screen displays all the bank transactions for the current period, or any uncleared transactions for previous months.
This option picks up all the transactions from temporary files created by posting in the customer, supplier, parts and ledger journal transactions and posts them to the various General Ledger accounts. Unless you have posted all of the above transactions, the current balances may not be accurate.
You will be asked if you are sure you want Post to the General Ledger. If you are sure, type Y.
After all the processing is done you will be prompted to press any key to continue; press e.
This option removes all transactions in the general ledger for the current month and changes the month to date balances to 0. Ideally, it should be run in conjunction with the Customer, Supplier and Parts End Of Month processing.
All non-current transactions are shifted into the archive files (from which they can be retrieved if necessary).
When you go into this area you will be asked to make sure you have done certain jobs. Run all your relevant reports and follow the instructions, then you must choose continue to complete the End Of Month process.
If it is the end of the financial year, you can also clear your profit and loss reports and rollover all the ledger accounts. Please ensure that all postings for the year are complete and an end of year has been completed in customers, suppliers and parts.
If it is June, July or August, you will automatically be reminded and prompted to do an End of Year. Make sure it is done before commencing to enter any transactions for the new financial year.
This is the utilities menu.
From here you can select a number of options that help in setting up the software and hardware and keeping the whole system running smoothly.
This option allows you to reindex the various files used within the Workshop Manager option.
Reindexing does several things. Firstly it removes any records that you have marked to be deleted. When you delete a customer, the customer record is only marked to be deleted and in fact can be recalled if necessary. This option permanently removes these records. Secondly, the files are then indexed. This basically is the same as setting up files in alphabetical order in a filing cabinet. When you go to search for information, for example "Price Lists" you don't then have to start at the beginning and search record by record until you find by accident the price list file, but can go immediately to "P" and then search. The computer is the same. By setting up indexes, it can find most records instantly. If you find that when searching for customers or parts, that the computer displays the wrong information, it's likely that the index has been corrupted. By running this option, it should fix the problem.
When you choose to run this option the first thing you get is a request for you to make sure that anyone else who is using the program is at the main menu, otherwise you cant Reindex. (This is only relevant in a multi-user system.) Once youve checked that all users are out of Workshop Manager you press } to continue.
Select Reindex if you wish to continue, or Esc to exit.
Once the reindexing is complete the program lets you know and you simply press } to continue, which takes you back to the main menu.
This option allows you to list and modify the postcodes file.
You already should have a complete list of all postcodes for your state, and if you wish, you can have a list of all postcodes within Australia. The reason for limiting the file to within a state is to save space and time, but you may request the additional postcodes if for example, you have many interstate suppliers or customers.
You can use this option to find a postcode quickly.
The first thing you put in here is the suburb you wish to find the postcode for (e.g. BALWYN). If you leave this blank you will be taken to the postcode maintenance screen, and the first postcode for the state in alphabetical order will show on the screen. If you put in an incorrect suburb or spell the suburb incorrectly a list will pop-up for you to choose from prompting the closest match, if this is the suburb you want press enter. If not, either use y, z, p or q, until you find the one you want or simply type the first few letters of the suburb and press enter and the red selection box will go to the closest match, you can then continue to search by using either method. Once you find the suburb you want highlight it and press enter.
After choosing the suburb you want you get a display showing the suburb and its postcode with nine options across the bottom of the screen.
These options are:
This option allows you to set up the mechanics in your workshop.
In the mechanics code enter their initials, then on the next line, their name. If you wish to charge out the mechanics time at a different rate from the default workshop rate, enter an amount per hour in Hourly rate. This may be useful if you get in a temporary, specialist mechanic, use a sub contractor, or you have apprentices that you don't charge full rate for. Leave the Hourly rate blank if you don't wish to have a different rate from the workshop. It also keeps a record of the mechanics address, telephone and tax file numbers.
The first thing you enter in this screen is the mechanics code. If you leave this blank the program will automatically choose the first mechanic on file (by alphabetical order). If you put in an incorrect code you get also get a pop-up list to choose from. Once youve chosen a mechanic you will get a display showing the following;
mechanics code and name. | |
mechanics hourly charge if it is different from the default workshop rate. | |
approximate hourly cost on labour if it is different from the default workshop rate. | |
mechanics home address and telephone number if you need to contact them. | |
mechanics tax file number. |
This option allows you to set up the various major service codes and their descriptions.
Across the bottom of the screen there is the usual options for adding and editing etc.
This option allows you to set up or modify various details that affect the rest of the programs.
Edit Changes the following settings;
Bank Details If you intend printing and using the bank deposit report (customers), enter your bank details here as they will then be used when printing this report.
If you change your address or telephone number they can be changed in this area.
This option deletes history records prior to the date you enter. This keeps the size of your history files manageable. Unless you really need to keep the records 2 years is normally long enough for warranty and service history details.
You get a message, which briefly tells you what happens. After reading this you can either put a date to clear from or press v to exit.
If you continue make sure you Reindex your files when youre finished.
This report gives a summary of sales tax collected from customers you have invoiced. Normally you invoice customers on a retail basis - that is that for the goods you sold, you have already paid sales tax to your supplier, and so do not need to charge for it again. However, for the goods you sell to another workshop or trade customer, you are classified as a wholesaler and are supposed to charge sales tax. This is despite the fact that you may have already paid tax to your supplier.
This report summarises that information.
The first thing you enter is the start and finish dates for the period you want a report on.
Next you specify whether you want to have the report displayed or printed.
After that you will get a report showing the following; a total of retail sales, trade sales and tax exempt sales, then on the right you will see the tax collected (retail and trade), a rebate amount and the amount of tax payable. Press } to continue.
This option allows you to change the account code of customers and suppliers, part numbers and general ledger codes and the registration number of vehicles or ownership of a vehicle.
Make sure all other users are out of the program before continuing with this procedure. Always enter the old code first and you will need to confirm if it is the right one before proceeding. At this stage you have no choice but to change the code so go to this area only if you are positive. Simply follow the instructions on the screen and you will modify/change a code. All transactions relating to the code changed will also be altered to the new code if you so choose. There are times when you would not like the transactions to go to the new owner i.e. if a caryard had the car originally and the new owner brought it in to you for its next service you would leave the original amounts with the caryard.
As the code affects the finding of records using an index, the files will need to be reindexed after changes have been made, you will be reminded of this as you exit this area using v. This reindexing takes several minutes, so allow plenty of time and can be found in Other menu - Reindex Files.
This option allows you to set up passwords to restrict access to various parts of the program.
You may wish to do this for a number of reasons, such as preventing staff or customers from viewing sensitive account information, or printing reports from your account customer information.
It also restricts access to certain critical functions such as End of Month processing.
The Level 1 password restricts access to sensitive or critical parts of the program. Its the sort of password you would use if your apprentice (for example) was doing invoices but you didnt want them to see the businesss financial information.
A Level 2 password restricts access to menu options as well and should only be used on a temporary basis if the computer is to be left unattended or you only want selected staff to use the program. This is the type of password you would set if you had to go away from the computer but wanted to leave it switched on.
Please note that if you do set a password, dont forget it!
To change these, you choose which password type you want, then simply type in the password and press e.
Note : if a previous password has been set, you will need to know what it was to change it.
Press v once youve finished here.
This option allows you to store up to 55 characters to a file that can be accessed by pressing the * key anywhere in the program.
You can then enter this text into an invoice or statement or any other text field by pressing the appropriate function key *. This is useful for storing commonly used comments, e.g. "Thank you for your custom" or "Parts carry a 12 month warranty". When you print an invoice, you can then press * and select from a pop up list of comments and this information will automatically appear on the invoice. Longer comments can be added using the repair codes found in the Other menu - Services option. Refer to the Services and Function Keys descriptions.
To edit any comments already in the system or add new comments simply follow the options on the bottom of the screen.
This section allows you to setup the printing options for the various forms in Workshop Manager.
As different workshops have different printers, networks with printers attached to different computers and so on, this area simplifies the printing of forms from each computer.
Select the type of form you wish to setup the printing options and make any changes as necessary. Listed below are the various options available, but they are not listed by form.
Compressed 15
Double Width 14
Check your printer manual for the correct decimal codes. They will be found under a title such as software control codes. If you are not sure or need help please contact us.
Stationery Type You can also select the type of stationery you are printing on. If you set the number to 1 on any of these, the program assumes you are printing on plain paper and will fill in all the headings and field titles. If you select 2, it leaves off the field titles, but fills in the headings. This is used for the standard invoices and statements supplied by Creative Accounts Management Systems. Option 3 is used for custom forms with your name and address already pre-printed. This stationery choice type is identical for invoices, jobcards, statements and letters.
Number of Copies If using an inkjet or laser, you can automatically print a second copy of the invoice by changing this from 1 to 2.
Header Margin Determines the number of lines from the top of the page to start printing. Use only if your printer doesnt line up properly.
Set Left Margin Moves the column starting position for printing. If the form doesn't line up across the page you can move it left or right by adjusting this number.
Page Length Sets the length of the page to tell the program how many lines it can print before starting another page.
Print in Tear Off If using CAMS standard inkjet/laser forms, there is a tear off at the bottom of the forms. You can get the printer to print in this section by setting this to a Y.
Print Options Allows you to customise your printed forms. Select Y to activate the display option or N to turn it off. Note that it does not affect the information displayed to you or any reports printed for you, only the way the invoice prints for the customer.
Display Options If set to Y, every time you print an invoice it will prompt you for the Invoice Print Options before printing. This is useful if you use more than one printer or if you wish to change the information you present to different customers on the invoice.
All Service Costs Prints a price for each service description. Enter N for no if you don't want to show the breakdown of labour on the work done.
Service Subtotal Prints a subtotal after the last service description before printing parts. You would probably only select this if you didn't print each service cost individually.
Part Numbers Part numbers will print. If you only want descriptions so your customers don't know what part number is used then enter N.
Part Costs Prints the price of each part used. If you want the customer to know individual charges for each part choose Y.
Parts Descriptions If this is set to N then no parts details are printed on the invoice. Note that the subtotals should also be set to N.
Labour/Part Subtotal Prints a Labour and Parts subtotal as well as an invoice total. If you enter N for no, then only an invoice total will print.
Lines and Boxes If printing on plain paper, you can set this to Y and the printer will print lines and boxes to make the invoice look more professional.
Telephone Numbers If this is set to Y, telephone numbers will print on the forms. This is handy with invoices and jobcards as the customers telephone numbers are printed and you can contact them without needing to look up their details in the computer, or if you are running late on a delivery, you can ring ahead to let them know.
Once you are happy with the information entered here press ) save this information. You will be prompted with "Are these details correct". Press Y if they are or N to further edit the printer details. You can also use w or x to move the cursor to the choice of yes or no.
If you are using "Car Yard" from Sonet Systems, you can automatically consolidate all your accounting data into Workshop Manager. Rather than have two completely independent sets of accounts, once you have invoiced your customers and entered costs against vehicles in Car Yard, you export the transactions to Workshop Manager. After exporting from Car Yard, use the car yard import option to import and update all the accounts in Workshop Manager.
This will then allow you to send one statement per customer and consolidate your accounts into one general ledger.
Once the data is imported, the data cannot be accidentally re-imported. Always check that the transfer has completed by checking a customers account that you know has been changed in Car Yard.
If you have a number of people using one computer, or you have a network where there are several computers entering transactions at the same time, you may wish to setup each user in this database.
By setting the flag in Utilities - Company Setup to request user login, every time a user starts Workshop Manager, they are asked for their User Id and Password. This ensures that only those users you have setup in this database can access the program, and it also records this users details against every transaction or change to any records in the system. In the event of any problems with data or potential tampering with your information, the User Id, Date and Time can be found in each record, tracing it back to the user who made the changes.
This system is extremely effective in a larger business where employees don't often own up to mistakes that may affect your business profitability.
It is on effective if each user is setup and logs in correctly. If a user is leaving the computer for any length of time, they should logout or exit the program so that anyone else who wishes to get information must log in as themselves and not use the previous users codes.
To change a user without exiting the program, go to Exit - Change User Logon.
Help is available from this menu option. Help is also available at any time by pressing ! and information relevant to the section you are in will be displayed.
This option will only appear if you are running a demonstration or unregistered copy of the program. You will need to contact CAMS to get the relevant information to register the software in your name. If this occurs, you will be given instructions over the telephone.
If the program is unregistered, this will display or print an information list about registering this program.
This option will give a basic overview of the Workshop Manager program. It also shows what the function keys do.
You use the y, z, p and q keys to move through this. v takes you back out to the main menu.
Press v when you are finished looking at this and you will return to the main screen. It is basically the same function as pressing !.
This screen lets the you find out what changes have been made and any future changes that are due to come in future releases.
As each new release or update of Workshop Manager is sent to you, a file containing information about changes, fixes and future changes is detailed in this section.
Read it carefully as it may affect some of the ways you currently operate the program.
These are simply an assortment of comments and tips by various people, hopefully they provide you with some entertainment. They will show when you first start the program but there is an option to switch them off.
This option can be found in Other menu - Company setup.
When the option is on press v to continue to the main screen.
This is simply a disclaimer of what the author and re-seller does and does not guarantee the program will and will not do.
To read the disclaimer simply use y, z, p and q keys to move around and v will take you back to the Help menu.
Displays an information screen telling you what version of the software you are using, serial number, registration number and if it is a demo copy, the number of demo sessions left.
To exit the program, select this menu option and press e. Or by now the shortcut key for exiting should be obvious, but for those of you who havent read the rest of this manual, its v. Press v to exit.
If you have accidentally selected this option or pressed v too many times and you have an exit screen showing, then you have two choices. You can press any key to return to the main Workshop Manager menu or you can continue to exit to DOS or Windows by pressing e.
This option allows each user to logon or change logon without exiting the program. By having a separate logon name for each user, security is improved. Each time any transaction or modification to any file is made, the user who is logged on at the time has their details recorded against this transaction.
If there are problems at a later date, this information can be recalled. Each user must be added under Utilities - User Access. You are then prompted for your User Id and Password. If they are correct, they remain in force until either another user logs on or you exit the program and restart with a new logon.
WORKUTIL is a support program for Workshop Manager. It contains a number of additional programs that are to be used only under direction and supervision from CAMS support staff. The programs it contains are listed below with a brief description, but you will be assisted with using the program if necessary.
1 set of disks marked Monday | |
1 set of disks marked Tuesday | |
1 set of disks marked Wednesday | |
1 set of disks marked Thursday | |
1 set of disks marked Friday (If your week is 6 working days) | |
1 set of disks marked Week 1 | |
1 set of disks marked Week 2 | |
1 set of disks marked Week 3 | |
1 set of disks marked Week 4 | |
1 set of disks marked Week 5 | |
1 set of disks for each month of the year. (marked 'July', 'August' etc.) |
Day: Week of |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
1 |
Monday Set |
Tuesday Set |
Wednesday Set |
Thursday Set |
Friday Set |
Week 1 Set |
2 |
Monday Set |
Tuesday Set |
Wednesday Set |
Thursday Set |
Friday Set |
Week 2 Set |
3 |
Monday Set |
Tuesday Set |
Wednesday Set |
Thursday Set |
Friday Set |
Week 3 Set |
4 |
Monday Set |
Tuesday Set |
Wednesday Set |
Thursday Set |
Friday Set |
Week 4 Set |
5 |
Monday Set |
Tuesday Set |
Wednesday Set |
Thursday Set |
Friday Set |
Week 5 Set |
Example of an Autoexec.bat file
Example of a Config.sys file
The information regarding rates and charges is subject to change from time to time. You will be supplied a copy of any support contract or latest rates and charges at the time of purchase.
Week 1 Introduction to Workshop Manager, setting up your software and Job Entry. | |
Week 2 Customers: entering jobs, invoices, receipts, reports and letters. | |
Week 3 Suppliers, Parts and Ledger: entering new parts, expenses and reports. How this affects the Profit and Loss. | |
Week 4 Open session covering general topics and questions. | |
Week 5 Introduction to Windows: Basic commands, features and tips. | |
Week 6 Internet and other topics. |