Double-Entry Accounting with Integrated Investment Accounting
In this article
Double-Entry Accounting with Integrated Investment Accounting
Double-Entry Accounting with Integrated Investment Accounting
This predefined template provides a ready-to-use example of double-entry accounting with integrated Investment Accounting for high-net-worth individuals (HNWIs). All investments are managed in the accounting base currency, together with the main components of personal wealth, including cash and bank accounts, real estate, other personal assets, liabilities, income, and costs. Individual investments, such as shares, bonds, and funds, are managed through the Items table and the corresponding Investment Balance Sheet Accounts, providing a complete view of the individual's investments, financial position, and results.
Open in Banana WebApp
Run Banana Accounting Plus on your browser without any installation. Customize the template, enter the transactions and save the file on your computer.
Open template in WebAppTemplate documentation
The tutorial file provides a ready-to-use example of integrated Investment Accounting, where general financial accounting and the detailed management of investments are maintained in the same Banana Accounting file.
All investments are managed in the accounting base currency, making this template suitable for learning and applying the basic principles of Investment Accounting without the additional complexity of foreign currencies.
The file includes a complete accounting structure for recording personal financial activities, assets, liabilities, and investment transactions. Investment-specific information, such as quantities, prices, Book Values, and Market Values, is managed alongside the corresponding accounting entries.
The chart of accounts also makes it easy to identify income and expenses for individual real estate properties, thanks to account descriptions that include the property names.
The template uses CHF (Swiss francs) as its default accounting base currency. You can change the base currency to suit your needs, preferably before entering transactions. For instructions, see Change the Base Currency.
For more information about managing investments in Banana Accounting, see the Investment Accounting documentation. For setup instructions, see How to Start.
Chart of Accounts
The chart of accounts provides a complete double-entry accounting structure for high-net-worth individuals (HNWIs), integrating Investment Accounting with the management of real estate properties, other personal assets, liabilities, income, and costs.
Balance Sheet Accounts
The Balance Sheet Accounts are organized into the following main categories:
- Cash and Equivalents, including cash, bank accounts, and withholding tax receivables
- Investments, with dedicated Investment Balance Sheet Accounts for securities and other financial investments
- Other Assets, including cars, pension assets, furniture and art, and receivables
- Real Estate Assets, with separate accounts for each owned property
- Debts, including other debts, loans, and mortgages
- Equity, including equity and the current year profit or loss.
This structure makes it possible to manage securities, real estate properties, and other personal assets and liabilities within the same accounting file.

Profit & Loss Accounts
The Profit & Loss statement is structured to record both investment results and the other income and costs related to the individual's assets and personal finances.
The investment-related accounts cover realized gains and losses on securities, foreign exchange gains and losses, unrealized investment and exchange rate adjustments, interest, dividends, and investment-related expenses.
The Profit & Loss statement also includes:
- Employment income, such as salary and bonuses;
- Depreciation, including depreciation of cars and furniture;
- Personal and asset-related costs, including cars, insurance, administration, legal fees, interest, taxes, health, and family costs;
- Real Estate Revenue and Costs, organized separately for each property, allowing rental and other income to be compared with utilities, insurance, maintenance, condominium fees, and other property-specific costs.
Identifying Financial Results by Property
A key advantage of this chart of accounts is that the accounts for each real estate property include the property name in their descriptions. This makes it easy to identify and compare the income and expenses of each property directly in the Profit & Loss statement, providing an immediate overview of each property's financial performance.
The chart of accounts also provides a comprehensive overview of personal income and expenses, making it easier to monitor the overall financial situation.
Because Investment Accounting is integrated into the financial accounting, purchases, sales, investment income and expenses, realized gains and losses, and valuation adjustments are recorded directly in the same accounting file and reflected in the corresponding Balance Sheet and Profit & Loss accounts.

Managing Quantities, Prices, and Values
The details of individual investments are managed in the Items table. The tutorial file includes sample shares and bonds and shows how investment-specific information can be maintained alongside the financial accounting.
For each investment, the Items table contains information such as the Item identifier, description, Asset Account, Quantity, Unit Price, Book Value, Market Price, and Market Value.
For more information, see the Items page.
Transactions
Investment transactions are recorded directly in the same Transactions table used for general financial accounting.
The tutorial file contains example transactions covering the main investment operations, such as purchases, sales, income, costs, realized gains and losses, and valuation adjustments.
Because the investment transactions are part of the double-entry accounting, their effects are reflected in the corresponding accounts and in the Balance Sheet and Profit & Loss statement.
For more information, see Investment Accounting Transactions.
Other Resources
Other Banana Accounting templates are available depending on how you want to manage your investments:
- Double-Entry Multi-Currency Accounting with Integrated Investment Accounting – for managing investments denominated in foreign currencies directly within multi-currency double-entry accounting.
- Multi-Currency Investment Accounting in a Separate File – for keeping detailed Investment Accounting multicurrency in a separate Banana Accounting file that can be used as an investment subledger for your general accounting.
- Double-Entry Investment Accounting in a Separate File – for managing investments in the accounting base currency, with detailed investment transactions recorded in a separate double-entry accounting file.