How to match or allocate a batch customer credit against a batch customer invoice

When you enter a batch credit note against a customer record, you would normally match it to an outstanding customer invoice. This explains how to match or allocate credit notes to outstanding invoices within the Customer Receipt window.

Watch the video

 TIP: This video is part of the free Sage University course Batch Invoices and Credits. To sign up for the full course, or see other free Sage University training courses.

Follow the steps

1. Click Bank accounts and click Customer receipts.
2. Complete the window as follows:
   
   

   Account Ref	As no money is posted to or from the bank account, you can select any bank account.
   Account	From the drop-down list choose the customer 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.

3. Allocate the full amount of the credit to the invoice:
   
   • To allocate the full amount of the credit to the invoice - on the relevant credit account line, select the Receipt box and click Pay in Full. On the relevant invoice line, select the Receipt box and click Pay In Full.
     or,
   • To allocate part of the credit - On the relevant line in the Receipt box, enter the amount you want to allocate and press the TAB key on your keyboard. Then on the relevant invoice line, enter the amount you want to allocate in the Receipt box and press the TAB on your keyboard.
4. Click Save then click Close.

NOTE: 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, use our handy How do I correct an audit trail transaction? to edit it.

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.