Introduction

Prerequisites

Before you start implementing PayEx Ledger Service the following is required:

• A sFTP Client
• An agreement that includes PayEx Ledger Service (CUSIN)
• Obtained credentials from PayEx
• A basic understanding of file name convention and file format limitations

Please contact us if you have any questions on how to get started.

Overview

Before getting started, have a look at the high level sequence diagram below, which will help you getting a better understanding of the whole process and the components necessary to implement Ledger Service.

All main steps of the process are described below. Please note that all XML examples below are here primarily for display purposes, to help you get an understanding of the CUSIN file format and to aid you in the implementation.

If you encounter any problem during implementation, don't hesitate to contact us.

Invoicing

The Company execute billing process and distribute the invoice to Customer.

Important to note!

• Payment reference must be calculated and presented on the invoice according to PayEx payment reference standard.
• Invoice Reference is used as a reference text to be presented on claims produced by PayEx

The next step is to create your CUSIN file.

Cusin

The first thing you need to do is to create a CUSIN file with extension .XML and UTF-8 encoding. Name it according to the filename convention.

Head over to our technical reference section for a more extensive description of the file format, where you find more information of each element in the XML schema and CUSIN example file.

When you have a complete and validated CUSIN file, you are ready to transfer it to PayEx via sFTP.

Upon reception PayEx will process the file and send you a receipt in return. If something went wrong, you will also receive an error log.

Receipt

When the CUSIN file, containing one or more activities -  is processed a receipt will be created showing numbers of processed customers, numbers of processed invoices and total amount.

Each activity has their own set of result parameters.

You can view the XSD and a detailed description here.

Error log

If errors are encountered during file processing an errorlog will be created. Errors may refer to insufficient customer information, invoice information or format errors.

The first part displays the processed item itself.

The second part of the error log displays the response item message element that gives reference back to the processed file.

You can view the XSD and a detailed description here.

Reports and Accounting

You get response files from PayEx in the from of Bill and Customer Journal.

Bill Journal

Bill Journal is the format used to notify changes in invoice status. Entries could relate to events such as a new claim process level, invoices getting closed and newly registered complaints and respites.

You find the Bill Journal technical reference here.

Customer Journal

Customer Journal is the format used to notify changes in customer information. Entries could relate to events such as a new legal address, activation/cancellation of consent and customer status changes due to decease.

You find the Customer Journal technical reference here.

Accounting

Bookkeeping data is produced on a transactional level and per value date. Files are exported from PayEx on a daily schedule.

ARAccounting file describes the accounting records on a transaction level and Includes invoice number, book account, amount, value date, etc.

You find the ARAccounting technical reference here.

Balance Report

The Balance Report (Client Asset Disbursement) includes:

• A payment summary of amount sold, fees and, VAT and specification of total amount to be paid out.
• A sales specification. Each record of "Client asset disbursement" listed is equal to the full Accounting Detail for the specified period.

• A Fees specification.  Depending on setup, fees are either deducted from the amount to be paid out, or (when applicable) to be invoiced separatly. Each fees row specify Quantity (sales), Amount (sales), Unit price, Provision and fee Amount.