{"id":17391,"date":"2024-04-23T07:12:37","date_gmt":"2024-04-23T07:12:37","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d8%a7%d8%b3%d8%aa%d9%8a%d8%b1%d8%a7%d8%af-%d9%83%d8%b4%d9%81-%d8%a7%d9%84%d8%ad%d8%b3%d8%a7%d8%a8-%d9%8a%d8%af%d9%88%d9%8a%d9%8b%d8%a7-%d9%84%d9%85%d8%b7%d8%a7%d8%a8%d9%82%d8%a9-%d8%a7%d9%84%d8%ad\/"},"modified":"2025-05-05T12:48:06","modified_gmt":"2025-05-05T12:48:06","slug":"manually-importing-bank-statement-to-match-the-bank-account-with-the-system","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/manually-importing-bank-statement-to-match-the-bank-account-with-the-system\/","title":{"rendered":"Manually Importing Bank Statement to Match the Bank Account with the system"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text css=”.vc_custom_1746443768438{margin-left: 200px !important;}”]<\/p>\n

\n

Through this feature on the system, you can reconcile the financial transactions occurring on your bank account with the corresponding expense and income in your account by uploading the Excel file containing your bank account transactions. This helps you manage your financial situation more efficiently and generate a comprehensive statement that clarifies the source, description, and bank reference of the financial transaction.<\/p>\n<\/div>\n

<\/div>\n

[\/vc_column_text][vc_custom_heading text=”Reviewing the Appropriate Excel File for Importing Bank Account Data” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1715591549719{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text css=”.vc_custom_1746443784500{margin-left: 200px !important;}”]Ensure that the Excel file is properly prepared with comprehensive client data intended to be uploaded to the system, such as the client’s name, email address, client code, business name, phone number, and other relevant information.<\/p>\n

\"\"<\/a>[\/vc_column_text][vc_message message_box_style=”3d” message_box_color=”alert-warning” css=”.vc_custom_1715593119374{margin-left: 200px !important;}”]<\/p>\n

The Excel file should be in CSV format, as it is considered the appropriate format for files.<\/p><\/blockquote>\n

[\/vc_message][vc_custom_heading text=”Method for Importing Bank Account Data From an Excel File” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1715593264719{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css=”.vc_custom_1746448806251{margin-left: 200px !important;}”]<\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n

Click on “Treasuries & Bank Accounts<\/strong>” under “Finance<\/strong>” in the main menu, and select the bank account for which you want to import transactions.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\"\"<\/p>\n

\n
\n
\n
\n
\n

Click on “Import Bank Statement<\/strong>“.<\/p>\n

\n
\n
\n

\"\"<\/p>\n

Select the “Comma Separated<\/strong>” option and click on “Choose File<\/strong>” to upload the Excel file from your device.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Note:<\/strong> When you click on the “Download Sample<\/strong>” button, an Excel file containing the format of fields matching the fields of bank accounts in the system will be downloaded, so that the fields of your actual bank account match the fields of the same bank account in the system easily.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
\n
\n
\n
\n
\n

\"\"<\/p>\n<\/div>\n<\/div>\n

\n
\n