Skip to main content
SANDIP.OS

// Finance Intelligence Lab

Turning Financial Complexity Into Clarity.

Accounting and financial operations have been the foundation of my career since April 2018. These six demos show the methods behind that work, using fictional data only.

Uneek Tribe LLP

Continuing accounting, GST compliance, financial reporting and related financial operations.

Independent assignments

Freelance GST return filing and accounting-related work for separate clients. Not employment; clients are never named.

PixelPearls

My own sole-proprietorship business — accounting, GST, inventory and marketplace reconciliation in practice.

Educational demonstrationNo portal connection · nothing filed or storedFreelance clients never named

Module 03

E-commerce Settlement Reconciliation

Sample data · fictional

Gross sale to net settlement across Shopify, Amazon, Flipkart and Instagram / WhatsApp — fees, GST on fees, TCS and TDS kept apart. Built on the PixelPearls settlement demo.

Marketplace: referral and closing fees plus shipping, GST on those fees, then TCS and TDS. Fictional rates.

Sale value

Gross sale (incl. GST)₹1,199

What the customer paid, less discounts and refunds. Prices include GST.

Platform fees & charges

Referral fee (12%)−₹143.88
Closing fee−₹25
Marketplace shipping fee−₹65

Operating expenses charged by the platform or payment gateway.

GST on platform fees

GST on fees (18%) — input credit−₹42.10

Tax charged on the operator's services. Potentially an input credit, subject to the usual conditions.

GST TCS · Section 52

TCS u/s 52 CGST (0.5% of taxable value)−₹5.82

Collected by the e-commerce operator and credited to your electronic cash ledger. A tax credit, not a fee.

Income-tax TDS · Sec 393(1), Table 8(v)

Income-tax TDS u/s 393(1) Table 8(v), IT Act 2025 (0.1%)−₹1.20

Sample dated April 2026, so the Income-tax Act, 2025 provision applies (0.1%; the same deduction was Section 194-O of the 1961 Act before 1 April 2026). Applied here for illustration — it does not apply to every payout: under Section 393(4) an individual or HUF seller whose gross sales through the operator in the tax year do not exceed ₹5,00,000 and who has given the operator their PAN or Aadhaar is exempt. Claimed against income tax, not GST.

Expected settlement₹916
Amount received (sample)₹880
Difference−₹36

Demonstration mismatch — deliberately introduced to illustrate reconciliation. The expected figure is what the fee and tax rules should leave; the received figure is what actually arrived. The gap must be traced in the seller report before it is booked.

Marketplace payout

Kept outside the settlement

GST liability on the sale (sample 3%)₹34.92

Your own tax liability, reported and paid through your return. It is not a platform deduction.

TCS + TDS credits to claim₹7.02

Tracked separately: TCS against GST, TDS against income tax.

Sample classification: imitation jewellery at an example 3% GST rate. Real rates depend on each product's classification. Sample period April 2026: GST TCS at 0.5% in total (the rate since 10 July 2024; 1% before) — 0.25% CGST + 0.25% SGST/UTGST on intra-state supplies, or 0.5% IGST on inter-state supplies and income-tax TDS at 0.1%. Fee rates are illustrative. These are not real PixelPearls orders, customers or settlements.

I am an accounting professional, not a Chartered Accountant or licensed tax practitioner. This lab is a demonstration of method, not a tax, filing or accounting service, and nothing here is tax advice. It is not certified or approved by GST authorities. GST explanations are summarised from official guidance (tutorial.gst.gov.in, cbic-gst.gov.in) and should be checked against the current law for any real period.

"I don't just work with numbers. I understand the systems, processes and technology behind them."