Implementation Guide

Introduction

PayEx Billing creates invoices for the PayEx Ledger System. PayEx Billing compiles one-time and recurring fees and credits to an invoice per end customer. When creating an invoice, any debit or credit products are taken into account. The invoice information is then exported to PayEx Ledger System (invoice service) and PayEx Distribution System. Billing-files can be received and loaded automatically all around the clock every day of the year.

Prerequisites

Before start implementing PayEx Billing the following is required:

  • An Agreement Invoice Service with Billing together with:
    • A SFTP Client
    • Business Rules
  • Revenue Accounting Rules (If Revenue Accounting)

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

1653037758665-469.png

Overview

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

All main steps of the invoice process are described below. Please note that all examples below are primarily for visualization, to help you get an understanding of the Bicus2/KUB file format and to support you in the implementation.

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

Information Overview

PayEx Billing aggregates one-time and recurring fees & credits to one invoice per end customer. When creating invoice information, any submitted discounts and credit products are taken into account. The invoice is then exported to PayEx ledger system and PayEx Distribution system (creation of invoices and mailings to distribution).

When implementing Invoice Service Billing with Revenue Accounting, customer-specific configuration takes place.

Bicus2 (Customerfile xml)

Customer file to billing (Bicus2) is used to submit end-user information to the PayEx Billing system. Bicus2 contains the end customer information for example address, subscription numbers and recurring products to be processed in the PayEx Billing System.

KUB (Customerfile csv)

Customer file to PayEx billing (KUB) is used to submit end-user information to the PayEx Billing system. KUB contains the end customer information for example address, subscription numbers and recurring products to be processed in the PayEx Billing System.

PR01 (Productfile)

Using PR01 files in the PayEx Billing system gives possibilities to create non recurrent products on both customer and subscription level.

Communication of non recurring products that will be added at the end customer level. The product file contains information about price (+/-), VAT rate and the product name (invoice text) that is communicated to the end customer.

Product Catalog

The product catalog contains instructions about how all products should be booked in correlation with revenue accounting.

Revenue Accounting Rules

...

Receipt

After processing one of the above files a receipt will be created.

A detailed description you can find here.

...

Reports

Many different reports with statistics can be created after every billrun or per month. Below will always be produced.

Invoice Journal Billing

For every billrun in the PayEx Billing System an Invoice Journal is being created. The Invoice Journal contains information regarding the new invoice numbers and associated customers, amounts and VAT. File has XML format.

UnbilledReport

Reports for unbilled fees/usage can be produced both before and after a billrun. UnbilledReport are both produced in the skv-format aswell as in text format

Revenue Accounting

Revenue Accounting is an optional service for PayEx companies.

BillingAccounting

Each Billrun will be booked and there will be produced a report with name BillingAccounting.xml contains:

  • Invoicenumber​

  • VAT code

  • Account

  • ProductCode

  • Group company code

  • Cost center

  • Amount

BilledInAdvanced

To close the books regarding revenue accounting every month an XML report regarding all billed fees which have been billed in advance will be created. This means that these fees have a later billmonth then current billmonth.

UnbilledProduct

Another possible report to close the books every month with. This XML report contains all processed fees with associated revenue ID in the PayEx Billing System, but not billed yet.

Error log

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

Created by David Persson on 2021/01/29 09:26