TabellenFaktura for Excel · Manual

Journal, Customers and Data Backup

Invoice numbers, final invoices and customer data are managed on the PC together for the various Excel files.

Version 1.6.17 Updated 9 November 2026

What is the journal?

The invoice journal is the local, cross-work overview of the number assignment and final invoices. It is outside the individual Excel files. Therefore, operations remain visible when a different mappe is used per customer or invoice.

e-invoice → Invoicing management → Open journal displays number, date, recipient, amount, format and status. The journal is not an automatic payment control, no email mail output, and no shared cloud database for multiple PCs.

Accounting journal with a reserved sample invoice and its amount
A reserved number is visible in the journal before a final invoice file has been created.
Status / ActionMeaning
Number reservedThe number is assigned for a process, the final file is still missing.
FinalizedThe invoice was completed and their file recorded. This does not mean "send, or "pay.
Replaced by correctionA complete correction replaces the original invoice. The assignment to the correction and the original file remain.
CancelledA reservation has been cancelled in a controlled manner. The entry remains comprehensible; the number is not reused.
UpdateReloads the overview and can follow up design data from the active mappe. Final entries are not rewritten afterwards.
Open FileOpens the corresponding final invoice. If the file is moved, an unchanged copy can be searched.
Check integrityChecks whether the stored invoice file is still in line with the file originally recorded.

The available actions are based on the selected entry. Cancel a reservation only if the planned invoice is not actually completed. For an invoice already created, a suitable technical correction is required.

Set up the number circle and archive

  1. Account management → Settings and the
  2. Select the location of the settings.
  3. Prefix for example: RE-{JJJJ}-. {JJJJ} sets the four-digit year, {JJ} the two-digit.
  4. Number of digits and First serial number Choose the appropriate number system. With four digits and start value 1, for example, RE-2026-0001.
  5. A accessible, permanently secured folder as Accounting archive set and save.
Billing management settings with prefix, digit number, start number and archive folder
The first serial number shall be the same as the numbering system already used.

Reserved and final numbers are centrally protected against dublettes on this PC. A new Excel copy or any other setting for the location does not reset this history. Independent PCs do not have a common number lock; for several workstations, a coordinated number assignment is required.

Reset Test Journal is a deletion function for pure test data. It is not part of the normal billing process and must not be used to make final real invoices disappear.

Manage and paste customers

  1. Customers → Manage customers and the
  2. Collect a new customer with name, address, country, e-mail and if necessary VAT ID number, Leitweg-ID and payment destination.
  3. Save. If you have a duvet note, first search for an existing record.
  4. For an invoice Add Customer open, choose the customer and check the cells taken over.
Customer management with customer list and input fields for address and email
Customer data is maintained centrally and transferred to the active invoice if necessary.

Take it from account can use existing buyer data as a starting point. Export CSV The displayed customer list can be output for further use. No longer used customers can be archived and over Show Archived Customers a later change in the customer base does not change any already generated invoice file.

Secure data completely

  1. Invoice management → Secure data The
  2. The question whether the final PDF/XML files still to be found should be included for a complete backup with Yes answer.
  3. One .tfbackup-Save file to a protected backup location.
  4. Read the final report and pay particular attention to missing invoice files.

A compact backup without invoice files contains the database with journal, number circles, customers and central settings. It does not replace backup of the archive. Also a complete backup can only record findable invoice files.

Save Excel files additionally.

Own templates, workbooks and assignments stored in them belong separately to the backup. Also the Outlook account and the Outlook signatures are not re-set by the TabellenFaktura backup.

Create backups regularly, as well as from updates, restores and a PC change. An additional copy outside of the billing PC protects even in case of a device failure.

Restore a backup

  1. First, back up the current data.
  2. Restore Backup select and select the desired .tfbackup- Open file.
  3. Check the test result and the scope.
  4. Confirm the recovery only for the intended data status. It replaces the current database, it does not merge two journals.
  5. Then check Journal, next invoice number and archived files. Excel Templates and, if necessary, Outlook Re-set up separately.

The previous database is stored as a backup copy. Nevertheless, an old backup of newer invoices cannot contain. On a new PC additionally the Clearing the Licensing.

Open image