Double-Entry Accounting with Integrated Investment Accounting

The tutorial file provides a ready-to-use example of integrated Investment Accounting, where the company's 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 both the company's general business activities and its investment transactions. Investment-specific information, such as quantities, prices, Book Values, and Market Values, is managed alongside the corresponding accounting entries.

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:

• Liquidity, 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.

Investment income and results include accounts for realized gains and losses on securities, foreign exchange results, 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.

The structure therefore makes it possible to determine the overall financial result while also keeping investment results and the results of individual real estate properties clearly identifiable.

Because Investment Accounting is integrated into the financial accounting, purchases, sales, investment income and costs, realized gains and losses, and valuation adjustments are recorded directly in the same accounting file and are 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 the company's general 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 accounting effects are immediately reflected in the corresponding accounts and in the company's 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 in a separate Banana Accounting file that can be used as an investment subledger for your general accounting.