Settlements
The merchant will receive a settlement in accordance with the agreement
Frequency
Available settlement frequency options are:
- Daily (business days)
- Weekly
- Monthly
How it works in practice
Activation
An invoice can be either fully activated or part activated, depending on if you can deliver the complete order or not. The amount settled will be the same as the total amount of the order rows that's been activated.
All activations will be specified in the settlement files.
Returns
An invoice can be fully or partially returned. The returned amount will be deducted from the next settlement amount (Activations minus Returns).
All returns will be specified in the settlement files.
Fees
Depending on the agreement, any potential fees either will be deducted from the amount payed to the specified account number, or separately invoiced on a monthly basis. However, the CSV settlement file will always contain the full order amount. The reason for this is to make sure the settlement sum correspond to the amount in your ERP system. If the fees are shown in the CSV file or not depends on which file type specification is agreed and used (see "File type specification" below).
File naming
The CSV file name has the following format:
#Companyname_#CountryCode_#FromDate-#ToDate_settlement_#SettlementId.csv
Every "#" is a dynamic value. Example of a complete file name:
TestPartner 3.0_SE_170814-170815_settlement_48094
This settlement contains data for the merchant "TestPartner 3.0" in Sweden, from the 14th and 15th of August 2017.
File retrieval
There are two ways of getting the settlement files:
The settlements can be downloaded from our Partner Portal (https://commerce.collector.se/portal). Logged in, go to Admin in the top menu, then select "Show settlements". If you have not received your Partner Portal login credentials, please contact merchant@collectorbank.se. The settlements can be uploaded using FTPS/SFTP. You can retrieve the files from Collector using FTPS, or have the files uploaded using FTPS/SFTP set up by you. Contact merchant@collectorbank.se with a request to have this set up.
File type specification
Each settlement consists of two file types; one PDF and one (or more) CSV files. The PDF file aggregates all transactions and fees (if any), giving you an overview of the transactions for the settlement period (a specification of transaction types with an aggregated count to present end balance/payment) The CSV file contains information of each transaction. Collector offer two ways of generating the CSV. See below for examples on the two different ways.
CSV Regular
The regular CSV file is the standard option settlement type. If used, the regular settlement CSV lists transactions (Purchases, Returns, Adjustments etc), but no Collector fees or commission.
File type example:
Example of CSV-file with all transaction for the periodCSV Extended
The extended CSV file is another option that can be used instead of the standard CSV type. If used, The extended settlement CSV lists transactions (Purchases, Returns, Adjustments etc) and all Collector fees (if agreement containts fees deducted on settlement).
All fees are listed directly under each transaction.
File type example:
Example of extended CSV-file with all transaction for the periodPDF File
Each settlement generate a PDF file that aggregates all transactions and fees (if any), giving you an overview of the transactions for the settlement period.
Example of PDF settlement fileAdd-ons
Be sure to check out our Add-ons page for more information on how you can automate the settlement flow