Generate report - Account balance - Mercado Pago Developers
What are you looking for?

Do not know how to start integrating? 

Check the first steps

Generate report

You can generate your Account balance report through your Mercado Pago account or via API integration. Refer to the table below for more information.

Easily keep track of your sales made with a QR Code
We have created new columns that allow you to identify which digital wallets or banks your clients use when they pay with a Mercado Pago QR Code. Update your settings preferences from the panel or via API so that you can include these columns in your reports.

Generation channels

There are two ways to generate an Available Balance report:

ChannelsDescription
Mercado Pago panelManually create the report through the Mercado Pago panel. Access your reports , click Go to Payment and account statement reports, and select the report. For more information, read the documentation Generate report through the panel.
API integrationCreate the report manually or scheduled according to the desired frequency using our API integration. For more information, refer to the documentation Generate report via API.

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.

ElementCharacteristics
Schedule
- Daily
- Weekly
- Monthly

Generation
- Manual
- Automatic

Report structure

Know the characteristics of the elements that make up your report.

Element or ActionCharacteristics
Tables Detail
The detail of the tables includes information generated in at least 1 day.

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
It must be based on the timezone of the user's account.
For example, the timezone of São Paulo corresponds to the user account registered in Brazil.

Report export

All the options you have available when downloading your report.

Element or ActionCharacteristics
Filename format
When the report is scheduled or manual:
"<prefix-configurable>-<yyyy-MM-dd-hhmmss>.<format>"
Example: mystore-2019-05-28-104010.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).
- Email notification.

Notifications

Webhook

Webhook (also known as "web callback") is a simple method that allows an application or system to send real-time data whenever a particular event takes place, that is, it is a way to passively receive information between two systems via an HTTP POST. In the case of the reports used for reconciliation, a notification is sent to the user who has set up this service when their files are generated.

AttributeDescription
transaction_idTransaction ID
request_dateRequest date
generation_dateGeneration date
filesAvailable files
typeFile format
urlDownload link
nameFile name
statusReport status
creation_typeManual or scheduled creation
report_typeReport type
is_testDetermines if it is a test
signatureNotification signature

Password for encryption

The encryption password is essential to secure the notification process to the system. In the message body (payload), an attribute called "signature" is sent to validate the legitimate origin of the Mercado Pago Webhook notification, avoiding possible imitations.

The creation of the signature occurs by combining the transaction_id with the encrypted password in the "Webhook Notification" section, along with the generation_date of the report. These values are then encrypted using the BCrypt algorithm as follows:

signature = BCrypt(transaction_id + '-' + password_for_encryption + '-' + generation_date)

To validate that it is Mercado Pago who issued the notification, the verification function offered by the BCrypt algorithm for the desired language must be used.

Java example:

BCrypt.checkpw(transaction_id + '-' + password_for_encryption + '-' + generation_date, payload_signature)

Have the Glossary of the report on hand to review it when needed or want to review a technical term.