March, 2025

Go Cardless: Phase 2

We have extended our GoCardless functionality to include automated posting of instant payments.

When this feature is enabled and a payment is made via an instant bank payment link, a draft receipt will be automatically recorded against the invoice. Once the payment has cleared into the GoCardless wallet, iplicit will automatically post the draft receipt. This will increase the accuracy of these transactions and reduce effort.

The GoCardless payment service settings have been extended to include an on/off toggle for the automated posting and the ability to select a Payment service account to post the automated receipts to.

Multico Journal

Our intercompany functionality has been extended to include a new manual journal type Multico Journal, which automates intercompany with multiple Intercompany Legal Entities to & from a single primary Legal Entity.

When using this feature, a single journal can be entered or imported into the system against the primary legal entity with lines coded to multiple intercompany legal entities. The process automatically generates the corresponding intercompany journal entries, ensuring proper accounting and compliance with intercompany transaction policies.

This process streamlines financial reconciliation and enhances accuracy by eliminating the need for manual journal creation across multiple entities. A common use case is processing payroll journals that span multiple entities.

Contact Account Data Access Control

We have introduced support for Data Access Control on Contact Accounts in iplicit. This feature enables administrators to apply data access control by legal entity to specific Customer, Supplier and Resource Groups within iplicit.

This new feature works in conjunction with iplicit user roles and define whether the user can create, edit or view suppliers, customers and resources records based on their Legal Entity access defined in Data Access Control.

When the feature is enabled on a Customer, Supplier or Resource group in iplicit, Legal Entity becomes mandatory for all contact accounts within that group and the records are protected by Legal Entity Data Access Control.

This enhancement is beneficial for restricting specific contact account records from being shared across legal entities in iplicit, whether to protect sensitive data or improve data entry quality.

Additionally, the import functionality has been enhanced to ensure that contact accounts added or updated via import behave according to the assigned DAC rules.

Performance enhancement with smart row limits.

To ensure faster performance and a smoother user experience, we've introduced a smart limit on Enquiry results to prevent system slowdowns from excessive data loads.

By default, enquiries can return up to 100,000 rows, with exceptions available for specific cases. If a query reaches the limit, users will receive a clear notification with guidance on refining their search. This enhancement optimizes efficiency while maintaining system reliability and responsiveness.

Find out more about limits and filtering here.

Data Import & Export Enhancements

A significant number of improvements to importing, exporting and updating data in iplicit have been made:

  • Catalogs

    • Available in the Catalogs menu.

    • The function now supports both importing and exporting.

    • Import routine includes the ability to update a record as well as add a new record.

    • All types of catalogs are supported, including custom attributes.

  • Suppliers

    • Available in the Suppliers menu.

    • The function now supports both importing and exporting.

    • Ability to update existing supplier records as well as creating new ones.

    • All fields on a supplier record are supported.

  • Cost Centre

    • Available in the Cost Centre menu.

    • The function now supports both importing and exporting.

    • Ability to update existing cost centre records as well as creating new ones.

    • All fields on a cost centre are supported.

  • Department

    • Available in the Departments menu.

    • The function now supports both importing and exporting.

    • Ability to update existing cost centre records as well as creating new ones.

    • All fields on a department are supported.

  • Product (generic import)

    • Available in the Interfaces menu.

    • The function now supports posting attributes against the product: cost centre, department and fund.

    • The function now supports tax band to be imported on the product.

  • Fixed Asset

    • Available in the Fixed Assets menu.

    • Custom fields are now supported on imports.

    • Assets that have already been disposed can now be imported.

  • Contact and Document imports

    • The user can now select the appropriate date format to use when importing data.

  • Resource

    • Import/Export now includes username to indicate the relevant user account the resource is linked to, when applicable.

  • For consistency with other Imports, e.g. Projects, the Full Import option has been removed from the import overlay on:

    • Supplier import (Suppliers & Contact Accounts finders).

    • Customers import (Customers & Contact Accounts finders).

    • Resources import (Resources & Contact Accounts finders).

    • Contact bank import (Suppliers, Customers, Resources & Contact Accounts finders).

  • Exporting data from enquiries

  • Improved formatting when exporting pivot enquiries with multiple grouping levels of columns/rows.

  • Fix implemented to resolve an issue whereby local time zones were causing a time difference in exported excel documents.

Deferred income & Prepayments

Significant enhancements have been made to Deferred Income and Prepayment Schedules.

While the invoice is in draft a draft state, users can now adjust the amounts and dates of deferments/prepayments to align with business accounting rules. Changes are logged with timestamps and user details. Validation ensures dates cannot be set before the start date, and total amounts must match the original amount to be deferred.

We have introduced support for weekly distribution profiles that can be used with deferred income and prepayments. Profiles can be configured to distribute every “x” number of weeks from the start date, allowing for better alignment with specific business requirements and non-standard accounting periods.

Fixed Assets

Support has been added to generate the depreciation book and related postings with a four-weekly frequency for straight-line depreciation. New depreciation methods have been added to enable the use of the new depreciation frequency.

Other Enhancements

  • SOFA Dynamic Accounting Structure

    • The SOFA format has been added as an authored Dynamic Accounts Structure (DAS), following the FRS 102 format

    • Chart of accounts codes can be mapped to the new structure to produce enquiries in the SOFA reporting format

  • Irish Enhance Expense Reporting Enhancement

    • Irish ERR users can now include payments for documents with line items that do not contain a main ERR category in bulk payments.

      When generating the Revenue Ireland Expense file, only expense document items with a main ERR category will be included in the report. This allows you to process bulk payments covering both ERR and non-ERR expense items while ensuring accurate ERR reporting to Irish Revenue.

  • Project Trial Balance

    • A new tick box has been added providing the ability to reverse the signage on amounts displayed on the Project TB; the amounts will be reversed so income is negative and expenditure is positive.

  • Bank reconciliation: Cash Sales/Purchases

    • Our bank reconciliation feature now allows users to create and post Cash Sales and Cash Purchases directly from the Bank Reconciliation screen.

      When the user has the required permission and the bank account is enabled for Cash Sales/Purchases, the Quick Transaction drop down on unmatched bank transactions will present a Cash Sale or Cash Purchase option based on whether the item is a deposit or withdrawal.

      Selecting this option allows the transaction to be created and submitted, which is then automatically matched in the bank reconciliation. This enhancement improves efficiency via a better user workflow and streamlines the reconciliation process.

Products & Stock

  • Standard-priced SKUs now correctly show the defined standard cost instead of being blank or incorrectly calculated as an average.

Settings and Configuration

  • The stock valuation process now displays a clearer, user-friendly error message when attempting to run a valuation while a draft valuation already exists.

  • A copy option has been added to the ellipsis menu so that a new Dynamic Accounting Structure (DAS) can be created by copying an existing one.

  • The FX realised process has been enhanced to enable the posting of the gain/loss journal to the accounting period that the invoice was settled in.

    • The Document date = allocation check box on the FX Realised process screen has been updated to Document date = settled date and its functionality has been revised to create the FX document in the accounting period of settlement instead of allocation.

  • Enhanced security on My Authorisation role. The ability for these users to drill down into supplier details has been disabled

  • The Include Draft tick box on the Credit Control screen has been removed.

  • The Order no. field is now available in the Purchase Invoice and GRN finders as an option column, enabling the ability to filter by the value and easily see the related Purchase Order tagged on the header.

  • Introduced the ability to disable the Include closed Periods options from the Correction posting attribute process to prevent users being able to run against documents in closed periods. If attempted, an error message will now appear advising: Posting attributes corrections cannot be run for closed periods.

  • In My Settings, Bank accounts without the required flag enabled will no longer appear in the selection lists for:

    • Cash Purchase Bank Account

    • Cash Sale Bank Account

    • Receipt Bank Account

    • Payment Bank Account

    Only bank accounts with the corresponding flag enabled will be available.

  • Fixed an issue where Sale Quote drop down lists were displaying documents that were not Sale Quotes.

  • In My Expenses, the Resource field is no longer editable following a copy exact of an expense that has been created

  • The help text on the Document type setting 'matching required' has been updated to: Tick this box to enforce matching. This must be ticked for matching tolerances to take effect.

Support and Other Minor Fixes

  • Help link from the Document templates screen now opens the correct page of the user guide.

  • Help link from the Project groups screen now opens the correct page of the user guide.

  • Download link to the csv template for SSO import updated in the SSO Wizard pop-up.

  • The Their Ref value is now correctly showing the Supplier name in the Result column under the Mappings tab in APA documents.

  • Selected attributes, such as Cost Centre and Department, now appear in the correct order, as chosen, during editing on the Budget Forecast.

  • The Last Modified timestamp and username on documents are updated appropriately when a posting attribute correction is performed.

  • Fix implemented to ensure debit/credit values remain consistent with the original recurring Manual Journal template, regardless of legal entity currency changes.

  • Removed unnecessary validations on Penny Difference corrections.

  • Resolved issues where reversals of Purchase Order accruals created duplicates in certain scenarios.

  • When creating Sales Invoices from disbursements, the available automations are now cleared down so they can be manually selected again against future invoices.

  • A fix has been implemented to ensure the Prepayments/Deferred Income Automation respects the selected date range and does not require the current month to be unlocked when processing past periods.

  • Minor issues with Credit limit validation have been resolved.

  • Fixed inconsistency with Project P/L values are now shown in Parent and Child Projects.

  • The AP automation setting on Suppliers to Override Currency is not available on bulk amend of supplier records.

  • Deleting a Tax Group now deletes the related MTD Registration for the group.

  • Updated the pricing on Timesheet Products to display more than the first fifty rows of prices.

  • Fix to prevent duplicates in Bank Payment files if the supplier has been set up with duplicate bank account details.

  • Validation added to ensure a Period cannot be created if the Date To is earlier than the Date From. An error will be returned to advise Date To cannot be before Date From.

  • New option in the Committed TB screen on projects that offers a choice of columns to be included in the display, including a new column Outstanding ordered which shows the remaining outstanding amount from purchase orders.

  • When creating a new expense claim, if the legal entity is amended, the bank account value now clears ensuring the correct bank account details can then be entered.

  • Various improvements and edge-case fixes on average cost calculations.

  • Improvements implemented around Sales Invoice allocation validation. A customisable limit can now be set on the number of allocations that are validated.

  • Fix implemented to ensure that prepayments and deferred income schedules are correctly updated when a related purchase or sales invoice is abandoned.

  • Improved tracking and automatic retrying of execution jobs to prevent documents getting stuck in a pending state.

  • Formatting and display issues resolved when the Stock Level Enquiry is exported to Excel.

Data Entry Control

  • Minor UI improvements when selecting available attribute values when configuring Data Entry Control.

  • Accuracy of Data Entry Control values on documents has been improved, ensuring that the correct values are shown when changing legal entities during document entry.

Enquiries

  • Profit/Loss

    • Fixed issues when using the Fund filter.

  • Budget

    • Fixed an issue where grand totals were missing when grouping by multiple fields in the columns and data sections. All totals are now correctly populated in the enquiry results.

  • Aged Debt

    • A fix has been implemented to ensure Credit control notes display the latest note per document/customer.

  • Periodicity Setup

    • All periods are now displayed correctly, whether open or closed, when the financial year active box is checked.

  • Improved support and validation added when **@CurrentUserAccountId** parameter is included in an enquiry.

  • Apple Mac users can now use the keyboard shortcut CMD Option C to get the ID of the item open on screen, such as the ID for an enquiry.

Reports

  • Enhancement to how Tax registrations details are selected in reports. The effective date of a legal entity's tax registration is now assessed against the document’s tax date (or document date if the tax date is null) to ensure the correct tax registration details are displayed. This has been applied to all authored reports that include tax registration numbers:

    • Cash Remittance: UK1

    • Purchase Order: UK1

    • Direct Debit: UK1

    • Sales Order: UK1

    • Sales Invoice: UK1

    • Refund: UK1

    • Remittance: UK1

    • Reminder Letter - Strong: UK1

    • Sales Dispatch: UK1

    • Sales Invoice - Timesheet: UK1

    • Sales Proforma: UK1

    • Customer Statement Multiple: UK1

    • Receipt: UK1

    • Reminder Letter - Polite: UK1

    • Sales Quote with Discount: UK1

    • Sales Invoice: UK1 - GoCardless Instant Payment

    • Cash Receipt: UK1

    • Credit Note: UK1

    • Sales Quote: UK1

    • Customer Statement: UK1

    • Sales Invoice Direct Debit: UK1

  • Customer Statement (authored)

    • When the Customer Statement report is run and the currency parameter is not filled in, the report will run with the default currency defined on the customer record.

  • Bank Reconciliation Summary (authored)

    • Corrected the run date format, it will now display in UK date format

  • Trial Balance – Summary (consolidated)

    • Updated so that it will now order Accounts by account code.

    • When using the Calendar year parameter, the drop-down list of years is now displayed in a logical (date) order.

  • Trial Balance (TB) and Aged Creditors

    • Resolved issues with specific combinations of user access and Custom Data Access Control configurations. With this fix, reports now display accurate balances, ensuring consistency across financial data.

  • Batch Payment Report

    • Logic has been corrected to properly account for intercompany bulk payments, ensuring all intercompany transactions are accurately reflected in the report.

  • Improved error messaging when previewing Reports that have issues. Additional logging has also been added for these exceptions.

Tax

  • Greece (GR)

    • Standard Rate Updated from 19% to 24% (as of 01/01/2024)

  • Northern Ireland (GBNI)

    • Tax code Exempt purchases ROW added

  • Singapore (SGEW)

    • Tax return treatment for Output Services Reversal ROW added.

Interfaces

  • Revolut Bulk Payment Interface

    • USD Swift (USD - GB)
    • EUR Swift (EUR - DK)
    • Routing file (USD - US)

  • RBS CSV BACS Bulk Payment

  • Sparkasse Bank Statement Import Interface

  • Coincorner Bank Statement Import Interface

API

See API changelog for an update on what's new.