Accounts payable tracker
An accounts payable tracker lists the bills your business owes, when each is due and what has been paid. This free template keeps the balance on each bill and the total you owe, so you can plan payments, avoid late fees, and see your real cash position before you spend.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Vendor | Bill no. | Bill date | Due date | Category | Amount | Paid | Balance | Paid on | Method |
|---|---|---|---|---|---|---|---|---|---|
| Sysco | INV-55812 | 2026-04-01 | 2026-04-15 | Food cost | $2,840.20 | $2,840.20 | $0.00 | 2026-04-14 | ACH |
| City Utilities | 4410-22 | 2026-04-03 | 2026-04-24 | Utilities | $612.75 | $0.00 | $612.75 | ||
| Rivera Plumbing | 1188 | 2026-04-05 | 2026-05-05 | Repairs | $950.00 | $400.00 | $550.00 | 2026-04-20 | Check |
| Square | Apr-26 | 2026-04-30 | 2026-04-30 | Software | $69.00 | $69.00 | $0.00 | 2026-04-30 | Card |
| Total | $4,471.95 | $3,309.20 | $1,162.75 |
Why track bills you haven't paid yet?
Because the bank balance lies. If you owe $8,000 in bills due next week, a $12,000 balance is really $4,000. Entering bills when they arrive shows your real position, spreads payments sensibly and stops late fees. It also catches duplicate bills before you pay twice.
How does this help at tax time?
Every vendor sits in one list, with categories. Contractors you paid $2,000 or more during 2026 need a Form 1099-NEC by February 1, 2027, so add a 1099 contractor tracker alongside. On the cash basis, a bill counts as an expense when you pay it, so the Paid on column matters.
When should I move to software?
Once you have more than a couple of dozen bills a month, or more than one person approves them. QuickBooks Online and Xero track bills, due dates and payments, and connect to your bank.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceWhat is the difference between accounts payable and accounts receivable?
Payable is what you owe vendors. Receivable is what customers owe you.
Should I pay bills early?
Only if there's a discount for paying early. Otherwise, pay on the due date and keep the cash longer.
How do I handle a partial payment?
Enter the amount paid so far. The balance column shows what's left, and you can add a second row when you pay the rest.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.