This article will explain how to process a Unit Cost Adjustment




When to process a Unit Cost Adjustment


For various reasons the dealership may require to process a cost adjustment to a unit and sometimes that adjustment will need to be directly related to a charge (this would be a plus adjustment) or credit (this would be negative adjustment so you would need to type the figure in with a negative ie -120) from a Vendor


Examples may include a freight adjustment / Vendor rebates etc



How to process a Unit Cost Adjustments in Blackpurl


  1. Navigate to the relevant Stocked Unit Record > then scroll to the B. Price & Cost Tracking section 

  

User-added image


  1. Click on User-added image > Add adjustment


User-added image


  1. On the Add adjustment window, slowly work your way down the fields and complete as required:



A.  Type
Select if it is a BASE or FACTORY OPTION adjustment


B.  Item/Description
A free text field where you can type information about what the cost adjustment is


C.  Total Price
This is how much the cost adjustment will affect the Total Price of the Unit


D.  Total Cost
This is how much the cost adjustment will change the Total Cost of the Unit

**For Australian/New Zealand please enter the amount as GST exclusive as you can nominate the relevant tax down later in this process


E.  Adjustment date
It will default to today's date - change the date as required
If you have Accounting Integration, this is the date that will appear in the accounting package


F.  Category
Indicate the Category for the cost adjustment 
If you have Accounting Integration, the Category indicates where this cost adjustment will be mapped to in the accounting package:


G.  Vendor - If applicable, select the relevant Vendor
**If you select a Vendor, the transaction will not post anything to the Category but will create an Accounts Payable document instead
  • a new field will population - Vendor Reference Number and you will need to type in the relevant reference number ie Invoice #.
  • a Vendor invoice/credit will generated in the accounting package (if you have Accounting Integration) using the Vendor Reference Number indicated above
  • you can also nominate the applicable tax and this will integrate with the Vendor document to your accounting package

H.  Customer - If applicable, select the relevant Customer
**If you select a Customer, the transaction will not post anything to the Category but will create an Accounts Receivable document instead
  • a new field will population - Customer Reference Number and you will need to type in the relevant reference number ie Invoice #
  • a Customer invoice/credit will generated in the accounting package (if you have Accounting Integration) using the Customer Reference Number indicated above.
  • you can also nominate the applicable tax and this will integrate with the Customer document to your accounting package


  1. Once you have completed the details > click on User-added image

Result


  • The cost adjustment will make an impact on the Unit Record as per your instructions


  • If you have accounting integration the transaction will integrate to your accounting package and be sitting under the relevant Inventory General Ledger with an offset to either Stock Adjustment Category General Ledger OR if you have nominated a Vendor/Supplier or Customer, it will show as a document in the relevant Accounts Payable or Accounts Receivable section




Further information - Accounting Integration



  • If the Credit is paid directly to you by the Supplier (either into your bank account or by sending you a cheque etc), due to a QuickBooks restriction, it will not allow you to allocate the payment straight onto the Vendor/Suppliers Credit Note


To receive the payment onto the Vendor/Suppliers Credit Note, it is a two-step process:


Receive the deposit funds directly onto the Accounts Payable > to the Vendor / Suppliers account


Then go to the Vendor / Suppliers Account and raise an expense item to allocate the Deposit received against the Credit Note.  


For example - we received a direct deposit into our bank account for $500 from Yamaha to be allocated to a rebate credit note

Step 1
  • We allocate the deposit funds onto the Accounts Payable > Yamaha Account


  • The transaction will list on the Vendor/Suppliers account.
Step 2
  • We go into the Yamaha Vendor/Supplier account and click NEW TRANSACTION > Expense

User-added image

  

  • Then select both the Rebate Credit Note and your bank deposit and ADD them to the Expense
User-added image
  • Check your entries (note it should be zero balance) then click on SAVE
User-added image

  • You can process a Unit Cost Adjustment to fix a keying in $ error when receiving the Unit into stock as the Cost Adjustment will NOT alter the original Vendor Invoice in your accounting package


If you do wish to use the Cost Adjustment to fix a keying in $ figure error, you will need to go to the Vendor Invoice in your accounting package and Edit the Bill


Add a Line and the process the amount of the cost adjustment using the Inventory Adjustment General Ledger account as the offset as you have already adjusted the Unit Inventory General Ledger account when you did the adjustment in Blackpurl . 


Don’t forget to take into consideration any tax implications depending on the tax jurisdiction in your area on the manual change to your Vendor Invoice




The end result is that your Vendor invoice is now as it should be, your inventory is correct and the entries to the Blackpurl Inventory adjustment match each other so no extra expense is recorded