Sheets
8
Review overdue pace first
Finance Excel template
Accounts Receivable Tracker Template
Consultation
If you want to line up invoice volume, due dates, overdue days, and collection rules with your existing workflow, we can help decide what stays in Excel and what moves to the web. We can also adjust the column layout to match your current receivables sheet.
If you need team collaboration, mobile data entry, attachment storage, collection follow-up reminders, or dashboards, view the systemized version.
A free Excel template for organizing customers, receivable documents, receipts, aging, disputes, and collection actions in one workbook. The system example link is available only in supported languages.
Free download
Invoices
Due dates
Collections
Workflow
Traceable
Best for invoice-level follow-up
Input
Shareable
Easy to share with sales
Input example
Lock in the collection forecast baseline
Align invoice number, due date, expected collection amount, and forecast status first, then track the monthly collection trend.
Invoice number
INV-2401
Due date
2026-04-18
Expected collection
320,000 JPY
Forecast status
Updated this week
Free download
See what is inside the Excel version first
A free Excel template that brings customer master data, receivables detail, receipt logs, disputes and collections, aging analysis, and a dashboard into one workbook.
File
Accounts Receivable Tracker Template.xlsx
File name: finance_accounts_receivable_tracker_template_en.xlsx
Sheets
8 sheets
Purpose
Customers, receivables, receipts, aging, disputes
Keeping invoice numbers, due dates, and customers aligned helps reduce missed follow-ups.
Overdue items and collection notes stay in one workbook, so status checks are easier.
The same flow can keep contact history for finance and sales handoff.
Start by organizing the invoice and collection assumptions. Aging analysis and dashboard totals are not calculated automatically; calculate them separately and update the records manually.
How Excel is used
How to run receivables collection in Excel
The overview screen surfaces receivables and overdue items first, while the settings screen keeps collection rules consistent.
Step 1
Register invoices
First define the invoice number and customer, then align the monthly review checkpoints.
Step 2
Update due dates
Maintain contractual due dates. Record expected payment dates in Notes so forecasts do not replace the agreed payment deadline.
Step 3
Check overdue items
Log overdue items and reminder status so the next action is always clear.
Step 4
Monthly review
Bundle the month-end results and expected collections into a format you can reuse next month.
Excel to screen mapping
Which Excel columns become the collections screen
Separating invoices, overdue items, and collection history makes follow-up easier.
Excel element
System element
Notes
Excel element
Invoice list
System element
Invoice table
Notes
Track invoice number, customer, amount, and due date.
Excel element
Overdue list
System element
Overdue board
Notes
Keep overdue items and follow-up timing visible.
Excel element
Collection history
System element
Activity timeline
Notes
Record contact dates, responses, and resolution status.
Excel element
Notes
System element
Notes board
Notes
Keep reminder timing and escalation notes together.