80.3 Excel Report and Item List
80.3.1 Overview ¶
The Excel report (XLSX) summarizes the processing runs of a period, prepared for accounting and review. It can be generated manually via the log toolbar (Create Excel report…, with a period/options dialog, see chapter 5.3) or automatically on a schedule, saved and/or sent by email (see chapter 40.8).
80.3.2 Report structure ¶
| Sheet |
Content |
| Overview |
Status and task totals of the period |
| Successful processing |
One row per invoice file with invoice data (number, dates, amounts, parties) and the task results (target paths, recipients, printers) |
| Errors |
Failed processing runs with messages |
| Not overwritten |
Files whose target already existed (conflict behavior “Cancel”) |
| No match |
Files excluded by the filter |
| No invoice data |
Files without readable invoice data |
The sheet names carry the entry counts; a file’s overall status follows its most severe task result.
80.3.3 Item list via CSV ¶
For analyses at line item level (one row per invoice line item), the Save extract as CSV task with line item fields is the right tool (see chapter 11.3) - e.g. a monthly collective CSV with item, quantity, and unit price per line.