Double-Entry Multi-Currency Accounting with Integrated Investment Accounting

This template provides a ready-to-use example of multi-currency double-entry accounting for high-net-worth individuals (HNWIs), with integrated Investment Accounting.

The accounting structure is designed to manage the individual's overall personal wealth, not only securities and financial investments. Within the same Banana Accounting file, it is possible to manage cash and bank accounts in different currencies, securities, real estate properties, cars, pension assets, furniture and art, receivables, debts, mortgages, and equity.

The Profit & Loss Accounts complement the wealth management structure by recording investment results and income, employment income, depreciation, taxes, personal and family costs, and the revenue and costs associated with individual real estate properties.

This provides an integrated view of the individual's assets and liabilities, together with the income, costs, and financial results that affect the overall personal wealth.

Chart of Accounts

The chart of accounts is structured to manage the different components of personal wealth and the related income and costs within the same multi-currency accounting file.

Balance Sheet Accounts

The Balance Sheet Accounts provide the accounting structure for managing the individual's assets, liabilities, and equity.

They are organized into the following main categories:

• Liquidity, including cash, bank accounts in different currencies, derivative positions, and withholding tax receivables;
• Investments, with dedicated Investment Balance Sheet Accounts for securities and other financial investments in different currencies;
• 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.

For Investment Accounting, each security maintained in the Items table is linked through its Asset Account to the corresponding Investment Balance Sheet Account. This makes it possible to maintain detailed information for individual securities while keeping their accounting values fully integrated into the Balance Sheet.

Profit & Loss Accounts

The Profit & Loss Accounts are structured to record the income, costs, and financial results associated with the individual's personal wealth and activities.

They include:

• Investment income and results, including realized gains and losses on securities, foreign exchange results, unrealized investment and exchange rate adjustments, interest, dividends, and investment-related expenses;
• Employment income, including salary, fees, bonuses, and related social security contributions;
• Depreciation, including depreciation of cars and furniture;
• Personal and asset-related costs, including car expenses, insurance, administration, legal fees, loan interest, taxes, health costs, family costs, and other personal expenses;
• Real Estate Revenue and Costs, with dedicated income and expense accounts for each property, including rent, other revenue, utilities, insurance, maintenance, condominium fees, and other property-specific costs.

This structure makes it possible to determine the overall financial result while keeping the results from investments and individual real estate properties clearly identifiable.

Other Resources

Other Banana Accounting templates are available depending on how you want to manage your personal accounting and investments:

• Double-Entry Accounting with Integrated Investment Accounting – for managing personal wealth and investments directly within double-entry accounting when securities are managed in the accounting base currency.
• Multi-Currency Investment Accounting in a Separate File – for keeping detailed multi-currency Investment Accounting in a separate Banana Accounting file that can be used as an investment subledger for your general accounting.