Sage Intacct

Processing refunds to a customer

From time to time, you may need to refund a customer, perhaps because of overpaying an invoice or you have received an advance that was never used.

There are various scenarios that may arise, but this Sage Intacct Help Sheet is designed to cover the most common, if you have a specific query that does not meet the criteria documented please contact the support team.

Our consultancy team can design a more automated process for you, for more information please contact your Customer Success Manager. Details of how to process these within Intacct is covered in section 2.

1. Manually processing a refund

In this example an Invoice for £1200 was posted and a BACS receipt posted for £2400, making a £1200 overpayment.

Screenshot 1

To clear the customer’s balance to zero you will need to navigate to Accounts Receivable, All, Adjustments and post a non-vatable debit memo adjustment.

Change the date if required, select the customer and the originating Sales Invoice number, this is not mandatory, it is purely for reference.

If you have assigned Document Sequencing for adjustments the Adjustment number will say –New--, otherwise enter a reference that you can use to track the transaction.

Select suspense, or a dedicated customer refunds code if you have one. There is no VAT implication so use the code No VAT Output Tax Detail code.

The adjustment will increase the balance on the customer.

Screenshot 2

Allocate the adjustment to the overpayment by navigating to Accounts Receivable, All, Receive Payments – New! Select the Customer, enter the date(s) if not using today’s date, and then click on the Select invoices button.

Tag the adjustment if there are more invoices and transactions outstanding and click on Add & close.

Screenshot 3

In the Invoices selected for payment section enter the amount in the Credits to apply box. If there are more credits available to ensure you select the correct one click on the Credits available hyperlink.

Screenshot 4

The overpayment is available to allocate to the Adjustment. Tag this and the Credits to apply will update to the required value. Click on Save.

Screenshot 5

The adjustment will now have a credits to apply value and an outstanding amount of 0.00.

Screenshot 6

Click on Post.

The original payment will now be fully applied.

To record the refund in the bank, post a journal to credit the bank and debit suspense, or the GL account used on the adjustment.

The original adjustment postings were:

Screenshot 7

In the Entries section you can optionally select the customer dimension.

Screenshot 8

 

2. Processing a refund using the automated process

This document assumes that the Customer Refunds Enhancements package has already been installed and the REFD journal type already exists.

The Customer refund functionality is used where you grant a refund for a late credit or overpayment by the customer.

It may also be used where a payment has been rejected by the bank after it has been processed and you do not wish to void the whole payment batch to reverse it.

Refunding a customer - Missing Screenshot 1

Navigate to Accounts Receivable, All, Adjustments and post an adjustment with type debit memo. The adjustment will increase the balance on the customer.

Enter the required description and select the Customer Refund checkbox, the account that the money has been refunded from in the Refund into Account dropdown and any refund reference.

Select suspense, or a dedicated customer refunds code if you have one. There is no VAT implication so use the code No VAT Output Tax Detail code.

Click Post. There are several validation steps that the software will undertake. If you are presented with an error, review the message, and correct your input.

Review the GL postings – the double entry will debit the Debtors Control Account and credit the suspense, or dedicated customer refund account.

 

Screenshot 10

The Customer refunds package ensures that the relevant journal (REFD) is posted between the bank and the chosen GL account to reverse the initial credit to that account.

To view the journal, General Ledger, All, Journal Entries and click View Transactions next to the Refund Journal.

Screenshot 11

Two transactions will have been created, one for the zero value VAT amount and one for the net amount of the refund.

Screenshot 12 (1)

Refunding a customer - Missing Screenshot

The net value journal, above, reverses the original credit from the Suspense account and posts a credit to the bank account to show the money leaving the account.

 

Need a helping hand?

If you're encountering any issues or require additional support when refunding a customer in Sage Intacct make sure to get in touch with our support team.