Data Hub
Settings
Configure once — every report, every sheet references these values.
Client & Period
FX Rates to INR Update monthly — drives multi-currency conversion
| Currency | Name | Rate to INR | Effective |
|---|
ⓘ INR = 1.00 always. Add Currency column in Raw Ledger per transaction.
Browser Cache & Reset
If other tools (Budget, Cashflow, AP/AR etc.) are showing old client names or stale data, clear the browser cache below. This resets all locally-stored data to the current session.
Data Hub
Raw Transaction Ledger
Single source of truth — paste from Xero/Tally/QuickBooks, upload the SVGR Excel, or enter manually. All reports update instantly.
Copy rows from Excel (Ctrl+A then Ctrl+C) and paste below. Expects columns: Date | Source | Voucher | Party | Ledger Account | Account Group | Sub-Group | Cost Centre | Debit | Credit | Net Amount | Narration
Drop your file here or click to browse
Accepts: SVGR Excel (.xlsx) · Generic Ledger CSV / Excel · Any tabular ledger fileAdd Transaction Row
Transaction Ledger 0 rows loaded
MIS Report
Management Information Report
FY 2025-26 · YTD Apr–Dec 2025 · Every figure is a live SUMIFS against the Data Engine
AR Ageing
Accounts Receivable Ageing
Age (days) = Report Date in Settings minus Due Date · Buckets recalculate instantly on date change
AR Register
Ageing Buckets
DSO Analysis
Add AR Invoice
Bank Reconciliation
Bank Reconciliation
Dec 2025 · BANK-XXXX-0000 · Book balance from Data Engine · Paste bank statement to match
Filters
Month
Scope
Bank Statement — Paste from CSV
Book Entries — From Data Engine
Add Bank Statement Row
Data Hub
Trial Balance
Computed from Raw Ledger · All accounts · Debits must equal Credits
Data Hub
Balance Sheet
Closing balances = Opening Trial Balance + period movements · Assets = Liabilities + Equity
Dashboard
Executive Dashboard
FY 2025-26 · YTD Apr–Dec 2025 · All KPIs live from Data Engine
YearMonth
Monthly Revenue Trend
Top Clients by Revenue YTD
Expense Breakdown YTD
AR Status Summary
System
Data Engine
Processed rows from Raw Ledger · Inspect MIS Group mapping · Edit DIM_LEDGER to fix unmapped accounts