This article explains what the SelectLine export is, where to find it in your back-office, how to download a day of bookings and what each column of the file contains.

1. What the SelectLine export is

The SelectLine export is a daily file of your Smeetz sales bookings, ready to import into SelectLine financial accounting as batch postings (Stapelbuchungen). It is built from your journal entries, so it follows the same double-entry logic.

👉 How the file is built

One file per booking day. You select the day, and the file contains the bookings of that day.
Consolidated lines. Bookings that share the same accounts, booking text and tax code are grouped into one line. You do not get one line per transaction.
Net amounts. The Netto column is the amount without the tax. SelectLine posts the tax part to your VAT account using the tax code on each line.
19 columns, in the order SelectLine expects for batch postings (see section 6).

2. Where to find the report

The export is available as a dashboard in your back-office.

📌 How to access: Analytics > Accounting > SelectLine export

The dashboard opens on yesterday's bookings by default. It contains:

Buchungstag: the filter to select the booking day.
Letzte Aktualisierung: the date and time the data was last refreshed.
Kontrollen für diesen Tag: the checks for the selected day (see below).
SelectLine-Buchungsdatei: the table you download and import into SelectLine.

👉 Focus on the checks

The Kontrollen für diesen Tag tile summarises the selected day so you can check it before import.

Zeilen: number of lines in the file.
Total bezahlt: total amount paid by your customers, VAT included.
Total netto: total of the Netto column, excluding the tax.
Pauschalsteuer: Tax for the day (Total bezahlt minus Total netto).
Ohne Steuerschlüssel: number of lines without a tax code. This should be 0 before you import.
Offene Posten: number of open items, for example unpaid invoices.

3. How to download the file

Open the SelectLine export dashboard.
In the Buchungstag filter, select the day you want to export. Only export a day once all your tills have synchronised.
Check the Kontrollen für diesen Tag tile. If Ohne Steuerschlüssel is not 0, fix the setup on the related taxes first (see section 5).
Open the menu (⋮) of the SelectLine-Buchungsdatei table.
Click Download.
Choose CSV or Excel, depending on the format your SelectLine import is set up for.
Turn Apply data formatting off. This keeps dates, amounts and codes exactly as SelectLine expects them.
Click Download to save the file.

⚠️ Always download from the menu of the SelectLine-Buchungsdatei table, with Apply data formatting off. Downloading the whole dashboard gives you a ZIP file, and with formatting on, dates and amounts can change format and the import will fail.

4. How to import the file into SelectLine

In SelectLine, open the import for batch postings (Stapelbuchungen).
For your first imports, use a test day and import into a batch you can check before posting.
Review the imported bookings: accounts, net amounts, tax codes and cost objects.
Post the batch.

✅ Import each booking day once. If you import the same day twice, the bookings are duplicated in SelectLine.

5. Before you export: check your setup

The file reads its values from your Smeetz configuration. To get a clean file, check the following.

Accounting code on items: each item carries the revenue account it posts to (Soll or Haben column). It overrides the default sales account.
Analytic code on items: each item needs the analytic code that SelectLine uses as cost object (Kostenträger).
Tax ID on taxes: each tax used on your items needs the SelectLine tax code (Steuerschlüssel) stored as its tax ID.

⚠️ If a tax has tax code yet, its lines are exported with the full amount and an empty Steuerschlüssel. They are counted under Ohne Steuerschlüssel. Fix them before you import.

6. What each column contains

Each line of the file has 19 columns, in this order. Columns marked empty are always present in the file but left blank.

Column	What it contains
1 Buchungsdatum	Booking date (sale date), written YYYYMMDD (for example 20261001).
2 Beleg-Nr	The booking reference (for example P664-261001-1).
3 Valutadatum	Value date, written YYYYMMDD. Same as the booking date.
4 Soll	Debit account of the line, from your Smeetz chart of accounts (for example 1007).
5 Haben	Credit account of the line, same rule as column 4 (for example 3501).
6 Text	Booking text: order channel and gateway.
7 Netto	Net amount in CHF, two decimals, without the tax. Each line equals the sum of the journal entries it groups, to the centime.
8 Kostenstelle	Empty.
9 KL-Nummer	Empty.
10 Steuerschlüssel	SelectLine tax code, taken from the tax ID of the tax set on the item (for example 61). Empty on lines without VAT.
11 Skontobetrag	Empty.
12 Währung	Empty.
13 Sammel	Empty.
14 Zahlungsziel	Empty.
15 Skonto	Empty.
16 Skontoprozent	Empty.
17 Kostenträger	Cost object, taken from the analytic code of the item.
18 Text2	Empty.
19 OPBeleg	Empty.