Back

Loans Management System (Pautang Tracker)

Business Tools

💰 Loans Management System (Pautang Tracker)

Automate your lending business with smart tracking and automatic email reminders!

🚀 The Ultimate Lending Solution

Introducing the Loans Management System — a powerful Google Sheets and Apps Script-based tool designed for individuals and businesses who lend money. Say goodbye to manual tracking, awkward follow-ups, and forgotten due dates.

This system automatically calculates interest, organizes your active records, and most importantly, sends automatic email reminders to your borrowers on their exact due date!

⚖️ Manual vs Automated

❌ The Old Way (Manual)

  • Messy paper trails and lost records.
  • Forgetting to follow up on due dates.
  • Awkward confrontations asking for payment.
  • Manual computation of interest rates.

✅ The New Way (Automated)

  • Clean, digital, and searchable records.
  • System automatically sends reminders via email.
  • Professional and stress-free collection process.
  • Auto-calculates interest based on your set rate.

✨ Premium Features Included

Automated Email Triggers
The system runs a background check every 5 minutes. Once a due date hits, it automatically emails the borrower and updates you (the admin) as well.
Friendly vs. Business Loans
Supports two types of loans: Friendly Loans (0% Interest) for personal lending to friends/family, and Business Loans where you can set a specific interest rate.
Customizable Email Templates
The system auto-generates a polite, professional email message based on the borrower's name and amount due. You can edit this message before saving!
Admin PIN Protection
The dashboard is protected by an Admin PIN. Only you can view, add, edit, or delete sensitive loan records.
Auto Interest Calculation
Just input the Principal and Rate %. The system instantly computes the exact Interest Due.
Mobile Responsive PWA
Access your dashboard anytime, anywhere using your smartphone. Installable directly on your home screen.

🎯 Who is this for?

Small Lending Businesses Sari-Sari Store Owners Individuals who lend money Cooperative Treasurers

📺 Live App Preview

💰
Loans Management System
Admin Login → Add Record → Auto Send Email

👉 To try the live preview, use the Admin PIN: 12345


CLICK FOR LIVE PREVIEW

📚 How to Use the System

👨‍🏫 For the Admin / Lender:

  1. After purchasing, click the "Make a Copy" link sent to your email.
  2. Open the Google Sheet and go to the Settings tab to change your Admin PIN and set your Sender Name (the name that will appear in emails).
  3. Deploy the Web App (Extensions > Apps Script > Deploy > Web app). Set access to "Anyone".
  4. Open the Web App URL and log in using your PIN.
  5. Fill up the form: Name, Principal, Rate (use 0 for friendly loans), Gmail, and Due Date.
  6. The system auto-generates the email message. You can edit it if you want, then click SAVE RECORD.
  7. Once the Due Date arrives, the system automatically emails the borrower.
  8. When the borrower pays, simply click Paid in the table to archive the record.

⚠️ Important Note on the "Send" Button:

  • The system automatically checks and sends emails every 5 minutes in the background.
  • Sometimes, emails might be delayed by a few minutes due to Google's servers.
  • The "Send" button in the table is strictly for manual retries. Use it ONLY if the system completely failed to send the email.
  • Do not spam the "Send" button if the email is just late, otherwise, the borrower will receive duplicate emails!

❓ Frequently Asked Questions

What is the difference between Friendly Loans and Business Loans?
Friendly Loans are for lending money without profit (0% interest)—the borrower just pays the exact principal amount. Business Loans allow you to set an interest rate (e.g., 5%), and the system calculates the interest as the amount due.
How does the automated email reminder work?
Once you save a record, a background trigger runs every 5 minutes. If it detects that the current time matches or passes the Due Date you set, it automatically sends a polite email to the borrower's Gmail. It also sends a notification to you (the admin) so you know the reminder was sent.
Can I edit the email message before it sends?
Yes! When adding a new record, the system auto-formats a professional message in the text box. You can edit this text before clicking Save Record. The system will send exactly what is written in that box.
Is my data secure?
Yes. The data is saved directly to your own Google Sheet. The dashboard is protected by an Admin PIN that only you know.

Get Your Copy Today!

One-time payment. Use it forever for your lending business.

Special Price
₱200.00 ONLY

BUY NOW VIA GCASH

After payment, you will receive an email with the link to make your own copy of the system. No coding required!