Import Pay.nl mutations

Connecting Pay.nl to Yuki is an efficient way to largely automate your administration. With this integration, sales invoices, payments, and transaction fees are automatically posted to the correct locations in your bookkeeping system.

Below are the two steps you need to follow to import Pay.nl transactions:

• create the Pay.nl account
• import the Pay.nl files (transactions).

Step 1. Create Pay.nl account

Before you can upload files, Yuki needs to know that a Pay.nl account exists.

To create a Pay.nl account:

• click on the Bank icon in the navigation bar
• click on Bank accounts.
• click on the Create new online payment provider button.
  
  
  
• select the online payment provider Pay.nl.
  
  
  
• in the now-opened screen, enter the details of your Pay.nl account:
  • Administration: select the correct administration (if there are multiple administrations)
  • Payment provider account (required): enter your Pay.nl account number here
  • Description (required): enter a descriptive text to be shown on the overview of all accounts
  • Opening balance: you may leave this field blank.  
    
    
    
• then click on the Save button.

The Pay.nl account is now created in your administration.

Step 2. Generate and upload Pay.nl files (per payment)

To actually process the transactions, you must retrieve the correct files from the Pay.nl environment and upload them to Yuki.

Generate files

To generate the files containing transaction data (per payment):

• log in to your Pay.nl environment to generate the files for each payment (clearing)
• set the frequency (daily, weekly, or monthly) at which Pay.nl deposits payments into your bank account
• go to the overviews (where revenue is grouped by week number or calendar month) and generate the statements for each payment (clearing).

Select correct file type 

For each payment, Pay.nl generates three different files: PDF, CSV, and MT940.

You must specifically download the MT940 files and upload them to Yuki. Only this format can be automatically imported and processed by Yuki as a bank transaction.

Upload Pay.nl file to Yuki

We recommend that you do not open or edit the file. This ensures that the file structure remains intact and allows Yuki to process the file correctly.

You can then upload the downloaded file to Yuki via the PO Box or send it as an attachment by email to <yourdomainname>@yukiworks.nl.

The electronic file will be automatically processed in your administration.

Yuki automatically breaks down the payments: sales invoices are reconciled, the payment is linked to your regular bank statement, and Pay.nl’s service fees are posted directly to the expense account.

For a detailed description of uploading files in Yuki, see article Upload files from PO Box.