Hello Community,
As I was checking the retained earnings balance each year end, I've found that the Trial balance is not retrieving the expected number for the retained earnings as I've calculated it.
I know that the Retained earnings has 2 sectors that calculate it:
- Cumulative Balance of the Transactions directly posted on the Retained Earning account until the reporting year, and this can be found in the Account Detail report.
- Cumulative Net Income/Loss until the beginning of the reporting year.
For example, Retained Earnings balance As of Adjust 2022 is $30,867,864.41 at the consolidated level.
But when calculating it to check if the number is correct I use the 2 mentioned sectors:
- Account Detail report balance as of Adjust 2022 is $3,004,341.41. As the retained earnings increases in credit this number will be treated as negative number.
- Net Income/Loss as of Dec 2021 is ($27,884,816.94).
Then the retained earning is equal (3,004,341.41) + ($27,884,816.94) = ($30,889,158.35) which is not equal the number shown by the trial balance making a difference of -21,293.94.
I've customized the balance sheet report based on the accepted answer to the question: Calculated Retained Earnings
Link:
I've customized the balance sheet to show the two lines used to calculate the retained earnings which are:
- Retained Earnings (Account Section)
- Net Income (Balance Forward to Beginning of Year)
Then after the preview of the report, I found that the Account section balance is the same as the balance in the Account Detail Report, But the Net Income balance is different from the amount found in the P&L showing ($27,863,523) making difference of -21,293.94 which is the same difference shown before.
I've run the same investigation per each subsidiary to check if the Net Income balance is the same as in the P&L or not and found they are all the same, so this happened only while using the consolidated subsidiary.
Does anyone faced something like this before, or have an explanation for why the Net Income Balance used to calculate the retained earning is different from the P&L amount.
Thanks in advance.