Partner Reports reconciliation guide

DocsBetaLast updated: April 12th 2024, @ 2:50:55 am

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

REVENUE BOOKING - BALANCE REPORT

Use case	How 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

Use case

How 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 case	How 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

Use case

How 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