Product Release: 1812

The principal enhancements in version 1812 are as follows:

Payments – Analysis of Payment Transaction

The current payment process generates a single payment transaction per creditor irrespective of the number of invoices being paid. Because of this consolidation, the payment transactions do not contain any analysis information that may be held on the invoice.

A new flag called “Analyse Payments” has been added to the Instance Settings, under the Configuration tab. If this flag is enabled, the payment process will generate separate payment transactions in both the creditor and bank accounts for every combination of analysis of the invoices being paid.

Depending on whether analysis information is being captured on an invoice header or the individual invoice lines, the resulting creditor account can result in multiple transactions against a single invoice. When a Creditor Remittance is created, these analysis transactions are combined into a single value for each invoice in the remittance.

Likewise, the payment transaction in the bank account may consist of a number of analysis transactions. When using Manual or Automatic Bank Reconciliation, these functions combine the transactions into a single value for each payment to correspond with the amount in the bank statement. An icon is displayed against any line that is a combination of transactions, which can be used to view the breakdown of the individual transactions.

Bank Transactions Import Rules

The Common Rules, defined under the Configuration tab, have been enhanced to provide options to modify the text read from the account statement. The example below shows a simple replacement of one word for another. The second is a more complex example replacing multiple space characters in the description with single spaces. Note that the Replace With parameter requires a space character to be entered.

Bank Statement Import

The bank statement import process, used in Automatic Bank Reconciliation and Bank Transaction documents has been enhanced to test whether a statement has already been uploaded.

The user has the option to either continue with the upload or cancel.

Financial Reports

There are certain conditions when a financial report is displaying a calculated row that the calculated columns are showing the wrong signs. A typical example below is showing the Gross Profit as a positive difference instead of a negative difference.

A new parameter has been added to the row definition for calculated rows to reverse the sign of any calculation.

The result of this change is:

Note – A few users have difficulties defining calculated columns to show the correct signs. In the example above, either the difference column or the difference percentage column display the wrong sign. The correct configuration is to set the “Apply Category Sign” = No in both cases and for the percentage calculation use the ABS function on the divisor.

Person Edit

As an aid to setting up and maintaining a person’s permissions, it is now possible to link directly into Workflow Groups to view and maintain that person’s workflow group settings.

Cash Receipts – Printing and Emailing

It is now possible to print a formatted document based on a Cash Receipt document and email the document to the email recipient specified in the document header.

If you are interested in using this feature, contact to discuss enabling the option and configuring the formatted document.

HMRC – MTD (Making Tax Digital)

This release contains all the functionality to allow the VAT 100 reports to be submitted through the new HMRC VAT MTD portal. Aqilla will continue to support the current VAT 100 process and the new MTD functionality, which will be switched on by company using the new parameter in Company Edit. Once MTD is enabled for a company it will no longer be possible to submit VAT returns using the old VAT 100 functionality although it will still be possible to view the details of VAT returns created prior to MTD.

While we are performing pilot live trials with HMRC, MTD cannot be enabled through Aqilla. We expect the functionality to be fully available to Aqilla users in our next software release when we will provide more details of the use of the MTD functionality.

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.