KSeF for Google Sheets (Poland)
GoRoute KSeF is an add-on for Google Sheets that issues a Polish business's invoices to the National e-Invoicing System (KSeF). A row becomes a structured FA(3) invoice: GoRoute checks it against the Ministry of Finance schema, sends it to KSeF with the business's own KSeF token, and writes the KSeF number, the status and the KOD I verification link back to the row. The add-on is in Polish, with English one click away.
GoRoute is software that sends your invoices to KSeF with your own token. The invoice is issued by your business; KSeF gives it its number and its official receipt (UPO).
For an overview, see the KSeF for Google Sheets page on goroute.ai.
Getting started
- Install GoRoute: KSeF Faktury z arkusza from the Google Workspace Marketplace, or ask your Workspace administrator to install it for your whole domain. Then open a spreadsheet and choose Extensions › GoRoute KSeF › Start. You sign in with your Google account; there is no separate password.
- Twoja firma (your business): the legal name, the NIP and the address printed on every invoice. Press Utwórz konto i wstaw arkusze: the add-on creates your GoRoute account and inserts two sheets, Faktury (Invoices) and Pozycje (Lines).
- Token KSeF: in the Ministry of Finance KSeF app, create a token for your NIP with the permissions to issue and view invoices (InvoiceWrite and InvoiceRead), paste it, and press Połącz token. GoRoute checks it with KSeF before keeping it and stores it encrypted. It is never written to the spreadsheet. Only the account owner or an administrator sees this step.
The sidebar always says which KSeF environment you are connected to. An invoice accepted by the KSeF TEST environment has no legal effect.
The sheets
Faktury holds one invoice per row, with its first item on the same row. Further items of the same invoice go in Pozycje, one per row, under the same invoice number.
| Column | What to enter |
|---|---|
| Numer faktury | Your invoice number (required) |
| Data wystawienia | The issue date, 2026-11-17 or 17.11.2026 (required) |
| Data sprzedaży | The date of sale, only when it differs from the issue date |
| Termin płatności | The payment due date |
| Rodzaj | Faktura, or Korekta for a corrective invoice |
| Nabywca | The buyer's name (required) |
| NIP nabywcy / VAT UE | A Polish NIP (with or without dashes; the check digit is verified), an EU VAT number with its country prefix, or another country's tax number |
| Ulica i numer, Kod pocztowy, Miejscowość, Kraj | The buyer's address; the street is required, the country defaults to PL |
| Nr zamówienia | The buyer's order number |
| Nazwa towaru lub usługi, Ilość, J.m., Cena jedn. netto | The item, its quantity, unit and net unit price (required, except the unit) |
| Rabat % | A discount on the item, not on a correction |
| Stawka VAT | 23%, 8%, 5%, 0%, zw, 0% WDT, 0% EXP, np. (art. 100) or np. |
| Podstawa zwolnienia | The legal basis of an exempt sale (zw), for example art. 43 ust. 1 pkt 37 ustawy o VAT |
| Indeks | Your item code |
| Waluta | PLN when empty; another currency is converted at the NBP rate of the last working day before the issue date |
| Uwagi | A note |
| Nr faktury korygowanej, Data faktury korygowanej | On a correction: the invoice it corrects |
The add-on writes only its own columns: Status KSeF, Numer KSeF, Komunikat, Link weryfikacyjny (KOD I), PDF and UPO, plus three hidden columns it uses to recognise each row.
A buyer without a NIP is a consumer: KSeF invoices for consumers are optional, so such a row is refused unless you tick Faktury dla konsumentów in the business details.
Check, issue, follow
- Select the rows and press Sprawdź zaznaczone wiersze (Check). Reading problems and everything KSeF would refuse (a NIP with a wrong check digit, a rate that is not Polish, an exemption without its basis, an intra-Community supply to a buyer without an EU VAT number) appear as notes on the cells concerned, with GoRoute's reason code.
- Press Wystaw zaznaczone w KSeF … (Issue), read the confirmation and press Wystaw. Each row is sent once, even if you press twice.
- A few seconds later, press Odśwież status KSeF (Refresh; it also runs whenever the sidebar opens). The row shows Przyjęta przez KSeF with the KSeF number and the verification link to KSeF's own page for the invoice.
- Select a row and press Zapisz PDF i UPO zaznaczonego wiersza na Dysku: the PDF, with the KOD I QR code and the KSeF number, and KSeF's receipt (UPO) are saved to your Google Drive and linked in the row.
If KSeF has not answered yet, the row says Wysyłana do KSeF; GoRoute keeps sending until KSeF answers. If the KSeF token is refused or removed, the row says Czeka na token KSeF and the invoice goes out once a new token is connected.
Correcting an invoice
An invoice KSeF has accepted cannot be deleted or edited: it is changed by a corrective invoice (KOR).
- Select the accepted invoice's row and press Przygotuj korektę (KOR).
- A new row is added, typed Korekta, numbered after the original (for example
FV/2026/11/001/KOR/1), naming the original's number and date, with its buyer and items copied. The original row is not changed. - Enter the amounts by which the invoice is lowered (for example one returned item at its net price), then check and issue the row as any other.
A correction can be issued once the original has its KSeF number. This version corrects invoices issued through GoRoute and lowers amounts; for an increase, issue an additional invoice.
Issuing again
If KSeF rejects an invoice, the row says Odrzucona przez KSeF with the reason. Correct the row, select it and press Wystaw ponownie: GoRoute first confirms that KSeF did not number it, then the row can be issued again. If nothing on the invoice changed, GoRoute says so and issues nothing.
Limits of this version
- No GTU codes or procedure markings.
- No "mechanizm podzielonej płatności" annotation: for an invoice of 15,000 zł gross or more the check warns you; if it covers goods or services listed in annex 15 of the VAT act, issue it in the Ministry's KSeF app.
- No advance or settlement invoices (ZAL, ROZ), margin schemes, self-billing or domestic reverse charge (oo).
Your data
The add-on reads only the spreadsheet you use it in and, in Google Drive, only the files it saves for you. Invoices are processed on GoRoute's platform on Amazon Web Services in the United States. The KSeF token is sent to GoRoute over an encrypted connection and stored encrypted; it is used only to send your invoices to KSeF. See section 3.7 of the privacy policy and the add-on terms. The add-on is free of charge.
Support
Write to support@goroute.ai, quoting the invoice number and the reason code shown in the Komunikat column.