Templates
The templates are preconfigured with Investment Balance Sheet Accounts, an Items table for managing individual investments, and example transactions covering the main investment operations. The chart of accounts can be customized to suit your specific requirements.
We provide three predefined accounting templates to help you get started with Banana Investment Accounting:
The Double-Entry Accounting with Integrated Investment Accounting template is suitable for managing investments in the accounting base currency. Investment transactions are recorded directly within your financial accounting.
The Double-Entry Multi-Currency Accounting with Integrated Investment Accounting template allows you to manage investments denominated in foreign currencies directly within your financial accounting. The Exchange Rates table is used to define currencies and exchange rates, and the accounting structure includes the accounts required to record exchange rate gains and losses.
The Multi-Currency Investment Accounting in a Separate File template allows you to keep detailed Investment Accounting separate from your general accounting. The Banana file can be used as an investment subledger, maintaining the details of individual investments and their transactions, while aggregated accounting values can be recorded in your general accounting.
Investment Accounting Extensions
The Investment Accounting Extensions help automate key investment accounting operations. They can be used to:
- calculate the data required when selling investments, including realized gains and losses;
- calculate exchange rate differences;
- update current Market Prices;
- create Market Value Adjustment transactions.
Together with the predefined templates, the extensions provide an integrated workflow for recording transactions, maintaining investment information, updating valuations, and keeping investment data consistent with the related accounting balances.
Contabilità in Partita Doppia per Società Finanziaria con gestione Portafoglio
Contabilità in Partita Doppia per Società Finanziaria con gestione Portafoglio francescaContabilità in Partita Doppia per Società Finanziaria con multi-moneta e gestione Portafoglio
Contabilità in Partita Doppia per Società Finanziaria con multi-moneta e gestione Portafoglio francescaMulti-Currency Investment Accounting in a Separate File
Multi-Currency Investment Accounting in a Separate FileWhen Investment Accounting is managed in a separate file, the Banana Investment Accounting file contains the detailed information for each individual investment, while the general accounting contains the accounting values required for financial reporting.
In the Banana Investment Accounting file, you record the detailed investment transactions, including purchases, sales, income, costs, realized gains and losses, and, when applicable, value and exchange rate adjustments. Each transaction can be linked to the corresponding Item, allowing Banana Accounting to maintain quantities, Book Values, prices, and other investment-specific information.
In the general accounting, you do not need to reproduce the detailed information for each individual investment. You can record the corresponding accounting transactions using aggregated amounts by Investment Balance Sheet Account or investment category.
There are two possible approaches:
- Record each operation in both files. Purchases, sales, income, costs, gains and losses, and applicable adjustments are recorded in the Banana Investment Accounting file and also in the general accounting.
- Update the general accounting periodically. Detailed transactions are recorded in the Banana Investment Accounting file, while the general accounting is updated periodically with the accounting values required to keep the investment accounts and financial statements aligned.
When using periodic updates, the amount to record in the general accounting is not simply the difference between the opening and closing balance of an investment account. Purchases, sales, realized gains and losses, income, costs, and applicable value or exchange rate adjustments must be considered according to their accounting nature.
The investment balances in the general accounting should be periodically reconciled with the corresponding Investment Balance Sheet Accounts in the Banana Investment Accounting file.
Related Resources
For more information about setting up and managing investments, see the Investment Accounting documentation.
To automate key investment accounting operations, such as calculating sales data, updating Market Prices, creating adjustment transactions, and preparing investment reports, see the Investment Accounting Extension.