ataeru.cloud · Good Morning, —
Load both files to activate dashboard
📅 —
⚙ Admin
🔑 Update AI API Key
Paste your Groq API key below. Get a free key at console.groq.com · 500k tokens/day free.
🔓
Analysis tabs unlocked!
Overview · Booking vs Dispatch · Collections · Pipeline · Company Analysis are now available under Accounts in the sidebar.
📚 Merge DayBooks
Drag any number of DayBook Excel files here (or choose files). Mode A = bank transfer · Mode B = cash — adjust per file after load. Then process to unlock analysis tabs.
Drop DayBook files here
.xlsx / .xls · as many as you need
Merge DayBooks — tips
Cross-book linking is strict (exact text after spaces/case; Fortuna LLP + VK buckets only — no fuzzy). Receipt + Payment with the same voucher/cheque reference and equal amount nets off (typical bounced cheque).
Tick client rows in the merged ledger, then use A ↔ B, A → B, or B → A (same checkboxes as Merge selected). DayBook file mode is still set per file in the table above.
A ↔ B swaps the two columns; A → B / B → A combine all amount into one column.
🔍 Name Match Review
Strict cross-book links only · manual merge when you force a link
📊 Merged Client Ledger
Frozen toolbar · table scrolls · backups in
DATA/merge/Server snapshots
Each save creates a timestamped copy under DATA/merge/history/
🚚 Deliveries & dispatch data
Upload raw Tally / operations Excel — we map whatever columns exist (Date, Party, Amount, Ref, Notes) into a standard layout for MIS and monthly saves.
New-order advances (monthly) will come from Trial Balance / DayBook in a later step; Tally remains source of truth for amounts.
VK books reflect cash received; Fortuna tracks transfers; consolidated cashflow narrative is Fortuna Colours and Prints LLP.
No file loaded yet — use Download format as a starting point, or paste your export.
Mapped preview
First 200 rows · monthly exports can be stored under
DATA/exports/ on the server for future quarterly reports
Import a file to see mapped columns and rows.
⚙ Monthly pipeline & recipes
Choose a preset (e.g. Core MIS = steps 1+2+3+7). Status lights read from this browser session: merged books, Company Analysis import, deliveries file, dispatch, cashflow, name-match review.
Step 7 sends aggregated text to Groq — same key as the rest of ataeru · model
llama-3.3-70b-versatile.
0%
Step checklist (this preset)
Refresh by re-opening this tab or loading data
| ID | Step | Status |
|---|
Step 7 — Board briefing (Groq)
Uses only computed summaries from the session — not raw Excel bytes
ataeru.cloud · Business Intelligence
Select what you want to import — each file goes to the right module automatically
📋
Dispatch Details
Dispatch_Details_*.xlsx
→ Accounts Dashboard
Click to import
⚙
Monthly pipeline
Presets · step checklist · Groq briefing
→ Recipes & AI
Click to open
🏦
Cash Position
Weekly planning · collections & vendors
→ Cash Position tab
Click to open
💼
CashFlow File
CashFlow_*.xlsx
→ Loads into Cash Position
Click to import
📖
Day Book
Several Tally Day Book exports · set A/B per file · ⚡ Process (strict names + cheque netting)
→ Merge workspace
Click to choose Day Book files…
⚖
Trial Balance
Single Tally Trial Balance export → Company Analysis
→ Company Analysis
Click to import Trial Balance…
🚚
Deliveries data
Raw Excel → format · MIS export
→ Deliveries workspace
Click to open
⚡ 7 tools on this hub · Day Book = multi-file merge only · Trial Balance uses its own card · Leather / personal debt sheet: use VINOD PERSONAL in the sidebar.
📚 Merge DayBooks · Load multiple DayBooks, strict name rules + bounced-cheque netting, Mode A (bank) vs B (cash), A↔B moves — still here; open from the sidebar or this button.
Order Booking vs Dispatched Value
Monthly comparison · Apr 2025 – Apr 2026 · Values in ₹ Lakhs
Booked
Dispatched
Status Summary
Total Dispatched (FY)
—
Total Booked
—
Dispatch Cover
—
Peak Month
—
Cash Balance
—
Collections: Oct–Jan
Pipeline Status
Payables Breakdown
Monthly Order Booking vs Dispatched / Billed Value
Apr 2025 – Apr 2026 · ₹ Lakhs · Grouped comparison
Orders Booked
Dispatched
Surplus/Gap
Cumulative Position
Dispatch as % of Booking
Monthly efficiency ratio
Collections: Delivered Goods Balance
Payment received against already dispatched orders · Oct–Jan
New Order Advance Collection
Advance payments received for new orders · Oct–Feb
Combined Collection Analysis — Delivery vs Advance (Oct–Jan)
Which months drove advance bookings vs delivery collections
New Projects Pipeline
PI Total vs Received vs Balance outstanding
Total Payables Breakdown
As on date · ₹ Lakhs
Pipeline Detail Table
Monthly Business Performance Table
Apr 2025 – Apr 2026 · All values in ₹
✦
ataeru.cloud AI · Powered by Groq + Llama 3.3 70B
Groq Cloud · 500k tokens/day free · Get API key →
✦ llama-3.3-70b-versatile · 131k context · 500k/day free
Groq AI is analysing your financial data…
Thinking mode · 10–25 seconds
Ask Groq AI a Follow-up
Ask anything about your financial data
✦ Groq · Llama 3.3 70B
✦
Load your Excel files first
Groq AI will analyse your financial data and surface key business insights.
✦ AI Assistant
Groq · Llama 3.3 70B
💰 Cash Position & Weekly Planning
Load DayBook + Trial Balance to populate client balances
Weeks: loading…
📥 Expected Collections — Client × Week
Click any cell to enter expected collection. Tab to move across weeks. Changes auto-saved.
📤 Planned Vendor Payments — Week by Week
Import vendor payment plan Excel or add manually
Weekly Net Cash Position
Collections − Payments · ₹ Lakhs
Cumulative Cash Balance
Running balance through the month
📄 CashFlow File Data (from Excel upload)
This Week Payment Schedule
Cheque Tracker
🏢 Company Analysis — Auto-generated from DayBook / Trial Balance
Import a DayBook or Trial Balance file using the ⬆ Import Data button above
📖
Company Analysis — single-file import
Multi Day Book merge lives on Import hub → Day Book. Here you may load one Day Book or one Trial Balance for quick charts.
Auto-detects:
DayBook → receipts by client by month ·
Trial Balance → debtor / creditor balances ·
Both companies: Fortuna Colours & VK Consulting
Client Receipts — Month by Month
Monthly Receipts vs Invoices
Top Clients by Receipt
🏭
Production Analysis · Google Sheets Live
Connect your progress sheet — all tabs and product codes auto-detected
Setup (one time):
Go to GCP Credentials
→ + Create credentials → API key → name it "Sheets Key"
→ API restrictions → select Google Sheets API → Save → paste key above ·
Sheet must be "Anyone with link → Viewer"
Connecting to Google Sheets…
Fetching and scanning all sheet tabs
Sheets Detected
Tick which sheets to include
Product / Item Codes
Filter to specific codes · blank = all codes
Scanning sheets for codes…
Select sheets then load
Filtered by codes:
Ask Groq AI — Production Query
Ask about data across selected sheets and codes
✦ Groq · Llama 3.3 70B
Quick:
🏪
Store & Stock Management
Upload your inventory Excel or Balance Sheet — Groq AI analyses stock, vendors, and valuations
⚡ Upload one or both files · Groq AI will cross-analyse them together
Reading file…
Parsing sheets and detecting columns
Ask Groq AI — Store Query
Ask about stock levels, vendor totals, valuations
✦ Groq AI · Store
Quick:
🔗 Client Name Mapping — Dispatch File ↔ DayBook / Tally
Click a name on the left, then click the matching name on the right to link them. Saved permanently in your browser.
⚠ Import your DayBook first using ⬆ Import Data — this loads the DayBook receipt party names on the right side.
The Dispatch file client names are pre-loaded from the file you analyse.
📋 0 dispatch clients
📖 0 DayBook parties
✓ 0 linked
⚠ 0 unlinked
📋 Dispatch File Names
📖 DayBook / Tally Names
← Click a name on the left first, then click the matching name on the right
⚠ Known Issues — Tell Accounts to Fix
Based on analysis of your DayBook and Dispatch files
VINOD PERSONAL
📋
Import Leather Dept Payment Control Sheet
Parses all 4 sections — Leather creditors, Other suppliers, Statutory, Personal obligations
Add payments, track balances, compare with Trial Balance
Add payments, track balances, compare with Trial Balance
📋 Leather Dept Payment Tracker
⚖ Trial Balance Comparison:
☁ vs last saved on server:
🏭 Leather Department Creditors & Obligations
| Supplier | Original Amount | Paid (Jul 23–date) | Add Payment | Effective Balance | Comment | TB Status |
|---|
👷 Leather Employee Balance Payments
| Employee | Original Amount | Paid | Add Payment | Effective Balance | Comment | TB Status |
|---|
📦 Other Regular Suppliers
| Supplier | Amount | Paid | Add Payment | Balance | Comment | TB |
|---|
🏗 Infrastructure Creditors + Other Dept Salaries
| Party | Amount | Paid | Add Payment | Balance | Comment | TB |
|---|
⚖ Statutory Obligations
| Obligation | Amount | Add Payment | Balance | Comment |
|---|
👤 Monthly Personal Obligations
| Obligation | Monthly Amount | Notes |
|---|
📊 Grand Summary — Total Outstanding
🏦 Loans, Policies & Insurance Tracker
Track all EMIs, premiums, due dates — get reminders before payment dates
⚠ Payments due soon:
| Name | Provider | Loan/Policy No | Start Date | Expiry Date | Last Paid | Policy Amount | Maturity Amount | Payable (Monthly/Yearly) | Status | Action |
|---|---|---|---|---|---|---|---|---|---|---|
| No loans added yet. Import Excel or click + Add Manually. | ||||||||||
| Name | Provider | Loan/Policy No | Start Date | Expiry Date | Last Paid | Policy Amount | Maturity Amount | Payable (Monthly/Yearly) | Status | Action |
|---|---|---|---|---|---|---|---|---|---|---|
| No policies added yet. | ||||||||||
| Name | Provider | Loan/Policy No | Start Date | Expiry Date | Last Paid | Policy Amount | Maturity Amount | Payable (Monthly/Yearly) | Status | Action |
|---|---|---|---|---|---|---|---|---|---|---|
| No insurance added yet. | ||||||||||
📅 Payment History — Loans, Policies & Insurance
Only payments recorded from these 3 tabs
No payment history yet. Use "Add Payment" buttons above to record payments.
💳 Auto pay & Auto debit
Per payment method (Phone Pe, Paytm, cards…): what debits, which day each month, reminder email & message 2 days before. Data stays in this browser. Turn on Enable Reminders under Debt sheet → Loans for browser notifications.