Updates for Excel
Browse published versions and see what changed in each one.
Published versions
1.6.20 Licence management, PDF/XML review and Outlook
- Manage or change the licence code from the ribbon after successful verification.
- The check validates the XML and the generated ZUGFeRD PDF.
- A combined preview supports visual review before final creation.
- Direct Outlook sending is optional.
- A visible draft remains the default.
- Consistent controls, clearer setup and download progress in MB improve usability.
1.6.19 More reliable values from Excel
- Formula errors and invalid VAT rates are reported.
- Numeric and VAT values stored as text are recognised.
- Reading accounts for narrow columns, hidden rows and filters.
- Inserting a customer prompts before overwriting cells.
- Long item lists load faster.
- The German and English interfaces were made more consistent.
1.6.17 Payment QR code and more resilient template references
- Combine multiple description columns in a defined order.
- Named ranges preserve item references when rows or columns are inserted.
- An optional bank transfer QR code appears on the PDF.
- The release updates ZUGFeRD to 2.5.2 and improves final PDF/A checks.
1.6.16 Payment terms and Outlook drafts
- Enter multi-line payment terms or read them from an Excel cell.
- For outstanding amounts, the assistant checks for a due date or payment terms.
- New Outlook profiles create HTML drafts.
- Plain text and signature selection remain available.
1.6.15 Setup, buyer registration and save protection
- The setup assistant opens automatically only once.
- Descriptive headings can be assigned to items.
- The buyer’s legal registration identifier is supported.
- Closing detects unsaved edits.
- Invalid control characters are reported with their location.
1.6.14 Invoice types and final payments
- Assign fixed or per-line units, continuation text and additional seller identifiers.
- Invoice references can extend beyond twelve entries.
- Advance payments, partial invoices, credit notes and corrections have clearer distinctions.
- Final invoices can include a full payment statement.
- Corrections link back to the original invoice.
- Item net and invoice net totals are checked separately.
1.6.13 Clearer validation messages and invoice references
- Validation messages identify the field or item and can be copied as a report.
- Date errors show the input and its source.
- More shorthand for flat rates and hours is recognised.
- Reference up to twelve earlier invoices by number and date in ZUGFeRD and XRechnung.
1.6.12 Setup only in visible Excel sessions
- Background launches by other applications do not open setup, activation or update windows.
- Pending setup is cancelled when Excel closes.
1.6.11 More room in the setup window
- Setup opens larger and remembers its size.
- Long step names wrap and actions remain reachable with larger text.
1.6.10 Individual amounts and more precise totals
- Combine discounts, charges, payments and retention amounts from several cells or manual entries.
- Individual sources can be saved.
- Section subtotals are distinguished from items in supported templates.
- Read errors show the Excel row and total checks catch single-cent discrepancies.
1.6.9 Guided setup and help
- A new nine-step assistant guides users through templates, required fields, numbering, archiving and other settings.
- Setup can be resumed.
- Press F1 for field help.
- The ribbon links directly to the documentation and blog.
1.6.8 A more compact update window
- The version and title share one line.
- The window adapts its height to the message.
1.6.7 Improved recognition of large templates
- Recognition improves for multi-page item tables, repeated headers and merged cells.
- Tonnes and more flat-rate abbreviations are supported.
- Zero-value items and payments entered with negative signs are handled more reliably.
1.6.6 Aligned input fields
- Single-line text, number and selection fields remain vertically aligned when Windows text size changes.
1.6.5 More readable installer
- The install action and licence terms remain readable with larger text.
- The window has a suitable minimum size.
1.6.4 Save and update directly
- The update saves workbooks, lets Excel close normally and starts the signed installer after Excel closes.
- Cancelling a save stops the update.
- Input controls and customer labels were improved.
- The email preview uses the selected invoice numbering format.
1.6.3 Flexible item ranges and construction billing
- Read items from multiple or named ranges and compare quantities with line totals.
- More units were added.
- The update supports retention, early payment discounts, construction progress invoices and partial or final settlements.
1.6.2 Correction lines and tax checks
- Negative quantities are supported for correction lines.
- Zero-rated and out-of-scope items receive more appropriate checks.
- The update dialog adapts to larger text.
1.6.1 Invoice numbering, journal and Outlook
- Automatic numbering skips numbers already used.
- Refreshing reserved journal entries takes the current Excel values.
- Outlook signature images remain embedded in saved drafts.
1.6.0 Installation per Windows user
- Installation applies to the signed-in Windows account and normally requires no administrator rights.
- Both 32-bit and 64-bit Excel are supported.
- This version uses manual updates through the browser.
- The application shows the available version and download address.
1.5.0 Central customer management
- Search, edit, archive and export customers as CSV.
- Import recipients from an invoice or insert them into an Excel template.
- Customer management flags possible duplicates.
1.4.0 Invoice journal, archive and backup
- A shared local journal manages numbering, validation status and generated files across workbooks.
- Numbers can be reserved and duplicate final numbers are blocked.
- Backups can include invoice files.
- Settings can be saved centrally or per workbook.
- The ribbon includes an update check.
1.3.0 TabellenFaktura for Excel
- Early release catalogue entry under the TabellenFaktura brand.
- The add-in uses existing Excel invoice templates for electronic invoicing.
Your ideas make TabellenFaktura better
What would make your daily work easier? Small suggestions help too.
Submit an improvement suggestion