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...
by Bria Wright
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
by Wayne Winston
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...
by Jennifer Louis
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...
by Tara Fisher
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...
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.
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
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...
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...
by John Stevko
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...
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...
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 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...
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...
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...
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...
In our January and February 2019 newsletters we discussed
the OFFSET function. Recall that the syntax of the OFFSET function is
OFFSET(cell reference, rows moved, columns
As we explained in our last two
articles, we begin in the cell reference and based on the rows...
The Financial Accounting Standards Board (FASB) has proposed
that two GAAP alternatives currently available only to nonpublic business
entities also be made available to nonprofit organizations. The accounting
alternatives were originally codified into GAAP through ASU 2014-02 and ASU...
Now that tax season is over, it is important to look at some
recent tax changes that affect compliance and planning for 2019. These changes have been brought about by the
Tax Cuts and Jobs Act (TCJA), new regulations, revenue procedures, notices, and
Medical deduction: The...
The Tax Cuts and Jobs Act added a new
provision to the Internal Revenue Code called the “Base Erosion and Anti-abuse
Tax” (BEAT). The IRS recently issued Form 8991, Tax on Base Erosion Payments of
Taxpayers with Substantial Gross Receipts, which taxpayers will use to report
their tax liability...
Forgot your password?
Username or E-mail: