🚀 Pehli Baar Shuru Karo (Quick Start)
1
Templates Download Karo
Left sidebar mein Excel Templates click karo. Wahan 7 ready-made Excel sheets hain — Daily Collection, PDC, Sales, Monthly Data, Expenses, Suppliers, Petty. Pehle inhe download karo aur apne accountant ko do fill karne ke liye.
2
Daily Data Enter Karo
Daily Entry tab mein jaake har branch ka Cash, Card, UPI manually enter karo — ya accountant ki filled Excel file import karo (📥 Import Excel button). Ek baar import karo, sab tabs automatically update ho jaate hain.
3
Monthly Data Add Karo
Monthly Data mein jaake gross sales, discounts, COGS, aur sab expense figures enter karo. Yeh data P&L, Cash Flow, Budget vs Actual — sab jagah automatically use hota hai.
4
Analysis Dekho
Upar se dashboard automatically live ho jaata hai — P&L Report, Store Performance, Cash Flow sab update ho jaate hain. Koi formula likhne ki zaroorat nahi.
💡 Pro Tip: Pehle ek mahine ka data enter karo poora — phir dekhna kitna acha lage dashboard. Daily entry sirf 2-3 minute ka kaam hai agar routine ban jaaye.
🔧 Top Toolbar — Kya Karta Hai Kya
↩ Undo / Redo
Koi bhi galti hui? Undo karo. Multiple steps tak undo ho sakta hai — import bhi undo hota hai.
💾 Save
Browser mein local save hota hai. Page band karoge toh data wahan rahega jab tak same browser mein kholo. ⚠ Browser clear karne se data jaata hai — isliye Export karte raho.
📂 Load
Pehle export kiya hua JSON file wapas load karo. Backup restore karna ho toh yahi use karo.
🖨 PDF
Current screen ka PDF banataa hai. Report print karne ke kaam aata hai.
📊 Export
Sabse important button. Poora data JSON file mein download hota hai. Ise regularly backup lo — weekly ya monthly. Load button se wapas le aao kisi bhi time.
💡 Backup Rule: Mahine ke aakhir mein Export zaroor karo. Ek folder banao "Nutan CFO Backups" aur date-wise files rakho.
📅 Daily Entry — Roz Ka Data
Yeh tool ka sabse important module hai. Har branch ka daily collection yahaan aata hai — manually ya Excel se import karke.
Date
Jiski entry ho uska date. Format: DD/MM/YYYY ya D.M.YY (jaise 1.6.26)
Branch
NM (Madhav Nagar), NB (Manish Nagar), NK (Khamla), NTR (Hingna), NG (Gajanan Nagar)
Cash Sales ₹
Aaj branch par kitna cash aaya — walk-in customers se
Card Sales ₹
Credit/debit card se aaya amount
UPI/QR ₹
PhonePe, GPay, Paytm se aaya amount
Recovery Cash/Digital
Purane outstanding balance ke against jo paisa aaya — advance/balance collections
Cash in Hand ₹
Raat ko branch mein kitna cash tha physically
Cash Deposited ₹
Aaj bank mein kitna cash deposit kiya
Excel se Import Karna (Zyada Easy)
Accountant wali Excel file download hai Excel Templates → Daily Collection mein. Usse fill karke do accountant ko. Phir wahi file wapas lo aur 📥 Import Excel button se import karo. Ek click mein 5 branches × 30 din ka data aa jaata hai.
💡 Naya: Bank Balance Tracker — Daily Entry tab mein neeche scroll karo. Har hafte NNSB 007, SBI NB, PNB NM etc. ka balance update karo. Yeh W3 Bank Balance KPI ke liye use hota hai aur Cash Flow mein total dikhtaa hai.
Do alag files hain — confuse mat hona:
• daily_statement_sample.xlsx (accountant wali sheet) → Daily Entry → 📥 Daily Collection Sheet
• DailyStatement.xlsx (CRM wali monthly report) → Reconciliation → 📥 CRM Statement
Agar galti se CRM file Daily Entry mein import karo toh tool warning dega aur Reconciliation mein redirect karega.
Pehle import kar chuke ho aur dobara karna hai? "🔄 Re-Import (Replace)" button use karo — existing month ka data hata ke fresh import karega.
🏦 PDC Tracker — Supplier Payments
Suppliers ko jo cheques diye hain — unka record yahaan rakho. Frames, Lenses, Contact Lenses, Sunglasses, aur Operating Costs — 5 categories mein.
PDC No.
Cheque number — jaise 001234
Payee Name
Supplier ka naam — jaise BAJRANG OPTICAL, ZEISS, VISION RX LAB
Due Date
Cheque ki maturity date — jis din bank present karega
Bank Account
NNSB 007, NNSB 89, SBI, PNB NM, PNB NTR mein se kaunsa
Status
Pending → cheque abhi clear nahi hua. Cleared → bank se paisa gaya. Bounced → cheque bounce hua.
💡 PDC data Cash Flow mein directly dikhtaa hai — 30-day liquidity position automatically calculate hoti hai. Isliye due dates accurately bharein.
📋 Monthly Data — P&L Ka Backbone
Har mahine ka summary yahaan aata hai. Yeh data P&L, Cash Flow, Budget vs Actual — sab tabs mein use hota hai. Ek baar bharr do, sab jagah reflect hoga.
Key Fields
Gross Sales
MRP pe total billing — discount se pehle
Discounts
Total discount diya customers ko
Net Revenue
Gross Sales − Discounts. Auto calculate hota hai.
Category Revenue
Frames, Lenses, Contact Lenses, Sunglasses — alag alag kitna aaya
COGS
Cost of Goods Sold — frames/lenses khareedne mein kitna lagaa
Branch Revenue
NM, NB, NTR, NK, NG — branch-wise kitna aaya
Expenses
Rent, Salary, Loan EMI, Electricity, Marketing, Staff Commission — sab alag alag
💡 Pehle month ka data time lagta hai bharrne mein — lekin ek baar baad mein sirf changes update karo. Excel Template se import karna zyada fast hai agar accountant se file leni ho.
📥 Sales & Manual Entry — CRM Import ya Manual
Billing software (Retina / iConnect) se export kiya hua sales report yahaan import hota hai. Tool automatically columns map karta hai.
1
Billing Software se Export Karo
CRM mein Reports → Sales Report → Export as Excel. File ka naam hoga salesReport.xlsx. Yeh 64 columns wali file hai.
2
Sales Import Tab mein Upload Karo
"Upload & Map" button click karo, file select karo. Tool automatically columns detect karega — Customer Name, Branch, Net Amount, Payment Mode, Outstanding Balance sab.
3
Preview Check Karo, Import Karo
5 rows ka preview dikhega — agar sab theek lage toh "✓ Import Valid Rows" click karo. Duplicates automatically skip ho jaate hain.
💡 Manual Sales Entry bhi available hai agar billing software nahi hai ya koi ek entry add karni ho manually.
💸 Expense Master — Kharcha Track Karo
Do parts hain — Expense Heads (categories banao) aur Expense Entries (actual kharcha enter karo).
Step 1: Expense Heads Banao
Pehle expense categories set karo — jaise RENT, SAL (Salary), ELEC (Electricity), MKTG (Marketing). Ek baar setup karo, phir entries mein sirf code use karo.
Step 2: Entries Add Karo
Har expense entry mein Date, Expense Head select karo, Supplier ka naam, Amount aur Branch bharr do. Yeh P&L mein automatically reflect hoga.
💡 Important: Expense Entries ab P&L mein directly reflect hoti hain. Agar Monthly Data mein rent/salary fill nahi kiya lekin Expense Master mein entries hain — toh woh automatically P&L mein aa jaayengi. Dono jagah fill karne ki zaroorat nahi.
Suppliers tab mein apne sab suppliers ek baar add karo — BAJRANG OPTICAL, VISION RX, ZEISS etc. Phir entries mein dropdown se select karna aasaan ho jaata hai.
📄 Excel Templates — Accountant ke Liye
7 ready-made Excel templates hain — exactly usi format mein jo tool import karta hai. Accountant ko yeh files do, woh bharr ke wapas de, aap import karo.
Daily Collection
5 branches × 30 din ka Cash/Card/UPI
Daily Entry → 📥 Import
PDC Ledger
Supplier cheque payments — 5 categories
PDC Tracker → 📥 Import PDC
Sales Data
Manual bill-level entry agar CRM nahi hai
Sales Import
Monthly Summary
Revenue, COGS, expenses sab ek sheet mein
Monthly Data → Import
Expense Entries
Individual expense transactions
Expense Master
Supplier Master
Sab suppliers ek baar setup
Expense Master → Upload Suppliers
Petty Expenses
Roz ka chota kharcha — chai, petrol etc.
Daily Entry → Import
⚖ Bank Reconciliation — CRM vs Bank Match Karo
CRM mein jo collections dikhti hain aur bank mein jo credit ata hai — dono ko match karo. Koi gap ho toh woh yahaan pakad mein aata hai.
Step 1: Data Import Karo
A
CRM Statement Import Karo
📥 CRM Statement button click karo — DailyStatement.xlsx select karo (CRM se export ki hui monthly report). Tool automatically advance + balance collections parse karega — ~1,400+ individual transactions.
B
Bank Statement Import Karo
🏦 Bank Statement button click karo — NNSB ya SBI ka xlsx export select karo. Tool automatically DATE, PARTICULARS, DEBIT, CREDIT columns detect karega.
Auto-Match — 4 Rounds Mein
Round 1
Exact amount match — CRM ₹500 = Bank ₹500 → ✓ Matched (green)
Round 2
Same amount ±2 din — card settlement D+1 hoti hai, isliye ek-do din ka gap handle hota hai
Round 3
Amount diff ≤ ₹15 — MDR/GST deduction wali entries (⚠ Diff — amber)
Round 4
Amount diff ≤ ₹100 — thodi aur fuzzy matching (⚠ Diff — amber)
Manual Matching — Drag & Drop
1
Card View Tab Click Karo
Left side mein CRM entries ke cards, right side mein bank entries ke cards.
2
Drag Karo Ya Click Karo
Drag: CRM card pakdo, bank card pe chhodo.
Click: Pehle CRM card click karo (purple border), phir bank card click karo.
3
Tray mein Confirm Karo
Neeche se ek tray slide up hogi — dono entries side by side dikhenge. "✓ Match" click karo. Entry purple ⬡ Manual badge ke saath match ho jaayegi.
Tabs Explanation
Side-by-Side
Table view — CRM columns left, Bank columns right, Diff column end mein
Card View
Visual cards — drag & drop manual matching ke liye
Errors
Jo entries match nahi hui + amount mismatch — yahan sab issues listed
Cash Entries
Cash collections — bank statement se match nahi hoti (cash deposit track karo alag)
Orphan Bank
Bank mein credit aaya lekin CRM mein koi entry nahi — investigate karo
💡 ⬇ Excel button se poora reconciliation report download hota hai — 5 sheets: Reconciliation, Errors, Cash Entries, Orphan Bank, Summary. Shirish Sir ko share karne ke liye perfect.
📈 P&L Report — Profit ka Hisaab
Monthly Data + Daily Collections se automatically P&L ban jaata hai. Koi formula likhne ki zaroorat nahi.
Gross Sales
Total billing before discount
Gross Profit
Net Revenue − COGS. Optical mein yeh 65-75% hona chahiye.
EBITDA
Gross Profit − Operating Expenses (depreciation aur tax exclude). Real business ka health check.
Net Profit
EBITDA − Depreciation − Interest − Tax. Final bottom line.
💡 P&L sirf tab accurate hoga jab Monthly Data mein COGS aur expenses sab fill hue hon. Aadha data = aadha picture.
💰 Cash Flow — Paisa Aana Jaana
Agle 30 dinon mein kitna paisa aayega aur jaayega — yeh yahaan dikhtaa hai. PDC data aur collections se automatic forecast hoti hai.
Cash In
Daily collections from all branches
Cash Out
PDC payments due + operating expenses
30-Day PDC
Agle mahine mein kitne cheques present honge — cash mangaao abhi se
Coverage Ratio
Collections ÷ Expenses. 1.0 se upar matlab comfortable. Neeche gaya toh danger zone.
🏪 Store Performance — Branch Comparison
Paanch branches — NM, NB, NK, NTR, NG — ka comparison ek jagah. Kaun best perform kar raha hai aur kaun peeche reh raha hai.
NM
Madhav Nagar — main branch
NB
Manish Nagar — Beltarodi Road
💡 Monthly Data mein branch-wise revenue fill karo — tab yeh tab fully live hoti hai. Agar sirf Daily Entry hai toh collections dikhtii hai, revenue nahi.
🎯 Budget vs Actual — Target Track Karo
Monthly Data mein budget figures enter karo — phir yeh tab actual vs target automatically compare karega. Har line item mein variance dikhtaa hai.
💡 Pehle ek realistic budget set karo. ₹100 Cr wala dream target alag hai — monthly operational budget alag. Budget vs Actual ke liye mahine ka expected revenue aur expense estimate karo.
📐 Margin Benchmarks — Ratios Check Karo
Industry standard ratios vs tumhara actual — kahan ho aur kahan hona chahiye. Gross Margin, EBITDA %, Rent-to-Revenue, Salary-to-Revenue sab dikhtaa hai.
💡 Optical retail mein Gross Margin 65-75% normal hai. EBITDA 15-20% healthy. Rent 8-10% se upar toh cost restructuring socho.
📂 Session Manager — Data Control
Poora data ek jagah se control karo — koi bhi import batch undo karo, ya poora data reset karo fresh start ke liye.
Import History
Kitne imports hue, kab hue, kitni rows — sab listed. Individual import undo bhi ho sakti hai.
⚠ Reset All Data
Danger button. Poora data wipe ho jaata hai. Reset se pehle Export zaroor karo backup ke liye.
📜 Audit Log — Kya Kab Kiya
Har action automatically log hota hai — import, edit, delete, undo, redo. Agar koi galti ho ya question aaye "yeh kab import hua tha?" — audit log mein dekho.
⚠ Common Mistakes aur Fix
Import ke baad "No records imported"
File format check karo — template download karke usse use karo. Date format D.M.YY ya DD-MM-YYYY hona chahiye.
Dashboard blank dikhtaa hai
Mahina select karo top mein — data usi month ka dikhega jiska data hai.
P&L mein sab zero hai
Monthly Data fill karo — Gross Sales, COGS, Expenses. Sirf daily collection se P&L nahi banta.
Reconciliation mein No Match dikhtaa hai
Bank Statement import kiya? Dono — CRM Statement aur Bank Statement — dono import honni chahiye. Tab matching hogi.
Page refresh karne se data gaya
💾 Save button regularly dabao. Ya ₹ Export karke JSON file rakh lo — Load se wapas aa jaata hai.
Galat data import ho gaya
↩ Undo button dabaao — import bhi undo hota hai. Ya Session Manager mein jaake woh import delete karo.
Branch name galat show ho raha hai
Import mein branch column mein sirf NM / NB / NK / NTR / NG likhna hai — full name nahi.
📊 Data Entry → Analysis — Complete Wiring Table
Kaunse data entry tab ka data kaunse analysis tab mein jaata hai — yeh table mein sab clear hai.
Part 1 — Data Entry Tab → Analysis Tabs
| Data Entry Tab |
What You Enter |
Feeds Into Analysis |
KPIs Enabled |
Frequency |
📅 Daily Entry
Accountant Excel Sheet |
Cash, Card, UPI per branch
Recovery Cash/Digital
Bills count, Cash in Hand
Cash Deposited |
✓ CFO Dashboard (collection, coverage)
✓ Cash Flow (inflows, branch breakdown)
✓ Store Performance (ABV, digital%)
✓ P&L (petty expenses, tColl)
✓ Charts (collection trends)
|
D1 D2 D4 W4 W5
M9 M10 |
🔴 Daily |
🏦 Bank Balances
Inside Daily Entry tab |
NNSB 007, NNSB 89, SBI NB
PNB NM, PNB NTR, Cash balance |
✓ Cash Flow (bank balance, net position)
|
W3 |
🟡 Weekly |
📥 PaymentReport Import
Reconciliation → 📥 Payment Report |
CRM payment data
Customer, Order, Amount
Sales Person, Pay Mode
Advance/Balance type |
✓ CFO Dashboard (outstanding, staff discount, collEff)
✓ Store Performance (CRM by branch)
✓ Reconciliation (CRM side)
|
W1 M7 M9
D5 |
🟡 Monthly |
🏦 Bank Statement Import
Reconciliation → 🏦 Bank Statement |
NNSB/SBI xlsx export
Date, Description, Debit, Credit |
✓ Reconciliation (bank side — match with CRM)
|
D3 (settlement lag) |
🟡 Monthly |
🏦 PDC Tracker
Manual entry per cheque |
Supplier name, Amount
Due date, Bank account
Status (Pending/Cleared/Bounced) |
✓ CFO Dashboard (PDC 30-day)
✓ Cash Flow (outflows, weekly forecast)
✓ Charts (PDC trends)
|
W2 M8 M10 |
🟠 Per cheque |
📋 Monthly Data
Manual form — once per month |
Gross Sales, COGS per category
Branch-wise revenue
All expenses (Rent, Salary etc.)
Budget targets |
✓ P&L (revenue, margins, EBITDA — PRIMARY)
✓ CFO Dashboard (netRev, GM%, EBITDA%)
✓ Store Performance (branch revenue)
✓ Budget vs Actual (all 3 lines)
✓ Margin Benchmarks (all ratios)
✓ Charts (P&L waterfall)
|
M1 M2 M3 M4 M5
M6 M10 Q7 |
🟡 Monthly |
💸 Expense Master
Expense Heads + Entries |
Expense heads setup (RENT, SAL...)
Individual expense entries
Supplier master |
✓ P&L (expense line items — overrides Monthly Data)
✓ Margin Benchmarks (via getActualExpenses)
✓ CFO Dashboard (EBITDA, opEx)
|
M3 M10 |
🟠 Per expense |
✏ Manual Sales Entry
Inside Sales & Manual tab |
Bill-by-bill sales entry
Category, Amount, Customer
Payment mode |
✓ P&L (netRev — when Monthly Data not filled)
✗ Does NOT feed Store Performance directly
✗ Does NOT feed Charts
|
M1 (fallback) |
🟠 As needed |
Part 2 — Analysis Tab → Required Data Sources
| Analysis Tab |
Required Data (Tab Blank Without This) |
Optional (Enhances Tab) |
Missing = What Breaks |
| 📊 CFO Dashboard |
Daily Entry (collections)
Monthly Data (revenue, EBITDA) |
PaymentReport (outstanding, staff)
PDC Tracker (30-day liability)
Bank Balances (liquidity) |
Without Daily: collection = ₹0
Without Monthly: margin = 0%
Without PaymentReport: outstanding = blank |
| 📈 P&L Report |
Monthly Data (revenue + COGS + expenses) |
Expense Master (detailed entries)
Daily Entry (petty expenses) |
Without Monthly Data: P&L completely blank
Without COGS: Gross Margin = 0% |
| 💰 Cash Flow |
Daily Entry (cash inflows)
PDC Tracker (outflows) |
Monthly Data (fixed costs)
Bank Balances (opening position) |
Without Daily Entry: actuals = ₹0
Without PDC: outflows = ₹0 (wrong forecast) |
| 🏪 Store Performance |
Daily Entry (collections per branch) |
Monthly Data (branch revenue)
PaymentReport (CRM by branch) |
Without Daily: all branches show ₹0
Without Monthly: revenue = 0, GM = 0% |
| 🎯 Budget vs Actual |
Monthly Data — both Budget fields AND actual data |
— |
Without budRevenue/budEBITDA/budExpense: tab shows all zeroes in budget column |
| 📐 Margin Benchmarks |
Monthly Data (revenue + expense lines) |
Expense Master (fills gaps in Monthly Data) |
Without Monthly Data: all ratios = 0% |
| 📉 Charts & Analytics |
Daily Entry (collection trends)
Multiple months of data |
Monthly Data (P&L waterfall)
PDC Tracker (payment trends) |
Single month: trends flat
Without Daily: collection chart empty |
| ⚖ Reconciliation |
PaymentReport import (CRM side)
Bank Statement import (bank side) |
Daily Entry (collection comparison in sumbar) |
Without PaymentReport: CRM side blank
Without Bank Statement: all show "No Match" |
Part 3 — KPI → Kaunsa Data Chahiye
| KPI |
Data Source |
Entry Tab |
Status |
| D1 Total Collection | S.collections — totalCollection | Daily Entry | ✓ Live |
| D2 Cash vs Deposited | S.collections — cashInHand, cashDeposited | Daily Entry | ✓ Live |
| D3 Digital Settlement Lag | S.collections + S.bank | Daily Entry + Bank Statement | ⚠ Partial |
| D4 Branch Collection | S.collections — branch field | Daily Entry | ✓ Live |
| D5 Advance vs Balance | S.crmSales — section field | PaymentReport import | ✓ Live |
| W1 Outstanding >7 days | S.crmSales — advance orders | PaymentReport import | ✓ Live |
| W2 PDC Due 7/30 days | S.pdc — dueDate, status | PDC Tracker | ✓ Live |
| W3 Bank Balance | S.bankBalances — per account | Daily Entry → Bank Balances section | ✓ Live |
| W4 Undeposited Cash | S.collections — cashInHand vs cashDeposited | Daily Entry | ✓ Live |
| W5 Week-on-Week | S.collections — week grouping | Daily Entry (auto-calculated) | ⚠ No dedicated view |
| M1 Gross Revenue | S.monthly — grossSales, discount | Monthly Data | ✓ Live |
| M2 Gross Margin % | S.monthly — revenue + COGS | Monthly Data | ✓ Live |
| M3 EBITDA % | S.monthly — all expense lines | Monthly Data or Expense Master | ✓ Live |
| M4 Branch Contribution | S.monthly — nmRev/nbRev etc. + shared COGS | Monthly Data (branch revenue fields) | ⚠ COGS equally split |
| M5 Category Mix | S.monthly — framesRev, lensesRev, clRev, sgRev | Monthly Data | ✓ Live |
| M6 Discount % | S.monthly — discount / grossSales | Monthly Data | ✓ Live |
| M7 Staff Discount % | S.crmSales — salesPerson, orderValue, amount | PaymentReport import | ✓ Live |
| M8 PDC Bounce Rate | S.pdc — status = Bounced | PDC Tracker — update status | ✓ Live |
| M9 Collection Efficiency | S.crmSales (billed) + S.collections (collected) | PaymentReport + Daily Entry | ✓ Live |
| M10 Cash Coverage | S.collections + S.pdc + S.monthly | Daily Entry + PDC + Monthly Data | ✓ Live |
| Q4 Dead Stock | S.inventory — not built yet | — | ✗ Phase 4 |
| Q7 Vybe % Revenue | S.monthly — vybeRev field (not yet added) | Monthly Data (field to be added) | ✗ Not built |
| A5 CAGR / YoY | S.monthly — multiple years needed | Monthly Data (12+ months) | ⚠ Need 12+ months data |
Part 4 — Jo Data Entry Abhi Nahi Hai (Future Phases)
Vybe Revenue ₹ field
Q7 Vybe % of total revenue
Next update
Branch-wise Rent/Salary
M4 Branch contribution margin (accurately)
Phase 2
Staff headcount per branch
Q6 Revenue per employee
Phase 2
Inventory value per month
Q3 Inventory turnover, Q4 Dead stock
Phase 4
Marketing campaign data
Q8 Marketing ROI
Phase 6
Shopify D2C revenue
A4 D2C revenue %
Phase 6
n" data-tags="workflow routine monthly process accountant">
📆 Monthly Routine — Har Mahine Ka Process
1
Mahine ke Pehle Hafte
Pichle mahine ka Daily Collection template fill karke accountant se leke import karo. DailyStatement.xlsx CRM se export karke Reconciliation mein import karo.
2
Bank Statement Import Karo
NNSB ya SBI ka pichle mahine ka statement xlsx download karo aur Reconciliation → 🏦 Bank Statement se import karo. Auto-match run ho jaayega.
3
Monthly Data Bharo
Monthly Data tab mein jaake pichle mahine ka Gross Sales, COGS, sab expenses fill karo. Accountant ki P&L sheet se yeh data milega.
4
Reports Dekho aur Share Karo
P&L Report, Store Performance, Cash Flow — sab update ho jaate hain. PDF ya Export karke Shirish Sir ko bhejo.
5
Backup Lo
📊 Export button dabao — JSON file download ho jaayegi. "Nutan CFO Backups" folder mein "2026-06.json" type naam se save karo.