Course Description
QuickBooks remains the top-selling entry-level accounting software solution in the United States. Yet, many accountants wrestle with generating financial statements and operational reports from QuickBooks data files. In this half-day seminar, you’ll learn how to use advanced techniques and tools to assist you in such issues as solving accrual-to-cash basis conversion issues, creating presentation-quality reports with Intuit Statement Writer, consolidating data from multiple data files, using third-party add-ins such as Adagio, getting industry-specific operational reports, extracting and analyzing data via ODBC queries and PivotTables, and optimizing the reporting process with dashboards.
Upon completing this course, participants will have a thorough understanding of how to prepare comprehensive and detailed financial statements and operational reports quickly and efficiently. Learn how to get the information and reports you need out of QuickBooks by attending this course.
“Great examples – many new ideas – will use in the future!” D.G., CPA NY
“The information presented was easy to follow and very helpful.” M.P. WY
Course Information
CPE Credit: Recommended for 4 hours of Accounting
Instructional delivery method: Group-live demo and discussion using color computer projection – NOT a hands-on course
Prerequisites: Experience with QuickBooks
Program level: Advanced
Advanced preparation: None
Designed for: Accountants who use or support clients who use QuickBooks
Who should attend: Accountants in public practice and in private industry seeking a deeper and more thorough knowledge of financial reporting and analysis with QuickBooks
Course Highlights
- Describe solutions to common financial and operating reporting issues including Solving Accrual-to-Cash Conversions, Working with Report Groups, Accessing Reports with a Single Mouse Click, Using the Journal as a Foundation for Customizing Reports, Preparing Consolidated Financial Statements, and Exporting Reports to Excel
- Define key terms associated with the Intuit Statement Writer such as Row Properties, Column Properties, and Cell Properties and describe how to create Excel-based financial statements using the Intuit Statement Writer
- Describe how to use technologies such as Open Database Connectivity and third-party reporting tools such as Adagio FX and ProfitCents to integrate with QuickBooks to solve more complex reporting problems
Dates & Locations
| Event Date | Location | Sponsor Name |
|---|---|---|
| 6/20/2012 | South Padre Island, TX | Texas Society of CPAs |
| 7/18/2012 | San Antonio, TX | Texas Society of CPAs |
| 8/8/2012 | Galveston, TX | Texas Society of CPAs |
| 8/16/2012 | Pelham, AL | Alabama Society of CPAs |
| 8/29/2012 | Oklahoma City, OK | Oklahoma Society of CPAs |


