Reconcile Your Online Store Payouts Every Month: A 20-Minute Routine

Your online store shows, say, ₹1,20,000 in sales for the month. Your bank shows a smaller figure arriving in several credits on odd dates. Your accountant asks which is correct, and you are not sure. This is the gap that online store payment reconciliation closes. Once a month, you match what the payment gateway settled to the orders in your store and to the credits in your bank. Done regularly it takes about twenty minutes. This post gives you the routine, explains where the differences come from and tells you what to hand your accountant.

Why a monthly habit, not a year-end scramble

GST returns are filed monthly or quarterly, and the sales figure you report must match what you invoiced. If you only look at payouts in March, you are explaining twelve months of fees, refunds and failed payments in one sitting. A monthly check also catches real problems early: a settlement that never arrived, a refund issued twice, or a customer charged twice for one order. Those are easier to raise with the gateway while the transaction is recent.

What to export before you start

You need three reports for the same month, exported as spreadsheets into one folder named by month.

• Gateway settlement report — from Razorpay, PhonePe PG, Cashfree or whichever gateway you use. Choose the settlement or payout report, not the plain transactions list. It shows each payout to your bank, the transactions inside it and the fees deducted. UPI Payment Gateways Compared: Razorpay, PhonePe PG and Cashfree for Small Businesses covers how their reports and settlement cycles differ.
• Store orders export — from your OpenCart, WooCommerce or Shopify admin, with order number, date, status, payment method, total and the gateway payment ID if your store records it.
• Bank statement — for the account the gateway pays into, filtered for credits with the gateway's name in the narration.

The three-way match

Reconciliation is one question asked three times: does this amount appear in all three places, and if not, why?

• Orders to gateway — every paid online order should have a matching successful gateway transaction for the same amount.
• Gateway to bank — every settlement the gateway paid should appear as a bank credit for the same net amount.
• Bank back to orders — total credits plus fees plus refunds should add up to the month's online order total. If it does, the month is clean.

Where the differences come from

A gap between store sales and bank credits is normal. Every rupee of it should have a name.

• Gateway fees and GST on fees — the gateway deducts its charge from each settlement and adds GST on that charge. Both are expenses, and the GST portion is usually claimable as input credit. The gateway issues a tax invoice for its fees each month; download it and confirm the treatment with your accountant.
• Refunds — a refund issued this month for last month's order reduces this month's settlement. Note which order it belongs to so both months' sales figures stay right.
• Failed and duplicate payments — a customer whose first attempt failed may pay again. The store shows one order; the gateway may show one failed and one successful transaction, or occasionally two successful ones. The second needs a refund.
• Cash on delivery — COD orders never touch the gateway. Exclude them here and reconcile them against your courier's remittance.
• Settlement timing — gateways settle on T+1 or T+2 working days, so an order paid on the 30th may land in the bank on the 2nd. The last two or three days of each month sit in next month's bank credits. Carry them forward on a short list rather than treating them as missing.

The 20-minute routine

Do this in the first week of each month.

• 1. Export the three reports into the month's folder.
• 2. Total the store's paid online orders, excluding COD and cancelled orders. Write the figure down.
• 3. Total the gateway's successful transactions for the same dates. The two totals should match. If not, sort both lists by amount and find the orders in one but not the other.
• 4. List the gateway settlements with their net amounts and tick each against a bank credit. Note any not yet received.
• 5. Write down the explained differences: fees, GST on fees, refunds, duplicates and late-month carry-forwards. Store sales minus these should equal bank credits.
• 6. Raise anything unexplained with gateway support the same week, quoting the payment ID.

The first month takes longer while you learn the reports. After that it becomes routine.

What to hand your accountant

Your accountant needs a clean trail, not your working. Send one folder per month with the three exports, the gateway's fee invoice, a short note listing the explained differences and the carry-forward list. If your store issues the GST invoice for each order, confirm it shows the details described in What Every GST Invoice Must Show: A Simple Guide for Small Businesses, because the order total on the invoice is the sales figure your return is built on, not the net credit in the bank.

When software removes the manual work

Past a few hundred orders a month, matching by hand stops being twenty minutes. There are two ways to automate it. The first is a store integration: your website records the gateway payment ID and settlement ID against each order and pulls settlement data automatically, so the match happens inside the admin and you only review exceptions.

The second is billing software that imports store orders and the bank statement, posts fees and GST as expenses, and produces the sales register your accountant files from. GST Billing Software: 10 Features Every Indian Shop Needs lists what to look for, including bank reconciliation and GST reports. For a Sivakasi or Madurai trader running a counter and a website, having both flow into one register is the real time saver.

Frequently asked questions

Which figure do I report for GST: store sales or bank credit?

The invoice value, which is your store's order total before gateway fees. Fees are a separate expense with their own tax invoice from the gateway. Confirm the treatment and the input credit on fees with your accountant, since rules change.

What if a settlement never arrives in the bank?

Check the settlement status in the gateway dashboard first; it may be on hold for a document or a bank detail issue. If it shows as paid and the bank has no credit after three working days, raise a ticket with the gateway quoting the settlement ID.

Can I reconcile COD orders the same way?

The method is the same but the parties differ. Match COD orders against the courier company's remittance report and then against the bank credit from the courier. Courier charges and return-to-origin fees play the role that gateway fees play here.