// 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.
Module 03
E-commerce Settlement Reconciliation
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
What the customer paid, less discounts and refunds. Prices include GST.
Platform fees & charges
Operating expenses charged by the platform or payment gateway.
GST on platform fees
Tax charged on the operator's services. Potentially an input credit, subject to the usual conditions.
GST TCS · Section 52
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)
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.
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
Your own tax liability, reported and paid through your return. It is not a platform deduction.
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."