Loading this page.
Loading this page.
Upload an accounts receivable ledger export -- one row per open invoice line. F20 buckets the outstanding balance by age, per currency, rates each customer's risk, and reports how collection is progressing.
Free AR aging analyzer: bucket what customers owe by how overdue it is, per currency, from the file's own as-of date. Upload the file this page names, review the result in the browser, and download CSV or Excel when offered.
An AR ledger with more than one currency. These are synthetic fixtures, processed in memory and never stored.
Your file is processed in memory and never stored. Nothing is written to disk, and nothing is retained after the response.
Invoices are aged from the latest invoice date in the ledger itself, not from today, so the same file gives the same answer whenever you run it. Each bucket shows a gross figure beside the net one: a 120-day invoice netted against a fresh credit note would otherwise read as a healthy zero.
Ages every invoice against the latest invoice date present in the ledger itself — the file's own 'as of' moment — never today's date, so the same file always produces the same buckets. Each invoice's signed outstanding balance falls into exactly one of six buckets or an explicit unassessable-due-date group, so the buckets always re-sum to a total a controller can re-derive from the same file, and a parallel gross figure is reported beside each one because a 120-day invoice netted against a fresh credit note would otherwise read as a healthy zero. Every figure is per currency; a EUR balance and a USD balance are never summed.
Upload the AR ledger. Invoices are aged against the latest invoice date in the file, never today's date, so the same file always produces the same buckets. EUR and USD are never summed.
Open the page, drop the AR ledger export, and read the result in the browser. Download CSV or Excel when the tool offers those exports.
Yes. There is no charge and no account required. Every tool on F20 FinanceOps runs without signing in. A run made without an account is not recorded.
No. Uploaded files are processed in memory and dropped when the response is sent. Nothing is written to disk. They are never stored.
Have the AR ledger export. Ageing uses the latest invoice date in the file, never today's date, so you do not need to freeze a clock. EUR and USD stay separate.
Read the overdue buckets per currency. Match unapplied cash next if receipts are sitting, or reconcile the customer statement if confirmation is the next step.
AR ageing is a close schedule, not a forecast. The as-of date comes from the file so the same upload always produces the same buckets. Nothing here is a collections model.