Skip to content
Workflow · Match two lists · Opening soon

Razorpay settlement reconciliation

Export your Razorpay settlements report and your HDFC Bank statement, then upload both files. The workflow numbers the settlement rows, extracts the UTR and amounts, brings in bank credits, and matches each settlement to the bank by UTR and amount.

Early access opens shortly. Check back soon.

Someone typed

“match each razorpay settlement to the credit in my bank statement by settlement utr and amount, show the fee and gst on fee for each settlement, and list settlements not yet in the bank”

The agent read it as

Match each Razorpay settlements report to the credit in my HDFC Bank statement by settlement UTR and amount, show the fee and GST on fee for each settlement, and list settlements not yet in the bank

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Razorpay settlements report
    CSV export · 25 rows
  2. File
    HDFC Bank statement
    CSV export · 24 rows
  3. Step
    Number settlement lines
    Step 1
  4. Step
    Extract UTR and number bank lines
    Step 2
  5. Join
    Bring in bank credits
    24 of 25 paired
  6. Step
    Match lines and flag differences
    Step 4
  7. Result
    Settlement reconciliation
    25 rows · 2 flagged
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 25 rows came out, and the join paired 24 of 25 rows.

What you get back

The result of that run, the rows to look at first.

Settlement reconciliationSample data25 rows
23 agrees1 amount differs1 missing in bank
Settlement IDBank narrationStatusFeeGST on feeSettlement amountBank deposit amountSettlement dateBank dateSettlement UTR
setl_8f2c1aa9·Missing in bank711127.9834,711.02·2026-11-04·RZP26110004Y
setl_8f2c1aa8NEFT RAZORPAY SETTLEMENT RZP26110003XAmount differs347.6062.5716,969.8315,469.832026-11-032026-11-03RZP26110003X
setl_8f2c1a91NEFT RAZORPAY SETTLEMENT RZP26100001AAgrees368.9966.4218,014.5918,014.592026-10-012026-10-01RZP26100001A
setl_8f2c1a92NEFT RAZORPAY SETTLEMENT RZP26100003BAgrees553.6099.6527,026.7527,026.752026-10-032026-10-03RZP26100003B
setl_8f2c1a93NEFT RAZORPAY SETTLEMENT RZP26100004CAgrees259.8046.7612,683.4412,683.442026-10-042026-10-04RZP26100004C
setl_8f2c1a94NEFT RAZORPAY SETTLEMENT RZP26100006DAgrees904.20162.7644,143.0444,143.042026-10-062026-10-06RZP26100006D
setl_8f2c1a95NEFT RAZORPAY SETTLEMENT RZP26100007EAgrees397.5071.5519,40619,4062026-10-072026-10-07RZP26100007E
setl_8f2c1a96NEFT RAZORPAY SETTLEMENT RZP26100009FAgrees630.80113.5430,795.6630,795.662026-10-092026-10-09RZP26100009F
setl_8f2c1a97NEFT RAZORPAY SETTLEMENT RZP26100010GAgrees334.4060.1916,325.4116,325.412026-10-102026-10-10RZP26100010G
setl_8f2c1a98NEFT RAZORPAY SETTLEMENT RZP26100012HAgrees1,178212.0457,509.9657,509.962026-10-122026-10-12RZP26100012H
setl_8f2c1a99NEFT RAZORPAY SETTLEMENT RZP26100013IAgrees49388.7424,068.2624,068.262026-10-132026-10-13RZP26100013I
setl_8f2c1a9aNEFT RAZORPAY SETTLEMENT RZP26100015JAgrees749.60134.9336,595.4736,595.472026-10-152026-10-15RZP26100015J
25 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Settlement reconciliation workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Settlement reconciliation: questions

How do you reconcile Razorpay settlements?
Export your Razorpay settlements report and your HDFC Bank statement, then upload both files. The workflow numbers the settlement rows, extracts the UTR and amounts, brings in bank credits, and matches each settlement to the bank by UTR and amount. It shows the fee and GST on fee for each settlement, and flags any rows that do not match or are not yet in the bank.
Which export files should you use?
Use the Razorpay settlements report and the HDFC Bank statement export. The workflow reads the rows from those files and compares the settlement records to the bank credits.
What happens to rows that do not match?
Rows that do not match the UTR and amount rules are flagged as differences. Rows with no matching bank credit are listed as missing in the bank.
How do you change the matching rules?
Edit the rule words in the workflow, for example which fields to extract and which columns to match on. You can change the checks from UTR and amount to other text or number fields in the exported files.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.