From 1 January 2020, the Mollie Dashboard will be upgraded. We will gradually migrate our customers. Before we migrate your account to the upgraded dashboard, we will inform you in advance by email. Only if your dashboard has been upgraded, the information below applies to you.

In this article we list the changes that will apply to the exports. Please read this carefully, so you know exactly how the exports are structured and, if needed, can adjust the default settings for your bookkeeping. These changes are only visible if you are switched to the upgraded Mollie Dashboard, and you were informed by us in advance.

Time-based exports

If you do your accounting with a suspense account, you can use an export within a certain time frame (per day or per month). Previously, these exports were available in your dashboard under Administration > Current balance and now under Administration > Report. To download an export, click Export at the top and then select the file type - MT940 or CODA. After this, select the time period you want to download, this can be the entire month or one day.

Opening balance

In the old exports the opening balance was by default € 0 due to a setting in our system, with this upgrade you will see the opening balance of the chosen period of time. This allows you to connect the different exports to each other. The fourth line in the export will change from / to:

 

Old

New

MT940

:60F:C200101EUR0,00

:60F:C200101EUR83,55

Settlements

Payout specifications no longer include the word UITBETALINGEN (Dutch for settlements), but only the reference number of the settlement. A possible custom reference will still be visible.

 

Old

New

MT940

:61:1803160316D15,60NMSC
:86:/TRTP/SEPA OVERBOEKING/IBAN/NL91ABNA0417164300/BIC/ABNANL2A/NAME/
EXAMPLE BV/REMI/REF 1234567.0000.00 UITBETALINGEN/EREF/1234567.0000.00

:61:1803160316D15,60NMSC
:86:/TRTP/SEPA OVERBOEKING/IBAN/NL91ABNA0417164300/NAME/EXAMPLE BV/EREF/12345678.0000.00 TEST

Deductions

Previously, an export could contain multiple deductions for an invoice, because the deductions were performed per outpayment. These deductions are now combined in one line per month in the export. Only if deductions or corrections from different months are included in the outpayment, you will see a separate line per month. The invoice number of your next invoice that was on the export will be replaced by a reference number.

 

Old

New

MT940

:61:1803270327D3,51NMSC
:86:/TRTP/SEPA OVERBOEKING/IBAN/NL91ABNA0417164300/BIC/ABNANL2A/NAME/
Mollie B.V./REMI/Invoice 2018.123456/EREF/NOTPROVIDED

:61:2003010301D0,90NMSC
:86:/TRTP/SEPA OVERBOEKING/REMI/Withheld transaction fees MOLR2020.000001887/EREF/NOTPROVIDED

Settlement-based exports

If you do your accounting without a suspense account, you can use the settlement-based exports. These exports are in your dashboard under Administration > Payouts. You can download an export by clicking on the reference number and selecting the file format: MT940, CSV, PDF or CODA. 

Previously, one line per payment method was created - which could also be split into 2 lines due to fixed and variable costs - you now see only one line per month for all payment methods combined. This makes the file clearer and consistent. You can find the specification of all costs on your invoice. You will only see different lines in the file if payments from different months or corrections have been included in the settlement.

 

Old

New

MT940

:61:1911111111D39,10NMSC
:86:/TRTP/SEPA OVERBOEKING/IBAN/NL91ABNA0417164300/BIC/ABNANL2A/NAME/
Mollie B.V./REMI/Fees Creditcard (9 payments)/EREF/NOTPROVIDED
:61:1911011101D4,00NMSC
:86:/TRTP/SEPA OVERBOEKING/IBAN/NL91ABNA0417164300/BIC/ABNANL2A/NAME/
Mollie B.V./REMI/Fees Vaste kosten voor creditcard-betalingen (16 payments)/EREF/NOTPROVIDED

:61:1911111111D43,10NMSC
:86:/TRTP/SEPA OVERBOEKING/REMI/Withheld transaction fees/EREF/NOTPROVIDED

CSV

2019-04-01 00:00:00,ideal,EUR,-0.92,,,"Kosten iDEAL (4 payments)","Mollie B.V.",NL91ABNA0417164300,ABNANL2A,EUR,-0.92,2193251.1904.05,
2019-04-01 00:00:00,,EUR,-0.19,,,"BTW over kosten april 2019","Mollie B.V.",NL91ABNA0417164300,ABNANL2A,EUR,-0.19,2193251.1904.05,

2020-09-28 06:07:59,,EUR,-11.96,,,"Ingehouden transactiekosten MOLR2020.0000172165",,,,EUR,-11.96,,