在此文中
The Transactions table is the core of the accounting workflow. It records all investment operations, including purchases, sales, income, expenses, transfers, and valuation adjustments.
Each transaction updates both Financial Accounting and Investment Accounting by linking the accounting entries to a specific Item. This ensures that investment quantities, book values, and financial statements remain synchronized.
Before entering investment transactions, you must:
- create the required Investment Balance Sheet Accounts in the Accounts table
- define each investment in the Items table.
This documentation assumes that you are familiar with financial accounting, portfolio accounting, and the concept of updating the book value of an investment when it is sold.
For general accounting features, such as attaching digital documents, using Cost Centres and Cost Segments, or importing accounting data, refer to the Financial Accounting documentation.
Recording Investment Transactions
Investment operations are recorded as compound (multi-line) transactions. Each row records one accounting component of the operation, while the same Item links all related rows to the corresponding investment.
Depending on the type of transaction, additional rows may be required to record commissions, taxes, realized gains or losses, exchange rate differences, or other accounting adjustments.
The following sections explain each step of the process and the accounting treatment for the different types of investment transactions.
Preparing Transaction Data
Before entering an investment transaction, collect all the information required to complete the accounting entry.
The information is often provided by different sources:
- Bank statement – provides the net amount credited or debited
- Portfolio statement – provides the investment details, including quantity, unit price, currency, and transaction date.
Transactions can be entered manually or imported automatically.
Banana Investment Accounting supports several import methods:
- importing bank statements using Import into Accounting
- copying and pasting data prepared in Excel
- importing data generated by Excel macros
- using customized import extensions for specific banks or portfolio management systems.
Regardless of the import method, every investment transaction must contain the information required to correctly update both the Investment Balance Sheet Account and the related Item.
Transaction's entries
Investment purchases and sales are recorded as compound (multi-line) transactions.
Each line records one accounting aspect of the operation, while the Item ID links all rows to the corresponding investment.
A typical investment transaction includes:
- one row for the bank payment or receipt
- one row for the purchase or sale of the investment, including quantity, unit price, and exchange rate
- one or more rows for commissions, charges, or taxes
- for sales, additional rows for realized gains or losses and, when applicable, realized exchange rate gains or losses.
By recording all information in a single compound transaction, Banana Investment Accounting automatically updates both the Investment Balance Sheet Account and the related Item.
Multi-line double entry transactions
Following the typical concept of double-entry accounting, all details related to investment purchases or sales are recorded in multi-line transactions. This allows you to enter all necessary information across multiple lines. The system is flexible — you can easily track additional expenses, commissions, or other details by simply adding a new line.
In the Transactions table the purchase or sale of investment is entered using a compound transaction, so you enter all detail using multiple rows:
- The first line is the Bank account of the transaction.
- Enter the Item identifying the security ID as specified in the Item Table.
The Item is repeated on each line so that the software can associate the information regarding costs, charges, commissions, gains and loss, to the specific investment and prepare reports. - Enter the Quantity and Unit Price and exchange rate.
The software will automatically calculate the amounts and update the accounts value and also the item current quantity. - Bank charges are entered in a separate line.
- When entering sale use separate lines to enter:
- Gain/Loss from investment.
- Gain/Loss from currencies.
- The command Calculate Sale Data will calculate both values based on the historical data, so you can easily complete the transaction.
This information is all what is needed for the software to generates comprehensive reports on the status, purchases, and sales of your securities, providing you with a clear overview of your portfolio.
Required booking information
To correctly update both Financial Accounting and Investment Accounting, each investment transaction must include the information required to identify the investment and record the related accounting entries.
The required information depends on the type of transaction. The following information is typically required when recording investment purchases and sales.
Basic Transaction Information (to be repeated for all rows)
- Date – The transaction date.
- Item – Identifies the investment defined in the Items table. Enter the same Item on every row belonging to the same investment transaction.
- Description – A short description of the transaction.
Bank Payment or Receipt
This row records the payment for a purchase or the receipt from a sale.
- Debit account (sale) – Bank account receiving the sale proceeds
- Credit account (purchase) – Bank account used to pay for the investment
- Amount – Net amount credited or debited by the bank.
Investment Movement
This row records the purchase or sale of the investment.
- Debit Account (for purchase): Asset account for the investment. Make sure to use the Asset account assigned to the Item in the Items table. If you use a different account than the one associated in the Items table, the program will display a warning.
- Credit Account (for sale): Asset account for the investment. Make sure to use the Asset account assigned to the Item in the Items table. If you use a different account than the one associated in the Items table, the program will display a warning.
- Quantity: Positive for purchases, negative for sales.
- Unit Price: Price per unit for the purchase.
- Exchange Rate: Exchange rate used by the bank for the transaction.
The software will automatically calculate the transaction amount in both the transaction's currency and the base currency.
Note: The Investment Balance Sheet Account should match the account assigned to the Item in the Items table. If a different account is used, Banana Investment Accounting displays a warning.
Bank Charges and Commissions
Use additional rows to record brokerage fees, bank commissions, taxes, or other transaction costs.
- Debit account – Expense account for the related cost.
Additional Details for Sales Transactions
After recording the sale, enter the realized results or calculate them automatically using the Command for Calculating the Gain/Loss on Investment Sales.
- Realized Gain/Loss on Investment
- Debit Account – Account for realized investment losses
- Credit Account – Account for realized investment gains
- Contra Account – Use the same account used for the investment movement.
- Realized Exchange Gain/Loss (for foreign currency investments)
For investments denominated in a foreign currency.- Debit Account – Account for realized exchange rate losses
- Credit Account – Account for realized exchange rate gains
- Contra Account – Use the same account used for the investment movement.