Skip to Content
portcora / Help centre
Import & mapping

Supported accounting files

The file formats, columns and reporting scope supported by the current accounting actuals importer.

Read as Markdown

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.

FileRequired column namesWhat it provides
Trial balance / SuSaSachkonto, Sollbetrag, Habenbetrag, Eröffnungssaldo, EndsaldoYTD P&L and closing balance-sheet values
Dated account postings / ledgerSachkonto, Sollbetrag, Habenbetrag, BuchungsdatumMonthly 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

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

  • 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

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.

On this page