Finac interface

General ledger

The interface to a financial accounting ensures that a multiple number of exposures are largely omitted. A separation between Treasury activities and financial accounting is ensured. Accounting activities can only be carried out independently of Treasury activities in the Finac module.

Account assignment in treasury
The transactions of the cash management module have associated assignments. Each transaction is automatically linked to a standard business transaction, which uses one or more booking functions to connect to the chart of accounts.

Further business transactions can be set up with the ‘DispoTypes’ function (Cashflows), which is standard in the Treasury module, and the associated DispoTypes (with scan / analysis functions of the MT940 messages). Any automatically generated account assignment can be revised or updated. (E.g., cost centers, projects, etc.).

Account assignment in finac
magnet® first assigns each business transaction to a mandator booking accumulation. The accounting department generates a booking wallet from the booking accumulation that contains all incidents that can be recorded. The booking wallets can be edited multi-user-compatible with the account assignment masks.

In the booking wallets, the bookings are checked and revised. With the booking run, the logical booking records are copied to one booking file per mandator. The automatic interface generation is run in parallel. The interface file transfers the data in ASCII format or as a web service to the general ledger.

Interface formats
There are standard interfaces, among others, to

  • SAP
  • CS/2 Wilken
  • MS Dynamics AX / NAV
  • Abacus
  • Sage
  • IFAS etc.

A/R Match /
Generating of debtor payments files

Debtor payments as SWIFT MT940 bank notifications can be processed with a high hit rate to a payment file by means of automatic matching of the open item list. This can then be imported into the Accounts Receivable.

The collection and decimation of non-structured payment receipts (for example, from abroad) involves a high manual effort. With ‘A/R Match‘ magnet® offers an additional module for the system-supported processing of such debtor payments.

Based on accounting rules and filters, which are individually defined, a selection of the debtor payments and a check for plausibility are made. These rules include invoice and customer numbersposting texts, and so on. To enable the open items to be cleared, the open item lists, enriched by other customer master data (for example, payment conditions, etc.), are copied from the accounts receivable into a daily batch run (upload). ‘A/R Match’ compares the information found in the electronic bank account statement against the current open item list. Cash discounts and permitted deviations are checked and taken into account. The payment amount is not always the same as the invoice document. In practice, payment instructions may be missing or incomplete. The customer may pay several invoices and accept allowed discounts and non-tolerated deductions in different combinations. Therefore, the electronic adjustment can be repeated several times. The user also has the opportunity to manually enter the process to improve the result. Because the success rate of the fully automatic adjustment is exceptionally high, relatively few cases remain for manual aftertreatment.

The overall processing ensures that all account statements are processed without interruption after completion of the process. The ‘debtor payment file‘ produced after the processing process is then read in the accounts receivable accounting.

Video content:

  • Module overview / Integration
  • Finac interface module
  • Standard interfaces
  • Debtor matching
  • Visualization of the debtor matching processes