Calculate Retained Earnings

I have had this discussion, and argument, with other consultants on what to do about Beginning Retained Earnings (RE BegBal) at the initiation of a consolidation application build and moving forward. This comes from the treatment of RE BegBal in whatever consolidation tool you are using. I am now writing it down and spreading it to anyone who will listen to try to make at least one thing in our lives simpler.

The Two Options

Option 1

  • Load RE BegBal from source systems into the RE BegBal account in the first time period of the consolidation tool.
  • After that point, RE BegBal is ignored from whatever periodic load is utilized, with a formula of some sort pulling forward the prior year-end retained earnings into the current year.
  • Basically, RE BegBal is an input account in the first period and calculated going forward.

Option 2

  • Always load RE BegBal from source systems into a statistical account outside of the trial balance accounts.
  • Use a formula to pull the balance from the statistical account into the body of the trial balance to initiate the consolidation system.
  • Going forward from the system initialization, use a formula to pull forward the prior year-end retained earnings.
  • Basically, RE BegBal is always input into the consolidation system and the calculation of RE BegBal in the balance sheet is always a calculation.

Overview

From a reporting perspective, RE BegBal shouldn’t be changing, but we all know that is not always the case or reality. Changes can occur because of audit adjustments or significant events in the business.

What happens when you put that into a consolidation tool? My preferred option is Option 2 from above. This is a very simple process that can be applied to any consolidation tool.

  • It allows users and the business to begin the analysis when a trial balance data load is out of balance.
  • This process simplifies validations as well as mapping.

General Thought Process

General Thought Process

Conclusions

As noted earlier, from a reporting perspective, RE BegBal shouldn’t be changing, but it has been known to do just that.

  • RE BegBal needs to come from somewhere in order to kick off the trial balance of a consolidation system.
  • If a source RE BegBal value is input into the RE BegBal account of a new consolidation system and then allowed to roll forward, any mapping of the original account needs to be ignored going forward. In practice, historical data is loaded and reloaded many times, so mapping needs to be modified back and forth.
  • If a source RE BegBal value is always loaded into a statistical account, the consolidation system retained earnings can always be calculated, both to initiate the balance sheet and to pull the correct balance going forward as well.
  • Using a statistical account allows for stable mapping of RE BegBal, maintenance of it as a calculated account, and the ability to always compare consolidation system versus source system RE BegBal.
  • That comparison is important because differences in beginning retained earnings are often the source of an imported trial balance being out of balance.

MindStream Analytics

The consultants at MindStream can help you discover solutions and best practices for your consolidations. Fill out the form below for more information.