Accounts Payable Due Date Tracker Excel - Free Template

1. Open the Instructions tab and review the entry rules, date format, payment-term examples and vendor-category reference list.
2. On AP Tracker, enter one invoice per row beginning in row 4. Complete Invoice ID, Vendor Name, Vendor Category, location, Invoice Date, Payment Terms (Days) and Invoice Amount.
3. Use the available lists for Vendor Category, state, payment terms and Payment Method. Enter dates as MM/DD/YYYY and amounts as positive numbers.
4. Update Amount Paid whenever a payment is issued. Add Payment Date, Payment Method and Notes so the remaining balance reflects the latest transaction.
5. Leave calculated columns Due Date, Balance Due, Payment Status, Days Until Due, Due-Date Bucket and Priority unchanged; their formulas fill the prepared rows through row 103.
6. Before each payment run, filter the AP Tracker and review overdue or high-priority items. Then open AP Dashboard to compare totals by category, aging bucket, vendor and status.
7. Reconcile the spreadsheet to invoices, payment confirmations and the business bank account before treating the dashboard balance as final.

A small-business bookkeeper, office manager or controller can use this workbook during the weekly payment run to see which invoices need action. It is suited to a contractor with four employees, a professional-services LLC, a nonprofit treasurer or a growing office that has outgrown a folder of unpaid bills.

The AP Tracker has prepared operational rows 4 through 103, so it can hold 100 invoice records. That is capacity for a business receiving roughly 25 bills per week for one month, not a claim that every organization should keep its entire payables history in one file.

During Weekly Payment Runs

Suppose a plumbing company enters a $4,850 utility invoice dated 08/10/2026 with 15-day terms. The calculated Due Date is 08/25/2026, and the open balance remains $4,850 until Amount Paid is entered. A payment manager can sort or filter the tracker for Overdue, Due Within 7 Days or High priority before releasing cash.

At Month-End Close

At month-end, a bookkeeper can compare the workbook with the accounts payable ledger and bank activity. The dashboard separates total invoice amount, total paid, total balance due and overdue balance, then summarizes invoice amount, balance and count for five vendor categories.

For Vendor and Cash Planning

Software renewals, utility bills and facilities invoices often follow different terms. The Instructions tab lists reference terms of 30 days for Office Supplies and Software, 15 for Utilities, 30 for Professional Services and 45 for Facilities. Use the actual invoice or contract terms in the tracker; the reference list is not a substitute for those documents.

Accounts payable is not governed by one national payment deadline. Your obligation normally comes from the vendor invoice, purchase order or contract, while sales tax is state-level and payment terms such as Net 15 or Net 30 are commercial agreements. This workbook therefore calculates due dates from the terms you enter instead of assuming one universal rule.

For example, an invoice dated 02/14/2026 with 30-day terms produces a due date of 03/16/2026. If the invoice amount is $18,750 and Amount Paid is $4,500, Balance Due calculates to $14,250. The tracker records this operational balance; it does not determine whether the invoice is valid, deductible or subject to sales tax.

W-9 and 1099-NEC Review

Before paying an independent contractor, collect a W-9 and retain the vendor's legal name and taxpayer identification information. A business generally issues 1099-NEC for qualifying nonemployee compensation of $600 or more during the year, subject to the applicable reporting rules. Vendor category and Notes can help you flag the relationship, but the workbook does not prepare tax forms.

Recordkeeping and Reconciliation

Keep the invoice, approval, payment confirmation and related correspondence with the spreadsheet. The IRS generally expects tax records for three years, and some records may need to be kept up to seven years. Reconcile the AP Tracker to the general ledger and bank account; a paid status alone is not proof that the payment cleared.

Terms Are Not Cash-Flow Forecasts

A due date tells you when payment is expected, not whether cash is available. If five invoices totaling $42,000 fall into the 0-7 Days bucket, compare that amount with the bank balance, payroll, taxes and other commitments before approving the run.

The costliest AP failures usually begin with incomplete invoice entry. If a bookkeeper enters $1,250 but omits Payment Terms (Days), the formula cannot calculate Due Date, Days Until Due or the related classifications. The dashboard may then understate the practical workload even though the invoice row exists.

Partial Payments Misread as Completed

A partial payment is not a paid invoice. For an $18,750 software invoice, entering $4,500 in Amount Paid leaves a $14,250 Balance Due. If someone marks the invoice complete in another system without updating this row, the dashboard still reports an open liability while the payment team may stop following up.

Dates and Terms Entered Inconsistently

Typing 30 into one row and 45 into another without checking the vendor agreement can move a $10,000 invoice's planned payment by 15 days. The workbook provides list validation for 7, 10, 15, 30, 45 and 60 days, but the allowed list does not prove that the selected term matches the contract.

Duplicate Invoices and Weak Approvals

The file does not automatically detect duplicate Invoice IDs. Entering the same $6,200 invoice twice inflates Total Invoice Amount and Balance Due by $6,200, potentially causing a double payment. Search the vendor, invoice number and amount before adding a row, and require approval evidence in Notes or your separate document system.

Ignoring Aging Until the Bill Is Late

Waiting for a vendor reminder can create late fees, interrupted service or lost early-payment discounts. Review the High priority output and the 0-7 Days bucket every payment cycle; those fields are more useful when you act before the due date rather than merely documenting the miss.

Give one person ownership of the tracker and attach its update to an existing routine, such as Tuesday invoice intake and Friday payment approval. A business receiving 20 invoices each week should not wait until month-end to enter 80 rows; four short entry sessions produce a cleaner cash view and fewer forgotten bills.

Use a Fixed Review Sequence

• Enter new invoices and confirm Invoice ID, vendor, date, terms and amount.
• Update Amount Paid, Payment Date and Payment Method immediately after payment release.
• Review Overdue and Due Within 7 Days items before approving the next bank batch.
• Compare dashboard totals with the AP subledger and bank activity at close.

Protect the Calculated Columns

Do not overwrite columns H and K through O. The formulas calculate Due Date, Balance Due, Payment Status, Days Until Due, Due-Date Bucket and Priority across the prepared rows. If you need a new category, update the reference list carefully and test one row before changing the production file.

Make the Dashboard a Decision Tool

Use the category table to spot concentration. If Software shows $30,000 outstanding while Utilities shows $4,000, review renewal dates and approval status rather than paying strictly in entry order. The dashboard's three charts can support a brief weekly review, but the underlying invoice documents remain the authority.

Know When to Move On

This workbook is practical for 100 prepared records. When you need approval routing, purchase orders, duplicate detection, multi-entity controls, recurring bills or a complete audit trail, move the process to an accounting system such as QuickBooks or an AP platform and retain this file as a controlled reference.