2.2 Sales Discounts and VAT Calculations

Introduction to Sales Discounts

Discounts are common in B2B transactions. They are used to build customer loyalty, clear slow-moving inventory, or speed up cash flow. Bookkeepers must distinguish between trade discounts and prompt payment discounts, as they are calculated and recorded differently.

Trade and Bulk Discounts

A trade discount is a reduction in the catalog list price of goods or services offered to other businesses in the same trade (e.g., wholesalers to retailers) or to regular customers. A bulk discount is a type of trade discount granted for purchasing large quantities.

Key rules for trade and bulk discounts:

• They are negotiated and applied at the point of sale.
• They are shown on the face of the invoice as a deduction from the list price.
• They are not recorded in separate ledger accounts. The transaction is entered directly at the net value (list price minus the trade discount).

Prompt Payment Discounts (PPD)

A prompt payment discount (or cash discount) is an option offered to customers to encourage early payment (e.g., a 2% discount if paid within 10 days, otherwise the full balance is due in 30 days). PPD is calculated on the net invoice value but is not applied at the point of sale since the customer may choose not to pay early. If the customer pays within the discount period, a credit note is issued to adjust the VAT and net values in the ledger.

Value Added Tax (VAT) in the UK

Value Added Tax (VAT) is a tax charged on the sale of goods and services. VAT-registered businesses charge Output VAT on sales and pay Input VAT on purchases. The standard UK VAT rate is 20%, which is the rate tested in the AAT Level 2 syllabus.

The three values on a tax invoice are:

• Net Value: The value of the sale after deducting trade discounts, before VAT (represents 100%).
• VAT: The tax amount, calculated at 20% of the Net value.
• Gross Value: The total amount the customer must pay, representing Net plus VAT (120%).

The Order of Calculations

The order of calculations is non-negotiable. Trade discounts must always be deducted before VAT is calculated. VAT must only be charged on the actual agreed price of the goods, which is the Net price.

The calculation sequence is:

1. Total List Price = Quantity * Unit List Price
2. Trade Discount Amount = Total List Price * Trade Discount %
3. Net Value = Total List Price - Trade Discount Amount
4. VAT Amount = Net Value * 20%
5. Gross Value = Net Value + VAT Amount

Worked Example 1: Standard Sale with Trade Discount

A supplier sells 50 office desks with a list price of £120 each. The customer receives a 15% trade discount. VAT is 20%.

• Step 1: Total List Price: 50 desks * £120 = £6,000.00
• Step 2: Trade Discount Amount: £6,000.00 * 15% = £900.00
• Step 3: Net Value: £6,000.00 - £900.00 = £5,100.00
• Step 4: VAT Amount: £5,100.00 * 20% = £1,020.00
• Step 5: Gross Value: £5,100.00 + £1,020.00 = £6,120.00

The entry in the sales journal will be recorded at the Net value of £5,100.00, VAT of £1,020.00, and Gross of £6,120.00.

Worked Example 2: Tiered Bulk Discount

A manufacturer offers tiered discounts:

• Under 100 items: No discount.
• 100 to 499 items: 5% discount.
• 500 or more items: 10% discount.

A customer orders 600 items at a list price of £10.00 each. VAT is 20%.

• Total List Price: 600 items * £10 = £6,000.00
• Trade Discount: Since the quantity (600) is in the highest tier, a 10% discount applies.
  • Discount Amount = £6,000.00 * 10% = £600.00
• Net Value: £6,000.00 - £600.00 = £5,400.00
• VAT Amount: £5,400.00 * 20% = £1,080.00
• Gross Value: £5,400.00 + £1,080.00 = £6,480.00

Working Backwards from Gross Figures

In exam scenarios, you may be given a Gross figure and asked to find the Net or VAT amounts. Because Gross is Net + VAT (120% of Net), we use the following formulas:

Finding Net from Gross

Divide the Gross figure by 1.20:

• Net = Gross / 1.20
• Example: A customer pays a gross invoice total of £2,400.00.
  • Net = £2,400.00 / 1.20 = £2,000.00

Finding VAT from Gross

Subtract the Net from the Gross, or divide the Gross by 6 (since 20% / 120% = 1/6):

• VAT = Gross / 6
• Example: For a gross total of £2,400.00:
  • VAT = £2,400.00 / 6 = £400.00
  • Verification: Net £2,000.00 + VAT £400.00 = Gross £2,400.00.

Finding VAT from Net

If you are given the Net and need to calculate the VAT directly, multiply by 0.20 or divide by 5:

• VAT = Net * 0.20 = Net / 5