Call us: +1-786-629-6893 (USA) | +91 755-491-0482 (India)

HFM Calculating Retained Earning

What is Retained Earnings?

Generally, retained earnings is a corporation's cumulative earnings since the corporation was formed minus the dividends it has declared since it began. In other words, retained earnings represents the corporation's cumulative earnings that have not been distributed to its stockholders.

The amount of retained earnings as of a balance sheet's date is reported as a separate line item in the stockholders' equity section of the balance sheet.

A negative amount of retained earnings is reported as deficit or accumulated deficit.

Order of Preparation


HFM Application Metadata



Custom Procedure RetainedEarningsCalc()

Sub RetainedEarningsCalc()

Dim REValue

REValue = HS.GetCell("A#Netprofit.C1#TotalProducts.C2#TotalCustomers. C3#TotalC3.C4#ClosingBalance.I#[ICP None]")

If REValue < 0 Then

HS.Exp "A#RetainedEarnings.C1#[None].C2#[None].

C3#[None].C4#Decreases.I#[ICP None] = -1 * "& REValue

ElseIf REValue > 0 Then

HS.Exp "A#RetainedEarnings.C1#[None].C2#[None].

C3#[None].C4#Increases.I#[ICP None] = "& REValue

End If

End Sub

After Consolidation the Below Output Received.

Balance Sheet Structure

Difference Between Retained Earnings & Net Income

The primary difference between retained earnings and net income is time. Net income is the bottom-line profit your business earns for a given period. Retained earnings is the accumulation of those earnings over time to reinvest in the business or to maintain as a safety net.

Why BISP Solutions?


We are focused on Enterprise performance management, business intelligence, CRM services; application development, Data Migration and support. From managed services and consulting to 24x7 operational support, BISP Solutions has become preferred partner in clients list. BISP's clients include Fortune 100 to mid-sized companies that rely on robust support services that build their revenue-generating data infrastructure.

24*7*365 Support

Cloud Specialists

Onshore /offshore

Highly Skilled Experts