Hello,
we are posting our daily bank account transactions through General Ledger/General Journal with the respective Bank account being the Offset account. Purely manual. This is sometimes time-consuming.
Is anyone aware of a procedure on how to import bank account transactions? (We could use csv or txt files or MT940 files)
Would be great to hear how those transactions could be processed fairly easily and fast.
Many thanks
Nette78
Hi Nette78,
If you mean bank statement, as it is mentioned you can use standard Electronic Reporting configuration (e.g. MT940) or if needed, create a custom one.
If it applies to bank transactions in general journal, you can either use data management framework or Excel add-in to import them.
MT940 is support of the box in D365.
- Go to Electronic Reporting and import MT940 file format.
- Open Bank reconciliation settings and map to MT940 file format
- Import file
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156