Repository navigation
Journal (EN)
anti43 edited this page Nov 19, 2026
·
2 revisions
Deutsch: Journal
The journal (Journal in the toolbar) shows all documents, income, expenses and payments received of a period – for the German cash-basis profit statement (EÜR), the VAT return, as an overview and for handing over to the tax adviser. Every change of a filter reloads the journal (in the background); Reload reloads by hand, Filters hides the filters to give the table more room.
- Period: from – to, or one click on This month, Last month, This quarter, Last quarter, This year, Last year.
-
View sets the filters for the usual tasks:
- Cash basis (EÜR): paid documents only, by payment date – the result of the EÜR.
- All documents: all documents by document date.
- Open items: unpaid invoices and expenses.
- Custom: chosen as soon as a filter is changed by hand. The settings are kept for the user.
- Created by: only documents of one user.
Outgoing documents and expenses are different records, so they have their own filters:
- Income (outgoing documents): invoices, credit notes, deposit and part-payment invoices and income records, with their own status (all, paid, not paid, cancelled) and date (document or payment date). Offers and orders can be added under Not part of the result.
- Expenses (incoming documents): with their own status (all, paid, not paid) and date.
- Groups and accounts apply to both and look the same: a searchable list with multiple selection; nothing selected means all. Include subgroups adds the subgroups of the selected groups.
The journal of a contact (History) has the outgoing documents of the contact only; the second tab shows the contact overview.
- Gray rows do not count towards the result (not paid, cancelled, offers, orders, invoices paid in parts – their payments count). The Profit column is green for income, red for expenses and credit notes.
- Search filters the rows of the table (the totals still cover all loaded rows).
- Double click opens the document; right click: delete, email, SEPA direct debit, PDF/ODT, set Paid.
| Income | Expenses | Result | Open items | Document volume |
|---|---|---|---|---|
| net | net | surplus net | receivables (gross) | net |
| output VAT | input VAT | VAT balance (output − input) | payables (gross) | tax |
| gross | gross | surplus gross | discounts | gross |
- Income and expenses count paid documents only. Credit notes reduce income and output VAT (they are not expenses with input VAT).
- By tax rate: income and expenses per tax rate (net / tax), e.g. for the VAT return. The rate is the one stored with the record: expenses and income records have their rate, invoices the rates of their positions – invoices with several rates are split by their positions, exact to the cent on the stored amounts (discounts included); payments in the proportion of their invoice. The names come from Settings › Tax rates; rates no longer listed there (e.g. 16 % of 2020) keep their own line.
- E-invoice: the number of invoices to businesses above 250 EUR in the period and how many of them go out as e-invoice (format at the contact, tab E-Invoice). Red if some do not; the rules are in the tooltip and below.
Export at the top right:
-
Package for the tax adviser (ZIP): the loaded journal with
-
journal.csv– one line per document (semicolon, decimal comma, UTF-8; opens in Excel), -
journal_steuersaetze.csv– one line per document and tax rate (for the import into bookkeeping software), -
zusammenfassung.txt– period, filters, EÜR totals, amounts by tax rate, open items, the e-invoice check and what is not included (German), -
belege/– the archived receipts of expenses and income (original files, also received e-invoices), -
e-rechnungen/– the XRechnung XML of the outgoing invoices to contacts with e-invoice (made from the current document data; the originals sent are in the archive, e.g. GoBD plugin), -
datev/– when the DATEV export plugin is active, the DATEV posting batch (EXTF_Buchungsstapel_….csv).
-
- DATEV-Buchungsstapel (CSV): when the DATEV export plugin is installed, direct EXTF export with pre-export validation.
- CSV file (Excel, semicolon) and HTML file: the table as shown (sorted, searched, column order).
-
Template (PDF/ODT): the journal template (Templates); new fields
journal.profitgrosvalue,journal.openreceivables,journal.openpayables. - Printer.
- Since 1 Jan 2025 businesses in Germany must be able to receive e-invoices.
- Issuing to other businesses in Germany: from 1 Jan 2027 with a previous-year turnover above 800,000 EUR, from 1 Jan 2028 for all – as XRechnung or ZUGFeRD profile EN 16931 or higher.
- Exempt: small-amount invoices up to 250 EUR gross, tickets, invoices to consumers.
- Cash book and cash receipts need no e-invoice; GoBD, the cash register rules (TSE) and the DSFinV-K export apply (Cash register and TSE).
- E-invoices must be kept in their original format (XML).
![]()
Download installation packages here!
Deutsch
- Dokumentation (DE)
- Beschreibung
- Hinweise und Neuerungen
- Datenbank
- E-Rechnung
- Kleinunternehmer
- Datenschutz (DSGVO)
- Journal
- GoBD
- SEPA-Lastschrift
- Kontaktliste
- QR-Code
- Dateinamen
- Shopify
- Kasse und TSE
- Vorlagen
- Spaltendefinition
- Skripte
Plugins (DE)
- Plugins (Übersicht)
- DATEV-Export
- GoBD-Plugin
- Heilpraktiker-Plugin
- Kfz-Werkstatt-Plugin
- Vereinsverwaltung-Plugin
- ScriptOnSavePlugin
- Plugins schreiben
English
- Documentation (EN)
- Notes and changes
- Database
- Journal
- Small business VAT exemption
- Data protection (GDPR)
- SEPA direct debit
- Contact list
- QR code
- File name defaults
- Shopify
- Cash register and TSE
- Templates
- Scripts
Plugins (EN)