Online help

Manual import » How to create your import files with Excel?

You can use our template of CSV files to facilitate the creation of your files and to do your imports.

Download the files and fill them with your data in ExcelExcel. Then save your file in .csv format and then import them easily with our import module Smart UploadLink.

  • Items file :   download the template
    Required columns
    • Company / Customer code
    • Item No: must be unique by calendar year. If this is not the case, another « unique identifier » field should be used.
    • Issue date (recommended format : yyyy/mm/dd or dd/mm/yyyy)
    • Due date (recommended format : yyyy/mm/dd or dd/mm/yyyy)
    • Initial amount inc. Tax
    • Item type: here you can insert directly the item types of My DSO Manager or the one of your accounting tool and set the correspondence with the item types of My DSO Manager on your first import (this second method is simpler because the setting is to be done only once).

      match types of items

      If you do not have item types, the data will be imported with the following rule: debit amount = invoice, credit amount = payment


  • Clients file :   download the template
    Required columns:
    • Company / Customer code
    • Company / Business name


  • Contacts file :   download the template
    Required columns:
    • Company / Customer code
    • Name

The columns that have an asterisk (*) are the required information in order My DSO Manager works.

Uploading items and client files are required to start with My DSO Manager, .

← Back : Online help » Various questions