Open dashboard

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.

Where to go next

Type to search across every page.

↑↓ navigate↵ openesc close