– Privacy of Tax Return Data
Tax Return Data – Privacy Issues I read an interesting article the other day on the privacy of your tax return. Everyone, of course, needs to be aware that your tax-return information can reside in many places, whether you are doing just your own taxes or those...
New Lease Accounting Standard
ASU 2016-02 In February, 2016, the FASB released its new lease accounting standard, ASU 2016-02. This standard changes most elements of lease accounting for lessees and practically eliminates the use of those leases currently classified as operating leases as an...
3 Most Common Financial Reporting Errors
Three Most Common Reasons for Restating Financial Statements I just finished reading an interesting article in the Wall Street Journal on financial reporting. Did you know that over 650 companies filed financial revisions or restatements last year? In most cases, it...
Source Data in a Pivot Table
Source Data – Pivot Table When you close an Excel file, containing a pivot table, Excel can save the source data in the file or clear it from memory. If you go to Options>Pivot Table Options you will see that Excel by default saves the source data with the...
EOMONTH
Date Function EOMONTH EOMONTH displays the serial number of the last day of the specified month. You can use this to calculate maturity dates and due dates that occur on the last day of the month. In the example below, I have 1/2/2016 in cell A1. In another cell, I...
Ways to Sum Data with Errors
Excel Techniques to Sum Data with Errors There are times that you need to know the sum of numeric data even though there may be errors in it. The most common of these error values are #DIV/0!, #NUM!, #N/A and #VALUE!. #DIV/0! refers to a situation where Excel is...
Go To Special
The Special Uses of Go To Special in Excel Hidden on the Home ribbon in Microsoft Excel, within the Find & Select Button, is an Excel feature that has some very special and generally unknown uses for the CPA. The feature is Go To Special. It’s the fourth option...Steps to an Optimized Finance Function
Optimizing a Finance Function The following steps, once executed, will enhance the value of the finance function in any organization by ensuring that decision useful data is produced timely and accurately. Focus on internal controls to ensure that data is accurate...