Thoughtful templates. Instant downloads.
RizqtekStudio.
Launch gift: 4 of 5 free template claims remainUse STUDIOFIRST5 →

DueGuard — Overdue Receivable & Bill Reminder Engine

EXCEL TEMPLATE · BUSINESS & WORK

DueGuard — Overdue Receivable & Bill Reminder Engine — Excel Template

Automated stage-based overdue customer invoice chasers and upcoming vendor bill reminders.

Designed for business owners who forget to chase overdue customer invoices or miss upcoming vendor bill deadlines. DueGuard checks your payment register, emails customers across configurable overdue stages (e.g., 1, 7, 14 days), and sends upcoming/due/overdue vendor bill reminders to the owner with full stage-history deduplication.

$59.00 USD · ONE-TIME PURCHASE

Digital download · No physical item

Refunds & download support · Template licence

Software requirementsGoogle Sheets (runs natively in browser via included Google Apps Script .gs file; uses Google Drive and Gmail services where applicable).

Try the free budget starter · Read practical guides

  • Monitors both customer RECEIVABLE rows and vendor BILL deadlines from one unified Google Sheets register
  • Configurable overdue stages (default 1, 7, 14 days) and upcoming bill lead window (default 3 days)
  • Non-destructive Preview tab and TEST mode that routes all test reminders exclusively to your TestEmail

From the people who use it.

No published customer reviews yet.

Purchased this product? Sign in to review it. Link guest orders from your private receipt first.

Consider the details.

What’s inside
  • Monitors both customer RECEIVABLE rows and vendor BILL deadlines from one unified Google Sheets register
  • Configurable overdue stages (default 1, 7, 14 days) and upcoming bill lead window (default 3 days)
  • Non-destructive Preview tab and TEST mode that routes all test reminders exclusively to your TestEmail
  • Optional daily scheduled trigger with ReminderLog ledger that prevents emailing the same stage twice
  • Includes complete Google Apps Script (02-DueGuard.gs), setup manual, and sample payments CSV

02-DueGuard.gs, 02-DueGuard-GUIDE.md, START-HERE.md, SELLER-ACCEPTANCE.md, and examples/payments-sample.csv packaged in a clean ZIP archive.

Software & capacity

Google Sheets (runs natively in browser via included Google Apps Script .gs file; uses Google Drive and Gmail services where applicable).

  • Requires Google Sheets and Gmail permissions; daily automation subject to standard Google Apps Script email quotas.
  • Relies on manually updated payment statuses (OPEN, PAID, HOLD) and balances; does not auto-sync with bank feeds.
  • Final automated reminder stops after the highest configured overdue stage.
Download & getting started
After captured payment is verified, the order page provides your download links. Save your private order access link. Extract the ZIP, read Quick_Start.txt, and save a working copy of the clean workbook. Read the download guide
Licence & product support
One purchaser may use this digital automation package internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the source files or scripts is prohibited. Copyright 2026 RizqtekStudio. All rights reserved. Read the licence

Questions about this template

What is included with DueGuard — Overdue Receivable & Bill Reminder Engine?

02-DueGuard.gs, 02-DueGuard-GUIDE.md, START-HERE.md, SELLER-ACCEPTANCE.md, and examples/payments-sample.csv packaged in a clean ZIP archive.

What software is required to use DueGuard — Overdue Receivable & Bill Reminder Engine?

Google Sheets (runs natively in browser via included Google Apps Script .gs file; uses Google Drive and Gmail services where applicable).

How do I receive DueGuard — Overdue Receivable & Bill Reminder Engine after purchasing?

After captured payment is verified, your private order page provides download links and a receipt is emailed. A valid complimentary claim also provides access without payment.

What licence applies to this template?

One purchaser may use this digital automation package internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the source files or scripts is prohibited. Copyright 2026 RizqtekStudio. All rights reserved.

A little more possibility.

All templates