When is it ok to delete a General Ledger account?
Description
Cause
Resolution
[BCB:5:Third-party support:ECB]

There are three levels of tolerance to consider when determining if it is ok to delete GL accounts:

Tolerance level Fields Records Files
No activity for 2 years, no balances for 10 years, and no future activity

Accrual Method:

  • Current Balance
  • Future Balance
  • End Balance (1-10) Years Ago
  • Prior Year Adjustment
  • YTD Net
  • YTD Net 1 Year Ago
  • Future Activity (1-6)
  • Current Period Activity
  • Prior (1-12) Activity
  • 1 Year Ago Activity
  • Year 1 Period (1-12) Activity

Cash Method:

  • CCurrent Balance
  • CFuture Balance
  • CEnd Balance (1-10) Years Ago
  • CPrior Year Adjustment
  • CYTD Net
  • CYTD Net 1 Year Ago
  • CFuture Activity (1-6)
  • CCurrent Period Activity
  • CPrior (1-12) Activity
  • C1 Year Ago Activity
  • CYear 1 Period (1-12) Activity
GL Account master.glm
No activity before the prior 23 periods
  • Years Ago

Accrual Method:

  • X Years Ago Activity
  • Year X Period (1-12) Activity

Cash Method:

  • CYr X Ago Activity
  • CYr X Period (1-12) Activity
GL Account Activity History master.glm
No activity ever all fields GL Transaction Current.glt and History.glt



The general rule of thumb for deleting accounts is that there is no activity or balances on the GL Account record (GL Setup, Accounts, Balances tabs and Activity tabs) and you will not need to do any reporting or retrieve information prior to the periods and years available on these tabs. If there is activity and/or balances on an account that is deleted, then the Ledger and financial statements will appear out of balance for those periods that had amounts. Note: If you maintain both Accrual and Cash accounting methods, be sure to review the balances and activity tabs for both methods.

Other considerations:

  • If there is older activity on an account that is deleted but the transactions still exist, when you attempt to retrieve information on that account, you will be missing the account name/description. If that information is important to verify what the transactions were for, you should reconsider deleting the account.
  • If you plan to re-use the account number of a deleted account, when transactions exist for that account and that account number gets re-used it will appear as if those transactions always belonged to the "new" account.
  • Always take into consideration any auditing periods or cases of litigation where you may need to provide documentation further back than 2 years.

IMPORTANT:

  • For all cases and scenarios, always create a full backup of the database (to be kept and used for reporting purposes) before accounts are deleted.
  • If you need assistance with verifying which accounts are ok to delete, please work with your Sage 300 Construction and Real Estate Consultant.
Steps to duplicate
Related Solutions

How do I retire a General Ledger prefix and full accounts?
How do I delete multiple General Ledger accounts at the same time?
Can I deactivate, disable, disallow posting, or make an account inactive in General Ledger?
How do I delete a General Ledger account?