🇮🇳 Built for SME Finance Teams

Your AR data is in Excel.
Your insights shouldn't be.

CollectIQ turns your accounts receivable spreadsheet into a live intelligence dashboard — DSO tracking, credit scoring, interest engine, ageing buckets, and payment reminder drafts. Runs 100% on your machine.

Get CollectIQ Pro — $39 → Download Free Lite
✓ No cloud. No login.
✓ One-time payment
✓ Windows & Mac
CollectIQ v1.0
Overview
Customers
Interest
Ageing
Analytics
06 Aug 2026
Total Outstanding
$5.0M
35.9% of billed
Portfolio DSO
87.5d
vs 30d terms
Interest Accrued
$183K
@ 18% p.a.
0–30d
$0
31–60d
$0
61–90d
$1.7M
91–180d
$2.7M
181d+
$525K
▸ Top Overdue Customers
Meridian Exports Ltd
91 days overdue
$84,200
Apex Global Trading
67 days overdue
$61,500
Sunridge Industries
45 days overdue
$38,750
5 Dashboard Tabs

Everything your AR team needs, in one dashboard

Five intelligent tabs — each answering a different question your finance team asks every single day.

📊
Tab 1
Overview
Portfolio KPIs, collections heatmap by month, financial year summary, ageing snapshot, top 10 overdue customers, and branch-wise DSO at a glance.
👤
Tab 2
Customer Analysis
Per-customer DSO trend, credit score, suggested credit limit, invoice breakdown, quarterly payment pattern, and one-click reminder drafts in Email and WhatsApp tone.
💰
Tab 3
Interest Charges
Configure your interest rate, threshold, and from-day — the engine recalculates portfolio-wide interest live. Export to PDF or Excel instantly.
📅
Tab 4
Customer Ageing
0–30 / 31–60 / 61–90 / 91–120 / 120+ day buckets across your full customer base, with drill-down per customer.
📈
Tab 5
Analytics
Period-level WACD trends, quarterly and monthly comparisons, colour-coded by performance — instantly spot deteriorating accounts before they become bad debt.
Pro Features

Powerful AR intelligence, fully offline

Everything you need to manage receivables professionally — without uploading your data anywhere.

✓
Unlimited customersTrack every account with no limits on portfolio size.
✓
DSO / WACD trackingFilter by All, FY, Quarterly, or Monthly periods.
✓
Credit scoring engineComputed from real payment behaviour, not static ratings.
✓
Interest engineConfigurable rate, threshold, and from-day — live editable in dashboard.
✓
PDF, Excel & CSV exportsCustomer cards, ageing, interest, and overview reports.
✓
Payment reminder draftsEmail and WhatsApp tone — one-click copy.
✓
Dark, Light & High-Contrast themesWorks the way your team prefers to work.
✓
100% local — zero cloudNo login, no subscription. Your data never leaves your machine.
Setup

Up and running in under 5 minutes

No server setup. No IT department. Just Python, your data, and one script.

1
Download & unzip
Get your ZIP from the store. Unzip anywhere on your machine.
2
Install dependency
One command. That's it.
pip install openpyxl
3
Paste your AR data
Add your invoice and receipt data to CollectIQ_Data.xlsx. Field guide included.
4
Activate (Pro only)
Run Activate_CollectIQ.bat once. Licence key arrives by email in 60 seconds.
5
Run daily
Double-click RUN_DAILY.bat. Your dashboard opens in the browser instantly.
RUN_DAILY.bat
Pricing

One-time payment. Yours forever.

No subscription. No renewal. No price hike. Pay once and use CollectIQ for as long as you want.

Lite
$0 forever
Up to 50 customers
  • ✓ All 5 dashboard tabs
  • ✓ DSO tracking & credit scoring
  • ✓ Interest engine
  • ✗ Exports (PDF, Excel, CSV)
  • ✗ Payment reminder drafts
  • ✗ Unlimited customers
Download Free
MOST POPULAR
Pro
$39 one-time
1-machine lifetime licence
  • ✓ Unlimited customers
  • ✓ All 5 dashboard tabs
  • ✓ DSO / WACD with period filters
  • ✓ Credit scoring + suggested limits
  • ✓ Interest engine (live editable)
  • ✓ PDF, Excel & CSV exports
  • ✓ Payment reminder drafts
  • ✓ Dark / Light / High-Contrast themes
  • ✓ Machine migration at no charge
Get Pro — $39 →
Pro Plus
$69 one-time
3-machine lifetime licence
  • ✓ Everything in Pro
  • ✓ 3-machine licence (whole team)
  • ✓ Same order number for all 3
  • ✓ Priority support (12hr response)
  • ✓ Machine migration at no charge
Get Pro Plus — $69 →
Studio
$249 /year
25-machine · White-label
  • ✓ Everything in Pro Plus
  • ✓ 25-machine licence
  • ✓ Custom white-label branding
  • ✓ Your firm name, logo & colours
  • ✓ Done-for-you delivery
  • ✓ Dedicated support (4hr response)
Interactive Demo

See CollectIQ in action

A full 24-step walkthrough of all 5 tabs with real sample data. No sign-up needed.

Requirements

Minimal setup. Maximum insight.

CollectIQ is intentionally lightweight — one dependency, two platforms, zero cloud.

🐍
Python 3.8+ ↗
Free to download from python.org
📦
openpyxl only ↗
One pip install. No other dependencies.
🪟
Windows & Mac
Native scripts for both platforms included.
🌐
No internet needed
After one-time activation, runs fully offline.
📊
Excel data file
Standard AR columns — field guide included in ZIP.
🔒
Machine-locked licence
Your data never leaves your machine.

Stop rebuilding pivot tables.
Start running CollectIQ.

Free Lite for up to 50 customers. Pro unlocks everything for a one-time $39.

Get CollectIQ Pro — $39 → Download Free Lite