Skip to content
Accounts Payable Tracker cover: a sample sheet with open bills, overdue and paid to date and a bar chart, beside the Dashboard, Bills and Vendors tabs

Accounts Payable Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Bookkeepers, office managers and small business owners use this accounts payable tracker to keep every supplier bill in one place. On the Bills tab every invoice gets a row holding its bill number, vendor, category, invoice and due dates, amount and status, and works out the days late for anything not yet paid. The Vendors tab keeps each supplier's payment terms and accounts contact, and totals what has been billed to them. The Dashboard shows open bills, overdue amounts, paid totals and a chart of open and overdue money by category.

Start by listing your main suppliers on the Vendors tab so every bill can be matched to its terms. Sort the Bills tab by due date before each payment run, and change the status to Paid as the money leaves your account. If the bills run past a few hundred rows, copy the finished months to an archive sheet so the working file stays quick. Red rows mark overdue bills, so a short weekly look at the Dashboard keeps late payments to a minimum.

Useful for

  • Track supplier bills and their due dates each week
  • Spot overdue vendor invoices before late fees apply
  • See which spending categories hold the most unpaid bills

What's included

  • 4 tabs: Dashboard, Bills, Vendors, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Bills: a table
  • Vendors: 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 Bills 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

How do I mark a bill as paid?

Change its status on the Bills tab from Open or On hold to Paid. The amount drops out of open bills on the Dashboard, and its days late stops counting. Keep the bill number so the record matches what your accounting system shows.

Can I record a part-payment on one bill?

The status column holds Open, On hold or Paid, so a part-payment needs its own row. Enter the remaining balance as a new bill with the same vendor and a suffix on the bill number, such as AP-1047B. Each amount then stays visible and counts correctly on the Dashboard.

How are days late worked out?

Days late is today's date minus the due date, for any bill that has passed its due date and is not marked Paid. The figure refreshes whenever the sheet recalculates, so an overdue bill keeps counting until you pay it or correct its due date.

  • #profit-and-loss
  • #accounts-payable-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…