Neste artigo
An Investment Accounting system is specialized software that records, values, and reports financial 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;
- performing market and foreign currency valuations;
- calculating realized and unrealized gains and losses;preparing accounting and investment reports.
Professional investment accounting systems also support multiple accounting frameworks, such as IFRS, GAAP, and tax reporting, together with reconciliation and compliance reporting.
Elements
Investment accounting software are sophisticated solution that are usually based on a general accounting software / ERP (Enterprise Resource Planning System) . They are formed by different elements.
- General ledger
- Double-entry accounting engine (Accounting Book of Record, ABOR) – Books all investment-related debits/credits.
- Multi-basis accounting – Supports IFRS, US GAAP, statutory, tax books simultaneously.
- Chart of accounts & financial statements – Provides Balance Sheet and P&L outputs.
- Trade & transaction capture – Records buys, sells, income events, fees, and settlements.
- Cash & liquidity management – Tracks cash movements, forecasts, and balances.
- Investment accounting
- Investment Book of Record (IBOR) – Tracks real-time quantities, cash, and exposures.
- Security master & reference data – Centralized instrument definitions (ISIN, coupons, ratings).
- Market data & pricing engine – Imports or calculates prices, FX rates, yields, and curves.
- Valuation & revaluation logic – Computes fair value, amortized cost, unrealized P&L.
- Performance measurement – Calculates returns, benchmarks, contributions (optional).
- Risk & exposure analytics – Supplies duration, FX, sensitivity, 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)
Is a double entry accounting journal that records financial transactions. - Investment Book of Record (IBOR)
- Is a journal similar to an inventory system that records the quantities and prices of securities bought and sold.
- It may be a separate database or a subledger of the ABOR system.
Investment data (IBOR) is typically integrated into the general accounting module (ABOR) through a procedure that creates double entry transactions at a specified time period, usually daily.
Single Book of Record
Banana Accounting uses a single ABOR journal that also allows the integration of information required for investment accounting.
Double entry transactions include the information necessary for investment accounting, such as Investment Id, quantity, price and other details.
The Asset account serves as a connection between the Investment Account part and the General Account part. In the Accounting table you define the Investment account that will record the investments.
In the Items table, for each investment you specify in the Asset Account column one of the Investment accounts you have defined in the Accounts table.
When entering transactions that change the quantity and value of an investment, you must use the account you have defined in the Items table for that investment. The opening balance of the Investment account must match the sum of all opening values of all investments with the same Asset Account.
The current balance of the Investment account must match the sum of all current values of all investments with the same Asset Account.
Banana Accounting ha use instead a single ABOR Journal that also allow to integrate information necessary to the investment accounting.
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. Most 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 features with functionalities 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 unique 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 ordinary 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 is the amount reported in the Balance Sheet and forms the basis for calculating realized and unrealized gains and losses, as well as taxable income where applicable.
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 program automatically maintains the book value of each investment and calculates realized and unrealized gains and losses, including those arising from exchange rate fluctuations.
Using the Moving Average Cost with Market Adjustments (MAC-MA) method, Banana Accounting produces both the financial accounting reports (Balance Sheet and Profit and Loss Statement) and the investment reports required to monitor securities, eliminating the need for separate spreadsheets and manual reconciliations.