We are delighted to launch of the latest version of Aqilla fit with MTD functionality.
The March 2019 release of Aqilla (1903) sees a whole new range of features bringing forth new Making Tax Digital (MTD) functionality for automatically submitting VAT information to HMRC; an option to filter on additional system attributes when using the Automatic Transaction Matching function; new Expense and Expense / Timesheet only user types; a whole range of enhancements to the user interface including coloured background themes, date entry shortcuts etc. and significant upgrade to the Microsoft Excel Add-In (which requires a mandatory upgrade to the Add-In) which now enables users to post to multiple companies, ledger dimensions and period within a single worksheet.
HMRC – MTD (Making Tax Digital)
The interface for submitting VAT returns through the HMRC MTD is now available. Full details as to the background of the MTD changes can be found in the relevant Making Tax Digital Aqilla Help article.
Although MTD is a technical change to the way VAT returns are submitted to HMRC and the calculation of VAT is unchanged, there are a number of issues that have been identified due to the removal of any ability to make manual adjustments to the VAT figures outside Aqilla. The following issues and resolutions are currently being addressed within the Aqilla software:
If anyone would like to discuss anything about the HMRC MTD process please contact our support at firstname.lastname@example.org and we will be happy to help.
A new option has been added to Transaction Matching to enable matching by a user-specified attribute within the selected account. When this has been selected, there is an additional selection in Automatic Match – “Match & Split”. In this mode all the transactions with the same value of the additional attribute will be matched together and any remaining difference will be split against the most recent transaction.
In the example above, Project Code has been used as the additional attribute. The first project (P001) fully matches but project (P002) has an outstanding balance.
If Automatic Match = “Yes”, Transaction Matching will still only match if the transactions have the same additional attribute and the same values.
If Automatic Match = “No”, Transaction Matching will not automatically match any transactions and the user may manually match transactions even if the values in the additional attribute differ. In the manual mode the user may also sort by any of the columns.
If filtering by the additional attribute is not relevant to a particular matching task, the option “Not Applicable” can be selected.
Two new, reduced licence cost user types have been added, to provide additional flexibility to Aqilla’s licencing. The new types are:
Users of these types are limited to only being able to enter their own expense or timesheet documents.
When entering dates into Aqilla, it is now only necessary to enter part of the date and the remainder will be deduced and displayed in the entry field. For instance, if today’s date is 6th March 2019 and “12” is entered into a date field the following is displayed:
If this is correct, the user may tab out of the field and the indicated date will be displayed.
The specification of the month, as a number, and year requires entering a date separator (either “/” or “.”). For example:
You may also part type date formats with the short month names. For example:
Entry of today’s date can be achieved by a number of shortcuts:
Relative dates are also now supported. For example:
Three optional parameters have been included into the document upload functions to provided additional control over what company and ledger a document is to be uploaded to within a single Aqilla instance. In addition, if the “Add and Post” option is used, you may specify what period the document is to be posted to.
These optional parameters are specified in the blank column between header and details.
In the example above, the worksheet contains four Miscellaneous documents that are to be added to four separate companies and posted to period Feb-19. These four documents may be selected as a single upload and posted in one go.
Note that the parameter names and associated values are case sensitive. The parameter values may be surrounded by double quotes, particularly if the values contain separators such as “,” or “:”. The posting period is specified by the name of the period, which must be open for posting.
This enhancement requires a mandatory update to the Aqilla add-in. Please contact email@example.com if you require help installing the update.
When working simultaneously on different companies, it is now possible to select a background colour from a selection of themes to highlight each particular one. this helps differentiate between multiple companies in the same instance. This is defined in the bottom left-hand section in Company Edit found under the Configuration tab.
The default is a light grey background, but users can switch back to the original white or a number of alternate solid or graduated hues.
We understand that this is down to personal preference however the default will set to grey.
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.