In this article
With Banana Investment Accounting, you can manage your investment portfolio separately from your general accounting, using a simple, dedicated accounting file.
This solution is ideal for businesses, accountants, and private investors who need detailed records of securities and financial investments while continuing to use their existing accounting software, such as Xero, QuickBooks, or another system.
The separate file works as an investment subledger, combining double-entry accounting with portfolio management. It allows you to track investment transactions, quantities, prices, Book Values, and Market Values without maintaining separate Excel spreadsheets.
An investment subledger maintains detailed records of individual investments, while the general ledger records the corresponding overall balances and financial results.
A Simple Alternative to Excel Spreadsheets
Managing investments with spreadsheets often means maintaining separate records for transactions, quantities, purchase prices, and portfolio valuations.
Banana Investment Accounting brings this information together in a single, structured accounting file. Because the file is dedicated exclusively to investments, the chart of accounts can remain small and focused.
Key advantages:
- One integrated file: Keep investment transactions, accounting balances, and portfolio information together.
- Less reliance on Excel: Manage investment quantities, prices, and valuations without separate tracking spreadsheets.
- Double-entry accounting: Maintain consistent records of investment assets, income, expenses, and gains or losses.
- Portfolio overview: Monitor individual securities and organize investments into groups.
- Simple accounting structure: Focus on investment activities without including other general accounting operations.
- Flexible currency management: Choose between single-currency and multi-currency accounting.
When to Use Separate Investment Accounting
Separate Investment Accounting is particularly useful when:
- You already use accounting software: Maintain detailed investment records without changing your general accounting system
- You currently track investments in Excel: Replace spreadsheets with an integrated investment accounting solution
- You need detailed securities accounting: Monitor shares, bonds, ETFs, investment funds, and other financial investments
- You manage multiple entities or portfolios: Maintain a dedicated accounting file for each company, client, or portfolio
- You want to simplify investment management: Use a focused accounting structure dedicated to your investment activities.
How Separate Investment Accounting Works
A separate investment accounting file uses double-entry accounting and integrates three main tables.
Accounts Table
The Accounts Table contains the accounts used to record investment assets, income, expenses, and gains or losses.
The chart of accounts can remain relatively small because it includes only the accounts needed for investment activities.
Items Table – Investment Portfolio View
The Items Table – Investment Portfolio View contains the individual securities and financial investments.
For each investment, you can manage:
- Investment identification and description
- Quantity or nominal value
- Beginning and current quantities
- Investment prices
- Book Values and Market Values
- Investment groups and portfolio totals.
Book Value represents the investment's carrying amount in the accounting records, while Market Value represents its value based on the market price used for portfolio valuation. These values may differ.
Each investment is linked to its corresponding Balance Sheet account, keeping portfolio information and accounting records connected.
[Insert screenshot: Items Table – Investment Portfolio View]
Transactions Table
The Transactions Table contains the double-entry accounting records for investment operations, including:
- Purchases and sales of securities
- Dividends and interest received
- Investment fees and expenses
- Realized gains and losses.
- Valuation adjustments and unrealized gains or losses.
Transactions can be associated with individual investments through their Item codes, allowing investment quantities and accounting records to be managed together.
[Insert screenshot: Transactions Table]
Use Banana Accounting Alongside Your Existing Accounting Software
Separate Investment Accounting complements your existing general accounting system rather than replacing it.
You can continue using Xero, QuickBooks, or another accounting application for your company's general accounting and financial statements, while Banana Accounting maintains the detailed records of your investment portfolio.
The two systems have complementary roles:
- General Accounting Software
- Manages the company's overall accounting and financial statements
- Records investment balances in the Balance Sheet
- Reports investment income, expenses, and financial results
- Banana Investment Accounting (Subledger)
- Maintains detailed accounting records for individual securities
- Tracks quantities, prices, Book Values, and Market Values
- Records investment transactions and financial results
- Provides supporting information for reconciliation and reporting.
Reconcile the Investment Subledger with the General Ledger
The investment balances and financial results maintained in Banana Accounting can be compared with the corresponding accounts in your general ledger.
Periodic reconciliation allows you to:
- Verify that investment balances agree between the two systems
- Review investment income, expenses, and gains or losses
- Identify and investigate discrepancies
- Transfer or record the necessary accounting information in the general ledger.
The two accounting systems operate independently. Reconciliation and accounting data transfers are separate processes and do not imply automatic synchronization.
Single-Currency or Multi-Currency Investment Accounting
Separate Investment Accounting can be managed using either a single-currency or a multi-currency accounting file.
Single-Currency Investment Accounting
Suitable for portfolios managed in one accounting currency, such as CHF.
This option provides a straightforward structure for recording investment transactions, tracking quantities, and monitoring portfolio valuations.
Multi-Currency Investment Accounting
Suitable for portfolios containing investments denominated in different currencies, such as CHF, EUR, and USD.
This option supports foreign-currency transactions and balances, exchange rate differences, and valuations in the accounting base currency.
Get Started with a Ready-to-Use Template
The Banana Investment Accounting templates provide a predefined chart of accounts, investment information, and example transactions.
To get started:
- Choose the single-currency or multi-currency template
- Open the template in Banana Accounting
- Adapt the accounts and investments to your requirements
- Enter the opening balances, investment quantities, and initial values
- Start recording transactions and monitoring your portfolio.
For additional instructions, see How to Start.
Frequently Asked Questions
What is an investment subledger?
An investment subledger is a separate accounting file used to maintain detailed records of securities and financial investments. It complements the general ledger by tracking individual investments, transactions, quantities, and valuations.
Can Banana Investment Accounting work alongside my existing accounting software?
Yes. Banana Investment Accounting operates independently and can complement your existing general accounting system. Investment balances and financial results can be periodically reconciled with the corresponding general ledger accounts.
Can Banana Investment Accounting replace Excel spreadsheets?
Yes. Banana Investment Accounting combines portfolio tracking and double-entry accounting in one file, reducing the need for separate spreadsheets to manage securities, transactions, quantities, prices, and valuations.
Does Banana Investment Accounting support multiple currencies?
Yes. Banana Investment Accounting offers single-currency and multi-currency templates for managing investment portfolios denominated in different currencies.
Do I need to move my general accounting to Banana Accounting?
No. You can continue using your existing accounting software and use Banana Investment Accounting exclusively for detailed securities and investment accounting.