News & Tech Tips

Quickbooks Tips – Exporting to Excel

When you export from Quickbooks note that you have an “Advanced” tab. There are three items which are not checked automatically which can help you in Excel. They are as follows:

  • Send Header to screen in Excel – The header does not automatically show on the screen. It is hidden unless you print. This option will show it in the document.
  • Auto Outline (Allows collapsing / Expanding) – With this option, the data will be automatically subtotaled in Excel. You can expand and collapse as you see fit based on the subtotals. (Example: if you have four cash accounts, but want to see one, you can collapse the tree for the cash account. But, if you want to see all F/A accounts, you can leave that tree as it is).

NOTE: If you collapse the accounts and want to copy and paste ONLY what you see without bringing all the data with it – you can. You can copy, click the cell you want to paste into or start the range with and click the clipboard. This will paste only what you see without bringing the data along with it. If you just copy and paste using Control C and Control V, you will bring all the data hidden in the subtotals along with what you actually are seeing on the screen. This also works for any rows or cells which are hidden. You will only bring over what you see, not what is in the hidden ranges.  Can’t see the clipboard? The shortcut to get to it is Control C and C again. This should show your clipboard. You have to click directly on the clipboard for this to work.

  • Auto Filtering (Allows Custom Data Filters): With this option, you will have filters across all columns and be able to select only what you want. For instance, if you have transactions from four cash accounts and only want to show two, you will have all four as an option on the filters. Just unclick “all” and select what you want. Then, you will only show transactions from the two accounts you want.

Workplace Fraud Threatens All Businesses

If you think that fraud won’t occur at your workplace, you’re probably not being realistic. Fraud can occur anywhere, and the instances and level of sophistication of fraud are a growing concern of business owners and managers.

Chrissie Powers, co-owner of P.D. Eye Forensics, advised Whalen clients and banking executives about ways to deter fraud and how to minimize exposure to it at a special workshop held by the firm on June 5. Her presentation also covered the warning signs of workplace fraud and how to respond to suspicions of fraud.

Whalen & Company recently began partnering with P.D. Eye Forensics to offer specialized forensic and valuation services to the firm’s business and individual clients. The firm has expertise in fraud detection and deterrence, business valuations, damages and lost profits, bankruptcy services, marital relations and litigation support.

“Although the economy is improving slightly, the economic downturn will continue to have its effect on fraud in the workplace,” she told workshop participants. “It’s really been a perfect storm for fraud.”

According to Powers, as businesses have reduced the number of their employees or cut hours, there is often a reduction in internal controls and fewer proactive fraud prevention measures in place. In addition, the increased financial strain on employees during the economic hardship contributes to the likelihood of fraud.

Finally, bombardments of bad financial news cause mounting feelings of helplessness, pessimism and isolation, which allows employees to rationalize previously unthinkable acts. “Given enough financial pressure, someone in your organization is going to commit fraud,” Powers warned. “The pressure of financial strain is so strong that they don’t think there are other options.”

Research shows that 66 percent of employees will steal if they see others do so without consequence; 21 percent of employees are honest and will never steal from employer, and 13 percent of employees will steal regardless.

“Business owners need to ensure that proper fraud prevention procedures are in place,” Powers emphasized. “You can’t stop it, but you can slow it down and make it harder for fraudsters.” See box for ways to deter fraud.

Small businesses often don’t have enough employees to put segregation of duties in place or have sufficient internal controls. “Just because you have an audit doesn’t mean that you’re protected,” she said. “If it is immaterial to a financial statement, an auditor is not likely to catch it. An auditor’s job is not to find fraud.”

Asset misappropriation, involving payroll fraud, fraudulent invoicing or billing, or skimming revenues, is the most frequent fraud method, accounting for about 87 percent of the incidents. About one-third of the occurrences are due to corruption, where an individual uses his or her influence to obtain a benefit or kickback.

Fraudulent statements are the least frequent, but generally result in more loss to a company.

If you believe fraud has been committed, Powers recommends not confronting the suspect initially or calling the police. “You don’t want to give the employee time to destroy evidence, and the police don’t have enough time to investigate,” she explained.

She advises business owners to contact their lawyer, accountant and insurance agent. Generally, this will lead to a competent investigator.

To review Powers’ complete fraud presentation, click here, or visit the firm’s website at www.whalencpa.com.

Partnership with P.D. Eye Forensics Benefits Clients

Whalen & Company, CPAs is partnering with P.D. Eye Forensics, LLC to offer specialized forensic and valuation services to the firm’s business and individual clients.

P.D. Eye is a Columbus-based forensic accounting firm owned by Chrissie Powers and Heather Deskins, who have more than 20 years of combined experience in the accounting field.

Their firm has expertise in fraud detection and deterrence, business valuations, damages and lost profits, bankruptcy services, marital relations and litigation support.

Both Powers and Deskins are Certified Public Accountants with specialized credentials as Certified Fraud Examiners, Certified in Financial Forensics and Certified Valuation Analysts. In addition, Deskins holds the Accredited in Business Valuation credential.

“This initiative is part of our firm’s ongoing efforts to bring additional service offerings to clients and add value to our relationship,” said Whalen Partner Richard Crabtree. “We believe this new development is good for our clients and for both firms.”