Please follow the below steps for easy reconciliation (in case you are not doing it already):
1) Go to Cashier Panel
2) Download Daily Collection report for a given date range
3) Go to Razorpay Panel
4) Download the Collection Reports
5) Both reports will have a Razorpay payment ID. Do a Vlookup.
6) In case any ID is missing, it means that the transaction was not recorded in Vawsum portal.
7) This is the fastest way to find discrepancies if any.
8) No Bank or Gateway gives an external company access to their DB. Hence, this manual step.
Next Steps
1) Flag these items to Vawsum team.