Bollettino Postale processing

Bollettino Postale is a pay slip solution for the Italian market. They can be delivered to Poste Italiane by hand directly to a post office, or through a Tobacco Store, SISAL machine or online via apps and web portals. Full official documentation [PDF - Italian] can be downloaded from the Poste Italiane website. The FinDock implement for Bollettino Postale supports the following payment flow:

  1. Generate Bollittino Postale payment references (FinDock)
  2. Print pay slips (outside FinDock)
  3. Run campaign (outside FinDock)
  4. Upload payment reports from Poste Italiane (Salesforce Chatter)
  5. Reconcile with Guided Matching (and re-run reconciliation using bank reports, if needed (FinDock)

Bollettino Postale pay slips

All Bollettino Postale pay slips have the same basic layout, as illustrated here with payment slip type 896. Bollettino Postale pay slip example

  1. Payment amount in euros
  2. Postal current account number
  3. IBAN code
  4. Name of the creditor /cause to donate to
  5. Debtor Name and Address
  6. Codeline

For reconciliation purposes, the Codeline on the is the most essential part of the pay slip. It contains four fields. From right to left:

  • Bollettino Postale pay slip type
  • Creditor account number
  • Amount
  • Quarto Campo (payment reference number)

Bollettino pay slip types

There are four types of Bollettino Postale pay slips. Each type has a different data collection method and also determines what information is included in the reports you get back from the post office. It is important to know the structure and nature of each pay slip type. You need to different Guided Matching rules for each pay slip type to handle these differences in your reconciliation process. Two types use pre-filled data, while the other two employ manual data entries:

  • Paga Procompilato (pre-filled): 674 & 896
  • Paga Blanco (blank): 123 & 451

There is also a fifth pay slip type called TEL. This type is filled in by the debtor online but is otherwise equal to type 896. The table below summarizes which fields are pre-filled (marked with ‘X’) and which need to be manually entered by the donor or customer.

Field896674451123
Creditor Bank AccountXXX-
Creditor NameXXX-
CauseXX--
Debtor SurnameXX--
Debtor AddressXX--
Payment Reference (Quarto Campo)XX--
AmountX---

Payment reference (Quarto Campo) The payment reference stored in the fourth field from the right in the Codeline varies depending on the type of pay slip.

  • Type 123: no Quarto Campo reference
  • Type 451: generated and printed by Poste Italiane in a predetermined format
  • Type 674 & 896: an 18 digit code generated and printed by the creditor (e.g. nonprofit organization). From left-to-right, the code uses the following structure:
    • The first 16 are generated by the creditor according to the creditor's own rules.
    • The last 2 digits are reserved for a modulo 93 check on the first 16 digits.

Generating payment references

There are two ways to create Quarto Campo payment references with FinDock.

  • Payment Request Generator: with the generator, you can create references without having to create installments. The references themselves can be based on either the Bollettino Postale reference pre-configured by FinDock which is guaranteed to be unique, or you can use the Bring Your Own reference option.
  • Payment Schedule: use type ‘Bollettino Postale’ to generate references for installments that you expect to be paid.

Reconciling Bollettino Postale payments

The reconciliation process allows you to confirm the accuracy of the payment data in your Salesforce org as well as enrich the data with additional information. Typically, bank statements are used for reconciliation, but Bollettino Postale payments can also be reconciled using reports from Poste Italiane.

Poste Italiane reports

Reports can be downloaded from Poste Italiane. The contents of the ZIP file differs depending on the pay slip type, as outlined below.

Reports in ZIP with images

The downloaded ZIP files contains:

  • A CSV file containing information about the received Bollettino Postale pay slips
  • Scans of the individual pay slips. Since the data quality of the 123 & 451 types are expected to be low and the CSV does not contain debtor (donor) data, these scans need to be manually reviewed to match pay slip data against data in Salesforce. Some customers receive types 674 & 896 in the same report as well, but these are (more) likely to be matched on payment reference.

The CSV has a structure as outlined in the table below.

Column Nr.Column NameExample Data
1ACCOUNTNUMBER000000298000
2LOCATIONFI
3DATACARICAMENTO
4DATAOPERAZIONE20181005
5CODICEPROVINCIA81
6CODICEUFFICIO67
7TIPODOCUMENTO123
8IMPORTODOCUMENTO1000
9DATAPREALLIBRAMENTO
10DATAPOSTALLIBRAMENTO20181009
11QUARTOCAMPO*8278081067020035*
12PROGRESSIVODIMARCAGGIO
13NCONTOTRAENTE
14DIVISAE
15FLAGINSANABILIK
16PROGRESSIVODISELEZIONE
17REPORT_VERSION*20181009092456 *
18SVX
19Immagine fronteBR_5_FI50029800020181008K000007FA.tif
20Immagine retro

Reports without images, in CSV

The Postal Office often does not include scans of pay slips with types 674 & 896, since the payment reference is pre-generated and should be a trusted match with data in Salesforce. The CSV file in these reports has a structure as outlined in the table below.

Column Nr.Column NameExample Data
1Data Operazione28/09/2018
2Ufficio Postale055 0288
3ValutaE
4Importo3000
5Data Accredito01/10/2018
6Quarto campo*3206200086476813*

Guided Matching for Bollettino Postale

Before you can start using Guided Matching for Bollettino Postale, you need:

FinDock provides managed and suggested Guided Matching rules for Bollettino Postale. You can add your own Guide Matching rules to the predefined rule sets. Each Report Sub Type has its own Guided Matching rule set to allow for different business logic like dealing with different report fields.

Using Guided Matching for Bolletino Postale

To start reconciliation of Bollettino Postale, upload your ZIP archive (most used for types 123 & 451 where little data was pre-filled) or CSV file to Chatter. The file is picked up by FinDock and transformed into Inbound Report records in Salesforce. The Report Type and Report Sub Type are automatically generated, and the rest of the CSV data is added to the Raw Message field. If provided, the original pay slip scans are attached to the Inbound Report record.

Matching rule behavior of managed rules

Once Inbound Report records have been created, Guided Matching will take over. With a set of pre-configured Guided Matching rules, FinDock:

  1. Maps fields from the CSV (as stored in the ‘Raw Message’ field) to the Inbound Report
  2. Extracts and sets the Payment Reference / Quarto Campo from the Codeline
  3. Extracts and sets the Amount
  4. Extracts and sets the Collection Date
  5. Extracts and sets the Report Date
  6. Extracts and sets the Post Office number
  7. Searches for existing Installments based on the extracted data
    1. If found, sets the Contact based on the existing Installment
    2. If not found:
      1. Ask the user for Contact information by providing a search bar that allows you to both search and select an existing Contact, as well as create a new Contact. The Contact information can be gained from the attached scan of the Bollettino Postale under ‘Files’. PNG files can be opened directly in Salesforce and will open full screen in the same window.
      2. Creates a new Installment with the selected contact
  8. Processes the Installment by updating the amount and changing the status if applicable.

Guided Matching Bollettino Postale Inbound Report details The managed rules create mapping for Inbound Reports as outlined in the table below.

Report FieldWith imagesWithout ImagesDescription
Report TypeBollettinoPostaleBollettinoPostaleSource report type
Report SubTypeTIPODOCUMENTO675896
Report DateDATAOPERAZIONEData OperazioneDate the report was run
Postal OfficeCODICEUFFICIOUfficio PostaleNr. of the post office where the Bollettino Postale was collected
DateDATAPOSTALLIBRAMENTOData AccreditoPayment collection date

The pre-configured rules create mapping for Installments as outlined in the table below.

Installment FieldWith imagesWithout imagesDescription
AmountIMPORTODOCUMENTOImportoThe amount of this transaction. copied from the Recurring Payment.
Final Payment ReferenceQUARTOCAMPOQuarto campoThe payment reference for this installment.