Reconciling Checkout API payments with daily payouts

Get your Checkout ID

When creating a checkout using the Checkout API, ensure to retain the checkout ID provided in the response. You will need this ID for reconciling transactions with your daily payouts.

Access the export feature

Log in to the Yoco App and navigate to Payouts History.

Choose the payout to reconcile

Select the specific payout you want to reconcile by clicking on it. You will be directed to the payout details page.

Export payment records

• On the top right of the payout details page, you will find an Export arrow button. Click on it to initiate the export process.
• The system will generate a CSV file containing the payment records associated with the selected payout.

Match payment records

• Once the download is complete, open the CSV file.
• In the exported file, you will see various columns containing payment information, including the Online Reference column.
• The Online Reference column contains unique IDs for each payment. For example, ch_ngopqZ91r65hl8Osp2IPDrxB.
• Use this ID to cross-reference and match successful transactions.

Reconciliation

• The downloaded CSV file contains all successful transactions that have been either paid out or subtracted for refunds in the selected payout period.
• For each transaction in the CSV file, check if the Online Reference matches the Checkout ID provided in your API response data.
• If there is a match, mark the transaction as successfully reconciled.
• Any transactions in your API logs that don’t appear in the CSV file may still be processing or may have failed.