Advertisement
The magazines

Microsoft Excel: Dating problems

When I paste a large amount of data into Excel containing dates as far back as the 1800s, the recent dates display correctly as valid dates, but the older dates automatically convert to text. I assume I need to adjust a setting in Excel, but I can’t find it. Can you help?

Going mobile

Ever dreamed of getting away from it all—permanently? One CPA figured out a way to do just that, and he shares tips on how other sole practitioners can do it, too.

Boost your LinkedIn profile

Be prepared when an unexpected career opportunity arises, by following these tips for keeping your LinkedIn page current.

Wi-Fi: Stopping illegal access

A little-known trick makes it easy for unscrupulous people to circumvent your sign-on/payment webpage and use your internet connection without paying the required access fee.

HSA amounts for 2016

The IRS issued the inflation-adjusted figures for calendar year 2016 for the annual contribution limits for health savings accounts and the minimum deductible amounts and maximum out-of-pocket expense amounts for high-deductible health plans.

No COD income from loans

Expiration of state limitation period on loan collection wasn’t conclusive of debt discharge.

Expanding your app-titude

This month: Can’t read the words in a photo? Try Scanner&Translator … Instantly speak another language with SayHi Translate … TransferWise makes foreign currency settlement cheaper, easier.

FBAR penalty amount guidelines set

Maximum penalties for willful failure to report foreign bank accounts on FinCEN Form 114, Report of Foreign Bank and Financial Accounts (FBAR), for multiple years are limited under new IRS procedures.

SPONSORED REPORT

How to find the right CAS clients

The key to success with CAS is selecting the best clients. Tools like ideal client profiles (ICPs), buyer personas, and even artificial intelligence can help identify the businesses that best fit each CAS practice.