How to generate your Available Balance report?
Generating channels
There are three ways to generate an Available Balance report:
Channels | Description |
Mercado Pago panel | It's very simple and fast. To generate it from your Mercado Pago account, go to your reports and choose the Reports option. Follow the step by step to generate reports from this panel. |
API integration | This integration can only be used to consult and download the reports manual and does not allow generating new reports. |
Con el retiro de dinero | Generate a report automatically each time you withdraw your available balance to a bank account. Follow the step by step to generate reports for each withdrawal. |
Technical characteristics of the report
Consider the following technical information when you want to generate, schedule and set up your reports.
Report Schedule
Set up how and how often you want to generate your reports.
Element | Characteristics |
Schedule | - Daily. - Weekly. - Monthly. |
Generation | - Manual. - Automatic for withdrawal of available balance, total or partial. These generation instances can live together. That is, even if you schedule the generation of your reports automatically, each time you withdraw money an additional report will be generated. |
Report Structure
Know the characteristics of the elements that make up your report.
Element or Action | Characteristics |
Tables Detail | The detail of the tables includes information generated in at least 1 day. Except in the reports generated by money withdrawal. |
Column Order | Permanent. |
Maximum Period | Reports with data of up to 60 days. |
Currency | Local (based on the country where the Mercado Pago account is registered). |
Time zone of the columns | GMT-4 Take as reference the place where you download the report from. |
Date selection via API | Timezone format: UTC / GMT-0. |
Date selection via web | DIt must be based on the timezone of the user's account. For example, the timezone of Sao Paulo corresponds to the user account registered in Brazil. |
Report Export
All the options you have available when downloading your report.
Element or Action | Characteristics |
Filename format | When the report is scheduled or manual: "<configurable-prefix>-<yyyy-MM-dd-hhmmss>.<format>" Example: mystore-2019-05-28-104010.csv When the report is generated by a money withdrawal: "configurable-prefix-withdrawal-id-creation-date.csv" Example: mystore-ID23902138-28-05-2019.csv |
Download formats | .csv, .xlsx Tip: Download the report in .csv to import the data and use it in other applications. Download it in .xlsx to read the information in the spreadsheet tables. |
File | The generated reports are saved in your Mercado Pago account. |
Set up available via API | - Columns to generate per report - File prefix for easy identification - SFTP upload - Column separator (period or semicolon) - Decimal separator (comma or period) - Email notification - Withdrawal at the end of the report (optional) |