Product Release 2022.07

Aqilla delivers open banking, multi-currency expense management, enhanced enquiries & automatically recurring Smart Events

We are excited to announce our Midsummer Release, delivering open banking features, multi-currency expense management, enhanced enquiries and automatically recurring Smart Events. For exclusive access to our full release notes click here.
1. Integration with open banking using Plaid

It is now possible to directly link customer bank account information with Aqilla. This provides up to date statement information automatically uploaded into Aqilla from banks that support the open banking (PSD2) interface. This provides a common interface for most banks in the UK, US, Canada and several  major European countries.

Once the Aqilla user has established the link to their bank using a simple connection wizard the bank transactions are made available in Aqilla for creating bank transactions, such as customer payments using Aqilla’s inbuilt intelligent matching rules and for automatic bank reconciliations.

Note that more detailed information about setting up the link can be found in the Aqilla Help.


Up to date bank balances can be viewed through the existing Bank Account Details function or by use of a new open banking balance gadget that can be added to individual user’s home pages. Note that this gadget is Protected by default and permission must be given to the individual users that are to be given access to this gadget.


The processing of the imported transactions is automatically monitored by Aqilla and alerts can be setup to notify users of:

  • The volume of transactions imported
  • Any issues with the connection to the bank
  • When the connection to the bank needs renewing (usually every 90 days)


These notifications are created through the Aqilla Smart Events in the new Templates section.

Two example templates are provided that can be copied for use against individual Financial Institutions. One event deals with general errors and warnings, the other provides information on uploaded transaction counts.

Once the templates have been created, they are assigned when setting up a Financial Institution or by later editing the Financial Institution.

The details of the notifications can be sent to email recipients or Smart Event gadgets. These notifications are also shown in the Ad-Hoc Calendar tab in SmartEvents.


2. Multi-currency Expenses

It is now possible to enter expenses in a number of foreign currencies in a single expense claim document. For example, if your main currency is GBP, individual expenses can be specified in EUR and the GBP equivalent is calculated automatically.

This feature must first be enabled by setting the “Currency in Expense Lines” flag in Instance Settings.

Once enabled, a currency button is displayed before the Net Expense column for lines that allow entry of expense values (i.e. not mileage claims). Pressing the button opens a dialog box allowing a different currency to be selected. This will use the currency rate setup in the currency tables applicable for the expense date but either the Currency Rate or Claim Amount can be specified.

If any multi-currency transactions have been entered, an additional column is displayed showing the Currency Amount. The currency button changes to reflect the currency entered. Note that if the currency Symbol has been defined against a currency then this will be displayed in front of the Currency Amount.

3. Enhanced Filtering in Enquiries and Reports

When using additional filters,  Aqilla will provide a smart search lookup of valid values in many more places than previously. For instance, if filtering an account by Project Code, a list of valid codes is now offered. Previously, the user would have to manually enter the code.


4. Currency Variable Enforcement

Each account has a Currency Variable flag, which is used in parts of Aqilla to limit whether the user is allowed to process currencies other than the Account Currency.

If Currency Variable is set to No, the control has been extended to limit in Sales and Purchase Invoices the currency that can be specified, if different to the Account Currency of the Debtor or Creditor. Likewise, the Bank Transactions document limits the currency that can be specified for individual bank accounts.

5. Smart Event Recurrence Options

A new option has been added to specify that an event occurs on the last day of a specified day of the week when specifying Monthly or Yearly repeats.


6. Promotion Button Sequence

The document promotion buttons (e.g. Release, Approve, Reject, Rough Post, Post, etc.) are now displayed in alphabetic sequence when more than one promotion is valid at a particular document state. Previously, the same options could be displayed in different sequences depending on the document’s workflow.