{"id":31221,"date":"2025-09-15T10:29:49","date_gmt":"2025-09-15T10:29:49","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=31221"},"modified":"2025-09-15T10:44:44","modified_gmt":"2025-09-15T10:44:44","slug":"how-to-record-a-write-off-and-an-over-payment-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/09\/15\/how-to-record-a-write-off-and-an-over-payment-in-sage-x3\/","title":{"rendered":"How to Record a Write-off and an Over-payment in Sage X3"},"content":{"rendered":"\n

In accounting and finance, handling invoices and payments is part of the daily routine\u2014but it\u2019s also one of the most important tasks for keeping books accurate. Sometimes, businesses face situations where small amounts need to be written off, whether due to bad debts, rounding differences, or even over-payments. Knowing how to record these write-offs correctly during payment entry in Sage X3 helps ensure your financial records stay clean and reliable. Below are five practical steps and best practices to manage write-offs effectively.<\/p>\n\n\n\n

The first step is to set up a Payment attribute.<\/strong> This will define how the amount should be posted to the general ledger and ensure everything flows correctly in the accounts.<\/p>\n\n\n\n

1.  Go to Setup > A\/P-A\/R Accounting > Payment Attributes<\/strong>.<\/p>\n\n\n\n

2. Create a new Payment Attribute and set the code as \u201cWOFF\u201d<\/strong> (short for Write -off<\/strong> small balances). Use the account structure Account \u21ff BP<\/strong>. This setup ensures that the write-off amount is posted to a designated GL account through the Accounting code, rather than going directly to the bank account.<\/p>\n\n\n\n

\n
\"Payment
Fig01: Payment Attribute<\/strong><\/figcaption><\/figure>\n<\/figure>\n\n\n\n

3. From the Accounting code<\/strong> field, you can jump to the Payment Attribute Accounting Code setup. Create a new code called WODIFF<\/strong> and link it to the GL account you want to use for tracking over-payments and underpayments.<\/p>\n\n\n\n

\n
\"Accounting
Fig02: Accounting Codes<\/strong><\/figcaption><\/figure>\n<\/figure>\n\n\n\n

Example 1: Writing off a balance<\/strong>
Let\u2019s say a customer makes a payment that\u2019s slightly less than the invoice amount, leaving behind a small balance we don\u2019t plan to collect. For instance, the invoice is for $50<\/strong>, but the customer only pays $49<\/strong>. In this case, we\u2019ll write off the remaining $1<\/strong>.$49<\/strong><\/p>\n\n\n\n

When entering the payment transaction:<\/p>\n\n\n\n

The REC line<\/strong> should reflect the actual payment received ($49<\/strong>).<\/p>\n\n\n\n

For the write-off, enter the details as follows:<\/p>\n\n\n\n