QuickBooks at tax time: Cleaning up your client's QuickBooks data

By Joe Woodard, for the Intuit Academy

Though QuickBooks is very easy to use, our clients often create numerous setup and data entry errors that we have to troubleshoot. We have to do most of this troubleshooting at the end of the client’s fiscal year, but if the client needs mid-year financial statements (e.g., to secure a loan), you may need to clean up the client’s data file at any time during the fiscal year.
 
The analyses in this book walk you through the most common types of setup and data entry errors, based on my over 10 years of experience working with clients who use QuickBooks. The analyses in this text focus mostly on cleaning up the General Ledger, to present financial statements and/or to prepare the client’s annual business income tax return. Consequently, the steps are not designed to comprehensively troubleshoot the data file. Examples of QuickBooks data outside the scope of this text include, but are not limited to: Price Levels, Billing Rates, Terms (correct AR/AP aging), correct auto-entry of memorized transactions, correct formatting of custom (memorized) reports created by the client, correct setup of loans in the Loan Manager, or timesheet entries/time reporting.
 
In this whitepaper you'll learn 10 easy steps to help you with that once-a-year cleanup of your client's records. Everything you need to know to help solve the most commonly encountered QuickBooks problems is described in "10 Steps to Cleaning Up Your Client's QuickBooks Data." Download the whitepaper today.

 

About the author
Joe Woodard is an Advanced Certified QuickBooks ProAdvisor and Intuit Solution Provider who has taught over 20,000 QuickBooks consultants across the country. Joe works with Intuit, state CPA societies, and Atlanta-area CPA firms to present advanced QuickBooks instruction to accounting professionals and software consultants. Joe has earned a unique relationship with Intuit as a trainer, consultant and author. Joe has built two successful accounting software consulting practices: the first in New Orleans, Louisiana and the second in Atlanta, Georgia – Creative Financial Software (CFS). In addition to consulting with small businesses, CFS provides advisory services to CPA firms and other QuickBooks ProAdvisors/Intuit Solution Providers across the country -- helping them to better service their clients who use Intuit products. Joe recently hosted the first annual Scaling New Heights QuickBooks conference in Atlanta.

See all articles by Joe Woodard.

Related articles:

 Reprinted with permission from Intuit

You may like these other stories...

In the old days, we used to tape down receipts from our travels and submit them to accounts payable. But that was before remote employees who may live in a different city from the home office. And of course, there's all...
In 2011, electrical services and technology provider Parsons Electric in Minneapolis, Minn., decided to take its accounting to the cloud. Monica Ross, the company's director of strategic projects, talked with AWEB about...
Event Date: July 24, 2014, 2 pm ET In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the...

Upcoming CPE Webinars

Jul 16
Hand off work to others with finesse and success. Kristen Rampe, CPA will share how to ensure delegated work is properly handled from start to finish in this content-rich one hour webinar.
Jul 17
This webcast will cover the preparation of the statement of cash flows and focus on accounting and disclosure policies for other important issues described below.
Jul 23
We can’t deny a great divide exists between the expectations and workplace needs of Baby Boomers and Millennials. To create thriving organizational performance, we need to shift the way in which we groom future leaders.
Jul 24
In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.