Fee Analysis:
Correctly Charged Fees:
The software confirms a perfect match between Razorpay’s fees and internal calculations.
Overcharged Fees:
If Razorpay’s fees exceed calculated amounts, these orders are flagged for further investigation. This helps identify potential discrepancies and recover any overcharges.
Undercharged Fees:
Conversely, orders with fees lower than Razorpay’s calculations are highlighted.
Tax Verification:
Correctly Charged Tax:
The software verifies if the tax levied (typically 18% GST on fees) matches the calculations. This ensures accurate tax application on each transaction.
Overcharged Tax:
Any orders reflecting tax exceeding the calculations are identified, enabling you to investigate potential tax overcharges.
Undercharged Tax:
Orders with lower than expected tax are highlighted, allowing you to address any undercharged tax liabilities proactively.
Settlement Analysis:-
Settlement without Transaction ID:
These settlements appear in the Razorpay report, but the corresponding transaction IDs are missing.
Settlement Amount Match:
Our software calculates the settlement amount using the formula: Settlement Amount = Amount Collected from Customer – Fee Charge – Tax Charge. Orders with matching calculated and reported settlement amounts are displayed
Settlement Amount Mismatch:
Orders with discrepancies between the calculated and reported settlement amounts are identified for further review to ensure accurate reconciliation.
Settlement UTR not Present:
UTR (Unique Transaction Reference) is crucial for verifying bank settlements. Orders lacking UTR require investigation as they might not be reflected in the bank account.
Settled in Bank Account: Orders with the final settlement amount reflected in the bank statement are categorized here. Not Settled in Bank Account: Orders where the final settlement amount is missing from your bank statement are identified.