What is Sage 100 How to Reverse a Journal Entry?

Definition

Reversing a journal entry in Sage 100 means recording an offsetting entry that cancels the original entry’s accounting effect while preserving a traceable transaction history. Finance teams use reversals to release prior-period accruals, correct certain posted transactions, and keep general ledger balances aligned with the intended accounting period. The appropriate method depends on the Sage 100 version, General Ledger configuration, the original entry’s posting status, and company accounting procedures. Before making changes, identify the original journal number, posting date, fiscal period, accounts, and amounts so the reversal can be linked to the transaction it offsets.

Before You Reverse a Journal Entry

First, determine why the entry needs to be reversed. A planned accrual reversal is different from correcting an entry posted to the wrong account. Confirm that the original entry is posted, review its supporting documentation, and check which fiscal periods are open. Also establish whether company policy requires a reversal, an adjusting entry, or another approved correction method.

Record the original journal number, transaction date, source, debit and credit accounts, amounts, and explanation. This information helps the reviewer confirm that the reversal addresses the intended transaction and supports the month-end close. If the original entry is already correct but was intended to reverse automatically in a later period, verify the configured reversal process before creating another entry.

Steps to Reverse an Entry in Sage 100

Menu names and available options can vary by Sage 100 version and setup, so use the procedure documented for your installation. In general, follow these steps:

  • Locate the original entry: Open the General Ledger journal inquiry or applicable transaction history and identify the entry by journal number, date, or reference.
  • Review the details: Verify the accounts, debit and credit amounts, posting status, and reason for reversal.
  • Choose the supported method: If your configuration provides a reversal function, follow its prompts. Otherwise, prepare a new journal entry with the original debit and credit sides exchanged.
  • Set the reversal date: Use the appropriate open fiscal period according to the accounting policy and reporting requirements.
  • Add a clear reference: Include the original journal number and a concise explanation, such as “Reverse prior-month accrual.”
  • Validate and post: Confirm that total debits equal total credits, review the accounts and date, obtain required approval, and post using the established procedure.

After posting, review the resulting general ledger activity to verify that the intended balance was offset. If the reversal is part of a correction, separately confirm that the replacement entry has been prepared and posted correctly.

Example: Reversing an Accrual

Suppose a business records a $3,600 month-end expense accrual for services received but not yet invoiced. The original entry debits expense for $3,600 and credits accrued liabilities for $3,600. In the next period, the company records the reversal by debiting accrued liabilities for $3,600 and crediting expense for $3,600.

Result: The reversal offsets the original accrual in the new period. When the supplier invoice is recorded, the accounting team can process the actual transaction according to its normal invoice and general ledger procedures. An Accrual Journal Entry is often used for this type of period-end estimate, and its reversal should be coordinated with invoice posting to maintain accurate expense recognition.

Controls, Documentation, and Close Review

A reliable reversal process includes a clear explanation, supporting documentation, appropriate authorization, and a review of the final ledger impact. A Journal Entry Audit examines details such as account selection, posting dates, approvals, and evidence connecting the original entry with its reversal. Retain the journal references and supporting schedules in the close file so another reviewer can follow the accounting treatment.

For recurring accruals, document which entries should reverse, the intended reversal period, and who reviews the resulting transactions. For an Interest Journal Entry, for example, confirm whether the original amount represents estimated interest that should be reversed when the actual interest is recorded. The treatment should follow the company’s accounting policy and applicable reporting requirements.

Using Automation Alongside Sage 100

The Hyperbots Platform can be configured to align finance workflows with company-specific ERP connections, general ledger structures, roles, and approval rules. Process Specific Capabilities support finance tasks tailored to the workflow, while Ready to Deploy Capabilities provide pre-trained agents and ERP connectors for supported use cases. Self Learning Capabilities can use human feedback to refine workflow decisions and general ledger coding, and Human in the Loop controls can route selected transactions to authorized reviewers.

Automation can complement, rather than replace, the accounting controls used to approve and post reversals. For wider finance context, AI in Finance: From Curiosity to Competitive Edge discusses AI applications in reconciliations and month-end close tasks. Speed Up Accruals: How AI Streamlines Month-End Closings covers accruals and reversals as part of close readiness. The Paperless AP System: Complete Guide to 100% Digital AP explains invoice validation, matching, and general ledger coding that support accurate posting. AI Copilots for Sage 300 discusses finance productivity and accuracy for Sage 300, a separate product from Sage 100; confirm system compatibility before applying any workflow to your environment.

Summary

To reverse a journal entry in Sage 100, locate and verify the original transaction, use the reversal method supported by your setup, enter the correct date and offsetting debit and credit amounts, and follow approval and posting procedures. Reconcile the resulting ledger activity and retain the supporting references. These steps help maintain accurate period balances, a clear audit trail, and dependable financial reporting.