
TabellenFaktura is started with a clear goal in the test phase: An existing Excel invoice should be output as a verified ZUGFeRD invoice or XRechnung without cloud change. The first practical impressions have now resulted in a lot more. Good suggestions from testers have made concrete workflows visible – and several derived functions have already been implemented.
Version 1.4.0 added local invoice management to TabellenFaktura, with controlled numbering, a journal shared across workbooks, an invoice archive, backups and guided restoration. Version 1.5.0 extends this with central customer management. Customer data can be searched, checked, archived and transferred directly between the customer records and an Excel invoice. Invoice data continues to stay locally on the Windows PC.
Tester feedback becomes usable functions
A test phase is particularly valuable if not only individual buttons are evaluated. The complete process is decisive: Where does the next invoice number come from? How does a sent invoice remain to be found? What happens after a computer change? How often do the same customer data have to be maintained in different Excel files?
The feedback so far has sharpened these everyday points. Thanks to the good and concrete suggestions, new functions have not only been planned, but already in successive versions and tested. A simple output wizard is gradually developing a related, still Excel-close invoice process.
The latest extensions in direct comparison
| Area | Previous focus | Version 1.4.0 | Version 1.5.0 |
|---|---|---|---|
| Invoicing | Create and technically test ZUGFeRD and XRechnung from Excel | Connect creation with central journal and controlled invoice number | In addition, link recipient data to the central customer base |
| Invoice numbers | Take number from the respective Excel template | Reserve numbers centrally and block double use | Customer and invoice data interact in the same local process |
| Storage | Store result file at selected location | Record additional archive, check status, file path and SHA-256 check sum | Keep customer data centrally available for billing |
| Data backup | Backup workbooks and output files separately | Portable TFBACKUP backup with verified recovery | Take over customer base as part of central backup |
| Master data | Read receiver from the opened Excel file | Save template and program settings centrally or workbook-related | Search, filter, edit, export, archive and reuse customers |
New in version 1.5.0: central customer management
Many Excel invoices are generated from custom copies of a template. This is familiar, but easily leads to multiple addresses, VAT ID, electronic address or payment destination being maintained. Version 1.5.0 therefore complements a local customer base that works independently of individual workbooks.
The customer management covers the most important tasks of a small billing process:
- Search, filter and edit customer data centrally
- Export customer lists as CSV file
- Identify possible dublettes via customer number, VAT ID and name and address
- securely archive and reactivate active customers if necessary
- Add recipient data from an open Excel invoice to the customer base
- insert a stored customer directly into the active Excel file
- Leitweg-ID or bring customer reference and customer-specific payment destination
Templates that have not yet been prepared are also supported: If customer field mappings are missing, TabellenFaktura can create a clearly arranged customer block at the active cell. This makes it easy to get started while retaining the option to set up structured mappings later.
Since version 1.4.0: Billing journal instead of individual file silos
A Excel workbook first only knows its own content. For a reliable number circle, this isolated view is not sufficient as soon as several customer folders or templates are used in parallel. Therefore, the invoice management merges the processes into a local, workbook-independent database.
A new invoice number can be reserved centrally and written to the associated Excel cell. Already used numbers are blocked against unnoticed reuse. The journal records the technical verification status, the local file path and the checksum of the generated PDF or XML file. Essential processes are logged with time, user and computer.
The benefit is not in additional bureaucracy, but in a clear answer to a simple question: Which file is actually part of what final invoice?
Local accounting archive with comprehensible file integrity
After a successful creation, TabellenFaktura can leave an additional unchanged archive version by year and invoice number. A Sha-256 audit sum shows changes later. Technical examination, the final invoice number and the archive path are recorded together in the journal.
This does not make the familiar Excel file the only place where the process exists. The workbook remains the tool for design and calculation; the final created e-invoice additionally receives its own documented space.
Backup directly from Excel
Tester feedback often concerns not only creating, but also the emergency: a new computer, a new installation or loss of local settings. Therefore, TabellenFaktura can be a portable backup file with the ending .tfbackup The
The backup includes the central database and can optionally include the archived invoice files. Before restoring the database and checksums are checked. The existing local data stock is additionally retained as a backup copy. With version 1.5.0 the central customer base belongs to this backup concept.
Central or only in the workbook: Settings remain selectable
Not every operation organizes Excel templates the same. Some settings should apply to all invoices, others are deliberately only part of a specific customer folder. Therefore, TabellenFaktura offers two storage locations:
- Central: Assignments, units, email templates and other settings are available across workbooks and are included in the data backup.
- In the Excel file: Template-specific settings are stored as invisible custom XML data with the workbook and taken with you when copying.
Invoice journal and dublette protection remain central regardless of this selection. Thus, a template can remain flexible without losing the common overview of final invoices.
Updates are checked and installed in a controlled manner
Technical rules for e-invoices are evolving, so a local solution requires a reliable update path. TabellenFaktura checks if a new version is available when starting the license comparison. In addition, a manual search in the Excel menu band is possible.
An installation program is loaded after confirmation and checked before starting using its released SHA-256 check sum. Excel is not forcibly terminated when an update is made. Open workbooks can be saved and Excel completely closed.
What remains consciously the same despite the expansions
More management does not mean a change to a cloud ERP at TabellenFaktura. The basic idea remains unchanged:
- The existing Excel template remains usable.
- ZUGFeRD and XRechnung are created locally and are technically tested.
- Invoice contents are not transferred to TabellenFaktura.
- A Outlook draft can be prepared, but the shipment never happens automatically.
- Journal, customer base, archive information and settings are located locally on the Windows PC.
The new functions do not replace the familiar process. They supplement it where individual Excel files alone do not provide a common overview.
Why the test phase is crucial for further development
A technically valid XML document is only part of a good tool. In everyday life, understandable terms, reasonable default values, findable buttons, clear error messages and as few double entries as possible count. Such details become particularly visible when different templates and real operational processes meet.
The previous suggestions from the tester group have already led to tangible extensions. An express thanks for this. Any comprehensible feedback helps to not overload TabellenFaktura with any additional functions, but to improve the steps that actually cost time for small companies and self-employed people.
The latest versions expand TabellenFaktura in two clear steps: Version 1.4.0 creates the basis for a coherent local billing process with number circle, journal, archive and backup. Version 1.5.0 complements reusable customer management. Both remain closely connected to Excel and follow the same principle: more security and less double recording without having to move billing data into a cloud.
Frequently asked questions
What's new in TabellenFaktura 1.5.0?
Version 1.5.0 adds a central local customer management. Customers can be searched, edited, exported as CSV, checked on dublettes, archived and directly transferred between customer base and Excel invoice.
What functions were added with version 1.4.0?
Version 1.4.0 added a local billing journal, controlled billing numbers, dublette protection, an ordered billing archive, a portable backup and an audited update path.
Are customer or billing data stored in a cloud?
No. Customer base, billing journal, settings and billing content are processed locally on the Windows PC. No billing content is transferred during license and update reconciliation.
Can the existing Excel template be used?
Yes. The extensions complement the existing Excel template. Fields can be assigned once, customers can be taken over and invoices can be generated as ZUGFeRD or XRechnung.
How does tester feedback flow into TabellenFaktura?
Feedback from real processes is evaluated according to benefits, comprehensibility and technical security. Several suggestions for invoice management, data reuse and usability have already been incorporated into versions 1.4.0 and 1.5.0.