Paying a bill late costs more than a late fee. It strains the relationship with a supplier you depend on, it can put you on prepayment terms, and it often means you missed a cheaper option: paying a few days early for a discount. Most small businesses don’t pay late because they lack the money. They pay late because the bills are scattered across email, a desk drawer and three vendor portals, and nobody has one list.
This free accounts payable tracker is that list. Enter each bill once and it tells you what’s overdue, what’s due this week, how much cash you need week by week, and which early-payment discounts are still available. Use the online version on this page, or download the Excel template.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice.
Free online accounts payable tracker
Type your unpaid bills below, or click Load example to see how it works. The report updates as you type. You can print it, save it as a PDF, download it as Excel, Word or CSV, email it, or copy a link that opens the same report on another computer. If you’re signed in, Save to my account keeps it for next time.
3. Your payables report
Cash needed by week
Payment schedule
Open payables by vendor
Next bills to pay
Made with the free accounts payable tracker at bookkeepingsheets.com
What is an accounts payable tracker?
Accounts payable (A/P) is the money your business owes to suppliers for goods and services you’ve already received: inventory, rent, utilities, insurance, contractors, software. An A/P tracker is a list of those unpaid bills with the date each one is due, so you can plan payments instead of reacting to reminder emails.
It’s the mirror image of an accounts receivable aging report. Receivables tell you what’s coming in; payables tell you what has to go out. Put the two side by side, or feed both into a 13-week cash flow forecast, and you can see a cash crunch weeks before it happens.
What’s inside the Excel template
- Start Here: business name, today’s date (or type
=TODAY()), how many days count as “due soon” (7 by default) and, optionally, the cash you have available to pay bills. - Bills: room for 150 bills. You enter the vendor, bill number, bill date, payment terms in days, amount, any partial payments and, if offered, an early-payment discount. The template calculates the due date, balance, days until due, status (Overdue, Due soon, Upcoming or Paid), the discount deadline, the discount still available and the date you should pay by.
- AP Report: six headline numbers, a week-by-week payment schedule, open balances by vendor and a list of the next 15 bills to pay, earliest first.
Overdue bills turn red, bills due soon turn orange, and paid bills fade to gray and drop out of the report. The template comes with eleven example bills so you can see the report filled in; delete them and enter your own.
How to use it
1. Enter every bill when it arrives
The habit that makes A/P work is simple: when a bill arrives, it goes on the list the same day, before it goes in a folder. Enter the vendor name the same way every time (“Coastal Paper Supply” and “Coastal Paper” would count as two vendors), the bill number, the bill date (the date on the invoice, not the day you opened it), the payment terms in days and the amount.
Payment terms are usually printed on the bill. Net 30 means payment is due 30 days after the bill date; Net 15 means 15 days; Due on receipt is 0. Rent and utilities often have a fixed due date. In that case, enter the number of days from the bill date to that date.
2. Add early-payment discounts
Some suppliers offer a discount for paying early. Terms of 2/10 net 30 mean you can take 2% off if you pay within 10 days; otherwise the full amount is due in 30 days. Enter 30 as the terms, 2% as the discount and 10 as the discount days. While the discount is still available, the tracker shows the dollar amount and moves the Pay by date to the discount deadline.
3. Record payments
When you pay a bill, type the amount in Amount paid. A partial payment leaves the rest open; a full payment marks the bill as paid and removes it from the schedule. Keep paid bills on the sheet: a year of history per vendor is useful at tax time and when you negotiate terms.
4. Plan the week’s payments
Pick one day a week to open the report. Pay everything in Overdue first, then the bills in This week, then decide whether to take any discounts that expire soon. If you entered your available cash on the Start Here sheet, the last headline number shows what’s left after paying everything overdue and due soon. A negative number means it’s time to call a vendor before the due date, not after.
Example: a small business with eleven bills
Here’s what the vendor summary looks like for a small business as of October 31, using the example data in the template. One bill (Northgate Software) is already paid, and Bayline Freight has a $400 partial payment.
| Vendor | Overdue | Due in 7 days | Upcoming | Total |
|---|---|---|---|---|
| Coastal Paper Supply | $1,850 | – | $960 | $2,810 |
| Metro Electric | $640 | – | – | $640 |
| Pinecrest Insurance | – | – | $2,400 | $2,400 |
| Delta Office Leasing | – | $3,200 | – | $3,200 |
| Bayline Freight | – | – | $875 | $875 |
| Summit Wholesale Foods | – | – | $6,700 | $6,700 |
| Ridgeway Cleaning | $520 | – | – | $520 |
| Lakeside Equipment Rental | – | – | $1,600 | $1,600 |
| Total | $3,010 | $3,200 | $12,535 | $18,745 |
The report flags three things. First, $3,010 is already overdue, including a $520 cleaning bill that’s on hold because of a dispute; that one needs a phone call, not a payment. Second, the $3,200 rent is due tomorrow. Third, Summit Wholesale Foods offers 2/10 net 30 on two bills: paying the $4,500 bill by November 3 and the $2,200 bill by November 8 saves $134. That’s why the payment schedule shows $7,700 for this week, not the $3,200 of bills strictly due in the next seven days.
How the calculations work
Due date = Bill date + Terms (days)
Balance = Amount - Amount paid
Days until due = Due date - Today (negative = overdue)
Disc deadline = Bill date + Disc days
Discount = Balance x Disc % (only while Today <= Disc deadline)
Pay by = Disc deadline if a discount is available, otherwise Due date
The status comes from days until due: below zero is Overdue; zero up to your “due soon” window is Due soon; anything later is Upcoming. The payment schedule groups open balances by how many days remain until the pay-by date (overdue, 0–6 days, 7–13, 14–20, 21–27, 28 or more) using SUMIFS. The next bills to pay list uses SMALL and INDEX/MATCH to sort bills by pay-by date without macros, so it works the same in Excel and Google Sheets.
Is the early-payment discount worth it?
Usually, yes, if you have the cash. With 2/10 net 30, you’re paying 20 days early to save 2%. Expressed as an annual rate, that’s about 37%:
2% / 98% x 365 / 20 days = 37.2% per year
Few small businesses earn anywhere near that on cash sitting in a bank account, and it’s well above the cost of most credit lines. The exception is when paying early would leave you short for payroll or rent. That’s where the payment schedule and the cash figure help you decide.
Common mistakes
- Using the date you received the bill instead of the bill date. Terms run from the invoice date. A bill that sat in an inbox for a week is a week closer to due than you think.
- Paying from statements instead of invoices. Vendor statements can include bills you already paid or that are in dispute. Match each payment to a bill number.
- Paying twice. It happens more than people think, especially when a bill arrives by email and again by mail. Always check the bill number against the list before you pay.
- Ignoring disputes. If you’re holding a bill because something was wrong, write it in Notes and tell the vendor right away. A silent late payment looks the same as one you can’t afford.
- Forgetting recurring bills. Rent, insurance and software subscriptions are easy to miss because nobody sends a paper bill. Add them to the list each month when they’re issued.
Vendors and 1099s
Your A/P list doubles as the starting point for year-end 1099 reporting. For payments made in 2026 and later, the threshold for reporting nonemployee compensation on Form 1099-NEC (and most payment types on Form 1099-MISC) rose from $600 to $2,000 per recipient for the year. Payments to corporations are generally exempt, but payments to attorneys still have a $600 rule. Ask every new contractor for a Form W-9 before the first payment; chasing W-9s in January is much harder. Check the current IRS instructions for Forms 1099-MISC and 1099-NEC, or ask your tax preparer, for the rules that apply to you.
Sample accounts payable report
Here’s what a simple accounts payable report looks like for a small business on November 30, 2026. Each open bill gets one row, and the “days overdue” column puts it into an aging bucket. This is the same layout the tracker above and the Excel template produce.
| Vendor | Invoice # | Invoice date | Due date | Amount | Days overdue | Bucket |
|---|---|---|---|---|---|---|
| Bright Web Hosting | BW-2290 | Nov 15, 2026 | Dec 15, 2026 | $49.00 | 0 | Current |
| Lakeside Insurance | LI-5530 | Nov 20, 2026 | Dec 20, 2026 | $1,125.00 | 0 | Current |
| City Utilities | 88213 | Nov 5, 2026 | Nov 25, 2026 | $318.40 | 5 | 1–30 days |
| Northside Supply | INV-4471 | Oct 1, 2026 | Oct 31, 2026 | $1,240.00 | 30 | 1–30 days |
| Metro Freight | MF-1187 | Sep 10, 2026 | Oct 10, 2026 | $860.00 | 51 | 31–60 days |
| Prime Packaging | PP-0921 | Aug 25, 2026 | Sep 24, 2026 | $2,310.00 | 67 | 61–90 days |
Summary by bucket: Current $1,174.00 · 1–30 days $1,558.40 · 31–60 days $860.00 · 61–90 days $2,310.00 · Total owed $5,902.40.
How to read it: the two current bills can wait until their due dates. Prime Packaging is more than two months late, so call them first and agree a payment date before they put your account on hold. Metro Freight and Northside Supply come next. A report like this, printed every Friday, is usually all a small business needs to stay on top of its bills.
What an accounts payable spreadsheet should include
- Vendor and invoice number, so you never pay the same bill twice.
- Invoice date, terms and due date (for example Net 30), with the due date calculated, not typed.
- Amount, amount paid and balance, so partial payments are tracked.
- Days overdue and aging bucket (current, 1–30, 31–60, 61–90, 90+).
- Payment date and method once it’s paid, which makes bank reconciliation much faster.
Need to count due dates in working days instead of calendar days? Use our business days calculator.
Bookkeeping Kit Pro 2026 links your P&L, invoices, bills, bank rec, mileage and quarterly tax in one Excel workbook (works in Google Sheets). The free templates on this site stay free.
Related calculators and templates
- Free Accounts Receivable Aging Report Template
- Free 13-Week Cash Flow Forecast Template
- Monthly Bank Reconciliation Template + How to Reconcile in 5 Steps
- Free Small Business Bookkeeping Spreadsheet
FAQ
What is an accounts payable aging report?
It’s a list of unpaid bills grouped by how late they are: current, 1–30, 31–60, 61–90 and over 90 days past due. It shows which vendors to pay first. See the sample report above.
What should an accounts payable report include?
At minimum: vendor, invoice number, invoice date, due date, amount, balance still owed and days overdue. Adding the aging bucket and a total per vendor makes it easy to plan the week’s payments.
What’s the difference between accounts payable and accounts receivable?
Accounts payable is what you owe suppliers. Accounts receivable is what customers owe you. Both are tracked the same way, with a list of open invoices and due dates, and our A/R aging template uses the same layout as this one.
How often should I review accounts payable?
Weekly works for most small businesses: pick one day to review the list and schedule payments. Businesses with many suppliers often run two payment days a week.
Should I pay bills as soon as they arrive?
Not necessarily. Paying on the due date (or the discount deadline) keeps cash in your account longer at no cost. The goal is to pay on time, not early, unless there’s a discount.
Can I use this tracker in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All formulas use functions that work in both (SUMIFS, COUNTIFS, INDEX/MATCH, SMALL); no macros.
Is my data stored on your site?
No, not unless you choose to save it. The online tracker runs in your browser and keeps your bills on your device. If you’re signed in and click Save to my account, a copy is stored in your private account so you can open it from another device.
Related templates
- Accounts receivable aging report template
- 13-week cash flow forecast template
- Small business bookkeeping spreadsheet
This template and article are for general record-keeping and information. They aren’t legal, tax or accounting advice. Check payment terms with your vendors and current filing rules with the IRS or your tax professional.
Comments
5 responses to “Accounts Payable Tracker Template: Never Miss a Vendor Due Date”
[…] Accounts Payable Tracker Template […]
[…] Accounts Payable Tracker Template […]
[…] Accounts Payable Tracker Template […]
[…] Enter opening balances from your balance sheet on the start date: bank, credit cards, loans, equity, and open customer invoices and vendor bills (your A/R aging and A/P list). […]
[…] Accounts Payable Tracker Template […]