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

Working with HFM Custom Rule

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 represent 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 the deficit or accumulated deficit.
HFM Custom Rule

Transaction Analysis and the Accounting Equation

HFM Custom Rule

Order of Preparation

HFM Custom Rule

HFM Custom Rule

HFM Application Metadata

HFM Custom Rule

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.

 HFM Custom Rule

Balance Sheet Structure

HFM Custom Rule

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.

Let us know in case of any query:

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