Jayco Engineering
Customer Portal — staff sign in
Password
Sign in
⚙️ First-Time Setup
Connect this system to your Google Sheets database.
1
Create a new Google Sheet & copy its
Sheet ID
from the URL
2
Copy the
Code.gs
file into Google Apps Script bound to that sheet, deploy as
Web App
(Anyone access)
3
Run
setupSheets()
once from Apps Script editor to create headers
4
Paste your
Web App URL
below and click Save
Apps Script Web App URL
Auth Token (must match Code.gs)
Save & Launch
Loading…
Receivables Manager
CA Amit N Lakhtariya
M. No. 117820 · +91 9376139815
Staff Portals
⎋ Log out
Overview
📊
Dashboard
Masters
👥
Customers
Transactions
🧾
Bills / Invoices
💳
Payments
Reports
📋
Outstanding
💵
Cashflow Forecast
⚡
Advance Report
📄
Statement
Tools
📥
Excel Import
Dashboard
Sales & Receivables Overview
🔍
⚙️ Settings
Add Customer
✕
Customer Name *
GSTIN
Phone
Email
Credit Days
Credit Limit (₹)
Address
Add Bill
✕
Customer *
Bill / Invoice No *
Bill Date *
Invoice Amount (₹) *
Credit Period (days)
Due Date
— auto-set from credit period, or pick a date directly
Narration / Remarks
📎 Attachments
— paste Google Drive / Dropbox / any shareable link
+ Add Link
Record Payment
✕
Customer *
Payment Date *
Amount Received (₹) *
Mode
NEFT
RTGS
IMPS
Cheque
Cash
UPI
Reference No
Narration
📎 FIFO Allocation Preview
Date
Bill No
Balance
Apply
Remaining
Statement of Account
✕
Confirm Delete
✕
📎 Attachments
✕
Import from Excel
✕