Settlement discounts on purchase transactions

We have identified three common scenarios that affect how you enter the settlement discounts on purchase transactions. Each of the scenarios requires you to input your invoices in a particular way or take specific actions. The scenarios are:

  1. Invoices and purchase orders contain full VAT and you do not expect to receive a credit note from your supplier to account for the VAT discount.

    This scenario would occur when the invoices you receive from your suppliers contain the mandated settlement discount text as illustrated here:

  2. Invoices and purchase orders with full VAT and credit note expected from your supplier to account for the VAT discount.

    This scenario would occur when invoices you receive from your suppliers do not contain the mandated settlement discount text and the supplier instead provides a credit note to account for the VAT discount when it is taken.

  3. Invoices with VAT already discounted.

    This scenario would occur if you paid for an order at the time you placed it.

Invoices and purchase orders with full VAT and no credit note expected

If the invoice you've received from the supplier has the VAT calculated at the full rate, the details of the discount are included on the invoice, and you're not expecting any further documentation from your supplier, we recommend that you follow the steps below:

  1. Enter the discount details on the invoice. Sage 200 calculates VAT at the full rate but you can change the VAT value if required. Depending on the values entered, the Invoice total and Discounted invoice total are calculated. The Discounted value is the amount that you expect to pay within the discount period.

    For an invoice of £100 with a 5% settlement discount, the following values are calculated:

    • VAT = 20.
    • Discount value = 5.
    • VAT discount = 1.
    • Invoice total = 120.
    • Discounted value = 114.

  2. Record the payment.

    If you qualify for the discount when you pay the invoice, you'll pay the invoice total less the net and VAT discounts. Include the net discount amount on the payment, but not the VAT discount. This makes sure that the net discount is posted to the Discounts Taken nominal account.

    For example, for an invoice of £100 with a 5% discount, you will pay £114. (Net disc = 5 and VAT disc =1). You enter a payment value of 114 and the discount as 5. This posts a payment with a total value of 119.

  3. Allocate the payment to the invoice. Make sure the Allocate amount of the invoice matches the payment. The discounted VAT amount should still be outstanding.

    Tip: If you double-click the allocation amount on a fully outstanding invoice or credit note, the allocated amount will automatically be reduced by the VAT discount, if it's still within the settlement discount period. This is indicated by a yellow highlight on the Disc Due date.

  4. Record VAT adjustments.

    Once you've allocated the payment to the invoice, the discounted VAT amount will remain outstanding on the supplier's account and the full VAT amount will be recorded on your VAT Return.

    To make sure the VAT is recorded correctly on your VAT Return and to clear the outstanding balance on your supplier's account, you'll need to process a credit note for the remaining VAT discounts.

    How you record these VAT adjustment depends on the business processes you want to use. You may want to process them per invoice or enter a number of adjustments as one transaction for a supplier.

    1. Use the Supplier Current Transaction Enquiry workspace to find the transactions that require adjustments.

      See how to do this

      This workspace has two new columns for settlement discount: VAT discount value and VAT Disc Outstanding column. If you filter the VAT Disc Outstanding column by Yes, then only invoices where the outstanding amount is equal to the VAT discount amount are shown.

      You can further filter the workspace by supplier to see which invoices have the VAT discount outstanding. Use this to calculate the value of the VAT discount you need to credit for the supplier.

      Tip: You may need to add the settlement discount columns to the workspace using the column selector.

    2. Enter a credit note for the discounted VAT amount. You can do this for individual transactions or as a single transaction for a customer. This makes sure that the VAT is reported correctly on your VAT Return.

    3. Allocate the credit note to the remaining balance on the invoice(s).

Invoices with full VAT and credit note expected

If your supplier is going to send you a credit note to account for the VAT discount, we recommend that you follow the steps below:

  1. Enter the discount details on the invoice. Sage 200 calculates VAT at the full rate but you can change the VAT value if required. Select VAT adjustment document expected. This indicates that you're expecting to receive a credit note from your supplier and helps you to identify these transactions.

    Depending on the values entered, the Invoice total and Discounted invoice total are calculated. The Disc Inv Total is the amount that you expect to pay within the discount period.

  2. If you qualify for the discount when you pay the invoice, you'll pay the invoice total less the net and VAT discounts. Record the payment and include the net discount amount, but not the VAT. When you allocate the payment to the invoice, the VAT discount will remain outstanding.

  3. Allocate the payment to the invoice. Make sure the Allocate amount of the invoice matches the payment.

    Tip: If you double-click the allocation amount on an invoice or credit note, the allocated amount will automatically be reduced by the net and VAT discount due, if it's still within the settlement discount period. This is indicated by a yellow highlight on the Disc Due date.

  4. Record the credit note for the discounted VAT amount when you receive it and allocate it to the outstanding amount on the invoice.

  5. Allocate the credit note to the remaining balance on the invoice(s).

    Tip:

    To see a list of invoices with credit notes expected, use the Supplier Current Transaction Enquiry. Add and filter the VAT adjustment document expected column.

Invoices with VAT already discounted

If you've paid your supplier, and the invoice you've received already has the VAT discounted, then you need to indicate this when you enter the invoice. This tells Sage 200 to calculate the VAT on the discounted value. In this case there is no need to create additional VAT adjustments.

When you enter the invoice, select Settled immediately. The VAT is calculated on the discounted value. The VAT discount is set to 0.00 as it's already been taken into account.

For an invoice of £100 with a 5% settlement discount, the following values are calculated:

  1. VAT = 19.
  2. Discount value = 5.
  3. VAT discount = 0.
  4. Invoice total = 119.
  5. Discounted value = 114.

Other things to consider

Examples

Note - information

Sage is providing this article for organisations to use for general guidance. Sage works hard to ensure the information is correct at the time of publication and strives to keep all supplied information up-to-date and accurate, but makes no representations or warranties of any kind—express or implied—about the ongoing accuracy, reliability, suitability, or completeness of the information provided.

The information contained within this article is not intended to be a substitute for professional advice. Sage assumes no responsibility for any action taken on the basis of the article. Any reliance you place on the information contained within the article is at your own risk. In using the article, you agree that Sage is not liable for any loss or damage whatsoever, including without limitation, any direct, indirect, consequential or incidental loss or damage, arising out of, or in connection with, the use of this information.