Skip to Content

Journal entries in SAP Business one with Excel

This is an Excel file for accounting entries directly via Excel without losing much time.

To download the file: Download

Before starting make sure that the reference (the DLLs) it up correctly.

1 – Open the file

2 – click ALT + F11

3 – Add the appropriate reference, depending on your version of SAP Business One

4 – click save and close this window.

5 – Change the connection settings in SAP Business One in the excel sheet.

6 – Save the file.

7 – The Excel workbook is composed of two sheets: one for the header of the accounting entry, and one for the lines of writing.

8 – the header is composed of the following columns:

  ID: An incremental counter for headers of the accounts, it starts with 1.

series: the numbering series of writing in your SAP Business One.

How to determine the proper value of the series in SAP Business One:

  1.   Open SAP Business One.
  2.   Petite View / Enable System Profiler, or simply with all the key shortened   CTRL+SHIFT+I.
  4.   Open the “journal entry” SAP Business One.
  5.   By placing the cursor on the series of writing in the information bar at the bottom, is recovered in the series.


Cal.Auto.TVA: To inform SAP if we will apply an automatic calculation of VAT,

this cell must contain either tYES or tNO   (note this value is case-sensitive).

Date Comp.: Accounting Date.

Date Ech.: Date due.

Date Doc.: Date document.

Memo: wording

Reference1: ref. 1

Reference2: ref.  2

9 – For lines (sheet EJ) the ID column refers to the ID of the header.

10 – click on Valider to commit transactions.


Note: do not insert rows before the column headers or

reorder the columns.

Do not hesitate to contact me.

You must be Logged on to comment or reply to a post.
    • For Sql Server 2012 you must do some change in code:

      1- Open file in Excel (don't forget to allow using macro)

      2- ALT+F11

      3- Double Click on ThisWorkbook

      4- change this line:<oCompany.DbServerType = dst_MSSQL2008> by <oCompany.DbServerType = dst_MSSQL2012>

      5- Save And Run