Dynamics 365 Business Central | General Journal Copy/Paste from Excel

By: Jennifer Ryan

In Dynamics 365 Business Central you have the ability to copy and paste from Microsoft Excel to the General Journal. The information below will highlight the quick and convenient way to complete this task.

Important to Note:

  • Create an Excel worksheet with the same columns as configured on the General Journal. The General Journal can be personalized.
  • Dimension Codes should be placed after the last Account No./Bal. Account No. fields. If an Account No. or Bal. Account No. field is populated after the dimension codes, the dimension codes will be blank.

  1. In Excel, select the data to be copied to Business Central and right click to copy ( or use CTRL + C).
  2. Select the leftmost cell on an empty line on the Business Central General Journal and right click to Paste (or use CTRL + V).
  • Some or all rows can be deleted and re-imported.
  • The following transaction is the same as above except that the offsetting account 10200 is entered to Bal. Account No. where Bal. Account No., above, is blank

For more information on the Business Central General Journal please reach out to us at Support@BondConsultingServices.com or click here to schedule a free consultation with one of our Business Central experts.