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
- Navigate to the relevant Stocked Unit Record > then scroll to the B. Price & Cost Tracking section
- Click on > Add adjustment
- On the Add adjustment window, slowly work your way down the fields and complete as required:
**For Australian/New Zealand please enter the amount as GST exclusive as you can nominate the relevant tax down later in this process
If you have Accounting Integration, this is the date that will appear in the accounting package
If you have Accounting Integration, the Category indicates where this cost adjustment will be mapped to in the accounting package:
- For example - if you are adding a cost adjustment for freight to the cost of the unit and you want the transaction to go to a specific general ledger, you will need to create a new Adjustment Category for freight
- Please review our article - Understanding Accounting Integration - Step 7 Categories - Introduction.
- 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
- 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
- Once you have completed the details > click on
- 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.
- We allocate the deposit funds onto the Accounts Payable > Yamaha Account
- The transaction will list on the Vendor/Suppliers account.
- We go into the Yamaha Vendor/Supplier account and click NEW TRANSACTION > Expense
- Then select both the Rebate Credit Note and your bank deposit and ADD them to the Expense
- Check your entries (note it should be zero balance) then click on SAVE
- 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