{"id":17700,"date":"2024-08-27T11:13:24","date_gmt":"2024-08-27T11:13:24","guid":{"rendered":"https:\/\/docs.daftra.com\/?post_type=user_manual&p=17700"},"modified":"2025-05-07T11:22:54","modified_gmt":"2025-05-07T11:22:54","slug":"importing-journal-entry-data-from-an-excel-sheet","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-journal-entry-data-from-an-excel-sheet\/","title":{"rendered":"Importing Journal Entry Data from an Excel Sheet"},"content":{"rendered":"

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

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

The accounting system allows you to import multi-party entry data from an Excel file all at once, so you don’t need to enter data for each party separately. Instead, you can take simple steps to transfer all the data directly from the Excel file to the entry screen. In the following lines, we will learn about these steps with an illustrative example.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n

[\/vc_column_text][vc_custom_heading text=”Notes on the Excel Sheet” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1715682239342{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text css=”.vc_custom_1715682822733{margin-left: 200px !important;}”]<\/p>\n

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

Before starting any step, we should have an Excel sheet containing the entry data. To ensure that the accounting system recognizes this data correctly, consider the following:<\/p>\n