Create adjustment transactions

This extension allows you to generate automatically accounting adjustment transactions (revaluation or devaluation to fair market value) for all securities for which a market value (Price current) has been defined.

Set up the current prices

In the Items table, enter the current prices for each security in the “Price Current” column.
You can choose to:

• Enter the values manually, even only for the securities for which you want to generate adjustment entries.
• Use the Update Market Prices extension to update all prices automatically at once.

Create adjustment transactions dialog

The dialog shows the list of all Assets for which a current price has been entered, along with the corresponding price. Each time the extension is executed, it reads the latest values from the “Price Current” column from the Items table and updates the content displayed in the dialog.

Within the dialog, if needed, you can modify the current prices of the individual Assets. If the current price of an Asset is changed in the dialog, the value is also updated in the Items table.
You can view the list of changes related to the current prices in the Commit Changes dialog, under the Items section.

Commit changes dialog

Before recording the transactions, a preview dialog is displayed, allowing you to review and confirm the adjustments.

Transactions

In the Transactions sections are reported all the transactions that will be created, while in the Items sections are showed alla the changes performed to the Current Prices of the Asset in the Create adjustment transactions dialog.

Items

Once you confirm the changes, the program calculates the necessary adjustment by comparing the book value with the market value. The market price used for the adjustment is automatically inserted into the transaction description.

Adjustment Transaction

The adjustment transaction is recorded using the cost or revenue account specified in the Account settings dialog under the "Other value changing income field". If no account is found, a placeholder is inserted instead.

This feature ensures that your securities are properly revalued while giving you full control over the adjustments before they are recorded. This operation could be performed multiple time in a year.

In the following cases, no transactions are created

• The book value and the market value are identical.
• The Asset has a current quantity of zero.
• The Asset does not have current price.

Error Messages

• Items table not found: The Items table is not present in the accounting file
  • Add the Items table to your file.
• No Asset found in the Items table: The Items table does not contains any Asset.
  • Add Assets to the Items table.
  • A valid Asset must have an ID and an Asset Account.
• No Asset with current price found in the Items table: No Asset with a valid current price was found in the Items table.

Compatibility version

To run this extension, you need to use Banana Dev Channel, minimum version '10.2.1'.

You can check your current version of Banana Accounting from the menu: Help > About Banana Accounting+ > Version.