1. Home
  2. Accounts
  3. Sage Integration
  4. How Part Exchange ‘Over Allowance’ Integrates into Sage

How Part Exchange ‘Over Allowance’ Integrates into Sage

Open the Vehicle Record for the vehicle that is being sold Invoicing > Part Exchange > Add Vehicle.

Place a Part Exchange vehicle against the car being sold by clicking Add Vehicle and typing in the Registration of the PX and clicking Confirm.

adding PX test

Calculating Over Allowance

Add ‘Over Allowance’ onto the PX by typing in the ‘Buying Price’ box the actual price you are buying the PX for and then type in the ‘Stand In Value’ box how much the PX is actually worth.

This will then calculate the ‘Over Allowance’ as shown below:

over allowance calculation

Sage integration

PX sage integration

1. Sales Invoice (SI) created against 4300 (Used Vehicle Sales – Retail) for the Sale of the Vehicle
2. Sales Receipt on Account (SA) created against 1209 (Dragon2000 Dummy Bank Account For PX Contras) for the PX Contra
3. Payment on Account (PA) created against 1209 (Dragon2000 Dummy Bank Account For PX Contras) for the PX Contra
4. Journal Debit (JD) created against 4300 (Used Vehicle Sales – Retail) for Clear Over Allowance
5. Journal Debit (JD) created against 5309 (Used Vehicle Closing Stock) for Over Allowance
6. Journal Debit (JD) created against 5309 (Used Vehicle Closing Stock) for the Sale of the Vehicle
7. Journal Credit (JC) created against 4306 (Used Vehicle PX Over Allowances) for the Discount Over Allowance
8. Journal Credit (JC) created against 1020 (Used Vehicle Retail Stock) for the Over Allowance
9. Journal Credit (JC) created against 1020 (Used Vehicle Retail Stock) for the Sale of the Vehicle
10. Purchase Invoice (PI) created against 5300 (Used Vehicle Purchases – Retail) for the Purchase of the Part Exchange
11. Journal Debit (JD) created against 1020 (Used Vehicle Retail Stock) for the Purchase of the Part Exchange
12. Journal Credit (JC) created against 5309 (Used Vehicle Closing Stock) for the Purchase of the Part Exchange

Please note that the Nominal Codes shown above are based on the default Nominal Codes set by Dragon2000 for each transaction (i.e. 1020 (Used Vehicle Retail Stock), 5309 (Used Vehicle Closing Stock) etc.). If you are already using these Nominal Codes in Sage for other transactions, and therefore changed the default Nominal Codes, the Nominal Codes you have used for each transaction will be displayed instead.

Updated on November 6, 2019

Was this article helpful?

Related Articles