Guides
Insolvency expert report: what IT data the expert needs
Which IT data experts need to examine the grounds for opening, coverage of the costs of proceedings and the prospects of continuation, and how early preservation overcomes typical hurdles.
The insolvency court (Insolvenzgericht) appoints an expert and expects a report promptly. The debtor’s management can hardly be reached, the latest management accounts (BWA) are months old, and the tax adviser has stopped work because of unpaid fees. Accounting and ERP are on the server, but nobody on site can operate the systems. For court-appointed experts, this situation is not unusual. This article shows which data is typically needed for an insolvency expert report, where it can be found and how rapid preservation can speed up the preparation of the report.
The expert’s mandate in the preliminary proceedings
Under § 5 InsO (German Insolvency Code), the insolvency court must investigate of its own motion all circumstances relevant to the proceedings and may in particular commission experts for this purpose. If a preliminary insolvency administrator is appointed, the court may, under § 22(1) sentence 2 No. 3 InsO, additionally instruct them as an expert to examine whether grounds for opening exist and what the prospects are for continuing the business.
In terms of content, three questions are usually at the centre:
- Grounds for opening: Is there illiquidity under § 17 InsO, is it imminent under § 18 InsO, or is there over-indebtedness under § 19 InsO?
- Coverage of the costs of proceedings: Are the assets likely to be sufficient to cover the costs of the proceedings? Otherwise, dismissal for lack of assets under § 26 InsO comes into consideration.
- Prospects of continuation: Can business operations be continued, and under what conditions?
Each of these questions requires reliable figures. And these figures are mostly held in the debtor’s IT systems.
What data the expert typically needs
Financial accounting and reports
Financial accounting is the central source. The following are needed in particular:
- trial balances as of the current date and earlier reporting dates,
- management accounts (betriebswirtschaftliche Auswertungen, BWA) for recent months and previous years,
- annual financial statements for past financial years,
- account ledgers for bank, payables and tax accounts,
- the fixed asset register for valuing fixed assets.
However, the reports are only as current as the accounting. If it has not been maintained for months, the missing periods must be reconstructed from bank statements and vouchers.
Open item lists
For examining illiquidity, the liabilities that have fallen due are decisive. Accounts payable open item lists with due dates show which liabilities were outstanding at which point in time. Accounts receivable open item lists provide information on collectible receivables, which play a role both for liquidity and for the coverage of the costs of proceedings.
Liquidity planning and bank data
To establish illiquidity, a liquidity balance sheet or liquidity status is regularly prepared; for imminent illiquidity, a plan covering the relevant forecast period. The debtor’s existing liquidity plans, frequently a spreadsheet on a management computer, are a valuable starting point. Bank data with account balances, credit lines and transactions completes the picture.
Payroll data
Payroll journals and payslips show ongoing personnel costs, arrears in wages and social security contributions, and the basis for pre-financing insolvency benefit (Insolvenzgeld). For the continuation forecast, the staff structure is an essential factor. Guidance on preserving these holdings is given in the article on personnel files and payroll data in insolvency.
Order backlog from the ERP system
Whether a business can be continued depends largely on orders, inventory and margins. This information is held in the merchandise management or ERP system: order backlog, open purchase orders, inventory valuation, contribution margins. Exports from these systems are often more laborious than from financial accounting, because reports are individually configured.
Contracts
Lease, leasing, supply and customer contracts as well as financing agreements determine ongoing obligations and possible security rights. They are usually spread across file servers, email mailboxes and paper files.
Do not just ask for finished reports – preserve the underlying systems. The debtor’s reports may be incomplete or out of date; the system allows an independent examination.
Additional data for over-indebtedness and the continuation forecast
Examining over-indebtedness under § 19 InsO requires an over-indebtedness statement, i.e. a comparison of assets and liabilities. Whether going-concern or liquidation values are to be applied depends on the continuation forecast. For both steps, accounting balances alone are usually not sufficient.
For the over-indebtedness statement, additional information is needed that often lies outside financial accounting:
- inventory and stock lists with quantities and valuation bases from the merchandise management system,
- fixed asset registers with information on transfers by way of security and leased items,
- schedules of guarantees, letters of comfort and other contingent liabilities,
- information on provisions, for example for warranties or personnel obligations.
The continuation forecast is based on planning calculations. Corporate plans, cost calculations, framework agreements with customers and suppliers and data on order trends in past periods are informative here. These documents are typically held in management’s spreadsheets, presentations and emails. It is therefore worth including the workstations and mailboxes of senior management in the preservation at an early stage. The assessment itself remains the expert’s task, but the data basis must be fully available.
Typical hurdles in obtaining data
In practice, expert reports are often delayed not by the analysis but by obtaining the data. Recurring hurdles are:
- Lack of cooperation from the debtor: Management cannot be reached or provides information only reluctantly. The duties to provide information and cooperate under §§ 20, 97 InsO exist, but enforcing them takes time.
- Data held by the tax adviser: The accounts are kept externally, and the tax adviser refers to unpaid fees. How to deal with this situation must be examined in the individual case. Guidance is given in the article on DATEV data in insolvency.
- Blocked cloud services: Because of payment arrears, the provider blocks access to accounting, ERP or email services. The data exists but is not accessible.
- Lack of system knowledge: The employees who operated the systems have been dismissed or are no longer available.
- Outdated data: Bookings have not been entered for months, and vouchers are in disarray.
With cloud services in particular, time is pressing, because blocking is often followed by deletion. More on this on the page on the preservation of cloud services and Microsoft 365.
How rapid preservation speeds up the expert report
Early, complete preservation shifts the dependency: instead of waiting for individual pieces of information from the debtor, the expert works with a data set of their own. This brings several advantages:
- Independence: reports can be generated independently without having to rely on management or the tax adviser.
- Currency: missing booking periods can be supplemented from bank statements and vouchers contained in the preserved data set.
- Traceability: the report is based on a documented data state with checksums. Later queries can refer to the same state.
- Continuity: if the proceedings are opened, the data is already available for the avoidance review, collection of receivables and tax obligations.
It has proven effective to first preserve the systems completely and then generate the reports needed for the expert report in a targeted manner. Where systems can only be operated with specialist knowledge, a prepared analysis can help, as described on the page Data preparation and research.
From the expert report to the opened proceedings
The expert report is usually only the first step. Upon opening, the same data is needed for further tasks: examining claims for insolvency avoidance, fulfilling the bookkeeping obligations under § 155 InsO and subsequent retention. Anyone who has already carried out a complete preservation in the preliminary proceedings does not have to repeat this work. If, on the other hand, the petition is dismissed for lack of assets or withdrawn, it should be clarified how the preserved holdings are to be dealt with, in particular who keeps them, who may access them and when they are erased in compliance with data protection law. These questions are also easier to answer if the scope and storage location of the preservation have been documented from the outset. Which data is relevant for avoidance in detail is covered in the article on the avoidance review.
Beweisanker carries out the insolvency data preservation as early as the preliminary proceedings, including at multiple sites and from cloud services, and provides the holdings to the expert in analysable form.
Frequently asked questions
Which data is most important for examining illiquidity?
As a rule, accounts payable open item lists with due dates, bank data with account balances and credit lines, and a current trial balance. A liquidity status can be prepared from these.
What should be done if the accounts have not been maintained for months?
Missing periods can often be reconstructed from bank statements, vouchers and payment transaction data. The prerequisite is that these sources have been completely preserved.
May the expert access the debtor’s IT systems directly?
This depends on the court order and the role in the proceedings, for example as a preliminary administrator with an expert mandate. The scope of the powers must be examined in the individual case.
Why are the latest management accounts (BWA) not sufficient for the expert report?
A BWA is a condensed report as of a particular date. To establish grounds for opening, individual details of liabilities due and available funds are generally needed.
This article is for general information only and does not replace legal advice in the individual case.
Direct line
Urgent preservation?
Call us. We usually agree the scope and next steps during the first conversation.
- Response usually on the same working day
- Preservation on site or remotely
- Binding quotation in advance
Read more
More guides
Liquidating a GmbH: checklist for IT and data from the dissolution resolution to custody of the records
What managing directors and liquidators should do with accounts, cloud, accounting, servers, website, hardware and paper records in each phase of the liquidation, so that nothing is missing once the GmbH has been deleted.
Read article →Selling customer data in insolvency: value, permissibility, process
How insolvency administrators realise a customer database in an asset deal, which data may be transferred without consent and how the value of a customer base can be estimated reliably.
Read article →Continuation of business operations: keeping IT running in insolvency
How insolvency administrators keep IT stable during the continuation of business operations: critical systems, service providers and estate liabilities, key personnel, data preservation and an emergency plan.
Read article →