● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Invoices Clients & CRM›Recurring Invoice Tracker
Recurring Invoice Tracker hero view showing the recurring invoice tracker spreadsheet and its headline features
INVOICES CLIENTS & CRM

Recurring Invoice Tracker

Retainer income is the steadiest money a freelancer can earn, and the easiest to let slip. This recurring invoice tracker keeps every plan visible: set each one up once, and due dates, overdue flags and your monthly recurring revenue all look after themselves.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Steady income that never slips quietly

Repeat billing fails in a boring way: a renewal slips by, a payment date shifts, a quarterly plan drifts past its due date, and the gap only shows up weeks later when the money has not arrived. This tracker exists to make that impossible. Each plan gets set up a single time: client, amount, how often it bills and when it started, and the tracker keeps watch over every due date from then on.

The next due date is always calculated, never typed. Monthly plans step forward a month from the last payment, quarterly plans three months, annual plans twelve, and a brand new plan counts from its start date. Log a payment when it arrives and push the last payment date forward; the next due date follows automatically, with overdue and due-soon plans flagged clearly.

The Overdue and Reminders tab is the one to read before you chase anyone: it shows how many days late each plan is and suggests what to send. Meanwhile the Monthly Recurring Revenue tab turns all your plans into one steady monthly figure, counting quarterly plans as a third and annual plans as a twelfth, and the Annual Summary sets payments received against that figure month by month.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a copy link for your own Sheets version
  • BLANK Excel workbook, ready to set up your own plans
  • EXAMPLE Excel workbook filled with realistic demo data to explore first
  • Quick Start Guide PDF covering setup in Excel and Google Sheets
  • Separate files, delivered individually, ready to use straight away

Good to know

  • Runs in Microsoft Excel and in Google Sheets, same formulas in both
  • Due soon means a due date within the next seven days
  • It tracks billing, it does not send invoices or collect payments
  • Built for freelancers and small businesses with repeat clients
  • Questions? Message us on Etsy and we will help you get set up

Questions about this template

The things buyers ask us most.

How does the tracker know my next due date?

You never type it yourself. Monthly plans add one month from the last payment, quarterly plans add three and annual plans add twelve. For a brand new plan with no payment yet, the date is worked out from the start date. Log a payment, update the last payment date, and the next due date moves forward on its own.

When is a plan overdue, and when is it just due soon?

Overdue means the next due date has already passed. Due soon means that date falls inside the coming week. The Overdue and Reminders tab gathers both groups in one place, shows the days overdue for each, and gives you a plain reminder instruction so chasing never feels improvised.

How is monthly recurring revenue calculated?

Monthly plans count in full. Quarterly plans contribute a third of their amount each month, and annual plans a twelfth, so every plan is converted to the same monthly footing. The total is the steady monthly income your active plans represent, and the Annual Summary compares it with payments actually received.

Does it send invoices or take payments?

No. This workbook is a tracker, not a billing service. It remembers every plan, works out due dates, flags what is late and totals your recurring revenue, but the invoices themselves still go out through whatever you already use to bill clients. Use the two side by side and nothing slips between them.

More in Invoices Clients & CRM

All templates in this category →

Three more workbooks from the same shelf.

Freelancer Client Invoice Tracker

Clients, invoices and follow-ups in one sheet, with overdue payments flagged for you.

$6.99 $2.80
View on Etsy
Small Business Payment Log

Log installment plans and payments, and always know what is collected, outstanding and overdue.

$3.99 $1.60
View on Etsy
Small Business Lead Tracker

Every lead, stage and follow-up in one place, with pipeline value and win rate automatic.

$3.99 $1.60
View on Etsy
View on Etsy · $3.00