Brazil Transaction-Level Fee Report

Document Version 1.0

Changelog

Report Definition

The Transaction-Level Fee report provides detailed information about your transactions and the fees associated with them. The details provided in the report depend on whether you have an IC+ pricing model, or a flat rate or blended model. Contact us if you're unsure of your pricing model. Payment methods supported by the Transaction-Level Fee report:

• Credit and Debit Cards
• Venmo Accounts
• Apple Pay
• Google Pay

In Brazil, the report will also contain:

• Installments
• Funds Anticipation Fees

For more information about running this report, visit our Transaction-Level Fee report page.

Installments

In Brazil, merchants can offer customers the ability to pay for transactions in installments. This is supported for Visa and Mastercard credit cards, and PayPal Wallet transactions. Learn more about the installments capability.

Installments will be assessed fees individually for the below fee types:

• Discount Fees
• Pre-defined Funds Anticipation Fees

Reconciling Fees for Installment Disbursements

To reconcile the fees for installments that have been disbursed to your bank account, follow the below steps:

1. Locate records where Record Type = Installment and Record Subtype = Disbursements.
2. With the installment disbursement records selected, iterate through the installments using the Transaction ID field to locate the ID of the installment.
3. For each installment record, you will use the following columns to gain insight into the fees netted from the disbursed installment:
   • Discount – The rate of the charged charged by PayPal for the installment
   • Per Transaction Fee – The fee charged for each transaction for the installment
   • Funds Anticipation Rate – If Pre-defined Funds Anticipation was used to accelerate the funding of the installment, the Funds Anticipation fee rate will be populated in this column.
   • Braintree Total Amount – This is the total discount fee, which equals: (Discount X Settlement Amount) + Per Transaction Fee
   • Total Fee Amount – This will be the total fee amount that was charged for the installment. It will be the Braintree Total Amount + (Funds Anticipation Rate X Settlement Amount)

Reconciling Fees for Installment Adjustments

When a transaction with installments is refunded, the discount fees for each installment may also be refunded. This is dependent on your pricing agreement with PayPal. Only fully refunded transactions with installments will have refunded fees associated with it.

If a transaction with installments is refunded, the refund amount is equally divided over the number of installments. The refunds are shown in reporting as: Record Type = Installment and Record Subtype = Adjustment.

Follow the below methodology to reconcile fees associated with installment adjustments caused by refunds:

1. Locate records where Record Type = Installment and Record Subtype = Adjustment.
2. With the installment disbursement records selected, iterate through the installments using the Transaction ID field to locate the ID of the installment.
3. For each installment record, you will use the following columns to gain insight into the fee credits associated with the installment adjustment:
   • Discount Credit – The rate of the PayPal fee charged for the installment
   • Per Transaction Fee Credit – The portion of the per transaction fee charged to the installment
   • Funds Anticipation Rate Credit – If pre or post defined fund anticipation was used to accelerate the funding of the installment, the Funds Anticipation fee rate will be populated here.
   • Braintree Total Amount – This is the total discount fee, which equals: (Discount Credit X Original Sale Amount) + Per Transaction Fee Credit
   • Total Fee Amount – This will be the total fee amount that was charged for the installment. It will be: Discount Fee + Per Transaction Fee + Funds Anticipation Fee (which equals: Original Sale Amount X Funds Anticipation Fee Credit)

For both installment disbursement and adjustments that appear in the Transaction Level Fee Report, the Total Fee Amount for the installment should be equal to the Net Settlement Fees for the same line item in the Disbursement Report.

Funds Anticipation

In Brazil, credit card transactions take 30 days to disburse by default. Merchants can opt to pay a certain rate-based fee to have their credit card transactions paid out sooner than 30 days. This feature is called Funds Anticipation.

Braintree and PayPal support Pre-defined Funds Anticipation that allows merchants to have all credit card transactions be paid out earlier than 30 days at an agreed upon schedule and Funds Anticipation rate (e.g. all credit card transactions will be paid out in 15 days as opposed to 30, and each transaction will be assessed an additional rate-based Fund Anticipation fee).

These fees will apply to standard credit card transactions and transactions with installments.

To see the rate applied to a sale or refund, with or without installments, look to the Funds Anticipation Rate and Funds Anticipation Rate Credit column to obtain the rate assessed to the transaction. Multiply the transaction or installment amount to obtain the fee that will be assessed for Funds Anticipation.

Record types and subtypes

Payment instrument types and subtypes

Changelog