Skip to main content
Answer

Retained Earnings Fiscal YE not Matching New Fiscal Year

  • April 19, 2023
  • 5 replies
  • 427 views

We just had our first year end on March 31/23.  The starting balance does not match my YE amount, even after allowing for;

  1. At year end, the ending balance in Retained Earnings + the ending balance in YTD Net Income = beginning balance for Retained Earnings for the next year.

The new FY is overstated by a significant amount.

Has anyone experienced this ?

Best answer by andrewmurphy87

I had this exact issue. To Fix I ran the “Recalculate Account History” Process ScreenID GL509900. I first ran it on the last period of the previous year in my case 12-2022. I then ran it in the first period of the current year 01-2023.

At this point it was still out so I ran it again in 01-2023 then again in 12-2022. After this Retained earnings was back in balance. 

The best explanation I got here was that sometimes if a process in Acumatica has many steps a few can be missed throwing off the system calculated retained earnings amount. “Recalculate Account History” is a fail safe for the system to reference the GL history and “recalculate” any errors that might exist. Good Luck!

5 replies

  • Author
  • Freshman I
  • April 19, 2023

Issue resolved


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • April 19, 2023

Hi @dwayne - Can you share with the community your solution? Thank you!


  • Freshman I
  • May 11, 2023

Hi any update to the solution. Thx

 


I had this exact issue. To Fix I ran the “Recalculate Account History” Process ScreenID GL509900. I first ran it on the last period of the previous year in my case 12-2022. I then ran it in the first period of the current year 01-2023.

At this point it was still out so I ran it again in 01-2023 then again in 12-2022. After this Retained earnings was back in balance. 

The best explanation I got here was that sometimes if a process in Acumatica has many steps a few can be missed throwing off the system calculated retained earnings amount. “Recalculate Account History” is a fail safe for the system to reference the GL history and “recalculate” any errors that might exist. Good Luck!


Forum|alt.badge.img
  • Freshman II
  • May 6, 2024

I just came across the same issue at another client and this seemed to solve the issue.