Excel workbook · €29
Open items aging
See overdue balances and separate revaluation from booked amounts.
Review build. Scoped native checks are listed under What you need. Full acceptance is incomplete. Purchases are disabled.
Will it fit your work?
- Your input
- Open AR or AP items, key date, bucket limits and valid exchange rates.
- Your result
- Aging buckets, partner ranking and an incomplete-result warning for invalid rows.
- What you need
- Microsoft 365 or Excel 2021 on Windows. Opened, fully recalculated and reconciled in native Excel on synthetic data; wider acceptance is incomplete. Power Query import is optional; follow START_HERE.md (helper sheet, paste values, check formula), not step 4 on the Queries sheet. That path passed natively in Excel on the FBL5N sample (19 Oct 2026).
- Check this first
- Rows 5–2000 are prepared. Invalid rows are excluded from totals and must be resolved before using the result. Credit-note handling must match your policy.
Start with one known example
- Extract the whole ZIP and read START_HERE.md.
- Start with
OpenItems_Aging.xlsxon a copy. - Use the example below; replace input paths and settings.
- Reconcile rows and totals before using real data.
Work on a copy. Settings → OpenItems → Partners → Aging. Resolve every CHECK before using totals.
Each package includes the source file or workbook, its PDF guide, a short setup path, verification status and a support checklist.
Free builds are for evaluation; validate the result in your own environment. Price shown for a paid tool is the proposed one-time price, before any applicable checkout taxes.
Data stays in your own files except for configured service calls. VIES receives VAT numbers; currency services receive requested dates and currency codes. No tracking or signup is used by this static preview.