Business Tools • Version 2

💰 Loans Management System V2 (Pautang Tracker)

Our best-selling lending tool — rebuilt from the ground up with payment tracking, smart follow-ups, and a live dashboard!

🚀 The Next Evolution of Lending Automation

After the success of the original Loans Management System, we listened to real feedback from real lenders — and built the upgrade they asked for. Introducing Loans Management System V2: the complete command center for your lending business.

V2 doesn't just send reminders anymore. It now tracks every peso — partial payments, running balances, overdue accounts, and total collections — all visible in one beautiful live dashboard. Borrowers can't slip through the cracks, because the system keeps following up until the loan is fully paid.

⚖️ Version 1 vs Version 2

📱 Version 1 (Basic)

Records are deleted once marked "Paid" — no history.
Sends only ONE reminder — no automatic follow-ups.
Flat (one-time) interest computation only.
No payment tracking — a loan is either unpaid or paid.
No overview of your whole portfolio.

🚀 Version 2 (Complete)

Full history — paid loans are safely archived in a Paid tab.
Follow-up reminders repeat until the loan is fully settled.
Flat OR Monthly × Term interest with loan terms.
Partial payments with live balance and complete payment history.
Live dashboard with real-time stats and overdue alerts.

💡 On a budget, or just need the basic auto-reminder features? Version 1 is still available at a lower price — Click here to view Version 1 →

✨ Premium Features Included

Payment Tracking & History

Record partial or full payments with one tap. The balance updates instantly, every payment is logged with date and note, and the loan is automatically marked Fully Paid once the balance hits zero.

Live Dashboard & Statistics

Active loans, outstanding balance, total collected, overdue count, expected interest, and fully paid count — all in real time, at a glance.

Overdue Monitoring

Overdue loans are highlighted in red with a day counter showing exactly how late each payment is — plus a dedicated overdue list on the dashboard.

Smart Follow-up Reminders

If a borrower ignores the first reminder, the system automatically re-sends emails every few days (you choose the interval) until the loan is fully paid. No more awkward follow-ups!

Flexible Interest Modes

Choose between Flat (one-time) interest or Monthly × Term interest for long-term loans. Example: ₱10,000 at 5% monthly for 6 months — computed automatically.

Editable Email Templates

Design your own reminder email in the Settings tab using placeholders like {borrower_name} and {balance}. Amounts are always up to date at send time — and custom messages per loan are supported too.

Built-in Search

Instantly find any borrower by name or email — even with hundreds of active records.

Enhanced Security

Admin PIN protection — now changeable directly inside the app, no more editing the spreadsheet! Plus an automatic session timeout that logs you out after inactivity.

Activity Logs

Every save, edit, payment, and email is recorded in a dedicated Logs sheet — perfect for reviewing your history or settling disputes.

Mobile Responsive PWA

Install the app directly on your home screen and manage your lending business anytime, anywhere.

🎯 Who is this for?

Small Lending Businesses Sari-Sari Store Owners with Utang Individuals who lend money Cooperative Treasurers Version 1 users ready to level up

📺 Live App Preview

💰

Loans Management System V2

Dashboard → Add Loan → Track Payments → Auto Email + Follow-ups

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

CLICK FOR LIVE PREVIEW

📚 How to Use the System

👨‍🏫 For the Admin / Lender:

After purchasing, click the "Make a Copy" link sent to your email.
Open the Google Sheet → Extensions > Apps Script > Deploy > New deployment > Web app. Set Execute as: Me and Who has access: Anyone, then Deploy and authorize the permissions when prompted.
Open the Web App URL and log in using the default PIN: 1234
Go to the ⚙️ Settings tab: change your PIN, set your Sender Name, customize your email template, and configure your follow-up reminder interval.
Add loans from the Interest or Friendly tab: Name, Principal, Rate (use 0 for friendly loans), Interest Type, Term, Gmail, and Due Date.
When a borrower pays, tap the 💰 button to record the payment — the balance updates instantly, and each payment is saved in the payment history.
On the due date, the borrower receives the email automatically. If follow-ups are enabled, the system keeps reminding them every few days until the balance reaches zero.
Fully paid loans automatically move to the ✅ Paid tab — your complete history is preserved forever, and your dashboard totals update in real time.

⚠️ Important Note on Reminders:

The system automatically checks and sends emails every 5 minutes in the background.
If follow-up reminders are enabled, the system re-sends the email every X days (default: 7) until the loan is fully paid — you control the interval, or you can turn it off, in the Settings tab.
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's the difference between Version 1 and Version 2?

V2 adds payment tracking with partial payments, a live statistics dashboard, overdue monitoring with day counters, automatic follow-up reminders that repeat until fully paid, monthly × term interest, a permanent Paid history tab, built-in search, in-app PIN changing, session timeout, and activity logs. V1 is a simpler tool that sends a one-time reminder and deletes the record once marked paid.

Is Version 1 still available?

Yes! Version 1 is still available for those who prefer a simpler, more affordable tool that focuses on the core automatic email reminder feature. View Version 1 here → But if you want payment tracking, automatic follow-ups, and the live dashboard, V2 is definitely the better investment.

How do partial payments work?

Just tap the 💰 button on any loan and enter the amount received (e.g., ₱500 out of ₱5,000). Every payment is logged with its date and an optional note (GCash, cash, etc.), and the remaining balance updates instantly. Once the balance reaches zero, the loan is automatically marked Fully Paid. You can even delete a wrongly-encoded payment and the balance recomputes automatically.

What happens to loans after they're fully paid?

They move to the ✅ Paid tab, which keeps the principal, interest, total collected, and the date paid. Nothing is ever deleted automatically — only the 🗑 button removes a record permanently, and it asks for confirmation twice.

How do follow-up reminders work?

After the first reminder on the due date, the system automatically re-sends a follow-up email every X days (you set the interval — default is 7) for as long as the loan has a remaining balance. You can also disable follow-ups entirely in the Settings tab. You (the admin) are notified only on the first reminder, so your inbox never gets spammed.

What is the difference between Flat and Monthly interest?

Flat interest is a one-time percentage of the principal — ₱10,000 at 5% = ₱500 interest. Monthly × Term applies the rate per month for the duration of the loan — ₱10,000 at 5% monthly for 6 months = ₱3,000 interest. The system computes both automatically; you just pick the type and enter the term.

Is my data secure?

Yes. The data is saved directly to your own Google Sheet — only you have access to it. The dashboard is protected by an Admin PIN that you can change inside the app, and the session automatically logs out after a period of inactivity.

Level Up Your Lending Business Today!

One-time payment. Lifetime use. The complete lending command center.

Special Price

₱399.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!