Payment Time

Overview

The Swedish Payment Time report or Rapportering av betalningstider is a statutory requirement for large companies (more than 249 employees) to report payments to subcontractors. It aims to monitor how small businesses are paid by suppliers so the Swedish government can determine special lending programs and other benefits for small companies with cashflow issues caused by long payment terms. The report is submitted to the Swedish Companies Registration Office (SCRO) and includes the following information:

Average agreed payment term
Average actual payment term
Percentage of invoices paid after the agreed payment term

Additionally, Maconomy provides three separate reports according to the number of employees under subtractors, as follows:

Payment terms for companies with 0 - 9 employees
Payment terms for companies with 10 - 49 employees
Payment terms for companies with 50 - 249 employees

Note: As of publication date, the Swedish Payment Report generated by Maconomy excludes Reverse Factoring Agreement (RFA). Customers utilizing RFA to finance accounts payables (AP) must manually report them.

Report Workspace

Navigation

To open the report workspace, select Reporting » Country Reports » Sweden » Payment Time.

Or, go to Reporting » BI Launch Pad and click Open BI Launch Pad. The report is located on the Business Performance Management » Reporting » Sweden folder.

Selection Criteria

Field	Description	Mandatory
Currency Type	Use this drop-down to indicate which currency type (Base, Account or Enterprise) amounts are displayed in.	No
Include Inactive Vendors	Select this checkbox to include inactive vendors in the list.	Yes
Include Non-Swedish Companies	Select this checkbox to include all non-Swedish companies for a Swedish vendor	Yes
From Date	Use this field to filter off payments (or reconciliations). Only payment entries having an Invoice Date equal to or after this date are included.	Yes
To Date	Use this field to filter off payments (or reconciliations) . Only payment entries having an Invoice Date equal to or before this date are included.	Yes
Vendor No.	Use this field to search for or enter a vendor number as needed. Multiple valued.	No
Vendor Group	Use this drop-down to restrict to specific vendor groups. Multiple valued.	No
Transaction Type	Use this text field to enter a value or text related to the type of transaction. Multiple valued.	No
Country	Use this drop-down to include only vendors from the specified countries. Multiple valued.	No
Currency	Use this drop-down to indicate the currency used in the report.	No
Segment	This field restricts to a specific vendor segment. Multiple valued.	No
Area	This field restricts to a specific vendor area.	No

Dimensions

Field	Description
Project Name	Use this field to search for or enter a project name to filter by.	No
Company No.	Use this field to search for or enter a company number.	No
Transaction No.	Use this text field to enter a transaction number.	No
Location Name	Use this field to search for or enter a location to filter by.	No
Entity Name	Use this field to search for or enter an entity to filter by.	No
Purpose Name	Use this field to search for or enter a purpose name to filter by.	No
Spec. 1 - 10	Use these fields to enter other specs as needed.	No
Local Spec. 1 - 10	Use these fields to enter other local specs as needed.	No

Generate the Report

Export the Report

To generate the report:

Go to Reporting » Country Reports » Sweden » Payment Time.
Enter the selection criteria for running the report.
Click Run. The screen refreshes and displays the generated report.
To keep a copy, click the Download icon. In the dialog box, specify the parameters for the export file (file type, reports and options), then click Export.

Submit the Report

Not applicable for this report.

Report Description

Universes

The data export is based on the following universe:

Vendor Payment Universe

Export Fields and Descriptions

This report displays vendor invoices paid within the payment period, as well as overdue ones. It consists of four tabs displaying the payment times data table for each of the following employee headcount group, and a Summary tab:

0-9 Employees
10-49 Employees
50-249 Employees
Summary

The information above the data table includes the following:

Field	Description
From Date	Only payments (reconciliations) with a reconciliation date equal to or after this date are included. If the reconciliation date is blank, the payment is also counted.
To Date	Only payments (reconciliations) with a reconciliation date equal to or before this date, are included. If the reconciliation date is blank, the payment is also counted.
Currency Type	The specified currency type.
Incl. Inactive Vendors	Shows Yes if inactive vendors are included, otherwise this is No.
Incl. Non-Swedish Companies	Shows Yes if non-Swedish companies are included, otherwise this is No.
Currency	Displays the specified currency.
Company	The company number and company name.
Vendor	The vendor number and company name.

The data table includes the following:

Main Header	Subheader	Description
Tax	No.	Vendor tax number.
Invoice	No.	Invoice number of the payment invoice.
Transaction No.		Transaction number of the vendor entry.
Journal No.		Journal number of the specific invoice number.
Entry	Text	Entry text of the vendor payment.
Dates	Invoice	Invoice date of the specific invoice number.
Entry		Entry date of the specific invoice number.
Payment	Date	Date of payment for the specific invoice number. This date is the reconciliation date (or when payment is matched with a corresponding invoice). Note: Maconomy considers an invoice paid only when it is fully closed so that it uses the reconciliation date as the Payment Date for a vendor invoice.
Due		Due date of the specific invoice number.
Vendor	Invoice Type	Shows whether it is vendor invoice, vendor credit memo or credit general journal.
Invoiced		Amount declared for the specific invoice number.
Overdue Payment	Paid	Total amount paid as of specified To Date for the specific invoice number.
Overdue Payment	Unpaid	Total amount still to be paid as of specified To Date for the specific invoice number.
Open/Closed		Shows whether the invoice has been paid (Closed) or not (Open).
Total No. of Invoices		Shows the number of invoice rows for the vendor.
Average Agreed Payment Period		Sum of days between the invoice date and the due date of invoices divided by the Total No. of Invoices.
Average Actual Payment Period		Sum of days between the invoice date and the payment date divided by the Total No. of Invoices. Note: This excludes entries without payment dates.
Late Payment Rate		Percentage of invoices paid past the due date. Note: Unpaid vendor invoices past due dates are considered as paid late invoice.
Total		Balances as of specified To Date: Invoiced - Total amount of all invoices. Paid - Total amount already paid. Unpaid - Total unpaid amount.

The summary includes the following data in semicolon delimited format:

Field	Description
IDENTITETSBETECKNING	Identification number of the vendor company or organization. This can also be the personal ID number or coordination number of the owner, or the company registration number.
NAMN	The vendor company registered name.
STORLEKSKLASS_SME_KOD	Codes for the vendor company sizes.
STORLEKSKLASS_SME_KLARTEXT	Plain text for the codes in STORLEKSKLASS_SME_KOD.

For example:

IDENTITETSBETECKNING;NAMN;STORLEKSKLASS_SME_KOD;STORLEKSKLASS_SME_KLARTEXT
00000001;Sweden;S0_9;Företag som har 0 - 9 anställda
00000001;Sweden;S10_49;Företag som har 10 - 49 anställda
00000001;Sweden;S50_249;Företag som har 50 - 249 anställda

Limitations

No Reverse Factoring Agreement (RFA)

This report requires you to set up supplements for vendor entries. Vendor entries not associated on a job (for example, direct transactions between vendor and company) may not provide accurate reverse factoring information (for example, payment due date agreement). As a result, the Reporting of Payment Time report generated by Maconomy does not include Reverse Factoring Agreement (RFA).

Payment Date Field

Maconomy considers an invoice paid only when it is fully closed so that it uses the reconciliation date as the Payment Date for a vendor invoice. If you reconcile payments to invoices at a later date, the report may show late payments. This results to inaccurate data, such as Late Payment Rate or Average Actual Payment Period, which are relevant components of the report.

Admin Setup

Maconomy Setup

Note: You must have System Administrator rights to configure some of these settings, such as the Reference Workspaces.

Map Company Vendor Information Fields to Supplements

The report filters vendor entries into corresponding report tabs (0-9 Employees, 10-49 Employees and 50-249 Employees). You must set up supplement types to identify the number of employees in the company and configure this supplement for each vendor company.

To create a Supplement Type:

Go to Reference Workspaces » Set-Up » Note » Supplement Types.
Select New Supplement Type.
In the Name field, provide a name for the supplement. For example, BPM [Country] Company.
(Optional) Provide a description for the supplement type.
In the Area field, select Company Vendor BPM.
Go to the Integers card. provide a value in the No. of Employees field.
(Optional) Provide values for other free text fields.
Click Save.

To create a Supplement:

Go to Reference Workspaces » Set-Up » Note » Supplements.
Select New Supplement.
In the Supplement Type field, select the supplement type for the company (for example, BPM [Country] Company created in the previous section).
In the Name field, provide a name for the supplement.
Click Save.
Enter company data in the corresponding field(s) under the Integers card.
Click Save.

To use a Supplement:

Go to Accounts Payable » Company Vendors.
Search for and double-click the vendor company you want to configure.
Select the Setup tab.
In the Supplement field, select the supplement created for the company.
Click Save.

Email Notification Setup

Configure Maconomy to send an email notification when it successfully generates a data export or encounters an error while running the report. The email specifies the report name, other information such as the report's format (if any), as well as the date and time the export is created. The alert is sent to the email address associated with the user who initiates the report. For reports with errors, the message points to the maconomy.log file for details.

To set up the email server and sender:

Open the Extension.ini file. It is located in the <Path to Maconomy installation>\CouplingService\Configuration\Settings folder.
Configure the email server and sender:
- Locate mailserver.address and change the value to smtp.deltek.com:25.
  Note: The email server can also be set via the Web Client. Go to Setup » System Setup » System Parameters » Mail Port and Server workspace and use the Server and Mail Port parameters.
- Locate email.from.default and provide an email address for the From field of the email.
Save the file.
Restart the Coupling Service to apply the changes.

External Setup