This guide outlines the standard practice for recording discounts when ordering products and applying pay-on-time discounts via a supplier portal.
- Purchase discounts are entered on the Purchase Order in LightSpeed before it syncs as a bill in Xero.
- Pay-on-time discounts can be applied in Xero either as an adjustment during reconciliation or as a credit note on the supplier record in Xero.
Appling Discounts on Purchase Orders in Lightspeed
- Create the Purchase Order in Lightspeed as per your normal process.
- At the bottom of the PO screen, navigate to the Discount Line.
- Select whether the discount is a dollar or % value.
- Enter the discount amount in the field provided.
- Click Save.
- Once products are received, Receive the PO and send it to Xero.
- The bill created in Xero should reflect the discounted amount.
Appling pay-on-time discounts in Xero
You can apply the pay-on-time discount either by:
- Applying the discount as an adjustment during bank reconciliation, or
- Creating a credit note on the supplier and applying it to the related bill(s).
Apply discount as an Adjustment during bank reconciliation
- Pay the bills as per your normal process in the Supplier Portal.
- In Xero, locate the bank statement line for the amount you paid to the Supplier.
- On the right-hand side, click 'Find and match'
- In Section 1, find and select the bills you paid
- In Section 2, ensure the bills selected match what you paid via the portal.
- In Section 3, click the 'Adjustments' dropdown and select Bank Fee. Fill the transaction as follows:
- Contact: Supplier
- Description: Enter an appropriate description for audit purposes e.g 1% supplier portal discount
- Account: Select 5000-300 COGS Discount Taken
- Amount: Enter the dollar amount of the discount.
- The total of the bills selected and the bank fee transaction should match the amount paid.
- Click Reconcile.
Create a credit note on the supplier and apply it
- Pay the bills as per your normal process in the Supplier Portal.
- In Xero, navigate to the supplier record.
- On the top right-hand side, click New and select Bill Credit Note.
- Enter the credit note details:
- From: Auto-populates to the Supplier
- Date: Date discount was given
- Reference & Description: Enter an appropriate description for audit purposes e.g 1% supplier portal discount
- Account5000-300 COGS Discount Taken
- Amount: Enter the dollar amount of the discount.
- Click Approve to proceed to the 'Allocate Credit Balance page'.
- Apply the credit balance to the related bill(s) and click Allocate Credit.
- Reconcile the bill(s) against the related statement line using the Find and Match feature.