CFO Dashboard KPIs Operational: 12 Metrics for 2026

Key Takeaways

A focused set of 12 operational CFO KPIs, covering cash runway, DSO, DPO, ITC at risk, bank reconciliation lag, and bill allocation coverage, gives day-to-day control over working capital and compliance from Tally and GSTN data.
ITC at risk is the most undertracked metric; unmatched ITC blocks cash and can trigger interest under Section 50, so track it weekly, not just at month-end.
The 180-day rule can convert AP into a GST liability; invoices unpaid beyond 180 days require ITC reversal and interest, so flag items at 150 days to avoid surprises.
Bill-wise entry is non-negotiable; without bill-linked payments in Tally, DSO, DPO, and ageing reports are unreliable.
A 30-60-90 rollout, starting with cash and bank rec, then adding DSO/DPO and ITC-at-risk, and finishing with 2B reconciliation automation, prevents disruption and assigns ownership early.

CFO Dashboard KPIs Operational: The Short Answer

Every finance head knows the feeling: it is the 5th of the month, the board wants a cash update, and the numbers in the Excel file are already two weeks stale. A CFO dashboard built on operational KPIs, ones computable directly from Tally and GSTN, fixes this. The 12 metrics below cover cash runway, collections, payables, and GST exposure, each with a formula, a target guardrail, and a clear Tally data source.

Cash Runway — Months of operating expenses covered by current cash — ≥ 3 months
DSO — Average days to collect from customers — ≤ your credit terms + 10 days
DPO — Average days to pay suppliers — ≤ 45 days for MSME vendors
ITC At Risk (2B Mismatch) — Claimed ITC not yet reflected in GSTR-2B — ₹0 before GSTR-3B filing
Bank Rec Lag — Days between statement date and reconciled date — ≤ 2 business days
Bill Allocation Coverage — % of payments linked to specific bills — 100%
Creditor Ageing > 90 days — AP overdue beyond 90 days — ₹0 for MSME vendors
Debtor Ageing > 60 days — AR overdue beyond 60 days — < 15% of total AR
ITC Reversal Exposure — ITC on invoices unpaid beyond 150 days — ₹0
GST Filing Punctuality — Returns filed by due date — 100%
Working Capital Cycle — DSO + inventory days − DPO — Trending down quarter-on-quarter
Bank Balance Variance — Difference between book and bank balance — ₹0 after reconciliation

The single most common mistake is treating ITC at risk as a year-end reconciliation task. It is a weekly cash flow item, unmatched ITC blocked today is a cash outflow tomorrow if it triggers interest under Section 50.

The 12 Operational CFO KPIs Your Dashboard Should Track Now

A focused set of operational KPIs beats a 40-metric spreadsheet because each one connects directly to a decision. These 12 KPIs span cash, collections, payables, and GST, and every one is computable from Tally or GSTN.

Cash And Liquidity KPIs

Cash Runway — Divide current cash and bank balance by average monthly operating cash outflow. A runway below three months triggers a working capital review, not a board presentation.

Bank Balance Variance — The difference between your Tally bank ledger balance and the actual bank statement balance after reconciliation. Target is ₹0. Any non-zero variance means unreconciled transactions are distorting every other metric downstream.

Working Capital Cycle — DSO plus inventory days minus DPO. A cycle trending upward means you are funding your customers and suppliers at the same time. Review quarterly and investigate any upward move of more than five days.

Collections KPIs

Days Sales Outstanding (DSO) — (Trade receivables ÷ Revenue) × Number of days in the period. If your standard credit terms are 30 days and DSO is 52, you have a 22-day collection gap. Track it monthly and by customer segment.

Debtor Ageing > 60 Days — The rupee value of receivables outstanding beyond 60 days as a percentage of total AR. Target is below 15%. Above 20% is a collections process failure, not a customer relationship issue.

Payables KPIs

Days Payable Outstanding (DPO) — (Trade payables ÷ Cost of goods sold) × Number of days. Manage DPO against your credit terms. For MSME vendors, it must not exceed 45 days under Section 15 of the MSMED Act, 2006. Breaching that triggers compound interest at three times the RBI bank rate.

Creditor Ageing > 90 Days — Any AP outstanding beyond 90 days for an MSME vendor is a statutory violation. Target is ₹0. This KPI also feeds your MSME-1 filing obligation.

ITC Reversal Exposure — ITC claimed on invoices where supplier payment has not been made within 150 days of the invoice date. Monitoring at 150 days gives you a payment window before the 180-day statutory reversal becomes mandatory.

GST And Compliance KPIs

ITC At Risk (2B Mismatch) — The rupee value of ITC you have recorded in your purchase register that does not appear in your GSTR-2B for the same period. GSTR-2B is a static, auto-drafted ITC statement generated on the GSTN portal on the 14th of the succeeding month. ITC restricted under Rule 36(4) must not be claimed beyond what appears in GSTR-2B. Any mismatch above ₹0 at GSTR-3B filing time is a direct risk.

GST Filing Punctuality — Percentage of GSTR-1 and GSTR-3B returns filed by due date. Late GSTR-3B triggers late fees and 18% per annum interest on unpaid tax under Section 50.

Process And Data Quality KPIs

Bank Reconciliation Lag — The number of days between the bank statement date and the date the bank ledger in Tally is fully reconciled. Target is two business days. A lag beyond five days means your cash position numbers are guesses.

Bill Allocation Coverage — Percentage of payment vouchers in Tally linked to specific bill references. Target is 100%. This is the single data quality prerequisite for every other KPI on this list.

How To Compute Each KPI Directly From Tally (No Data Warehouse Required)

Every metric above has a direct Tally data source. Four settings must be right in Tally Prime before you pull any number.

Enable Bill-Wise Entry At Company And Ledger Level

In Tally Prime, set Maintain bill-wise details to Yes at the company level, then enable bill-wise entry in every debtor and creditor ledger. Without this, Tally cannot track which payment settles which invoice. Always use Against Reference when recording a payment to link it to an existing bill. Clear and reallocate on-account entries before any KPI run.

Map Ledger Groups And GSTIN Masters

Cash runway depends on bank and cash ledgers being under the correct group. DSO requires all customer ledgers under Sundry Debtors, DPO requires vendor ledgers under Sundry Creditors. ITC at risk requires correct vendor GSTINs in ledger masters, since GSTIN is the matching key for GSTR-2B reconciliation. Run a master audit first.

Import Bank Statements And Automate Reconciliation

Set up structured Excel or CSV import for each bank account, then import weekly. Use the Bank Reconciliation screen to match imported transactions against ledger entries. Any unmatched line becomes your bank balance variance KPI. Unreconciled entries older than two business days need immediate investigation.

Pull ITC At Risk From GSTR-2B

Download the GSTR-2B JSON from the GSTN portal after the 14th of each month. Reconcile supplier GSTIN, invoice number, invoice date, taxable value, and tax amount across your Tally purchase register and GSTR-2B. Invoices in your purchase register that do not match GSTR-2B represent unmatched ITC, your ITC at risk balance. For downloads, use the GSTN portal at gst.gov.in.

AiA plugs directly into Tally to sync ledger masters and push cleaned data back, with vendor and GSTIN validations at ingestion. DSO, DPO, and ITC at risk are computed on validated data. AiA also automates AP bill ingestion with row-level error flags, so a missing GSTIN or mismatched invoice number is caught before it distorts KPI reads.

Cadence And Targets: What You Review Daily, Weekly, Monthly

Knowing the formula is not enough. The question is: when does a deviation trigger an action versus a note?

Daily Review (5-Minute Cash Stand-Up)

Review cash and bank balance against the prior day. Any bank balance variance above ₹0 must be explained and cleared. If bank rec lag exceeds two days on any account, resolve it that day. Once imports are configured this takes under five minutes.

Weekly Review (Working Capital Meeting)

Every Monday, review DSO versus prior week and flag any debtor moving into 60-day-plus. Review ITC at risk the week after the 14th, when GSTR-2B is available. Any unmatched ITC above ₹50,000 requires a vendor follow-up that week. Review the ITC reversal exposure list and initiate payment for invoices approaching 150 days.

Monthly Review (Month-End Close)

Confirm five compliance metrics: GSTR-1 by the 11th, GSTR-3B by the 20th, ITC at risk at ₹0, bill allocation coverage at 100%, and bank rec lag at zero. If a metric is off on close day, find the root cause, do not merely note the number.

Thresholds That Force An Action

DSO — Watch Level: > credit terms + 5 days, Action Level: > credit terms + 10 days → escalate to collections
DPO (MSME) — Watch Level: > 30 days, Action Level: > 45 days → pay immediately (MSMED Act Section 15)
ITC At Risk — Watch Level: > ₹25,000, Action Level: > ₹50,000 → vendor follow-up same week
ITC Reversal Exposure — Watch Level: any invoice at 150 days, Action Level: pay supplier before 180 days → Section 16(2) CGST Act
Bank Rec Lag — Watch Level: > 2 days, Action Level: > 5 days → escalate to CFO
Bill Allocation Coverage — Watch Level: < 100%, Action Level: any on-account entry older than 7 days

Fixing Blind Spots That Make KPIs Lie (Masters, Bill-Wise, 2B, Bank Rec)

A dashboard is only as honest as the data feeding it. Four root causes drive most KPI distortions in Indian SMB Tally installs.

Duplicate And Incomplete Ledger Masters

Duplicate vendor masters split history and break DPO and GSTR-2B matching. Merge duplicates and update GSTINs in the surviving master. Missing or incorrect GSTINs cause persistent 2B mismatches even when suppliers file correctly.

On-Account Payments And Unmapped Bank Lines

On-account payments distort DSO and DPO. Rule: no on-account booking unless it is a genuine advance with a PO reference. Link every other payment to a specific bill at entry. Map every imported bank line daily, or cash balances and variance metrics will lie.

Supplier Filing Failures And ITC Leakage

If a supplier fails to report an invoice in GSTR-1, it will not appear in your GSTR-2B. You cannot claim ITC on it under Rule 36(4). Follow up with the supplier to upload or amend before your GSTR-3B filing date. Track follow-ups as a named list with supplier, invoice number, and days outstanding.

The GSTR-2B Mismatch Workflow

Bucket mismatches: (1) supplier not filed — follow up; (2) invoice in 2B but wrong GSTIN in your master — fix master; (3) genuine dispute — hold ITC claim and document. Do not file GSTR-3B until bucket-1 and bucket-2 items are resolved or consciously deferred.

AiA’s GSTR-2B reconciliation ingests GSTR-2B and your purchase register, matches invoices, and surfaces unmatched ITC with the exact suppliers causing the gap. Bank and card statement ingestion uses AI-predicted mapping so lines are allocated at entry. AiA’s WhatsApp assistant lets a designated user capture bills on the move, reducing data lag that distorts weekly KPI reads.

30-60-90 Day Rollout Plan For An SMB Finance Team On Tally

Days 1–30: Data Foundation

Audit all ledger masters, merge duplicates, add missing GSTINs, and assign the correct Tally group.
Enable bill-wise entry across the company, reallocate on-account vouchers older than 30 days to specific bills.
Set up bank statement imports for all bank accounts, and map recurring descriptions to ledgers.
Baseline two KPIs by day 30: bank rec lag and bill allocation coverage.

At turnover above ₹5 crore, e-invoicing is mandatory. Ensure Tally e-invoice integration is live before Phase 2.

Days 31–60: KPI Computation Layer

Compute DSO and DPO from outstanding reports using period averages, then baseline.
Download GSTR-2B and run the first reconciliation against the Tally purchase register, bucket every mismatch.
Build the ITC reversal exposure list, pay or document deferrals for items at 150 days.
Assign a named owner for each of the 12 KPIs.

Days 61–90: Automation And Steady State

Automate bank statement imports daily or twice weekly, so bank rec is continuous.
Automate GSTR-2B reconciliation so mismatches are available by the 16th, four days before GSTR-3B filing.
Run the first full KPI review using live data, validate against manual runs from Phase 2.
By day 90, compute all 12 KPIs within 30 minutes of request, using data no older than 48 hours.

Frequently Asked Questions

Which of these 12 KPIs should I prioritise if I am starting from scratch?

Start with bank reconciliation lag and bill allocation coverage. They are data quality KPIs, and every other metric, DSO, DPO, ITC at risk, depends on them being clean. If the bank ledger is not reconciled and payments are booked on-account, your DSO and cash runway numbers will mislead from day one. With AI Accountant, you can automate daily bank imports so rec lag trends to zero, and enforce bill-wise entry validations during voucher posting.

How do I calculate DSO if my revenue is seasonal, say Q4 peaks?

Use a rolling 90-day average: (average trade receivables over the last 90 days ÷ total revenue in that 90-day period) × 90. A trailing window smooths out seasonality better than a single month-end snapshot. AI Accountant can compute this rolling metric and segment it by customer cohort to show where collections drift versus credit policy.

What happens to DPO if some vendor payments are booked on-account in Tally?

On-account payments inflate apparent payables because Tally cannot net them against specific invoices. DPO computed on such data overstates actual outstanding, and creditor ageing misclassifies settled invoices as overdue. Reallocate all on-account entries to bill references before computing DPO. AI Accountant highlights on-account vouchers older than seven days so nothing slips through.

Can I compute ITC at risk without downloading GSTR-2B each month?

Not natively in standard Tally Prime. You must download GSTR-2B from the GSTN portal and match supplier GSTIN, invoice number, date, taxable value, and taxes to your purchase register. Manual Excel works at low volumes, but becomes unmanageable beyond ~200 invoices per month. AI Accountant automates 2B ingestion and reconciliation so the mismatch report is ready by the 16th.

How often should I run GSTR-2B reconciliation, and what is the filing dependency?

Once per month, in the week after the 14th when GSTR-2B is available. Finish reconciliation before GSTR-3B filing, typically by the 20th. Claiming ITC on invoices absent from GSTR-2B violates Rule 36(4) and risks 18% per annum interest under Section 50. AI Accountant’s scheduler ensures the reconciliation completes on time and assigns follow-ups to the owner vendor-wise.

What is a sensible DSO target for an Indian B2B SMB?

Set DSO at your contractual credit period plus a 10-day tolerance. If terms are 30 days, target 40. Sustained readings above 45 days indicate a collections process gap. Use MSME norms as an external anchor: if your customers are MSMEs breaching their 45-day obligation to you, DSO will signal it before legal escalation.

How do I fix a creditor ageing report that still shows paid invoices as outstanding?

These are typically payments posted on-account. Open each on-account voucher and reallocate using Against Reference to the correct invoice. After reallocation, the ageing report will net the payment and clear the outstanding. AI Accountant’s bill-allocation checker lists such vouchers so you can batch-fix them.

What if a supplier refuses to upload a missing invoice in GSTR-1?

Withhold further payments and document the follow-up. If the invoice is still missing at GSTR-3B filing, do not claim the ITC. Once the invoice appears in GSTR-2B, you can re-avail ITC in a subsequent period. Claiming ITC without 2B support violates Rule 36(4) and risks interest under Section 50.

What is the exact cost of missing the GSTR-3B deadline?

Late filing attracts ₹50 per day (₹25 CGST + ₹25 SGST) for returns with tax liability, plus 18% per annum interest on unpaid tax from due date to payment date. On ₹5 lakh tax delayed by 30 days, interest is roughly ₹7,500. The cash cost is avoidable with a punctuality KPI and owner assignment.

My DPO is above 45 days for some MSME vendors, what penalties apply?

Under the MSMED Act, pay within 45 days. Beyond that, interest accrues at three times the RBI bank rate, compounded monthly, and MSME-1 disclosure is mandatory. Non-filing risks Companies Act penalties. Set a DPO watch at 30 days, action at 45 days for MSMEs.

Can I re-avail ITC reversed under the 180-day rule after payment?

Yes. After paying the supplier, re-avail the reversed ITC in the GSTR-3B of the period in which you paid. Interest already paid is not refunded. Keep a clear trail of reversal period, amount, and payment date to satisfy audit queries.

What does “bill allocation coverage at 100%” mean operationally?

Every payment voucher is linked to one or more invoice references, no generic on-account entries left open. Advances are tagged as Advance and later cleared to specific invoices. This is a process discipline, not a tooling gap; AI Accountant enforces it by blocking voucher save if references are missing.

We have duplicate vendor ledgers, one with GSTIN and one without. How should we clean this?

Merge the duplicates by moving vouchers into the correct master, ensure the surviving ledger carries the correct GSTIN, then delete the duplicate. Re-run GSTR-2B reconciliation for the last three periods; previously unmatched ITC may now match because GSTIN consistency is restored.

If we cross the ₹5 crore e-invoicing threshold mid-year, what changes for ITC?

Once applicable, all B2B and export invoices must carry a valid IRN. Without IRN, invoices are invalid and recipients cannot claim ITC. Monitor turnover quarterly and activate e-invoicing in Tally before crossing the threshold to avoid 2B and ITC issues downstream.

How does a shorter working capital cycle translate into cash on hand?

A one-day DSO reduction on ₹10 crore annual revenue frees ~₹2.75 lakh. A five-day cut frees ~₹13.7 lakh. On the payables side, moving DPO from 20 to 35 days on ₹8 crore purchases retains ~₹32.9 lakh for 15 additional days. Track DSO and DPO weekly to turn these into repeatable cash gains.