Cleanup Course Outline

Lesson #1 - Managing Cleanup Engagements

  • Diagnosing the books
  • Setting goals
  • Creating a checklist
  • Managing expectations
  • Ending the engagement

Lesson #2 - Cleanup Best Practices

  • Where to start
  • Company settings
  • Managing lists
  • Deleting versus voiding
  • Importing data
  • Linked transactions

Lesson #3 - Cleanup Tools

  • QBOA tools
  • Report tools
  • Reclassify
  • Custom reporting
  • Audit log
  • Search
  • Trial balance

Lesson #4 - Reconciling Accounts

  • Basics of reconciliations
  • Undo
  • Other items
  • Fixing reconciliations

Lesson #5 - Fixing Transactions

  • Duplicate transactions
  • $0 transactions
  • Clearing accounts
  • Cleanup account
  • Product/service mapping issues

Lesson #6 - Complicated Accounts

  • Clearing accounts
  • Reclassify revenue
  • Undeposited funds
  • A/R & A/P
  • Tax accounts (payroll and sales tax)

** Bonus Course** Excel Skills for Accountants - Top 10 Excel Tools to Increase Productivity

  • Layout tips
  • Formulas
  • Time-savers
  • Pivot tables

**Bonus Course** Tying Tax Returns to the Financials

  • Tax return layouts
  • Difference between the tax forms
  • Matching balance sheet accounts
  • Matching income statement accounts
  • Difference between tax and financials