Kingar Signs — Business Intelligence

Accounts Receivable

₹6.12 Cr

₹2.18 Cr overdue (FY25-26 invoices)

Accounts Payable

₹2.14 Cr

200+ bills · Top: Lyncotek ₹5.52L

Available Cash (IDBI-26558)

₹21.31L

Operational account · Other accounts: loans

Unearned Revenue

₹3.80 Cr

Customer advances received · work pending

Net GST Liability

₹1.45 Cr

Output ₹2.81Cr − Input ₹1.37Cr

📈 Vendor Payments — Last 60 Days by vendor

💰 AP by Top Vendors

🔴 Urgent: Pay Lyncotek ₹5.52L

50+ days overdue across 5 bills. RTGS of ₹32.9L already sent 18 May — clear the remaining balance to protect supply chain.

₹5,52,323 outstanding

🟠 Collect: Chase Top AR Customers

₹2.18 Cr overdue on FY25-26 invoices. Continental alone owes ₹28.93L. Call top 5 customers today to schedule payment.

98 overdue invoices

🟡 Review: Prepaid Expenses ₹2.26 Cr

Large prepaid balance on books. Verify these are genuine advances to suppliers with delivery schedules — could signal locked capital.

₹2,26,29,697 prepaid

⚖️ Working Capital Snapshot

🧾 FY25-26 Invoice Collection Rate

Total AP Outstanding

₹2.14 Cr

Canonical · Zoho chart of accounts

Bills in Window (200)

₹29.2L

Apr–May 2026 recent bills balance

Active Vendors

120+

Across all categories

Payments (Apr–May)

₹59.4L

Top: Lyncotek ₹35.6L (RTGS)

🏆 Top Vendors by Outstanding Balance

⏱ Aging Buckets (recent 200 bills)

📋 Vendor Outstanding — Top 20 Apr–May 2026

#	Vendor Name	Priority	Bills	Outstanding	Oldest Bill	Age (days)

💳 Recent Vendor Payments Apr–May 2026 · Top 25

Date	Vendor	Amount	Mode	Ref / Note
Total shown

Total Assets

₹14.87 Cr

AR ₹6.12Cr + Fixed ₹2.34Cr + Prepaid ₹2.26Cr + GST Credit ₹1.37Cr

Total Liabilities

₹9.24 Cr

AP ₹2.14Cr + Unearned ₹3.80Cr + GST Out ₹2.81Cr + Loans ₹1.59Cr

Equity (Net Worth)

₹5.47 Cr

Retained Earnings ₹5.46Cr + Owner's Equity ₹1L

Assets

Accounts Receivable₹6.12 Cr

Prepaid Expenses₹2.26 Cr

GST Input Credit₹1.37 Cr

Fixed Assets (net)₹2.34 Cr

Inventory₹12.49L

IDBI Bank-26558₹21.31L

FDs & Deposits₹20.26L

Salary Advance₹10.94L

Income Tax / TDS₹12.81L

Total Assets₹14.87 Cr

Liabilities

Accounts Payable₹2.14 Cr

Unearned Revenue₹3.80 Cr

Output GST (net)₹2.81 Cr

Unsecured Loans (RK)₹1.15 Cr

HDFC Auto Loan₹44.35L

Akshay Kingar (Dir.)₹12.75L

Sundry Creditors₹4.91L

RK Cash Loan₹7.49L

Provisions₹9.60L

Total Liabilities₹9.24 Cr

Equity

Retained Earnings₹5.46 Cr

Owner's Equity₹1.00L

Drawings-₹2.83L

Total Equity₹5.47 Cr

Bank Accounts

IDBI-26558 ✅+₹21.31L

RKM BOB (loan)-₹7.43L

RKF BOB (loan)-₹79.91L

SCB-45505 (CC)-₹52.78L

IDBI-21696-₹17.17L

⚠ Negatives = loan/credit line accounts

📊 Balance Sheet Visual

🧾 GST Position

Input CGST

₹63.39L

Input SGST

₹56.94L

Input IGST

₹16.33L

Output CGST

₹1,10.79L

Output SGST

₹1,10.79L

Output IGST

₹59.75L

Net GST Payable: ₹1,44,67,998 · Total Output ₹2,81,33,913 − Total Input ₹1,36,65,915 = ₹1,44,67,998

🔧 Key Expense Accounts (May 2026)

Account	Balance
Cost of Goods Sold	₹27,12,641
PURCHASES	₹3,44,179
Office Expense	₹2,48,242
Transportation (Inward)	₹30,600
Transportation (Other)	₹74,821
Material Purchase	₹1,50,095
Business Promotion	₹20,839
Security Services	₹18,000
Electricity (KEB)	₹18,444
Staff Welfare	₹7,165

🏗 Key Asset Accounts

Account	Balance
Machinery	₹71,00,401
Car / Vehicles	₹1,14,24,934
Leasehold Improvements	₹27,21,339
Computers & Laptops	₹6,94,164
CCTV Equipment	₹1,04,197
OFFICE EQUIPMENT	₹3,38,934
Furniture & Equipment	₹6,10,645
Suguna (ESI/PF/TDS Advance)	₹21,54,569
Income Tax 2025-26	₹2,50,000
Accum. Depreciation	-₹44,52,283

💵 Available Cash — IDBI Bank 26558

₹21,30,847

After selected payments: calculating...

AR Expected Inflow

₹2.18 Cr

overdue FY25-26 invoices

🎯 Payment Priority Queue — Check to include in payment plan

SELECTED PAYMENT TOTAL

₹0

0 vendors selected

📅 Recommended Payment Schedule

TODAY — 28 May

• Lyncotek — ₹5,52,323 (NEFT/RTGS)
• Acrylic House — ₹3,00,000 partial (₹1.68L next week)

Impact: -₹8.52L · Remaining: ₹12.79L

THIS WEEK — by 1 Jun

• Aristocrat Light N Sign — ₹2,00,000
• Aluminium Sales Corp — ₹1,93,648
• Ashok Marketing — ₹1,89,456

Collect ₹5L+ from AR first to fund this

NEXT WEEK — 2–7 Jun

• Jai Maruthi Steel — ₹1,48,128
• Hindustan Paints & Chem — ₹1,52,726
• Maruthi Enterprises — ₹1,65,205

Subject to AR collections week 1

LATER — when AR collected

• Plus Print ₹1.09L · Aldura ₹85K
• Meenakshi Elec ₹77K · Navrang LED ₹40K
• CS Surana ₹30K · Maxx Designs ₹36K

📊 Cash Flow Projection (Next 4 Weeks)

⚠ Assumes ₹15L/week AR collection. Actual depends on customer follow-ups. Chase Continental, Café Coffee Day, and 3 other top debtors first.

Total Tracked

₹0

0 entries logged

This Month

₹0

0 this month

Top Category

—

add entries to see

Top Manager

—

add entries to see

Avg per Entry

—

across all recorded entries

🍕 Spend by Category

👤 By Manager

📅 Monthly Trend

📋 Expense Log

Date	Description	Category	Manager	Amount
Total				₹0

📊 Manager Summary

📁 Category Summary

💸

Petty Cash Entry Form — Notion

Submissions go directly to your Notion Petty Cash Management database

↗ Open full screen

Total Salary Loaded

₹0

No data uploaded yet

Employees Tracked

—

from uploaded Excel

Latest Month

—

Upload a file to begin

📤 Upload Salary Excel

📊

Click or drag & drop your salary .xlsx file here

Supports .xlsx · .xls · .csv

Expected columns: Employee Name · Department · Month · Amount/Salary · Date

💡 Template format: Row 1 = headers. Columns: Employee Name, Department, Month, Salary, Date. Any order, any extra columns — we auto-detect.

📅 Monthly Salary Summary

Month	Employees	Total Salary	Avg/Employee
Upload a salary file to see breakdown

🏢 By Department

👤 Employee List

#	Employee	Department	Total Paid	Months
No data

🔴 Vendor Overpayments

₹52.54L

Lyncotek ₹24.89L · H.Paints ₹8.70L · Dialogue ₹18.95L

⏰ Aged AR >365 days

₹62.44L

RK Marketing 797d · RK Foundry 424d

Customer Advance Balances

₹55.12L

DENALI ₹32.92L · PRMD ₹16.22L · Platinum ₹5.88L

Clean Matches (Net ~₹0)

Continental · OneSource · Aurbis · Telrad · Raman

⚠️ Reconciliation Alerts — Action Required

👥 Customer Ledger AR Balances — Zoho Live

#	Customer	Outstanding (AR)	Credits	Net Balance	Status
Total

🏭 Vendor Ledger AP Balances — Zoho Live

#	Vendor	Bills Outstanding	Credits	Net Balance	Status
Total

📅 Customer AR — Top 15 Outstanding

🏭 Vendor AP — Top 15 Outstanding (Net)

🔴 Aged Receivables — Overdue Invoices from Zoho

Invoice #	Customer	Balance	Due Date	Age

⚖️ Reconciliation Summary

Item	Amount	Action
Lyncotek Overpayment Credits ₹35.60L vs Bills ₹10.71L	-₹24.89L	Request Lyncotek to raise invoice for ₹24.89L
Hindustan Paints Overpayment Credits ₹9.06L vs Bills ₹36K	-₹8.70L	Adjust against future bills / request credit note
Dialogue Form Advance ₹18.95L paid, no bills raised	-₹18.95L	Verify project delivery status + request bills
RK Marketing — 797 days Related party, INV2023-24-267	₹19.96L	Board resolution needed / write-off review
RK Foundry — 424 days Related party, 2 invoices	₹42.48L	Net against vendor payables / inter-co set-off
DENALI — Customer Advance ₹32.92L received, used to pay Lyncotek	-₹32.92L cr	Raise invoice against Denali / recognize revenue
PRMD Ventures Advance ₹17.22L credits, ₹1L billed	-₹16.22L cr	Invoice remaining work or refund if cancelled