Payment reconciliation
How to view, filter, and export your payment records fro PayMongo
Overview
Every transaction processed through your PayMongo account is recorded in the Payments tab of your dashboard. Each payment entry shows the transaction amount, customer details, payment method used, and current status.
Each payment has a unique ID that looks like pay_LgStXCp9cVJn549SDFMXyoyY. Use this ID to look up a specific transaction, match it to an order in your system, or reference it when contacting PayMongo support.
Use webhooks for real-time updates
The dashboard is useful for manual review and exports, but webhooks are the source of truth for your application. When a payment is paid or fails, PayMongo sends a payment.paid or payment.failed event to your registered endpoint — this is the right place to update order status, trigger fulfillment, or send confirmation emails.
Don't rely on polling the API or waiting for a customer redirect to confirm payment. A customer may close their browser before returning to your return_url, but the webhook will still fire.
Retrieve payments via API
For programmatic reconciliation, use the List Payments endpoint to fetch payment records with pagination.
const payments = await fetch('https://api.paymongo.com/v1/payments?limit=10', {
headers: {
'Authorization': 'Basic ' + btoa('sk_test_YOUR_SECRET_KEY:')
}
}).then(r => r.json());To page through all payments in a date range, use the id of the last record in each response as the after cursor for the next request.
View your payment records
Go to Payments in your PayMongo dashboard. The table shows all transactions on your account, including:
- Payment ID
- Amount and currency
- Payment method used
- Customer name and contact details
- Date and time
- Status (
paid,failed,refunded)
Click any row to expand the full details for that transaction.
Export payments to CSV
To export your payment records:
- Go to Payments in the dashboard
- Click Export Payments
- Select the date range you want to include
- Download the CSV file
The exported file contains all fields shown in the table, suitable for importing into accounting software or reconciling against your own order records.
Match payments to your orders
Use the payment ID (pay_xxx) or the description field you set on the Payment Intent to match dashboard records back to orders in your system. Setting a meaningful description (such as your internal order number) when creating a Payment Intent makes reconciliation straightforward.
The description value appears in the dashboard and in webhook payloads, making it easy to trace a payment back to the originating order.
Updated 2 days ago