N.Progression Investments

Investment accounting and portfolio management inside Microsoft Dynamics 365 Business Central – for investment companies, financial institutions and family offices. Bonds, deposits, equities, derivatives and real estate in one financial instruments subledger, integrated with your general ledger.

Key solution features

1. Master data management

Financial instruments list with asset class, subclass, status and position

Financial instrument card of a bond: general, debt and position details

Hierarchical financial instrument types: equity, debt, commodities and other

Credit ratings of a financial instrument

2. Financial transactions management

Asset classes

Equities – shares, ADRs, ETFs

Trade operations: purchases and sales
Realized and unrealized gains maintained per position
Dividends processed as corporate actions

Bonds

Principal and coupon managed separately, including bought accrued coupon
Coupon accruals, payments, principal redemption and maturity operations support

Deposits – term and call

Placements, top-ups and partial withdrawals
Interest accruals
Interest held, capitalized or paid out to a bank account
Automatic withdrawal at maturity

Futures and forwards

Futures: daily variation margin from market quotes
Close-out by an offsetting trade; final valuation at expiry
Cash-settled forwards with off-balance notional legs
Fair value to the variation margin result; day-one result to the trade account

Real estate

Investment property valuation
Property operations – acquisition, construction,
Income and costs per property recognition

For all asset classes

Multiple portfolios and posting books (IFRS, tax, local GAAP)

FIFO and average cost are supported

Instrument dimension, quantity and original currency on every G/L posting

Mark-to-market revaluation from market quotes (ask / bid / mid)

FX revaluation of balance and off-balance accounts

Import of financial transactions from Microsoft Excel

General journal line for a bond purchase with FI posting book and portfolio

3. Reporting

PowerCentral, N.Progression's Power BI solution, is extended with the financial instruments subledger and investment master data: management dashboards, Excel pivot reports connected to the model, and filters by instrument, portfolio and 30+ other dimensions. Built into Business Central: the Asset Allocation and Income reports with Excel export.