Adyen statement import

This module lets you import an Adyen settlement details report (CSV or Excel) directly into Odoo as a bank statement, instead of entering the transactions by hand.

On the bank journal form you get a new field, Adyen merchant account, where you type the exact merchant account string used in the Adyen file. When you import a statement, Odoo reads the file, finds the merchant account in the file and selects the journal whose Adyen merchant account matches it. If no journal matches, or if the journal you selected does not match the file, the import stops with an error message.

Each transaction line in the file becomes a statement line with its date, amount, reference and a note containing the merchant account, PSP reference, merchant reference and payment method variant. The statement is named after the merchant account, the year and the batch number.

All fee columns (commission, markup, scheme fees and interchange) are added together and posted as a single extra line named "Commission, markup etc. batch ...". The module also checks that the total of the transactions equals the merchant payout; if not, the import is refused. The Adyen format is added to the list of available bank statement import formats.