Summer is here so along with the tennis, the strawberries and cream (and probably umbrellas) we’re pleased to release a whole range of new features in Aqilla, all of which are provided to all end-users on a opt-in, use as needed basis.

New “Un-Match” Function

The new function found under the Processes tab provides a means of easily un-matching transactions within an account. Un-Matching can be used on any account type, by selecting an account and then the Matching Id of the transactions to be un-matched. If a bank account is selected, reconciled transactions will be un-reconciled. Note that this function only clears the matching information. Additional manual procedures may be required such as reversing a payment or clearing realised currency adjustments.

Automatic Bank Reconciliation

The function can now perform a new one sided reconciliation. For instance, if a transaction has been incorrectly entered in the bank account and then subsequently reversed, there may be no record of the transaction in the bank statement. The function now allows the user to reconcile the original transaction to the reversal.

Financial Reports

It is now possible to report by any user defined numeric values in the ledger as well as Base and Currency values. For instance, if Time is being passed to the ledger from Timesheet documents, this can be selected in a report column when defining a report.


A new feature has been added to Projects to allow individual rates to be defined against a Person and Time Type. Thus on a per project basis it is possible to define what rate is to be used for a particular type of work.

Microsoft Excel Add-in and RESTful API Enhancements

An optional update to the Aqilla Microsoft Excel Add-In is available which now provides support for:

  • Maintaining Lookup Values.
  • Maintaining Fixed Assets record data

The Aqilla RESTful API also now provides support for third party currency rate integration.

E-book: Dispelling the (five) myths of accounting in the Cloud

Month or year end doesn’t have to be slow or difficult. Here is a best practice guide to the busiest times of the accounting and finance year with 5 tips to facilitate a quicker and more efficient period end.