Error - 'There is a mismatch in the net/tax elements of the payments selected'

Summary

How to resolve this message in Sage 50 Accounts.

Description

If you use the VAT Cash Accounting scheme, when you try to allocate transactions that have different tax codes or VAT calculations this message may appear.

To allocate transactions together on VAT Cash Accounting, you must ensure they have the same tax code and VAT calculation. This is necessary to calculate the VAT value correctly on the payment or receipt and maintain correct nominal balances.

You can amend the tax code, but if the tax codes are correct, there's no need to correct the transactions. Pay the invoice with a payment that has the same tax code, and refund the original payment to ensure that the VAT Return is correct.

 TIP: Ensure the List Invoice/Credit by item line is selected in Settings>Bank Defaults. This displays the tax codes in the T/C column in the Customer Receipt and Supplier Payment windows.

Resolution

Amend the tax code or VAT value on a transaction

If the transaction has been VAT reconciled then it can't be edited. In this situation the transaction must be reversed and, if required, re-entered.

  1. Click Transactions and select the required transaction then click Edit.
  2. Select the required transaction in the bottom pane and click Edit.
  3. From the T/C drop-down, choose the tax code as required or amend the value in the Tax box.

    If prompted to recalculate the Tax, click Yes or No as required.

  4. Click Close then click Save and click Yes.
Refund the transaction
You must use the same tax code to refund the payment on account and then pay the original invoice with the same tax code. For example, if the payment on account uses tax code T0 the refund must also use T0 and if the invoice uses tax code T1 the payment must also use T1.

The example shown below is to refund a customer payment on account. If you need to refund a supplier payment on account replace customer with supplier.

  1. Click Customers and click Refund.
  2. Complete as follows:

    BankSelect the same bank account that the sales payment on account transaction was posted to.
    PayeeSelect the customer account.
    Tax CodeSelect the same tax code as the transaction you're refunding.
    DateEnter the same date that the sales payment on account transaction was created on.
    ValueEnter the amount of the refund
  3. Click Save.

    You now need to allocate the refund transaction to the sales payment on account.

  4. Click Bank accounts and click Customer receipt.
  5. Click the Account drop-down list, choose the customer account.
  6. Enter the full refund value in the Receipt column on both the SA and SP transactions.
  7. Click Save then click Close.

    You must now pay the invoice with a payment which uses the same tax code as the invoice.

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Image

Solution Properties

Solution ID
200427112205946
Last Modified Date
Mon Oct 23 10:14:09 UTC 2023
Attributes
Product Details
Modules: Bank
Modules: VAT
Views
0