Skip to Main Content

insightsarticles

Key considerations from GASB Statement No. 99 

06.09.22

Read this if you are interested in GASB updates. 

The Governmental Accounting Standards Board (GASB) issued GASB Statement No. 99, Omnibus 2022 on May 9, 2022. The statement enhances comparability in accounting and financial reporting and improves the consistency of authoritative literature by addressing (1) practice issues that have been identified in previous GASB Statements, and (2) adding guidance on accounting and financial reporting for financial guarantees.

We’ve reviewed the statement in its entirety, and broken down key components for you to know. Here are the highlights.  

Accounting and financial reporting for exchange or exchange-like financial guarantees

Financial guarantees is a guarantee of an obligation of a legally separate entity or individual, including a blended or discretely presented component unit, that requires the guarantor to indemnify a third-part obligation holder under specified conditions, in an exchange or exchange-like transactions. 

An entity that extends an exchange or exchange-like financial guarantee should recognize a liability and expense related to the guarantee when qualitative factors and historical data indicate that is it more than likely not a government will be required to make a payment related to the guarantee.

Statement 99 excludes guarantees related to special assessment debt, financial guarantee contracts within the scope of Statement 53, or guarantees related to conduit debt obligations. 

Certain derivative instruments that are neither hedging derivative instruments nor investment derivative instruments

Derivative instruments that are within the scope of Statement 53, but do not meet the definition of an investment derivative instrument or the definition of a hedging derivative instrument are considered other derivative instruments. These “other derivative instruments” should now be accounted for as follows:

  1. Changes in fair value should be reported on the “resource flows statement” separately from the investment revenue classification.
  2. Information should be disclosed in the notes to financial statements separately from hedging instruments and investment derivative instruments.
  3. Governments should disclose the fair values of derivative instruments that were reclassified from hedging derivative instruments to other derivative instruments. 

Leases

If your entity has leases please review the following as Statement 99 clarifies numerous issues from Statement 87, specifically:

  • Lease terms as it relates to options to terminate and option to purchase the underlying assets, in paragraph 12 of Statement 87 has been clarified;
  • Short-term leases in paragraph 12 of Statement 87 has been clarified as it relates to an option to terminate the lease;
  • Lessee and lessor recognition and measurement for leases other than short-term leases that transfer ownership has been clarified, and
  • Lease incentives in paragraph 61 of Statement 87 has been further defined.

Public Private and Public-Public Partnerships (PPPs)

If your entity has PPPs, Statement 99 clarifies the following: 

  • PPP terms
  • Receivable for installment payments (transferor recognition)
  • Receivable for the underlying PP Asset (transferor recognition)
  • Liability for installment payments (operator recognition)
  • Deferred outflow of resources (operator recognition)

Subscription-Based Information Technology Arrangements (SBITAs)

Subscription terms and definitions have been clarified, specifically as it relates with options to terminate, short-term SBITAs, and measurement of subscription liabilities.

If your entity has SBITAs, review the provisions of each SBITA to ensure compliance with Statement 99 paragraphs 23–25.

Replacement of LIBOR

Check with your banking institutions to confirm when they have phased out of LIBOR. Confirm with your banking institutions what specifically has replaced LIBOR and update Financial Statement disclosures as needed. 

SNAP

State governments should recognize distributions of benefits from Supplemental Nutrition Assistance Program (SNAP) as a nonexchange transaction. Review Financial Statement disclosure and determine if a disclosure is needed. 

Disclosure of Nonmonetary Transactions

If you engage in one or more nonmonetary transactions during the fiscal year, you will need to disclose those transactions in the notes to the financial statements the measurement of attribute(s) applied to the assets transferred, rather than basis of accounting for those assets.

Pledges of future revenues when resources are not received by the pledging government

When blending the financial statement of a debt-issuing component unit into the financial statements of a primary government pledging revenue for the component unit’s debt, the primary government should reclassify an amount due to the component as an interfund payable and an interfund transfer out simultaneously with the recognition of the revenues that are pledged.

Focus of the government-wide financial statement

Statement 99 reiterates that there should be a total overall government-wide column within the MD&A, Statement of Net Position, and Statement of Activities. This column should exclude all fiduciary activities, including custodial funds. 

Terminology updates

No action is needed. Terminology has been updated in previous pronouncements, for terminology as it relates to Statements 63 and 53. 


Effective dates

The requirements related to the extension of the use of LIBOR, accounting for SNAP distributions, disclosures of nonmonetary transactions, pledges of future revenues by pledging governments, clarification of certain provisions in Statement 34 and terminology updates related to GASB 53 and 63 are effective upon issuance.

The requirements related to leases, PPPs, and SBITAs, are effective for fiscal years beginning after June 15, 2022.

The requirements related to financial guarantees and the classification and reporting of derivative instruments within the scope of Statement 53 are effective for fiscal years beginning after June 15, 2023.

Earlier application is encouraged and permitted for all.

If you would like more information regarding Statement 99, please contact our Audits of Governmental Component Units team. We’re here to help.

Topics: GASB accounting

Related Services

Related Professionals

Principals

BerryDunn experts and consultants

What the C-Suite should know about CECL and change management

Read this if you are at a financial institution. 

Some institutions are managing CECL implementation as a significant enterprise project, while others have assigned it to just one or two people. While these approaches may yield technical compliance, leadership may find they fail to realize any strategic benefits. In this article, Dan Vogt, Principal in BerryDunn’s Management and IT Consulting Practice, and Susan Weber, Senior Manager and CECL expert in BerryDunn’s Financial Services Practice, outline key actions leaders can take now to ensure CECL adoption success.  

Call it empathy, or just the need to take a break from the tactical and check in on the human experience, but on a recent call, I paused the typical readiness questions to ask, “How’s the mood around CECL adoption – what’s it been like getting others in the organization involved?” The three-word reply was simple, but powerful: “Kicking and screaming.”  

Earlier this year, by a vote of 5-2, the FASB (Financial Accounting Standards Board) closed the door to any further delays to CECL adoption, citing an overarching need to unify the industry under one standard. FASB’s decision also mercifully ended the on-again off-again cycle that has characterized CECL preparation efforts since early 2020. One might think the decision would have resulted in relief. But with so much change in the world over the past few years, is it any wonder institutions are instead feeling change-saturated?  

Organizational change

CECL has been heralded as the most significant change to bank accounting ever, replacing 40+ years of accounting and regulatory oversight practices. But the new standard does much more than that. Implementing CECL has an effect on everything from executive and board strategic discussions to interdepartmental workflows, systems, and controls. The introduction of new methods, data elements, and financial assets has helped usher in new software, processes, and responsibilities that directly affect the work of many people in the organization. CECL isn’t just accounting—it’s organizational change. 

Change management

Change management best practices often focus on leading from optimism—typically leadership and an executive sponsor talk about opportunities and the business reasons for change. Some examples of what this might sound like as it relates to CECL might include, by converting to lifetime loss expectations, the institution will be better prepared to weather economic downturns; or, by evolving data and modeling precision, an institution’s understanding and measure of credit risk is enhanced, resulting in more strategic growth, pricing, and risk management. 

But leading from optimism is sometimes hard to do because it isn’t always motivating—especially when the change is mandated rather than chosen.  

Perhaps a more judiciously used tactic is to focus on the risk, or potential penalty, of not changing. In the case of CECL, examples might include, your external auditor not being able to sign-off on your financials (or significant delays in doing so), regulatory criticism, inefficient/ineffective processes, control issues, tired and frustrated staff. These examples expose the institution to all kinds of key risks: compliance, operational, strategic, and reputational, among them.

CECL success and change management

With so much riding on CECL implementation and adoption going well, some organizations may be at heightened risk simply because the effort is being compartmentalized—isolated within a department, or assigned to only one or two people. How effectively leadership connects CECL implementation with tenets of change management, how quickly they understand, then together embrace, promote, and facilitate the related changes affecting people and their work, may prove to be the key factor in achieving success beyond compliance.  

One important step leaders can take is to perform an impact assessment to understand who in the organization is being affected by the transition to CECL, and how. An example of this is below. Identifying the departments and functions that will need to be changed or updated with CECL adoption might expose critical overlaps and reveal important new or enhanced collaborations. Adding in the number of people represented by each group gives leaders insight into the extent of the impact across the institution. By better understanding how these different groups are affected, leaders can work together to more effectively prioritize, identify and remove roadblocks, and support peoples’ efforts longer term.           

 
No matter where your institution is currently in its CECL implementation journey, it is not too late to course-correct. Leadership—unified in priority, message, and understanding—can achieve the type of success that produces efficient sustainable practices, and increases employee resilience and engagement.

For more information, visit the CECL page on our website. If you would like specific answers to questions about your CECL implementation, please visit our Ask the Advisor page to submit your questions. For more tips on documenting your CECL adoption, stay tuned for our next article in the series, revisit past articles, or tune in to our CECL Radio podcast. You can also follow Susan Weber on LinkedIn.

Article
Implementing CECL: Kicking and screaming

Editor's note: read this if you are a CFO, controller, accountant, or business manager.

We auditors can be annoying, especially when we send multiple follow-up emails after being in the field for consecutive days. Over the years, we have worked with our clients to create best practices you can use to prepare for our arrival on site for year-end work. Time and time again these have proven to reduce follow-up requests and can help you and your organization get back to your day-to-day operations quickly. 

  1. Reconcile early and often to save time.
    Performing reconciliations to the general ledger for an entire year's worth of activity is a very time consuming process. Reconciling accounts on a monthly or quarterly basis will help identify potential variances or issues that need to be investigated; these potential variances and issues could be an underlying problem within the general ledger or control system that, if not addressed early, will require more time and resources at year-end. Accounts with significant activity (cash, accounts receivable, investments, fixed assets, accounts payable and accrued expenses and debt), should be reconciled on a monthly basis. Accounts with less activity (prepaids, other assets, accrued expenses, other liabilities and equity) can be reconciled on a different schedule.
  2. Scan the trial balance to avoid surprises.
    As auditors, one of the first procedures we perform is to scan the trial balance for year-over-year anomalies. This allows us to identify any significant irregularities that require immediate follow up. Does the year-over-year change make sense? Should this account be a debit balance or a credit balance? Are there any accounts with exactly the same balance as the prior year and should they have the same balance? By performing this task and answering these questions prior to year-end fieldwork, you will be able to reduce our follow up by providing explanations ahead of time or by making correcting entries in advance, if necessary. 
  3. Provide support to be proactive.
    On an annual basis, your organization may go through changes that will require you to provide us documented contractual support.  Such events may include new or a refinancing of debt, large fixed asset additions, new construction, renovations, or changes in ownership structure.  Gathering and providing the documentation for these events prior to fieldwork will help reduce auditor inquiries and will allow us to gain an understanding of the details of the transaction in advance of performing substantive audit procedures. 
  4. Utilize the schedule request to stay organized.
    Each member of your team should have a clear understanding of their role in preparing for year-end. Creating columns on the schedule request for responsibility, completion date and reviewer assigned will help maintain organization and help ensure all items are addressed and available prior to arrival of the audit team. 
  5. Be available to maximize efficiency. 
    It is important for key members of the team to be available during the scheduled time of the engagement.  Minimizing commitments outside of the audit engagement during on site fieldwork and having all year-end schedules prepared prior to our arrival will allow us to work more efficiently and effectively and help reduce follow up after fieldwork has been completed. 

Careful consideration and performance of these tasks will help your organization better prepare for the year-end audit engagement, reduce lingering auditor inquiries, and ultimately reduce the time your internal resources spend on the annual audit process. See you soon. 

Article
Save time and effort—our list of tips to prepare for year-end reporting

Read this if you are a community bank.

The Federal Deposit Insurance Corporation (FDIC) recently issued its first quarter 2022 Quarterly Banking Profile. The report provides financial information based on Call Reports filed by 4,796 FDIC-insured commercial banks and savings institutions. The report also contains a section specific to community bank performance. In first quarter 2022, this section included the financial information of 4,353 FDIC-insured community banks. BerryDunn’s key takeaways from the report are as follows:

Community banks continue to feel the impact of shrinking net interest margins and inflation.

Community bank quarterly net income dropped to $7 billion in first quarter 2022, down $1.1 billion from a year ago. Lower net gains on loan sales and higher noninterest expenses offset growth in net interest income and lower provisions. Net income declined $581.3 million, or 7.7 percent from fourth quarter 2021 primarily because of lower noninterest income and higher noninterest expense.

Loan and lease balances continue to grow in first quarter 2022

Community banks saw a $21.5 billion increase in loan and lease balances from fourth quarter 2021. All major loan categories except commercial & industrial and agricultural production grew year over year, and 55.3 percent of community banks recorded annual loan growth. Total loan and lease balances increased $35.1 billion, or 2.1 percent, from one year ago. Excluding Paycheck Protection Program loans, annual total loan growth would have been 10.2 percent.

Community bank net interest margin (NIM) dropped to 3.11 percent due to strong earning asset growth.

Community bank NIM fell 15 basis points from the year-ago quarter and 10 basis points from fourth quarter 2021. Net interest income growth trailed the pace of earning asset growth. The yield on earning assets fell 28 basis points while the cost of funding earning assets fell 13 basis points from the year-ago quarter. The 0.24 percent average cost of funds was the lowest level on record since Quarterly Banking Profile data collection began in first quarter 1984. 

Community bank allowance for credit losses (ACL) to total loans remained higher than the pre-pandemic level at 1.28 percent, despite declining 4 basis points from the year-ago quarter.


NOTE: The above graph is for all FDIC-Insured Institutions, not just community banks.

The ACL as a percentage of loans 90 days or more past due or in nonaccrual status (coverage ratio) increased to a record high of 236.7 percent. The decline in noncurrent loan balances outpaced the decline in ACL, with the coverage ratio for community banks emerging 57.9 percentage points above the coverage ratio for noncommunity banks. 

The banking landscape continues to be one that is ever-evolving. With interest rates on the rise, banks will find their margins in flux once again. During this transition, banks should look for opportunities to increase loan growth and protect and enhance customer relationships. Inflation has also caused concern not only for banks but also for their customers. This is an opportune time for banks to work with their customers to navigate the current economic environment. Community banks, with their in-depth knowledge of their customers’ financial situations and the local economies served, are in a perfect position to build upon the trust that has already been developed with customers.

As always, please don’t hesitate to reach out to BerryDunn’s Financial Services team if you have any questions.

Article
FDIC issues its First Quarter 2022 Quarterly Banking Profile

Read this if you use QuickBooks Online.

With gas prices so high, you need to track your travel costs as closely as possible. Consider getting a tax deduction for your business mileage.

If you drive even a little for business, it’s easy to let mileage costs slide. After all, it’s a pain to keep track of your tax-deductible mileage in a little notebook and do all the calculations required. If you do rack up a lot of business miles, you probably forget to track some trips and end up losing money.

QuickBooks Online offers a much better way. Its Mileage tools include simple fill-in-the-blank records that allow you to document individual trips. You can either enter the starting point and destination and let the site calculate your mileage and deduction or enter the number of miles yourself.

If you use QuickBooks Online’s mobile app, it can track your miles automatically as you drive (as long as you have the correct settings turned on). Here’s a look at how all of this works.

Setting up 

To get started, click the Mileage link in QuickBooks Online’s toolbar. The screen that opens will eventually display a table that contains information about your trips, but you need to do a little setup first. Click the down arrow next to Add Trip in the upper right corner and select Manage vehicles. A panel will slide out from the right. Click Add vehicle.

 
You’ll need to supply information about your vehicles before you can start entering trips.

You’ll need to supply the vehicle’s year, make, and model. Do you own or lease it, and on what date was the vehicle purchased or leased and put into service? Do you want to have your annual mileage calculated by entering odometer readings or have QuickBooks Online track your business miles driven automatically? When you’re done making your selections and entering data, click Save.

Entering trip data

You can download trips as CSV files or import them from Mile IQ, but you’re probably more likely to enter them manually. Click Add Trip in the upper right corner. In the pane that opens, you’ll enter the date of the trip and either the total miles or start and end point. You’ll select the business purpose and vehicle and indicate whether it was a round trip. When you’re done, click Save. The trip will appear in the table on the opening screen, and your current possible total deduction will be in the upper left corner, along with your total business miles and total miles.

If you want to designate a trip as personal, click the box in front of the trip in that table. In the black horizontal box that appears, click the icon that looks like a little person, then click Apply. Now, the trip will appear in the Personal column and will not count toward your business tax-deductible mileage. 

When you select a trip in the Mileage table, you can mark it as personal so it’s not included in your business tax-deductible miles.

Personal trips can count, too

If you use your vehicle(s) for personal as well as business purposes, tracking some of those miles can also mean a tax deduction. For tax year 2022, you can deduct 18 cents per mile for your travel to and from medical appointments. Note: Medical mileage is only deductible if medical exceeds a certain percent of AGI. Be sure to check with the IRS yearly tax code, as they update the mileage amounts annually.

And if you do volunteer work for a qualified charitable organization, the miles you drive in service of it can be deducted at the rate of 14 cents per mile. You can also claim the cost of parking and tolls, as long as you weren’t reimbursed for any of these expenses. Obviously, the IRS wants you to keep careful records of your charitable mileage, and QuickBooks Online can provide them.

QuickBooks Online doesn’t track these deductions, but you’ll at least have a record of the miles driven.

Auto-track your miles

The easiest way to track your mileage in QuickBooks Online is by using its mobile app. You can launch this and have it record your mileage automatically as you’re driving. Versions are available for both Android and iOS, and they’re different from each other. They also have more features than the browser-based version of QuickBooks Online, like maps, rules, and easier designation of trips as business or personal.

 
The iOS version of Mileage in the QuickBooks Online app

In both versions, you’ll need to click the menu in the lower right corner after you’ve opened the QuickBooks Online app and select Mileage. Make sure Auto-Tracking is turned on. Your phone’s location services tool must be turned on, too. There are other settings that vary between the two operating systems. You can search the help system of either app to make sure you get your settings correct if the onscreen instructions aren’t clear enough.

Of course, you won’t see the fruits of your mileage deductions until you file your 2022 taxes. But you can factor these savings in as you’re doing your tax planning during the year. Please contact the Outsourced Accounting team if you’re having any trouble with QuickBooks Online’s Mileage tools, or if you have questions with other elements of the site.

Article
How QuickBooks Online helps you track mileage

Read this if you are a financial institution.

Choosing a method for estimating lifetime expected losses is a commitment. A commitment that signals, in spite of any other option, you’re certain this method is the right one for you—your segment, portfolio, and institution. While you might be able to support a change in method later, it is much more likely you’ll be living with this decision a good long while. So, how exactly does one know which method is the right one? Let’s take a few minutes to answer some frequently asked questions about selecting methods for CECL.

How many CECL methods are there?

This depends on who you ask. Section 326-20-30-3 of the standard names five (5) categories: discounted cash flow, loss-rate, roll-rate, probability of default, and aging schedule. Some categories, like loss-rate, have several methods. Additionally, some methods seem to be referred to by different names, giving people the impression that there are exponentially more options out there than there really are. With this in mind, I tend to think of two (2) broad categories, and seven (7) unique methods:  

  • Loss-rate methods
    • Snapshot (open pool, static pool, cumulative loss rate)
    • Remaining Life and Weighted Average Remaining Maturity (WARM)
    • Vintage
       
  • Other methods
    • Scaled CECL Allowance for Losses Estimator (SCALE) (option for banks with assets <$1 billion)
    • Discounted Cash Flow (DCF)
    • Probability of default 
    • Migration (roll rate, aging schedule)  

What’s the difference?

The loss-rate methods use actual historical net charge-off information in different ways to derive a loss rate that can then be used to calculate expected losses over the remaining life of a pool. In general, they do this by holding the mix of a group of loans constant (e.g., by year of origination) and then tracking net losses tied to that grouping over time. The “other” methods employ a variety of mathematical techniques and/or credit quality information to estimate expected lifetime losses. For a quick overview of each method and corresponding resources, access our CECL methodologies guide here.

How do I know which to use?

This is the CECL equivalent of the proverbial million-dollar question. Technically, any institution could use any one, or all of these methods. But there are considerations that make some of them a more or less likely fit. For example, if your institution has >$1 billion in assets, SCALE is not even an option for you, and you can cross it off the list. If you are not in a position to afford software, or lack the internal expertise to build a similar model internally, then discounted cash flow and probability of default methods would likely be extremely burdensome in the normal course of business. For that reason, you may need to cross those off your list. If you lack large pools with consistently diverse performance over time, then migration methods will be difficult to support. If you have a relatively stable loan mix, consistent credit culture, and a lot of reliable historical loss data—especially through multiple economic cycles—the loss-rate methods may be a good fit, with or without software. If your portfolio has undergone a lot of changes—products, underwriting standards, merger and acquisition activity—and/or there are significant gaps in key data that cannot be restored, then you might want to re-consider software and one of the “other” methods. 

What are the pros and cons of the various methods?

One pro of the loss-rate and SCALE methods is they have been shown to be manageable without software. Examples of all of these methods have been illustrated using Excel spreadsheets. The use of Excel is also potentially a con, given that more spreadsheets and, maybe more people, are likely going to be involved in computing the Allowance for Credit Losses (ACL). As a result, version control as well as validation of spreadsheet macros, inputs, formulas, math, and risk of accidentally overwriting or deleting values should be addressed. One pro of the discounted cash flow method is that it is a bottom-up approach, meaning each loan’s discounted cash flow (DCF) is computed and then rolled up to the segment level. Because of this, DCF can more easily handle mixed pools, e.g., loans of all vintages, sizes, terms, payment and amortization schedules, etc. A potential con of DCF is that it really requires software, staff trained to use the software appropriately, and an understanding of the vast array of choices, levers, and decisions that come with it.     

Does my choice of method affect my qualitative adjustment options?

How’s this for commitment: maybe. In general, I think it’s safe to say that CECL requires additional thought be given to the nature and degree of adjustments. This is especially true when you look at the combination of potential segmentation changes, new elements of the calculation, and the variety of methods now available. Consider the example of a bank using a loss-rate method and facing a potential economic downturn. If that bank has sufficient history and a relatively stable portfolio mix, credit culture, and geography, then it might elect to use a different time period—say, historical loss-rates observed from the last recession—rather than those more recently computed. In this case, the loss-rate method would already be using a recessionary experience. 

How then, would the bank approach additional qualitative adjustments for changing economic outlooks to ensure it is not layering (or double counting) reserve? Going back to the original “maybe” response, perhaps the answer is less about inherent conflicts between methods and qualitative adjustments. Rather, it’s about understanding that given your chosen method, you may be faced with even more decisions about if, where, and how much adjusting you are doing.

CECL adoption is required. Struggling to adopt isn’t. We can help.

No matter what stage of CECL readiness you are in, we can help you navigate the requirements as efficiently and effectively as possible. For more information, visit the CECL page on our website. If you would like specific answers to questions about your CECL implementation, please visit our Ask the Advisor page to submit your questions.

For more tips on documenting your CECL adoption, stay tuned for our next article in the series. You can also follow Susan Weber on LinkedIn.

Article
Questions to ask when deciding your CECL Method

Read this if you use QuickBooks Online.

You should be running reports in QuickBooks Online on a weekly—if not daily—basis. Here’s what you need to know.

You can do a lot of your accounting work in QuickBooks Online by generating reports. You can maintain your customer and vendor profiles. Create and send transactions like invoices and sales receipts, and record payments. Enter and pay bills. Create time records and coordinate projects. Track your mileage and, if you have employees, process payroll.

These activities help you document your daily financial workflow. But if you’re not using QuickBooks Online’s reports, you can’t know how individual elements of your business like sales and purchases are doing. And you don’t know how all of those individual pieces fit together to create a comprehensive picture of how your business is performing. 

QuickBooks Online’s reports are plentiful. They’re customizable. They’re easy to create. And they’re critical to your understanding of your company’s financial state. They answer the small questions, like, How many widgets do I need to order?, and the larger, all-encompassing questions like, Will my business make a profit this year?

Getting the lay of the land

Let’s look at how reports are organized in QuickBooks Online. Click Reports in the toolbar. You’ll see they are divided into three areas that you can access by clicking the labeled tabs. Standard refers to the comprehensive list of reports that QuickBooks Online offers, displayed in related groups. Custom reports are reports that you’ve customized and saved so you can use the same format later. And Management reports are very flexible, specialized reports that can be used by company owners and managers.


A partial view of the list of QuickBooks Online’s Standard reports 

Standard reports

The Standard Reports area is where you’ll do most—if not all—of your reporting work. The list of available reports is divided into 10 categories. You’re most likely to spend most of your time in just a few of them, including:

  • Favorites. You’ll be able to designate reports that you run often as Favorites and access them here, at the top of the list.
  • Who owes you. These are your receivables reports. You’ll come here when you need to know, for example, who is behind on making payments to you, how much individual customers owe you, and what billable charges and time haven’t been billed.
  • Sales and customers. What’s selling and what’s not? What have individual customers been buying? Which customers have accumulated billable time?
  • What you owe. These are your payables reports. They tell you, for example, which bills you haven’t paid, the total amount of your unpaid bills (grouped by days past due), and your balances with individual vendors.
  • Expenses and vendors. What have I purchased (grouped by vendor, product, or class)? What expenses have individual vendors incurred? Do I have any open purchase orders?

The Business Overview contains advanced financial reports that we can run and analyze for you. The same goes for the For my accountant reports. Sales tax, Employees, and Payroll will be important to you if they’re applicable for your company.

Working with individual reports


Each individual report in QuickBooks Online has three related task options.

To open any report, you just click its title. If you want more information before you do that, just hover your cursor over the label. Click the question mark to see a brief description of the report. If you want to make the report a Favorite, click the star so it turns green. And clicking the three vertical dots opens the Customize link. 

When you click the Customize link, a vertical panel slides out from the right, and the actual report is behind it, grayed out. Customization options vary from report to report. Some are quite complex, and others offer fewer options. The Sales by Customer Detail report, for example, provides a number of ways for you to modify the content of your report so it represents exactly the “slice” of data you want. So you can indicate your preferences in areas like:

  • Report period
  • Accounting method (cash or accrual)
  • Rows/columns (you can select which columns should appear and in what order, and group them by Account, Customer, Day, etc.)
  • Filter (choose the data group you want represented from several options, including Transaction Type, Product/Service, Payment Method, and Sales Rep)

Once you’ve run the report, you can click Save customization in the upper right corner and complete the fields in the window that opens. Your modification options will then be available when you click Custom reports, so you can run it again anytime with fresh data.


You can customize QuickBooks Online’s reports in a variety of ways.

We’ll go into more depth about report customization in a future article. For now, we encourage you to explore QuickBooks Online’s reports and their modification options so that you’re familiar with them and can put them to use anytime. Contact our Outsourced Accounting team if you have any questions about the site’s reports, or if you need help making your use of QuickBooks Online more effective and productive.

Article
Getting started with reports in QuickBooks Online

Read this if you are a financial institution.

As you know by now, ASU No. 2016-13, Financial Instruments – Credit Losses (Topic 326), better known as the CECL standard, has already been implemented for some and will soon be implemented for all others (fiscal years beginning after December 15, 2022 to be exact). During your implementation process, the focus has likely been on your loan portfolio, and rightfully so, as CECL overhauls 40+ years of loan loss reserve practices. But, recall that the CECL standard applies to all financial instruments carried at amortized cost. So, it therefore includes held-to-maturity (HTM) debt securities. And, although not carried at amortized cost, the CECL standard also makes targeted enhancements to available-for-sale (AFS) debt securities. As if re-hauling your entire allowance methodology wasn’t enough! Before tearing out your hair because of another CECL-related change, let’s quickly review what is currently required for securities, and then focus on how this will change when you implement CECL.

Current US GAAP

Under current US generally accepted accounting principles (GAAP), direct write-downs on HTM and AFS debt securities are recorded when (1) a security’s fair value has declined below its amortized cost basis and (2) the impairment is deemed other-than-temporary. This assessment must be completed on an individual debt security basis. Providing a general allowance for unidentified impairment in a portfolio of securities is not appropriate. The previous amortized cost basis less the other-than-temporary impairment (OTTI) recognized in earnings becomes the new amortized cost basis and subsequent recoveries of OTTI may not be directly reversed into interest income. Rather, subsequent recoveries of credit losses must be accreted into interest income.

CECL: Held-to-maturity securities

Then comes along CECL  and changes everything. Once the CECL standard is implemented, expected losses on HTM debt securities will be recorded immediately through an allowance for credit loss (ACL) account, rather than as a direct write-down of the security’s cost basis. These securities should be evaluated for risk of loss over the life of the securities. Another key difference from current GAAP is that securities with similar risk characteristics will need to be assessed for credit losses collectively, or on a pool basis, not on an individual basis as currently prescribed. Also, contrary to current GAAP, since expected losses will be recorded through an ACL account, subsequent improvements in cash flow expectations will be immediately recognized through earnings via a reduction in the ACL account. CECL effectively eliminates the direct write-down method, with write-offs only occurring when the security, or a portion thereof, is deemed to be uncollectible. 

In practice, there may be some types of HTM debt securities that your institution believes have no risk of nonpayment and thus risk of loss is zero. An example may be a US Treasury debt security or possibly a debt security guaranteed by a government-sponsored enterprise, such as Ginnie Mae or Freddie Mac. In these instances, it is acceptable to conclude that no allowance on such securities is necessary. However, such determination should be documented and changes to the credit situation of these securities should be closely monitored.

Financial institutions that have already implemented CECL have appreciated its flexibility; however, just like anything else, there are challenges. One of the biggest questions that has risen is related to complexity, specifically from financial statement users in regards to the macroeconomic assumptions used in models. Another common challenge is comparability to competitors’ models and estimates. Each financial institution will likely have a different methodology when recording expected losses on HTM debt securities due to the judgment involved. These concerns are not unique to the ACL on HTM debt securities but are nonetheless concerns that will need to be addressed. A description of the methodology used to estimate the ACL, as well as a discussion of the factors that influenced management’s current estimate of expected losses must be disclosed in the financial statements. Therefore, management should ensure adequate information is provided to address financial statement users’ concerns.  

CECL: Available-for-sale securities

Upon CECL adoption, you are also expected to implement enhancements to existing practices related to AFS debt securities. Recall that AFS debt securities are recorded at fair value through accumulated other comprehensive income (AOCI). This will not change after adoption of the CECL standard. However, the concept of OTTI will no longer exist. Rather, if an AFS debt security’s fair value is lower than its amortized cost basis, any credit related loss will be recorded through an ACL account, rather than as a direct write-down to the security. This ACL account will be limited to the amount by which fair value is below the amortized cost basis of the security. Credit losses will be determined by comparing the present value of cash flows expected to be collected from the security with its amortized cost basis. Non-credit related changes in fair value will continue to be recorded through an investment contra account and other comprehensive income. So, on the balance sheet, AFS debt securities could have an ACL account and an unrealized gain/loss contra account. The financial institution will be responsible for determining if the decline in the value below amortized cost is the result of credit factors or other macroeconomic factors. In practice, the following flowchart may be helpful:

Although changes to debt securities may not be top of mind when working through CECL implementation, ensuring you reserve time to understand and assess the impact of these changes is important. Depending on the significance and composition of your institution’s debt security portfolio, these changes may have a significant impact on your financial institution’s financial statements from CECL adoption forward. For more information, visit the CECL page on our website. If you would like specific answers to questions about your CECL implementation, please visit our Ask the Advisor page to submit your questions.

Article
Don't forget about me! Changes in debt security accounting resulting from CECL 

Read this if you are at a financial institution.

While documentation of your CECL implementation and ongoing practices is essential to a successful outcome, it can sometimes feel like a very tall order when you are building a new methodology from the ground up. It may help to think of your CECL documentation as your methodology blueprint. While others will want to see it, you really need it to ensure that what you are building is well-designed, structurally sound, appropriately supported, and will hold up to subsequent “renovations” (model changes or tweaks). To help you focus on what’s essential, consider these documentation tips:

Getting started

Like any good architect, you need to understand the expectations for your design—what auditors and regulators want to see in your documentation. Two resources that can really help are the AICPA Practice Aid: Allowance for credit losses-audit considerations1, and the Interagency Supervisory Guidance on Model Risk Management2. One way to actively use these guides is to take note of the various section/subject headers and the key points, ideas, and questions highlighted within each, and turn that into your documentation checklist. You’ll also want to think strategically about where to keep the working document, who needs access to it, and how to maintain version control. It is also a good idea to decide up-front how you will reference, catalog, and store the materials (e.g., data files, test results, analyses, committee minutes, presentations, approvals, etc.) that helped you make and capture final decisions. You can download our CECL Documentation checklist now.   

What to watch out for

What’s new under CECL are areas requiring documentation (e.g., broader scope of “financial assets,” prepayments, forecasts, reversion, etc.). But watch out for elements that seem familiar—they may now have a new twist (e.g., segmentation, external data, Q factors, etc.). It’s a good idea to challenge any documentation from the past that you feel could be re-purposed or “rolled into” your CECL documentation. Be prepared also to spend time explaining or customizing vendor-provided documents (e.g., model design and development, data analysis memos, software procedures, etc.). 

While this material can give you a running start, they will not on their own satisfy auditor and regulator expectations. Ultimately, your documentation will need to reflect your own understanding and conclusions: how you considered, challenged, and got comfortable with the vendor’s work; what validations and testing you did over that work, and how you’ve translated this into policies and procedures appropriate for your institution’s operations, workflows, governance, and controls. For more information on making the vendor decision, and for suggestions of vendor selection criteria, read our previous article “CECL Readiness: Vendor or no vendor?” 

Point of view

It is human nature, especially whenever entering new territory, to want to know how others are approaching the task at hand. Related to CECL, networking, joining peer discussion groups, researching what and how those who have already adopted CECL are disclosing, are all great ways to see possibilities, learn, and gain perspective. When it comes to CECL documentation, however, the most important point of view to communicate is that of your institution’s management. Consider the difference in these two documentation approaches: (a) we looked at what others are doing, this is what most of them seem to be doing, so we are too; or (b) this is what we did and why we feel this decision is the best for our portfolio/risk profile; as part of our decision-making process, we did this type of benchmarking and discovered this. Example b is stronger documentation: your point of view is the primary focus, making it clear you reached your own conclusions. 

Other elements for CECL documentation

Documenting your CECL implementation, methodology, and model details is critical, but not the only documentation expected as you transition to CECL. It has been said that CECL is a much more enterprise-wide methodology, meaning that some of the model decisions or inputs may require you use data and assumptions traditionally controlled in other departments and for other purposes. One common example of this is prepayments. Up to this point, prepayment data may have been something between management and a vendor and used for management discussion and planning, but not necessarily validated, tested, or controlled for in the same way as your loss model calculations. Under CECL, this changes specifically because it is now an input into the loss estimate that lands in your financial statements. As a result, prepayments would be subject to, for example, “accuracy and completeness” considerations, among others (for more information on these expectations, refer to our earlier articles on data and segmentation). Prepayments is just one example, but does illustrate how CECL adoption will likely trigger updates to policies, procedures, governance, and controls across multiple areas of the organization.    

One final note: There are some new financial statement disclosures required with CECL adoption. Beyond those, there may be other CECL-related information either you want to share, or your audit/tax firm recommends be disclosed. Consulting with your auditor at least a quarter prior to adoption will help make sure you aren’t scrambling last minute to draft new language or tables.  

Struggling with CECL documentation or other elements of CECL? 

No matter what stage of CECL readiness you are in, we can help you navigate the requirements as efficiently and effectively as possible. For more information, visit the CECL page on our website. If you would like specific answers to questions about your CECL implementation, please visit our Ask the Advisor page to submit your questions.

For more tips on documenting your CECL adoption, stay tuned for our next article in the series. You can also follow Susan Weber on LinkedIn.

1You can find the AICPA Practice Aid here.
2The interagency guidance was released as OCC Bulletin 2011-12, FRB SR 11-7, and as FDIC FIL 22-2017

 

Article
CECL documentation: Your methodology blueprint