Import Pay.nl mutations

Connecting Pay.nl to Nmbrs Accounting 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, Nmbrs Accounting 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 Nmbrs Accounting.

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 Nmbrs Accounting. Only this format can be automatically imported and processed by Nmbrs Accounting as a bank transaction.

Upload Pay.nl file to Nmbrs Accounting

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

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

The electronic file will be automatically processed in your administration.

Nmbrs Accounting 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 Nmbrs Accounting, see article Upload files from PO Box.