Import a Razorpay Settlement Report

When you collect through Razorpay, the amount your customers pay is not the amount that lands in your bank. Razorpay deducts a fee (plus GST on that fee) before settling, and any refunds are pulled back too. If you simply total the gross column, your books overstate what you actually collected.

Kuvi now reads a Razorpay settlement report properly. It records the real economics in one step, so your income always reconciles to the money credited to your account.

What Kuvi reads from the file

A settlement export has one row per transaction with these columns: amount, fee (exclusive tax), tax, debit, credit, settled_at, and transaction_entity. When Kuvi sees them, it switches automatically from the plain sales report mode to the settlement reader, which pulls out:

• Gross collections: the total your customers paid (payment rows).
• Gateway fee: Razorpay's charge, before GST.
• GST on the fee: the tax on that charge, which you can claim as input credit.
• Refunds: any refund or chargeback rows, which reduce your income.
• Net settled: what actually reached your bank (credit minus debit).

How it is booked

Kuvi follows standard accounting so nothing is double-counted:

1. Income recorded = gross collections, less any refunds. This is your true turnover and feeds product revenue and your P&L.
2. Gateway charges (fee + GST) are logged as a separate pending expense in the category "Payment gateway charges". It goes to your approval queue, and once approved it appears in the expense ledger. The GST portion is noted as claimable input credit.
3. Refunds are netted off the income automatically.

The result always balances:

Income, minus the gateway expense, equals the amount credited to your bank.

A worked example

For a July settlement of 27 payments:

Kuvi records Rs 46,232.82 as income and creates a Rs 264.03 gateway charges expense for approval. The two net to Rs 45,968.79, exactly what your bank received.

Step by step

1. In Razorpay, download the settlement report for the period as CSV.
2. In Kuvi, go to Accounting and click Record income.
3. Choose Import a report and upload the CSV.
4. Kuvi detects the settlement format and shows the full breakdown: gross, fee, GST, refunds, and net settled. The period dates are filled in from the file.
5. Optionally pick the product the income belongs to and add a note.
6. Click Record income. Your revenue is posted, and the gateway charges land in the approvals queue.
7. Open Expenses, review the "Payment gateway charges" entry, and approve it so it posts to the ledger.

Good to know

• No double imports. Kuvi fingerprints each file and blocks re-importing the same report, and it will not let two entries overlap the same period for a product. If you need to replace an entry, delete the old one first.
• Nothing leaves your computer during the read. The file is parsed in your browser; only the totals are sent when you click Record income.
• Not a Razorpay settlement file? Any other CSV still works the old way: Kuvi totals a single amount column. See Import a Sales Report.
• Foreign currency. Settlement import is designed for INR payouts. For other currencies, record the income manually or use the plain sales report import.