Payment (Settlement) Discount - VAT Calculation

Scenario: Posting a purchase invoice from a supplier say for £1000, the supplier also offers 2% payment discount if the payment is made within 8 days, the actual supplier invoice assume the lower VAT amount.

Note: VAT legislation in the UK states to always assume the lower vat amount i.e. £171.50 (even if you do not take the payment discount)

	Without Discount	With Discount
Amount	£  1000.00	£  980.00
VAT Amount	£  171.50	£  171.50
Total Amount	£  1,171.50	£  1,151.50

 

Following three steps involved in setting up NAV to accommodate above scenario.

1)     General Ledger Setup

2)    Payment Terms Setup

3)    Customer Card Setup or Payment Discount % in Invoice Page.

General Ledger Setup

 

Pmt. Disc. Excl. VAT: Place a check mark in this check box; so that the payment discount is calculated on amounts excluding VAT.

VAT Tolerance %: The value in this field needs to be at least as high as the maximum settlement discount % you will be offered (purchase order processing) and offering (sales order processing).

 

Payment Terms Setup

Discount Date Calculation: If you enter a date formula here, the program will automatically calculate a payment discount date when an invoice is created. The date indicates the deadline for receiving a payment discount.

Discount %: Here you can enter the percentage of the invoice amount. The program will automatically calculate a possible payment discount when you post an invoice. If payment occurs on or before the payment discount date, the program will apply the payment discount when you post the payment of the invoice.

 

Customer Card Setup or Payment Discount % in Invoice Page.

You could select a payment terms code with Discount % against the vendor card. The program will automatically calculate a possible payment discount when you post an invoice.

You could also manually enter Payment Discount % in the purchase invoice without being predefined under Payment Terms Setup.

 

Example: Below screenshots illustrates above scenario with the relevant settings in place.

·         Purchase Invoice

·         Statistics

·         Posted the purchase invoice.

·        Document Date: 27/01/2011 | Pmt. Discount Date: 04/02/2011; in line with payment terms.

·         Payment is made on 07/02/2011 (Outside discount tolerance)

·         Posted payment journal.

·         Vendor Ledger Entries

As you could see from above, with the right settings in place, NAV does consider lower VAT amount automatically.