Sage 50 Helps and Technical Articles

⌘K
  2. Home
  4. Docs
  6. Sage 50 Helps and Technic...
  8. Sage 50 General Ledger Ar...
  10. Exclude Inactive Accounts from Financial Statements in Sage 50

Exclude Inactive Accounts from Financial Statements in Sage 50

How to Exclude Inactive Accounts from Financial Statements in Sage 50

Sage 50 does not provide a built-in option to automatically exclude inactive accounts from financial statements. While zero-balance accounts may not affect totals, they can clutter reports and reduce readability—especially when legacy or unused accounts are involved. Sometimes you need to show active accounts with zero balance but don’t want inactive accounts to show.

Challenge

Inactive accounts still appear on income statements and balance sheets, even if they hold a zero balance. This can lead to unnecessary complexity when distributing financials to stakeholders.

Workaround: Use Alphanumeric Filtering via Account ID

If your chart of accounts uses numeric account IDs, you can apply a smart filtering technique to remove inactive accounts from custom reports. Here’s how to do it:

Step-by-Step Guide

1. Tag Inactive Accounts with a Prefix

  • Go to Maintain > Chart of Accounts.
  • For each inactive account, click Change ID.
  • Add a prefix letter, such as Z, to the beginning of the Account ID.
  • Example: 4100 becomes Z4100.

Tip

Use a consistent letter prefix that won’t overlap with active accounts.

2. Open and Customize the Income Statement

  • Navigate to Reports & Forms > Financial Statements.
  • Select your desired Income Statement, then click Design.

3. Adjust Line Descriptions to Filter Out Inactives

For each section of the report (e.g., Revenues, Expenses):

  • Double-click the Line Description object.
  • In the From field, enter: 0
  • In the To field, enter: 999999999999999

This numeric range will exclude any accounts that begin with a letter, effectively hiding those tagged as inactive.

4. Repeat for All Relevant Sections

  • Apply the same filter logic to each Line Description in other segments of the report (e.g., COGS, Operating Expenses, Other Income).

5. Save as a New Report

  • Use File > Save As to give your customized statement a descriptive name.

Final Check: Net Income Reconciliation

Ensure your modified income statement still aligns with your financials:

  • Compare the Net Income on your custom report with the Net Income line under the Capital section of the Standard Balance Sheet.
  • Discrepancies may indicate a miscategorized or filtered-out account that needs review.

Benefits of This Method

  • Keeps financials clear and concise.
  • Reduces clutter from zero-balance, inactive accounts.
  • Maintains full editability and transparency for future reporting needs.