Title Language  : 

Find a Course... Try for Free!

 

QuickBooks 2008 Advanced Tutorials

Course Content
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.

QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

«« Hide This
Getting Started
 Advanced QuickBooks Course Objectives (04:00)
 Tips & Shortcuts (05:47)
Networking Alternatives
 Working with an Accountant Copy (04:41)
 Remote Access & Third Party Solutions (05:21)
Invoices / Orders & Estimates
 Estimates / Change Orders / Sales Orders (05:32)
 Tracking Work in Progress (04:20)
 Tracking Progress with Enterprise Solutions (02:44)
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 Feedback
Tutorial Information / Pricing
Title: QuickBooks 2008 Advanced
Author: Lauri Matson
SKU: 33900
ISBN: 1-934743-82-8
Duration: 7 hrs / 88 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products