CFO Dashboard KPIs for Liquidity: The 2026 Playbook

Key Takeaways

Six KPIs are enough for a CFO liquidity dashboard, cash runway, net working capital days, DSO, DPO, cash conversion cycle, ITC unlock rate from GSTR-2B, and unreconciled bank items, consider wiring them into a weekly cadence with a CFO liquidity dashboard.
ITC timing is a cash flow variable, not just a compliance task, ITC can be availed only for invoices visible in GSTR-2B and wrongly availed ITC attracts 18% interest, tracking the ITC unlock rate recovers cash faster.
Section 43B(h) makes AP ageing a tax exposure, not just a vendor relationship issue, MSME invoices unpaid beyond 45 days are disallowed in the incurring year and deductible only on actual payment.
Drawing Power caps usable working capital, not just bank limits, DP is a margin-adjusted value of eligible inventory and receivables, higher DSO shrinks DP even when gross receivables rise.
Unreconciled bank items are an early warning signal, not housekeeping, more than five entries older than seven days indicates data integrity problems that will corrupt every other KPI.

CFO Dashboard KPIs For Liquidity: The Short Answer

Your suppliers are stacking up invoices, collections are sliding past 60 days, and your founder wants a runway number by Monday morning. The average Indian SMB CFO is managing this with a mix of Tally reports, WhatsApp messages, and a spreadsheet nobody fully trusts.

A CFO liquidity dashboard does one job, tell you whether cash holds this month and what to pull to fix it if not. The minimum viable set is six KPIs, cash runway, net working capital days, DSO versus DPO gap, cash conversion cycle, ITC unlock rate from GSTR-2B, and unreconciled bank items. Each can be computed directly from Tally and your bank statement. Wire them into a Monday cadence and you stop reacting to surprises.

Cash Runway — Cash balance ÷ average weekly cash burn, weeks of operating buffer.
Net Working Capital (NWC) Days — (Receivables + Inventory − Payables) ÷ (Revenue ÷ 365), net capital tied in operations.
DSO — (Closing debtors ÷ Revenue) × 365, collection speed.
DPO — (Closing creditors ÷ COGS) × 365, payment timing leverage.
Cash Conversion Cycle (CCC) — DSO + DIO − DPO, full working capital cycle.
ITC Unlock Rate — ITC in GSTR-2B ÷ ITC in purchase register, cash trapped versus available.
Unreconciled Bank Items — Count of entries older than seven days, data integrity signal.

DIO, Days Inventory Outstanding, equals closing inventory ÷ COGS × 365.

The most common mistake is tracking DSO and DPO in isolation. The gap between them, DSO minus DPO, is the number that tells you whether you are financing your customers or your vendors are financing you. A positive gap means you are funding the difference from your own cash.

What KPIs Belong On A CFO Liquidity Dashboard In 2026?

The six liquidity KPIs above are the minimum viable set for an Indian SMB managing cash in FY 2025–26. Each addresses a distinct cash drain.

Cash Runway And Net Working Capital Days

Cash runway answers the founder’s question directly, how many weeks does cash last at current burn. Calculate it weekly using closing bank balance divided by the seven day rolling average of net cash outflows. If runway drops below four weeks, every other KPI becomes secondary.

NWC days converts the balance sheet into a single operating number. For a trading business running ₹5 crore in revenue, NWC days of 60 means ₹82 lakh is permanently locked in the operating cycle. Reducing NWC days by 10 frees approximately ₹14 lakh, money that reduces your overdraft draw and cuts interest cost.

DSO, DPO, And The Gap That Matters

DSO and DPO are the two levers inside NWC days. A DSO of 55 against a DPO of 30 means your gap is 25 days. At an SME borrowing rate linked to MCLR plus spread, typically 11 to 14% per annum for FY 2025–26 based on RBI lending rate data, 25 days on ₹1 crore of revenue translates to roughly ₹75,000 to ₹1,00,000 per year in unnecessary interest cost.

DPO must be read against your MSME vendor base. Under Section 43B(h) of the Income Tax Act, effective 1 April 2024, any payment to a micro or small enterprise delayed beyond 45 days under the MSMED Act, 2006 is disallowed in the incurring year. You recover the deduction only in the payment year. Stretching DPO above 45 days on MSME invoices is not a working capital gain, it is a deferred tax liability.

ITC Unlock Rate As A CFO Liquidity KPI

ITC sitting in your purchase register but not in GSTR-2B is blocked cash. Under Section 16(2)(aa) of the CGST Act, 2017, ITC is available only for invoices that appear in GSTR-2B. GSTR-2B is generated on the 14th of each succeeding month and is static, it reflects only what your supplier has uploaded to GSTR-1 before the cut off.

Track ITC unlock rate as, total ITC in GSTR-2B divided by total ITC in your purchase register for the same period. An unlock rate below 90% signals either supplier non compliance or data mismatches. Every percentage point below 100% is cash you cannot yet offset against output GST. If a supplier’s GSTR-1 is consistently unfiled, escalate or switch, the ITC is not just delayed, it may never arrive.

How To Compute Each CFO Dashboard KPI Directly From Tally

Tally holds all the raw data needed for these CFO dashboard KPIs, the work is mapping the right report to the right formula.

Cash Runway From Tally

Go to Gateway of Tally → Cash or Bank Books. Set the date range to the last seven days. Sum net outflows, debits minus credits on your operating accounts. Divide closing cash balance by the daily average to get days of runway.

The weakness, this includes salary and GST outflows that are lumpy. Separate recurring monthly fixed outflows from variable. A simple check is, if runway on variable cash burn alone exceeds 30 days, you have a reasonable buffer. If fixed plus variable runway is under 21 days, that is a trigger for immediate action.

DSO And DPO From Tally Outstanding Reports

Gateway of Tally → Display → Statements of Accounts → Outstandings → Receivables. Set the ledger filter to all sales ledgers. Export to Excel. DSO equals the sum of invoice amount times days outstanding divided by total revenue for the period, a weighted average that is more accurate than a simple ratio.

For DPO, use the Payables report with the same logic. Tally’s bill wise detail feature, enabled at the ledger level by switching “Maintain balances bill by bill” to Yes, gives you each invoice’s due date and outstanding amount. Without bill wise details enabled, the ageing report aggregates by ledger and loses granularity.

Enable bill wise details at ledger level, Gateway of Tally → Accounts Info → Ledgers → Alter → set “Maintain balances bill by bill” to Yes. Do this for every debtor and creditor ledger. Without it, your DSO and DPO calculations are approximate at best.

Cash Conversion Cycle In Tally

CCC equals DSO plus DIO minus DPO. DIO requires the stock summary. Gateway of Tally → Display → Inventory Books → Stock Summary. Closing stock value divided by COGS multiplied by 365 gives DIO. COGS comes from the Trading Account under Profit and Loss.

One worked example, DSO 52 days plus DIO 28 days minus DPO 38 days equals CCC 42 days. On ₹3 crore annual revenue, 42 CCC days means approximately ₹35 lakh is locked in the operating cycle at any point. Reducing CCC to 32 days frees roughly ₹8 lakh, a direct reduction in working capital borrowing.

Unreconciled Bank Items From Tally Bank Reconciliation

Gateway of Tally → Banking → Bank Reconciliation. Set the statement date to today. All transactions in the Tally cash book that do not have a matching bank date are unreconciled. Export the report and count entries older than seven days. This count is your unreconciled bank items KPI.

Businesses with turnover above ₹5 crore must generate e invoices under CBIC’s phased mandate, effective 1 August 2023, which means AP data flows into Tally faster and reduces reconciliation lag. Below ₹5 crore, daily bank statement imports are the primary discipline.

AiA’s bank and credit card statement ingestion pulls statements directly into the reconciliation workflow, matches transactions against Tally ledger entries, and surfaces unmatched items by age, eliminating the manual export and compare step. With 300M plus transactions processed across 450 plus SMB customers, the matching logic handles Indian bank statement formats without manual column mapping.

What Targets Should Indian SMB CFOs Set For These KPIs In 2026?

Target ranges for liquidity KPIs depend on business model. A trading company, a manufacturer, and a services firm have structurally different NWC profiles.

DSO And DPO Target Ranges By Business Model

For a trading business in FY 2025–26, DSO above 45 days signals collection risk. Most FMCG and consumer goods distributors run DSO between 30 and 50 days depending on channel. Manufacturing SMBs can sustain DSO up to 60 days if they have matching DPO, but a DSO minus DPO gap above 20 days is a warning sign.

Services businesses should target DSO below 30 days. Milestone based billing with 30 day payment terms is achievable and common among IT services and professional services SMBs. DSO creep in services usually means milestone disputes or poor invoice discipline, both are operational fixes, not market realities.

DPO for MSME vendors is hard capped at 45 days by the MSMED Act, 2006 and Section 43B(h) of the Income Tax Act. For non MSME vendors, DPO of 30 to 45 days is a reasonable target. Stretching to 60 days on non MSME vendors is possible but carries relationship risk if those vendors are key suppliers.

Cash Conversion Cycle Targets

A CCC below 45 days is a sound target for most Indian SMB manufacturers and traders in FY 2025–26. Services businesses should target CCC below 20 days, since they carry minimal inventory. A CCC above 90 days means over a quarter of annual revenue is permanently tied up in the operating cycle, this is the level at which working capital borrowing becomes a structural need rather than a cyclical one.

RBI’s working capital assessment under the Master Circular on Loans and Advances (July 2015) uses Drawing Power based on eligible inventory and receivables minus bank stipulated margins. A bank applying 25% margin on inventory and 30% on receivables will compute DP on ₹100 lakh inventory and ₹50 lakh receivables as ₹110 lakh, not ₹150 lakh. If your receivables inflate because DSO is high, your DP constraint tightens, even if the credit limit has not changed.

ITC Unlock Rate And Runway Targets

Target ITC unlock rate above 95% each month. An unlock rate below 90% over two consecutive months means at least one significant supplier is a filing risk. For cash runway, four weeks is a minimum operating buffer. Below two weeks, discretionary capex and non critical vendor payments should pause.

What Weekly Cadence Keeps These Liquidity KPIs Green?

The financial KPIs above become useful only with a consistent review rhythm. A weekly cadence converts metrics from retrospective scorecards into forward looking controls.

The Monday Morning Liquidity Check

Monday morning, the CFO or finance head reviews three numbers, cash runway, unreconciled bank items count, and the DSO minus DPO gap versus last week. These three tell you whether the week starts with a problem or a baseline.

If runway has dropped by more than half a week since last Monday, identify the cause before any discretionary payment goes out. If unreconciled items are above five, the bank rec team has a same day clearing task. If the DSO minus DPO gap has widened by more than three days week on week, collections need an escalation call.

The 14th And 20th GST Rhythm

Two fixed monthly dates anchor the GST cash flow rhythm. GSTR-2B is generated on the 14th of each succeeding month. Reconcile your purchase register against GSTR-2B between the 14th and 18th, this is the optimal window before GSTR-3B is due on the 20th.

Any ITC mismatch identified by the 18th can either be escalated to the supplier for a GSTR-1 amendment or excluded from the current month’s ITC claim to avoid interest risk. Section 50 of the CGST Act charges 18% per annum on wrongly availed ITC. A mismatch of ₹5 lakh held incorrectly for 30 days costs approximately ₹7,500 in interest, small individually, but compounding across multiple suppliers.

GSTR-3B filed after the 20th attracts late fees under Section 47 of the CGST Act. For businesses with turnover above ₹5 crore, the late fee cap is ₹10,000 per return, ₹5,000 CGST plus ₹5,000 SGST. For turnover between ₹1.5 crore and ₹5 crore, the cap is ₹5,000. For turnover up to ₹1.5 crore, the cap is ₹2,000. The 18% interest on unpaid tax has no cap.

Wednesday Payables And Thursday Collections

Wednesday is the AP review day. Check the MSME payables ageing, any invoice from a micro or small enterprise approaching 40 days needs a payment scheduled before the 45 day trigger. Non MSME payables approaching 60 days get reviewed for DPO impact.

Thursday is collections. Pull the receivables ageing from Tally. Any invoice above 45 days outstanding gets a direct call or message, not an email. Weekly follow up on overdue invoices typically compresses DSO by 7 to 10 days within a quarter for most SMBs.

AiA’s GSTR-2B reconciliation runs the match between your purchase register and GSTR-2B automatically, flags mismatches by supplier, and queues them for review, so the 14th to 18th window becomes a 30 minute review task rather than a half day manual exercise. The WhatsApp assistant handles daily nudges for pending entries and lets the team forward bill images directly into the queue, keeping the AP ledger current between formal weekly reviews.

What Must Be Automated To Keep CFO KPI Data Trustworthy?

Manual data entry is the primary source of KPI drift. The output of the five KPIs above is only as reliable as the data feeding them.

Bank Statement Ingestion And Reconciliation

Manual bank reconciliation in Tally requires the finance team to match each bank statement line against a Tally ledger entry. For an SMB processing 200 to 400 transactions per month across two or three bank accounts, this is a weekly task that takes several hours and produces errors when postings are done in bulk at month end. Unreconciled items older than seven days corrupt cash runway calculations, because the closing bank balance in Tally diverges from the actual bank statement.

Automating bank statement ingestion, pulling statement files directly into the reconciliation layer and auto matching against existing Tally entries, cuts this to a daily clearing task and keeps the unreconciled items count near zero throughout the month.

AP Data Entry And Bill Allocation

DPO accuracy depends on every vendor invoice being posted with a bill reference on the date of receipt. An invoice posted late or without a bill reference distorts payables ageing and DPO. For businesses below the ₹5 crore e invoicing threshold, which mandates e invoice generation for B2B transactions above ₹5 crore aggregate turnover, per CBIC notifications effective 1 August 2023, AP data entry is manual and error prone.

Bill wise allocation, linking each payment to the specific invoice it settles, is the second automation priority. Without it, DPO shows incorrect ageing because partial payments against multiple invoices get posted as on account entries and age from the payment date rather than the invoice date.

ITC Reconciliation Automation

The GSTR-2B reconciliation step, matching each purchase register line to its GSTR-2B counterpart, is the most compliance critical automation. A manual reconciliation on 300 invoices per month takes two to four hours and misses matches when invoice numbers have minor discrepancies between supplier uploaded and buyer recorded formats.

Automated reconciliation identifies exact matches, near matches, same GSTIN and amount with minor invoice number variations, and mismatches, invoice not in GSTR-2B at all. Separating these three categories is what allows the 14th to 18th action window to work, mismatches get supplier escalation, near matches get manual confirmation, and exact matches auto populate into the ITC claim.

Frequently Asked Questions

Which CFO liquidity KPI should I check first if cash is tight this week?

Cash runway is the immediate check, it tells you how many weeks of buffer remain at current burn. Once you know the runway number, DSO and ITC unlock rate tell you where the fastest cash recovery is possible. If DSO is high, accelerate collections. If ITC unlock rate is below 90%, follow up with suppliers whose GSTR-1 is unfiled, because that is blocked cash you can recover in the next GSTR-2B cycle.

Does DPO above 45 days always trigger Section 43B(h)?

Section 43B(h) applies only to payments owed to micro or small enterprises as classified under the MSMED Act, 2006. Payments to medium enterprises and non MSME vendors are not covered. However, compound interest at three times the RBI bank rate applies to all MSME payment delays under the MSMED Act. Verify your vendor’s MSME registration status before stretching DPO beyond 45 days.

What is the difference between DSO and cash conversion cycle for a CFO dashboard?

DSO measures only the collection side, how many days on average it takes to collect payment after a sale. CCC is the full picture, CCC equals DSO plus DIO minus DPO. A business can have a low DSO of 30 days but a high CCC of 75 days if inventory sits for 60 days and DPO is only 15 days. For a liquidity dashboard, both matter, DSO flags collection speed, while CCC tells you total cash tied up in operations.

My supplier filed GSTR-1 late and my ITC is not in this month’s GSTR-2B. What are my options?

ITC can only be availed for the period in which it appears in GSTR-2B under Section 16(2)(aa) of the CGST Act, 2017. If a supplier filed GSTR-1 after the GSTR-2B cut off for a given month, the ITC will appear in the next month’s GSTR-2B. You can avail it then without penalty, provided it is before the November 30 deadline of the succeeding financial year and before annual return filing. Do not claim ITC in the current month’s GSTR-3B if it is absent from GSTR-2B, Section 50 charges 18% per annum interest on wrongly availed ITC.

How do I calculate Drawing Power and does it affect my liquidity KPIs?

Drawing Power is calculated as eligible inventory times one minus inventory margin plus eligible receivables times one minus receivables margin, per RBI guidance. With a 25% margin on ₹80 lakh inventory and 30% margin on ₹40 lakh receivables, DP equals ₹60 lakh plus ₹28 lakh equals ₹88 lakh. DP directly caps accessible liquidity, if DSO rises and bloats receivables beyond what the bank counts as eligible, DP can fall even though gross receivables are higher.

What is the penalty if I pay an MSME vendor beyond 45 days?

Two consequences apply. Under the MSMED Act, 2006, compound interest at three times the RBI bank rate, compounded monthly, is payable to the supplier after day 45. Under Section 43B(h), the expense is disallowed in the incurring year and deductible only on actual payment. This increases taxable income now and defers the deduction to the payment year.

How do I check if my ITC unlock rate is healthy before filing GSTR-3B?

Download GSTR-2B for the period, export your purchase register from Tally for the same period, then compute ITC unlock rate equals GSTR-2B ITC divided by purchase register ITC. Above 95% is healthy. For invoices missing in GSTR-2B, identify the supplier by GSTIN, confirm GSTR-1 filing status, and either follow up or exclude from the current ITC claim to avoid Section 50 interest.

Can I set a single CCC target for both manufacturing and trading divisions?

No. Manufacturing and trading have different DIO profiles. Manufacturing holds RM, WIP, and FG, DIO can be 45 to 60 days. Trading holds mostly FG and may run DIO below 20 days. Track DSO, DIO, DPO, and CCC separately by division using cost centres or separate companies in Tally, then set targets by division.

What happens to my cash runway calculation if I have unreconciled bank items?

Unreconciled items distort runway because Tally’s closing balance differs from the actual bank balance. If ₹8 lakh in vendor payments are posted in Tally but not yet cleared in the bank, Tally shows less cash than the bank, understating runway. Deposits in the bank but not in Tally do the opposite. Reconcile daily or weekly and use the lower of the two balances as the conservative runway input.

Which three KPIs should an early stage SMB prioritise if it can track only three?

Cash runway, DSO, and ITC unlock rate. Runway determines survival horizon. DSO is the fastest lever for improvement through focused collections. ITC unlock rate protects cash that is legally yours but can be trapped if supplier compliance is weak. Once these stabilise, add DPO for MSME compliance and unreconciled bank items for data integrity.

How do I enable bill wise details in Tally for accurate DSO and DPO?

In Tally, go to Gateway of Tally → Accounts Info → Ledgers → Alter for each debtor or creditor ledger, set “Maintain balances bill by bill” to Yes. This enforces bill references on entries and makes the Outstandings report invoice level, which is essential for accurate DSO and DPO.