Online help

If you have questions, contact us

How to import your data (clients, receivable, ...) with a file (.csv, .txt or .xls) via our « Smart upload » module

Compatible with many software: Sage 100
It is necessary to upload into My DSO Manager your customer and receivable data to use the features of our software.

For this you need to use the import module Smart Upload to facilitate this integration:
video 5minutes

How it works?


It's very simple, you only have to carry out an extraction of your sales management tool (for customer data) and your accounting system (for billing information) to a .csv, .txt or .xls file and then import them with « Smart Upload ».

Do not worry about your import file formats: tab, comma, semicolon, dates and amounts formats are managed smartly by the import module.
Example of a .csv file containing customer data.

Example of import file

Your files must contain column headers. The first line is not composed of data but some text to describe the content of each column.

Go to the Settings / Import / Export your dataLinkthen select your file to import. Then specify what type of file it is:

  • customer data

  • receivable (invoices, credit notes, non allocated payments...)

  • or customer contacts to associate with customers

Then click « Submit »

Import module

Now you need to indicate to My DSO Manager the correspondence between the information in your file and the fields of the application.

Exemple de fichier d'import

This methodology for manual import is applicable to all import files (customers, receivable, contacts). It is also used to set the automatic import by FTPLink.

Once completed and verified your settings, click the « Import » button at the bottom of the page, and your data are integrated.

This setting is to be done only once since it is recorded by My DSO Manager. Even better, the tool helps you to match your data and will propose correspondence between columns of your file and application fields.

See how to import each data type:

← Back : Online help » Various questions

scroll top
Copyright © 2015-2017 - MY DSO MANAGER / P2B Solutions SARL - France