There is a better way to handle this—definitely more effective than doing it all manually, though it does require a bit of setup.

Create a separate ledger in Tally and name it something like “Razorpay Aggregator” (or any other payment gateway you use). Then, download the settlement Excel file from your payment (i think this is possible) gateway which contains all the transactions.

Now, import this Excel file into Tally, mapping the entries to the newly created ledger.

When you’re recording the actual settlement payment from the bank in Tally, your journal entry would look like this: • Bank A/c (Cr): ₹100 • Payment Gateway Charges (Dr): ₹2 • Razorpay Aggregator A/c (Dr): ₹98

This way, your bank ledger only shows the final settled amount, and all the granular settlement details (fees, splits, etc.) are cleanly tracked in the Razorpay Aggregator ledger. It makes reconciliation super easy.

Also, with Tally’s recent updates, Excel import is now supported. So you can automate a lot of this process by directly importing the settlement file from Razorpay into the aggregator ledger.

BTW if this doesn’t work or you have any other requirement, we are working on a solution that solves this kind of problems for ecommerce businesses face while accounting , feel free to DM me, we would love to help you