In-memory Costing

Unleash the Power of Creating Reserve Columns

The setting of reserve columns allows you to change the default values of factory settings relevant for specific processing of Block. Redefining Block Type for each Block is most important of your Apps, It provides different kinds of data extraction model as follows: –

In-Memory Cost Accounting

CostMethod for Amortisation = StraightLine, DeclineBalance, Rule78, EffectiveRate,DiscountCashflow

CostMethod for Allocation = ProRata30Day, ProRataActulDay

CostMethod for Financial Instrument = SimpleInterest, CompoundInterest

CostMethod for Inventory = FIFO,LIFO,Average

CalcBasis = BalanceByRound2, MovementByRound2

Interval = Day, Week, Month, Quarter, Interim, Year

DayCount for Month-end Closing = FullMonth, ProRata30Day, ProRataActualDay

DayCount for Financial Instrument = 30/360, Actual/Actual

The combined application of DiscountCashflow & EffectiveRate is designed for IFRS 16 Lessee Accounting.

Unleash the Power of Creating Reserve Columns

The setting of Reserve Column of Common Data Table working with defined data extraction is key to create different scenarios of connect-to-calculate functions. Below CalcFunction can be applied to support your compliance works: –

Revaluation of Asset & Liability by Current Exchange Rate & Current Unit Price

%FairValue(), %RevalueAdj()

Cost Allocation by ProRata Method

Reserve Column: AllocatedCost

Amortisation of Deferred Income & Expenditure by Tenor

Reserve Column: CurrentTenor, CurrentDate, AmortisePL, AmortiseBS, CostNBV

Depreciation of Fixed Asset by Tenor

Reserve Column: CurrentTenor, CurrentDate, DepreciatePL, DepreciateBS, FixedAssetNBV

Loan & Bond Interest Calculation by Interest Rates & Tenor

Reserve Column: CurrentTenor, CurrentDate, InterestPL, InterestBS, AssetNBV, Payment, LoanNBV, BondNBV, BondFairValue

IFRS16 Lessee & Lessor Accounting by Discount Rate & Tenor

Reserve Column: CurrentTenor, CurrentDate, InterestPL, InterestBS, AssetNBV, Payment, LoanNBV, BondNBV, BondFairValue,

General Calculation

Mathematical Calc: %Add(), %Subtract(), %Multiply(), %Divide()

Time Calc: %TimeInterval(), %CurrentDate(), %CurrentPeriod()

Statistical Calc: %Count, %Sum, %NetSum, %Average, %Median, %Max, %Min

Data Manipulation: %Map(), %ExactMap(), %Insert(), %Split(), %Merge(), %Extract(), %ReverseDC

Note: BS represents Balance Sheet, PL represents Profit & Loss, NPV represents Net Present Value