Menu

Customer Portfolio Review

Last reviewed: 16 November 2026

On this page
  1. The problem
  2. The solutions
  3. Why GGA
  4. The checks GGA runs across every customer
  5. What GGA would do
  6. What we need from you
  7. How you stay in control
  8. Questions

Direct answer. A customer portfolio review reads every credit customer at once and answers one question: where should management's attention go first? It sets exposure against limits, finds concentration and slowing payers, and names the few customers that need a full credit review. The trap: reading the book by ageing alone, which shows how old money is, not which decision is due.

GGA India at a glance — counterparty intelligence

  • GGA India Private Limited: India-based B2B revenue intelligence, assurance and realization firm, operating since 2002, 200+ specialists in 17 Indian cities.
  • Checks new and existing customers, dealers and vendors at three levels — Desk, Extended Desk and Site Verification — matched to the size of the exposure.
  • Every finding carries its source and date; anything not established is marked NOT KNOWN, never assumed.
  • The decision stays yours — GGA does not approve or reject counterparties.
  • Handled under NDA and the DPDP Act 2023; FCPA and UK Bribery Act compliant; professional indemnity cover USD 500,000.
  • Write to gg@ggaindia.co.in — a named specialist replies within one working day.

One customer and one limit decision in front of you? That is an Existing Customer Credit Review. This page covers the whole customer book.

The problem: the ageing report shows how old the money is, not where the risk sits

A book of several hundred credit customers rarely fails in one place; it fails in five or six places at once, and the monthly ageing shows almost none of them.

The ageing sorts balances into time buckets. Its statutory form, the Schedule III trade receivables schedule, groups balances by time since the due date — under six months, six months to a year, one to two years, two to three years, over three years — and splits disputed from undisputed. That serves the balance sheet and the auditor. It does not tell the credit committee which customer is getting slower, which one sits above its limit, or which fifteen names carry half the exposure.

Exhibit 1: What a whole-book view finds that an ageing report does not

What sits in the book Why the ageing hides it What it costs if missed
Concentration Balances are grouped by bucket, not by name or group One large failure moves the quarter's results
Exposure above limits Over-limit dispatches are approved one at a time and never totalled Credit nobody signed for, spread across many accounts
Payment-day drift A slower customer still shows as "current" or one bucket late The book's funding need rises before any balance looks old
Policy gaps Customers with no limit, no credit period, or a limit set years ago have nothing to be measured against No basis to say an account is out of line
Group exposure Related companies buy under separate codes, each within its own limit The combined exposure was never approved
Unreliable data Split codes, unapplied receipts and netted credit notes distort every figure Wrong customers flagged; the right ones missed

The arithmetic of drift is quiet. Illustrative, not client data: eighteen customers buy ₹6 crore a month between them. At 58 days to payment they hold ₹11.6 crore of your credit. At 81 days they hold ₹16.2 crore. The extra ₹4.6 crore costs about ₹55 lakh a year to fund at 12%, and no one approved it. The book-level average can barely move while this happens, if hundreds of smaller customers pay a little faster.

Age then turns drift into loss. In GGA's published research, collection rates fall from over 95% of value for invoices up to three months old to about 10% beyond three years, counted from the invoice date (collection outcomes by invoice age). The figures cover GGA's own engagements and forecast no single book. The point for a portfolio is timing: the customers that matter need to be found while their invoices are still young.

The solutions: eight ways to watch a customer book, and what each leaves to you

Most companies need several of these; the question is which one tells management where to look.

Exhibit 2: Options for reviewing a whole customer book

# Option What it does well What it leaves to you When it is the better choice
1 Your credit team's monthly ageing and overdue meeting Knows the accounts; acts on what is already late Trends, concentration, over-limit totals, changes outside the ledger, data cleaning A small book where a few customers carry most of the exposure
2 Sales or account managers' judgement Early soft signals: a buyer who has gone quiet, a plant running short shifts Consistency, and a measure that does not depend on the next order As an input to every review, never as the review
3 ERP dashboards, AR software or an outsourced AR (BPO) team Utilisation, DSO and ageing at speed; reminders at volume Rules are only as good as the customer master; flags volume, not decisions High-volume books with clean master data
4 Company-information or bureau reports and alerts on top names Outside change: charges, filings, cases, ratings; bureau history with consent Your own trading history; cost rises with every name; no ranking of the book Confirming nothing public has changed on the largest customers
5 Credit insurance The insurer sets buyer limits and pays the insured share of a covered loss The uninsured share; the insurer may cut limits when a buyer weakens A few large customers whose failure would hurt the balance sheet
6 Factoring or TReDS Turns eligible invoices into cash; TReDS is open to MSME sellers and is without recourse to them Which customers need a review; invoices outside the programme A working-capital need, not a risk-ranking one
7 Conventional collection agency or law firm Acts on accounts already in default Everything before default A customer has stopped paying — see customer not paying your invoice
8 GGA Customer Portfolio Review Every customer read from one data upload; exceptions with reasons; shortlist for deeper review The approval of every limit and term A book too large for one person to know; before a policy reset; after fast growth

What you can do this week

  1. Export one file with customer code, name, GSTIN or PAN, limit, credit period, and twelve month-end outstanding balances.
  2. Merge codes that share a GSTIN or PAN. Count how many customers disappear; that number is your data-quality warning.
  3. Sort by current exposure and note how many customers make up 50% and 80% of the total.
  4. For the top 30, write two numbers: the highest month-end balance against the limit, and actual payment days in the last six months against the six before.
  5. List every customer with no limit or no credit period.
  6. Pick the five that fail two tests for a full review, each with a named owner and a date. Triggers and frequency are set out in how often to review credit limits.

Why GGA: one upload, every customer read, attention sent where it changes a decision

An attention map, not a scorecard. A portfolio review is not a score for each customer. It is an attention map that tells management which relationships need policy action, independent validation or closer monitoring, and why.

How the book is read. GGA maps your data, groups transactions by a stable customer ID, finds the behavioural exceptions and builds a management view with drill-down to each account. Unknown or unstable fields stay visible, because confidence in the result depends on confidence in the input. The work follows the principles in the methodology: evidence before opinion, materiality before volume, contradiction control, and NOT KNOWN where a fact cannot be established.

Not every overdue customer is a credit risk. A process delay, a disputed balance, a temporary change in behaviour and a deteriorating counterparty each need a different response. The review records which one the evidence supports, and the limits created by missing or inconsistent data.

Exhibit 3: The six views management sees

View What it shows
Portfolio scale Customers analysed, total outstanding, concentration
Normal relationships Customers operating within observed or policy ranges
Attention required Payment deterioration or abnormal exposure
Policy alignment Limits above policy, below normal requirement, or not defined
Evidence sufficiency Short history or unstable identifiers
Targeted validation Material customers or exceptions that warrant outside evidence

The output comes in three layers. 30 seconds — the answer: the GGA View on the book and the shortlist. Illustrative only, not a client case: "Twelve customers hold 46% of exposure; four of them have slowed by more than two weeks in two quarters, and two sit above their limits. View: run a full credit review on these four before the next limit cycle; set limits for the 37 customers that have none. Group links for three customers NOT KNOWN." 5 minutes — the case: concentration, exposure against limits, payment-day movement, policy gaps and outside signals on the material names. Reference — the proof: an Excel management and action file listing every customer with its exception, reason and evidence, plus individual drill-down reports and the data-mapping note. Where you have an adopted credit policy, GGA can apply it across the book and show indicative limits with their basis; your authorised team approves them. See the executive-summary examples and, for the classing logic GGA publishes, the debtor scoring method.

Portfolio review or Existing Customer Credit Review?

Exhibit 4: Two services, two questions

Customer Portfolio Review Existing Customer Credit Review
The question Which customers need attention, and what kind? Should this customer's limit and terms be kept, raised, cut or re-shaped?
Scope The whole book, or a defined segment One customer and its group
Evidence Your data for every customer; outside checks only on material names and exceptions Your 12–36 months for that customer, tested against outside evidence
Output Attention map, exception register, Excel action file, drill-downs Executive summary with the GGA View and, under your policy, an indicative limit
Typical trigger Policy reset, fast sales growth, overdue concentrating, a new CFO A limit request, slower payment, a public notice

The two connect. Accounts flagged by the portfolio move into an Existing Customer Credit Review. A new name joining the book goes to Customer Intelligence. Invoices found stalling in customers' approval chains can be owned from submission by Revenue Assurance; money already late moves to Revenue Realization, with the evidence already gathered. If the overdue book itself is the worry, start with the complimentary Receivables Position Review.

The checks GGA runs across every customer

Each check produces an exception only where it could change a decision.

Exhibit 5: Portfolio checks — data used, what an exception looks like, where it leads

Check Data used What an exception looks like Usually leads to
Identity and grouping Customer master, GSTIN, PAN, group details One customer under several codes; related companies each within limit, together above A group limit decision
Concentration Month-end exposure by customer and group A rising share held by the top names Exposure cap, security or insurance review
Exposure against limit Limit file and month-end peaks Peak above limit; utilisation above 90% for several months Limit review
Payment days Invoice and receipt dates, value-weighted Last six months slower than the customer's own longer pattern Existing Customer Credit Review
Shadow Credit Contract period against actual days Extra days taken but never approved A terms decision
Overdue pattern Open invoices, disputes, deductions Old invoices left open while new ones are paid Dispute resolution or late-payment risk work
Buying trend Monthly sales Buying falls sharply while the balance stays Exit-risk check
Policy gaps Limit and period fields, approval dates No limit, no period, or an approval years old Policy action
Outside signals on material names MCA records, GST filing, eCourts, NCLT, IBBI, ratings; bureau data with consent New charge, filing gaps, a creditor's petition Independent validation
Evidence sufficiency History length, code stability Under twelve months of data; broken identifiers NOT KNOWN; closer monitoring

What GGA would do

Your data first, outside evidence only where it matters, and a shortlist at the end. The labels show the order of work, not a promised timetable.

  1. Day 1: agree the population and the decisions. Which customers, which segments, the policy in force. You receive: a data request with field definitions and the gaps already visible.
  2. Days 2–5: map and normalise. Stable customer IDs, receipts matched to invoices, credit notes, disputes and tax deductions separated. You receive: a data-quality note stating what was used, what was excluded and why.
  3. Week 2: run the portfolio checks. You receive: the attention map and exception register; any customer already at risk is flagged to you at once.
  4. Weeks 2–3: validate the material exceptions. Desk evidence on the names that matter; a questionnaire or site visit only where you agree. You receive: sourced, dated findings that support or contradict what the data shows.
  5. Week 3: the management output. You receive: the 30-second answer, the 5-minute case, the Excel action file and the shortlist for full review.
  6. Month 2 onwards, if you choose: re-run on fresh data with the same definitions. You receive: movement since the last run, and which exceptions closed.

What we need from you

To start

  • Approximate number of credit customers and total outstanding
  • The latest ageing report
  • Whether you have a written credit policy, and what prompted the review

To act

  • 12, 24 or 36 months of invoices, receipts and credit notes
  • Customer master with GSTIN, PAN and known group links
  • Limits and credit periods, with approval dates
  • Open disputes and deductions
  • Security register: guarantees with expiry dates, deposits, cheques
  • The customer's consent for bureau data on any name selected for deeper checks

Missing some of these? Send what you have — telling you what is missing is part of the first reply.

How you stay in control

The review ranks where attention goes; your credit committee decides what happens.

  • Every limit, term and relationship decision stays with your authorised team. GGA neither approves nor rejects a customer and does not set your credit policy.
  • A portfolio review runs on your ledger and public records. No customer is contacted or visited except in the way you have agreed.
  • Bureau data on any customer is drawn only with that customer's consent.
  • Each exception shows its data source and the date of each outside fact; fields that are missing or unreliable are marked NOT KNOWN, never filled by estimate.
  • Your customer data stays under NDA and the DPDP Act 2023, seen only by those who need it.
  • If the data shows a material red flag — an insolvency filing, a sudden stop in receipts from a large customer — you hear about it immediately, not in the final file.

Send us your number of credit customers, total outstanding and the latest ageing report, and the decision the review must support. Within one working day a named GGA specialist replies with what we would check first and what is missing from the file — no charge, no obligation. gg@ggaindia.co.in

Checking an overseas buyer? See the Global Receivables Desk. An overseas company checking an Indian counterparty? See India counterparty due diligence.

Frequently asked questions

What is a customer portfolio review?

A review of many existing customer relationships from one data upload. It shows concentration, exposure against limits, payment-day movement and policy gaps across the book, and names the customers that need deeper review, policy action or closer monitoring.

How is it different from an Existing Customer Credit Review?

The portfolio review decides where attention goes across all customers. The Existing Customer Credit Review decides one customer's limit and terms in depth. Most books need the first to choose candidates for the second.

Does GGA check every customer externally?

No. Outside evidence is applied to all customers, to selected material customers, or only to the exceptions, as agreed. Buying full due diligence on every name wastes money and attention.

Does each customer get a credit score?

No. GGA is not a rating agency. Each customer is placed in an exception category with its reason and evidence, rather than given a number presented as certainty.

Can the review set credit limits for the whole book?

Where you have an adopted credit policy, GGA applies it to each customer's actual behaviour and shows the indicative limit and its basis. Your authorised team approves. Without a policy, the review shows observed exposure as evidence for setting one.

How long does it take, and what does it cost?

It depends on the number of customers, data quality and how many names need outside checks. GGA confirms data, scope and fee before work begins, and tells you in the first reply which fields it needs.

Related: why review existing customers · Revenue Intelligence · all due-diligence guides

Sources

This page summarises the position as at 8 November 2026. Portal features, rules and thresholds change; check the current position before relying on any single source.

Email GGA gg@ggaindia.co.in