Skip to Main Content

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 state Medicaid agency. 

As the end of the Public Health Emergency becomes more likely, much attention has been paid to the looming coverage cliff as state Medicaid agencies re-determine eligibility for their programs. The impacts can be mitigated in part by planning and taking proactive steps.

In the unsettling initial days of the COVID-19 Public Health Emergency (PHE), the Centers for Medicare and Medicaid Service (CMS) temporarily increased federal matching funds for state Medicaid programs. In exchange, states would suspend redeterminations of enrollees’ eligibility for the duration of the PHE. 

For Medicaid, states were in effect prohibited from disenrolling an individual from Medicaid programs. The result, according to CMS data, is 14.8 million more people were enrolled in Medicaid as of late 2021 than before the pandemic, reaching a total of nearly 79 million Medicaid enrollees.  According to one estimate, the end of the PHE could bring a decline in the number of Medicaid enrollees by as many as 15 million. This number includes an estimated 8.7 million adults and 5.9 million children. 

Local and state government eligibility staff will need to review the submitted documents and determine if these members qualify for continued Medicaid coverage. The potential exists for members to lose coverage, due to factors such as having moved, not realizing their circumstances have otherwise changed, or being unable or unaware to return the required paperwork within appropriate timeframes.

State Medicaid agencies strive to maintain an equitable program while remaining trusted stewards of public funds. With a large base of beneficiaries, this change is expected to impact the community and the healthcare market, with broad implications for public health. Similarly, the federal requirement for continuous health coverage has also helped state Medicaid agencies by easing the strain on organizations during pandemic-related disruptions. 

For these reasons state Medicaid agencies may search for routes to limit the loss of coverage. This can be accomplished through finding policy levers to retain members, establishing routes to alternative forms of insurance, and mitigating the risk of coverage loss for members. 

Mitigating the likelihood of becoming uninsured

State Medicaid agencies can reduce the risk that members lose their coverage and become uninsured through a number of steps. 

  • Designing comprehensive, multi-pronged, and targeted communication strategies. States can help Medicaid members understand the requirements and timelines required to maintain their coverage.
  • Updating systems to automate and reduce administrative burden. Maximizing ex parte renewals through the use of existing data that is stored in integrated systems.
  • Making key decisions early. States can minimize coverage loss by carefully planning the unwinding process and their approach to resuming Medicaid eligibility renewals.
  • Coordinating with other forms of coverage. Confirm or design user-friendly pathways by which a member is transferred or referred to other alternatives like the Marketplace or CHIP.
  • Leveraging their health plans. Particularly when it comes to coordinating outreach and updating member information. Managed care plans are also able to refer members who are losing coverage to other qualified health plans.

Policy levers for retaining members

States may consider reviewing emergency state plan amendments and appendix k amendments completed during the PHE to determine what flexibilities are possible to continue under existing authorities. At the same time, states should consider what other policy options may help retain coverage for existing members- for example:

  • Adopt 12 months continuous eligibility. This can be done for children via a State Plan Amendment (SPA), for adults through an 1115 waiver, and for individuals enrolled in BHP (via BHP Blueprint revision) 
  • Establish 12 months of postpartum coverage. This can be done through several paths, including SPAs 
  • Review operational policy for efficiencies. For example, a State could consider modifying the frequency of periodic data matching 

Next steps

The US Department of Health and Human Service has previously indicated its intention to provide notification to states of the end of the PHE 60 days before its scheduled end. The PHE was renewed in April 2022, and as of this writing will last until mid-July, meaning enrollees could lose Medicaid coverage as soon as August 1. The enhanced FMAP and the Maintenance of Eligibility (MOE) requirements are in place until the end of the quarter in which the PHE ends. In the case of a July 2022 end date to the PHE, the enhanced FMAP would last through September 30, 2022. 

Regardless, Medicaid agencies will need to begin reviewing all enrollees’ eligibility, performing outreach, and designing system updates this summer. In terms of next steps, states should consider the following:

  • Evaluate your program and identify initiatives to prioritize in the coming year. Ask your CMS contact about the latest applicable guidance. 
  • Develop Advanced Planning Documents (APDs) to help fund technology needs for initiatives, along with training your SMA team and providers. 
  • Implement a communications management approach to engage stakeholders, and inform affected Medicaid members.
  • Marshal project management resources and develop a realistic and achievable roadmap to success.  
  • Explore agency contracting vehicles, cooperative contracts, and other procurements tools. 

We’re here to help. If you have more questions or want to have an in-depth conversation about your specific situation, please contact the Medicaid consulting team.

Article
Medicaid coverage gap: Tools and strategies for Medicaid agencies to help retain members

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

Read this if you use QuickBooks Online.

Are you taking on a worker who’s not an employee? QuickBooks Online includes tools for tracking and paying independent contractors.

The COVID-19 pandemic created millions of self-employed individuals and small businesses. Whether they chose to, or circumstances forced them to, these new entrepreneurs had to learn new ways to get paid and to prepare their income taxes.

If you’re thinking about taking on a contract worker, you, too, will have to educate yourself on the paperwork and processes required to comply with the IRS’ rules for his or her compensation. It’s much easier than hiring a full-time employee, but it still takes some knowledge of how QuickBooks Online handles these individuals.

You’ll also need to make certain that the person you’re hiring is indeed an independent contractor and not an employee. The IRS takes this distinction very seriously. If you’re at all unsure of your new hire’s employment status, we can help you sort it out.

Creating records for contractors

Once new contractors have accepted your offer, you’ll need to have then fill out an IRS Form W-9. You can download a copy here. Employees complete the more detailed Form W-4 so that the employer can withhold income taxes correctly, but you won’t have to withhold taxes for your contract workers. They will be responsible for calculating and paying quarterly estimated taxes and filing an IRS Form 1040 every year. 

You, though, will be responsible for sending them an IRS Form 1099-NEC (Non-Employee Compensation) every January if you paid them more than $600 during the previous year. You do not need to send a 1099-NEC to a corporation or to an LLC that is treated as a C Corp or an S Corp. 

You can complete the Vendor Information window for each independent contractor, checking the box in front of Track payments for 1099.

Using the information the contractors provide, you can create records for them in QuickBooks Online. If you don’t have a QuickBooks Payroll subscription, you can set them up as 1099 vendors. Click the Expenses tab in the toolbar and then on the Vendors tab. Click New vendor in the upper right to open the Vendor Information window. Complete the fields for the worker and be sure to check the box in front of Track payments for 1099, as shown in the partial image above.

The vendor records you create will appear in QuickBooks Online’s Vendors list (again, Expenses | Vendors). Click on one to open it. You can toggle between two tabs here. The first, Transaction List, will eventually display all your financial dealings with that contractor. Vendor Details opens the record you just created, which you can edit from this screen.

Paying contractors

When independent contractors send you invoices, you’ll return to this same screen. There are three ways you can pay them. Click the down arrow next to New Transaction in the upper right corner to see your options (or look down at the end of the row while you’re in list view). You can record the debt as a Bill if you want to pay it later (or if that’s the way you structure your recordkeeping). If you’re paying it right away, you can create an Expense or write a Check

You can choose an option from this vendor action menu to pay your independent contractors.

When you click one of these, QuickBooks Online opens a form with many of the contractors’ details already filled in. You’ll need to complete any additional fields at the top of the screen, and then either record the payment or debt under Category details or Item details, depending on how you do your bookkeeping. Either way, you’ll be able to enter the quantity and rate and/or amount and mark it billable (with a markup percentage, if you’d like) to a customer or project.

You’re probably going to want our help here, since there’s more than one way to pay independent contractors. If you subscribe to QuickBooks Payroll, you can use the service’s contractor features, which include the ability to invite your contractors to fill out their own records in QuickBooks Online. You may also want to add an account to your Chart of Accounts, and we’d want to offer guidance there. And you need to ensure that you’re classifying payments correctly, so they’ll appear in 1099 reports and 1099s themselves.

Creating records for independent contractors and paying these individuals seem like they should be simple operations. But anytime you’re dealing with payroll issues, you’re dealing with peoples’ livelihoods – and the IRS. We strongly encourage you to let us help you get this right. Contact the Outsourced Accounting team, and we’ll make sure you’re handling your worker payments with absolute accuracy.

Article
Hiring an independent contractor? How QuickBooks Online can help