Skip to content

Setting up BMD

If your tax advisor or your accounting team posts in BMD NTCS, set up BMD once per company. For this you need the add-on module BMD as a further system, see Modules. Day-to-day use is described under Handover to the tax advisor.

Open Settings, Further systems and choose Add BMD. The following cards are then on the same page.

Export the lists in BMD and read them in list by list: G/L accounts, tax codes, cost centers, cost objects and person accounts.

  • The first time you read in, you set once per list which column fills which field. The character set does not matter.
  • Known codes are updated, nothing is deleted. If the file marks a block, it applies. Tax codes whose validity has expired are blocked. The lists belong to BMD, creating them by hand is not possible here.
  • When reading in the person accounts, fineelik assigns them to the vendors, by VAT ID, IBAN or name and only on a clear match. The IBAN is read for this, but not stored.
  • Accounts without a vendor you assign at the vendor.
  • If you work without an ERP, the person account from BMD becomes the vendor number in fineelik. A number that already exists stays.

With the local agent you do not have to upload the lists by hand. A batch in BMD exports them as CSV into a master data folder of its own, which you enter in the setup of the agent. The agent checks every 10 minutes, and fineelik reads in the newest file per list like an upload. Read in now fetches them immediately.

On the Master data from the folder card you set the file name and the column mapping per list. The default is sachkonten*.csv, steuercodes*.csv, kostenstellen*.csv, kostentraeger*.csv and personenkonten*.csv. With File is the complete list, values missing in the file are blocked and marked “missing in BMD”, never deleted. If more than half of the previous values are missing, fineelik does not read the file at all.

The mapping says which value of your leading system gives which value in BMD, for example G/L account 5100 to BMD G/L account 5000 or a VAT product posting group to a tax code. If you wish, it applies only to one tax case.

From it, fineelik derives the BMD coding of every line. After a change this runs in the background for all invoices that have not yet been handed over to BMD. Values set by hand and values from posting rules stay.

Without a mapping to the tax code, fineelik uses the default tax code of the BMD account. If the account has none, fineelik uses the code that BMD marks as the default for domestic invoices with tax and for reverse charge from within the country, provided there is exactly one. In all other cases the tax code stays open: for EU acquisition, third country, unknown origin and invoices without tax. Maintain the country of the company for this.

fineelik learns at night from reviewed invoices in which you or a posting rule set the BMD value. Values that fineelik derived itself do not count as evidence. Update suggestions starts this immediately. From two identical lines without a contradiction, a suggestion is created. With AI assistance, AI suggestions assigns G/L accounts that have been used to BMD accounts.

Suggestions only apply once you confirm them, one by one or with Confirm all. A rejected suggestion does not come back with the same target.

Only with Business Central as the leading system. Instead of waiting for reviewed invoices, you read in the journal export of your tax advisor (Learn from booking journal).

For every document, fineelik looks for the posted purchase invoice in Business Central and suggests G/L account, tax code, cost center and cost object from it. The G/L accounts from BMD must have been read in beforehand, and the vendors must have their person account in BMD. Export the journal in BMD through “Export bookings”, without an export model. Suggestions are created, which you confirm like the others. fineelik does not store the file itself.

The Handover to BMD card sets how the batches are created:

Setting Meaning
Ready from From when an invoice is ready: Approved or Reviewed
Invoices from From which invoice date. Empty: from the month BMD was added. Older invoices do not appear on the Handover page
Document number Running number from fineelik or the vendor’s invoice number. With the invoice number, an invoice is blocked if the number is already taken in this system
First document number Only with a running number: It applies until the first one is assigned, after that fineelik counts on
Booking symbols One symbol each for invoices and credit notes
Encoding Windows-1252 is the BMD default
Document image Not in the file, as a file in the batch (only with BMD DMS) or as a link to fineelik
Posting lines One line per invoice line or one per account assignment
New person accounts from Vendors without an account get the next free number, with a file for BMD. Empty: none
Extra columns Columns that the import model expects in addition, for example uidnr
Company number in BMD Only with the local agent: With it the agent reads the person accounts of this company
Subfolder in the import folder Only needed if one agent serves several companies

On a day you set, fineelik can also create the batch for the previous month on its own, with an advance notice and a monthly package for your accounting, see Monthly handover.

If you remove BMD under Settings, Further systems, fineelik deletes the lists that were read in, the mappings and the BMD coding on the invoices. As soon as a batch has gone to BMD, the system can no longer be removed. If your tax advisor changes the program, you add the new system in addition.

If BMD runs at your site, the local agent takes the batches to the import folder and fetches the feedback. Without an agent, you download the files on the Handover page.