Neste artigo
An Investment Accounting system is specialized software that records, values, and reports investments such as shares, bonds, ETFs, and investment funds.
Unlike a traditional accounting system, it manages both the accounting value and the investment-specific information required to track securities over time, including quantities, prices, market values, exchange rates, and realized and unrealized gains and losses.
Typical functions include:
- Recording purchases and sales of securities.
- Calculating book value and cost basis.
- Processing interest, dividends, and commissions.
- Perfoming market and foreign currency valuations.
- Calculating realized and unrealized gains and losses.
- Preparing accounting and investment reports.
Professional investment accounting systems may also support multiple accounting frameworks, such as IFRS and GAAP, as well as tax, reconciliation, and compliance reporting.
Elements
Investment accounting software consists of sophisticated solutions that are usually based on general accounting software or ERP (Enterprise Resource Planning) systems. These solutions typically include several components.
These solutions include several components.
- General ledger
- Double-entry accounting engine (Accounting Book of Record, ABOR) – Records all investment-related debits/credits.
- Multi-basis accounting – Supports IFRS, US GAAP, statutory, and tax accounting simultaneously.
- Chart of accounts & financial statements – Provides Balance Sheet and Profit & Loss outputs.
- Trade and transaction capture – Records purchases, sales, income events, fees, and settlements.
- Cash and liquidity management – Tracks cash movements, forecasts, and balances.
- Investment accounting
- Investment Book of Record (IBOR) – Tracks real-time quantities, cash, and exposures.
- Security master and reference data – Provides centralized instrument definitions and reference data, such as ISINs, coupons, and ratings.
- Market data & pricing engine – Imports or calculates prices, FX rates, yields, and curves.
- Valuation and revaluation logic – Calculates fair value, amortized cost, and unrealized gains and losses.
- Performance measurement – Calculates returns and contributions and compares performance against benchmarks (optional).
- Risk and exposure analytics – Provides duration, FX exposure, sensitivity, and VaR metrics (optional).
- Regulatory & compliance reporting – Supports filings (e.g., Solvency II, NAIC, UCITS).
- Reconciliation tools – Matches cash, positions, and transactions with custodians/brokers.
- Client & portfolio reporting – Generates statements, holdings reports, and dashboards.
Accounting and Investment Book of Record
- Accounting Book of Record (ABOR)
An ABOR is a double-entry accounting journal that records financial transactions. - Investment Book of Record (IBOR)
- An IBOR is similar to an inventory system and records the quantities and prices of securities bought and sold.
- It may be maintained in a separate database or as a subledger of the ABOR system.
Investment data from the IBOR is typically integrated into the ABOR through a process that creates double-entry accounting transactions at specified intervals, usually daily.
Single Book of Record
Instead of maintaining a separate IBOR, Banana Accounting uses a single ABOR journal that also integrates the information required for investment accounting.
Double-entry transactions include the information required for investment accounting, such as the Investment ID, quantity, price, and other details.
The Asset Account provides the connection between investment accounting and financial accounting. In the Accounts table, you define the Asset Accounts used to record the accounting value of the investments.
In the Items table, each investment is linked through the Asset Account column to one of the Asset Accounts defined in the Accounts table.
When entering transactions that change the quantity or value of an investment, you must use the Asset Account defined for that investment in the Items table.
The opening balance of each Asset Account must match the sum of the opening values of all investments linked to that Asset Account.
The current balance of each Asset Account must match the sum of the current values of all investments linked to that Asset Account.
Simplicity Through Innovation
Simplicity Through Innovation
Integrating investment management into a financial accounting system while keeping it simple to use is a significant technical challenge. Many investment accounting solutions rely on separate portfolio management systems or complex subledgers, making implementation and daily operation more complicated.
Banana Accounting follows a different approach by extending its standard accounting system with features specifically designed for investment accounting.
One of these is the integrated Items system, which allows investment information to be recorded directly in accounting transactions. Each transaction can include the Investment ID, quantity, and unit price, while the program automatically calculates the corresponding accounting amount. This makes it possible to manage investment movements without maintaining a separate investment journal.
Another distinctive feature is the support for neutral quantities (±). A neutral quantity is entered by typing ±123, which Banana Accounting automatically converts to ±123. Unlike positive or negative quantities, a neutral quantity does not change the number of securities held. Instead, it is used to calculate the accounting amount for transactions that modify the book value of an investment without affecting its quantity, such as market value adjustments, unrealized gains and losses, or other valuation entries.
These innovations allow Banana Accounting to manage complex investment accounting scenarios using the same transaction model employed for standard accounting, reducing complexity while maintaining complete integration between financial accounting and investment management.
Keeping Track of the Book Value
One of the most challenging aspects of investment accounting is maintaining the book value of each investment throughout its entire life cycle.
Unlike portfolio management systems, which primarily focus on market value, portfolio performance, and trading activities, investment accounting must determine and maintain the accounting value of each investment. The book value represents the accounting value of the investment and is used to determine realized and unrealized gains and losses. It may also be relevant for tax purposes, depending on the applicable tax rules.
To maintain the correct book value, every investment transaction must be recorded together with all the information that affects its accounting value. This includes:
- purchases and sales;
- quantities and unit prices;
- commissions and transaction costs;
- interest and dividends;
- realized gains and losses;
- unrealized gains and losses resulting from market value adjustments;
- realized and unrealized exchange rate differences.
Traditional accounting software generally records only monetary amounts and does not manage the quantities and prices required for investment accounting. As a result, accountants often maintain separate spreadsheets to calculate book values, realized gains and losses, and year-end valuations, increasing both workload and the risk of errors.
Banana Investment Accounting integrates investment management directly into the accounting system. By recording quantities, prices, expenses, commissions, and other investment data together with the accounting entries, the information required to maintain the book value of each investment and calculate realized and unrealized gains and losses, including those arising from exchange rate fluctuations, remains integrated within the accounting system.
Using the Moving Average Cost with Market Adjustments (MAC-MA) method, Banana Accounting produces both financial accounting reports, such as the Balance Sheet and Profit & Loss Statement, and investment reports for monitoring securities, eliminating the need for separate spreadsheets and manual reconciliations.