Reconciling transactions between the two systems can be challenging without a unique identifier. So which unique identifier can clients refer to match transactions and subscriptions between Piano and Stripe reports?
Piano provides an External Transaction ID in the transaction log which is the payment intent id in Stripe, it can be used as a reference across all transaction operations, example format: pi_3MgEiMGcAAGAcv130bshv2Ak
This satisfies the use case of being able to find and identify transaction operations between the systems.
For the use case of reconciling with other reports from Stripe such as balance_history export or unified_payments export, Piano is passing additional metadata for this purpose as subscriptionId (metadata), example format: RW70MKQ44IHP
This is a unique identifier across Transaction and Subscription logs which contain a Subscription ID and it is also available in Stripe balance_history and unified_payments exports for any reconciliation mapping.