Skip to content
Payment Due Date Tracker cover: a sample sheet with still to pay, paid so far and overdue and a bar chart, beside the Dashboard and Payments tabs

Payment Due Date Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Payment Due Date Tracker is for anyone who juggles bills paid by card, bank transfer, check or cash. The Payments tab lists the payee, payment method, due date, amount, status and a Days left column that counts down from today. Overdue rows turn red so they stand out the moment you open the file.

The Dashboard shows what is still to pay, what you have paid, how many items are overdue, the earliest unpaid due date and how many fall within the next seven days. A chart compares unpaid and paid amounts by payment method, which helps when you check whether the account behind each method has enough money in it.

Useful for

  • Seeing which bills fall due in the next week
  • Checking the bank balance before a run of direct debits
  • Catching a missed card payment before a late fee

What's included

  • 3 tabs: Dashboard, Payments, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Payments: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Payments tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Can the tracker send me reminders?

Not by itself. Google Sheets and Excel do not send alerts from this file. The Due in the next 7 days figure on the Dashboard shows what needs attention, so check it each time you open the file, or set a calendar reminder that points to it.

What happens to a bill when I pay it late?

Change its status to Paid when the money leaves your account and note the date in the description. The row stops counting as overdue, but the record still shows the bill was late, which helps when you query a charge.

How do I add a bill that repeats every month?

Add one row for each due date. Copy the last row, change the due date and reset the status to Waiting. Keeping a full year of rows makes it easy to see your yearly spending on each payee.

  • #bill-tracker
  • #due-date-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 8

Also in Finance

All finance templates
Get this template

Preparing your template…