expand all
Projects Research Private Contact

Michael Pfeiffer
Imprint, Disclaimer


SEPA, Single Euro Payments Area

General Description

For associations or clubs it's often hard to do the accounting job without supporting software. The here provided tool creates so called pain xml files which can be uploaded to the bank in it's online portal.

One pain file can contain one or more either bank or debit transfers. The source of the data is maintained in text files which are converted by the provided tool sepa. Especially the debit transfers are challenging because the are depending on mandates which are issued by the debitors. In the case of repeating debit transfers this tool maintains the bank details for each debitor. If the bank details are changing for one debitor the tool warns and asks you to produce more than one pain file if necessary.

For further information have a look in the man pages in this section.

Sample

This sample shows the procedure of a debit transfer with just one debitor. As source the following contents of the input file is used:
BEGIN {
  Art	      DDCORE
  Referenz    DE11ZZZ00000112233
  Name        Karl Max Mustermann
  IBAN        DE39370502991234567890
  BIC         COKSDE33XXX
  Ausfuehrung 04.12.2014
}

{
  Transaktion	Einzug-Wiederholung
  Mandat	MM1
  SigDatum 	30.04.2013
  Name          Der Geldhabende
  IBAN		DE71820642281234567890
  BIC		ERFBDE8EXXX
  Betrag	123,45
  Zweck         Verwendungszweck
  Text		DieZweite
  Text		DieDritte
}

First debit transfer

If it's the first debit transfer from "Der Geldhabende" you have to use the tool with the option "-tf" to create a transfer file with "FRST"-entries. If you forget this option you get a warning concerning first time entries.

The command line for conversion:
sepa -tf -c Einzug.ctl

As result you get the follwing xml file:
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.008.002.02"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         
xsi:schemaLocation="urn:iso:std:iso:20022:tech:xsd:pain.008.002.02
          pain.008.002.02.xsd">
  <CstmrDrctDbtInitn>
    <GrpHdr>
      <MsgId>MID-000bbfd4</MsgId>
      <CreDtTm>2014-11-02T11:56:52</CreDtTm>
      <NbOfTxs>1</NbOfTxs>
      <InitgPty>
        <Nm>Karl Max Mustermann</Nm>
      </InitgPty>
    </GrpHdr>
    <PmtInf>
      <PmtInfId>PIID-000bbfd4</PmtInfId>
      <PmtMtd>DD</PmtMtd>
      <BtchBookg>false</BtchBookg>
      <NbOfTxs>1</NbOfTxs>
      <CtrlSum>123.45</CtrlSum>
      <PmtTpInf>
        <SvcLvl>
          <Cd>SEPA</Cd>
        </SvcLvl>
        <LclInstrm>
          <Cd>CORE</Cd>
        </LclInstrm>
        <SeqTp>FRST</SeqTp>
      </PmtTpInf>
      <ReqdColltnDt>2014-12-04</ReqdColltnDt>
      <Cdtr>
        <Nm>Karl Max Mustermann</Nm>
      </Cdtr>
      <CdtrAcct>
        <Id>
          <IBAN>DE39370502991234567890</IBAN>
        </Id>
      </CdtrAcct>
      <CdtrAgt>
        <FinInstnId>
          <BIC>COKSDE33XXX</BIC>
        </FinInstnId>
      </CdtrAgt>
      <ChrgBr>SLEV</ChrgBr>
      <CdtrSchmeId>
        <Id>
          <PrvtId>
            <Othr>
              <Id>DE11ZZZ00000112233</Id>
              <SchmeNm>
                <Prtry>SEPA</Prtry>
              </SchmeNm>
            </Othr>
          </PrvtId>
        </Id>
      </CdtrSchmeId>
      <DrctDbtTxInf>
        <PmtId>
          <EndToEndId>NOTPROVIDED</EndToEndId>
        </PmtId>
        <InstdAmt Ccy="EUR">123.45</InstdAmt>
        <DrctDbtTx>
          <MndtRltdInf>
            <MndtId>MM1</MndtId>
            <DtOfSgntr>2013-04-30</DtOfSgntr>
            <AmdmntInd>false</AmdmntInd>
          </MndtRltdInf>
        </DrctDbtTx>
        <DbtrAgt>
          <FinInstnId>
            <BIC>ERFBDE8EXXX</BIC>
          </FinInstnId>
        </DbtrAgt>
        <Dbtr>
          <Nm>Der Geldhabende</Nm>
        </Dbtr>
        <DbtrAcct>
          <Id>
            <IBAN>DE71820642281234567890</IBAN>
          </Id>
        </DbtrAcct>
        <RmtInf>
          <Ustrd>Verwendungszweck DieZweite DieDritte</Ustrd>
        </RmtInf>
      </DrctDbtTxInf>
    </PmtInf>
  </CstmrDrctDbtInitn>
</Document>

Repeating debit transfer

For repeating debit transfers you don't have to change the input file, just for the amount probably, and you get the right pain files for transfer.

In that cases you have to type in the following command:
sepa -c Einzug.ctl