# Supported accounting files (/docs/imports/supported-files)

## Accounting actuals [#accounting-actuals]

The importer accepts supported **UTF-8, semicolon-separated CSV accounting exports**, not arbitrary spreadsheets. Amounts use German formatting, such as `1.234,56`. Dated postings use `DD.MM.YYYY`.

| File                            | Required column names                                                   | What it provides                         |
| ------------------------------- | ----------------------------------------------------------------------- | ---------------------------------------- |
| Trial balance / SuSa            | `Sachkonto`, `Sollbetrag`, `Habenbetrag`, `Eröffnungssaldo`, `Endsaldo` | YTD P&L and closing balance-sheet values |
| Dated account postings / ledger | `Sachkonto`, `Sollbetrag`, `Habenbetrag`, `Buchungsdatum`               | Monthly P&L movements from posting dates |

The description is read from the column immediately after `Sachkonto`. Preserve account codes and export structure. If your export differs, ask your administrator before importing.

## Mapping files [#mapping-files]

Optional reference mappings can be **CSV or XLSX**. Generic mappings identify an account column named `account`, `konto` or `sachkonto`, and a target column named `target`, `metric`, `metricId` or `reporting category`.

Specific Loyos worksheets `GuV - P&L` and `Bilanz - BS` have a dedicated reader. Account codes and targets must be literal values, not formulas. Review detected assignments before saving.

## Scope and limits [#scope-and-limits]

- Up to **20 MB per file**.
- One trial balance and/or one dated ledger, plus an optional mapping; not a batch of multiple trial balances or ledgers.
- **EUR**, **GKV** and **calendar-year YTD coverage starting in January**.
- Coverage stays within one year and must match ledger dates.
- A ledger without a trial balance provides P&L actuals, not balance-sheet values.
- A trial balance without a dated ledger preserves P&L as a YTD interval, without fabricated monthly splits.

## Not supported by this flow [#not-supported-by-this-flow]

PDF extraction, generic financial XLSX actuals, budget workbooks, customer/supplier group templates, headcount, facilities and qualitative reporting are not part of this actuals import. The XLSX option here is for mapping.

Continue with [How to import accounting actuals](/docs/imports/import-actuals).