Font size:

Mastering QuickBooks for Accountants Level 1

  1. Getting Started
    • Setting up your client’s data files
    • Moving around QuickBooks...EFFICIENTLY
  2. Everyday Client Transactions
    • Selling: invoices, sales receipts, payments, deposits, credit memos, statement charges, linking to 3rd party software, and customer statements
    • Buying: bills, bill payments, checks, bills vs. checks, and credit memos
    • Inventory: purchase orders, receiving items, adjusting inventory
    • Sales Taxes: setting up, adjusting, paying, and reporting sales taxes
    • Banking: reconciling bank accounts and locating discrepancies
  3. Special Transactions
    • Giving and receiving refunds
    • Voiding vs. deleting a check
    • Applying credit memos
  4. Tips & Tricks
    • Special "Window" tricks
    • Cleaning up lists (delete, hide and merge)
    • Sorting and customizing lists
    • "Collapsing" financial statements
    • Preparing P&L by month, or as a percent of income
  5. Financial Statements
    • Really understanding the QuickBooks financial statements
    • Setting up the chart of accounts
    • Changing/fixing the chart of accounts
    • Applying Cash vs. Accrual accounting in QuickBooks
    • Using general journal entries
    • Entering reversing journal entries
    • Creating and using subaccounts
    • Using the Company Snapshot
  6. Special Features for Accountants & Bookkeepers
    • Supporting and understanding the different versions of QuickBooks
    • Introduction to the Accountants version of QuickBooks
    • Using the toggle feature to simulate your client’s QuickBooks
    • QuickBooks journal entries…understand the unique quirks
    • Modifying your client’s chart of accounts
    • Creating customized financial statements using the Intuit Statement Writer
    • Combining your client’s financial statements
    • Using the working trial balance feature
  7. Payroll
    • Setting up your client’s payroll
    • Entering year-to-date payroll information
    • Setting up employees
    • Creating payroll items
    • Tracking and invoicing time
    • Processing paychecks
    • Modifying paychecks
    • Making tax deposits
    • Preparing tax forms
    • Summarizing payroll data in Excel
  8. Working with Reports
    • Adding, deleting, resizing, and reordering columns
    • Filtering and formatting reports
    • Saving reports and creating memorized report groups
  9. Advanced Features
    • Using petty cash
    • Setting up your client’s multi-user QuickBooks
    • Password protecting QuickBooks
    • Updating your clients QuickBooks
    • Working with Microsoft Word and Microsoft Excel
    • Closing the client’s books
    • Finding transactions FAST and other time saving features
    • Working with the Accountant's Copy feature
    • Protecting your client’s QuickBooks data
  10. Tips & Tricks
    • Keyboard shortcuts
    • Tailoring company preferences
    • Creating custom invoices and other forms
    • Adding logos and custom fields to forms
  11. Tricky Transactions
    • Using online banking
    • Handling bounced checks...easily
    • Entering customer down payments/deposits
    • Setting up automatic transactions (memorizing transactions)
    • Using credit cards
  12. Special Features for Accountants & Bookkeepers
    • Finding (and stopping) changes to client financial statements
    • Using the Employee Organizer: Adding employees, tracking raises & promotions, entering leaves of absence, and terminating employees
    • Running reports from the employee organizer
    • Using the Employee regulations guide
    • Multi-user QuickBooks in Enterprise Solutions: Assigning the administrator, creating roles, setting access levels, and adding new users
    • Working with the audit trail in Enterprise Solutions

Mastering QuickBooks for Accountants Level 2

  1. Customizing QuickBooks (make QuickBooks REALLY work for your client!)
    • Modifying important preferences
    • Customizing your client’s home page
    • Modifying the iconbar
    • Creating and using custom fields
    • Using account numbers
    • Using classes (for departments, locations, etc.)
  2. Sales Transactions, Tricks, and Workarounds
    • Setting up price levels
    • Sales orders/backorders
    • Batch invoicing
    • Invoicing for billable costs
    • Complex sales tax situations
    • Creating and using estimates
    • Progress invoicing
    • Finding and fixing typical errors in accounts receivable
    • 2 methods for handling customer deposits
    • Managing collections
    • Writing off bad debts
    • Customer under- and over-payments
    • Transferring customer credits
    • Working with multiple accounts receivable accounts
    • Entering retail sales
  3. Purchase Transactions, Tricks, and Workarounds
    • Purchasing and accounting for fixed assets
    • Entering company loans with the Loan Manager
    • Lines of credit
    • Typical bill payment errors
    • Preparing 1099’s at year-end
    • Employee and owner purchases
    • Prepaid expenses
    • Vendor deposits
    • Vendor refunds
    • Barter transactions
    • Voiding prior period checks
    • Using the cash flow projection tool
  4. Items & Inventory
    • Expenses vs. Items…which does your client use?
    • Inventory limitations
    • Inventory adjustments
    • Creating group items
    • Working with inventory assemblies
    • Units of measure
  5. Advanced Tricks
    • When should you start over with a new file?
    • The limitations of QuickBooks
    • Handling bank reconciliation errors
    • Use multiple currencies
    • Fixing errors in all areas of QuickBooks... there are so many we can't list them all!
  6. Completing Set Up
    • Completing setup: opening balances, completing lists, special accounts, opening balance equity, and payroll setup
    • 2 methods for entering transaction history
    • Checking the setup…is it right?
  7. Payroll Transactions, Tricks, and Workarounds
    • Correcting the setup of payroll items
    • Adding difficult payroll items
    • Using payroll effectively for job costing
    • Voiding/Reprinting paychecks
    • Special payroll deductions and payments
    • Preparing and adjusting W-2s
    • Employee loans
    • Setting up and tracking workers compensation insurance
    • Net to Gross paycheck calculations
  8. Mastering QuickBooks Reporting
    • Advanced report customization
    • Report types in QuickBooks…what you really need to know!
    • Importing and exporting reports
    • Using special fields to improve reports
    • Troubleshooting reports filters
    • Memorizing reports and creating report groups
    • Adding reports to the iconbar
    • Powerful techniques for modifying reports in Excel
    • Custom summary and transaction reports
    • Graphing QuickBooks data in Excel
    • Budgets and forecasts
    • Combining financial statements
    • Extending the QuickBooks database
    • Using advanced fields for reports (customer type, vendor type, job type, custom fields, and more)
  9. Unlocking the Power of QuickBooks
    • Deleting and archiving old transactions in your client’s file
    • Remote access (to access your company file through the internet)
    • Automating backups
    • Tricks to make QuickBooks run faster and more efficiently
    • Corrupt data files…how, why, and what to do
    • Verifying and rebuilding company files
  10. Importing and Exporting
    • Exchanging data between QuickBooks files
    • Importing and exporting lists
    • Importing and exporting customized forms
    • Using reports with multiple company files
    • Exchanging data between QuickBooks and other programs
    • Working with integrated applications
    • Using special Excel import feature
  11. Working with Clients
    • Common client mistakes and their fixes
    • Closing the books
    • Getting information to and from your client
    • Finding changes made to closed periods
    • Understanding and using retained earnings
    • Discovering quirks of QuickBooks journal entries
    • Using reversing journal entries
    • Understanding year-end procedures
    • Using the Audit Trail and other reports to find errors
    • Cash basis financial statements (what is QuickBooks doing?)
    • Special reports you’ll need as the accountant
    • What you REALLY need to know to become an advanced user!
    • Little known power features in all areas of QuickBooks
  12. More Features for Accountants
    • Correcting common mistakes with undeposited funds
    • Changing account types to correct client financial statements
    • Using the Client Data Review feature to review a client’s file
    • Converting your clients from Quicken
    • Using the Fixed Asset Manager: Setting up for a new client, adding assets, and calculating depreciation
Register Now
Essential Accountant's Bundle-On Demand Online course
  • Course ID:
    253479
  • Duration:
    1 day
  • Price:
    $650