After the data is imported, reconciliation starts automatically, and each transaction gets a reconciliation status. The reconciliation status represents the state of the transaction and helps you understand what action to take. Settlement reconciliation and Transaction reconciliation have different statuses.
Settlement reconciliation statuses
For reconciliation between settlement and bank data, each settlement is assigned one of the following statuses:
- Completely matched: Both “amount” and “settlement_id” matched with the Bank Statement
- Unmatched:“Settlement_id” not matched/found either in settlement data or Bank data
- Partially matched: “Settlement_id” matched/found in the Bank Statement but difference in “amount” beyond the threshold
You can configure the settlement reconciliation threshold when you compare settlement data to bank deposit data. If the difference in amounts is within the threshold, the settlement ID gets tagged as completely matched. If the difference in amounts is outside of the threshold, the settlement ID gets tagged as partially matched.
Here is an example of how the settlement reconciliation statuses are computed (in this example, the threshold is 1 USD):
|Settlement reconciliation status||Settlement ID (Stripe data)||Settlement ID (bank data)||Settlement amount expected (Stripe data)||Deposit amount (bank data)|
|Completely matched||ST-123||ST-123||1000 USD||1000 USD|
|Partially matched||ST-abc||ST-abc||1000 USD||900 USD|
Transaction reconciliation (between transaction data and settlement data) has four statuses:
- Settled: The record is present in both datasets and the amount is an exact match. In the case of pay-in reconciliation with three data sets, the settlement reconciliation status needs to be completely matched.
- In process: The record is present in both datasets but the difference in the amounts is beyond the set threshold.
- Open: The record is present in the transaction data but missing in the Stripe settlement data. A transaction can be open even if the settlement reconciliation for the corresponding
charge_id is unmatched.
- Foreign: The record is present in the Stripe settlement data but missing in transaction data.
Configure the transaction reconciliation threshold when comparing the amount expected (transaction data) and the amount processed (Stripe records). If the difference in amounts is within the threshold, the charge ID gets tagged as Settled. If the difference in amounts is outside of the threshold, the charge ID gets tagged as In process.
Here is the sample data showing how the transaction reconciliation statuses are computed (in this example, the threshold is 1 USD):
|Transaction reconciliation status||Charge ID (transaction data)||Charge ID (Stripe records)||Amount expected (transaction data)||Amount processed (Stripe records)|
|50 USD||50 USD|
|50 USD||45 USD|