Excel Puzzler: MAXIF Without Using an Array Function

Special AccountingWEB Article: A recent piece addressed the lack of MAXIF in Excel. A clever reader uncovered an alternative buried deep in Excel. Can you uncover it too? Test your Excel skills!

Companies Shelling Out More Money to Finance Executives

Salaries for finance leaders in private and public companies in 2014 have increased 3.3 percent and 3.4 percent, respectively, according to a new survey released by Grant Thornton and the Financial Executives Research Foundation.

IRS Draws the Line on Clothes, but Loopholes Remain

It's common knowledge that the IRS makes it difficult to deduct clothing used for work, but the Supreme Court has carved out some exceptions. Know how to take advantage of them.

Bramwell’s Lunch Beat: Meet Mike McGuire, Grant Thornton’s Next CEO

The menu for June 9 features specials on accountants and artwork, Israeli bank to pay US $289 million in tax-evasion deal, Illinois Tool and IRS to battle in US Tax Court, and more.

Intuit Injects Note of Caution on Cloud

Although the venerable accounting technology giant is onboard with the cloud, it advises firms to give a lot of thought and to take care of the details before making the move.

Expecting a Tax Refund? Not So Fast!

The IRS can hold back tax refunds of taxpayers for up to six months while it examines their tax returns from other years. It can then use the refund to offset the tax liability. And the program may expand further.

Bramwell’s Lunch Beat: FASB ‘Redoubling Our Efforts’ on US GAAP

The menu for June 6 features specials on Senate tax writers slate summer hearings on tax reform, more larger companies turning to smaller audit firms, Tax Foundation refutes report on corporate taxes, and more.

Tech Review: Keeping Track of Your Email Time

Email seems to take up a lot of your day—but do you know how much? There's a service that will time you, so you can see how much time you and your staff are spending (or wasting) on Outlook.

Economic Optimism Among CPAs Climbs Upward: AICPA

The number of CPAs and financial executives who are optimistic about the US economy has surpassed the 50 percent mark for the first time since the recession, according to a new AICPA survey released on Thursday.

Creating Excel's Equivalent of MAXIF

Excel doesn't have a MAXIF function, but you can easily adapt the MAX function. Learn how to write a special type of formula known as an array formula that will do the trick instead. Just take it step by step.

Bramwell’s Lunch Beat: PCAOB Will Consider Standard on Related Parties Next Week

The menu for June 5 features specials on the SEC extending settlement schedule with Big Four firms in China, a health insurance strategy the IRS may not approve of, Fortune 500 companies’ tax shelters, and more.

Auditing Special Purpose Frameworks: Planning Document, Part 1

A Planning Document is a cost-efficient way to document inquiries from the planning phase and to coordinate and summarize the results of various risk assessment procedures.

Many Companies Slow to Implement 2013 COSO Framework

According to a new Protiviti survey, 48 percent of the more than 600 audit executives and professionals surveyed reported that their organization had not yet applied the new internal control framework as of the first quarter of 2014.

New Zealand-based Xero Makes Major Play for the Cloud

Yes, everyone talks about the cloud today and many are using it already. But for Xero CEO Rod Drury, the cloud is more than just another tool: It's the shape of things to come.

Bramwell’s Lunch Beat: BEPS Rollout Won’t Be a Piece of Cake

The menu for June 4 features specials on Senate tax extenders bill stalled until November, tax-evasion probe targets another Swiss bank, tactic Walmart uses to slash its tax bill, PwC resigns as Annie’s auditor, and more.
Education & Careers

AICPA Task Force May Turn CPE on Its Head

An AICPA task force report challenges CPAs to think about learning in new ways. From 10-minute for-credit webinars to the use of game elements, tomorrow's CPE may look very different.

Revenue Recognition Transition Group to Convene Next Month

The group will be tasked with informing the FASB and the IASB about potential implementation issues that could arise when companies and organizations implement the new accounting standard.

Scott London’s Golf Buddy, Bryan Shaw, Gets 5 Months in Jail

The Los Angeles-area jeweler, who was sentenced on Monday, received confidential client information and stock tips from London that helped him make at least $1.6 million in illicit profits over a two-year period.

Short Sales Lead to Unexpected Tax Hardships

Going through a short sale is hard enough, both financially and psychologically. And the expiration of a special provision may mean a huge tax bill for those who can least afford it.


Already a member? log in here.