How to Delete General Ledger Accounts in Sage 100

Are you looking to remove a General Ledger (GL) account from Sage 100? Follow this guide to make sure you delete accounts safely and correctly. Always try this in a TEST Company first.

Requirements Before Deleting a General Ledger Account

Before you can delete a GL account, make sure these conditions are met:

• No transaction history: The account must not have any transaction activity.
• No budget data: The account should not be included in any budgets.
• Zero balance: The account's balance must be zero.
  
  

How to check GL Account Status

To see the status of the GL account:

1. Go to GL > Main Menu > Account Maintenance.
2. Select the account you want to delete.
3. The Status Field is on the Main tab. You can change the status here from "Deleted" to "Active" and back.
4. An account in a "Deleted" status will not allow entries to be made to it.
   
   

Ways to Delete a GL Account

Option 1: Delete in Account Maintenance

• Go to GL > Main > Account Maintenance.
  • Click the Delete button in the lower right-hand corner in Account Maintenance.
  • If all requirements above are met, the account will be deleted.
    
    

• • If all requirements are not met, Sage will prompt with the following message. Selecting Yes will change the Account to a Deleted Status. This is the same message you will receive if there is only Budget Data for this account and no transactions.
    
    
    
    

Option 2: Delete Accounts Utility

• Go to GL > Utilities > Delete Accounts.
  • If the requirements are met, the account will be deleted when using the Delete Accounts Utility.
  • If not, the account status will be set to "Deleted."
    
    
  • You can delete accounts by any of the following four Field options. You cannot delete two single GL Accounts at one time unless they are in a Range. You can delete an entire Main Segment, Department, or Location or a combination of those.
    
    

• • All users need to be out of the Company Code you are working in and all journals and batches posted before clicking "Proceed."
  • Print the Report Listing.
  • Print the Delete Log and review it for the status of your deletion to see if the Account was actually removed or just changed to a "Deleted" status.
    
    
    
    
    
    

Option 3: Period and Year-End Process

• If an account has a "Deleted" status, no transaction or budget data, and a zero balance, it will be removed automatically during the Period and Year-End process.
• If your account is marked as "Deleted," has a zero balance, and transactions exist only in years older than your "Years to Retain GL History" setting, those transactions will be removed, and the account will be deleted via the next Period and Year-End Process.
• If your account is marked as "Deleted" and does not meet the requirements it will stay in a "Deleted" status until the conditions are met.
  
  
  
  

How to check for GL Account Transaction History

• In Account Maintenance for the account, review the Transactions tab for all years.
  
  
• OR run the GL Detail Report for the account By Date using a date range covering all years.
  
   
  • If you find an account balance (for the above example, in 2021), and it shouldn't have one, you'll need to make a journal entry to bring the balance to zero. Afterwards, set the accounts status to "Deleted." It will remain in that status until your history retention period passes and will be removed automatically during Year-End.
    
    
    

How to check for budget data

1. Run the Budget Report.

2. Select Print Totals Only and choose "No" for zero balance budgets.

3. Enter the specific account and run the report for each year and budget you have.
4. If there's no budget data, it will give a message that there is no data to report.
   
   

Tip: How Long Does Sage Keep Account History?

To find out how many years Sage retains GL history:

• Go to GL > Setup > GL Options.
• Note your current fiscal year and your "Years to Retain GL History" setting.
• Below means that when the Year 2023 Period and Year End is run then it will keep the years 2024, 2023, and 2022 and purge any historical data prior to 2022.
  
  
  
  

How to Purge GL History

• You can manually purge history data by running the Purge General Ledger History option on the Utilities menu.
• Go to GL > Utilities > Purge General Ledger History.
• All unposted batches and journals must be updated. The utility will prompt with a message stating what is open.
• All users need to be logged out of the company code you are trying to purge.
• You can purge by year up to the Year set as your Current Fiscal Year in GL Setup Options.
  
  
• If you have a high number of Years set to Retain GL History then you may not be able to see any years on the above screen. You will need to adjust the Number of Years to Retain in GL History in GL Setup Options first to a lower number.

By following these steps, you can safely and successfully delete GL accounts in Sage 100. If you run into any issues or messages, contact RKL eSolutions or double check the requirements above—usually, it means the account still has history, budget data, or a balance.

Want More Sage 100 Tips & Tricks?

Make sure to subscribe to our blog to stay up-to-date on the latest insights and trends. We're dedicated to providing valuable resources for businesses looking to optimize their financial management with Sage 100.

Check out these blogs to help get you started!

How to Reverse a Cash Receipt
How to Reverse an Invoice Posted to the Wrong Month
Understanding the Purchases Clearing Report
How to Setup ACH Processing in Accounts Payable