The Monthly Reconciliation Nightmare
Every week, the same ritual. Your Razorpay dashboard shows ₹50,000 in sales. Your bank account received ₹47,200. Tally shows ₹50,000 in revenue entries. And your accountant spends 3-4 hours figuring out where the ₹2,800 went.
Spoiler: it’s Razorpay’s processing fee (2%) plus GST on that fee (18% of 2%). Plus settlement timing differences. Plus the occasional refund that processed on a different day.
Simple math? Sure. But across 200 transactions a week, with split settlements, partial refunds, disputed charges, and TDS deductions — it becomes a full-day exercise.
Now multiply that by Cashfree, PayU, PhonePe Business, and Google Pay. If you accept payments through multiple gateways (and most businesses do), reconciliation becomes a full-time job.
The 8-Step Manual Process
Here’s what your accountant actually does every week:
Step 1: Download the Razorpay settlement report (CSV). Filter by date range. Pray the format hasn’t changed since last week.
Step 2: Download the bank statement. Match settlement reference numbers to bank credits. Flag anything that doesn’t match.
Step 3: For each settlement, calculate Razorpay’s fee. It’s 2% on cards, different on UPI, different on netbanking. Each transaction has a different fee.
Step 4: Calculate GST on Razorpay fees (18%). This is input credit you can claim, so it needs to be accurate.
Step 5: Match the settlement timing. Razorpay settles T+2 for most merchants. So Monday’s sales appear in Wednesday’s bank statement. But some transactions settle T+1, and some T+3. Good luck.
Step 6: Handle exceptions. Refunds that crossed settlement cycles. Disputed charges. Partial settlements. Each one is a special case.
Step 7: Create TDS entries for applicable transactions (Section 194O for e-commerce, if applicable).
Step 8: Post everything to Tally. Sales entries, fee entries, GST entries, bank entries. One by one.
Time spent: 3-4 hours minimum. Every single week. That’s 15-20 hours a month. On just one payment gateway.
How a Digital Employee Does It in 5 Minutes
Connect your Razorpay account. Connect your bank feed. Your Tally is already connected.
Now ask: “Show me unreconciled Razorpay settlements this month.”
In under 10 seconds, you see every settlement with:
- Transaction-level fee breakdown (card vs UPI vs netbanking rates)
- GST on fees calculated per transaction
- Bank credit matching with timing adjustment
- Exceptions highlighted in red — refunds, disputes, partial settlements
- Net amount verification (sales minus fees minus GST minus TDS = bank credit)
Everything matches? One click: “Post to Tally.” The Digital Employee creates all the journal entries — sales, fees, GST input credit, bank — and puts them in Tally for your approval.
Something doesn’t match? The Digital Employee tells you exactly what’s off. “Settlement #RZP_2026031500123 shows ₹12,500 but bank received ₹12,250. Likely TDS deduction of ₹250 (2% under 194O). Shall I create the TDS entry?”
That’s 5 minutes. Not 4 hours.
The Real Numbers
If your accountant spends 4 hours/week on Razorpay reconciliation at ₹300/hour (fully loaded cost for a semi-senior accountant), that’s ₹4,800/month on one gateway.
Add Cashfree, bank statements, and GST reconciliation: ₹12,000-15,000/month in accountant time. Just on reconciliation.
A Digital Employee costs ₹49/month for normal usage. Even heavy usage runs ₹200-300/month.
That’s not a 10x improvement. That’s a 50x improvement. And the Digital Employee doesn’t make calculation errors, doesn’t forget to account for GST on fees, and doesn’t miss the TDS deduction.
Beyond Razorpay
The same pattern works for every payment gateway:
- Cashfree: Different fee structure, same reconciliation headache. Connected.
- PayU: Split settlements across multiple bank accounts. Connected.
- CCAvenue: Complex fee tiers based on volume. Connected.
- PhonePe Business: UPI settlements with MDR variations. Connected.
- Google Pay Business: Zero MDR on UPI, but timing differences still exist. Connected.
222 connectors. One Digital Employee. Every reconciliation automated.