Free Accounts Receivable Tracker Spreadsheet Template for Google Sheets & Excel
A line per invoice with the customer, the date you raised it, the date it is due and the amount - and a Paid column that takes it straight out of the outstanding figure. The Free Accounts Receivable Tracker spreadsheet template keeps everything invoiced and everything still owed as two separate numbers, and leaves the invoice number free text so your own numbering carries over. Sixteen rows, one working sheet. Google Sheets or Excel. No macros, no VBA.
The FinancialAha Free Accounts Receivable 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 Receivable Tracker Excel template and a Free Accounts Receivable Tracker Google Sheets template from the same download. This Free Accounts Receivable Tracker spreadsheet template lists invoices with the customer, both dates and the amount, and marking one paid drops it out of the outstanding figure. No macros, no VBA.
Inside the workbook
What's inside the FinancialAha Free Accounts Receivable Tracker spreadsheet template
The FinancialAha Free Accounts Receivable 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 Receivable Tracker spreadsheet holds.
01of 01
AR
One line per invoice, each with its number, the customer, the date it was raised, the date payment is expected, the amount, and a column to mark it paid.
Holding both dates rather than one is worth something on its own, because the gap between them is the credit you are actually extending, and it is easy to lose sight of when invoices are remembered only by their due date.
Two figures on the sheet are deliberately different: what is still outstanding, on the strip at the top beside a count of the rows filled in, and everything invoiced, at the foot of the table. Typing Yes in the Paid column takes the row out of the first and leaves it in the second, so the ledger stays complete while the number you chase stays honest.
What this build does not do is compare a due date against today. Nothing is flagged as late and nothing counts the days it has run over - reading which invoices have slipped is a matter of looking down the due-date column yourself. That is where the Essentials build picks up.
AR
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 Receivable Tracker Spreadsheet template for Google Sheets
Upload the Free Accounts Receivable Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Accounts Receivable Tracker Google Sheets template needs no conversion step and nothing gets rewritten on the way in - the total recalculates exactly as it does in Excel. The currency dropdown beside the title relabels the amount column.
Free Accounts Receivable Tracker Google Sheets template setup
A shared copy of the Free Accounts Receivable Tracker Google Sheets template suits a business where one person raises invoices and another chases them, and Sheets version history covers a row edited in error.
Sharing the Free Accounts Receivable Tracker Google Sheet
The Free Accounts Receivable Tracker Google Sheet is updated when an invoice goes out and, in this build, when one is paid - typing Yes in the Paid column is what keeps the outstanding figure meaning what it says.
Free Accounts Receivable Tracker Spreadsheet template for Excel
The Free Accounts Receivable Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Free Accounts Receivable Tracker Excel template directly, with no import step and no compatibility prompt, and the total updates as rows change. There are no macros and no VBA in the file, so it opens without a security warning.
The same Free Accounts Receivable 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 Receivable Tracker spreadsheet download to choose between.
The Free Accounts Receivable Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt - which matters when a receivables list goes to a bookkeeper or a lender.
Opening the Free Accounts Receivable Tracker spreadsheet Excel file
Nothing in the Free Accounts Receivable Tracker Excel template is version-specific, so this Free Accounts Receivable Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.
The FinancialAha Free Accounts Receivable Tracker Spreadsheet Template lists each invoice with both dates and the amount, and a Paid column keeps what is still outstanding apart from what has been invoiced. What it does not do is read a due date against today. The Essentials Accounts Receivable Tracker Spreadsheet Template for Google Sheets and Excel turns that Paid column into a status - including written off, not just paid or pending - works out how many days each overdue invoice has run and how much of the balance that represents, and reports the outstanding and overdue figures separately from the total, with a chart alongside.
Notes on working in the Free Accounts Receivable Tracker spreadsheet template
Everything invoiced and everything still outstanding are two separate figures - the outstanding one on the strip at the top, the total at the foot of the table - so typing Yes in the Paid column changes the first without disturbing the second.
Nothing compares a due date against today, so no invoice is flagged as late by the sheet. Days overdue and an overdue total start at the Essentials build.
Holding both the invoice date and the due date shows the credit you are actually extending, which the due date alone does not.
Paid rows stay in the ledger rather than needing deleting - the outstanding figure already excludes them.
The currency dropdown beside the title relabels the amount column of the Free Accounts Receivable Tracker spreadsheet. It changes the label only and does not convert the numbers.
How the Accounts Receivable Tracker template works
The Free Accounts Receivable Tracker Spreadsheet Template lists each invoice with its number, the customer, the date raised, the date due and the amount. Holding both dates is worth something on its own, because the gap between them is the credit you are actually extending. A Paid column sits at the end of each row, and the outstanding figure leaves out every row marked paid while the total at the foot still counts it - so the ledger stays complete and the number you chase stays honest. What the sheet does not do is compare a due date against today, so no invoice is flagged as late.
When this template helps
01
You want a written list of what has been invoiced and to whom.
02
You want the invoice date and the due date recorded together.
03
A bookkeeper or lender has asked what is outstanding.
04
You would rather own a file than pay for accounting software.
Tips to get the most out of it
Typing Yes in the Paid column drops the row out of the outstanding figure while the total at the foot still counts it.
Nothing compares a due date against today, so no invoice is flagged as late by the sheet.
Both dates together show the credit period you are actually extending.
Paid rows are meant to stay where they are - the outstanding figure already leaves them out.
Common mistakes to avoid
Reading the total at the foot as a receivable balance. It covers every invoice on the sheet; the outstanding figure is the one that drops the paid rows.
Forgetting to type Yes in the Paid column, which leaves the invoice inside the outstanding figure - the total tests for Yes exactly, so any other word keeps it there.
Relying on the due date to surface a late payment. Nothing here checks it against today.
Reusing an invoice number. It is painful to unpick when a customer queries which one they paid.
How to Use the Free Accounts Receivable Tracker Spreadsheet Template
1
Log the invoice
Its number and the customer it went to.
2
Record both dates
When it was raised and when payment is expected.
3
Enter the amount
The value of the invoice. The total updates above.
4
Clear paid rows
Typing Yes in the Paid column drops the row out of the outstanding figure.
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 Receivable 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 Receivable 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 Receivable 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 Receivable Tracker Spreadsheet Template a Google Sheets template?
Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Accounts Receivable Tracker Google Sheets template, and version history covers a row deleted in error.
Is the FinancialAha Free Accounts Receivable Tracker Spreadsheet Template an Excel template?
Yes. The download is a plain .xlsx, so the Free Accounts Receivable Tracker Excel template opens directly in Excel with no import step. There are no macros and no VBA, which matters when a receivables list goes to a bookkeeper or a lender.
Will the Free Accounts Receivable Tracker spreadsheet Excel file open in older versions of Excel?
Yes. The Free Accounts Receivable Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.
Does the FinancialAha Free Accounts Receivable Tracker Spreadsheet Template show what is still owed?
Yes. Type Yes in the Paid column and the row drops out of the Still Outstanding figure at the top, while staying in the total invoiced beside it. The two are deliberately separate, so the ledger stays complete and the figure you chase stays honest.
Does it flag overdue invoices?
No. The due date is recorded but nothing compares it against today, so no invoice is marked late. Days overdue and the amount overdue are worked out on the Essentials build.
Why record the invoice date as well as the due date?
Because the gap between them is the credit you are actually extending, and that is easy to lose sight of when invoices are remembered only by when they are due.
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 Receivable 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 Receivable 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.
