Recurring Transactions Table

The Recurring transactions table is used to store transactions that are used repeatedly:

Display Recurring transactions table

The Recurring transactions table is displayed from the Actions menu → Recurring transactions.

Columns and views arrangement 

The Recurring transactions table does not allow you to save your own view settings, but takes over the views and column settings of the Transactions table.
However, it is possible to:

  •  Add a new view in the Transactions table
  •  In the Transactions table, arrange the columns for the new view you have added.
  •  When viewing the recurring transaction, choose the preset view.

Entering Recurring transactions in the Doc column

For repetitive operations, codes can be created for automatic data recovery.

  • If the 'End Date' column is present (see Automatic Transactions), you can also indicate a date after which this entry is no longer taken up in the Transactions table. 
    Transactions that are no longer used must be deleted manually.

recurring transacrtions

Progressive numbering of "docnum" documents 
If, when retrieving recurring transactions, you wish to have a Doc number different to the automatic one in the Transactions table, you need to create a row containing the code "docnum" in the Doc column, and your desired text in the Description column. For the following rows, the text specified in the Description column will be used.

  • "0" when no automatic numbering is required.
  • "1" progressive numbering.
  • "cash-1" progressive numbering with the prefix "cash-" (cash-2, cash-3).
    The program replaces the number indicated at the end of the text with the next progressive number.
     
  • If you wish the program to suggest just one row per code, the description has to be preceded by:
    • An "*": displays just this row and not the others with the same code.
    • An "**" displays just this row, but doesn't retrieve this row (only title row).
    • An "\*" allows the user to start the description with an asterisk, without it being interpreted as a command.

Retrieving recurring transactions in the Doc column into the Transactions table

In the Transactions table, you can resume the rows defined in the Recurring Transactions table:

  • In the Transactions table, enter the date in the transaction row and display any other columns that are missing from the Recurring transactions table.
  • In the Doc column in the Transactions table, choose one of the codes defined in the Recurring transactions table and press Enter:
    • The programme inserts repetitive rows that have the same code.
    • IIf you need to modify or complete any values, you can always do so.
  • Rows stored in the Recurring transactions table can be resumed by entering the code in the Doc column and pressing the F6 key.

Copying transaction rows from the Transactions table into the Recurring transactions table

In order to copy rows from the Transactions table into the Recurring transactions table, you need to:

 

 

Automatic transactions with recurring deadlines

Automatic transactions are useful for facilitating the recording of repetitive entries, such as subscriptions, insurances or taxes. By using automatic transactions, you only have to enter the entry of interest once, set a few parameters such as the start date, the frequency and the end date and then Banana Accounting Plus will inform you when an automatic transaction is ready to be created and will create it for you.

In Banana Accounting Plus, there are two ways to create automatic entries: directly from the Recurring Transactions table or from the Manage Automatic Transactions dialogue.

Requirements

Adding the End Date and Repeat columns to your accounting file

To be able to activate the commands for automatic transactions, the End Date and Repeat columns must be added; without these columns the commands will not be displayed.

  1. Open your accounting file or create a new accounting from the File menu > New command.
  2. Select the command from the Tools menu  > Add/Remove Functionalities...
  3. The Add/Remove Functionality dialogue will appear with the list of available functionalities.
  4. Select the option Add End Date and Repeat columns in Transactions table. 
    If this option is not available, check the Banana version and the plan you are using, as described in the Requirements section. 
  5. Click on the OK button.

registrazioni automatiche

 

Creating an automatic transaction from the Recurring Transactions table

  1. Select the command from the Actions menu > Recurring transactions > Create automatic transaction.
  2. The Recurring transactions table will appear with a new row, showing the date of the day in the Date column and the text !Auto in the Doc column, which serves to identify the automatic transaction.
  3. Update the Date column with the date of the first occurrence you wish to schedule.
  4. Display the End Date and Repeat columns with the command from the Data menu > Columns setup... 
    Make sure to check the Visible box for both the End Date and Repeat columns. 
    If these columns are missing, you can add them as described in the Adding the End Date and Repeat columns paragraph.
  5. Add the desired repetition to the Repeat column. For example, if you want a quarterly repetition, enter the text 3MS in the Repeat column.
  6. If the automatic transaction has an expiry date, set it in the End Date column.
  7. Complete the Description, Debit Account, Credit Account and Amount columns.
  8. Select the command from the Actions menu > Recurring transactions > Manage automatic transactions to display the scheduled transactions.

Note: If you use the command from the Actions menu > Recurring transactions > Create automatic transaction from an existing transactions in the Transactions table, the Description, Amount and Accounts columns will show the text of the original transaction.      
The Create automatic transaction command is also available in the context menu of the Transactions table (right-click on a transaction, and choose the Create automatic transaction command).

 

Creating an automatic transaction from the Manage automatic transactions dialogue

  1. Select the command from the Actions menu > Recurring transactions > Manage automatic transactions.
  2. The Manage automatic transactions dialogue will appear.
  3. Click on New automatic transaction button at the bottom of the dialogue.
  4. Complete the necessary fields:
    • Start date     
      Date from which the first automatic transaction will start. When the transactions are generated, this date will be updated with the date of the last automatic transaction created.
    • End Date
    • Repeat
    • Description
    • Account
    • Contra-account
    • Amount
    • CC1, CC2, CC3
    • Name or description (optional)
  5. Click on the OK button.