SFTP- Email Reports

How do I set up a report?

To configure your own report, you must follow these steps:

1. Log in to the Localpayment dashboard with with a user with permission on this section.
2. Select the Configurations module.
3. Select the Clients section.
4. Click on the Edit option.
5. In the header menu, select Notifications.

📘

Info

If the option does not appear, click on the ellipsis to get more options.

6. Select Reports from the Notifications menu.
7. Choose the type of report you want to configure:
   1. Email
   2. FTP
8. Click the Add button.
9. Select the Report Name from the following options:
   1. Balance Report : Shows the balance after each transaction, along with the payment method, status, and payment details (amount, FX quote, taxes, etc.) for all completed transactions.
   2. Fides Report : Indicates the available balance once the transaction is completed; the transactions are grouped according to their origin (debit/credit).
   3. Details Report : This report contains all the details about a transaction, including the payers and beneficiaries.
   4. Activity Report : Provides all the details on every kind of transaction, including its status.
   5. Global Consolidation Report: Shows the balance after each transaction, along with the payment method, status, and payment details (amount, FX quote, taxes, etc.) for all completed transactions of a global account.
10. Select the Country field, and all available countries will appear.

📘

Info

• For the Detail Report and Activity Report, you can select all or just one country.
• The only choice for the Global Consolidation Report is Global.

11. Select an Account Number. This field lists all of your Localpayment accounts for the selected country. If you choose All in the Country field, you must also pick All in the Account Number.
12. Choose the Frequency at which you wish to receive the report from the options below:
    1. Daily: the report will be sent every day at 2 a.m. GMT. It will contain the transactions made the previous day until 00:00 GMT.
    2. Weekly: the report will be sent every Monday at 3 a.m GMT. It will contain all transactions made between the previous Monday and the following Sunday until 00:00 GMT.
    3. Monthly: the report will be sent every first day of the month at 4 a.m GMT. It will contain all transactions made between the first day and the last day of the month until 00:00 GMT.
13. Select the File Type of the report from the following options:
    1. XLS
    2. CSV
14. Configure the File Name; there are two options:
    1. In the switch, select Free String, and in File Name write the name you want to give the report.
    2. In the switch, select With Tags and choose the Separator and Tags to create the file name.
15. Depending on the type of report you are creating, the following steps may vary:
    1. Email: In the To Email field, write the email address to which you want to receive the report.
    2. FTP: Fill the Url, User, Pass, Port, and **Path **fields with the necessary information of the SFTP Server.

📘

Info

If necessary, you can upload a private key file instead of writing a password.

16. Click the Confirm button to create your report.