Excel-backed ledger
Smart Fin 365
App Server
Checking Smart Fin 365 server...
View Setup Instructions
How to Create Google OAuth Credentials
Copy this exact URI into Google Cloud Console under Authorized redirect URIs. The protocol, domain, port, path and trailing slash must match exactly.
- Step 1 - Create a Google Cloud Project
Open Google Cloud Console, sign in with the Gmail account used for Smart Fin 365, create a project named "Smart Fin 365", and select it.
Google Cloud Console - Step 2 - Enable Google APIs
Open APIs & Services - Library. Enable Google Drive API, Google Sheets API, and Gmail API only if the application sends Gmail messages.
API Library - Step 3 - Configure Google OAuth Branding
Open Google Auth Platform, enter "Smart Fin 365" as the application name, add support/developer emails, upload the logo, and save.
OAuth BrandingGoogle branding guide - Step 4 - Configure the Audience
Select External for personal Gmail accounts. Use Internal only for Google Workspace. Keep Testing during setup and add the Smart Fin 365 Gmail address as a test user.
OAuth AudienceAudience guide - Step 5 - Configure Data Access
Add only required scopes: drive.file, spreadsheets, openid, email, profile, and gmail.send only when Gmail sending is enabled.
OAuth ScopesData access guide - Step 6 - Create the OAuth Client
Open Google Auth Platform - Clients, create a Web application client, and name it "Smart Fin 365 Web Client".
OAuth ClientsOAuth client guide - Step 7 - Add Authorized JavaScript Origins
For local use enter http://localhost:3333. For production enter the exact HTTPS domain. Do not include a page path.
- Step 8 - Add Authorized Redirect URIs
Use the exact Authorized Redirect URI displayed above. Local is normally http://localhost:3333/oauth2callback. Production is generated from the configured public application URL.
- Step 9 - Configure the Server
Configure the OAuth Client ID and Client Secret only in the protected server environment. Never enter the Client Secret into this webpage. Then connect Google, approve permissions, and test Upload Excel Now.
Official Google Guides
Google OAuth for web-server applications Google Auth Platform setup Manage OAuth clients Google Drive API Node.js quickstartSync Monitoring
Checking webpage, local Excel and Google Drive sync status...
Lent Summary
Loans and Property Loans Summary
Chitty Summary
Trading Summary
Trading
0 recordsToken help: Upstox Zerodha Dhan
| ID | Asset Type | Symbol / Name | Invested Date | Average Buy Price | Current Market Price | Quantity | Invested Value | Current Value | Realised P/L | Unrealised P/L | Profit/Loss | Profit % | Last Updated Timestamp |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No trading records yet. | |||||||||||||
Yearly Growth
Loading chart...Chitty Growth Graph
Loan Growth Graph
Trading Growth Graph
Properties
0 records| ID | Property Location | Google Map Location | Property Size | Property Dimensions | Previous Land Owner | Purchase Price / SqY | Purchase Total Price | Document Number | Registration Date | Sell Price / SqY | Sell Total Price | Present Owner | New Owner | Notes | Created At |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No property records yet. | |||||||||||||||
All Entries
0 records| Date | Type | Name | Amount | Final / Pending | Status | Notes | Actions |
|---|---|---|---|---|---|---|---|
| No records yet. | |||||||