Payment overview (Mastercard)

Note: Search for the word 'Mastercard' in Unipedia to find all articles about Mastercard Leverandørservice and Betalingsservice.

Via the Settings button under 'File formats for payment methods' you can make additional settings for Betalingsservice.  

Description of the fields

Type Mastercard Betalingsservice offers two types of solutions. Please specify the type of solution agreed with Mastercard.

• Betalingsservice Basic: Customers must be registered for Betalingsservice.
• Betalingsservice Total: FI cards are sent to customers who are not registered for Betalingsservice, those who are registered are automatically debited via the bank. Customers who are not registered for Betalingsservice can have the invoice sent to their e-boks/Betalingsservice APP if their CPR number or CVR number is stated on the debtor and an agreement has been made with Mastercard. Note: If the CPR number is used, it must be stated in the CVR number field on the debtor.

Important: It is important to specify the correct type of solution Basic/Total. Example: If the collection file is sent as a Total and the agreement you have with Betalingsservice is a Basic solution, the file will fail. Below is an example of the validation file that Betalingsservice returns when you send as Total but have a Basis solution.   Debitor group The debitor group must consist of 5 numbers. The default value is 00001. Note: It is important that the group agreed with Mastercard is used, otherwise the charges will fail. Charging (Principle) Here you can choose between

• Standard
• Remaining

Policy = Standard For this policy, the collection amount will always be the total invoice amount. Any partial settlements are not taken into account. Principle = Remaining For this principle, the collection amount will be the remaining amount on the invoice. Example: An invoice has been issued for DKK 1,000.00. The customer has paid DKK 200, which has been offset on the invoice. The remaining amount on the invoice is now DKK 800.00. This is the amount that will be charged. Note: This principle can only be applied if there is no VAT on the invoice. Create payment ID This parameter only applies to the Total solution. Activated = Uniconta will generate a Payment ID Not activated = Mastercard Betalingsservice will autogenerate a unique Payment ID In most cases, it will be an advantage to let Uniconta create the Payment ID. Below is a more detailed description. Customers who are not registered for Betalingsservice will be sent an Inpayment slip with a FIK71. Below is an example of an Inpayment Card. The OCR line is made up of the following values Card type: Betalingsservice only supports card type 71 Payment ID: The payment identification is 15 digits long. The last digit is a check digit, which is modulus-10 calculated. If you have activated 'Create payment ID', Uniconta will create a payment ID based on the setup under Company information. In this example, eight digits will be allocated to the debtor account and six digits to the invoice number. Note that this is the same setup used for invoices in Uniconta. If you have not activated 'Create payment ID', Mastercard Betalingsservice will create a unique payment ID. In the above example, the payment ID = 000003629500004. Please note that the payment will generate a transaction in the bank that is not immediately identifiable. This is an example of what an entry text would look like in the bank: 011019 indbet.ID = 000003629500004. The payment was made on d. 01.10.2019. The payment ID has been autogenerated by Mastercard and can therefore not be used to identify who the payment concerns. Of course, Mastercard keeps track of who has paid and you can also order a so-called 686 delivery that will translate the payment ID to the actual payer. 686 is a fixed-format text file that can be read. FI-Creditor number: Is an identification of the creditor's bank account. The creditor number has 8 digits - the first digit is 8. FI notification should be changed to Betalingsservice. Read more about this in the section Betalingsservice. Find it here. Payout is blocked With this parameter, payouts can be blocked. Extended delivery deadline Collection information can be delivered until the 6th last banking day of the month before the payment month. However, it is possible to extend the submission deadline to the 3rd last banking day of the month before the payment month. However, you should be aware that Mastercard will charge a surcharge to the transaction price. This means that the debtor will be notified on a separate payment overview. To give the option to postpone the delivery deadline, you must activate 'Extended delivery deadline'. Allow transactions without invoice number Version-93 If this parameter is activated, it will be possible to charge/pay transactions without an invoice number.

Payment overview template

The payment overview is an overview showing the coming month's payments from the debtor's account. The overview is sent to the debtor electronically or by regular mail immediately before the end of the month. The payment overview is intended for specifying the payment and for any notifications. In Uniconta, you can build the text in a template. The text can consist of fixed texts + a number of defined parameters. Read more about the legal requirements for the text at Mastercard. Template (invoice lines) This template is used for transactions that have an invoice number and exist in the invoice journal. Uniconta inserts the above standard template, which you can then customize to suit your needs. There are a few rules that must be followed for the template to work. - Parameter %20, %21 and %22 must be in the same line if they are represented - A line can have a maximum of 60 characters. It is also recommended that you comply with the requirements that Mastercard Betalingsservice points out. Below are the requirements from Mastercard. The payment overview is intended for the specification of the payment and for any notifications of a non-promotional nature. Certain information must appear on the payment summary. For example, the amount, payment date, your name and information about the payment must appear so that the customer can uniquely identify the payment. It is not allowed to advertise on the payment summary, as this would be a violation of the Danish Marketing Practices Act's rules on "direct unsolicited marketing". Parameters Here is a description of the parameters that can be used in the structure of the text. Header parameters These are the parameters that can be used in the upper part of the text. %10 = Customer number (Uniconta Mandate-Id) %11 = Invoice number %12 = Invoice date %13 = Debtor name %14 = Debtor address %15 = Comment from sales order header. Example: This example illustrates how the header text can be structured. All available parameters have been used - including a fixed text about contacting the accounting department. Below is the template used on invoice number 230. The text 'Delivery of table legs on backorder'. Is text that has been entered in the comment field on the order header. Body parameter These are the parameters that can be used to print the invoice lines. Note: It is not a requirement that the invoice lines are printed. They can be omitted completely if you wish. %20 = Quantity %20H = Quantity with header %20Z = Quantity (zero not shown) %20ZH = Quantity with header (zero not shown) %21 = Line text %21H = Line text with header %22 = Line amount %22H = Line amount with header %22Z = Line amount (zero not shown) %22ZH = Line amount with header (zero not shown) %25 = This parameter can be used when you have selected Principle = Remaining. The installment amount is inserted here. Example: This example illustrates how the Body text can be structured. All available parameters have been used. An 'H' has been specified which will insert a column header. The 'H' can be omitted to simply write %20 %21 %22. Below is the template used on invoice number 230. The text 'Screws are enclosed' is a line note. The line columns have been given a heading. Each line can be a maximum of 60 characters. By default, 16 characters are allocated to Amount and 5 characters to Quantity. The remaining space is used for the line text. You can omit %20 if the number is always 1 or an unnecessary piece of information. In the following, the line text is retrieved from the item name group. This can be used to your advantage if you want to write a subscription period etc. on the line. The advantage of this is that you only have to correct the text in one place. If the text is longer than the allotted space on the line - the system will split the text itself, as in the example below. Here is an example describing parameter %25 (Principle = Remaining) An optional text can be written in front of the %25 parameter. If the text is omitted, 'Paid' will be inserted by default when creating the invoice text. Here is the result of the above template. Note: The line with %25 is only printed if there has been a partial payment of the invoice. This means that there must be a difference between the amount in the 'Amount' column and the 'Remaining' column in the 'Payment proposal'. Footer parameters These are the parameters that can be used to print the bottom part of the text (footer). %30 = Net amount %30L = Net amount with line %31 = VAT amount %32 = Total amount %32L = Total amount with line Example: This example illustrates how the Footer text can be structured. All available parameters have been used. An 'L' has been specified, which will insert a line. The 'L' can be omitted, so you simply write %30 etc. A fixed text with relevant information for the debtor has also been inserted. Below is the template used on invoice number 230. The totals have been separated by lines, as 'L' is specified. You could possibly omit the VAT amount if the invoices are without VAT. Template (without invoice lines) This template is used for transactions not found in the invoice journal. Parameters Here is a description of the parameters that can be used in the structure of the text. %10 = Customer number (Uniconta Mandate-Id) %11 = Invoice number %12 = Invoice date %13 = Debtor name %14 = Debtor address %16 = Posting text (open posting) %32 = Total amount Show Invoice Text In the Payment proposal, you can see the result of the text by clicking the Invoice Text button Collective payments If several invoices are collected, the texts for each invoice will be added to the invoice file.