How to Import a Bank Statement File for Bank Reconciliation in Dynamics 365 Business Central

 In this article, let's take a look how to import CSV file of your monthly bank statement into Dynamics 365 Business Central for smooth and quick bank reconciliation process.

1. Navigate to Data Exchange Definitions. 


2. Under General Tab on Data Exchange Definition Card.



1. Code = a code for the report purpose ( in my example, BANKSTMTCSV)

2. Name = description of the purpose 

3. File Type = Variable Text

4. Type = Bank Statement Import

5. File Encoding = WINDOWS

4. Column Separator = Comma

5. Reading/Writing XMLport = 1220

6. Ext. Data Handling Codeunit = 1240

3.  In the Line Definitions tab below define the correct value for Column Count that matches the number of columns in your bank statement CSV file that you will be importing.



4.In the Column Definitions tab, match each line you plan to import to a corresponding column in the CSV.




1. Column No. = Which column number in the CSV file this line refers to.

2. Name = Name for the column title in the CSV file.

3. Data Type = [Some examples: Date, Text, Decimal, etc.]

4. Data Format = d/M/yyyy

5. Data Format = For data types of date and decimal, enter “en-AU”

5. Go to the Field Mapping tab where we can map our columns from the import bank statement CSV file to the correct table columns in Dynamics 365 Business Central. In the first line, select the first created column from Data Exchange Definition. Then, in the Field ID column, find the corresponding column in the Bank Acct. Reconciliation Line table in Business Central.





6. Now navigate to Bank Export/Import Setup and click New in the toolbar. 


Enter a Code and Name.
Direction = Import
Processing Codeunit Id= 1270
Data Exchange Definition Code = <The name of your Data Exchange Definition>








7.Go to Bank Accounts and select the card of the Bank Account you would like to use. Under the Transfer tab, enter in your import name in the Bank Statement Import Format field.


Now you are all set to import the bank statement CSV file.

Feel free to comment if there are any question that I can help with.




Comments

Post a Comment

Popular posts from this blog

Mastering Bank Deposits in Dynamics 365 Business Central

Image
In today's business landscape, efficiency and accuracy in financial processes are crucial for successful operations. One critical aspect is bank reconciliation, which can be simplified by ensuring that there is only one bank ledger entry per deposit. In this article, we will demonstrate the proper steps to create a bank deposit in Dynamics 365 Business Central that meets this essential requirement. Step 1: Create a New Bank Deposit To begin, navigate to the "Bank Deposits" page in Dynamics 365 Business Central and create a new bank deposit. This is the foundation of the entire process, as all subsequent actions will be associated with this deposit. Next, you need to add lines for each customer payment within the bank deposit. Since bank deposits may include several customer checks, each check represents a payment for one or more customer invoices. By adding lines for each payment, you establish a clear record of the funds to be deposited. Step 2: Apply Entries Once you ha
Read more

Ace the MB-800 Exam: Tips and Strategies for Success

 The Microsoft Dynamics Business Central MB-800 exam is a certification exam that tests your knowledge and skills in Business Central. Achieving certification in Business Central can help you advance your career and demonstrate your expertise in this software. If you are preparing to take the MB-800 exam, here are some tips and strategies that can help you succeed: Familiarize yourself with the exam format and content:   The MB-800 exam consists of 40-60 multiple-choice and case study questions and covers a range of topics. It is important to understand the exam format and content in order to prepare effectively. Here is the link to download MB-800 Study Guide to review the exam objectives.  Exam MB-800: Microsoft Dynamics 365 Business Central Functional Consultant - Certifications | Microsoft Learn .  Use study materials and resources: There are a variety of study materials and resources available to help you prepare for the MB-800 exam. These can include books, online courses, pract
Read more

Empowering Your Business with Custom Report Layouts in Business Central

Image
  In today's fast-paced business world, having well-designed and professional reports is crucial for success. That's where the Standard Reports in Business Central come into play. But what if you need to make modifications to these reports to align them with your company's unique needs and requirements? T he good news is that you can tailor the layout to meet your specific needs, without relying on technical expertise or the need for extensive programming or coding knowledge. Let's take a quick tour of how to utilize this fantastic feature in Business Central: Step 1: To modify a report layout, the first step involves exporting the existing layout as a file to a location on your computer or network. Step 2: Export the existing report layout to your computer or network, giving you the freedom to explore and modify it at your convenience. Step 3: Open the exported layout in MS word, click on the “XML Mapping Pane” under the Developer tab to open the XML Mapping.  
Read more