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.
Adding BMD
Section titled “Adding BMD”Open Settings, Further systems and choose Add BMD. The following cards are then on the same page.
Reading in lists
Section titled “Reading in lists”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.
Lists from the master data folder
Section titled “Lists from the master data folder”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.
Mapping
Section titled “Mapping”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.
Suggestions
Section titled “Suggestions”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.
Learning from the booking journal
Section titled “Learning from the booking journal”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.
Handover to BMD
Section titled “Handover to BMD”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.
Removing BMD
Section titled “Removing BMD”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.
BMD in-house
Section titled “BMD in-house”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.