Receivables Intelligence turns the open-items export from your accounting system into a complete month-end receivables review in one Excel workbook. Paste the report as it comes, in one yellow cell, and the workbook builds the analysis finance teams usually assemble by hand.
WHAT THE WORKBOOK PRODUCES
Aging by customer quality: seven aging buckets split by risk rating. Credit notes, offsets and invoices dated after the as-of date are handled and flagged.
IFRS 9 expected-credit-loss estimate: a provision matrix under the simplified approach, with editable loss rates and the coverage ratio.
Customers ranked for review: every customer prioritised by exposure, risk, age, sector and country, colour-coded red, amber or green, with a suggested approach that reflects payment behaviour, sector and country.
Works with incomplete data: no ratings? The workbook suggests them from payment behaviour. Unapplied payments are allocated to the oldest invoices (FIFO), missing dates and duplicates are handled, and every assumption is listed for review.
Monthly cash forecast: expected inflows net of expected losses, timed by rating, payment habits, seasonality and promises to pay.
Dashboard: eight headline figures, the top priorities and six charts.
Reconciliation and exceptions: every euro in the subledger is accounted for, and every excluded or adjusted line is listed.
Loss-rate calibration from your own history: enter past open amounts and losses, and the workbook computes your loss rates, applies a forward-looking adjustment and records who prepared and approved them. Until you calibrate, every report warns that example rates are in use.
Disclosure tables for the annual accounts: IFRS 7-style tables by days past due and by risk rating, with draft policy wording filled in with your figures.
WHY FINANCE TEAMS USE IT
No integration and no reformatting: paste your export as it comes. Exports from SAP, Oracle, Business Central, Sage, BOB, Exact, AFAS, Winbooks, Odoo, DATEV, QuickBooks, Xero and Greek ERPs have been tested. Column names in English, French, Dutch, German and Greek are recognised, along with European and US number and date formats, subtotal lines, debit/credit columns, part-payments, and semicolon- or tab-separated text files.
No macros, no add-ins, no internet connection: your data never leaves your computer. Every formula and assumption is visible and editable. Works with up to 5,000 invoice lines.
WHAT YOU GET
The Excel workbook, plus a ZIP with the quick-start guide, the full user guide in English, French, Dutch and German, and the Licence and Terms (PDF). Requirements: Microsoft Excel 2019, 2021 or Microsoft 365, on Windows or Mac.
LICENCE
This Standard edition is licensed for one company's own receivables. Accounting firms and advisers working for clients need the Firm edition. Copying or redistributing the workbook, and removing or changing its licensing information, are prohibited.
IMPORTANT
This is a baseline analysis tool. It produces estimates and suggestions; it is not accounting, audit, legal or tax advice. The loss rates supplied are examples only: replace them with rates based on your own historical data before using any figure. No responsibility is accepted for the figures or for decisions taken with them.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Accounts Receivable, Financial Risk Excel: Receivables Intelligence: AR Aging, IFRS 9 ECL & Priorities Excel (XLSX) Spreadsheet, SSA International
|
Download our FREE Strategy & Transformation Framework Templates
Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more. |