Skip to content
Accounts Receivable Tracker cover: a sample sheet with billed, collected and outstanding and a bar chart, beside the Dashboard and Invoices tabs

Accounts Receivable Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

This tracker is for freelancers and small firms that send invoices and wait for payment. Each invoice gets a row on the Invoices tab showing the client, issue date, due date, amount billed, amount paid, status, and a balance that updates on its own. Days overdue counts from the due date while anything is still owed, and rows with an overdue balance turn red.

The Dashboard totals billed, collected and outstanding amounts, the past-due figure and the collection rate. A bar chart compares what each client has been billed with what they still owe. The sample list covers ten invoices to six clients, with a partly paid bill, a disputed one and two that are past their due dates.

Useful for

  • Chasing clients who are past their due dates
  • Checking how much cash is tied up in unpaid invoices
  • Spotting clients who pay late more often than others

What's included

  • 3 tabs: Dashboard, Invoices, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Invoices: 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 Invoices 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

When should I start chasing a late invoice?

Many businesses send a polite reminder a few days after the due date and a firmer one after two weeks. Use the Days overdue column to decide. Keep your messages factual, and log each contact in the description so the history is clear.

How do I record a partial payment?

Enter the amount received in the Paid column and set the status to Partly paid. The balance and days overdue update straight away, so the remaining amount is always visible.

Does the tracker show whether a client is a bad payer?

It shows the figures that help you judge that, such as the balance owed and the days overdue for each invoice. Use the client breakdown on the Dashboard to compare clients side by side, then decide what to do based on your own contract terms.

  • #profit-and-loss
  • #accounts-receivable-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…