BMD CSV Export

CSV export files in BMD format, as produced by Payroll → Export.

Export files: up to three separate CSV files per export (gross payroll, absences, exits)
Delimiter: semicolon (;)
Header line: yes — every file starts with a header line

2050

Payroll → Export: select the files via the toggles. While "Test Export" is active, the files are generated WITHOUT finalizing the payroll — a final export (Test Export off) locks the payroll for further changes.

Download sample files:

1. Gross payroll file (Brutto-Abrechnung)

File name: YYYY_MM_Brutto-Abrechnung_<Company>.csv

PAYROLL_MONTH;CLIENT_ID;EMPLOYEE_ID;EMPLOYEE_SUB_ID;WAGE_TYPE_ID;WAGE_TYPE_QUANTITY;WAGE_TYPE_VALUE;WAGE_TYPE_AMOUNT;EMPLOYEE_COST_CENTER;CLIENT_COST_ACCOUNT;WAGE_TYPE_RECALCULATION_MONTH;
ColumnNameFormatDescription
1PAYROLL_MONTHInteger 1–12Month of the exported payroll (1 = January … 12 = December)
2CLIENT_IDIntegerMatching "Export ID 1" from company settings — must match the BMD client number. Where to configure
3EMPLOYEE_IDIntegerPersonnel number from the employment settings — must match the BMD personnel number. Where to configure
4EMPLOYEE_SUB_IDIntegerEmployment number ("Dienstverhältnis ID") from the employment settings — must match the BMD employment number. Where to configure
5WAGE_TYPE_IDInteger"Export ID 1" from wage type settings — must match the BMD wage type number. Where to configure
6WAGE_TYPE_QUANTITYDecimal (comma)Calculated quantity — only filled if "Anzahl exportieren" is enabled on the wage type. Where to configure
7WAGE_TYPE_VALUEDecimal (comma)Rate, either from the payroll ruleset or from the employment pay rates — only filled if "Wert exportieren" is enabled on the wage type. Where to configure
8WAGE_TYPE_AMOUNTDecimal (comma)Amount, either from the payroll ruleset or from the employment pay rates — only filled if "Betrag exportieren" is enabled on the wage type. Where to configure
9EMPLOYEE_COST_CENTERTextCost center (may be empty)
10CLIENT_COST_ACCOUNTTextCost account (may be empty)

2. Absences file (Fehlzeiten) — BMD "Nichtleistungszeiten importieren"

File name: YYYY_MM_Fehlzeiten_<Company>.csv.

The file matches the BMD import interface "Nichtleistungszeiten importieren" and can be imported directly. Only approved absences of the payroll month are exported; one row is written per absence day (Von = Bis). Dates use the format DD.MM.YYYY.

DV-Firma;Mitarb-Nr;DV-Nr;Art;Gutstd./Div. NLZ;Verarbeitungs-KZ;Von;Bis;Verwaltung;Bezahlt
200000;1;1;1;;2;15.05.2026;15.05.2026;;
200000;2;1;6;1;2;16.05.2026;16.05.2026;7,7;7,7
ColumnNameDescription
1DV-Firma"Export ID 1" from company settings. Where to configure
2Mitarb-NrPersonnel number from the employment settings. Where to configure
3DV-NrEmployment number. Where to configure
4ArtBMD absence type — see mapping table below
5Gutstd./Div. NLZFixed "1" for Art 6, otherwise empty
6Verarbeitungs-KZFixed "2" (create new / modify — overlapping entries are replaced in BMD)
7VonAbsence day, DD.MM.YYYY
8BisSame day as "Von" (one row per day)
9VerwaltungHours of the day (decimal comma) — only for Art 4 and Art 6, otherwise empty (BMD derives day-based types from the week model)

Absence type mapping (column "Art"):

BMD ArtMeaningMcTime absence types
1UrlaubVacation / Urlaub · Company Vacation / Firmenurlaub · Vacation Abroad / Sonderurlaub im Ausland
2KrankheitSickness / Krank
3ArbeitsunfallWork Accident Sickness / Krank wegen Arbeitsunfall
4ArztMedical Leave / Arztweg (hours in Verwaltung/Bezahlt)
5PflegeurlaubCare Leave / Pflegefreistellung
6Gutstd./Diverse NLZ — column 5 = "1", hours in Verwaltung/BezahltAll other absence types: Paid Leave / Zeitausgleich · Flextime / Gleitzeit ZA · Free Time / Frei · Work Rest Period / Ersatzruhe · Special Leave / Sonderurlaub · Statutory Leave / Gesetzliche Freizeit · Study Leave / Bildungsfreistellung · Jubilee Day / Jubiläumstag · Move / Umzug · Public Holiday Abroad / Feiertag im Ausland · Parental Leave / Karenzurlaub · Military Service / Präsenzdienst · Military Exercise / Truppenübung · Unpaid Time Off / Fehlzeit · Unpaid Vacation / Unbezahlter Urlaub · Other Leave / Sonstige Abwesenheit

3. Exits file (Austritte) — BMD "Austritte importieren"

File name: YYYY_MM_Austritte_<Company>.csv.

The file matches the BMD import interface "Austritte importieren". It contains employments whose end date lies within the calendar month of the payroll month (not within the time-report period of the pay period).

DV-Firma;Mitarb-Nr;DV-Nr;Ende Dienstverhältnis;Ende Beschäftigung;Abmeldegrund-Nr.;Abmeldetext
200000;1;1;15.06.2026;15.06.2026;2;
200000;2;1;20.06.2026;20.06.2026;99;Einvernehmliche Lösung wegen Übernahme durch Beschäftiger
ColumnNameDescription
1DV-Firma"Export ID 1" from company settings. Where to configure
2Mitarb-NrPersonnel number. Where to configure
3DV-NrEmployment number. Where to configure
4Ende DienstverhältnisEmployment end date, DD.MM.YYYY
5Ende BeschäftigungSame date as "Ende Dienstverhältnis"
6Abmeldegrund-Nr.Official Austrian deregistration reason code — see below

Abmeldegrund mapping: McTime uses the official Austrian SV deregistration reason codes in the employment settings. Codes supported by the BMD import are passed through unchanged (1–6, 10, 13, 16–22, 24, 25, 27, 30, 34). Code 0 (other reason), code 50 (Übernahme) and employments ended without a reason are exported as 99 with the original reason in the "Abmeldetext" column. Interruption reasons that do not end the employment in BMD (Karenz, Präsenz-/Zivildienst, unpaid leave > 1 month, Bildungskarenz, Truppenübung, Ummeldung, SV-technical reasons) are not exported.

Configuration: Export ID 1 (company)

Organisation → select the company → ⋯ → Bearbeiten → tab Einstellungen → section Schnittstellen. Used as CLIENT_ID / DV-Firma in all three files; must match the BMD client number.

2244

Step 1: Organisation → ⋯ menu of the company → Bearbeiten

1804

Step 2: tab Einstellungen → Schnittstellen → Export ID 1

Configuration: Personnel number and employment number

Anwender → select the user → ⋯ → Bearbeiten → tab BeschäftigungBasis Daten. Used as EMPLOYEE_ID / Mitarb-Nr and EMPLOYEE_SUB_ID / DV-Nr; must match the BMD personnel and employment numbers.

2894

Step 1: Anwender → ⋯ menu of the user → Bearbeiten

1804

Step 2: tab Beschäftigung → Basis Daten → Personalnummer + Dienstverhältnis ID

Configuration: Wage type export settings

Einstellungen → Payroll-Einstellungen → Lohnarten. "Export ID 1" must match the BMD wage type number (4-digit in BMD NTCS). The three toggles control which of the columns 6–8 are exported: Anzahl exportieren → WAGE_TYPE_QUANTITY, Wert exportieren → WAGE_TYPE_VALUE, Betrag exportieren → WAGE_TYPE_AMOUNT.

1804

Wage type: Export ID 1 + export toggles for quantity / rate / amount

Configuration: Rate and amount sources

Values for columns 7–8 come either from the employment pay rates (Anwender → Beschäftigung → Abrechnungssätze) or from the payroll ruleset (Einstellungen → Payroll-Einstellungen → Payroll Regelwerk → Payroll Regeln).

1798

Employment pay rates: Beschäftigung → Abrechnungssätze

1802

Payroll ruleset: fixed value per rule or "Wert aus Beschäftigung nehmen"