Receivables Intelligence Firm: AR & IFRS 9 for Advisers   Excel template (XLSX)
$599.00

Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Log in to unlock full preview.
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Receivables Intelligence Firm: AR & IFRS 9 for Advisers (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen. Unlock all 15 preview images:   Login Register

Receivables Intelligence Firm: AR & IFRS 9 for Advisers – Excel XLSX

Excel (XLSX) + Zip archive file (ZIP)

$599.00
Built by a CFO for finance teams: tested on real SAP, Oracle, Sage, BOB, Exact and Business Central exports, with no macros and no data leaving your computer.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

  1. Licenses the full Pro workbook to your firm for any number of client companies, including the reports you prepare for them.
  2. Turns each client's AR export into a reconciled aging, an IFRS 9 ECL estimate, collection emails and an audit evidence pack.
  3. Keeps each client in its own file, with no macros, no add-ins and no data leaving your computer.

ACCOUNTS RECEIVABLE EXCEL DESCRIPTION

Receivables Intelligence Firm: AR & IFRS 9 for Advisers is an Excel template (XLSX) with a supplemental Zip archive file document available for immediate download upon purchase.

Receivables Intelligence Firm 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.

FIRM: THE PRO EDITION, LICENSED FOR YOUR CLIENTS

For accounting firms, fiduciaries, auditors and finance consultants who review receivables for their clients. You get the full Pro workbook, licensed for use by your firm's staff on the data of any number of client companies, including the reports you prepare for them. Use one copy per client: save the workbook under the client's name and paste that client's export, so each client's settings and choices stay in its own file. The licence covers your firm's use; the workbook itself may not be passed on to your clients.

WHAT PRO ADDS: THE FOLLOW-UP WORK AND THE AUDIT TRAIL

Collection emails, ready to send: one email per customer overdue by more than 15 days (adjustable), in the customer's language (English, French, Dutch or German), with the overdue invoices, total, payment deadline and your bank details. The tone follows the situation: friendly reminder, second reminder, final reminder, payment-arrangement confirmation or dispute clarification.

Balance confirmation emails: one per customer with an open balance, overdue or not.

Follow-up log: every action and payment commitment, with evidence references. Each commitment is tracked automatically as pending, kept or broken.

Confirmation log: confirmations sent, replies, differences and missing replies.

Documented provision overrides: where evidence justifies it (e.g. a signed payment plan or cash received after period-end), apply a lower provision for a customer, with reason, evidence and approver recorded.

Audit evidence pack: one printable page per period with the provision summary, overrides, actions, commitments and confirmations.

Provision movement versus last month: the roll-forward auditors ask for (opening, increases, decreases, new customers, customers no longer open, closing, zero check), the 10 largest changes explained in plain words, and the IFRS 7 movement table for the notes.

Emails are prepared, never sent: you copy them into your own mailbox. Templates are editable. Company-run confirmations support, but do not replace, external confirmations controlled by your auditor.

EVERYTHING IN THE STANDARD EDITION

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 Pro 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 Firm edition is licensed to one accounting, audit or advisory firm for any number of client companies. 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 Firm: AR & IFRS 9 for Advisers Excel (XLSX) Spreadsheet, SSA International


$599.00
Built by a CFO for finance teams: tested on real SAP, Oracle, Sage, BOB, Exact and Business Central exports, with no macros and no data leaving your computer.
Add to Cart
  

ABOUT THE AUTHOR

Additional documents from author: 2
Terms of usage (for all documents from this author)

SSA International is a Belgian company that builds practical Excel tools for finance teams, designed by a CFO for the work finance departments do every month.

Our first product, Receivables Intelligence, turns the accounts receivable export from any accounting system (SAP, Oracle, Business Central, Sage, BOB, Exact, Odoo, DATEV, QuickBooks, Xero and more) into a complete month-end ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided business templates to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab





Read Customer Testimonials

 
"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me "

– Bill Branson, Founder at Strategic Business Architects
 
"I like your product. I'm frequently designing PowerPoint presentations for my company and your product has given me so many great ideas on the use of charts, layouts, tools, and frameworks. I really think the templates are a valuable asset to the job."

– Roberto Fuentes Martinez, Senior Executive Director at Technology Transformation Advisory
 
"Flevy.com has proven to be an invaluable resource library to our Independent Management Consultancy, supporting and enabling us to better serve our enterprise clients.

The value derived from our [FlevyPro] subscription in terms of the business it has helped to gain far exceeds the investment made, making a subscription a no-brainer for any growing consultancy – or in-house strategy team."

– Dean Carlton, Chief Transformation Officer, Global Village Transformations Pty Ltd.
 
"I have used Flevy services for a number of years and have never, ever been disappointed. As a matter of fact, David and his team continue, time after time, to impress me with their willingness to assist and in the real sense of the word. I have concluded in fact "

– Roberto Pelliccia, Senior Executive in International Hospitality
 
"Last Sunday morning, I was diligently working on an important presentation for a client and found myself in need of additional content and suitable templates for various types of graphics. Flevy.com proved to be a treasure trove for both content and design at a reasonable price, considering the time I "

– M. E., Chief Commercial Officer, International Logistics Service Provider
 
"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500
 
"The wide selection of frameworks is very useful to me as an independent consultant. In fact, it rivals what I had at my disposal at Big 4 Consulting firms in terms of efficacy and organization."

– Julia T., Consulting Firm Owner (Former Manager at Deloitte and Capgemini)
 
"I am extremely grateful for the proactiveness and eagerness to help and I would gladly recommend the Flevy team if you are looking for data and toolkits to help you work through business solutions."

– Trevor Booth, Partner, Fast Forward Consulting



Customers Also Like These Documents

Explore Templates on Related Management Topics



Your Recently Viewed Documents
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.