Free Accounts Payable Tracker Spreadsheet Template for Google Sheets & Excel
A line per bill with the vendor, their bill number, the amount and the date it falls due, and a Paid column to mark once it is settled. The Free Accounts Payable Tracker spreadsheet template reads a status off those two columns rather than asking you to type one - overdue, due soon or upcoming - and works it out again every time the file opens. Sixteen rows on one working sheet. Google Sheets or Excel. No macros, no VBA.
The FinancialAha Free Accounts Payable Tracker Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Accounts Payable Tracker Excel template and a Free Accounts Payable Tracker Google Sheets template from the same download. A line per bill, each with the vendor, the bill number, what is owed and when it is due - and a status that works itself out from the date rather than being typed. No macros, no VBA.
Inside the workbook
What's inside the FinancialAha Free Accounts Payable Tracker spreadsheet template
The FinancialAha Free Accounts Payable Tracker Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Accounts Payable Tracker spreadsheet holds.
01of 01
AP
One row per bill. Each carries who it is from, their reference number, the amount, the date it falls due and a Paid column to mark once it is settled. The status beside it is derived rather than typed: paid once the Paid column is marked, and otherwise overdue if the date has passed, due soon if it lands within a week, and upcoming after that.
Deriving that column is the difference between a list that stays true and one that quietly stops being. A typed status is right on the day it is written and wrong a fortnight later, and a payables list is exactly the kind of file that sits untouched for a fortnight. Here the column re-reads the row every time the file opens, so it cannot contradict the line it sits on.
The bill number is worth filling in properly. It is what a vendor will ask for when a payment is queried, and the difference between a two-minute call and an afternoon of matching amounts to invoices.
The strip at the top reports what is still owed rather than what the list adds up to, so a bill you mark paid drops out of the figure while its row stays where it is. A total for the whole list sits at the foot beside it.
AP
Included guide
How to Use
A step-by-step guide on its own tab, covering how to replace the sample values and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.
Works in both Google Sheets and Excel
Free Accounts Payable Tracker Spreadsheet template for Google Sheets
Upload the Free Accounts Payable Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Accounts Payable Tracker Google Sheets template needs no conversion step, and the derived status re-reads the dates in Sheets exactly as it does in Excel.
Free Accounts Payable Tracker Google Sheets template setup
A shared copy of the Free Accounts Payable Tracker Google Sheets template suits a business where more than one person pays bills, since the thing that goes wrong is two people assuming the other has.
Running the Free Accounts Payable Tracker Google Sheet
The Free Accounts Payable Tracker Google Sheet is worth opening on the same day each week. Because the status column reads the date on open, the list re-sorts itself into urgency without anyone maintaining it.
Free Accounts Payable Tracker Spreadsheet template for Excel
The Free Accounts Payable Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Free Accounts Payable Tracker Excel template directly, with no import step and no compatibility prompt, and the status column recalculates on open. There are no macros and no VBA in the file, so it opens without a security warning.
The same Free Accounts Payable Tracker Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Accounts Payable Tracker spreadsheet download to choose between.
The Free Accounts Payable Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt.
Opening the Free Accounts Payable Tracker spreadsheet Excel file
Nothing in the Free Accounts Payable Tracker Excel template is version-specific, so this Free Accounts Payable Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
The FinancialAha Free Accounts Payable Tracker Spreadsheet Template is a list of what you owe with the urgency worked out for you: mark a bill paid and both the status and the still-owed figure follow. The Essentials Accounts Payable Tracker Spreadsheet Template for Google Sheets and Excel trades that derived status for one you set yourself - paid, unpaid, partial, overdue or disputed - and adds the date the bill arrived beside the date it falls due, a countdown of days until due on anything unpaid, the amount still unpaid per bill, and a dashboard separating what has been paid from what is outstanding and what is past due, with the average time you actually take to pay.
Notes on working in the Free Accounts Payable Tracker spreadsheet template
The status is worked out from the Paid column and the due date, so it re-reads every time the file opens and cannot contradict the row it sits on.
Due soon covers the seven days ahead of today; anything past its date reads overdue.
The figure at the top is what is still owed and leaves out every row marked paid. The total at the foot counts them all.
Marking a bill paid moves both the status and the still-owed figure without taking the row off the list.
The dropdown beside the title relabels the amount column. It changes the label and nothing else.
How the Accounts Payable Tracker template works
The Free Accounts Payable Tracker Spreadsheet Template holds a line per bill - who each is from, their reference number, what is owed and when it falls due - with a status that works itself out rather than being typed. Paid once you mark the Paid column; otherwise overdue if the date has passed, due soon if it lands within a week, and upcoming after that. Deriving it is the difference between a list that stays true and one that quietly stops being: a typed status is right on the day it is written and wrong a fortnight later, which is roughly how long a payables list tends to sit untouched. The figure at the top is what is still owed, so a bill marked paid drops out of it while its row stays on the list.
When this template helps
01
You want one list of what the business owes and when.
02
Bills arrive from several places and nothing keeps them together.
03
You want to see what is overdue without working it out each time.
04
You are between a shoebox and accounting software.
Tips to get the most out of it
The bill number is what a vendor asks for when a payment is queried, which is what makes it worth filling in properly.
Because the status is derived rather than typed, the list stays true while it sits untouched - which is mostly what a payables list does.
Sorting by due date groups what has slipped and what is close, and the status column follows its own row.
Recording when a bill arrived, and how long it took to pay, is the Essentials build.
Common mistakes to avoid
Forgetting to mark a bill paid, which leaves it inside the still-owed figure.
Typing over the status column. It is derived from the Paid column and the due date, and will be rewritten.
Skipping the bill number, which is the one field a vendor will ask for.
Entering the date you received a bill in the due date column - only the due date drives the status.
How to Use the Free Accounts Payable Tracker Spreadsheet Template
1
Add the vendor
Who the bill is from, one row each.
2
Record the bill number
Their reference, for when a payment is queried.
3
Enter the due date
The status follows from it automatically.
4
Mark it paid
Type Yes in the Paid column once it is settled. The status reads Paid and the bill drops out of the still-owed figure while its row stays on the list.
Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.
Excel
Sheets
Privacy by default
Your numbers stay in your own file
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away
Frequently Asked Questions
What is the difference between the free and Essentials Free Accounts Payable Tracker spreadsheet template?
Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build, with more worked out for you rather than typed. This template has no Ultimate build. What each tier holds differs by template - the comparison table on every template page lists it exactly.
Which Free Accounts Payable Tracker spreadsheet template should I download?
Essentials is the fuller build of this template for ongoing use, and the comparison table on this page lists exactly what it adds. The Free version is a good fit for one-off planning or trying out the layout.
Can I upgrade the Free Accounts Payable Tracker spreadsheet template later?
Yes. Essentials is a one-time $19 purchase with no subscription. What it adds depends on the template: some builds gain capacity and a dashboard, others richer detail in the same layout. The comparison table on this page lists the differences exactly.
Is the FinancialAha Free Accounts Payable Tracker Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". The derived status re-reads the dates in the Free Accounts Payable Tracker Google Sheets template exactly as it does in Excel.
Is the FinancialAha Free Accounts Payable Tracker Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Accounts Payable Tracker Excel template opens directly in Excel with no import step. There are no macros and no VBA.
Will the FinancialAha Free Accounts Payable Tracker spreadsheet Excel file open in older versions of Excel?
Yes. The Free Accounts Payable Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
How does the status work?
It reads the due date rather than being typed - overdue if the date has passed, due soon if it lands within seven days, upcoming otherwise. A typed status is right on the day it is written and wrong a fortnight later, which is exactly how long a payables list tends to sit.
Can I mark a bill as paid?
Yes. Type Yes in the Paid column and the status reads Paid - the still-owed figure drops the bill while its row stays on the list. The Essentials build replaces the Yes/No marker with a status you set yourself (paid, unpaid, partial, overdue or disputed), plus a countdown of days until due and a record of how long bills take to pay.
Why does the bill number matter?
Because it is what a vendor asks for when a payment is queried. It is the difference between a two-minute call and an afternoon matching amounts to invoices.
Is the file safe to download?
Yes. No macros, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.
How do I open the Free Accounts Payable Tracker spreadsheet template in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
Can I use the Free Accounts Payable Tracker spreadsheet template for commercial work?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
