Perimattic
Free Tool

Payment Reconciliation Simulator

The Payment Reconciliation tool matches your Razorpay settlement report with the receipts in TallyPrime or other books, first on payment ID or order ID and then on amount and date. You get matched, mismatched and missing payments, refunds and adjustments listed separately, and a per-settlement breakdown of gross, fee, GST on fee and net settled with a suggested journal entry. It runs entirely in your browser.
Overhead view of a person working on a laptop beside a calculator

Use the free tool

Your files stay on your device. Everything is processed in your browser. Nothing is uploaded to ERPPlugs or anyone else, and no account is needed.

1

Razorpay settlement report

The settlement recon report (CSV or Excel) from your Razorpay Dashboard, with one row per payment, refund and adjustment.

2

Receipts from your books

Receipt vouchers exported from TallyPrime or your accounting software for the same dates, with reference or narration.

Add both files to see the reconciliation. No files handy? Click Use sample data in each box.

How It Works

How the Payment Reconciliation Simulator Works

  1. 1

    Add the Razorpay report and your receipts

    Drop the settlement report downloaded from the Razorpay Dashboard and your receipt vouchers exported from TallyPrime or Excel for the same dates. Columns such as entity_id, amount, fee, tax and settlement_id are detected automatically.

  2. 2

    Payments are matched in your browser

    Receipts that mention a pay_ or order_ ID in the reference or narration are matched on that ID. Remaining receipts are matched on exact amount within a date window (3 days by default) and flagged for review.

  3. 3

    Review gaps and post settlements

    See payments missing from your books, receipts with no Razorpay payment, amount differences, refunds and adjustments. Each settlement shows gross, refunds, fee, GST on fee, net and UTR, with a suggested entry to copy. Download Excel or CSV.

Guide

How to Reconcile Razorpay With TallyPrime Receipts

Prepare the files

From the Razorpay Dashboard, download the settlement reconciliation report for the dates you want to check. Keep the default columns; the tool needs entity_id and amount, and uses fee, tax, settlement_id, settlement_utr, order_id and created_at when they are present.

From TallyPrime, export the receipt vouchers for the same dates to Excel, with the reference number or narration where your team notes the Razorpay payment ID. Including a couple of days on either side helps with payments recorded on the settlement date.

Read the results

Work through the tabs in the detail table from the top.

  • Amount mismatch: the payment ID matched but the amounts differ. A common cause is booking the net amount after fees instead of the gross amount.
  • In Razorpay, not in books: money was collected but no receipt is recorded. Post the receipt, or check whether it falls in the next period.
  • In books, not in Razorpay: a receipt with no Razorpay payment. It may be a bank or cash receipt, a payment from another period, or a wrong ID.
  • Matched by amount: the same amount within the date window but no ID in the books. Confirm these before relying on them.
  • Refunds and adjustments: post credit notes for refunds and check adjustments such as dispute recoveries against the Razorpay description.

Posting the settlement

Each settlement is one bank credit. The suggested entry debits the bank with the net amount, debits payment gateway charges and input GST with the fee and GST on fee, and credits the Razorpay clearing ledger. It assumes receipts were posted to that clearing ledger and refunds were posted against it when issued. Check the ledger names and treatment with your accountant before posting.

FAQ

Frequently Asked Questions

Use the settlement reconciliation report from the Razorpay Dashboard for the period you are checking, as CSV or Excel. It lists every payment, refund and adjustment with its fee, tax, settlement ID and UTR. A plain payments export also works for matching, but the settlement view needs the settlement_id column.

One row per receipt with date and amount, plus any column where your team records the Razorpay payment ID (pay_...) or order ID (order_...), such as the reference number or narration. Party name and voucher number are optional but make the results easier to read. Filter the export to receipts that came through Razorpay if you can, otherwise bank and cash receipts will show as "in books, not in Razorpay".

First, the tool looks for a pay_ ID in the reference, narration, voucher number or party columns and matches it to the same Razorpay payment; if there is none, it tries the order_ ID. Receipts still unmatched are paired with a Razorpay payment of exactly the same amount whose payment or settlement date is within the date window, choosing the closest date. Those are marked "matched by amount" so you can confirm them.

A receipt matched by payment or order ID whose amount differs from the Razorpay amount by more than the tolerance (₹1 by default). If the books amount equals the amount after Razorpay fee and GST, the note says so: the receipt should usually be the gross amount, with the fee booked separately.

Razorpay’s fee column normally includes GST, with the GST also shown in a separate tax column. The tool checks this against the credit column and splits them, so each settlement shows the fee excluding GST and the GST on fee as separate figures, matching the gateway charges and input GST lines in the suggested entry. Amounts are treated as rupees; if every amount is a whole number the tool warns that the file may be in paise and lets you divide by 100.

No. Both files are read and matched by JavaScript in your browser. Nothing is sent to ERPPlugs, Razorpay or any other server, and no sign-up is needed.

ERPPlugs

Ready to eliminate manual data entry?

Start a 7-day free trial and see results in 5 minutes. No credit card required. Works with TallyPrime, Zoho, SAP and more.
  • Free consultation
  • No commitment
  • Tailored to your team

All product names, logos, and brands mentioned on this site are the property of their respective owners. ERPPlugs is not affiliated with, endorsed by, or sponsored by any of the third-party companies referenced. Use of these names is for identification purposes only and does not imply any association or endorsement.