Reconciliation

Use Cashfree Easy Split reconciliation reports to match marketplace orders to vendor settlements, commissions, refunds, and bank credits at line-item level.

The vendor reconciliation report lists all the transactions, adjustments, settlements and refunds that are associated with vendors. This will help you reconcile all transactions from your vendors with their respective settlement ID, time, and UTR.

To view the vendor settlement recon report,

1. Go to Payment Gateway Dashboard > Reports.
2. In the Report Type field, select Vendor Recon and click Generate Report.
3. Select the vendor recon report type, date range, file format, and provide the file name. Click Generate Report.

If you have already generated the report, you will get a pop-up stating to download the report. You can download the report by clicking the ellipsis button.

Sample report is available here.

Column name	Description	Example
entity_id	Unique ID of that particular event type.	1046658935
type	The type of that event.	transaction
merchantVendorId	The vendor ID that is added by the merchant	john213
debit	The amount that was debited.	ArunTestES2
credit	The amount that was credited.	2.0
amount	The total transaction amount.	2.0
currency	The currency used for that particular transaction.	INR
fee	PG service charges.	1.00
tax	PG service taxes.	0.18
settled	Indication of whether the vendor amount is settled or not.	true
txTime	The time of that particular transaction.	2022-06-28 14:50:58
settlementTime	The time at which Cashfree received a credit confirmation from the vendor’s bank.	2022-06-28 14:50:58
addedOnTime	The time at which Cashfree initiated the settlement for that particular vendor.	2022-06-28 14:50:58
settlement_eligibility_time	The date timestamp that denotes when the transaction will be eligible for settlement.	2022-06-28 14:50:58
settlement_id	Unique ID generated by cashfree for that particular settlement.	1213178
merchant_order_id	Unique ID passed to Cashfree by merchant when the order is created.	tutnvgetyfye123
cf_order_id	A unique ID generated for each order.	2359676476
settlement_utr	A unique transaction reference number. A number that is generated by your bank that will help in identifying credit in the merchant bank statement.	218038200406
refund_arn	Acquirer Reference Number - Unique ID generated by Cashfree’s partner bank for a particular refund.	322077986405
order_note	A small description for that transaction.	payment_link_23840285
payment_mode	The payment mode used for the transaction.	UPI
customer_name	The name of the customer.	john
customer_email	The email ID of the customer.	[e-mail]
customer_phone	The phone number of the customer.	7760381080