Main.Invoicing.billing.Implementation Guide - Implementation Guide

Page of - last modified by Anders Göthberg on 2025/12/30 14:50

Implementation Guide

Anders Göthberg

2025/12/30 14:50

Table of Contents

Introduction

Prerequisites

Overview

Information Overview

KUB (Customerfile csv)

PR01 (Productfile csv)

Receipt and/or Error logs

Reports

Invoice Journal Billing

UnbilledReport

Revenue Accounting

Revenue Accounting Rules

Product Catalog

BillingAccounting

BilledInAdvanced

UnbilledProduct

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.

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 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.

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 csv)

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.

Receipt and/or Error logs

After Billing processing any files sent by the company a receipt and/or error log will be created.

Detailed description of all all files can be find under Billing File.

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.

Revenue Accounting Rules

Companies that want the additional service "Revenue Accounting" need to work with Billing to set up the rules for how the accounting of the company's own invoice receivables should work so that the company can reconcile this in its accounting system.

Product Catalog

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

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.