Peak has received reams and reams of paper regarding the new FOC Warranty Parts system but, after much discussion, has determined that the majority of the changes are procedural and do not require many changes to the software.
This document sets out our recommendations for processing this new system and lists the changes we are making to the software to facilitate easier reconciliation.
There is no change to the Parts Ordering procedure. Processing a Warranty Job, other than issuing parts at cost + handling charge, is also unchanged. For users not utilising this function, the set up is detailed in the next section.
The Software includes:
New Balance Sheet account codes for the Nominal Ledger are required for the following:
Go into Parts Management Parameters and into Amend Discount Codes. In here select the correct Franchise/s (Skoda/Seat) and then amend the Sales Discount Codes and set them to the percentage for cost plus mark up using the minus symbol. This will need to be done for all the Discount Codes under the relevant Franchise/s.
In the above example, any parts issued against this warranty account will be issued at cost plus 7.5%. The 7.5% is the handling charge allowed by the manufacture.
N.B. This charge may vary and is not meant to be representative of the actual fee that Skoda or Seat may allowParts Procedures
Workshop Procedures
Below are the procedures for clearing the warranty invoices raised by the workshop. Many users currently contra the warranty credit notes from the purchase ledger to the sales ledger as a lump sum. With the new FOC parts it will now be easier to reconcile if the credit notes are posted to the sales and purchase ledgers rather than doing the contra. The new facility of a narrative line (20 characters) on miscellaneous postings and receipts will aid reconciliation. This narrative line will also transfer to the nominal ledger.
NOTE: The VAT content of all invoices and credit notes should be shown separately.
As an added feature the following will be transferred as the narrative on all sales ledger invoices:-
a) Workshop Invoice - Job number/Registration Number
b) Parts Invoice - words ‘Parts Invoice’
c) Vehicle Finance D.Note - Registration Number
d) Vehicle Bonus D.Note - Registration Number
Note: These narratives will not at present transfer to the historical data file.
NOTE: The VAT content of all invoices and credit notes should be shown separately.
The addition of the new nominal codes for
and the ability to enter narrative lines on the sales ledger postings, makes the reconciliation of the new Warranty FOC Parts procedure much easier.
The documentation received from Skoda/Seat should be utilised to help with the reconciliation task. These nominal account codes should be marked for ‘reconciliation’ to enable the accounts staff to easily trace unreconciled values.
A new Composite box code for Warranty Parts Handling Fee is to be introduced. The Workshop Warranty Parts Sales and COS nominal codes should be attached to this new box code. This change should not be actioned until the November composite is completed. New composite programs will be issued once we have ascertained where the new box code is to be positioned. These should not be copied on to your system until the November composite and nominal month end is completed.
The postings created by the various entries are as follows:-
Delivery of parts order value £1000
Nominal Description |
DR |
CR |
Narrative |
Parts Stock |
1000.00 |
|
GRN 123456 |
GRNI |
|
1000.00 |
GRN 123456 |
Note: The value (ex VAT) of any goods received but not invoiced prior to copying on the new programs associated with the new procedures, should be journalled as above.
Warranty Invoice – Sales Ledger
Nominal Description |
DR |
CR |
Narrative |
Warranty Labour Sales |
|
45.00 |
Job No 000123 |
Wrnty Part Sales (incl Hand.Fee 5%) |
|
105.00 |
Part Number |
Warranty Parts COS |
100.00 |
|
Part Number |
Parts Stock |
|
100.00 |
Part Number |
VAT on Sales |
|
26.25 |
Invoice Number |
SL Debtors |
176.25 |
|
|
Warranty Credit Note – Sales Ledger
Nominal Description |
DR |
CR |
Narrative |
Warranty Clearing (Labour) |
45.00 |
|
User entry |
Warranty Clearing (Hand.Fee) |
5.00 |
|
User entry |
VAT on Sales |
8.75 |
|
Ref Number |
SL Debtors |
|
58.75 |
|
Note: Parts Sale £100 + VAT £17.50 not credited on warranty credit note.
Warranty Credit Note – Purchase Ledger
Nominal Description |
DR |
CR |
Narrative |
Warranty Clearing (Labour) |
|
45.00 |
User entry |
Warranty Clearing (Hand.Fee) |
|
5.00 |
User entry |
VAT on Purchase |
|
8.75 |
|
PL Creditors |
58.75 |
|
|
Note: this credit will be utilised, along with the parts invoices (sale document) and bonus contras, against the net Skoda/Seat monthly Debit or Credit from/to your bank. It also clears the Warranty Clearing Account from the Warranty Credit Note posting done in the Sales Ledger.
Parts Sales Document – Sales Ledger
Nominal Description |
DR |
CR |
Narrative |
FOC Parts Clearing Account |
100.00 |
|
User entry |
VAT on Sales |
17.50 |
|
Ref number |
SL Debtors |
|
117.50 |
|
Note: This clears the Parts sale £100 + VAT £17.50 not cleared on the Warranty C. Note on the Sales Ledger Warranty account.
Parts Sales Document – Purchase Ledger
Nominal Description |
DR |
CR |
Narrative |
GRNI |
1000.00 |
|
Supplier Ref |
FOC Parts Clearing Account |
|
100.00 |
Supplier Ref |
VAT on Purchase (net of £175 - £17.50 |
157.50 |
|
|
PL Creditors |
|
1057.50 |
|
Note: This posting clears the GRNI nominal account and the FOC Parts Clearing nominal account
Items Awaiting Invoice
This report can be found in Parts, Reports, Orders, Purchase Orders, and lists all orders received but not yet invoiced. It will, of course, only list parts received against a purchase order. Therefore, all franchise parts ordered should be placed on a purchase order.
If there are any ‘old’ orders on this report i.e. orders where the invoice has not been posted against the order, these should be deleted. A level 9 password in Parts Purchases is required to access this delete function and great care should be taken to ensure no current orders (received and not invoiced) are deleted.
Once the order file is cleansed, the report should match the GRNI value on the nominal and can be used to check source v nominal values.
Parts Issues Monthly Analysis
Found in Counter, End of Day, this report lists, among other things, the Mechanical WIP parts issued by retail, trade, internal and warranty. Currently it is calculated from ‘this months movements’ but is being changed to read the workshop job file and calculated all non-invoiced parts.
If the GRNI field is activated on the product group, this report is used to check stock valuation v stock nominal. The Goods Received Not Invoiced report value is no longer used in the stock v nominal value. The calculation now being
Stock valuation + WIP Parts = Parts Stock nominal.
This calculation assumes that any adjustments done on the stock file have been journalled from Parts Stock in the balance sheet to Stock Adjustments in the P&L.
Files | ||
---|---|---|
DataImage36.png
42 KB
|
||
DataImage66.png
30 KB
|