Double exclamation marks (!!) print on ledger reports because activity doesn't match transactions
Description
Cause

The activity field on the account record in the master file doesn't equal the sum of the transactions for the same period.

Resolution

 CAUTION: We recommend working with your Sage 300 CRE Consultant because you'll manually change some account balances. You can end up with an out of balance situation if you don't do it correctly.

Prerequisites

Review the following articles for alternate causes and solutions before proceeding with this article's resolution.

If the problem persists, continue with the process below.

1. Prepare reports and adjust settings

1. Prepare reports and adjust settings

  1. Have all users exit the software for this company's data folder.
  2. Make a backup of your data.
  3. Go to File, Company Settings, GL Settings, Ledger Settings.
  4. On the General tab, in the Tran files for current ledger and Tran files for YTD ledger sections, select Current and History.
  5. On the Activity tab, in the Print activity section, select One column.
  6. In the Print credits section, select Negative.
  7. Click OK twice to exit settings.
  8. Print the year-to-date ledger again to verify if the !! still appear.
    • If a message displays that the history file isn't found:
      1. Click OK.
      2. Follow steps 1.3-1.8 to change the ledger setting in step 1.4 to Current only.
      3. Print the year-to-date ledger again.
  9. If the !! no longer appear, you don't need to proceed further. Follow steps 1.3-1.8 to change your ledger settings back to the original.
  10. If the !! still appear on the ledger, continue to section 2.

 

2. Calculate activity amounts

2. Calculate activity amounts

You can use the attached report to help identify articles with variances. Then follow the steps in this section to calculate the differences you need to correct.

Attachment: GLActivityToEntriesComparision.rpt

  1. Turn on Audit setup activity.
  2. Print a year-to-date ledger for the period that displays the !!. Use Range or Conditions to select the affected account.
  3. Note the total amount from the Activity column.
  4. Go to Setup, Accounts.
  5. Select the affected account and click the Activity tab.
  6. Note the amount for the period that has the !! on the ledger.
  7. Calculate the difference between the ledger total activity amount (step 2.4) and the amount from the account activity tab (step 2.6). The difference can be negative or positive.
    • Example 1: The year-to-date ledger for account 1-00-10010 for March 2025 has !! and the total activity amount is 200.00. The amount on the account Activity tab is 500.00.
      Difference: 200.00 - 500.00 = <300.00>
    • Example 2: The year-to-date ledger for account 1-00-20015 for March 2025 has !! and the total activity amount is <4000.00>. The amount on the account Activity tab is <4500.00>.
      Difference: <4000.00> - <4500.00> = 500.00
  8. Continue to section 3.

 

3. Change the Activity amount

3. Change the Activity amount

  1. On the account Activity tab, type the total activity amount (step 2.4) in the period field.
  2. Continue to section 4.

 

4. Adjust balance totals

4. Adjust balance totals

Depending on the message you receive, you have the following options.

If !! appear on a current period or prior period in the current fiscal year

  1. Click the Balances tab.
  2. Add the difference (step 2.7) to the Current balance, Future balance, and YTD net change fields.
  3. Go to section 5.

If !! appear on a period in a prior fiscal year

Follow the appropriate instructions for the account type of the affected account.

Balance sheet account (Account type: Current assets, Noncurrent assets, Current liabilities, Noncurrent liabilities, Equity, or Retained earnings)

  1. Click the Balances tab.
  2. Add the difference (step 2.7) to the Current balance, Future balance, and Year end 1 year ago fields.
  3. If the period with !! is one year or more before your current period, add the difference (step 2.7) to both fields:
    • Balance 1 year ago
    • YTD net change 1 year ago
  4. Go to section 5.

Income statement account (Account type: Income, Cost, Expense, or Other income)

  1. Click the Balances tab.
  2. Add the difference (step 2.7) to the Year end 1 year ago and the Prior year's adjustment fields.
  3. If the period with !! is one year or more before your current period, add the difference (step 2.7) to both fields:
    • Balance 1 year ago
    • YTD net change 1 year ago
  4. Go to section 5.

Suspense account

  1. Click the Balances tab.
  2. Add the difference (step 2.7) to the Current balance, Future balance, and Year end 1 year ago fields.
  3. If the period with !! is one year or more before your current period, add the difference (step 2.7) to both fields:
    • Balance 1 year ago
    • YTD net change 1 year ago
  4. Go to section 5.

If !! prints for future periods

  1. Click the Balances tab.
  2. Add the difference (step 2.7) to the Future balance field.
  3. Go to section 5.

 

5. Proof your changes

5. Proof your changes

  1. Add the total current year activity fields on the Activity tab. This amount should match the YTD net change field on the Balances tab.
  2. For balance sheet accounts, YTD net change + Year end 1 year ago should equal the Current balance.
  3. For income statement accounts, YTD net change should equal the Current balance.

 

6. Finish and verify that you are in balance

6. Finish and verify that you are in balance

  1. Click Save and Close.
  2. Print the year-to-date ledger again to verify that the !! no longer appear on the ledger.
  3. Turn off Audit setup activity.
  4. If you changed the settings in steps 1.3-1.8, use the same steps to change the settings back to the original settings.
  5. Re-close the fiscal year (Tasks, Close Fiscal Year) if you changed the prior fiscal year.
     NOTE: If you don't want to change last year's retained earnings, record a journal entry to reverse the prior year adjustment.

 

 

[BCB:156:Chat 300 CRE US:ECB]





Steps to duplicate
Related Solutions

How do I print financial statements for prior years?
How do I reconcile General Ledger if it's out of balance?