Username:
Password:
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)