Product Release: 1204

In keeping with the agile application development methodology employed by Aqilla, regular updates to Aqilla are made available to all subscribers every 6 to 8 weeks. New releases such as this one provide incremental features and functions designed to improve the user experience and extend capability at no extra cost end users. Furthermore, new functionality is provided on an ‘opt-in’ basis to minimise disruption to those users already familiar with the use of the Aqilla application.

Microsoft Excel Add-in

Now supports uploading of Accrual, Prepayments, and Bank Transaction documents.

Creditor Accounts

A new option has been added to the Creditor accounts to provide a Default Cost Account on Purchase Orders and Purchase Invoices. If set in the Creditor account, the Cost Account will default to this value when creating a new Purchase Invoice or Purchase Order line. The user may override this default account if required.

Accruals and Prepayments

Can now accept values in currency as well as the base currency.

Bank Transactions

When using currency transactions, the exchange rate is now looked up by reference to the date of the individual transaction dates.

Weekly Timesheets

It is now possible to create more than one timesheet for a person covering the same week although the system will warn that a timesheet already exists. This is useful if a week spans two periods and you wish to post the time to its associated period.

Financial Reports

Two auto-expansion options have been added to provide better control of how the Financial Reports are displayed.

  1. When a Financial Report is run, the report expands the hierarchies according to the setup of the report. A new button has been provided to expand all the rows of the report to their lowest level of detail. The button also toggles to collapse all rows to their most summarised level.
  2. When designing a Financial Report with a Breakout, it is now possible to make the report expand each sub-report to the report’s defined hierarchy levels, instead of a single total line for each breakout. This is defined in the configuration of the report as “Break out expanded”.


Multiple budget ledgers can now be accessed and posted to without adjusting the flags in the base Ledger Definition. A new flag in the Company Information now specifies which budget ledger is to be used for budget checking by Purchase Orders.

Accruals and Prepayments

A new configurable process has been added to calculate and post unrealised currency exchange differences To use this process users need to identify which currency is to be re-valued, at the same time nominating an appropriate Unrealised Exchange Gain and Loss account(s). Under the Configuration tab, users can then create an manage one or more Revaluation Profiles to determine how the revaluation will be performed against a range of selection criteria.

Selecting which profile to use and which period is to be re-valued. Aqilla will calculate the difference in the total base value for each account currently held in the ledger and the value calculated from the currency values and post the differences to each account and the balancing amount to the Unrealised Exchange Gain and Loss accounts defined for the currency. Note that any account can be excluded from the revaluation process by setting Supress Revaluation = Yes in the account setup.

If the Rough Post mode has been used, the transactions will be rough posted in the ledger and can be reported on before fully posting. Once Rough Posted, an option exists to either Post the Rough Posted revaluation or delete the rough journal. If Rough Post mode is not defined, the revaluation process will immediately fully post the revaluations.

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.