United States
QuickBooks 2008 Advanced Tutorials
Online Contents For This Course
We have made some of the video tutorials for QuickBooks 2008 Advanced freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Course Description
In this VTC QuickBooks 2008 Advanced tutorial, Lauri Matson a QuickBooks ProAdvisor, will go beyond the basics to teach advanced bookkeeping concepts, strategies, troubleshooting tips, shortcuts and more. Designed for the advanced user, the author uses easy to understand terminology coupled with valuable tips from over 30 years of business experience. Topics include unusual events and internal controls including reconciliations, assets & depreciation, taxes and reporting and even integration with other applications. Work files are included. This is a "must have" for any QuickBooks home or business office. To begin learning today, simply click on one of the QuickBooks 2008 Advanced lessons.
*While it is not necessary, it is recommended that users first take the VTC QuickBooks 2008 introduction course, and have a strong background in the Microsoft Office Suite (mainly Access, Excel and Word).
**This course uses QuickBooks 2008 Accountant’s Edition with Point of Sale and Enterprise Editions used when they are needed.
***Most techniques used in these lessons are applicable to QuickBooks 2006-2008 versions.
Choose your media type:
|
Getting Started
|
|||
| Advanced QuickBooks Course Objectives | (04:00) | T | |
| Tips & Shortcuts | (05:47) | T | |
|
Networking Alternatives
|
|||
| Working with an Accountant Copy | (04:41) | T | |
| Remote Access & Third Party Solutions | (05:21) | T | |
|
Invoices / Orders & Estimates
|
|||
| Estimates / Change Orders / Sales Orders | (05:32) | T | |
| Tracking Work in Progress | (04:20) | T | |
| Tracking Progress with Enterprise Solutions | (02:44) | T | |
|
Job Costing
|
|||
| Setting Up Jobs | (07:00) | ||
| Purchase Orders / Costs / Profitability | (03:47) | ||
| Reimbursable Expenses (Time / Mileage) | (05:40) | ||
|
Complex Purchase Transactions
|
|||
| Prepaid Expenses | (04:05) | ||
| Trading Balances Between Customers & Vendors | (04:47) | ||
| Voiding Prior Period Checks | (04:09) | ||
|
Inventory Control
|
|||
| Complexities of Inventory | (06:04) | ||
| Groupings & Assemblies | (04:41) | ||
| Using Point of Sale | (04:13) | ||
| Units of Measurement | (03:10) | ||
|
Statement of Cash Flow
|
|||
| Cash Flow Analysis | (04:08) | ||
| Generate a Cash Flow Statement | (04:14) | ||
|
Credit Card Transactions
|
|||
| Security | (03:18) | ||
| Customer Payments / Merchant Services | (04:08) | ||
| Vendor Payments | (02:54) | ||
|
Bank Reconciliations & Online Banking
|
|||
| Common Problems | (03:42) | ||
| Handling Bad Checks & NSF Fees | (03:19) | ||
| Electronic Statements | (04:13) | ||
| Online Errors | (01:42) | ||
|
Liability Reconciliations
|
|||
| Entering New Debt | (04:03) | ||
| Tracking Loan Balances | (03:32) | ||
|
Understanding Equity Accounts
|
|||
| Draws vs. Investments: How Equity Works | (04:53) | ||
| Closing the Equity Accounts | (05:34) | ||
|
Working with Assets
|
|||
| Depreciation & Amortization | (03:32) | ||
| Setting Up Accounts Depreciation Accounts | (03:51) | ||
| The Asset List | (05:03) | ||
| Purchasing Fixed Assets | (05:25) | ||
|
Payroll
|
|||
| Wages & Liabilities | (05:49) | ||
| Other Additions & Deductions | (06:26) | ||
| Payroll Checkup | (06:02) | ||
|
Advanced Payroll Items
|
|||
| Setup for Workers Compensation | (04:25) | ||
| Workers Compensation Payments | (06:27) | ||
| Earned Income Credit | (05:30) | ||
| Tracking Commissions | (05:45) | ||
|
Forecasts & Budgets
|
|||
| Significance of Forecasts & Budgets | (05:38) | ||
| Create a Budget | (05:25) | ||
| The Business Plan Tool | (05:38) | ||
| What If? Analysis in Microsoft Excel | (03:09) | ||
|
Internal Controls
|
|||
| Accuracy & Fraud Protection | (07:29) | ||
| Proper Documentation & Retention | (05:33) | ||
| User Access & Licensing | (03:44) | ||
|
Security
|
|||
| Permissions & Users | (04:38) | ||
| Year End Close | (04:32) | ||
|
Outgrowing Your Company File
|
|||
| Solutions to Large Files | (05:32) | ||
| Data Preparation | (05:58) | ||
|
Condensing & Creating a New File
|
|||
| Creating a New File | (04:44) | ||
| Pros & Cons of a New File | (03:45) | ||
| Condensing Your Data | (05:00) | ||
| Pros & Cons of Condensing | (04:03) | ||
|
Upgrading
|
|||
| Advanced Industry Solutions | (03:57) | ||
| Enterprise Edition | (04:44) | ||
| Point of Sale | (04:05) | ||
|
Journal Entries
|
|||
| Automatic & Manual Entries | (03:31) | ||
| Issues to be Aware of | (04:11) | ||
| General Ledger Report | (03:46) | ||
|
Audit Trails
|
|||
| Internal Controls | (05:01) | ||
| The Audit Trail Report | (06:47) | ||
|
Integration
|
|||
| Collection Letters | (05:49) | ||
| Pivot Tables | (05:24) | ||
| Mailings | (05:12) | ||
|
Verifying & Repairing Data
|
|||
| Troubleshooting | (04:18) | ||
| Verify & Rebuild | (07:03) | ||
| When the Balance Sheet is Out of Balance | (03:27) | ||
| What if Rebuilding Does Not Work | (04:31) | ||
|
Backups
|
|||
| Backups vs. Portable Files | (05:56) | ||
| Backup Strategy | (05:59) | ||
| The Accountant's Copy | (04:02) | ||
|
Common Errors
|
|||
| The Most Common Errors | (02:55) | ||
| Most Common Errors Continued | (03:30) | ||
|
Reporting
|
|||
| Advanced Reporting | (04:03) | ||
| Modifying & Saving Your Reports | (05:43) | ||
| Memorized Transactions | (04:20) | ||
| The Template Gallery | (04:12) | ||
|
Searching & Enhancements
|
|||
| Using the Find Function | (04:00) | ||
| Understanding the Add On Tools | (04:13) | ||
|
Connecting to Microsoft Access
|
|||
| Installing an ODBC Connector to Access | (03:45) | ||
| Using Access with QuickBooks | (05:23) | ||
| Integrating Applications | (03:08) | ||
|
Conclusion
|
|||
| Quick Tips | (03:04) | ||
| Wrap Up | (02:12) | ||
| About the Author | (02:03) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | QuickBooks 2008 Advanced |
| Author: | Lauri Matson |
| SKU: | 33900 |
| ISBN: | 1-934743-82-8 |
| Release Date: | 2008-08-28 |
| Duration: | 7 hrs / 88 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 650 courses, 70,000 video tutorials (14,250+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More