Verteco

Integrations / Universal formats / Excel (.xlsx)

Excel (.xlsx) logo

E-invoice export to Excel (.xlsx)

Export + import

All documents of your company, received and sent, can be downloaded at any time in the Exports section as one Excel workbook. It has three sheets, Documents, Lines and VAT, because that is exactly how an accountant works with the data: an overview of documents, a check of the invoiced lines and a VAT recap per rate. We read the data from the original XML of every document and the workbook is assembled right in your browser from the same JSON export, so the two never drift apart.

How it works

  1. 1Sign in and open Exports in the left menu. Choose the company, under Documents choose Received and sent, Received only or Sent only and, if you like, enter a period From date and To date; without dates everything is exported.
  2. 2In the Universal formats section click Download on the Excel (.xlsx) card. The portal loads the data and assembles the file peppol-doklady.xlsx right in your browser.
  3. 3Open the workbook in Excel or Google Sheets: the Documents sheet has one row per document, the Lines sheet the individual invoice lines and the VAT sheet the recap per category and rate. The invoice number repeats on all three sheets, so you can join them with a lookup function.
  4. 4Want to send invoices from Excel too? On the Send e-invoice page open the Send by file tab, choose Excel (.xlsx), download the template pre-filled with your company, fill in the customer and the lines and upload the sheet; we compute the amounts.

What the integration solves

  • ✓Three sheets in one workbook: Documents, Lines and VAT, with a frozen header row and an automatic filter
  • ✓Documents sheet: direction, document type, number, issue, delivery and due dates, currency, net base, VAT, total incl. VAT and amount payable, partner with company ID, tax ID, VAT ID, address and Peppol ID, variable symbol, IBAN, buyer reference, status and Peppol message ID
  • ✓Lines sheet: invoice number, line, name, quantity, unit, unit price, net amount, VAT rate and category
  • ✓VAT sheet: recap per category and rate with the base, the tax and the exemption reason, ready for the VAT return
  • ✓The data is read from the original XML of the document, not from the preview, and is identical to the JSON export
  • ✓The partner is always the other party: the supplier on a received and the customer on a sent invoice, so filtering by partner works in one column

Frequently asked questions: e-invoices for Excel (.xlsx)

What exactly do the individual sheets contain?
Documents is the accounting overview with one row per document including amounts, partner, delivery status and Peppol message ID. Lines contains every invoice line with quantity, unit price, net amount and rate. VAT is the recap per category and rate with the base, the tax and any exemption reason. The invoice number is on every sheet so you can join them.
Can I export just one month or only sent invoices?
Yes. On the Exports page you choose the company, the direction of documents and the period From date and To date; the period is judged by the issue date. Without dates everything the company received or sent is exported.
Why do some documents lack lines and the VAT recap?
We read lines and the VAT breakdown from the original XML. If the company has the Data archive switched off, the content of a document is deleted after the set period (14 days by default, 1 to 90 days configurable per direction) and only the register data remains in the export: number, dates, currency, amount and status. With the Data archive on we keep the originals for the whole cooperation and the export is complete.
Can the exported workbook be used to send invoices?
Not directly. The export is an overview of existing documents. For sending there is a separate Excel template on the Send by file tab of the Send e-invoice page: you download it pre-filled with your company, add the customer and the lines and upload it back; we build and send the e-invoice.
Can I download the Excel automatically from my own system?
The workbook is built in the browser, so the API does not provide it. The same data is returned by the export.json endpoint of the portal API, from which the workbook is assembled; you can call it with an API token that you create in the left menu under API tokens, API keys tab, Create token button.
How much does it cost?
The connection is free. The service costs from €2/month excl. VAT per company ID (IČO) that sends or has the Data archive switched on; receiving with the archive off is free (up to 1,000 invoices a month). During the voluntary period before the mandate of 1 January 2027 everything is free of charge.

Start today: selecting us on the Financial Administration portal is enough

Receiving is free · no lock-in, no hidden feesMeet your 2027 legal obligation in 2 minutesSlovak Financial AdministrationChoose Verteco on the Financial Administration portal →On the portal, click “Pokračovať” (Continue), sign in (slovensko.sk / eID or your FS portal credentials) and confirm the selection. We handle the rest automaticallyCertified provider of the Financial Administration (EFSK000031) · no commitment · you can change providers at any time
How does the selection work? (3 steps, ~2 minutes)
  1. 1Click the button above. The official Financial Administration page “Certified provider selection” opens with Verteco pre-selected. Click “Pokračovať” (Continue).
  2. 2Sign in to the Financial Administration portal, via slovensko.sk (eID / ID card with a chip) or with your PFS credentials, and confirm the provider selection.
  3. 3Done. A sign-in e-mail arrives. We create your account, company and Peppol network registration automatically. If another provider already holds your receiving record, we do not take it over: you get the migration-code procedure, or you choose in the portal that receiving stays with them and you only send through us.
  4. No eID? You can also sign in to the Financial Administration portal with your PFS identifier and password. Or register here with an e-mail and password, add your company manually and finish the selection later.
  5. Your company is not offered in the “taxpayer selection” step? Only entities you are authorised for on the FS portal appear. Add the authorisation in your Personal Internet Zone (Autorizácie → Pridať autorizovaného používateľa), then finish the selection.
  6. Detailed guide to the FS portal selection (in Slovak) →

Related: Peppol company check · e-invoicing guide 2027 · price list · all integrations