LBK
M/s. L. B. KUNJIR
FLEET ERP ā¢ V30 ULTIMATE ā¢ ENTERPRISE CLOUD
LIVE CLOUD SYNC Synced just now
STORAGEā¦
Admin
Finance + Purchase Access
A
OPERATIONS - V29
MASTER DATA - NEW TABS
V24 PLUS - 100GB - NEW
FINANCE TRACKING
ā¢ Finance / Free
ā¢ Loan A/c No, ROI
ā¢ Financer, Invoice
ā¢ Manufacturer
ā¢ Purchaser, Bill
ā¢ Loan A/c No, ROI
ā¢ Financer, Invoice
ā¢ Manufacturer
ā¢ Purchaser, Bill
V21 Enterprise
13 New Fields Added
Machinery Fleet ā¢ Finance + Purchase Details
Total Fleet Details - Finance, Loan, ROI, Manufacturer, Purchaser, Asset, Bill, Invoice - Enterprise Tracking
Dashboard - Finance + Purchase Overview
Total Fleet Value, Finance, Free Assets, Loan Status
Total Machinery
0
FREE: 0FIN: 0
Total Investment
ā¹0
Basic + GST invoiced value
Monthly EMI Outflow
ā¹0
-
Pending Documents
0
Expired + expiring in 30d
This Month Expenses
ā¹0
Fuel, Maint, EMI excluded
Loan Portfolio Summary
Recent Activity
Quick Actions & Drive
Docs Expiry Timeline
š° FLEET SPLIT - FREE vs FINANCED
š FLEET COUNT - TYPE WISE
š EXPENSE TREND - MONTH WISE
šļø SITE WISE FLEET + EXPENSES
Documents Management
Manage all compliance documents
š COMPLIANCE MATRIX - ALL MACHINES
OKDUE <= 30dEXPIREDNOT FILED
| Machine | RC Book | Insurance | PUC | Fitness | Permit |
|---|
Status auto-calculated from expiry dates - click a cell to open that document type filter
| Machine | Type | Doc No | From-To | Days Left | Status | File | Actions |
|---|
Sites Management
Manage all sites and yards
EMI Tracker - Loan Installments
Financed machines EMI - next due, overdue, mark paid - set EMI amount + date in the machine form
TOTAL MONTHLY EMI
ā¹0
OVERDUE
0
DUE 7 DAYS
0
PAID THIS MONTH
ā¹0
| Machine | Financer / Loan A/c | EMI Amount | Next EMI Date | Status | Last Payments | Action |
|---|
E-Way Bill Tracker
Track EWB numbers - validity expiry alerts - print report - CSV
ā ļø To generate an actual E-Way Bill use the government portal (button below). Once you have the EWB number, track it here.
TOTAL EWB
0
ACTIVE
0
EXPIRING (1 DAY)
0
EXPIRED
0
| EWB No * | Date | From ā To | Machine / Goods | Value | Vehicle | Valid Upto | Status | Actions |
|---|
Machine Transfer History
Site change history - auto-logged when you edit a machine's site - who, when, from where, to where
TOTAL TRANSFERS
0
THIS MONTH
0
LAST TRANSFER
-
| Date | Machine | From | To | By |
|---|
Hourly Rental Billing
Machine hourly rentals - Hours x Rate - monthly summary - Paid/Pending
HOURS THIS MONTH
0
AMOUNT THIS MONTH
ā¹0
PENDING TOTAL
ā¹0
ALL TIME
ā¹0
| Date | Machine | Client / Site | Hours | Rate | Amount | Status | Actions |
|---|
š MONTHLY SUMMARY - MACHINE WISE RENTALS
| Machine | Hours | Entries | Amount | Paid | Pending |
|---|
Machine Expenses - Maintenance & Running Costs
Per-machine expenses - Maintenance, Diesel, Repair - monthly summary + usage (HMR/KM)
THIS MONTH EXPENSES
ā¹0
THIS YEAR
ā¹0
ALL TIME TOTAL
ā¹0
MAINTENANCE ENTRIES
0
This Month
ā¹0
Diesel / Fuel
ā¹0
Maintenance + Repair
ā¹0
Avg / Machine
-
| Date | Machine | Type | Remark / Vendor | Reading (HMR/KM) | Basic | GST | Total | By | Actions |
|---|
š MONTHLY SUMMARY - MACHINE WISE EXPENSES + USAGE
| Machine | Site | Entries | Maintenance | Reading Start ā End | Usage (Run) | Total Expenses |
|---|
Reading = HMR/KM meter at time of entry - Usage = last minus first reading of the month
ā½ DIESEL MILEAGE REPORT - KM PER LITRE
Enter Reading + Litres on Diesel/Fuel entries - mileage = (Reading2 - Reading1) / Litres between consecutive fills
| Machine | Date | Reading | Litres | Km Run | KM/L | Average |
|---|
User Management - Strong Access Control - Admin Only Decides - V24 PLUS Professional
Admin Only - Decide what other users can see - Other users cannot see anything extra - Only admin can give access - Strong Access Control - Professional
STRONG ACCESS CONTROL - ADMIN ONLY DECIDES
ā¢ Admin - Full Access - All pages - Activity Log, Login History, Audit Trail, Auto-Backup, Backup & Restore, Company Settings, User Management, Reports - All - Super Admin
ā¢ Other Users (Viewer / Site Manager) - Cannot see anything extra - Only what Admin gives access - Default: Dashboard, Machinery, Documents, Sites + Master Data - but the Admin can also grant Reports, Backup, Activity Log etc.
ā¢ Admin decides - In User Management - Edit User - Permissions - Check what pages user can see - Save - Only admin can give access
ā¢ Other users cannot see anything extra - only the Admin grants access - strong, professional, secure
ā¢ Super Admin Change - left menu - change the Admin ID & password there - Admin only
| User / Role | User ID | Password | Permissions - Admin Decides | Status | Actions |
|---|
Add / Edit User - Strong Access Control - Admin Only Decides
PERMISSIONS - WHAT THIS USER CAN SEE - ADMIN ONLY DECIDES - STRONG ACCESS CONTROL
Admin decides - tick the tabs and actions this user can access - unchecked items stay hidden - strong access control
MACHINERY + EXPENSE ACTIONS - ADMIN DECIDES
Note: Other users see only what the Admin grants - Checked pages only visible to this user - Unchecked hidden - Admin Only - Strong Access Control - Professional
Financers Management
Add banks, NBFCs - Used in Finance dropdown
Machinery Types Management
Add custom machinery types - Used in Type dropdown
Manufacturers Management
Add manufacturers - Used in Manufacturer dropdown
Reports - Multiple Options - Free Fleets, All Data Detailed
Free Fleets, Financed, All Detailed - 19 Columns - Site Mandatory - Finance + Purchase
ā FREE FLEETS - DETAILED
TOTAL FREE: 0 ā¢ VALUE: ā¹0
š° FINANCED - DETAILED
TOTAL FINANCED: 0 ā¢ VALUE: ā¹0
š ALL FLEET - 19 COLS DETAILED
TOTAL: 0 ā¢ VALUE: ā¹0
š± MOBILE PDF + WHATSAPP - V29
Mobile friendly summary PDF (print/save) ani WhatsApp var summary share
š£ļø E-WAY BILL + TRANSFERS + BHADE CSV
š° EXPENSES REPORT - EXPENSES + MAINTENANCE
Machine wise expenses - Diesel, Maintenance, Repair - month wise
š FINANCE SUMMARY
š MANUFACTURER / TYPE / SITE / PURCHASER WISE
š PREVIEW - ALL FLEET - 19 COLUMNS
| No | Type | Number | Manufacturer | Site * | Invoice | Finance | Financer | Loan A/c | ROI |
|---|
Activity Log - Kon, Kadhi, Kay Change Kela - V24 PLUS - 100GB
Ramesh - 28 Aug 2026 3:15 PM - MH-12-9999 - Site Change - Kunjirwadi Yard to Niphad - Old: Kunjirwadi, New: Niphad
| DateTime | User & Role | Action | Machine No | Field | Old | New | IP |
|---|
Login History - Kon Kadhi Login Zala - V24 PLUS
TOTAL LOGINS TODAY
0
ACTIVE USERS - 24H
0
FAILED LOGINS
0
| DateTime | User & Role | Action | IP | Device | Status |
|---|
Audit Trail - Permission Wise - V24 PLUS - 100GB
ADMIN - FULL ACCESS
Add, Edit, Delete, Site Change, Finance Change, User Management, Backup, Reports - Sagla
FULL ACCESS
SITE MANAGER - SITE ONLY
Site Change fakt - HMR, Status - Delete nahi - Finance nahi
SITE CHANGE ONLY
VIEWER - READ ONLY
Fakt baghu shakto - Add, Edit, Delete nahi - Reports baghu shakto
READ ONLY
CURRENT USER
Admin
Full Access
| DateTime | User & Role | Action | Machine / Site | Details | Permission |
|---|
Auto-Backup - V24 PLUS - 100GB - [email protected] - Every 1 Hour - 5 Copies + Sheet Auto
100GB Monthly Subscription - Storage motha - Data motha - 1000 machines - 5 copies - 15MB - 0.015% - Tension nahi!
ā° AUTO-BACKUP - EVERY 1 HOUR
Status:Disabled
Last:Never
Next In:- -
Total:0 / 5 Copies
š¾ 100GB - [email protected] - LARGE DATA
100GB Monthly - Subscription - Storage motha - Data motha asnar - 1000+ machines - 5 copies browser madhe - Full ERP JSON - Machines, Sites, Docs, Financers, Types, Manufacturers, Users, Company, Activity Log, Login History, Audit Trail
Calculation:
1000 machines = 2-3MB per backup
5 copies = 15MB
100GB = 100,000MB
15MB = 0.015% - Tension nahi! - 97GB khali!
1000 machines = 2-3MB per backup
5 copies = 15MB
100GB = 100,000MB
15MB = 0.015% - Tension nahi! - 97GB khali!
Photo Storage:
1000 photos - 500KB each = 500MB - 0.5% - Drive var photo theva - Sheet madhe link - V24 PLUS optimized!
1000 photos - 500KB each = 500MB - 0.5% - Drive var photo theva - Sheet madhe link - V24 PLUS optimized!
āļø GOOGLE SHEET - AUTO BACKUP
Pratyek 1 tasala - Auto backup - Google Sheet madhe - Backups Tab - id, date, time, user, machinesCount, totalSize, backupData, type - Auto push - Version history - 1 mahina restore - [email protected] - 100GB - Safe!
STORAGE OPTIMIZATION - 100GB
1000 Machines2-3 MB
5 Copies15 MB - 0.015%
1000 Photos - 500KB500 MB - 0.5%
Total Used~3 GB - 3%
Remaining - 100GB97 GB - 97% Free!
š¦ BACKUP COPIES - 5 COPIES - BROWSER + SHEET - 100GB
| No | DateTime | User | Machines | Size | Action |
|---|
Backup & Restore
Export and import all data - Including Finance + Purchase Details
š¤ EXPORT BACKUP
š„ IMPORT & RESTORE
Select JSON backup - Finance + Purchase details restored
RECYCLE BIN ā¢ RESTORE
Company Settings - REAL CLOUD SYNC
š“ REAL CLOUD SYNC - Google Sheet Live URL - Saglyanna Same Data Sathi
Khali Web App URL taka - Extensions -> Apps Script -> Deploy -> Web App URL - https://script.google.com/macros/s/.../exec
Ha URL saglyanchya PC var same taka - Mag saglyanna same data disel - Real-time!
Khali Web App URL taka - Extensions -> Apps Script -> Deploy -> Web App URL - https://script.google.com/macros/s/.../exec
Ha URL saglyanchya PC var same taka - Mag saglyanna same data disel - Real-time!
* Ha URL saglyanna dya - Pratyek PC var same URL - Real sync - 10 sec madhe saglyanna disel
Company Details
Cloud & Sync - Supabase + Google Drive
Free online setup - database on Supabase, documents on your Google Drive (100GB) - real-time sync for the whole team
1ļøā£ SUPABASE - DATABASE + REALTIME
STATUS:
2ļøā£ GOOGLE DRIVE - DOCUMENT STORAGE (100GB)
Documents upload to ERP_Documents folder in the connected Gmail's Drive ([email protected] - 100GB). If Drive is not connected, files are stored in the browser as fallback.
STATUS:
SUPABASE SQL - RUN ONCE (paste in SQL Editor)
create table if not exists erp_data ( id text primary key, data jsonb, updated_at timestamptz default now() ); alter table erp_data replica identity full; alter publication supabase_realtime add table erp_data;
š STEP-BY-STEP SETUP GUIDE - ą¤øą„ą¤ą¤ ą¤Ŗ ą¤ą¤¾ą¤ą¤” (Marathi)
A) Google Drive API ([email protected] sathi):
1. console.cloud.google.com var jaa - tumcha Gmail ne login kara
2. "New Project" - nav "Fleet-ERP" theva - Create
3. Left menu - "APIs & Services" - "Library" - "Google Drive API" shodha - "Enable" daba
4. "APIs & Services" - "OAuth consent screen" - External - App nav "Fleet ERP" - tumcha email add kara - Save
5. "Credentials" - "Create Credentials" - "OAuth Client ID" - Application type = Web application
6. "Authorized JavaScript origins" madhe tumcha site add kara (e.g. https://tumcha-app.vercel.app) ani local sathi http://localhost
7. milalela Client ID copy karun var "GOOGLE DRIVE OAUTH CLIENT ID" box madhe takun "CONNECT GOOGLE DRIVE" daba
8. Popup madhe [email protected] select kara - permissions dya - jhala! Files autoprat ERP_Documents folder madhe jatil
1. console.cloud.google.com var jaa - tumcha Gmail ne login kara
2. "New Project" - nav "Fleet-ERP" theva - Create
3. Left menu - "APIs & Services" - "Library" - "Google Drive API" shodha - "Enable" daba
4. "APIs & Services" - "OAuth consent screen" - External - App nav "Fleet ERP" - tumcha email add kara - Save
5. "Credentials" - "Create Credentials" - "OAuth Client ID" - Application type = Web application
6. "Authorized JavaScript origins" madhe tumcha site add kara (e.g. https://tumcha-app.vercel.app) ani local sathi http://localhost
7. milalela Client ID copy karun var "GOOGLE DRIVE OAUTH CLIENT ID" box madhe takun "CONNECT GOOGLE DRIVE" daba
8. Popup madhe [email protected] select kara - permissions dya - jhala! Files autoprat ERP_Documents folder madhe jatil
B) Supabase (Free database + realtime):
1. supabase.com var jaa - GitHub ne "New project" banava (free)
2. Project banlyavar "Settings - API" madhun Project URL ani anon public key copy kara
3. Left "SQL Editor" madhe varcha SQL paste karun "Run" daba (erp_data table banel)
4. He don values var "SUPABASE" section madhe takun "CONNECT SUPABASE" daba
5. Realtime auto chalu hota - ek user data badlti tar dusranna refresh-vina disel
1. supabase.com var jaa - GitHub ne "New project" banava (free)
2. Project banlyavar "Settings - API" madhun Project URL ani anon public key copy kara
3. Left "SQL Editor" madhe varcha SQL paste karun "Run" daba (erp_data table banel)
4. He don values var "SUPABASE" section madhe takun "CONNECT SUPABASE" daba
5. Realtime auto chalu hota - ek user data badlti tar dusranna refresh-vina disel
C) Vercel var deploy (free hosting):
1. He file "index.html" navachya folder madhe theva - GitHub var new repository banava - file upload kara
2. vercel.com - "Add New Project" - GitHub repo select kara - "Deploy" daba
3. 1 minute madhe tumcha ERP online: https://tumcha-app.vercel.app
4. Team members la he link pathava - saglikade internet ch dista!
1. He file "index.html" navachya folder madhe theva - GitHub var new repository banava - file upload kara
2. vercel.com - "Add New Project" - GitHub repo select kara - "Deploy" daba
3. 1 minute madhe tumcha ERP online: https://tumcha-app.vercel.app
4. Team members la he link pathava - saglikade internet ch dista!
D) Data kuta save hota? (Safety - Requirement 11):
ā¢ Data (machines, expenses, users): Browser localStorage + Supabase cloud (connect asel tar)
ā¢ Documents (PDF/photos): Google Drive - tumcha 100GB - ERP_Documents folder
ā¢ Backup: Backup & Restore tab - Export JSON + Reports madhu CSV; Supabase Table Editor - erp_data - download
ā¢ Drive full jali tar: Drive madhun juna files delete kara (30 din trash madhe rahatat) - ERP chalto rahil
ā¢ Restore: Backup & Restore tab madhun JSON import kara
ā¢ Bug aala tar: Cloud & Setup - PULL FROM CLOUD - browser data harvle tari cloud madhun punha yet
ā¢ Data (machines, expenses, users): Browser localStorage + Supabase cloud (connect asel tar)
ā¢ Documents (PDF/photos): Google Drive - tumcha 100GB - ERP_Documents folder
ā¢ Backup: Backup & Restore tab - Export JSON + Reports madhu CSV; Supabase Table Editor - erp_data - download
ā¢ Drive full jali tar: Drive madhun juna files delete kara (30 din trash madhe rahatat) - ERP chalto rahil
ā¢ Restore: Backup & Restore tab madhun JSON import kara
ā¢ Bug aala tar: Cloud & Setup - PULL FROM CLOUD - browser data harvle tari cloud madhun punha yet
Super Admin Change - Admin ID & Password
Change the Admin User ID & Password - current password required - Admin only
š CHANGE ADMIN ID & PASSWORD
ā ļø RESET TO DEFAULT
If you forget the password, admin credentials can be reset to default.
Dhurandhar: After reset, login with admin / admin123 and set a new password immediately.
No credentials are shown on the login page - security.
Syncing - Real-time active - Changes visible to all users in 10 seconds