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 Excel. Then save your file in .csv format and then import them easily with our import module Smart Upload.

• 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).
    
    
    
    
    
    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