Lexoffice Import < 2025-2026 >

[Your System] --> (OAuth2 token) --> Lexoffice API ^ | | +--- CSV → JSON transformer (optional) | +--- Scheduler / Cron (for periodic imports)

| invoice_number | date | due_date | customer_id | line_1_description | line_1_quantity | line_1_price_net | line_1_tax_rate | line_2_description | line_2_quantity | line_2 lexoffice import

He was afraid of nothing—except maybe forgetting to save the backup. [Your System] --&gt; (OAuth2 token) --&gt; Lexoffice API

| Rule | Detail | |------|--------| | | UTF‑8 without BOM. Windows‑1252 will cause “invalid character” errors. | | Delimiter | Comma ( , ) – you can also use semicolon ( ; ) if you tick “Semicolon‑separated” in the import dialog. | | Header Row | Mandatory – column names must match Lexoffice’s field names (see the tables below). | | Date Format | ISO 8601 ( YYYY‑MM‑DD ). Lexoffice will auto‑detect DD.MM.YYYY but it’s slower. | | Decimal Separator | Dot ( . ). If you use a comma, enable the “European number format” toggle. | | Quote Handling | Enclose fields that contain commas, line‑breaks, or quotes in double quotes ( " ). | | | Delimiter | Comma ( , )

Emma's team spent hours reformatting the files, only to encounter errors during the import process. They tried to troubleshoot the issues but couldn't seem to get it right.