💰
LoanLedger Pro
Professional loan management.
Powered by your Google Sheet & Drive.
Step 1 — Google Sheet
Create 6 tabs in your Sheet
Name them exactly (case-sensitive):
Tab 1: Borrowers
Headers (A→N): BorrID | Name | Phone | AadhaarNo | PANNo | Address | RegisteredAt | Phone2 | Email | GtorName | GtorPhone | GtorAadhaar | GtorPAN | GtorAddress
Tab 2: Parties
Headers (A→N): LoanAccNo | BorrID | BorrName | LoanAmount | LoanDate | ReturnDate | InterestRate | Status | TotalProfit | Notes | CreatedAt | DisburseSplits | ActualReturnDate | Guarantor
Tab 3: Profits
Headers (A→J): ID | LoanAccNo | PartyID | PartyName | Date | TotalAmount | Splits | Notes | CreatedAt | Type
Tab 4: Documents
Headers (A→I): ID | PartyID | PartyName | FileName | Label | FileType | DriveFileId | DriveUrl | UploadedAt
Tab 5: Users
Headers (A→C): Username | PasswordHash | UpdatedAt
Tab 6: Audit
Headers (A→F): ID | Timestamp | Action | Entity | EntityID | Detail
Step 2 — Apps Script
Extensions → Apps Script → paste full script
Deploy as Web App · Execute as: Me · Access: Anyone
Your data lives in your own Google account only.