Skip to main content

BMD NTCS

The BMD NTCS integration turns your Timesheet data into import files for BMD NTCS, the accounting and payroll software most Austrian tax advisors use. You download two files and hand them to your Kanzlei: a booking import with your outgoing invoices, and a payroll import with worked time, overtime, absences and allowances for each employee. Nothing is sent to BMD directly.

Business plan

The BMD NTCS integration requires an organization on the Business plan. See the Plans page for the full comparison.

Before you start​

  • An organization in Timesheet on the Business plan, or on a Business trial.
  • Admin rights in that organization. Only admins can install the integration, and it cannot be installed on a personal profile.
  • The account numbers, tax codes and wage types from your tax advisor. The integration writes what you enter here, so ask for the list before you start.

Install the integration​

In the web app, open Integrations, select Browse Marketplace, and install BMD NTCS Export for your organization. There is no connection step, because the files are downloaded rather than sent.

The integration has four tabs: BMD Export, Settings, Mappings and Logs.

Enter your BMD settings​

On the Settings tab, fill in the values you received from your tax advisor.

  • Firmennummer: the company number in BMD NTCS. It is written into every payroll line.
  • Buchungssymbol: the symbol for outgoing invoices, usually AR.
  • Erlöskonto 20 %, 10 %, 13 %, steuerfrei, Reverse Charge: the revenue account for each tax rate.
  • Steuercode for each rate: the BMD tax codes. The defaults are common values, but confirm them with your tax advisor.
  • Debitorenkonto Standard: the debtor account used for customers you have not mapped yet.
  • Gutschriften: how credit notes are written. buchcode uses booking code 2 with positive amounts, negativ uses booking code 1 with negative amounts. Ask your tax advisor which one their import expects.
  • Kostenstelle Standard and Filiale: optional, leave empty if you do not use them.
  • Stichwort Taggeld and Stichwort Nächtigungsgeld: a word that identifies these allowances in your expense descriptions, for example Taggeld. Leave empty to skip them.
  • Dateiformat: character set, field separator, decimal mark, date format, header row and quoting. BMD import definitions are set up per installation, so match these to what your BMD consultant configured. The defaults are Windows-1252, semicolon, comma and TT.MM.JJJJ.
  • Monatlicher Lauf: choose which files the automatic monthly run produces.

Select Save to apply.

Map your data​

On the Mappings tab, tell the integration which BMD numbers belong to your Timesheet data. All values are typed in, because BMD has no interface to read them from.

  • Dienstverhältnisnummern: the employment number of each team member in BMD Lohn. If you leave a member out, the integration uses the employee ID from their Timesheet profile.
  • Lohnarten für Abwesenheiten: the BMD wage type for each absence type, for example vacation or sick leave.
  • Lohnarten für Zeiten und Zuschläge: the BMD wage type for worked hours, overtime at 50 % and 100 %, night, Sunday and holiday work, Taggeld and Nächtigungsgeld.
  • Debitorenkonten: the debtor account for each customer. The list is built from your invoices, so a customer appears here once you have invoiced them.

You do not have to map everything before the first export. Anything without a mapping is skipped or falls back to the default debtor account, and the export lists it as a warning. Add the missing number and run the export again.

Run an export​

On the BMD Export tab, enter the first and last day of the period and select FIBU-Import erzeugen for the invoices or Lohnimport erzeugen for payroll. The period defaults to the previous month.

Each run shows:

  • Download links for the files. The links are valid for a short time, so download the files right away.
  • Count: the number of invoices or payroll lines in the file.
  • Warnings: customers, employees or wage types the export could not map. The file was still produced without them.

The table Bisherige Exporte lists your last twelve runs with period, count and number of warnings.

What is in the files​

FIBU import. One line per invoice and tax rate with debtor account, revenue account, invoice number, date, tax code, gross and tax amount, booking text, due date and cost centre. Credit notes are recognized automatically. An invoice with two tax rates becomes two lines.

Payroll import. One line per employee for worked hours, one per overtime or surcharge type, one per absence with its own dates, and one per allowance. Hours are given with two decimals; absences in days.

An invoice dated outside the period stops the export instead of producing a file. This is the most common reason a BMD import is rejected, so the integration refuses it up front. Check the invoice date or widen the period.

The monthly run​

On the first day of each month at 06:00, the integration produces the files for the previous month automatically and records the run in Bisherige Exporte. Open the tab and download the files. You can switch each file on or off in the settings, and turn the schedule off entirely on the Triggers tab.

Import into BMD NTCS​

Hand the files to your tax advisor, or import them yourself in BMD NTCS with the import definition your BMD consultant set up. The column order, the tax codes and the credit note convention in the files follow the BMD standard import structure. Confirm the layout with your BMD consultant before the first real import, and adjust the file format settings if their definition differs.

Remove the integration​

Use the Actions menu in the header, or the Uninstall Integration option on the integration page. This removes the integration and its mappings in Timesheet. Files you already downloaded are not affected.

Troubleshooting​

The install button is missing or greyed out. The integration needs an organization on the Business plan and admin rights. It cannot be installed on a personal profile.

A customer appears with the default debtor account. Map the customer on the Mappings tab under Debitorenkonten and run the export again.

An employee is missing from the payroll file. Add their employment number under Dienstverhältnisnummern, or enter an employee ID in their profile.

An absence type is missing. Add its BMD wage type under Lohnarten für Abwesenheiten.

The export stops with a date error. An invoice in the result set is dated outside the period. Correct the invoice date or change the period.

Umlauts look wrong after the import. Change the character set in the file format settings to what your BMD import definition expects.

For anything else, contact support@timesheet.io with your Timesheet account email and organization name.

See also​

  • Integrations: install integrations and manage API keys and webhooks.
  • DATEV: the same export for DATEV in Germany.
  • Plans: compare what each plan includes.
Last updated on