Skip to content
logo Knowledgebase

Record supplier payments and allocations

Created on  | Last modified on 

Summary

How to post supplier payments in Sage 50 Accounts.

Description

The Supplier payment window helps you easily record payments and allocate them to the relevant invoices. You can see what the oldest outstanding invoices are so that you can clear these invoices first or you can even spread the payment value over multiple invoices.

From here you can also allocate outstanding credit notes (PC) and outstanding payments on account (PA) to invoices (PI).

Resolution

  1. Click Bank accounts and select the account to be used for the allocation then click Supplier payment.

    Account From the drop-down list choose the supplier record.
    Date Enter the date required for the payment.
    Amount Leave the Amount value as 0.00.
    Reference Enter a reference if required.
    Ex Reference  Enter and extra reference if required. (v28.1 and above)

    • If you want to post the full amount of the invoice as a supplier payment, on the relevant invoice line, select the Payment box then click Pay in Full
    • If you want to post part of the invoice as a supplier payment, on the relevant invoice line, select the Payment box and enter the amount you want to post then press TAB on your keyboard 
  1. Click Save then click Close.

 


Allocate credits notes or payments on account to invoices

  1. Open the Bank accounts module and select the account to be used for the allocation then click Supplier payment.

Account* From the drop-down list choose the supplier record.
Date* Enter the date required for the allocation.
Amount Leave the Amount value as 0.00.
Reference Leave this box blank, as this doesn't create an additional transaction.
Ex. Reference Leave this box blank as this don't create an extra transaction.
*This information is mandatory.

 

  • If you want to allocate the full amount of the credit or payment on account to the invoice, on the relevant credit or payment on account line, select the Payment box then click Pay in Full. Then on the relevant invoice line, select the Payment box then click Pay In Full
  • If you want to allocate part of the credit or payment on account, on the relevant line in the Payment box , enter the amount you want to allocate then press TAB on your keyboard. Then on the relevant invoice line, enter the amount you want to allocate in the Payment box then press TAB on your keyboard
  1. Click Save.

If you use the VAT Cash Accounting scheme and there's a mismatch in the tax codes within your allocation the following message appears:

      'There's a mismatch in the net/tax elements of the payment selected. Please ensure that the tax codes of any credit notes/payments on account are matched against invoices to which they're to be allocated.'

You can't allocate transactions with different tax codes. If a transaction has an incorrect tax code, you can amend this for more information please refer to our help guide.


Allocate credits or payments on account to outstanding invoices and post a payment

  1. Open the Bank accounts module then click Supplier payment.
  2. Complete the Supplier payment window as follows:

    Account From the drop-down list choose the supplier record.
    Date Enter the date required for the allocation.
    Amount Leave the Amount value as 0.00.
    Reference Enter the reference for the transaction.
    Ex. Reference Enter and extra reference if required. (v28.1 and above)
    • If you want to allocate the full amount of the credit or payment on account to the invoice, on the relevant credit or payment on account line, select the Payment box then click Pay in Full. Then on the relevant invoice line, select the Payment box then click Pay In Full
    • If you want to allocate part of the credit or payment on account, in the Payment box on the relevant line, enter the amount you want to allocate then press TAB on your keyboard. Then on the Payment box on the invoice line, enter the amount you want to allocate to the invoice. This should include the value of the credit or payment on account. Press TAB on your keyboard and the amount of the Payment appears in the Analysis Total
  1. Click Save.

    If you use the VAT Cash Accounting scheme and there's a mismatch in the tax codes within your allocation the following message appears: 'There is a mismatch in the net/tax elements of the payment selected. Please ensure that the tax codes of any credit notes/payments on account are matched against invoices to which they are to be allocated.' You can't allocate transactions with different tax codes. If a transaction has an incorrect tax code, you can amend this for more information please refer to our refunds guide.
  2. Click Close.

Transactions don't appear or are grouped

If there are transactions on the supplier account which don't appear in the Supplier payment window, you must check the following:

Check the supplier's activity to ensure the transaction is either outstanding or part paid

  1. Open the Supplier module and select the relevant supplier account then click Edit and click Activity.
  2. Locate the transaction and check the O/S column for the amount outstanding on the transaction.

Check for grouped transactions

  1. On the menu bar click Settings then click Bank Defaults.
  2. Select List Payment/Receipt by split then click OK.
  3. Open the Bank account module and click Supplier payments and check if the transaction now appears.

Check for data corruption

  1. On the menu bar click File then click Maintenance, if required, click Yes to close any open windows.
  2. Click Check Data.
  3. If any errors, warnings or comments appear, please refer to https://my.sage.co.uk/public/mydata.aspx

 


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