Sage-Partner-for-header

How to Issue Refunds for Overpayments in Sage X3

Issue Refunds for Overpayments

How to Issue Refunds for Overpayments in Sage X3

Most of our time is dedicated to following up on payments after sending out invoices. Resources like the Bad Debt Management and AR Write-offs blog are valuable in managing accounts receivable. Occasionally, customers not only settle their dues but also overpay. Let’s explore how to handle overpayments.
Dealing with overpayments offers several avenues. If the agreement with the customer permits, you can apply the amount to an existing invoice. Alternatively, the customer might request that the overpayment be left on account for future transactions. But what if there’s no ongoing business with the customer, or they demand a refund?
One approach is to generate a BP customer invoice matching the overpayment and link it accordingly. Then, produce a BP supplier invoice for the same amount. Finally, an AP check will be issued to settle this invoice, treating it like any other supplier invoice.
Another option is to issue a check against the overpayment directly.

Say we have a $5,000 invoice and receive a $6,000 payment which we record in Payment/Receipt Entry (GESPAY) using Transaction Type Check Receipts (RECCH). This function is found under A/P-A/R Accounting, Payments. The $1,000 overpayment amount has an Attribute of REC and no Type or Entry values.

How to Issue refunds for overpayments in Sage X3 image-1
The Financials, Journals, Journal Entry (GESGAS) shows that the $1,000 overpayment is now sitting in the AR account 12100.
How to Issue refunds for overpayments in Sage X3 image-2

If we go to Financials, Matching, Manual Matching (LETTRAGE), select Account 12100 (AR), the $5,000 invoice and the $5,000 portion of the payment are under Matched with the Matching code A.

How to Issue refunds for overpayments in Sage X3 image-3

The overpayment amount of $1,000 is all by itself under Not matched.

How to Issue refunds for overpayments in Sage X3 image-4
How do we generate a check for the overpayment while the $1,000 sits in the AR account?
It’s back to A/P-A/R accounting, Payments, and Payment/Receipt entry (GESPAY). Select an AP payment entry type to begin a new Payment/ Receipt entry. For this example, I’ll use PAYAT.
How to Issue refunds for overpayments in Sage X3 image-5

Select ‘New’ and enter the appropriate Site, BP Customer (1), and Bank information. Notice, that the Account (2) is the AR account even though this is to be an AP check payment. The BP amount is the overpayment amount of $1,000 (3). On the grid, Attribute (4) is Pay and Type (5) is RECPT.

How to Issue refunds for overpayments in Sage X3 image-6

Before we proceed, we need to review the Type found under Setup, Financials, Document types (GESGTE). Type must have Open item management checked. If not checked, you won’t be able to drill down into Entry to select the receipt journal or type in the receipt’s journal entry number.

How to Issue refunds for overpayments in Sage X3 image-7

Once you type in or use the lookup to retrieve the overpayment receipt, the overpaid balance auto-fills in the Amount and Allocated to BP fields, you can now save, print the check and post.

How to Issue refunds for overpayments in Sage X3 image-8

Next, the payment and overpayment can be matched in Manual Matching.

How to Issue refunds for overpayments in Sage X3 image-9

I hope this helps you manage your overpayments.

About Us

Greytrix Africa is a leading Sage business partner and ISV Partner offering Consulting, Implementation, and development services for Sage X3, Sage 300, Sage 300 People (HRMS), Sage CRM, and Sage Intacct, which covers East Africa, West Africa, SADC, and Middle East region. We offer professional services such as Implementation and Configuration, Business Process Analysis, Project Management, Integrations and Migrations, and Technical & Functional Support, along with enhancements within Sage X3, Sage 300 People (HRMS), Sage 300, Sage CRM, and Sage Intacct across various industry verticals like Process Manufacturing (Food & Beverages, Chemical), Discrete manufacturing (Automotive, Textile & Apparel), Non-Profit, Health-care Industry and Services Industry (Financial, Software & Engineering), Distribution (Transportation & Logistics), and Agriculture.

Our Partners

Get In Touch

Get In Touch

Thank you for contacting us.

Be ready to explore some leading business management solutions that will help shape the future of your business!

Our team will get in touch with you shortly.

Get In Touch

Thank you for downloading Sage X3 Brochure

The brochure is sent successfully on your registered  Email Id.

Download Free Sage X3 Brochure