Using DOKKA With Excel / CSV Mode



Working with Excel / CSV Connection




If you are using DOKKA without a direct integration to an ERP system (such as Hashavshevet, Priority, SAP, etc.), you can still work with DOKKA by selecting the Excel / CSV connection mode.


This connection type allows you to configure company settings, preferences, and import data, similar to any other supported integration.

This article walks you through how to configure and work with this connection type.


Choosing the Connection Type: Export to Excel/CSV Only




To enable the Excel/CSV connection:


  1. Open the company you wish to configure in DOKKA

  2. Go to Settings

  3. Select System Connections

  4. From the list of options, choose Export to Excel/CSV only

  5. Click Activate





Company General Settings – Required Setup




Before importing data or starting to process documents, it is important to set up several basic company details.
These settings ensure accurate supplier identification and correct handling of currencies.

To configure:


  1. Go to Company Settings

  2. Select General -> Main Info








Company Registration Number & VAT File




To prevent DOKKA from confusing the company’s registration number with supplier registration numbers, when possible, make sure to enter:

  • The company’s registration / tax ID

  • VAT file number



Primary Currency


In the same screen, set the company’s main working currency.





Email Address for Document Upload




You can also define a dedicated email address for sending documents directly into DOKKA.
Any document sent to this address will be uploaded automatically.



Important: To save changes on this screen, you must also fill in:

  • Full company address

  • City



Without these fields, the Save button will remain disabled.





Importing Company Data – Vendors, Customers, Payment Terms & More




Through the settings page, you can import key lists into DOKKA using an Excel file:

  • Vendors / accounts

  • Payment terms

  • Categories

  • Account codes

  • And additional custom fields


Preparing the Import File




You must download the mandatory import template provided at the bottom of this article.

This is the only approved template for importing data into DOKKA, and it must be used exactly as provided.



Important: do not delete, rename, reorder, or move any columns.
DOKKA reads the CSV file based on the exact structure of the template.
Any change will lead to an import error.


Template Structure


Column A – Required

Contains the type of value from predefined list options, such as:

  • Account – mandatory

  • Vendor

  • Payment Terms

  • Category / Category2 / Category3 – depending on your accounting setup (e.g., cost center, department, project, location)

  • Tax Rate – optional (VAT rate / tax code)

Column B – Required

Holds the corresponding value for each item in Column A.

Column C – Optional

Allows adding an internal ID / code for each value.

Column D – Optional

Allows adding payment terms associated with each vendor.


Saving the File as CSV



After entering your data, save the file as CSV UTF-8:

  1. Go to File → Save As

  2. At the bottom dropdown, choose CSV UTF-8 (.csv)

  3. Save the file locally





Importing the Data Into DOKKA


Return to:

Company Settings → System Connections → Excel → Import Company Setup (CSV or Excel format) -> IMPORT






Then:

  • Upload the CSV file

  • If an error appears, follow the instructions in the message and re-upload

  • Once the upload is successful, click Save



Exporting Documents




When exporting documents from DOKKA, you can choose between:

  • Excel

  • CSV



In addition, DOKKA provides several export templates designed specifically for different accounting systems.




Why Export?



Exports are intended for customers whose accounting system:

  • Is not connected to DOKKA via API, and

  • Is not supported as a direct integration



In these cases, exported transactions from DOKKA can be uploaded manually into your accounting system.

This ensures:

  • A consistent data structure

  • Smooth transfer of information

  • Complete and accurate bookkeeping even without an automated integration


Choosing an Export Template (ERP Type)




When using Excel/CSV mode, you can select the export template that matches your accounting system’s required structure.

To select a template:

  1. Go to Company Settings

  2. Select System Connections

  3. Click Excel

  4. Under ERP Type, choose the relevant export format





Available templates:

  • 1C

  • Almog Finance

  • MDA

  • MP

  • MY

  • Sage Pastel

  • Default template



Selecting the correct template ensures the exported data from DOKKA will match the layout expected by your accounting system.