Could several payments relate to one order?¶

Yes. One order can generate several payment records.

Avoid this assumption: Multiple transaction entries always represent separate purchases.

A customer may split payment across cards, wallets, gift cards, account balance or bank transfer.

An initial payment may fail or be declined before a later attempt succeeds.

A merchant may take a deposit first and the balance later, or charge items as they are dispatched.

An order may also produce authorisations, final charges, partial refunds and adjustments that appear as separate records.

Preserve the order ID and every linked payment, authorisation, reversal, refund and transaction reference.

Ask the merchant to provide the payment timeline and explain which entries were successful, replaced, cancelled or returned.

Do not add every visible amount together without checking the status. A declined or reversed entry may not represent additional loss.

Likewise, a pending authorisation and final charge may relate to the same underlying amount.

Compare merchant, processor, issuer and bank records because each may display the sequence differently.

Several payments can also involve different people or funding sources. One person may place the order while another provides part of the payment.

Where the order was changed, the merchant may create new payment records rather than editing the original one.

When reporting, distinguish payment attempts from successful value transfer and identify which records belong to the same order.

Operational takeaway¶

Use the order ID and merchant reconciliation records to group related payment attempts, charges and refunds before calculating loss or attributing separate purchases.