BANK STATEMENT IMPORT – PART 5

05 Monday Oct 2020

Posted by Ludwig Reinhard in Accounts Payable, Accounts Receivable, Bank Management, General Ledger

≈ 9 Comments

Tags

Advanced bank reconciliation, Bank reconciliation, Electronic reporting, General Ledger journal, MT940

For more information on electronic reporting, check out the following sites.

9 thoughts on “BANK STATEMENT IMPORT – PART 5”

Sarah Butler said:

2020-12-15 at 01:07

Thanks Ludwig for another great post as always. I have been trying to understand to import csv bank statement in banking reconciliation module. Would that be possible following same route of creating a model and mapping to read csv file in ER and writing output file as ‘imported bank statement’ in Cash & bank management for advanced bank reconciliation, just like it created a GL journal from Step 1 video. If so, please help in suggesting the right entities or a starting point. If not, please suggest another solution for this.

Thank you for your time and consideration in advance.

Regards
Sarah Butler

LikeLike
- Ludwig Reinhard said:
  
  2020-12-15 at 06:43
  
  Hi Sarah, A couple of months ago, my friend Ievgen did a webinar with me where we demonstrated how to import a CSV bank statement file into the advanced bank reconciliation forms in the bank module. The video should still be available on the axug.com website. Please check out details there. If you cannot find it or don’t have access to it, ping me again. Many thanks, Ludwig
  
  LikeLike
  - Sarah Butler said:
    
    2020-12-15 at 10:43
    
    Hi Ludwig
    
    Thanks for this but I’m unable to find the resource you mentioned. Probably it is there but could be me or my search queries at axug.com, failing. I’d appreciate if can find me the link to that post/webinar.
    
    Regards
    
    Sarah B
    
    LikeLike
  - Ludwig Reinhard said:
    
    2020-12-15 at 11:29
    
    Can you please send me an email to Lreinhard7@live.de? Many thanks
    
    LikeLike
Sarah said:

2020-12-15 at 12:45

Hi Ludwig

Thanks, I have dropped you an email at listed address.
Awaiting your reply.

Regards

Sarah

LikeLike
Miles R said:

2021-11-02 at 01:35

Grateful for sharring this

LikeLike
Annapurna said:

2023-02-13 at 19:15

Hi Ludwig,Thanks for the Blog Nice Explaination.I am Finance Functional Consultant.
Right now we are in January 2023 so many updates in Electronic Reporting by Microsoft. How to know about it exactly
It would be great if you clarify how to import BA12 file bank statement and reconcile post to General Ledger.

Thanks
Annapurna

LikeLike
- Ludwig Reinhard said:
  
  2023-02-13 at 19:18
  
  Hi,
  The latest post that I found is this one on MSFT learn.
  https://learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/import-bai2-er
  There are sample files and a detailed description for the import.
  Have you checked out this article already?
  Regards,
  Ludwig
  
  LikeLike
  - Annapurna said:
    
    2023-02-13 at 22:34
    
    Thanks so much..Have a g8 day ahead
    
    LikeLike