● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Bookkeeping & Business Finance›Accounts Payable Tracker
Accounts Payable Tracker hero preview showing the vendor bills workbook
BOOKKEEPING & BUSINESS FINANCE

Accounts Payable Tracker

Vendor bills have a habit of surfacing at the worst moment, usually the day after the money went elsewhere. This accounts payable tracker keeps every bill in one log, works out due dates from vendor terms and checks a pay run against your cash first.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Pay the right bills, in the right week

The tracker starts with your vendors. Each one is listed once with payment terms in net days, plus a contact and payment method, and that single entry drives everything else. When a bill arrives, you log it once and its due date is worked out from the vendor terms, so a 30 day vendor invoiced on 6 October falls due on 5 November. Change a vendor terms once and every open invoice from that vendor updates with it.

As money moves, the picture stays current without extra effort. Payments are logged against their invoice numbers, and part payments simply reduce the balance while the status turns to Partial. Every bill carries a live status, paid, partial, overdue, due soon or open, and the aging tab splits what you owe into buckets from not due through to over 90 days past due, listing each open invoice with its days overdue so nothing old hides quietly.

Before you pay, the Pay Run Planner asks the question that matters. It gathers the bills due this week, the overdue ones and those due in the next seven days, then compares the total with the cash on hand you entered. If the cash covers it, it says so and shows what stays in the bank, if not, it shows the shortfall so overdue bills get paid first. Bills under dispute can sit on hold, out of the pay run, until you clear them.

Inside the workbook: 9 tabs

What you receive

  • Google Sheets Access PDF with a one-click link to your own Google Sheets copy
  • BLANK Excel workbook, clean and ready for your own vendor bills
  • EXAMPLE Excel workbook following a small studio with 8 vendors and 12 invoices
  • Quick Start Guide PDF to set the tracker up in about five minutes
  • Separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel and in Google Sheets
  • No macros, no add-ins and no extra software needed
  • You only type in the highlighted cells and bill rows
  • Covers money going out only, not customer money coming in
  • A planning tool, not accounting advice

Questions about this template

The things buyers ask us most.

How does the due date work?

Each vendor has payment terms in net days on the Vendor Master tab. When you log an invoice, the tracker adds those days to the invoice date to set the due date for you. A vendor on 30 day terms invoiced on 6 October is due on 5 November. Change the terms once on the vendor record and every open invoice from that vendor gets its new due date automatically.

What if I only pay part of a bill?

That is fully supported. Record the part payment on the Payments Log against the invoice number, and the balance on the Invoice Log drops by exactly what you paid, while the status changes to Partial so everyone can see the bill is not finished yet. When you pay the rest later, log it the same way and the balance closes to zero and the status becomes Paid.

What does the cash check actually compare?

The Pay Run Planner adds together your overdue bills and the bills due in the next seven days, then compares that total with the cash on hand figure you enter on Start Here. If your cash covers it, the planner says yes and shows what remains in the bank afterwards. If it falls short, it shows the shortfall amount, so you can pay the overdue bills first.

What happens to a bill I dispute?

Put it on hold on the Approval and Holds tab, with the reason for the dispute and a release date if you have one. Held invoices are kept out of the pay run while the hold is active, so a disputed bill does not get paid by accident. When the issue is resolved, change its status back to Approved and it returns to the normal payment flow.

More in Bookkeeping & Business Finance

All templates in this category →

Three more workbooks from the same shelf.

Sales Commission Tracker by Rep

Commission worked out per sale, with rep totals, payouts due and monthly goals.

$7.50 $3.00
View on Etsy
Receipt and Mileage Expense Tracker Excel Spreadsheet

Receipts and business mileage in one workbook, with one combined total for tax time.

$7.50 $3.00
View on Etsy
Small Business Bookkeeping Spreadsheet

Log income and expenses in minutes and see your real net profit on one clear dashboard.

$6.99 $2.80
View on Etsy
View on Etsy · $3.00