Razorpay settlement reconciliation
“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”
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.
- FileRazorpay settlements reportCSV export · 25 rows
- FileHDFC Bank statementCSV export · 24 rows
- StepNumber settlement linesStep 1
- StepExtract UTR and number bank linesStep 2
- JoinBring in bank credits24 of 25 paired
- StepMatch lines and flag differencesStep 4
- ResultSettlement reconciliation25 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 25 rows came out, and the join paired 24 of 25 rows.
- Download Razorpay settlements report sample (25 rows)Razorpay: Settlements > Reports > Settlements report > Export CSV
- Download HDFC Bank statement sample (24 rows)HDFC Bank: Account Statement > Download > CSV
What you get back
The result of that run, the rows to look at first.
| Settlement ID | Bank narration | Status | Fee | GST on fee | Settlement amount | Bank deposit amount | Settlement date | Bank date | Settlement UTR |
|---|---|---|---|---|---|---|---|---|---|
| setl_8f2c1aa9 | · | Missing in bank | 711 | 127.98 | 34,711.02 | · | 2026-11-04 | · | RZP26110004Y |
| setl_8f2c1aa8 | NEFT RAZORPAY SETTLEMENT RZP26110003X | Amount differs | 347.60 | 62.57 | 16,969.83 | 15,469.83 | 2026-11-03 | 2026-11-03 | RZP26110003X |
| setl_8f2c1a91 | NEFT RAZORPAY SETTLEMENT RZP26100001A | Agrees | 368.99 | 66.42 | 18,014.59 | 18,014.59 | 2026-10-01 | 2026-10-01 | RZP26100001A |
| setl_8f2c1a92 | NEFT RAZORPAY SETTLEMENT RZP26100003B | Agrees | 553.60 | 99.65 | 27,026.75 | 27,026.75 | 2026-10-03 | 2026-10-03 | RZP26100003B |
| setl_8f2c1a93 | NEFT RAZORPAY SETTLEMENT RZP26100004C | Agrees | 259.80 | 46.76 | 12,683.44 | 12,683.44 | 2026-10-04 | 2026-10-04 | RZP26100004C |
| setl_8f2c1a94 | NEFT RAZORPAY SETTLEMENT RZP26100006D | Agrees | 904.20 | 162.76 | 44,143.04 | 44,143.04 | 2026-10-06 | 2026-10-06 | RZP26100006D |
| setl_8f2c1a95 | NEFT RAZORPAY SETTLEMENT RZP26100007E | Agrees | 397.50 | 71.55 | 19,406 | 19,406 | 2026-10-07 | 2026-10-07 | RZP26100007E |
| setl_8f2c1a96 | NEFT RAZORPAY SETTLEMENT RZP26100009F | Agrees | 630.80 | 113.54 | 30,795.66 | 30,795.66 | 2026-10-09 | 2026-10-09 | RZP26100009F |
| setl_8f2c1a97 | NEFT RAZORPAY SETTLEMENT RZP26100010G | Agrees | 334.40 | 60.19 | 16,325.41 | 16,325.41 | 2026-10-10 | 2026-10-10 | RZP26100010G |
| setl_8f2c1a98 | NEFT RAZORPAY SETTLEMENT RZP26100012H | Agrees | 1,178 | 212.04 | 57,509.96 | 57,509.96 | 2026-10-12 | 2026-10-12 | RZP26100012H |
| setl_8f2c1a99 | NEFT RAZORPAY SETTLEMENT RZP26100013I | Agrees | 493 | 88.74 | 24,068.26 | 24,068.26 | 2026-10-13 | 2026-10-13 | RZP26100013I |
| setl_8f2c1a9a | NEFT RAZORPAY SETTLEMENT RZP26100015J | Agrees | 749.60 | 134.93 | 36,595.47 | 36,595.47 | 2026-10-15 | 2026-10-15 | RZP26100015J |
How it works
How to use the Settlement reconciliation workflow
- 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.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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?
Which export files should you use?
What happens to rows that do not match?
How do you change the matching rules?
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.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent