How to manually record customer refunds - Sage 50 Accounts and Sage Instant Account v14 and above
QUESTIONOccasionally, you may need to return money to your customers and record this in your accounts. For example, the customer has returned some faulty goods that they have already paid for, or overpaid their account.
Note: This article only applies to Sage 50 Accounts and Sage Instant Accounts v14. If you are using an earlier version of Sage Accounts, please refer to Ask Sage Article 11468. If you prefer to automatically record the refund, please refer to Ask Sage Article 11491 - How to use the Write Off, Refund and Returns Wizard.
ANSWER
This article contains the following sections:
How identify what transactions you need to post - This section explains the different possible scenarios and the transactions you must to post to successfully record your refund.
To post a sales credit - This section explains how to post a sales credit.
To post a sales refund - This section explains how to post a sales refund.
VAT Cash Accounting scheme - To post a manual sales refund if the receipt you are refunding is dated prior to 1 December 2008 - This section only applies if you are using the VAT Cash Accounting scheme.
Note: The non-vatable tax code, T9 by default, is used when transactions are not to appear on the VAT Return. To check your non-vatable tax code, open the Settings menu, choose Company Preferences then click the VAT tab. The non-vatable tax code appears and, if necessary, can be amended.
How
to identify what transactions you need to postTo successfully use the table below, you should view the customer's activity and identify the transactions relating to the money being returned.
@@@@
| Transactions |
Examples |
Transactions to post |
| SI and SR |
You have an invoice on the customer's account and a payment has been allocated to it, the goods are faulty, have been returned and you must now send the customer a refund.
You have an invoice on the customer's account and a part payment that has been allocated to it. For example, the customer paid a deposit, was sent the goods which they have subsequently returned and they now want their deposit refunded.
You have an invoice on the customer's account and a payment that has been allocated to it. Part of the shipment has been returned and you now want to refund the money. |
Sales credit
Sales Refund |
| SA or SR |
A customer has overpaid an invoice, and the amount overpaid has been returned.
There is an outstanding payment on account on the customer's account, for example, a deposit and the money has been returned.
You have received a payment from a customer and the cheque has subsequently bounced.
You have received a payment from a customer and they have now stopped the cheque. |
Sales Refund |
| SC |
A customer has an outstanding credit on their account and rather than set the money against a future invoice it has been returned.
For example, a customer has paid an invoice, a credit has been raised because the goods were faulty and the money has subsequently been returned. |
Sales Refund |
Note: If only part of the amount is being refunded, you should process the refund transactions for the amount being refunded.
Once you have posted all of the refund transactions required, you should then allocate together any related outstanding transactions on
the customer's account. For further information about this, please refer to Ask Sage Articles:
11712 - How to allocate a payment on account or credit to an invoice - Standard VAT
11754 - How to allocate a payment on account or credit to an invoice - VAT Cash Accounting
To post a sales credit In the following example, you invoiced Bloggs Ltd for £117.50, inc VAT at 17.50% which is now being refunded.
Note: If you need to produce a credit note to either send to your customer, update your stock, or both, you should create and update this
from the Invoicing module and omit this section.
1) Open the Customers module then from the Links pane click Batch Credit.
The Batch Customer Credits window appears.
2) Enter the relevant details on the Batch Customer Credits window. You must use the same nominal code, tax code, net and VAT amounts as
the original invoice, for example:
| A/C |
Date |
N/C |
Details |
Net |
T/C |
VAT |
| BLOGGS |
Date |
4000 |
Refund |
100.00 |
T1 |
17.50 |
3) To post the credit, click Save.
4) To close the Batch Customer Credits window and return to the Customer window, click Close.
You have now posted the sales credit to reverse the effect of the original invoice from your Nominal Ledger and if you are on the
Standard VAT scheme this corrects your VAT Return.
To post a sales refund Note: VAT Cash Accounting - If you are refunding a standard VAT rated sales receipt dated prior to 1 December 2008, and the refund is
dated after this date. Please refer to the section VAT Cash Accounting scheme - To post a manual sales refund if the receipt you are
refunding is dated prior to 1 December 2008.
1) Open the Customers module then from the Tasks pane click Customer Refund.
The Customer Refund window appears.
2) Complete the Customer Refund window as follows:
Bank A/C Ref |
If required, enter an alternative bank reference, or press F4 then from the drop-down list choose the required bank and click OK. |
Tax Code
VAT Cash Accounting only |
You should use the same tax code as the original invoice and payment. The default customer tax code appears by default, if required, to change this from the drop-down list choose the required tax code. |
| Date |
The current program date appears by default. If required, enter a new date or select a date from the calendar, for example, the date of the refund. |
| Cheque No |
Enter up to a 12 character reference for the transaction here, for example, the cheque number.
Note: If you are using the Print Cheque option you should not enter anything into the Cheque No. box |
| Payee |
Enter the customer's account reference, or press F4 then from the drop-down list choose the required customer and click OK. |
| Amount box |
Enter the value of the customer refund. This should be the full cheque value, in this example, £117.50. |
Tip: If required, to allocate a department to the transaction, click Dept, press F4 then from the drop-down list choose the required
department and click OK.
3) To post the customer refund, click Save.
Sage 50 Accounts Plus and Accounts Professional - To print a cheque click Print Cheque, enter the payee details then to post the customer
refund, click Save.
4) To close the Customer Refund window, click Close.
You have now posted the sales refund. This records the money coming out of your bank account, corrects the balance on the customer's account and if you are using the VAT Cash Accounting scheme corrects your VAT Return.
VAT Cash Accounting scheme - To post a manual sales refund if the receipt you are refunding is dated prior to 1 December 2008
To post the sales invoice1) Open the Customers module then from the Links pane click Batch Invoice.
The Batch Customer Invoices window appears.
2) Enter the details on the Batch Customer Invoices window. You must use the date that the money is to be returned to the customer,
and the same tax code, net and VAT amounts as the original receipt, for example:
| A/C |
Data |
Ref |
N/C |
Details |
Net |
T/C |
VAT |
| BROWN |
Date |
Refund |
9999 |
Refund |
117.50 |
T1 |
17.50 |
3) To post the invoice, click Save.
4) To close the Batch Customer Invoices window, click Close.
This sales invoice corrects the balance on the customer's account and posts a balance to the Mispostings Account nominal code.
The sales invoices are not included on the VAT Return.
You must now post a bank payment to reduce your bank balance and clear the balance on the Mispostings Account nominal code.
To post the bank payment1) Open the Bank module then click Payment.
2) The Bank Payments window appears.
Enter the relevant details on the Bank Payments window, for example:
| Bank |
If required, enter an alternative bank reference, or press F4 then from the drop-down list choose the required bank and click OK. |
| Date |
The current program date appears by default. If required, enter a new date or select a date from the calendar, for example, the date of the refund. |
| Ref |
Enter a reference for the transaction here, for example your cheque number. |
| N/C |
Enter the Mispostings Account nominal code, 9999 by default. |
| Details |
Enter the details for the transaction here, for example, the reason for the refund. |
| Net |
Enter the net amount of the refund. |
| T/C |
You should use the same tax code as the original receipt, for example T1. |
| Tax |
The VAT amount defaults to the new 20% rate, for example 20.00. You must change this to match the amount on the original receipt, for example 17.50 |
3) To post the bank payment, click Save.
4) To close the Bank Payments window, click Close.
This bank payment reduces the balance on your bank account by the amount refunded to your customer and corrects the balance on the
Mispostings Account nominal code. This transaction also reverses the effect of the original sales receipt on your next VAT Return.