Partner Reports reconciliation guide

DOCSBeta

Last updated: Aug 15th, 6:14am

Reconciliation reports help finance and accounting teams to meet their end-to-end reconciliation requirements.

REVENUE BOOKING - BALANCE REPORT

Use caseHow to Reconcile
Book all revenue Report Summary section – provides the details of opening and closing balances for each currency To record the revenue records in your Accounting ledgers,
Iterate through all records in the Report Details section:
  • Record Type and sub-type indicate the revenue component (Partner Fee / Other revenue etc..).
  • Original Record type and Original record sub-type indicate the actual transaction against which this revenue is accrued (ex. Sale / Refund etc..).
  • Original Record ID indicates the ID of the Original transaction against which this fees is accrued
  • Records associated with Withdrawals to bank can be recorded accordingly
  • Net amount indicates the net revenue accrued per record
Few additional observations from the Reporting data:
  • Total revenue per currency maps to:
    • Sum of Net Amount column in Report details for each currency
    • Closing Available Balance in Report summary for each currency
  • Closing Available Balance for each currency = Opening Available Balance for each currency + Sum of amounts under Net Amount column, for all transactions in Transaction Details report for each currency
  • Closing Balance of N -1 day = Opening Balance of Nth day

BANK DEPOSIT RECON - DISBURSEMENT REPORT

Use caseHow to Reconcile
Reconcile my Bank Deposits Consume the records in the Report Summary (RS) section to identify all the bank disbursements - along with the Net disbursed amount and the corresponding Transfer ID
  • For each Transfer ID, iterate through the Report Details (RD) section to identify all transactions that contributed to the Disbursement and mark them as Settled/Disbursed
  • Total of Net amount for each Transfer ID should match with the Net disbursed amount in the Summary section

COST BOOKING - FEE REPORT

Use caseHow to Reconcile
Reconcile my costs
Reconcile Gross Billed Fees applicable at transaction level		Note: Gross billed fees is the fees billed periodically, as opposed to the net billed fees which is billed at the time of the transaction event itself.
To record the fees in your accounting books, iterate through each of the records in the Record Details section and consume the below columns:
  • Record type and sub-type indicates the type of fee accrued.
  • Original record type and sub-type indicates the actual transaction against which this fee is accrued.
  • Different fee components:
    • Total pass-through fees
    • Total Interchange Fees
    • Total Scheme Fees
    • PayPal Fees
    • Total fees gross billed : includes total fees across the different fee components
    • Total fees gross billed in invoice currency : indicates total fees in invoice currency
    • Gross billed month
Reconcile Total Gross Billed FeesTo identify the total fees for the month, iterate through all records with the corresponding Gross billed month
  • Sum of amounts in Total fees gross billed column would give you the Total Fees that's going to be gross billed to the user in Transaction currency.
  • Sum of amounts in Total fees gross billed in invoice currency field gives you the total Fees that would be billed to you.
ReferencePayPal.comPrivacyCookiesSupportLegalContact

If you accept cookies, we’ll use them to improve and customize your experience and enable our partners to show you personalized PayPal ads when you visit other sites. Manage cookies and learn more