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
Accruals and Prepayments
Two auto-expansion options have been added to provide better control of how the Financial Reports are displayed.
- 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.
- 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”.
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.
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.