Reports and exports
What the assistant can tell you about your books, and where its answers stop: totals, open items,
cash, the VAT summary, the profit and loss, and the exports for your tax adviser. It is for anyone
who wants numbers out of sevDesk, and for anyone deciding how far to trust them. Every report here
is read; only the DATEV export needs write (Permissions).
Important
The reports are computed by this server from your sevDesk records. They are not sevDesk's own reports, not a tax return and not tax advice. Binding answers come from your Steuerberater.
Which report answers what
| Question | Tool | Tier |
|---|---|---|
| Revenue per month, costs per supplier, totals | sevdesk_records_summarize | read |
| Who owes us what, and since when | sevdesk_receivables_aging | read |
| What we owe, and when it is due | sevdesk_payables_aging | read |
| How much money we have, and will have | sevdesk_cash_position | read |
| What changed since a date | sevdesk_changed_since | read |
| What the VAT return will roughly say | sevdesk_vat_summary | read |
| Profit for a month, quarter or year | sevdesk_profit_and_loss | read |
| A CSV file for Excel or the tax adviser | sevdesk_csv_export | read |
| The DATEV booking data for the tax adviser | sevdesk_datev_export | write |
Two prompts combine them: vat_precheck before the
Umsatzsteuer-Voranmeldung, and month_end_close for a month-end
close up to the hand-over to the Steuerberater.
Totals
Summarize revenue per month for 2026.
How much did we spend per supplier in the third quarter?
sevdesk_records_summarize counts and adds up invoices,
credit notes, vouchers or bank transactions: exact net, tax and gross per currency, grouped by
month, quarter, status, contact or account. It reads up to 10,000 rows and says when there were
more. Recurring templates and payment reminders are left out unless you ask for them. For single
records the list tools remain the way, for example
sevdesk_invoices_list.
Open items and cash
Who owes us money, and how much is more than 60 days overdue?
Which supplier invoices are overdue, and whom do we owe the most?
sevdesk_receivables_aging and
sevdesk_payables_aging sort today's open invoices and
expense vouchers into not due, 1–30, 31–60, 61–90 and over 90 days, with the largest customers or
suppliers. sevDesk only knows today's open items, so a reference day in the past is refused; a
later day ages today's items as of that day. Amounts without a usable paid figure are marked
approximate or unknown.
What is our cash position, and what does the next 30 days look like?
sevdesk_cash_position lists the balance of every payment
account as sevDesk computes it from the transactions it knows, which is not necessarily the bank's
figure. With an outlook it adds receivables and payables by due date and a projected balance,
labelled as expected, not booked.
VAT summary
Estimate the VAT return for October 2026.
sevdesk_vat_summary estimates the Umsatzsteuer-Voranmeldung
(UStVA) for a month, quarter or year: the form lines (Kennzahlen, 2026 form) with base and tax, the
expected payment or refund (Kz 83), the Zusammenfassende Meldung per buyer VAT ID, OSS sales per
country, and the amounts it cannot place. It reads the account's tax regime itself; a
Kleinunternehmer account gets no UStVA.
The basis is accrual (Sollversteuerung) unless you ask for cash (Istversteuerung). sevDesk's API does not say which one your account files with, so name it if you file on the cash basis. The server files nothing: the return goes to ELSTER from sevDesk or through your Steuerberater.
Profit and loss
What was our profit in the third quarter?
sevdesk_profit_and_loss builds an overview in the style of
an Einnahmenüberschussrechnung (EÜR): net income by tax rule, net expenses by booking account, the
result, and the VAT flows apart (VAT collected, input VAT paid, VAT paid to or refunded by the
Finanzamt). The basis is cash by default (the day the money moved, from the payments sevDesk links
to documents) or accrual (by document date).
How far you can rely on them
sevdesk_vat_summary and sevdesk_profit_and_loss are estimates for checking. They are computed
from your documents and their positions, and each result says what it left out. What they do, and
what they leave to you:
- Timing (accrual basis). Revenue counts at the end of the supply. That also holds for services to businesses in other EU states (Kz 21 and the Zusammenfassende Meldung), which belong to the period in which they are performed. Intra-EU supplies of goods count by the invoice date, at the latest in the month after the supply. Documents are read by date with a margin of 62 days around the period; one whose tax point falls in the period but whose date lies further away is missed, and the notes say so.
- Advance invoices (Abschlagsrechnungen). Their VAT is due when the payment arrives. On the
accrual basis the VAT summary does not compute that: it counts an advance invoice at its supply
date like any invoice and lists the ones concerned (
coverage.advanceInvoices, with a note), so you can check them by hand. - Cash basis. Only payments reconciled in sevDesk count; a payment that is not booked against its document is missing. In the VAT summary only taxable revenue moves to the payment date; input VAT, § 13b and acquisition tax and tax-free supplies stay on accrual.
- Import VAT (Einfuhrumsatzsteuer). sevDesk books it as the amount of a position on the import VAT account (SKR04 1433, SKR03 1588) under tax rule 9. Such amounts go to Kz 62 and count as input VAT, not as an expense. Import VAT booked on another account is not recognized.
- Not an Anlage EÜR. The profit and loss works net, with the VAT flows shown apart; the official Anlage EÜR works gross, so its totals differ by those flows. Fixed assets are listed apart and not depreciated (no AfA), and private use and other adjustments are not computed.
- Incomplete reads. Both reports read positions document by document, up to 1,500 documents,
which is slow for long periods. When a cap is reached, when a document's positions cannot all be
read, or when a remote server runs out of time, the report says so (
coverage.truncated, with a note) and the VAT summary gives no Kz 83 estimate. Over HTTP a report stops reading documents after about 90 seconds, because a request may take 120 (remote limits). At the default request rate that is a few hundred documents: ask for a month instead of a quarter or a year. - German accounts only. Tax rules and UStVA lines follow German law; Austrian accounts are not supported in 1.0.
Drafts never count, and unbooked bank transactions often mean missing receipts. The
vat_precheck prompt checks both before it runs the summary.
Exports
DATEV
Create the DATEV export for October 2026 for my tax adviser, with the receipt images.
sevdesk_datev_export (write, no confirmation) lets sevDesk
build the DATEV booking data (Buchungsstapel, CSV files in a ZIP) for a month, quarter, year or
date range, and saves the ZIP in SEVDESK_OUTPUT_DIR (on a remote server: a download link). You
can limit it to earnings, expenditure, transactions, cash register or assets, keep only documents
paid in the period, and add the receipt images, which makes the file much larger. It takes up to a
few minutes.
- It needs the DATEV settings in sevDesk (Beraternummer, Mandantennummer, start of the fiscal year) and refuses with guidance when they are missing.
- It may mark the documents as exported in sevDesk. It never enshrines them.
- sevDesk delivers the file from its own storage on Amazon S3 (Privacy).
CSV
Export all vouchers of 2026 as CSV.
sevdesk_csv_export (read) saves sevDesk's CSV export of
invoices, credit notes, vouchers, transactions or contacts exactly as sevDesk sends it (UTF-8 with
BOM, ;-separated, German headers), at most 1,000 rows per file; the result says when more may
exist. It returns the path or link, never the content, and changes nothing in sevDesk. For totals,
sevdesk_records_summarize is the better tool.
Both exports are offered only when the server can deliver files: with SEVDESK_OUTPUT_DIR over
stdio (Configuration), or through download links on a remote server
(Files over HTTP). Every call creates a new file.
Related
- Invoices and Receipts and vouchers: getting the records right that these reports read.
- Glossary: UStVA, Kennzahl, ZM, EÜR and the other terms.