When is it ok to delete a General Ledger account?
Description
Cause
Resolution

[BCB:5:Third-party support:ECB]

 

Determine if you can delete the account

There are three levels of tolerance to consider when determining if it's 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

 

Don't delete accounts with activity or balances on the GL Account record (GL Setup, Accounts, Balances tabs and Activity tabs). Don't delete accounts that you'll need to report on or retrieve information for prior to the periods and years available on these tabs.

If there's activity or balances on a deleted account, then reports will appear out of balance for periods that had amounts. Review the balances and activity tabs for both Accrual and Cash accounting, if you maintain both accounting methods.

Other considerations

  • When you retrieve information for a deleted account that still has transactions, the name/description will be missing. If that information is important to verify what the transactions were for, reconsider deleting the account.
  • If you re-use a deleted account number and old transactions still exist, the transactions appear to belong to the "new" account.
  • Always consider any auditing periods or cases of litigation where you may need to provide documentation further back than two years.

Important information

  • Always create a full backup of the database (for reporting purposes) before you delete accounts
  • If you need assistance with verifying which accounts are ok to delete, work with your Sage Consultant

 

Alternate solution

Consider deactivating the account instead of deleting it.

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?