Skip to content
logo Knowledgebase

Record customer receipts and allocations

Created on  | Last modified on 

Summary

How to post customer receipts in Sage 50 Accounts.

Description

The Customer Receipt window helps you easily record receipts 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 receipt value over multiple invoices.

From here you can also allocate outstanding credit notes (SC) and outstanding payments on account (SA) to invoices (SI).

Resolution

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

    AccountFrom the drop-down list choose the customer record.
    DateEnter the date required for the receipt.
    AmountLeave the Amount value as 0.00.
    ReferenceEnter 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 customer receipt, on the relevant invoice line, select the Receipt box then click Pay in Full
    • If you want to post part of the invoice as a customer receipt, on the relevant invoice line, select the Receipt box and enter the amount you want to post then press TAB on your keyboard
  2. Click Save then click Close.
 TIP: If you're adding bank charges to your customer invoice, follow our handy guide.


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 Customer receipt

Account*From the drop-down list choose the customer record.
Date*Enter the date required for the allocation.
AmountLeave the Amount value as 0.00.
ReferenceLeave this box blank, as this doesn't create an additional transaction.
Ex. ReferenceLeave 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 Receipt box > Pay in Full. Then on the relevant invoice line, select the Receipt box > Pay In Full
  • If you want to allocate part of the credit or payment on account, on the relevant line in the Receipt box , enter the amount you want to allocate > press TAB on your keyboard. Then on the relevant invoice line, enter the amount you want to allocate in the Receipt box > 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 receipt

  1. Open the Bank accounts module then click Customer receipt.
  2. Complete the Customer Receipt window as follows:

    AccountFrom the drop-down list choose the customer record.
    DateEnter the date required for the allocation.
    AmountLeave the Amount value as 0.00.
    ReferenceEnter the reference for the transaction.
    Ex. ReferenceEnter 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 Receipt box > Pay in Full. Then on the relevant invoice line, select the Receipt box > Pay In Full.
    • If you want to allocate part of the credit or payment on account, in the Receipt box on the relevant line, enter the amount you want to allocate > press TAB on your keyboard. Then on the Receipt 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 Receipt appears in the Analysis Total.
  3. 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.
  4. Click Close.

Transactions don't appear or are grouped

If there are transactions on the customer account which don't appear in the Customer Receipt window, you must check the following:

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

  1. Open the Customers module and select the relevant customer 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 Customer receipts 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



Upgrading your licence

Need a little more room? To add extra companies, users, employees or more to your software licence, leave your details and we'll be in touch.

Leave your details

Image