Customer Portfolio Review
On this page
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
- Export one file with customer code, name, GSTIN or PAN, limit, credit period, and twelve month-end outstanding balances.
- Merge codes that share a GSTIN or PAN. Count how many customers disappear; that number is your data-quality warning.
- Sort by current exposure and note how many customers make up 50% and 80% of the total.
- 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.
- List every customer with no limit or no credit period.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
- Schedule III amendments effective 1 April 2021: trade receivables and payables ageing (TaxGuru)
- RBI FAQs: Trade Receivables Discounting System (TReDS)
- GST portal: Search Taxpayer user manual
- TransUnion CIBIL: company credit report FAQ
- IBBI public announcements
- GGA research: collection outcomes by invoice age
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.