Reverse Payment in Sage 50: Quick Ways to Correct Payments

Updated On: March 10, 2026 10:32 am

Accurate payment recording in Sage 50 is critical for maintaining reliable Accounts Receivable, Accounts Payable, and General Ledger balances. However, errors like incorrect amounts, duplicate payments, or misapplied invoices may require payment reversal. In such cases, Sage 50 does not permit deletion of posted payments. Instead, you must reverse payment in Sage 50 using reversal mechanisms that generate offsetting entries and preserve the original transaction for audit trail integrity.

This step-by-step guide explains how to reverse payment in Sage 50, including customer receipts, vendor payments, and reconciled transactions, and payments recorded in prior accounting periods. Each method ensures compliance with accounting standards while maintaining data accuracy and financial transparency.

What does it mean to reverse a payment in Sage 50?

Reversing a payment in Sage 50 simply means canceling a payment that you entered earlier, but without deleting it from the system. The system preserves the source document to maintain audit trail integrity, restores the related Accounts Receivable or Accounts Payable balance, and reopens the associated invoice or bill. This process ensures accurate financial reporting, maintains accounting period compliance, and preserves full Sage 50 reverse transaction traceability within the General Ledger.

When should you reverse a payment in Sage 50?

A payment reversal becomes necessary under the following validated accounting scenarios:

• Payment was applied to the wrong customer or vendor.
• An incorrect amount was entered (overpayment or underpayment).
• Payment was recorded with the wrong date or accounting period.
• Duplicate payment entry was posted by mistake.
• Bank returned the payment (NSF cheque, rejected transfer, or chargeback).
• Payment was applied to the wrong invoice.
• The wrong bank account or ledger account was selected.
• Security or audit correction is required after review.

In short, you should reverse a payment whenever leaving it unchanged would cause inaccurate balances in Accounts Receivable, Accounts Payable, or the General Ledger.

Prerequisites before reversing a payment in Sage 50

Before you reverse payment in Sage 50, verify the following:

• Ensure the payment is posted in an open accounting period.
• Confirm the transaction is not bank reconciled.
• Check that it is not part of a locked deposit.
• Verify user permissions to modify or void transactions.
• Review linked invoices, credits, or adjustments.
• Identify if the situation requires a negative entry instead of a void.
• Along with that, create a company file backup.
• Understand the financial impact on A/R, A/P, or the General Ledger.

These checks help you safely undo payment Sage 50 without disrupting financial reports.

Also Read: Export Invoices from Sage 50 to Excel

How to reverse a customer payment in Sage 50 (Accounts Receivable)

Customer payment reversal in Sage 50 is executed by voiding the posted receipt transaction. The system does not delete the original record. Instead, it posts a controlled offset entry to maintain audit trail integrity and restore the customer’s open balance.

Below are the two valid procedural approaches to reverse payment in Sage 50:

Method 01: Void Receipt from Accounts Receivable Module

Use this direct A/R method to perform a Sage 50 reverse transaction:

• Navigate to Customers & Sales from the main navigation panel.
• Open the Receipts (Receive Money) transaction window.
• Click Select (Ctrl + F) to initiate transaction lookup.
• Enter the receipt number, customer name, or appropriate date range filter.
• Click OK to generate the filtered transaction list.
• Select the required posted receipt and click Select to open it.
• In the transaction window, access the Receipts menu from the top toolbar.
• Choose Void Receipt to initiate reversal.
• Confirm the void action when prompted to complete the process.

The receipt must be unreconciled, posted in an open period, and not linked to a locked deposit or restricted account.

Method 02: Void Payment via Transaction Lookup (Alternative Access Path)

Alternatively, you can undo payment Sage 50 using Transaction Lookup:

• Open the Transaction Lookup window from the main menu.
• Enter the payment reference number, customer name, or apply date filters.
• Click OK to retrieve the matching transaction records.
• Select the appropriate customer payment from the results list.
• Click Select to open the transaction in detail view.
• In the transaction window, access the Transaction menu on the top toolbar.
• Choose Void (Void Payment) to initiate the reversal process.
• Confirm the void action to finalize the payment reversal.

Keep in Mind: Applicable only if the payment is unreconciled, within an open fiscal period, and permitted by user security settings.

Method 03: Reverse Customer Payment Using Negative Receipt Entry (NSF / Bank Return Case)

Use when the bank reverses a deposited payment (e.g., NSF cheque, stale-dated cheque, or returned deposit) and the original receipt should not be voided directly.

• Navigate to Customers & Sales>>Receipts.
• After that, select the relevant customer.
• From the top menu, choose Receipts>>Include Fully Paid Invoices/Deposits.
• Change the ‘Paid By’ field to ‘Cash’.
• Select the appropriate Deposit To account.
• Update the Receipt No. field (e.g., NSF, Reversed, Void) for audit tracking.
• Change the transaction date to match the bank reversal date.
• Locate the original invoice and enter the amount as a negative value in the Amount Received column.
• Add comments explaining the reason for the reversal.
• Click Process/Post to complete the transaction.

Also Read: How to Connect Microsoft Power BI to Sage 50?

How to reverse a vendor payment in Sage 50 (Accounts Payable)

Vendor payments follow similar rules. To reverse payment in Sage 50 for vendors, use either the Void method or a negative payment entry.

Method 01: Void Payment (Primary & Recommended Method)

Use this method when the payment is unreconciled, in an open fiscal period, and no bank reversal has occurred.

1. Navigate to Vendors & Purchases>>Payments.
2. Click Select (Ctrl + F) to search for the posted payment.
3. Apply filters such as Payment Number, Vendor Name, or Date to quickly locate the transaction.
4. Open the payment entry to review the transaction details.
5. From the Payments menu, select Void Payment.
6. Confirm the void action to complete the reversal.

After confirmation, Sage 50 will automatically reverse the payment and reopen the associated invoice

Method 02: Reverse Using Negative Payment Entry (For Bank Returns / NSF)

This method is used when a direct void is not possible or when the bank has reversed the payment.

• Go to Payables (Vendors & Purchases) and then select Payments.
• Choose the vendor whose payment needs to be reversed.
• From the top menu, click Payment and select Include Fully Paid Invoices/Prepayments to display previously paid invoices.
• Change the ‘Paid By‘ field to ‘Cash’.
• In the From field, select the correct bank or general ledger account where the reversal should be recorded.
• In the Receipt Number field, enter a reference such as NSF, Reversed, Void, or Stale-dated for proper audit tracking.
• Modify the Date to match the date on which the bank reversed the payment.
• In the Payment Amount column, select the original invoice and enter the amount as a negative value.
• Add an appropriate Comment explaining the reason for the reversal.
• Then click Post to complete the transaction.

How to reverse a payment after bank reconciliation?

Before you start, ensure the following:

• Your service plan includes Sage 50 Cloud to access the reverse reconciliation feature.
• The reverse button is not available in versions 2020.1 or earlier.
• If reversing multiple reconciliations, handle them one at a time.
• Create a backup of your company file to prevent any accidental data loss.

Only after this step can you properly reverse payment in Sage 50.

How to Reverse a Bank Reconciliation in Sage 50 Accounts?

• Open the Banking Module and select Reconcile Accounts.
• After that, choose the bank account you want to reverse.
• Click Reconciliation and select Void Last Reconciliation, or click the Void Reconciliation icon.
• In the information window, click View Account Reconciliation Detail Report to review the details.
• Save or print the report for your records and close the report window.
• Click Yes to confirm and close the Reverse Account Reconciliation information window.

After completion, the reconciliation dates will return to the last period before the reconciliation was originally performed.

Also Read: How to Download and Install Sage 50 Connection Manager?

How to reverse a payment in previous accounting period?

When a payment is recorded in a closed or previous accounting period, you should not edit or delete the original transaction. Instead, you must reverse the payment in the current open period.

• First, create a backup of your Sage 50 company file to avoid data loss.
• Go to the Tasks menu and select General Journal Entry.
• Enter a date in the current open accounting period.
• Select the Reverse checkbox if you want Sage 50 to automatically create the opposite entry in the next period.
• Enter the same accounts used in the original payment.
• Debit the account that was originally credited.
• Credit the account that was originally debited.
• Add a clear description, such as “Reversal of payment posted in the previous period.”
• Make sure the Out of Balance field shows 0.00, then click Save.

Important Note: You cannot edit the automatically created reversing entry, but it appears in the General Journal for the next period.

Common Errors While Reversing a Payment in Sage 50

When you reverse a payment in Sage 50, users commonly face the following errors:

• Cannot Void a Reconciled TransactionThe system blocks the reversal because the payment has already been cleared during bank reconciliation.
• Transaction Is in a Closed Accounting PeriodSage 50 does not allow changes to transactions posted in a closed fiscal period.
• Deposit Has Been Posted or LockedThe software prevents voiding a receipt that belongs to a posted or locked deposit batch.
• Insufficient User RightsThe system restricts the action if the user does not have permission to modify or void transactions.
• Invalid or Restricted Transaction DateSage 50 rejects the reversal if the entered date falls outside the allowed accounting period.
• Linked Transactions Prevent ModificationThe system may stop the reversal if the payment is connected to invoices, discounts, or credit notes that require adjustment first.

Also Read: Fix Sage 50 Error Connecting to Database

Final Words

This guide explained how to reverse payment in Sage 50 using the correct methods based on different scenarios. It covered customer and vendor payment reversals, bank reconciliation adjustments, and corrections in previous accounting periods. After following the right steps and verifying key prerequisites, you can correct errors while maintaining audit accuracy and financial integrity.

Frequently Asked Questions: