Double-Entry Accounting with Separate Investment Accounting

This template is designed to manage securities and financial investments in a separate Banana Accounting file, independently of the general accounting.

It uses double-entry accounting to provide a structured and reliable way to record and monitor investment transactions, without including the company's or individual's general accounting activities.

The template allows you to manage shares, bonds, funds, and other financial investments, including purchases, sales, quantities, prices, dividends, interest, commissions, and realized and unrealized gains and losses.

It includes a dedicated chart of accounts, an Items table for tracking securities and investment holdings, and example transactions illustrating the main investment operations.

All transactions are recorded in the accounting base currency, without the additional complexity of multi-currency accounting.

The separate file provides a clear overview of investment holdings, portfolio values, and financial performance. It can also be used as an investment subledger, allowing summarized accounting values to be transferred to the general accounting when required.

This approach is particularly suitable for individuals, companies, and organizations that want to manage their securities and investments separately while maintaining detailed and organized financial records.

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
• Equity, including equity and the current year profit or loss.

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:

• Income and Costs, Investment-related costs and revenues
• Finaly Resultat, Investment profit or loss.

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.
• Double-Entry Accounting with Integrated Investment Accounting – Manage investments in the accounting base currency, with investment transactions recorded directly in double-entry accounting.