Title: Managing Accounts Receivable Overpayments
The topic below outlines what an overpayment looks like when recording it as a Customer Payment, as well as options for handling the overpayment (either applying to a subsequent invoice, or refunding the overage).
What’s covered in this document:
From the left hand menu select Paid Documents. Completed Invoices will be listed. Select the document to pay, in this case invoice number, 01008. Notice that our payment amount of 3,000.00 is being applied to an invoice amount of $1,801.71. As we select the invoice, the Balance of the Customer Payment will be updated to reflect the selection.
As shown above, there is a remaining balance of $1,198.29 that can be applied to future invoices, or refunded through AP.
Your customer may wish to have you apply the over payment to another invoice. In this case, when you process the next Customer Payment (the payment subsequent to the payment that caused the overpay situation), you will select the open invoice(s) AND the overpayment amount.
In the example below, a review of the Customer Payments list shows an overpayment of $1,198.29 on Customer 1's account. We are going to lessen the subsequent Customer Payment by this overage. In the example below, we will do that related to sample invoice UNANET-00969.
A/R Aging is also showing an overpayment of $1,198.29 for Customer 1:
The amount we would have invoiced next was $101,650.13 for invoice #UNANET-00969, but since we are going to apply the overpayment amount of $1,198.29, they only owe $100,451.84. As a result, they send us a payment in the amount of $100,451.84. We record this payment as outlined below.
After saving the summary screen, we choose Paid Documents in the left menu. We select the invoice we want to apply payment to, Invoice #UNANET-00969, as well as the Customer Payment with the overpayment amount 'CP 44' (where the Document number of the Customer Payment is 44). Once we do this, the Balance for the Customer Payment is $0.00.
When reviewing the A/R aging, Invoice 'Unanet-00969' has been paid in full and there is no credit on the customer's account
A review of the Customer Payments screen no longer shows an overpayment on Customer 1's account.
In this option we will refund the overage amount to the Customer as follows:
The amount over the invoice is saved as an "Unapplied Payment" and the excess amount is credited to the "AR Unapplied Payment Account" specified in the Default Posting Group:
A/R Aging is showing an overpayment of $1,198.29 for Customer 1:
The GL Details Report will also show an overpayment of $1,198.29 for Customer 1.
Go to the Customer Payments screen (Financials > Accounts Receivable) and list the payments for that specific customer. There will be an icon with green + sign on the left of the document on which this over payment was received. Click on this icon.
Clicking on the green icon will take you into the edit mode of this payment, where you can click on Details:
In the detail section, apply the excess amount to the "AR Unapplied Payment Account". Once posted, the result will be a debit and a credit to the "AR Unapplied Payment Account" (yes, debit and credit to the same account). It will also debit the Accounts Receivable account. The A/R Aging report will no longer show the overpayment.
If the Customer Org does not already have a Vendor Profile, go ahead and set that up now in Organization edit, Vendor Profiles:
Enter an AP invoice to pay the customer the excess amount via the Vendor Invoices screen. This will debit the AR write off account.
Click on Details in the left menu. Specify the "AR Unapplied Payment Account" account which will debit this account resulting in off-setting the credit balance in this account. This will also credit the AP payable account and create an item on the AP aging to issue a check to the customer.
This will also credit the AP payable account and create an item on the AP aging to issue a check to the customer.
Follow the same steps as issuing any other vendor check:
KC - Quick Topic - Unapplied Payments - Accounts Receivable and Accounts Payable
Help Docs - Customer Payments