The man who knows more about QuickBooks reporting and data extraction than anyone on the planet is has agreed to let us inside his brain and gain access to his experience. Don’t miss this!!!
Have you struggled to get that report out of QuickBooks that you can’t believe it doesn’t have? Do you want to learn how to get it done without a rocket science degree and a crew of programmers?
Learn about QuickBooks reporting, business analysis, and data extraction from the man whose companies have created thousands of custom report solutions, and who is the only outside accounting technology professional ever contracted by Intuit to work inside of the QuickBooks database as a data analyst and schema architect: Chuck Vigeant, M.Ed. Managing Partner of CLEARIFY® 
This is a once in a lifetime event, as Chuck will take you deep inside the QuickBooks data to help you understand:
- Why the report you think everybody should have – isn’t available.
- How the QuickBooks data is organized
- What QuickBooks can – and cannot do
- How to use QuickBooks to get around the limitations
- Reporting tools you can use to extract and get that report or analysis you want
- Solving problems for Sales, Job Costing, Inventory, and Financial Reporting
Chuck Vigeant, M.Ed. is widely acknowledged as the foremost authority on QuickBooks data and custom reporting solutions and is known as the ‘Grandfather of Crystal Reports for QuickBooks’. He partnered for three years with the company who created the first reporting interface to QuickBooks (QODBC by FLEXQuarters, which is licensed by Intuit for use in the Enterprise Solutions product), has lectured extensively for Intuit, trained its employees, and worked full time for them over a 2 ½ year period to reverse engineer the QuickBooks desktop data for cloud applications.
He will tell you things you never knew existed, and he will help you with advanced techniques to get the information you want, either from your own QuickBooks data – or your clients. Do not miss this opportunity to further your knowledge and efficiency.
This is a webinar event that will be spread out over three consecutive mornings, and will be recorded. Special reference materials will be made available to all attendees.
Chuck said, “Professionals in the Intuit Community have been pushing me to find a way to impart the knowledge I have gained over the last decade, but the high cost of travel and the current economy has prohibited me from making this available at an affordable rate. The webinar format, and advanced cloud based training tools allow us to provide this training to a larger audience, at an economical price.”
When: The webinar will contain a total of 12 hours of training and will be held on September 18,19,20 from 9am to 1pm central time each day.
Cost: Cost for attendance is $375.00 with an early bird special of $269 for those who purchase by August 15th, and $325.00 for those who purchase by August 31st.
Register: Here is the link to register.
CURRICULUM
Day One – How it Works
- How the QuickBooks data is organized
- Information that people want – but can’t get
- How QuickBooks stores the data
- Methods of data extraction – and how to access them:
- Intuit Models: SDK, IPP
- QODBC Driver
- Enterprise Custom Reporting
- QQube™
- What data is not available for any third party application
Day Two – Solving Problems 
Tools for reporting and analysis – usage, strengths, and limitations
- Xpanded Reports
- Web KPI
- Core Analytics
- Profit See
- QQube™
- Excel
- SAP Crystal Reports
- Access
- Other
Sales
- Handling Item Costs
- Best paying and most profitable customers
- Limitations of Price Levels and how to get around them
Job Costing
- Distinguishing between Customers and Jobs
- Using Estimates vs Budgets
- Handling Change Orders
- Project Managers, Estimators
- Splitting costs among Labor, Materials Contractors
- Methods of Handling WIP
- Payroll tips
Inventory
- Bill of Materials
- Lots and Serial Numbers
- Sites
- Consumption based forecasting
- Inventory Forecasting
- Inventory analysis
- Days out of stock
- Inventory turnover
Payroll
- Payroll registers the easy way
- Account reconciliation
- Commonly used export routines
Traditional 30-60-90 Day reporting for Open A/R and Open A/P
Day Three – Solving Advanced Problems
Financial
- Trial Balance Activity and Comparison
- Linked Transactions
- Budgets and Forecasts in the same report
- Handling 13 period reporting
- Working with 52/53 Tax Years
- Summary Amounts in Journal Entries
- Side by side Period Comparison of Statement of Cash Flows
- Cash Activity
Audit Trail
- Analyzing Dollar and Quantity Discrepancies
- Spotting Trends
Sales Tax
- How to find setup and posting errors
- How to view line details without individual drill down
Tying A/P and A/R transactions
- How to get around what QuickBooks doesn’t do
- Special tricks for tying sales to specific transaction non-inventory costs
- How QuickBooks links PO and Bills
- Discussion of linking between Estimates, Sales Orders, Invoices, Purchase Orders, Bills, Bill Payments
When: The webinar will contain a total of 12 hours of training and will be held on September 18,19,20 from 9am to 1pm central time each day.
Cost: Cost for attendance is $375.00 with an early bird special of $269 for those who purchase by August 15th, and $325.00 for those who purchase by August 31st.
Register: Here is the link to register.