Skip to content

9.6 - Commission Payment to Excel


In this section you'll be guided on how to import data from Commission Payment report to an Excel file.

The Commission Payment reports are found in Commission Payment folder on the SFTP server.

Each file is named with the following naming scheme: Commission_Payment_Currency_YYYY_MM_DD.json

For example: Commssion_Payment_EUR_2024_03_26.json

Follow these steps to open the files in Excel

1 - Create a new blank workbook.

Screenshot

2 - Select Data on the top menu bar.

Screenshot

3 - Select Get Data => From File => From JSON

Screenshot

4 - Locate the CommissionPayment folder in the dialog window.

Screenshot

5 - Select the desired file and press the Import button.

Screenshot

6 - A new window opens.

Screenshot

7 - Select To Table Convert

Screenshot

8 - A small window appears, press the OK button.

Screenshot

9 - Press once on the small double arrow button.

Screenshot

10 - A small window with the column names appears. Press the OK button.

Screenshot

11 - All column names and values are displayed.

Screenshot

12 - Scroll to the right until Column1.Settlements and press once on the small double arrow button and then on Expand to New Rows. Notice that new rows are displayed.

Screenshot

Screenshot

13 - Press the small double arrow on Column1.Settlements again and a window with more column names appears. Press the OK button.

Screenshot

Screenshot

14 - Scroll again to the right until Column1.Settlements.Fees and press once on the small double arrow button and then on Expand to New Rows. More data will be displayed is the payment contains fees.

Screenshot

15 - Scroll again to the right until Column1.Settlements.Merchant.Settlements and press once on the small double arrow button and then on Expand to New Rows. Notice that values under this column have changed from List to Record

Screenshot

16 - Press once again on the small double arrow button and a window with more column names appears. Press the OK button.

Screenshot

Screenshot

17 - Scroll to the right and repeat the same process with these columns. That is, press the small double arrow button and then on the OK button.

  • Column1.Settlements.Merchant Settlements.Volume
  • Column1.Settlements.Merchant Settlements.Commission
  • Column1.Settlements.Merchant Settlements.TransactionCount

Screenshot

18 - The process will be completed when no more columns have the double arrow button.

19 - Press the Close & Load

Screenshot

20 - The data gets displayed in a normal Excel format.

Screenshot