Payments & COD
Finance reports
Download the CashFlow Report, Tax Report and Order Reconciliation Report from Analytics, for any date range.
Four finance reports live in Analytics, under the Finance heading. Use them for your accounts, your GST returns, your platform commission, and to check each order’s profit.
| Report | Use it to | Dates are based on |
|---|---|---|
| Order Reconciliation | See each order’s revenue, costs and net profit | The day the order was placed |
| CashFlow Report | List every wallet movement in a period | The day the entry hit your wallet |
| Tax Report | Get taxable value and CGST/SGST/IGST per product line, plus credit notes, for filing | Invoices: the day the order was placed. Credit notes: the day the refund was processed |
| Commission Report | See the platform commission on each order, charged only once it is delivered | The day the order was placed |
Where: Analytics → Order Reconciliation, Analytics → CashFlow Report, Analytics → Tax Report, Analytics → Commission Report. You need access to the Payments module to see them. If your staff login doesn’t have it, these are hidden from the sidebar.
How every report works
Open the report
Go to Analytics and pick Order Reconciliation, CashFlow Report, Tax Report or Commission Report.
Pick the dates
Choose Yesterday, Last 7 days, Last 30 days, Last 90 days, Last month or Custom dates. Each report starts on the last 30 days.
Check the preview
The rows show on screen first. Use Search… to find a row. If there is nothing for those dates, you see Nothing to show.
Click Download CSV
You get the full set as a CSV. It opens in Excel or Google Sheets.
Order Reconciliation
An order-wise money breakdown. Use it to see which orders made money and which lost it.
Columns: Order No, Placed At, Status, Payment Method, Order Total, Revenue Counted, Product Cost, Shipping Cost, Commission, Refunds, Net.
| Column | How it is worked out |
|---|---|
| Order Total | What the buyer was charged |
| Revenue Counted | The order total. ₹0 for Cancelled and RTO orders |
| Product Cost | Your cost price × quantity. Uses the cost price saved on the order when it was placed, else the product’s current cost price |
| Shipping Cost | The shipping charge on the shipment plus any return pickup charge. Counted for RTO orders too; ₹0 for cancelled orders |
| Commission | Order total × the commission rate fixed on the order. ₹0 for Cancelled and RTO orders |
| Refunds | All refunds on the order that were not rejected or failed — including ones still waiting |
| Net | Revenue − product cost − shipping − commission − refunds |
Example: say your commission rate is 10%.
| Order | Status | Revenue | Product cost | Shipping | Commission | Refunds | Net |
|---|---|---|---|---|---|---|---|
| A | Completed | ₹1,000 | ₹400 | ₹70 | ₹100 | ₹0 | ₹430 |
| B | RTO | ₹0 | ₹0 | ₹70 | ₹0 | ₹0 | −₹70 |
Keep the cost price filled in on your products. If it is blank, Product Cost shows ₹0 and Net looks better than it is.
CashFlow Report
Every wallet movement in the period — COD credits, commission, ad spend, refunds and payouts.
Columns: Date, Type, Amount, Running Total (period), Order No, Note.
The running total starts at zero for the period you pick. For your real opening and closing balance, use Statements on Payments → Payments Overview.
The Type column uses system names. This table shows what each one is called on Payments Overview → Transactions:
| Type in the CashFlow Report | Name on Payments Overview |
|---|---|
| Order prepaid credit | Online payment received |
| Order cod credit | COD cash received |
| Order prepaid commission debit | Commission |
| Forward freight debit | Delivery charge |
| Rto freight debit | RTO charge |
| Return freight debit | Return pickup charge |
| Ad spend debit | Ad spend |
| Courier claim credit | Courier claim settled |
| Manual adjustment | Adjustment |
| Wallet recharge credit | Wallet recharge |
| Onboarding deposit credit | Onboarding deposit |
| Payout debit | Payout to bank |
| Reversal | Commission returned, Refund to buyer, Shipping charge returned, or Payout failed — money returned. The Note says which |
Example: a week with three entries.
| Date | Type | Amount | Running Total (period) |
|---|---|---|---|
| Mon | Order prepaid commission debit | −100 | −100 |
| Thu | Forward freight debit | −70 | −170 |
| Thu (next week) | Order prepaid credit | 1,000 | 830 |
Tax Report
Line-wise taxable value with CGST, SGST and IGST, for filing your GST returns (GSTR-1). Cancelled and RTO orders are left out. Every processed refund shows as a credit note.
Columns: Document Date, Document Type, Invoice/CN No., Order No, Order Status, Seller GSTIN, Seller State, Customer State (Place of Supply), Supply Type, Product, SKU, HSN, Qty, GST %, Taxable Value, IGST, CGST, SGST, Total Tax, Invoice Value (incl. GST), Payment Method.
How it is worked out: the line value is taken as GST-inclusive. The GST is backed out of it:
- Taxable Value = Invoice Value ÷ (1 + GST % ÷ 100)
- Total Tax = Invoice Value − Taxable Value
- If your state matches the buyer’s state, the tax is split half into CGST and half into SGST. Otherwise all of it is IGST. The column that doesn’t apply shows -. Your state comes from your GSTIN (else your business pincode). The buyer’s state comes from the delivery pincode, so a misspelt state name doesn’t matter. If a state can’t be worked out, the line counts as IGST.
Example: a line worth ₹1,180 for a product with GST 18%, from a seller in Gujarat.
| Customer State | Invoice Value | Taxable Value | IGST | CGST | SGST |
|---|---|---|---|---|---|
| Gujarat | ₹1,180 | ₹1,000 | - | ₹90 | ₹90 |
| Maharashtra | ₹1,180 | ₹1,000 | ₹180 | - | - |
Invoice/CN No. is the order number, the same as on the printed tax invoice. A credit note is numbered CN-<order number>-1, -2 and so on. It is dated the day the refund was processed, and its money columns are negative. Qty is negative only when the line is fully refunded; a partial refund shows Qty 0. A refund is for the whole order, so it is split across the order’s lines by line value.
The GST % and HSN come from each product. Keep them filled in on your products so this report is right. A product with no GST % shows 0, and its whole line value counts as taxable.
Commission Report
The platform commission on each order. Commission is charged only on delivered orders. Cancelled, RTO and not-yet-delivered orders show ₹0, and the Note says why.
Columns: Order Date, Order No, Status, Delivered On, Payment Method, Order Value, Commission Rate %, Commission, Refund Clawback, Net Commission, GST on Commission (18%), Total Charged (incl. GST), Wallet Deducted, Difference, Note.
| Column | How it is worked out |
|---|---|
| Commission Rate % | The rate fixed on the order when it was placed, else your current rate |
| Commission | Order value × rate, for delivered orders only |
| Refund Clawback | Commission given back to you on processed refunds |
| Net Commission | Commission − Refund Clawback |
| GST on Commission | 18% of Net Commission |
| Total Charged | Net Commission + GST |
| Wallet Deducted | Commission your wallet has actually taken for this order so far, after any reversals |
| Difference | Wallet Deducted − Net Commission. 0 means they match |
Example: your rate is 10%.
| Order | Status | Payment | Order Value | Net Commission | Wallet Deducted | Difference | Note |
|---|---|---|---|---|---|---|---|
| A | Completed | Online | ₹1,000 | ₹100 | ₹100 | ₹0 | Charged |
| B | Completed | COD | ₹1,000 | ₹100 | ₹0 | −₹100 | Charged — taken from the COD cash when the courier sends it |
| C | In Transit | Online | ₹1,000 | ₹0 | ₹100 | ₹100 | Not delivered yet — prepaid commission already held at payment |
| D | RTO | COD | ₹1,000 | ₹0 | ₹0 | ₹0 | Not charged (RTO) |
Things to know
- Different date bases. Order Reconciliation and Tax Report pick orders by the day they were placed (Tax Report credit notes go by the refund date). CashFlow picks wallet entries by the day they happened. So the same order can fall in different months across reports.
- Shipping charged to the buyer is part of the order total, so it counts in Revenue Counted in Order Reconciliation. The Tax Report lists product lines only, so it is not in Line Value.
- Refunds after the period still show on an order in Order Reconciliation, because it reads the order as it is today.
- For a full statement with balances, use Statements on Payments Overview. See Wallet & commission.