Accounts Payable Log: Free Template for Tracking Bills and Vendor Payments

By Nicole Hullihen, former SaaS Chief Operating Officer and Microsoft MVP · Updated October 25, 2026

Bills arrive by email, mail, text and vendor portals. Some get paid twice, some get paid late and some get lost until a vendor calls asking where their money is. An accounts payable log puts every bill in one place so you know what you owe, when it's due and what's already paid.

This guide includes a free accounts payable log and explains how to record bills, approve and match them, schedule payments, take early-payment discounts, prevent duplicate payments and fraud and review AP at month-end.

Note: This is general information, not accounting or tax advice. Talk to your accountant about how bills should be recorded in your books.

What Is Accounts Payable?

Accounts payable (AP) is money your business owes to suppliers and vendors for goods or services received but not yet paid for. An AP log, sometimes called a bill tracker or AP ledger, is the running list of those bills and their status.

Free Accounts Payable Log Template

What to Record for Every Bill

The Accounts Payable Process

1. Receive the bill and send it to one AP inbox or folder.
2. Log it the same day.
3. Match it to the purchase order and receiving record, if any.
4. Get approval from the person who ordered or received the goods or services.
5. Schedule payment based on the due date and cash flow.
6. Pay and record the payment details.
7. File the bill with proof of payment.
8. Review open bills weekly.

Matching Bills to Orders and Receiving

Before paying, check that you're paying for what you ordered and actually received. This is often called a three-way match: purchase order, receiving record and vendor invoice. If quantities or prices don't match, hold the bill and contact the vendor. See three-way match and the receiving log.

Approval Rules

Set simple rules for who can approve bills. For example:

These amounts are examples; set limits that fit your business. Separate duties where you can, so the same person doesn't set up vendors, approve bills and send payments.

Payment Scheduling

Paying every bill the day it arrives can strain cash flow; paying late damages vendor relationships and may trigger late fees. Many businesses run payments once or twice a week, paying bills due before the next payment run.

Look ahead at upcoming bills alongside expected customer payments so you're not surprised. See the cash flow planner.

Early-Payment Discounts

Some vendors offer a discount for paying early, such as "2/10 Net 30": 2% off if paid within 10 days, otherwise the full amount is due in 30 days. Track discount deadlines in your log. If cash allows, early-payment discounts can be a meaningful savings over a year.

Preventing Duplicate Payments

• Search the log for the invoice number before entering a bill.
• Pay from original invoices, not statements or reminders.
• Mark bills as paid with the date and reference number.
• Watch for the same amount from the same vendor in a short period.
• Review vendor statements monthly against your log.

Preventing AP Fraud

Fake invoices and changed bank details are common scams targeting small businesses. Protect yourself:

• Verify any request to change vendor bank details by calling a known phone number, not one in the email.
• Be cautious with invoices from vendors you don't recognize.
• Require approval for new vendors.
• Match bills to orders and receiving before paying.
• Limit who can add vendors and send payments.

See the vendor list template for keeping verified vendor details.

Vendor W-9s and Form 1099-NEC

Before paying independent contractors and some vendors, collect a Form W-9. The IRS says Form W-9 is used to provide a correct taxpayer identification number. Form 1099-NEC is used to report nonemployee compensation. Keep W-9s on file and note in your AP log which vendors may need a 1099, so year-end reporting is easier. Ask your accountant which vendors and payments must be reported.

Keeping Records

The IRS says supporting documents should identify the payee, the amount paid, proof of payment and the date incurred, and include a description showing the amount was for a business expense. Invoices, canceled checks or other proof of payment, account statements and credit card receipts are examples. Keep each bill with its proof of payment, organized by vendor or month.

AP Aging Report

An AP aging report shows how much you owe and how old it is. Review it monthly. Old open bills may be disputes to resolve, bills that were already paid or bills that slipped through.

Month-End AP Review

1. Make sure every bill received this month is logged.
2. Compare vendor statements to your log.
3. Follow up on bills on hold.
4. Review the aging report.
5. Confirm payments cleared the bank.
6. Send the log to your bookkeeper.

Example: A Small Restaurant

A restaurant owner paid bills from a pile on her desk. One produce invoice was paid twice, and a linen company charged late fees on a bill that had been misplaced. She set up an AP inbox, logged every bill the day it arrived, matched food invoices to delivery tickets and paid bills every Tuesday. Duplicate payments stopped, late fees disappeared and she could see her upcoming bills at a glance.

Common Accounts Payable Mistakes

• Bills in several places with no central log.
• Paying without matching to orders or receiving.
• Duplicate payments.
• Missing discount deadlines.
• Changing bank details based on an email.
• No W-9s collected before year-end.

Accounts Payable Checklist

Sample Completed AP Log

This sample uses made-up vendors and amounts. Notice the discount taken on the ABC Supply bill and the reference numbers that make each payment easy to trace.

Setting Up an AP Inbox

Bills arrive from many places. Give vendors one email address for invoices, like bills@yourcompany.com, and ask employees to forward any bills they receive. Scan paper bills into the same folder. When every bill lands in one place, nothing sits forgotten in someone's truck or inbox.

Coding Bills for Your Books

Use the same categories as your accounting system. Ask your bookkeeper which categories to use so reports line up. Coding job materials to the right job keeps job costs accurate.

Handling Disputed Bills

1. Mark the bill as on hold in the log with the reason.
2. Contact the vendor with specifics: wrong quantity, wrong price, damaged goods.
3. Ask for a corrected invoice or credit memo.
4. Pay the undisputed portion if your agreement allows.
5. Log the resolution and pay the corrected amount.

For returned goods, see the return to vendor form.

Recurring Bills

Rent, software subscriptions, insurance and utilities arrive every month. List recurring bills separately with their usual amount and due date. Review them every few months for subscriptions you no longer use and price increases nobody noticed. Unused subscriptions are one of the easiest costs to cut.

Who Should Manage AP

In a very small business, the owner may handle AP. As you grow, an office manager or bookkeeper usually logs bills and prepares payments, while the owner approves and releases them. Splitting those duties adds a simple safeguard against errors and fraud.

Days Payable Outstanding

Days payable outstanding (DPO) estimates how long, on average, you take to pay vendors. A rough calculation is accounts payable ÷ cost of goods sold × number of days in the period. Paying too quickly can strain cash; paying too slowly can hurt vendor relationships and cost you discounts. Ask your accountant to help you track it if cash flow is tight.

Weekly AP Routine

A predictable routine keeps AP from piling up. It also lets vendors know when to expect payment, which cuts down on "where's my check?" calls.

Paying Vendors: Methods Compared

Whatever method you use, record the reference number in your log so you can prove payment if a vendor asks.

AP and Vendor Relationships

Paying on time builds goodwill. Vendors who know you pay reliably are more likely to offer better terms, prioritize your orders during shortages and work with you when you need flexibility. If you'll be late on a bill, call the vendor before the due date. A heads-up is much better received than silence. See vendor scorecards for rating vendors in return.

Year-End AP Checklist

• Log every bill dated in the year, even if paid next year.
• Reconcile vendor statements.
• Confirm W-9s are on file for contractors and vendors you may report.
• Review open bills and credits.
• Send the log and supporting documents to your accountant.

Spreadsheet Tips for an AP Log

• Use one row per bill and one column per field.
• Format dates and amounts consistently so you can sort and filter.
• Add a formula for days until due: due date minus today.
• Use conditional formatting to highlight bills due this week.
• Filter by status to see only open bills.
• Keep a separate tab for paid bills by month.

A spreadsheet AP log works well for many small businesses. As volume grows, connecting purchasing, receiving and bills in one system reduces manual matching. Start with whatever your team will keep up to date every day.

Start today by gathering every unpaid bill into one place and entering it in the log. Once the backlog is in, keep it current by logging each new bill the day it arrives. Within a month you'll know exactly what you owe, when it's due and how much cash you need to cover it.

A clean AP log also makes tax time easier. Your accountant gets a complete list of expenses with proof of payment, instead of a box of loose receipts and bank statements to piece together.

Manage Purchasing and Bills With Updoot

Updoot's purchasing keeps purchase orders, receiving and vendor details together, so bills match the order before they're paid.

Sources

• IRS: About Form W-9
• IRS: About Form 1099-NEC
• IRS: What Kind of Records Should I Keep

Frequently Asked Questions