Reports reconciliation guide

• Reconciling payments received through PayPal with your order management system data.
• Reconciling with the day’s (or any specified period's) payment activity including sales, refunds, disputes, fees, withdrawals, etc., with the end of day PayPal balances.
• Understand payouts to your bank accounts
• Summary view of the total payment activity for the specified period aggregated by transaction category and payment methods.

PayPal balance report

Has 2 templates:

1. Balance summary report
2. Balance transactional report

• PayPal merchant portal web download
• SFTP

• Trace my payout in my bank statement.
• Reconcile my bank deposits with all contributing transactions.
• Track your bank reversal transactions and new payout transaction.
• Reconcile net settled fees.
• Reconcile gross settled fees.

Disbursement Reconciliation Report

• SFTP

• It provides a consolidated view of balances, payments, fees, taxes, chargebacks, and refunds in your account.

• Reconcile the total fees against the fees auto-debited monthly (applicable for merchants who opted for gross billing )

Monthly Statement

• PayPal merchant portal web download
• SFTP

• Understand the interchange, scheme, and PayPal fees billed monthly.
• Reconcile the total gross billed fees against the fees auto-debited monthly.

Fees report

(Monthly Report)

• PayPal merchant portal web download
• SFTP

Reconcile balances with payment activity

1. Closing available balance for each currency = opening available balance for each currency (including cryptocurrency) + sum of amounts under the Net Amount column for all transactions. Transactions are from the transaction details report for each currency.
2. Record the transaction activity in your accounting system by leveraging record type and record subtype
3. Closing balance of N -1 day = opening balance of Nth day
4. Payout or bank settlement amount on Nth day = closing balance of N -1 day or the opening balance of Nth day. Only applies if you are enabled for daily auto settlement to the bank.
5. This withdrawal to bank transaction appears in the N +1 day balance report.

Balance transactional report

Reconcile net billed fees

1. Net billed fees are when fees are applied at the time of the transaction and charged upfront to the seller.
2. All transactions for which fees are charged upfront, at the time of transaction, are available in the Balance Transactional report under the Total fees net billed column.
3. Total transactional fees charged to the user in a day = Sum of Net Fees column for each currency in Balance report for all transactions + Sum of Net Amount for the category Record Type = Fees

Alternatively, users can generate an on-demand Balance summary report for a date range according to their choice to get the total fees charged to them daily, weekly, monthly etc.

Total Fees net billed to user =   Sum of Net Fees column for each currency in Balance Summary report for all transactions  + Sum of Net Amount for the category Record Type = Fees

Balance summary report

Reconcile gross billed fees at the transaction level

Gross billed fees are fees billed periodically. Net billed fees are billed at the transaction event.

To identify the total IC++ fees for a specific merchant account:

1. Select all records with the same "Merchant Account ID"
2. Iterate through the records and consume the following columns at the minimum:
• Record Type – Type of transaction accruing the fees
• Total interchange Fees
• Total scheme Fees
• PayPal fees
3. The sum of amounts in the "Total fees gross billed" column gives you total fees. This includes PayPal markup and IC++ fees that are gross billed to the user.

There can be some monthly scheme fees charged to the merchant. These fees are not attributed to any individual transaction. These fees are not present in the fees report. Merchants can leverage the monthly statement to get the total monthly scheme fee components.

Fees report

Reconcile Total Gross Billed Fees

Total fees in the invoice currency field, below the fee summary section for each currency, gives you the total fees billed to you and auto debited from your bank account.

This includes the monthly scheme fees, if any, that are charged to the merchant.

Monthly statement