General Ledger account type was incorrect when the fiscal year closed
Description
Cause

You set up an account as an asset, liability, equity, or suspense, but it was meant to be an income or expense. Balances exist from last year that didn't get closed to Retained Earnings.

An income or expense account can show a balance on the Year-to-date Ledger at the beginning of the new fiscal year. The balance should be zero (0.00).

Resolution

CAUTION:

Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Important

This process requires that you change some account balances manually. If you don't do these steps correctly, it can create an out of balance situation. Contact your Sage Consultant for assistance. You can also contact Sage Expert Services to schedule an appointment. This is a paid service. Sage Expert Services will contact you with a quote before scheduling.

Considerations

Correct the account, retained earnings, and statements

Change the account type and correct balances

  1. Make a backup of your data.
  2. Turn on the Audit Setup Activity tool.
  3. Go to General Ledger, Setup, Accounts.
  4. Click List, select the account with the incorrect account type, and click OK.
  5. Press TAB and select the correct Account Type such as Income, Cost, Expense, or Other income.
  6. Go to the Balances (Accrual) or Balances (Cash) tab, depending on your Accounting Method.

    NOTE:

    If you're using Both as the Accounting Method, change the Balances (Accrual) and the Balances (Cash) tabs. To view your accounting method, go to File, Company Settings, General.

  7. Enter the amount you need to close to retained earnings in the Prior year's adjustment box. Confirm the prior year's adjustment has the same sign as this account. For example, if the account balance is $500.00 (a debit), enter a $500.00 debit adjustment.
  8. Correct the Current balance and the Future balance to reflect the adjustment. Remove the amount that you needed to close to retained earnings from the fields.
  9. Click Save.
  10. Click Close.
  11. Turn off the Audit Setup Activity tool.

Close the correct amount to retained earnings

  1. Reclose your fiscal year (Tasks, Close Fiscal Year). Only the accounts with an amount in the Prior year's adjustment box create closing transactions.
  2. Go to Reports, Financial Statements.
  3. Print a trial balance and roll it back to last year-end to confirm you made the proper corrections.
  4. Verify you classify the expense account correctly, and your retained earnings account shows the correct balance.

Update the default statements with the account type change

Note: Recreating the default financial statements overwrites any customizations you saved to the default designs.

  1. Launch Financial Statement Designer.
  2. Go to File, Create.
  3. Click Yes to every prompt.
  4. Close all open windows.

Verify the base account is the correct type

  1. Go to Setup, Prefix/Base, Base Accounts.
  2. Click List.
  3. Select the base account that corresponds with the full account with the incorrect account type. Click OK.
  4. Select the correct Account Type such as Income, Cost, Expense, or Other income.
  5. Click Save.
  6. Click Close.
  7. If you generated accounts with the incorrect base, update the full accounts to match.

 

 

Need more help?

Chat now

Steps to duplicate
Related Solutions

General Ledger account type incorrectly set up as an income or expense account when the fiscal year was closed

How do I correct a General Ledger account setup as the wrong account type?

How do I reconcile General Ledger if it’s out of balance?