Invoice Payment Tracker
Build a weekly accounts-receivable review: record invoice balances, see aging and overdue risk, assign the next action, and export the current ledger.
Open-balance aging
Aging uses the due date and today's date. Paid and written-off records are excluded; partial payments use the remaining balance.
Invoice review list
Past due is calculated separately from the recorded workflow status so an overdue disputed or partially paid invoice remains visible.
| Invoice / client | Due / age | Status | Owner / next action | Amount | Balance | Actions |
|---|
How to run the weekly receivables review
Start with the open balance, then inspect past-due records by due-date aging. For each account, confirm the invoice, approval evidence, amount received, last contact, owner, and a dated next action. A status without a next action does not resolve collection risk.
The aging buckets are operational groupings, not accounting or legal conclusions. This tool uses calendar days after the due date. Your accounting policy may use statement dates, month-end cutoffs, allowances, write-off approval, or jurisdiction-specific collection rules. Reconcile the CSV against the accounting system before making financial decisions.
Evidence to keep outside this tracker
Keep the issued invoice, delivery or acceptance record, payment confirmation, credit note, dispute correspondence, and any approved write-off in the system of record. The browser ledger is a review aid; it does not send reminders, verify bank receipts, modify invoices, or replace bookkeeping controls.
Invoice tracker questions
What does this tracker calculate?
It calculates the remaining balance, past-due amount, and five due-date aging buckets: current, 1–30, 31–60, 61–90, and 90+ days.
Does the tracker send payment reminders?
No. It records an owner and next action for manual review. Nothing is emailed or sent automatically.
Where are records saved?
The tool code saves them in local storage in this browser. Clearing site data or using another browser removes access, so export a CSV when the ledger matters.
Can I treat the export as an accounting ledger?
No. Reconcile it against invoices, credits, payment records, and the accounting system. Tax, bad-debt, and collection treatment require the applicable policy and qualified review.