Skip to content

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 

QuestionToolTier
Revenue per month, costs per supplier, totalssevdesk_records_summarizeread
Who owes us what, and since whensevdesk_receivables_agingread
What we owe, and when it is duesevdesk_payables_agingread
How much money we have, and will havesevdesk_cash_positionread
What changed since a datesevdesk_changed_sinceread
What the VAT return will roughly saysevdesk_vat_summaryread
Profit for a month, quarter or yearsevdesk_profit_and_lossread
A CSV file for Excel or the tax advisersevdesk_csv_exportread
The DATEV booking data for the tax advisersevdesk_datev_exportwrite

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.