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

1. What the Abacus export is

The Abacus export is a daily file of your Smeetz sales bookings, ready to import into Abacus financial accounting (FIBU). It follows the Abacus standard interface ASCII Buchungen v2014.00 (program 6251).

The file covers the sales side: tickets, memberships, vouchers, retail and F&B. Purchases, goods receipts, stock and cost of goods are not part of this file.

👉 How the file is built

One file per booking day. Each file contains the bookings of one day.
Consolidated lines. Bookings that share the same accounts, booking text, VAT code, cost centre and cost object are grouped into one line. You do not get one line per transaction.
Refunds and cancellations appear as their own lines with the accounts swapped. They are never netted against the day's sales.
Amounts are gross (VAT included). Abacus calculates the VAT itself from the VAT code on each line.

2. Where to find the report

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

📌 How to access: Analytics > Dashboards > Accounting > Abacus export

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

Abacus booking file: the table you download and import into Abacus.
Checks: lists lines that need your attention before import, for example a sales line without a cost centre or without a VAT code.

3. How to download the file

Open the Abacus export dashboard.
In the Booking day filter, select the day you want to export.
Check the Checks tile. If lines are flagged, fix the setup on the related items first (see section 5).
Open the menu (⋯) of the Abacus booking file table.
Click Download.
Choose CSV.
Turn Apply data formatting off. This keeps the values exactly as Abacus expects them (dates, decimal points, codes).
Click Download to save the file.

⚠️ Always turn Apply data formatting off. With formatting on, amounts and dates can change format and the import will fail.

4. How to import the file into Abacus

In Abacus, open the import for ASCII Buchungen (program 6251).
For your first imports, import into an inactive journal so you can check the result before posting.
If you import the CSV, use the Single transaction mode. The first line of the file is a header row, and Single mode skips it.
Review the imported bookings, then post the journal.

✅ Import each booking day once. Abacus does not block duplicate imports, and bookings cannot be reversed from outside Abacus. Before importing, check that the file's first RecordNumber follows the last one already in Abacus. If the numbers already exist, that day has been imported.

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. It overrides the default sales account.
Analytic code on items: every item sold on an income or expense account needs either a 5-digit cost centre or a 9-digit exhibition code (cost object). Without one, the line is flagged in the Checks tile.
VAT code on taxes: each tax used on your items needs the numeric Abacus VAT code stored on it (for example 313 for the standard rate 8.1% incl.). A tax without a numeric code leaves the VAT field empty and the line is flagged.
Accounting settings: payment method accounts (cash, card, vouchers, receivables) come from your group's accounting settings.

📌 How to access: Settings > Accounting

6. What each field contains

Each line of the file has 65 fields, in the order Abacus expects. Fields not listed below are always empty or 0.

Field	What it contains
1 RecordNumber	Sequential record number, unique across all Abacus exports. Numbering starts at 1 with the first entry of the very first export file and continues incrementally across every subsequent file
2 Version	Abacus interface version letter. Always J.
3 Date	Booking date (sale date), written DD.MM.YYYY (for example 22.09.2026).
4 Account	Debit account of the line, from the Smeetz chart of accounts.
5 Account2	Credit account of the line, same rule as field 4.
6 Text1	Free-text description of the entry, up to 80 characters. For product-related lines, it contains the product name, and the payment and voucher lines linked to that product carry the same name. For lines not tied to a product, it describes the type of entry, for example "Payment fee" or "Cash correction loss Kassa 1". Commas, semicolons, quotes and line breaks are replaced by spaces.
7 KeyAmount	Amount of the line in CHF, two decimals. Sales lines are gross (VAT included).
8 Text2	Empty.
9 DebitCredit	Always S: the amount is booked from the account in field 4 to the account in field 5.
10 BookingLevel1	Cost centre, when the account in field 4 is an income or expense account: the item's analytic code when it has 5 digits, or the first 3 and last 2 digits of a 9-digit exhibition code (321011100 gives 32100). Empty on balance-sheet accounts
11 ContraBookingLevel1	Cost centre assigned to field 5 (with same rule as field 10)
12 DocumentNumber	Date the file was generated, YYMMDD.
13 ExchangeRate	0. All amounts are in CHF.
18 Specification2	Always F (financial accounting).
20 ValueDate	Same date as field 3.
23 ClientNumber	Your Abacus client number (Mandant).
24 ISO	Currency of the account in field 4: CHF.
25 ISO2	Currency of the account in field 5: CHF.
28 BookingLevel2	Cost object (exhibition code), when the account in field 4 is an income or expense account and the item's analytic code has 9 digits. Otherwise empty.
29 ContraBookingLevel2	Cost object for the account in field 5 (with the same rule of field 28)
36 TaxCode	Abacus VAT code on sales lines, taken from the tax set on the item (tax code set as tax ID under taxes in Smeetz) (for example 313, 318, 312, 400). Empty on lines without VAT.
37–38 TaxRate, TaxIncluded	Empty. Abacus derives them from the VAT code.
39 TaxMethod	Always 1
40 TaxCountry	CH when the line has a VAT code, otherwise empty.
41 TaxCoefficient	100 when the line has a VAT code, otherwise 0.
42–50 VAT accounts and amounts	Empty. Abacus calculates the VAT accounts and amounts from the VAT code and the gross amount.
55 AmountType	0: actual amounts (not budget).
58–59 EuroCoefficient1, 2	1.
63–64 BookingLevel3	Empty (projects are not used).
65 EndMarker	Always E: closes the line.