Report fields - Released money - Mercado Pago Developers
Glossary
If you have any doubts about the technical terms used, check the glossary below.
Important
Some definitions are no longer available or have changed. Please use this glossary to check the terms for the reports you generate from October onwards. For reports that include previous dates,
please check this Glossary.
Name on the report column
What it means
DATE
Release, block or unlock date, as appropriate.
SOURCE_ID
Operation ID in Mercado Pago (for example, the payment of a sale).
EXTERNAL_REFERENCE
This information allows you to identify a transaction according to its origin. The code could be: - Order ID through the order or shipment (if it refers to a cart purchase). - Its own ID provided by the seller in case it is an external integration - ID provided by Coelsa, institution that processes transfers to other account
This field may be empty for some cases, such as invoice payments, money transfers, among others.
RECORD_TYPE
initial_available_balance → Money available from the previous period.
release → Money from a collection that was released.
total → Total Net Amount.
available_balance → balance before and after a withdrawal or transfer, which explains the account balance.
For available_balance: the field will display the prefix "pre" or "pos" to indicate the balance before or after a withdrawal or transfer, as appropriate, followed by the type of transaction, in this case, a transfer (payout) and, finally, the identification number of the transaction or ID Source.
Prefix + transaction name + transaction number.
Example: pre_payout_ID source
pre_payout_1948976543 pos_payout_1948976543
Definitions to consider:
chargeback: appears when a chargeback associated with the referred payment is initiated or resolved.
dispute: appears when a mediation or complaint on the referred payment is initiated or resolved. It can occur before or after the payment has been released as available money and even withdrawn from the account.
shipping_return: appears when a payment made by express return is blocked or unlocked.
payment: payment that is released in any of the channels in which the client operates.
refund: refund associated with the referred payment.
tax_payment_ibcf: perception of gross income in Federal Capital, it is calculated once a month according to the operations transacted. To reconcile by operation, see the detail in the Invoice Reports in MyML.
tax_payment_ibcf_cancel: cancellation of the gross income tax in Federal Capital.
tax_payment_ibex: collection of gross income per subject exceeded by a simplified regime, it is calculated once a month according to the transactions traded. To reconcile by operation, see the detail in the Invoice Reports in MyML.
tax_payment_iibb: collection of gross income in the province of Buenos Aires, it is calculated once a month according to the transactions transacted. To reconcile by operation, see the detail in the Invoice Reports in MyML.
tax_payment_iibb_cancel: cancellation of the gross income tax.
tax_payment_iibb_cre_[jurisdiction]: Gross Income Tax - Mercado Crédito, in which [jurisdiction] is replaced by the name of the province where the tax is generated. Example 1: tax_payment_iibb_cre_misiones Example 2: tax_payment_iibb_cre_san_luis To reconcile by operation, see the detail in the Invoice Reports in MyML.
tax_iibb_[jurisdiction]: Gross Income Tax, in which [jurisdiction] is replaced by the name of the province where the tax is generated. Example 1: tax_iibb_misiones Example 2: tax_iibb_san_luis To reconcile by operation, see the detail in the Invoice Reports in MyML.
tax_iva: VAT - General Regime.tax_iva_cre: VAT - General Regime - Mercado Crédito.
tax_credit_debit: tax on Credits and Debits in force in Argentina as of August 1st, 2021 for legal entities. This tax applies to all transactions with third parties, deposits and cash withdrawals.Learn more about this tax..
tax_withdholding_cancel: la cancelación de la retención tax_withdholding
tax_withdholding: the collection of withholdings that could not be transactionally executed to the associated payment. In Argentina they are only withholdings of Gross Revenue (perceptions are debited as another operation). In Uruguay they are VAT withholdings. In Colombia they are withholdings of VAT, ICA and Source as applicable.
tax_withdholding_cancel: the cancellation of the tax_withdholding retention.
tax_withholding_payer: tax on Credits and Debits on Payments.
tax_withholding_collector: tax on Credits and Debits on Payments.
tax_withholding_payout: tax on Credits and Debits on Withdrawals.
tax_withholding_shipping: tax on Credits and Debits on Money Transfers.
shipping: shipping commission for cart purchases that is not included in each cart payment.
shipping_cancel: cancellation of the shipping commission for cart purchases that is not included in each cart payment.
chargeback: chargeback either for or against an operation.
fee-release_in_advance: advance fee.
asset_management_gain: positive return generated by the variation in the value of shares subscribed in the mutual fund.
asset_management_loss: negative return generated by the variation in the value of shares subscribed in the mutual fund.
restriction: occurs when you apply a restriction for fraudulent behavior.
credit_payment: appears when the fee for a loan granted is charged.
payout: money withdrawal available at Mercado Pago.
reserve_for_embargo_invested: blocking of your invested money. This value appears when there is a reserve of money in investment funds.
reserve_for_bpp_shipping_return: reserve for returns.
reserve_for_debt_payment: withheld for debt payment.
reserve_for_refund: withheld for approved returns.
reserve_for_cbk_cross_recovery: withheld for linked account chargeback.
Description of the tax withheld by operation in TAXES_AMOUNT. You can consider the following values depending on the jurisdiction: cordoba corrientes mendoza la_pampa santa_fe tucuman entre_rios catamarca neuquen santiago_del_estero rio_negro jujuy
TAX_AMOUNT_TELCO
It is the value of the tax on telecommunications companies that is deducted from the gross value.
TRANSACTION_APPROVAL_DATE
Date of approval of the operation.
POS_ID
Cash ID if the payment is made through a physical commerce.
POS_NAME
Cash name for the payment made through a physical commerce.
EXTERNAL_POS_ID
User-defined cashier ID for payment made through a physical commerce.
STORE_ID
Branch ID if payment is made through a physical commerce.
STORE_NAME
Branch name for payment made through a physical commerce.
EXTERNAL_STORE_ID
User-defined branch ID for payment made through a physical commerce.
ORDER_ID
Purchase Order.
SHIPPING_ID
Shipping Identification.
SHIPMENT_MODE
Shipping Mode.
PACK_ID
Package identification in the cart.
TAXES_DISAGGREGATED
Taxes disaggregated in JSON format.
EFFECTIVE_COUPON_AMOUNT
Cost for offering discount.
POI_ID
Point ID if payment is made through a physical retailer.
CARD_INITIAL_NUMBER
It corresponds to the first digits of the credit or debit card that you used to make the purchase.
OPERATION_TAGS
These are labels to categorize and/or segment different aspects of the transaction, such as the channels used to make a payment. They are identified as: WHATSAPP_PAY: This label indicates that the payment was made via WhatsApp QR: This label indicates that the payment was made with a QR code PO: This label indicates that the payment was made with Point MARKETPLACE: This label indicates that the payment was made directly in Mercado Libre.
ITEM_ID
Identifier of the product sold.
PAYER_NAME*
Name of who is making a payment or donation.
PAYER_ID_TYPE*
Type of identification of who is making a payment or donation.
PAYER_ID_NUMBER*
Identification number of who is making a payment or donation.
BUSINESS_UNIT
Corresponds to the channel through which an order was generated. The channels are Mercado Pago, Mercado Libre, Mercado Shops and Delivery.
SUB_UNIT
Allows you to identify the method that was used to collect the payment of an order with Mercado Pago.
BALANCE_AMOUNT
This column shows the balance remaining in an account after a transaction that affects the total value is executed.
PAYOUT_BANK_ACCOUNT_NUMBER
The full account number to which the money was sent from Mercado Pago is shown here.
(*) This information can only be used for reconciliation purposes, will be treated according to the applicable
personal data protection laws and will be available when payments via QR code or transfers are received, as well as
when a donation is received by an NGO.