CECL Reporting for Credit Unions - Analysis by Account

    What is a n Analysis by Account Report? Analysis by Account Reports are considered Current Expected Credit Losses (CECL) reports and are used by accountants and compliance managers to support them in their CECL reporting. Some of the main functionality in this type of report is that it can be run for any quarter (or month) and the rows list credit and loan products by account, including: Mortgage loans, consumer loans, commercial loans, credit cards, as well as a grand total. The columns show Loan balance, Annual reserves, Total reserves (amount) and Reserves (%). You find an example of this type of report below. Purpose of Analysis by Account Reports Credit Unions use Analysis by Account Reports to speed up and improve their CECL reporting. When used as part of good business practices in Accounting- and Compliance departments, a company can improve its CECL reporting processes and insights, and it can reduce the chances that there are mistakes in reported figures due to manual errors. Example of an Analysis by Account Report Here is an example of an Analysis by Account Report with products and totals listed down the rows and loan balances and reserves shown in the columns. [caption id="" align="alignnone" width="2560"] Example of CECL Report for Credit Unions - Analysis by Account Report Example of CECL Report for Credit Unions - Analysis by Account Report[/caption] You can find hundreds of additional examples here Who Uses This Type of Report ? The typical users of this type of report are: Accountants, compliance managers, CFOs. Other Reports Often Used in Conjunction with Analysis by Account Reports Progressive Accounting- and Compliance departments sometimes use several different Analysis by Account Reports, along with detailed loan reports, internal income statements, balance sheets, cash flow reports, trial balances, transaction detail reports and other management and control tools. Where Does the Data for Analysis Originate From? The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others. In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions. What Tools are Typically used for Reporting, Planning and Dashboards? Examples of business software used with the data and ERPs mentioned above are:
    • Native ERP report writers and query tools
    • Spreadsheets (for example Microsoft Excel)
    • Corporate Performance Management (CPM) tools (for example Solver)
    • Dashboards (for example Microsoft Power BI and Tableau)
    Corporate Performance Management (CPM) Cloud Solutions and More Examples