Category Archives for "Technology"

Review Financial Statements
Feb 14

Review Financial Statements on Monitors

By Charles Hall | Accounting and Auditing , Technology

Today I give you seven steps to review financial statements on computer screens. I explain how to review financial statements in Word and in PDFs. 

In another post titled How CPAs Review Financial Statements, I provide information about creating and reviewing financial statements, but it doesn’t provide information about doing so on computer screens. This article does.

Review Financial Statements on Computer Screens

Financial Statement Review in Word

  1. First, open and visually scan the entire financial statement (spend two to three seconds per page) just to get a feel for the whole product. How do the parts fit together? Are the financial statements subject to the Yellow Book? Do they contain supplementary information? Are the statements comparative?
  2. Second, use a large computer screen (22 inches or more) to compare your financial statement pages. If you are reviewing in Word, reduce the financial statement page size by holding the control key down and scrolling back with your mouse. As you do so, you will see multiple statements on the screen, for instance: balance sheet, income statement and cash flow statement.  Now that you can see multiple statements, you can tick and tie your numbers. I use step 2. to compare the financial statement numbers. For example, I compare the net income number on the income statement to the same number on the cash flow statement. Then I use step 3. to compare the financial statements to the notes and the supplementary information.
  3. Next, use two to three computer screens to compare your financial statements with the notes and supplementary information. Open the financial statement on each screen–for instance, the balance sheet on screen 1, the notes on screen 2, and the supplementary information on screen 3. In Word, click View, New Window and another instance of the document will open. Then you can move the new instance to a second screen. Alternatively, you can use the side-by-side feature in Word to place two open documents on one screen. 
  4. After completing your review of the notes, return to and take a second look at the balance sheet to see if the disclosures are complete. (Since you just reviewed the notes, it’s easier to compare them to the balance sheet. If, for example, you look at the balance sheet and see inventory but no disclosure for the same, you’ll more easily see the error.)
  5. Use the find feature (in Word, click the Home tab, click Find, then key in the number–or word–you are looking for) to locate words or numbers. If you want to compare the long-term debt number on the balance sheet to the notes and to supplemental information, type that number into your search dialog box and you’re immediately taken to the same number in the notes. Click next, and you will see the next instance (in the supplementary information). You can do the same with words. (Note: If you embed Excel tables in the Word document, the find feature will not locate numbers in the embedded tables. Consider PDF review option below.)
  6. When needed, take breaks. Never spend more than 1.5 hours reviewing statements without taking a short break. You get more done by relaxing periodically.
  7. Finally, if you are reviewing financial statements in Word, consider turning on Track Changes and key in suggested revisions. Word reflects your modifications in a distinct color. That way, others can see your suggested changes. They can also see who made the suggested corrections. Thereafter, they can accept or reject the proposed changes.

Financial Statement Review with PDF Documents

You may find it easier to review financial statements after converting them to a PDF (rather than in Word). This makes all numbers and words fully searchable (no embedded Excel spreadsheet limitation issue). 

You can use the split screen feature (click Windows, Split in Adobe Acrobat) to see the same financial statements on one screen. I usually do this on my center screen. This allows me to scroll and compare numbers in the financial statements. For instance, I compare total assets with total liabilities and equity. Or I compare equity on the balance sheet with my statement of changes in equity ending balances. 

I also open a second instance of the PDF on my right-hand screen, mainly to compare my notes with the financial statements (on my center screen). Then I use control-f to locate numbers or words. For instance, if I see $456,856 for total plant, property, and equipment (on my center screen), I click on the right-hand screen, then control-f, then key in the number to find it in the notes. 

I make review comments in the PDF using the comments feature in Adobe Acrobat. Then persons can respond with the reply feature in the comments field. That way, they can provide a response, whether they agree or not—and what they did if a correction was made. 

Your Suggestions

Those are my ideas. What are yours?

iPad apps for CPAs
Nov 02

iPad Apps for CPAs: Productivity

By Charles Hall | Technology

Here is a list of accountant’s iPad apps for CPAs. You’ll find each one helpful in your daily work. 

iPad apps for CPAs

iPad Apps for CPAs

Here are accountant’s iPad apps:

Checkpoint – A library of accounting and auditing publications by Thomson Reuters. You must pay for the books, but Checkpoint provides powerful search capabilities.

Notability – The best app I’ve found for taking notes. You can also record audio as you take notes and then quickly return to a specific part of the conversation by touching a written word with your iPad Pencil. I use this almost daily.

OmniFocusA high-end to-do list. It provides contextual listings, including a hotlist (to help me remember the most important things). You can add, for instance, a to-do item for a particular client or a trip to the hardware store. This app takes some time to understand, but very powerful. Consider taking David Sparks online OmniFocus class. I find it useful.

Box – A secure file storage system in the cloud. Very powerful. I started using Box about six months ago. There’s a learning curve, but it’s worth it. It’s pricey. I use this storage system for business files.

Dropbox – Cheaper than Box. A cloud-based storage system in the cloud. Dropbox is easy to use. I tend to use Dropbox for personal data. Dropbox seems to integrate more easily with other apps than Box does. I store large video or audio files here (rather than Evernote). This app feels like a large electronic sandbox.

Evernote – Storage app. I create “notes” inside Evernote and store whatever I desire. Evernote is my electronic library. I have saved thousands of articles and research. Apply several tags to each note, so you can quickly find the information you need.

Keynote – A slide presentation app. I use Keynote more than Powerpoint. The Keynote background slides are the best. I find it easier to create slide decks with my iPad than with my desktop.

WeatherWeather app. I start my day by checking the weather, and, when I’m going out of town, I check my destination’s weather before I leave.

Outlook – Email app. I tried Gmail for a while but returned to Outlook. It’s just easier. And it integrates with Office 365.

Dictionary – App used to define words and look for synonyms. Since I am a writer, I use this often. 

Scanbot – I take pictures of multiple pages, and the scan automatically loads to a specified Box folder.

Holy Bible – You Version Bible app. I start each day with this app. You Version is free and provides several different translations.

Explain Everything – Want your clients to see what you are drawing while you are online with them? Pull up a PDF and write on it with your iPad Pencil. Instantly your client sees what you are doing. Record the presentation (including sound) and store it. Then share the conversation with anyone. Crazy. 

AudibleAudible book app. I listen to books while I’m on the road (or when I am exercising). 

iThoughts – Want to brainstorm visually? iThoughts is your app. Create color-coded maps of your ideas. 

Pocket – An easy-to-use use app to capture internet articles as you see them. Don’t have time to read an article? Save the piece with Pocket with one click. The app shares the captured articles across platforms.

Documents – Write on PDFs or annotate them in other ways (like adding a red box to highlight an area). I don’t take paper copies of agendas or additional information to meetings. They are all here in Documents. It’s a great file manager that connects to file storage systems such as Dropbox. Documents works with all types of files, including Excel, Adobe Acrobat, Word, video files, images. 

Apple Pencil – Consider using an Apple Pencil with your apps. Cost is $129. I use one daily to write on electronic documents. (If you’ve tried other styluses and they’ve not worked, try this one.)

Your Thoughts about iPad Apps for CPAs?

What accountant’s iPad apps do you like?

Accountant’s ipad
Nov 02

Accountant’s iPad: My Favorite Computer

By Charles Hall | Technology

Today I discuss an accountant’s iPad.

Accountants use all types of electronic devices and software: Caseware, Excel, scanners, Powerpoint, Adobe Acrobat, monitors, QuickBooks, iPhones—just to name a few. For me, the iPad tops them all.

Accountant’s ipad

I purchased my first iPad about six years ago for about $500.  Then, four years ago, I bought a second one. A year ago I picked up my third. Now, having spent hundreds of hours on iPads, I am smitten. 

You may be thinking, “Charles, you’re a CPA. How do you and why do you spend that much time on an iPad? Don’t you primarily use a desktop computer?” Yes, my work computer is my primary tool. But in terms of enjoyment, the iPad wins hands down. 

Accountant’s iPad

“How do you use it?” you say. Here are few ways:

As you can see an accountant’s iPad is a powerful tool.

Convenience and Portability

Mostly, I use my iPad at home, seated on my couch. The portability of the device is its primary benefit. It’s large enough to read from and work on—and small enough to take wherever I go.

Your Favorite Device

So what’s your favorite tool and how do you use it?

Here are my favorite iPad apps.

Evernote for CPAs
Jul 16

Evernote for CPAs: Developing a Super Power

By Charles Hall | Technology

While there is no Evernote just for CPAs, it’s still a game-changer for beancounters. I’ve used this tool for about ten years and it is one of my favorites software packages.

So, what is Evernote?

What is Evernote?

Think of it as your digital library. 

Evernote is a cloud-based storage system that allows you to capture and file voice recordings, documents (including Word, Excel, PDFs), pictures, and videos. Once information is placed in Evernote, it is searchable in a Google-like fashion. Even hand-written notes are searchable.

What can CPAs do with this killer app?

Things CPAs Can Do with Evernote

Here are examples of what you can do with Evernote:

  • Create a personal digital library (e.g., use an Evernote digital notebook to store Journal of Accountancy articles, CPE material, and videos of class instruction)
  • Share individual files or notebooks (a compilation of files) with others (with the premium version you can collaborate with others, allowing them to change Excel or Word files)
  • Capture meeting conversations with your smartphone and save them to Evernote
  • Use your smartphone to take a picture of meeting notes on a whiteboard (remember manually written words are searchable)
  • Encrypt selected text within an Evernote note (password protected); it can’t be viewed without the password
  • Add selected web information to Evernote using an Evernote clipper 
  • Email any document directly to your private Evernote email address (which adds the emailed information to an Evernote folder)
  • Create a local Evernote notebook for sensitive information (the notebook resides on your local computer and does not synchronize to your Evernote cloud account)

So, what are the main components of an Evernote storage system?

The Skeletal Framework: Notes, Notebooks, and Tags 

The skeletal framework for Evernote has three elements: Notes, notebooks, and tags.

 

Evernote for CPAs

1. The primary element of Evernote is a note.

Think of a note as a blank piece of paper on which you can type. You can also attach other files to the note (e.g., an Excel spreadsheet or a picture taken with your cell phone or a voice message recorded with your cell phone). Once you create your notes, organize them in notebooks. 

2. Notes are placed in notebooks.

Think of a notebook as a three-ring binder.

For example, if I want to create a note about comprehensive income, I can do so. Then I can attach related files (e.g., PDFs) to the note. Next, I might add a note about other comprehensive income and another about reclassifications from other comprehensive income. The separate notes can, for example, be a text file, an Excel file, and a voice message.

All three notes can be added to a notebook titled Comprehensive Income.

Another way to organize your information is to tag each note.

3. You may also tag each note.

I could place the comprehensive income notes in a notebook titled accounting (a more generic category) and tag each note as comprehensive income. Then I can search and find all comprehensive income notes by using the comprehensive income tag. When I type tag:”comprehensive income” in the Evernote search bar, all notes tagged as such appear.

Use both folders and tags to help you more readily find information.

And how do you move information into Evernote?

Getting Information Into Evernote

Feed your Evernote account in multiple ways. How?

You can use Evernote apps or programs on your iPad, PC, and smartphone to add information to your account. 

I use the smartphone app to make and save pictures, notes, and voice messages to my Evernote account.

Evernote also provides you with a unique email address that can be used to feed information into your personal cloud. When you find something you want to store, you can email it to your Evernote account.

Also, you can use the Evernote clipper to capture information on the fly, such as when you are browsing the Internet. Just download the Clipper program from the Evernote website. 

Another neat way to get information into Evernote is with your scanner. I use a Fujitsu ScanSnap to feed scanned pages directly into Evernote.

Create Your Evernote Account

To create your account, go to the Evernote website and follow the directions. There is a free version if you want to try it out. The premium version is $7.99 per month. You can see a comparison of their plans here. I have not received any type of commission for this recommendation. 

See my article An Auditor’s Cell Phone.

fences
May 31

Organize Your Computer Desktop with Fences

By Charles Hall | Technology

In this post, I explain how you can use Fences software to organize your computer desktop.

Most accountants like organization, yet I often see total chaos on computer monitors.

A typical CPA’s screen looks like this.

Organize desktop

We’d be much better off if our desktops looked like this.

fences

Creating Order on Your Desktop

So how can you bring order to your desktop?

Use Fences. The cost is $9.99, but well worth the iconic bliss.

Once the Fences software is downloaded, you simply right-click and drag on your screen to create a new fence (see below). Above you see a fence titled “Programs.” You can arrange the icons in whatever order you wish. To add an icon to a fence, you simply drag it to the desired location.

Create Fence

Once you arrange your icons, they stay that way. When you reboot your computer the next morning, you’ll find your icons in the same order. 

Fences Software YouTube Video

Here’s a video that provides additional information about the Fences software:

My Experience with Fences Software

I’ve used Fences for about ten years and have found it useful. I recommend it.

Other Office Suggestions

For helpful ideas in setting up your physical office, click here.

1 2 3 5
>