Upload your data in My DSO Manager

Customers data uploading (customer code, company name, recovery contacts ...) and receivable (invoices, credit notes ...) are done with our Smart Upload module which facilitates importing and updating your data every day or several times per day if needed.
The interface involves four types of information (two mandatory and two optionnal):
- Customers data. The file must contain at least the account and the business name but ideally contains other information such as address, legal identifier, the payment term ... etc. Many fields are available (credit limit, insurer guarantee, sales manager, contacts, etc and custom fields that are set according to your need and your data.
- The accounts receivable data. They include all open items: invoices, credit notes, unallocated payments, miscellaneous operations and items in transit (it is possible to load also closed items for revenue history and all KPI as DSO calculation).
The file must contain at least the following information: Type of item (it is possible to set the correlation between your types of items and those of My DSO Manager), item number, account number, date of issue, due date, amount, currency. Many standard fields are available and some others can b customized according to your need. - customer contacts (optional) who are your contacts for collection (accountants, purchasers, business managers ...).
The file contains at least the name and the account number but ideally includes other information such as email address, landline and mobile phone numbers ... - Users file (optional) in order to create automatically users (collectors, credit manager, sales manager, etc) and their portfolio.


- either systematically import all of your open items (not yet paid and cleared in your accounting). Thus, if an invoice is sent to the application one day and is not sent for the next one, the software will consider it as paid and cleared.
- or to realize partial imports and clear items manually (when paid for invoices) in the customer sheet or by inclunding them in the import file with the field "payment date" filled with the date of payment.
- Extracting data from your accounting tool for open items in a .csv or .txt file.
- Selection of the file and the type of data it contains.
- Setting the import. Purpose there is to specify the type of information of each column of your file and link it with the fields of MY DSO MANAGER. For example, you have a column in your file corresponding to the invoices numbers. Simply select the corresponding information: Item number.

FAC : invoices,
AVO : credit notes,
RGL : payments,
OD : miscellaneous operations,
TRT : items in transit,
DPA : payment requests. This is a memorandum item that has no accounting value.

Automatic import is available by API, SFTP and FTPS and with our connectors with tools like Saleforce, Quickbooks...
You can now:
- Go to online demo
- Know more about setup methods of My DSO Manager
Comment this page
Last comments
Comments are displayed in chronological order and have been reviewed by the editor before publication.
S. - 09/03/2023
Hello
I have been following this site for the past many years and found very informative. I am planning to start a consultancy on credit and receivable management. For this, I would like to know whether the software My DSO Manager can be used to upload the sales/colln/and aging report as excel files as it can not be done directly from the ERP of client.
Tools to download
Not yet registered?
Sign up now to enjoy the download and unlimited use of all tools of Credit tools.