SEPA
sepa camt053 <statement>
Description
Read a camt.053 / camt.052 / camt.054 statement (XML or path of a file): message, statements with the account, the balances (OPBD, CLBD...), the entries (signed amount, status, booking and value dates, bank reference, bank transaction code, end to end id, counterparty, remittance, details of the batches) and the totals
Read a camt.053 / camt.052 / camt.054 statement (XML or path of a file): message, statements with the account, the balances (OPBD, CLBD...), the entries (signed amount, status, booking and value dates, bank reference, bank transaction code, end to end id, counterparty, remittance, details of the batches) and the totals
Parameters
statement: The XML or the path of the file - String - required
statement: The XML or the path of the file - String - required
admin
sepa camt053 "<?xml version=\"1.0\" encoding=\"UTF-8\"?><Document xmlns=\"urn:iso:std:iso:20022:tech:xsd:camt.053.001.02\"><BkToCstmrStmt><GrpHdr><MsgId>STMT-20261103</MsgId><CreDtTm>2026-11-03T06:00:00</CreDtTm></GrpHdr><Stmt><Id>2026-11-02-001</Id><ElctrncSeqNb>212</ElctrncSeqNb><Acct><Id><IBAN>FR7630006000011234567890189</IBAN></Id><Ccy>EUR</Ccy><Ownr><Nm>ATELIER PAYET SARL</Nm></Ownr></Acct><FrToDt><FrDtTm>2026-11-02T00:00:00</FrDtTm><ToDtTm>2026-11-02T23:59:59</ToDtTm></FrToDt><Bal><Tp><CdOrPrtry><Cd>OPBD</Cd></CdOrPrtry></Tp><Amt Ccy=\"EUR\">1500.00</Amt><CdtDbtInd>CRDT</CdtDbtInd><Dt><Dt>2026-11-01</Dt></Dt></Bal><Bal><Tp><CdOrPrtry><Cd>CLBD</Cd></CdOrPrtry></Tp><Amt Ccy=\"EUR\">1717.16</Amt><CdtDbtInd>CRDT</CdtDbtInd><Dt><Dt>2026-11-02</Dt></Dt></Bal><Ntry><Amt Ccy=\"EUR\">337.16</Amt><CdtDbtInd>CRDT</CdtDbtInd><Sts>BOOK</Sts><BookgDt><Dt>2026-11-02</Dt></BookgDt><ValDt><Dt>2026-11-02</Dt></ValDt><AcctSvcrRef>REF001</AcctSvcrRef><BkTxCd><Domn><Cd>PMNT</Cd><Fmly><Cd>RCDT</Cd><SubFmlyCd>ESCT</SubFmlyCd></Fmly></Domn></BkTxCd><NtryDtls><TxDtls><Refs><EndToEndId>F2026-0042</EndToEndId></Refs><RltdPties><Dbtr><Nm>CLIENT SAS</Nm></Dbtr><DbtrAcct><Id><IBAN>FR7610107001011234567890129</IBAN></Id></DbtrAcct></RltdPties><RltdAgts><DbtrAgt><FinInstnId><BIC>BREDFRPP</BIC></FinInstnId></DbtrAgt></RltdAgts><RmtInf><Ustrd>FACTURE F2026-0042</Ustrd></RmtInf></TxDtls></NtryDtls></Ntry><Ntry><Amt Ccy=\"EUR\">120.00</Amt><CdtDbtInd>DBIT</CdtDbtInd><Sts>BOOK</Sts><BookgDt><Dt>2026-11-02</Dt></BookgDt><ValDt><Dt>2026-11-02</Dt></ValDt><AcctSvcrRef>REF002</AcctSvcrRef><BkTxCd><Domn><Cd>PMNT</Cd><Fmly><Cd>ICDT</Cd><SubFmlyCd>ESCT</SubFmlyCd></Fmly></Domn></BkTxCd><NtryDtls><Btch><NbOfTxs>2</NbOfTxs></Btch><TxDtls><Refs><EndToEndId>LOYER-11</EndToEndId></Refs><AmtDtls><TxAmt><Amt Ccy=\"EUR\">80.00</Amt></TxAmt></AmtDtls><RltdPties><Cdtr><Nm>SCI DU PORT</Nm></Cdtr><CdtrAcct><Id><IBAN>FR7630004000031234567890143</IBAN></Id></CdtrAcct></RltdPties><RmtInf><Ustrd>LOYER NOVEMBRE</Ustrd></RmtInf></TxDtls><TxDtls><Refs><EndToEndId>EDF-11</EndToEndId></Refs><AmtDtls><TxAmt><Amt Ccy=\"EUR\">40.00</Amt></TxAmt></AmtDtls><RltdPties><Cdtr><Nm>EDF</Nm></Cdtr></RltdPties><RmtInf><Strd><CdtrRefInf><Ref>RF18539007547034</Ref></CdtrRefInf></Strd></RmtInf></TxDtls></NtryDtls></Ntry></Stmt></BkToCstmrStmt></Document>"
mentdb
{"type": "camt.053", "message_id": "STMT-20261103", "created": "2026-11-03T06:00:00", "statements": [{"id": "2026-11-02-001", "sequence": "212", "account": {"iban": "FR7630006000011234567890189", "currency": "EUR", "owner": "ATELIER PAYET SARL"}, "from": "2026-11-02T00:00:00", "to": "2026-11-02T23:59:59", "balances": [{"type": "OPBD", "amount": 1500, "currency": "EUR", "date": "2026-11-01"}, {"type": "CLBD", "amount": 1717.16, "currency": "EUR", "date": "2026-11-02"}], "entries": [{"amount": 337.16, "currency": "EUR", "status": "BOOK", "booking_date": "2026-11-02", "value_date": "2026-11-02", "bank_reference": "REF001", "bank_transaction_code": "PMNT/RCDT/ESCT", "end_to_end_id": "F2026-0042", "counterparty": {"name": "CLIENT SAS", "iban": "FR7610107001011234567890129", "bic": "BREDFRPP"}, "remittance": "FACTURE F2026-0042"}, {"amount": -120, "currency": "EUR", "status": "BOOK", "booking_date": "2026-11-02", "value_date": "2026-11-02", "bank_reference": "REF002", "bank_transaction_code": "PMNT/ICDT/ESCT", "end_to_end_id": "LOYER-11", "counterparty": {"name": "SCI DU PORT", "iban": "FR7630004000031234567890143"}, "remittance": "LOYER NOVEMBRE", "batch_count": 2, "transactions": [{"amount": -80, "end_to_end_id": "LOYER-11", "counterparty": {"name": "SCI DU PORT", "iban": "FR7630004000031234567890143"}, "remittance": "LOYER NOVEMBRE"}, {"amount": -40, "end_to_end_id": "EDF-11", "counterparty": {"name": "EDF"}, "remittance": "RF18539007547034"}]}], "totals": {"credits": 337.16, "debits": 120, "count": 2}}], "warnings": []}
Complete: reconcile the statement with an invoice
admin
json load "tuto_i" (invoice complete "{\"number\": \"F2026-0042\", \"type_code\": \"380\", \"issue_date\": \"2026-11-03\", \"due_date\": \"2026-12-03\", \"currency\": \"EUR\", \"seller\": {\"name\": \"Atelier Payet SARL\", \"siren\": \"732829320\", \"vat_id\": \"FR44732829320\", \"address\": {\"line1\": \"12 rue de Paris\", \"postcode\": \"97400\", \"city\": \"Saint-Denis\", \"country\": \"FR\"}}, \"buyer\": {\"name\": \"Client SAS\", \"siren\": \"552100554\", \"address\": {\"postcode\": \"75008\", \"city\": \"Paris\", \"country\": \"FR\"}}, \"lines\": [{\"name\": \"Consulting\", \"quantity\": 3, \"unit\": \"HUR\", \"unit_price\": 95, \"vat_category\": \"S\", \"vat_rate\": 8.5}, {\"name\": \"Book\", \"quantity\": 2, \"unit_price\": 18.99, \"vat_category\": \"S\", \"vat_rate\": 2.1}], \"payment\": {\"iban\": \"FR7630006000011234567890189\", \"bic\": \"AGRIFRPP\", \"terms\": \"30 days\"}}"); json load "tuto_s" (sepa camt053 "<?xml version=\"1.0\" encoding=\"UTF-8\"?><Document xmlns=\"urn:iso:std:iso:20022:tech:xsd:camt.053.001.02\"><BkToCstmrStmt><GrpHdr><MsgId>STMT-20261103</MsgId><CreDtTm>2026-11-03T06:00:00</CreDtTm></GrpHdr><Stmt><Id>2026-11-02-001</Id><ElctrncSeqNb>212</ElctrncSeqNb><Acct><Id><IBAN>FR7630006000011234567890189</IBAN></Id><Ccy>EUR</Ccy><Ownr><Nm>ATELIER PAYET SARL</Nm></Ownr></Acct><FrToDt><FrDtTm>2026-11-02T00:00:00</FrDtTm><ToDtTm>2026-11-02T23:59:59</ToDtTm></FrToDt><Bal><Tp><CdOrPrtry><Cd>OPBD</Cd></CdOrPrtry></Tp><Amt Ccy=\"EUR\">1500.00</Amt><CdtDbtInd>CRDT</CdtDbtInd><Dt><Dt>2026-11-01</Dt></Dt></Bal><Bal><Tp><CdOrPrtry><Cd>CLBD</Cd></CdOrPrtry></Tp><Amt Ccy=\"EUR\">1717.16</Amt><CdtDbtInd>CRDT</CdtDbtInd><Dt><Dt>2026-11-02</Dt></Dt></Bal><Ntry><Amt Ccy=\"EUR\">337.16</Amt><CdtDbtInd>CRDT</CdtDbtInd><Sts>BOOK</Sts><BookgDt><Dt>2026-11-02</Dt></BookgDt><ValDt><Dt>2026-11-02</Dt></ValDt><AcctSvcrRef>REF001</AcctSvcrRef><BkTxCd><Domn><Cd>PMNT</Cd><Fmly><Cd>RCDT</Cd><SubFmlyCd>ESCT</SubFmlyCd></Fmly></Domn></BkTxCd><NtryDtls><TxDtls><Refs><EndToEndId>F2026-0042</EndToEndId></Refs><RltdPties><Dbtr><Nm>CLIENT SAS</Nm></Dbtr><DbtrAcct><Id><IBAN>FR7610107001011234567890129</IBAN></Id></DbtrAcct></RltdPties><RltdAgts><DbtrAgt><FinInstnId><BIC>BREDFRPP</BIC></FinInstnId></DbtrAgt></RltdAgts><RmtInf><Ustrd>FACTURE F2026-0042</Ustrd></RmtInf></TxDtls></NtryDtls></Ntry><Ntry><Amt Ccy=\"EUR\">120.00</Amt><CdtDbtInd>DBIT</CdtDbtInd><Sts>BOOK</Sts><BookgDt><Dt>2026-11-02</Dt></BookgDt><ValDt><Dt>2026-11-02</Dt></ValDt><AcctSvcrRef>REF002</AcctSvcrRef><BkTxCd><Domn><Cd>PMNT</Cd><Fmly><Cd>ICDT</Cd><SubFmlyCd>ESCT</SubFmlyCd></Fmly></Domn></BkTxCd><NtryDtls><Btch><NbOfTxs>2</NbOfTxs></Btch><TxDtls><Refs><EndToEndId>LOYER-11</EndToEndId></Refs><AmtDtls><TxAmt><Amt Ccy=\"EUR\">80.00</Amt></TxAmt></AmtDtls><RltdPties><Cdtr><Nm>SCI DU PORT</Nm></Cdtr><CdtrAcct><Id><IBAN>FR7630004000031234567890143</IBAN></Id></CdtrAcct></RltdPties><RmtInf><Ustrd>LOYER NOVEMBRE</Ustrd></RmtInf></TxDtls><TxDtls><Refs><EndToEndId>EDF-11</EndToEndId></Refs><AmtDtls><TxAmt><Amt Ccy=\"EUR\">40.00</Amt></TxAmt></AmtDtls><RltdPties><Cdtr><Nm>EDF</Nm></Cdtr></RltdPties><RmtInf><Strd><CdtrRefInf><Ref>RF18539007547034</Ref></CdtrRefInf></Strd></RmtInf></TxDtls></NtryDtls></Ntry></Stmt></BkToCstmrStmt></Document>"); -> "[due]" (json select "tuto_i" "/totals/due"); -> "[paid]" (json select "tuto_s" "/statements/[0]/entries/[0]/amount"); -> "[res]" (concat "invoice " (json select "tuto_i" "/number") " due " [due] ", received " [paid] " from " (json select "tuto_s" "/statements/[0]/entries/[0]/counterparty/name") " (ref " (json select "tuto_s" "/statements/[0]/entries/[0]/end_to_end_id") "), paid: " (equal [due] [paid])); json unload "tuto_i"; json unload "tuto_s"; [res]
mentdb
invoice F2026-0042 due 348.01, received 337.16 from CLIENT SAS (ref F2026-0042), paid: 0
sepa pain001 <json_payment>
Description
Write a SEPA credit transfer file pain.001.001.03: message_id, created, debtor {name, iban, bic}, execution_date, batch_booking, payments [{end_to_end_id, amount, creditor {name, iban, bic}, remittance}]. IBAN and BIC checked, amounts > 0 with 2 decimals at most, number of transactions and control sum computed, texts converted to the SEPA character set (accents removed) and cut (name 70, remittance 140)
Write a SEPA credit transfer file pain.001.001.03: message_id, created, debtor {name, iban, bic}, execution_date, batch_booking, payments [{end_to_end_id, amount, creditor {name, iban, bic}, remittance}]. IBAN and BIC checked, amounts > 0 with 2 decimals at most, number of transactions and control sum computed, texts converted to the SEPA character set (accents removed) and cut (name 70, remittance 140)
Parameters
json_payment: The payment order - String - required
json_payment: The payment order - String - required
admin
sepa pain001 "{\"message_id\": \"VIR-2026-11-03\", \"created\": \"2026-11-03T09:30:00\", \"execution_date\": \"2026-11-05\", \"debtor\": {\"name\": \"Atelier Payet SARL\", \"iban\": \"FR7630006000011234567890189\", \"bic\": \"AGRIFRPP\"}, \"payments\": [{\"end_to_end_id\": \"FOUR-881\", \"amount\": 1250.5, \"creditor\": {\"name\": \"Soci\u00e9t\u00e9 \u00c9quipement & Fils\", \"iban\": \"FR7630004000031234567890143\", \"bic\": \"BNPAFRPP\"}, \"remittance\": \"Invoice 881\"}, {\"end_to_end_id\": \"RENT-11\", \"amount\": 80, \"creditor\": {\"name\": \"SCI du Port\", \"iban\": \"FR7610107001011234567890129\"}, \"remittance\": \"Rent November\"}]}"
mentdb
<?xml version="1.0" encoding="UTF-8"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <CstmrCdtTrfInitn> <GrpHdr> <MsgId>VIR-2026-11-03</MsgId> <CreDtTm>2026-11-03T09:30:00</CreDtTm> <NbOfTxs>2</NbOfTxs> <CtrlSum>1330.50</CtrlSum> <InitgPty> <Nm>Atelier Payet SARL</Nm> </InitgPty> </GrpHdr> <PmtInf> <PmtInfId>VIR-2026-11-03-1</PmtInfId> <PmtMtd>TRF</PmtMtd> <NbOfTxs>2</NbOfTxs> <CtrlSum>1330.50</CtrlSum> <PmtTpInf> <SvcLvl> <Cd>SEPA</Cd> </SvcLvl> </PmtTpInf> <ReqdExctnDt>2026-11-05</ReqdExctnDt> <Dbtr> <Nm>Atelier Payet SARL</Nm> </Dbtr> <DbtrAcct> <Id> <IBAN>FR7630006000011234567890189</IBAN> </Id> </DbtrAcct> <DbtrAgt> <FinInstnId> <BIC>AGRIFRPP</BIC> </FinInstnId> </DbtrAgt> <ChrgBr>SLEV</ChrgBr> <CdtTrfTxInf> <PmtId> <EndToEndId>FOUR-881</EndToEndId> </PmtId> <Amt> <InstdAmt Ccy="EUR">1250.50</InstdAmt> </Amt> <CdtrAgt> <FinInstnId> <BIC>BNPAFRPP</BIC> </FinInstnId> </CdtrAgt> <Cdtr> <Nm>Societe Equipement Fils</Nm> </Cdtr> <CdtrAcct> <Id> <IBAN>FR7630004000031234567890143</IBAN> </Id> </CdtrAcct> <RmtInf> <Ustrd>Invoice 881</Ustrd> </RmtInf> </CdtTrfTxInf> <CdtTrfTxInf> <PmtId> <EndToEndId>RENT-11</EndToEndId> </PmtId> <Amt> <InstdAmt Ccy="EUR">80.00</InstdAmt> </Amt> <Cdtr> <Nm>SCI du Port</Nm> </Cdtr> <CdtrAcct> <Id> <IBAN>FR7610107001011234567890129</IBAN> </Id> </CdtrAcct> <RmtInf> <Ustrd>Rent November</Ustrd> </RmtInf> </CdtTrfTxInf> </PmtInf> </CstmrCdtTrfInitn> </Document>
sepa pain001 <json_payment> <json_params>
Description
pain.001 with parameters: version (03 or 09), report (true: {xml, count, total, message_id, warnings} with the changed texts)
pain.001 with parameters: version (03 or 09), report (true: {xml, count, total, message_id, warnings} with the changed texts)
Parameters
json_payment: The payment order - String - required
json_params: The parameters - String - required
json_payment: The payment order - String - required
json_params: The parameters - String - required
admin
sepa pain001 "{\"message_id\": \"VIR-2026-11-03\", \"created\": \"2026-11-03T09:30:00\", \"execution_date\": \"2026-11-05\", \"debtor\": {\"name\": \"Atelier Payet SARL\", \"iban\": \"FR7630006000011234567890189\", \"bic\": \"AGRIFRPP\"}, \"payments\": [{\"end_to_end_id\": \"FOUR-881\", \"amount\": 1250.5, \"creditor\": {\"name\": \"Soci\u00e9t\u00e9 \u00c9quipement & Fils\", \"iban\": \"FR7630004000031234567890143\", \"bic\": \"BNPAFRPP\"}, \"remittance\": \"Invoice 881\"}, {\"end_to_end_id\": \"RENT-11\", \"amount\": 80, \"creditor\": {\"name\": \"SCI du Port\", \"iban\": \"FR7610107001011234567890129\"}, \"remittance\": \"Rent November\"}]}" "{\"version\": \"09\", \"report\": true}"
mentdb
{"xml": "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\ <Document xmlns=\"urn:iso:std:iso:20022:tech:xsd:pain.001.001.09\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\ <CstmrCdtTrfInitn>\ <GrpHdr>\ <MsgId>VIR-2026-11-03</MsgId>\ <CreDtTm>2026-11-03T09:30:00</CreDtTm>\ <NbOfTxs>2</NbOfTxs>\ <CtrlSum>1330.50</CtrlSum>\ <InitgPty>\ <Nm>Atelier Payet SARL</Nm>\ </InitgPty>\ </GrpHdr>\ <PmtInf>\ <PmtInfId>VIR-2026-11-03-1</PmtInfId>\ <PmtMtd>TRF</PmtMtd>\ <NbOfTxs>2</NbOfTxs>\ <CtrlSum>1330.50</CtrlSum>\ <PmtTpInf>\ <SvcLvl>\ <Cd>SEPA</Cd>\ </SvcLvl>\ </PmtTpInf>\ <ReqdExctnDt>\ <Dt>2026-11-05</Dt>\ </ReqdExctnDt>\ <Dbtr>\ <Nm>Atelier Payet SARL</Nm>\ </Dbtr>\ <DbtrAcct>\ <Id>\ <IBAN>FR7630006000011234567890189</IBAN>\ </Id>\ </DbtrAcct>\ <DbtrAgt>\ <FinInstnId>\ <BICFI>AGRIFRPP</BICFI>\ </FinInstnId>\ </DbtrAgt>\ <ChrgBr>SLEV</ChrgBr>\ <CdtTrfTxInf>\ <PmtId>\ <EndToEndId>FOUR-881</EndToEndId>\ </PmtId>\ <Amt>\ <InstdAmt Ccy=\"EUR\">1250.50</InstdAmt>\ </Amt>\ <CdtrAgt>\ <FinInstnId>\ <BICFI>BNPAFRPP</BICFI>\ </FinInstnId>\ </CdtrAgt>\ <Cdtr>\ <Nm>Societe Equipement Fils</Nm>\ </Cdtr>\ <CdtrAcct>\ <Id>\ <IBAN>FR7630004000031234567890143</IBAN>\ </Id>\ </CdtrAcct>\ <RmtInf>\ <Ustrd>Invoice 881</Ustrd>\ </RmtInf>\ </CdtTrfTxInf>\ <CdtTrfTxInf>\ <PmtId>\ <EndToEndId>RENT-11</EndToEndId>\ </PmtId>\ <Amt>\ <InstdAmt Ccy=\"EUR\">80.00</InstdAmt>\ </Amt>\ <Cdtr>\ <Nm>SCI du Port</Nm>\ </Cdtr>\ <CdtrAcct>\ <Id>\ <IBAN>FR7610107001011234567890129</IBAN>\ </Id>\ </CdtrAcct>\ <RmtInf>\ <Ustrd>Rent November</Ustrd>\ </RmtInf>\ </CdtTrfTxInf>\ </PmtInf>\ </CstmrCdtTrfInitn>\ </Document>\ ", "count": 2, "total": 1330.5, "message_id": "VIR-2026-11-03", "warnings": ["payment 1 creditor name: 'Société Équipement & Fils' written 'Societe Equipement Fils' (SEPA character set)"]}"
Used in use cases (1 recipe)
Accountant & manager › Pay the suppliers: build the SEPA credit transfer file (pain.001) from the invoices to pay
Accountant & manager › Pay the suppliers: build the SEPA credit transfer file (pain.001) from the invoices to pay
sepa pain008 <json_debits>
Description
Write a SEPA direct debit file pain.008.001.02: message_id, created, creditor {name, iban, bic, creditor_id (SEPA creditor identifier, ICS in France: FRkkZZZnnnnnn, check digits verified)}, collection_date, scheme (CORE or B2B), debits [{end_to_end_id, amount, mandate_id, mandate_date (signature), sequence (FRST first debit, RCUR recurrent, OOFF one-off, FNAL last), debtor {name, iban, bic}, remittance, collection_date (optional), amendment {original_mandate_id, original_iban}}]. One payment block per sequence type and collection date, as the banks require; number of transactions and control sums computed; IBAN, BIC, amounts and mandate dates checked; texts converted to the SEPA character set
Write a SEPA direct debit file pain.008.001.02: message_id, created, creditor {name, iban, bic, creditor_id (SEPA creditor identifier, ICS in France: FRkkZZZnnnnnn, check digits verified)}, collection_date, scheme (CORE or B2B), debits [{end_to_end_id, amount, mandate_id, mandate_date (signature), sequence (FRST first debit, RCUR recurrent, OOFF one-off, FNAL last), debtor {name, iban, bic}, remittance, collection_date (optional), amendment {original_mandate_id, original_iban}}]. One payment block per sequence type and collection date, as the banks require; number of transactions and control sums computed; IBAN, BIC, amounts and mandate dates checked; texts converted to the SEPA character set
Parameters
json_debits: The direct debits - String - required
json_debits: The direct debits - String - required
admin
sepa pain008 "{\"message_id\": \"PRL-2026-11\", \"created\": \"2026-11-03T09:30:00\", \"collection_date\": \"2026-11-10\", \"creditor\": {\"name\": \"Club Sportif Saint-Pierre\", \"iban\": \"FR7630006000011234567890189\", \"bic\": \"AGRIFRPP\", \"creditor_id\": \"FR72ZZZ123456\"}, \"debits\": [{\"end_to_end_id\": \"COT-2026-11-001\", \"amount\": 35, \"mandate_id\": \"MDT-0001\", \"mandate_date\": \"2025-09-01\", \"sequence\": \"RCUR\", \"debtor\": {\"name\": \"H\u00e9l\u00e8ne Payet\", \"iban\": \"FR7630004000031234567890143\"}, \"remittance\": \"Cotisation novembre\"}, {\"end_to_end_id\": \"COT-2026-11-002\", \"amount\": 35.5, \"mandate_id\": \"MDT-0042\", \"mandate_date\": \"2026-10-20\", \"sequence\": \"FRST\", \"debtor\": {\"name\": \"Paul Hoarau\", \"iban\": \"FR7610107001011234567890129\", \"bic\": \"BREDFRPP\"}, \"remittance\": \"Cotisation novembre\"}]}"
mentdb
<?xml version="1.0" encoding="UTF-8"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.001.02" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <CstmrDrctDbtInitn> <GrpHdr> <MsgId>PRL-2026-11</MsgId> <CreDtTm>2026-11-03T09:30:00</CreDtTm> <NbOfTxs>2</NbOfTxs> <CtrlSum>70.50</CtrlSum> <InitgPty> <Nm>Club Sportif Saint-Pierre</Nm> </InitgPty> </GrpHdr> <PmtInf> <PmtInfId>PRL-2026-11-1</PmtInfId> <PmtMtd>DD</PmtMtd> <NbOfTxs>1</NbOfTxs> <CtrlSum>35.50</CtrlSum> <PmtTpInf> <SvcLvl> <Cd>SEPA</Cd> </SvcLvl> <LclInstrm> <Cd>CORE</Cd> </LclInstrm> <SeqTp>FRST</SeqTp> </PmtTpInf> <ReqdColltnDt>2026-11-10</ReqdColltnDt> <Cdtr> <Nm>Club Sportif Saint-Pierre</Nm> </Cdtr> <CdtrAcct> <Id> <IBAN>FR7630006000011234567890189</IBAN> </Id> </CdtrAcct> <CdtrAgt> <FinInstnId> <BIC>AGRIFRPP</BIC> </FinInstnId> </CdtrAgt> <ChrgBr>SLEV</ChrgBr> <CdtrSchmeId> <Id> <PrvtId> <Othr> <Id>FR72ZZZ123456</Id> <SchmeNm> <Prtry>SEPA</Prtry> </SchmeNm> </Othr> </PrvtId> </Id> </CdtrSchmeId> <DrctDbtTxInf> <PmtId> <EndToEndId>COT-2026-11-002</EndToEndId> </PmtId> <InstdAmt Ccy="EUR">35.50</InstdAmt> <DrctDbtTx> <MndtRltdInf> <MndtId>MDT-0042</MndtId> <DtOfSgntr>2026-10-20</DtOfSgntr> </MndtRltdInf> </DrctDbtTx> <DbtrAgt> <FinInstnId> <BIC>BREDFRPP</BIC> </FinInstnId> </DbtrAgt> <Dbtr> <Nm>Paul Hoarau</Nm> </Dbtr> <DbtrAcct> <Id> <IBAN>FR7610107001011234567890129</IBAN> </Id> </DbtrAcct> <RmtInf> <Ustrd>Cotisation novembre</Ustrd> </RmtInf> </DrctDbtTxInf> </PmtInf> <PmtInf> <PmtInfId>PRL-2026-11-2</PmtInfId> <PmtMtd>DD</PmtMtd> <NbOfTxs>1</NbOfTxs> <CtrlSum>35.00</CtrlSum> <PmtTpInf> <SvcLvl> <Cd>SEPA</Cd> </SvcLvl> <LclInstrm> <Cd>CORE</Cd> </LclInstrm> <SeqTp>RCUR</SeqTp> </PmtTpInf> <ReqdColltnDt>2026-11-10</ReqdColltnDt> <Cdtr> <Nm>Club Sportif Saint-Pierre</Nm> </Cdtr> <CdtrAcct> <Id> <IBAN>FR7630006000011234567890189</IBAN> </Id> </CdtrAcct> <CdtrAgt> <FinInstnId> <BIC>AGRIFRPP</BIC> </FinInstnId> </CdtrAgt> <ChrgBr>SLEV</ChrgBr> <CdtrSchmeId> <Id> <PrvtId> <Othr> <Id>FR72ZZZ123456</Id> <SchmeNm> <Prtry>SEPA</Prtry> </SchmeNm> </Othr> </PrvtId> </Id> </CdtrSchmeId> <DrctDbtTxInf> <PmtId> <EndToEndId>COT-2026-11-001</EndToEndId> </PmtId> <InstdAmt Ccy="EUR">35.00</InstdAmt> <DrctDbtTx> <MndtRltdInf> <MndtId>MDT-0001</MndtId> <DtOfSgntr>2025-09-01</DtOfSgntr> </MndtRltdInf> </DrctDbtTx> <DbtrAgt> <FinInstnId> <Othr> <Id>NOTPROVIDED</Id> </Othr> </FinInstnId> </DbtrAgt> <Dbtr> <Nm>Helene Payet</Nm> </Dbtr> <DbtrAcct> <Id> <IBAN>FR7630004000031234567890143</IBAN> </Id> </DbtrAcct> <RmtInf> <Ustrd>Cotisation novembre</Ustrd> </RmtInf> </DrctDbtTxInf> </PmtInf> </CstmrDrctDbtInitn> </Document>
sepa pain008 <json_debits> <json_params>
Description
pain.008 with parameters: version (02 or 08), report (true: {xml, count, total, message_id, batches [{sequence, collection_date, count, total}], warnings}) report and batch_booking also accept "true" / "1" as text. An amendment {"other_bank": true} (the debtor moved to another bank) writes the original debtor agent SMNDA required by the EPC rules (sequence FRST). The PmtInfId stays within 35 characters whatever the number of batches; an initiating party empty after the SEPA character set becomes the creditor name.
pain.008 with parameters: version (02 or 08), report (true: {xml, count, total, message_id, batches [{sequence, collection_date, count, total}], warnings}) report and batch_booking also accept "true" / "1" as text. An amendment {"other_bank": true} (the debtor moved to another bank) writes the original debtor agent SMNDA required by the EPC rules (sequence FRST). The PmtInfId stays within 35 characters whatever the number of batches; an initiating party empty after the SEPA character set becomes the creditor name.
Parameters
json_debits: The direct debits - String - required
json_params: The parameters - String - required
json_debits: The direct debits - String - required
json_params: The parameters - String - required
admin
sepa pain008 "{\"message_id\": \"PRL-2026-11\", \"created\": \"2026-11-03T09:30:00\", \"collection_date\": \"2026-11-10\", \"creditor\": {\"name\": \"Club Sportif Saint-Pierre\", \"iban\": \"FR7630006000011234567890189\", \"bic\": \"AGRIFRPP\", \"creditor_id\": \"FR72ZZZ123456\"}, \"debits\": [{\"end_to_end_id\": \"COT-2026-11-001\", \"amount\": 35, \"mandate_id\": \"MDT-0001\", \"mandate_date\": \"2025-09-01\", \"sequence\": \"RCUR\", \"debtor\": {\"name\": \"H\u00e9l\u00e8ne Payet\", \"iban\": \"FR7630004000031234567890143\"}, \"remittance\": \"Cotisation novembre\", \"amendment\": {\"original_mandate_id\": \"OLD-0001\"}}, {\"end_to_end_id\": \"COT-2026-11-002\", \"amount\": 35.5, \"mandate_id\": \"MDT-0042\", \"mandate_date\": \"2026-10-20\", \"sequence\": \"FRST\", \"debtor\": {\"name\": \"Paul Hoarau\", \"iban\": \"FR7610107001011234567890129\", \"bic\": \"BREDFRPP\"}, \"remittance\": \"Cotisation novembre\"}]}" "{\"version\": \"08\", \"report\": true}"
mentdb
{"xml": "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\ <Document xmlns=\"urn:iso:std:iso:20022:tech:xsd:pain.008.001.08\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">\ <CstmrDrctDbtInitn>\ <GrpHdr>\ <MsgId>PRL-2026-11</MsgId>\ <CreDtTm>2026-11-03T09:30:00</CreDtTm>\ <NbOfTxs>2</NbOfTxs>\ <CtrlSum>70.50</CtrlSum>\ <InitgPty>\ <Nm>Club Sportif Saint-Pierre</Nm>\ </InitgPty>\ </GrpHdr>\ <PmtInf>\ <PmtInfId>PRL-2026-11-1</PmtInfId>\ <PmtMtd>DD</PmtMtd>\ <NbOfTxs>1</NbOfTxs>\ <CtrlSum>35.50</CtrlSum>\ <PmtTpInf>\ <SvcLvl>\ <Cd>SEPA</Cd>\ </SvcLvl>\ <LclInstrm>\ <Cd>CORE</Cd>\ </LclInstrm>\ <SeqTp>FRST</SeqTp>\ </PmtTpInf>\ <ReqdColltnDt>2026-11-10</ReqdColltnDt>\ <Cdtr>\ <Nm>Club Sportif Saint-Pierre</Nm>\ </Cdtr>\ <CdtrAcct>\ <Id>\ <IBAN>FR7630006000011234567890189</IBAN>\ </Id>\ </CdtrAcct>\ <CdtrAgt>\ <FinInstnId>\ <BICFI>AGRIFRPP</BICFI>\ </FinInstnId>\ </CdtrAgt>\ <ChrgBr>SLEV</ChrgBr>\ <CdtrSchmeId>\ <Id>\ <PrvtId>\ <Othr>\ <Id>FR72ZZZ123456</Id>\ <SchmeNm>\ <Prtry>SEPA</Prtry>\ </SchmeNm>\ </Othr>\ </PrvtId>\ </Id>\ </CdtrSchmeId>\ <DrctDbtTxInf>\ <PmtId>\ <EndToEndId>COT-2026-11-002</EndToEndId>\ </PmtId>\ <InstdAmt Ccy=\"EUR\">35.50</InstdAmt>\ <DrctDbtTx>\ <MndtRltdInf>\ <MndtId>MDT-0042</MndtId>\ <DtOfSgntr>2026-10-20</DtOfSgntr>\ </MndtRltdInf>\ </DrctDbtTx>\ <DbtrAgt>\ <FinInstnId>\ <BICFI>BREDFRPP</BICFI>\ </FinInstnId>\ </DbtrAgt>\ <Dbtr>\ <Nm>Paul Hoarau</Nm>\ </Dbtr>\ <DbtrAcct>\ <Id>\ <IBAN>FR7610107001011234567890129</IBAN>\ </Id>\ </DbtrAcct>\ <RmtInf>\ <Ustrd>Cotisation novembre</Ustrd>\ </RmtInf>\ </DrctDbtTxInf>\ </PmtInf>\ <PmtInf>\ <PmtInfId>PRL-2026-11-2</PmtInfId>\ <PmtMtd>DD</PmtMtd>\ <NbOfTxs>1</NbOfTxs>\ <CtrlSum>35.00</CtrlSum>\ <PmtTpInf>\ <SvcLvl>\ <Cd>SEPA</Cd>\ </SvcLvl>\ <LclInstrm>\ <Cd>CORE</Cd>\ </LclInstrm>\ <SeqTp>RCUR</SeqTp>\ </PmtTpInf>\ <ReqdColltnDt>2026-11-10</ReqdColltnDt>\ <Cdtr>\ <Nm>Club Sportif Saint-Pierre</Nm>\ </Cdtr>\ <CdtrAcct>\ <Id>\ <IBAN>FR7630006000011234567890189</IBAN>\ </Id>\ </CdtrAcct>\ <CdtrAgt>\ <FinInstnId>\ <BICFI>AGRIFRPP</BICFI>\ </FinInstnId>\ </CdtrAgt>\ <ChrgBr>SLEV</ChrgBr>\ <CdtrSchmeId>\ <Id>\ <PrvtId>\ <Othr>\ <Id>FR72ZZZ123456</Id>\ <SchmeNm>\ <Prtry>SEPA</Prtry>\ </SchmeNm>\ </Othr>\ </PrvtId>\ </Id>\ </CdtrSchmeId>\ <DrctDbtTxInf>\ <PmtId>\ <EndToEndId>COT-2026-11-001</EndToEndId>\ </PmtId>\ <InstdAmt Ccy=\"EUR\">35.00</InstdAmt>\ <DrctDbtTx>\ <MndtRltdInf>\ <MndtId>MDT-0001</MndtId>\ <DtOfSgntr>2025-09-01</DtOfSgntr>\ <AmdmntInd>true</AmdmntInd>\ <AmdmntInfDtls>\ <OrgnlMndtId>OLD-0001</OrgnlMndtId>\ </AmdmntInfDtls>\ </MndtRltdInf>\ </DrctDbtTx>\ <DbtrAgt>\ <FinInstnId>\ <Othr>\ <Id>NOTPROVIDED</Id>\ </Othr>\ </FinInstnId>\ </DbtrAgt>\ <Dbtr>\ <Nm>Helene Payet</Nm>\ </Dbtr>\ <DbtrAcct>\ <Id>\ <IBAN>FR7630004000031234567890143</IBAN>\ </Id>\ </DbtrAcct>\ <RmtInf>\ <Ustrd>Cotisation novembre</Ustrd>\ </RmtInf>\ </DrctDbtTxInf>\ </PmtInf>\ </CstmrDrctDbtInitn>\ </Document>\ ", "count": 2, "total": 70.5, "message_id": "PRL-2026-11", "batches": [{"sequence": "FRST", "collection_date": "2026-11-10", "count": 1, "total": 35.5}, {"sequence": "RCUR", "collection_date": "2026-11-10", "count": 1, "total": 35}], "warnings": ["debit 1 debtor name: 'Hélène Payet' written 'Helene Payet' (SEPA character set)"]}"
Used in use cases (1 recipe)
Accountant & manager › Collect the monthly fees: SEPA direct debit file (pain.008) with first and recurring debits
Accountant & manager › Collect the monthly fees: SEPA direct debit file (pain.008) with first and recurring debits