Rules for the automatic completion of imported transactions

Documentation •
In this article

This Banana Accounting Plus functionality drastically reduces recording times and errors. It will change the way you do accounting because once the rules are set, it's  the programme that completes the imported transactions with all the necessary information (Contra account, VAT code, Cost Centers, etc.).

How it works

Video: Import and complete transactions automatically

  1. Import bank transactions
    The programme creates the transaction rows with date, description, amount, account, document number, exchange rates.
  2. The Apply Rules dialogue opens
    • You see the transactions that are completed automatically.
      You can edit or delete existing rules.
    •  Add new rules for other transactions.
        In the rule enter the text to be searched, the contra account and other information to complete the transactions.
    •    Click on the Apply rules button.
  3. In the Transactions table you will find the transactions, complete with contra account, VAT code, cost centre and other information that you have indicated in the rules.

Easy to Use

  • The preview of the Apply Rules dialogue allows you to have full control over the transactions recorded in the Transactions table.
  • Adding rules is simple, for the following reasons:
    • The programme creates the rule using the transaction data.
    • As you enter the rule you will see which transaction the rule is applied to.
  •  If you are in doubt, you can cancel the operation and redo both the rule application and the import.
  • Already created rules are saved in the Recurring transactions table and you can edit, delete and add new ones.


  • You complete transactions in seconds.
  • You avoid errors and oversights.
  • Rules make it easier to delegate the import activity to other people.

A comment from one of our users:

"The auto-completion rules to import bank transactions work amazingly!
    Accounting has never been so easy and fast!"


 In order to use the auto-completion rules you would need to have installed:

Learning the functionality

Customers who have used the functionality are enthusiastic, and testify to us that, after an initial phase, necessary to understand how the rules work and how best to use them, their accounting work has been significantly reduced. We gladly make the following documentation available for you to try out and practice with examples:

Rules = Basic knowledge

We notice from customers that rules, in addition to facilitating transactions, also become a knowledge base that brings together the logic with which different transactions must be recorded in the accounts. In addition to completing transactions quickly and safely, they also make it possible to:

  • Easily check how certain transactions are to be recorded. No more need of scrolling through previous operations to remember how they were done.
  • Explain to people who have to do the accounting how to record various transactions.
  • Define for the auditor how to record certain transactions.

Automatic completion Rules

Automatic carry-over of rules into the New Year

When creating a New Year, the contents of the Recurring transactions table are carried over into the New Year file, so the knowledge base remains intact. It is therefore also worth using the rules for operations that recur once or only a few times a year, but which require special attention.

Tell us how we can help you better
If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

Share this article: Twitter | Facebook | LinkedIn | Email