Pharma & Life Sciences
Reconciliation for pharmaceutical companies, distributors, and CROs
Reconciliation in Pharma & Life Sciences
Pharmaceutical companies in India sell through a tiered distribution network: stockists → distributors → retailers → patients, with each tier carrying credit terms, trade scheme entitlements, and return policies. The accounts receivable function must track outstandings across 2,000–10,000 stockists simultaneously, reconcile credit notes for trade schemes (scheme discounts, free goods, expiry returns, rate differences), and manage TDS under Section 194Q on purchases above ₹50 lakh. CROs (contract research organisations) additionally handle milestone billing against research agreements with Section 194C TDS. The result is one of the most complex receivables environments in Indian industry.
Where reconciliation breaks down
These are the structural problems that generic tools cannot solve for Pharma & Life Sciences businesses.
Stockist outstanding reconciliation
Stockists carry 30–60 day credit and pay through a combination of post-dated cheques, NEFT, and NACH. Partial payments, credit note adjustments, and scheme deductions mean that most remittances do not match any individual invoice — requiring multi-invoice aggregation with tolerance logic.
Trade scheme credit note accounting
Pharma trade schemes generate multiple types of credit notes: scheme discount (margin on sales threshold), free goods credit, expiry return credit, and rate difference credit. Each type has different GST treatment (scheme discount: GST reversal required; free goods: no GST). Reconciling credit notes against the correct invoice — and applying the correct GST treatment — is a specialist reconciliation task.
TDS on pharmaceutical purchases (Section 194Q)
Buyers (hospital chains, large pharmacy chains) who purchase above ₹50 lakh per year must deduct TDS at 0.1% under Section 194Q. Pharma companies must reconcile TDS deductions against Form 26AS and track credit — a new compliance flow since FY 2021-22.
CFA settlement reconciliation
C&F (Carrying and Forwarding) agents hold stock on behalf of pharma companies and disburse to the distribution chain. CFA accounts must be reconciled monthly: goods dispatched vs invoices raised vs collections received vs stock in hand.
How TransactIG solves this
TransactIG is built by Terra Insight with pharma & life sciences-specific configuration, not generic matching logic.
Stockist payment matching with credit note netting
TransactIG matches partial payments and NACH credits against open invoice balances, netting off credit notes automatically — producing a clean outstanding statement per stockist.
Trade scheme credit note classification
Credit notes are classified by scheme type (discount, expiry, free goods, rate difference) with the appropriate GST treatment applied per type — ensuring accurate GST reconciliation and ITC reversal where required.
Section 194Q TDS tracking
TDS deducted by large buyers is tracked per buyer, reconciled against Form 26AS, and reported quarterly for advance tax credit computation.
Reconciliation patterns
Configuration presets
No custom development
These presets are included with every Pharma & Life Sciences deployment of TransactIG. Go live in 2–4 weeks.
Frequently asked questions
How does TransactIG handle a stockist payment that covers 8 invoices with 3 credit note deductions?
The multi-invoice aggregation pattern matches the remittance against open invoices and nets off qualifying credit notes — producing a matched ledger entry with invoice-by-invoice allocation detail.
Can TransactIG differentiate between a scheme discount credit note and an expiry return credit note for GST purposes?
Yes. Credit notes are classified by type at ingestion. The GST treatment rule is applied per type — scheme discount credit notes trigger GST reversal; expiry return credit notes follow a different rule based on the return policy.
We operate across 18 states with different distributors per state. Can TransactIG handle all of them?
Yes. TransactIG supports unlimited distributor and stockist accounts, with state-wise segmentation and zone-level roll-up reporting.
Does TransactIG integrate with SAP for pharma ERP data?
Yes. TransactIG has pre-built SAP SD integration for sales invoice data and SAP FI integration for payment matching. Custom field mappings for pharma-specific SAP configurations are supported.
Ready to automate Pharma & Life Sciences reconciliation?
Terra Insight will walk you through a live TransactIG demo using pharma & life sciences transaction data — matching patterns, variance taxonomy, and ERP integration.