Category: Accounting & Finance

Accountants: How to Grow Relationships through Emotional Intelligence

At the latest Beta Alpha Psi (BAP) annual meeting, Becker instructor Mike Brown presented the importance of emotional intelligence (EQ) in professional accounting. Emotional intelligence is the capacity for recognizing our own feelings and those of others, and managing emotions well in ourselves...


How to Summarize Data with Treemap and Sunburst Charts in Excel

Treemap charts, also known as mosaic charts, and Sunburst charts were added to Excel to help you visualize hierarchical data. Hierarchical data is a way to organize data with multiple one-to-many relationships. The structure is based on the rule that one parent can have many children, but children...


Auditors Have New Responsibilities Relating to Other Information in Annual Reports

Statements on Auditing Standards No. 137, The Auditor’s Responsibilities Relating to Other Information Included in Annual Reports, was issued in July 2019.  It is codified under AU-C Section 720 of the AICPA Professional Standards.  The standard applies only to a single document or...


Here's What You Should Know About the Latest International Tax Guidance

Summertime is often associated with long vacations, lazy days, and afternoons by the pool sipping lemonade. This summer, however, has been anything but relaxing for the folks working at the Treasury Department and IRS. These organizations continue to issue the necessary guidance related to the...


Changed Requirements for Auditor Reporting and Performance on ERISA Plan Financial Statements

The Statement on Auditing Standards No. 136, Forming an Opinion and Reporting on Financial Statements of Employee Benefit Plans Subject to ERISA, was issued in July 2019. It is codified under AU-C Section 703 in the AICPA Professional Standards. The standard addresses the auditor’s...


3 Tricks to Help You Work Across Microsoft Excel Worksheets

Excel has three dimensions: rows, columns and worksheets. Most of us are familiar with how to use the powerful and indispensable Copy command to “copy” a formula across columns and down rows. In this article, we explore three tricks that can help you work across worksheets. Copying a...


Understanding the Tax Implications of the Legal Marijuana Industry

The legal marijuana industry is growing – and fast! As of 2019, 11 U.S. states and Washington, DC, have legalized marijuana for recreational use. The number of states that allow medicinal use of the drug is also steadily growing. As the legal marijuana industry grows, there is also a growing need...


Accountants: How to Craft the Perfect Elevator Pitch for Meet the Firms

Meet the Firms is an accounting-specific career fair that features representatives from various accounting, finance and CPA review firms. Attending a Meet the Firms event can be a crucial step in advancing your future career. You will get the opportunity to network with accounting professionals,...


How to Use Hyperlinks in Microsoft Excel

When navigating the web, we have all clicked on blue hyperlinks that send us to another web page. In this article, we will show you how to use hyperlinks in Excel to create links in your workbook to web pages or locations in your current workbook. Our work is in the file...


Understanding the Substance Over Form Doctrine

Substance over form. For tax practitioners this can be a big issue. Is that a real business loss your client has or is it just a hobby? Do you get to deduct all of your expenses related to the Becker Annual Tax Conference or is that merely a disguised gambling trip to Las Vegas? Two recent court...


Top Three Questions for Implementing the New Nonprofit Reporting Model

ASU 2016-14, Not-for-Profit Entities (Topic 958): Presentation of Financial Statements for Not-for-Profit Entities, made targeted improvements to the financial reporting model. The ASU was effective for fiscal years beginning after December 15, 2017. All calendar year-end entities have adopted the...


How to Create Your CPA Exam Study Routine

We recently asked our community of accountants how they balance full-time work, parenting and preparing for the CPA Exam. The top answer? Structure is key. Once you create a structured study routine, finding time to study and focusing on the material may not seem so difficult.   We can help...


AICPA Releases New SAS on Auditor Reporting

Statement on Auditing Standards (SAS) No. 134, Auditor Reporting and Amendments, Including Amendments Addressing Disclosures in the Audit of Financial Statements, was recently released by the AICPA’s Auditing Standards Board. The overall objective is to update the form and content of the...


Excel’s Stock Data Types

Office 365’s new stock data types allow you to type a company name or stock ticker symbol in Excel and write formulas that extract information about the company to a different cell. The file Stockdatatypes.xlsx contains our work. To begin we typed in the company names and ticker symbols shown...


The Joint Committee on Taxation Publishes Data on New BEAT Provision

The Tax Cuts and Jobs Act added a new provision to the Internal Revenue Code called the “Base Erosion and Anti-abuse Tax” (BEAT). In April 2019, the Joint Committee on Taxation (JCT) published a report that offers insight into the number of corporations that will be impacted by the BEAT...


Chicago CPA and NABA Member Shares Advice for Diverse Accounting Professionals

Chinedu “Chin” Iwuora has always been fascinated by money and how economies work. It’s no wonder he was immediately hooked on accounting after his first accounting class at Chowan University in North Carolina. “You can say I like the culture of business and accounting is the...


4 Tips to Balance CPA Preparation, Full Time Work and Parenting

Preparing for the CPA Exam is a special challenge, requiring a strong amount of dedication and hundreds of study hours. For working parents, it may feel nearly impossible to balance full time work, studying for the exam and parenting, but our community is here to help! Here are tips to assist...


An Auditor’s Responsibility for Cybersecurity Risks

Cybersecurity has rapidly become a significant risk to businesses as breaches of information may result in financial and reputational damage, diminished investor confidence, and exposure to potential regulatory fines. Cybersecurity risks and controls are within the scope of the financial statement...


Joint Committee on Taxation Publishes Distributional Effects of TCJA

The Joint Committee on Taxation (JCT) recently published a series of documents tied to the Tax Cuts and Jobs Act. One of the documents receiving a great deal of attention is the “Distributional Effects of Public Law 115-97.” The document provides distributional tables and analysis of the Tax...


Excel’s New Geographic Data Types

Office 365’s new geographic data types allow you to type a location in Excel and write formulas that extract information about the location to a different cell. For example, if you enter “Paris” in cell E4, entering the formula “E4.Population” in a different cell will...