Technology news

Tax

IRS: Beware of New E-mail Phishing Scam

This latest phishing scheme involves e-mails to taxpayers that appear to be from the IRS Taxpayer Advocate Service and include a bogus case number. The bogus e-mails direct the recipient to click on links to web pages that solicit personal information.
Education & Careers

High Impact Excel: Pivot Tables Redux

In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!
Technology

What to Do When Sparklines Are Disabled

Readers are confused about Excel's Sparklines; explanations and a simple trick make this powerful spreadsheet feature work.
A&A

Social Media Risk Is a Concern for Internal Auditors

A top priority for chief audit executives and internal auditors this year is preventing risks – such as hits to the bottom line and a loss of productivity – that could result from social media use within their organizations, according to a survey released last week by global consulting firm Protiviti.
Practice Management

ID Theft at IRS: Could Your Firm Be Next?

If someone can walk out of the IRS with personal information on 20,000 people, they can do it at your firm.
Practice Management

How to Get Excel to Handle Social Security Numbers Properly

Almost every accountant handles Social Security numbers and almost every Excel spreadsheet screws them up. Here's how to fix them.
Tax

Do 'Cloud' Ventures Result in Sales Tax Problems?

The "Cloud" is all the rage, promising to solve a range of data management issues. But care is needed – you may end up with a sales tax nexus.
Technology

Opposition Mounts for House XBRL Exemption Legislation

XBRL US and several corporate data providers are against a bill approved last week by the House Financial Services Committee that would require the US Securities and Exchange Commission to exempt public companies with annual revenues under $250 million from filing their financial statements in XBRL format for five years.
Technology

Excel: The Indispensable NCAA Bracket Tool

Sports enthusiasts should know that Excel isn't just for accountants: it's for anyone running a Final Four betting pool.
Technology

Accounting’s Got ‘Game’: Bank On It Designed to Engage High Schoolers

A new accounting game launched this month by the American Institute of CPAs, Bank On It, challenges high school students on accounting fundamentals and real-world workplace scenarios in the context of an online board game.
Technology

How to Improve Spreadsheet Integrity with VLOOKUP

Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain integrity.
Practice

Here Are Some Risks to Consider Before Using Social Media for Your Business

The noise about using social media as a means to grow your business has become so constant it almost blends into the background at this point. With Facebook, Twitter, and LinkedIn pushing their advertising platforms and Google+ touting better search optimization, it’s inescapable.
Technology

How to Resolve Duplicate Data within Excel Pivot Tables

An attendee from my recent pivot table webinar posed a question that I hadn’t encountered before.
Technology

Here's an Infographic of the Top 20 Names in Accounting Software

You've probably heard of lots of these brands and there are a few obscure ones, but overall this is a pretty comprehensive list from Capterra of the who's who in accounting software today.
Technology

High Impact Excel: Answers to Three Pivot Table Questions

David Ringstrom shares three of the best Excel-related questions he received during a question-and-answer session after a recent AccountingWEB webinar he conducted, "High Impact Excel: Pivot Table Edition."
Tax

IRS Releases Version 4.0 of Mobile App

It might take slightly longer for taxpayers to get their tax refunds from the IRS this year, but at least they can do a better job of tracking the progress on their smartphones.
Practice

Sqrl Is a ‘Digital Hunter-Gatherer’ for Accounting Firms

The web-based application, launched last week by the founders of the Ohio-based online accounting firm Upsourced Accounting, efficiently collects and manages information for professional service organizations.
Education & Careers

High Impact Excel: VLOOKUP Edition

In this session Excel expert David Ringstrom introduces beginners to the VLOOKUP function, and then go beyond the basics with a discussion of with the MATCH, CHOOSE, INDEX, SUMIF, SUMIFS, and SUMPRODUCT functions.
Technology

Do Your Best to Tame the Technology Beast This Busy Season

It seems you can’t go anywhere or do anything without technology. I know that’s a big Homer Simpson “Doh!,” but it’s true.
Education & Careers

High Impact Excel: Pivot Table Edition

In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!

Pages


Already a member? log in here.