Reversing an invoice in Sage 100 is a common requirement when customers request a refund, returned goods are processed, or a billing error must be corrected. Sage 100 provides a structured workflow that maintains audit trails while ensuring accurate financial updates.
This guide walks through the standard reversal process, important prerequisites, and best practices to keep your accounts clean and compliant. Follow each step carefully to avoid posting inconsistencies.
| Aspect | Details | Best Practice | Impact if Skipped |
|---|---|---|---|
| Transaction Type | Invoice reversal creates a credit note or negative invoice linked to the original document | Match the reversal type to the original transaction | Incorrect reversal type distorts reporting |
| Reversal Method | Void before shipment, issue credit memo, or post a journal entry | Use the method aligned with your SOPs and compliance rules | Wrong method leads to reconciliation issues |
| Financial Impact | Reversal affects accounts receivable, revenue, and inventory | Verify general ledger accounts after posting | Unreversed revenue or inventory skews financials |
| Audit Trail | Sage 100 maintains references to the original invoice | Retain reversal reason and supporting documents | Poor documentation complicites external audits |
Understanding Invoice Reversal Methods
Void versus Credit Memo
Before you reverse an invoice in Sage 100, understand the two main approaches. Void cancels the invoice before the customer pays, while a credit memo handles post-payment scenarios or returns. Each method affects different modules and reports, so choose carefully based on the transaction status.
When to Reverse in Accounts Receivable
In the Accounts Receivable module, reversing an invoice often means applying a credit memo or creating a reversal invoice. Ensure your payment terms and tax settings are correctly updated to avoid posting errors. This keeps your customer balances accurate and reduces reconciliation work.
Steps to Reverse an Invoice in Sage 100
Preparation and Prerequisites
Confirm that the invoice has not been fully applied to payments or other transactions. Gather supporting details such as the original invoice number, reversal reason, and authorization. Review your security roles to ensure you have rights to create and post reversal documents.
Creating the Reversal Document
Navigate to the appropriate entry window, select new transaction, and choose credit memo or reversal invoice. Enter the original invoice reference, item details, quantities, and amounts with negative signs where needed. Validate the general ledger accounts and tax codes before saving the reversal.
Posting and Verification
Post the reversal document and verify the update in Accounts Receivable and General Ledger. Run reconciliation reports to confirm that customer balances and revenue accounts reflect the reversal accurately. Keep a reference note attached to the original invoice for audit purposes.
Key Processes and Best Practices
- Always review payment and application status before reversing an invoice
- Use void for unpaid invoices and credit memos for paid or returned items
- Maintain detailed reversal reasons and link to the original invoice
- Run reconciliation reports immediately after posting the reversal
- Coordinate with sales and warehouse to ensure inventory and revenue alignment
- Document authorization for large or complex reversals
- Train staff on Sage 100 reversal workflows to reduce errors
Implementing and Optimizing Reversal Workflows
Standardizing how to reverse an invoice in Sage 100 across your team reduces errors and speeds up resolution. Combine clear SOPs, user training, and periodic audits to maintain data integrity and support timely financial reporting.
FAQ
Reader questions
Can I reverse an invoice after payment has been applied in Sage 100?
Yes, you can reverse by creating a credit memo applied to the original invoice. Ensure the payment is appropriately adjusted or refunded based on your accounting policy.
What is the difference between voiding and reversing an invoice in Sage 100?
Voiding cancels an unpaid invoice before payment, while reversing handles post-payment corrections or returns through a credit memo or reversal invoice.
How do I ensure the general ledger reflects the reversal correctly in Sage 100?
After posting the reversal document, run ledger and reconciliation reports to confirm that revenue, receivables, and inventory accounts are updated accurately.
Will reversing an invoice affect customer history or aging reports in Sage 100?
Yes, the reversal appears in transaction history and aging, so verify that customer balances and open item reports reflect the change correctly.