Self-paced training
Nonprofit Course Bundle
What's includedIncluded
What you'll learnTopics
FAQ

5 Full courses – over 33 hours of practical knowledge, shortcuts, tips, and tricks that you can apply immediately!

You get all the content covered in Mastering QuickBooks for Nonprofits, Mastering QuickBooks Level 2, Mastering Accounting Basics, Mastering Payroll, and Mastering Word & Excel for QuickBooks Desktop. To see a detailed list of what’s covered in each course, see the What you’ll learn tab to the right.

Includes a 241-page PDF manual

We recommend you begin with the basics covered in Mastering QuickBooks for Nonprofits. This course is the foundation that you’ll build on with Mastering Accounting Basics and Mastering QuickBooks Level 2. And because it’s so important to your foundation, you’ll receive a work manual, so you can follow along and take notes as you go.

Free updates – for life!

QuickBooks Desktop changes every year. But you don’t have to worry about outdated training. Unlike other software training that eventually becomes outdated when the software changes, your purchase includes all the updates we make in the future. Rest assured knowing you have the latest and greatest content…at no additional cost.

Full High Definition video

The courses are all filmed in crystal clear HD, so you don’t miss any details. Expand the viewing area to full screen or watch it in a smaller format…either way, you can easily follow the instructions and see every detail.

Access to all the courses: Anywhere. Anytime.

You can view the courses as many times as you want from any device connected to the internet.

Everything you need to know to master QuickBooks “A to Z,” and understand the “behind the scenes” accounting basics

Whether you love bookkeeping or you’re a “reluctant” bookkeeper, being QuickBooks Confident means coming to work each day with the confidence that you know what to do, how to do it, and most importantly, WHY you need to do it! All this with the confidence that you’re saving time applying the tips, tricks, and shortcuts you discover.

Mastering QuickBooks for Nonprofits
The Basics
Using the nonprofit menu
Understanding the financial statements of a nonprofit
The Unified Chart of Accounts (UCOA)
Nonprofit forms and letters
Setting up accounts for different types of nonprofits
Setting up Classes and Programs
Entering grants
What's the Form 990?
Tracking Income
Setting up members and donors
Recording individual donations
Recording lump sum donations
Tracking and receiving grants
Receiving general contributions
Making deposits
Tracking Expenses
Setting up vendors and employees
Entering and paying bills
Writing checks
Using an outside payroll service
Paying employees
Paying payroll taxes
Tracking volunteer time
Classifying expenses and payroll by program
Allocating expenses by percentage to programs
Standard Reports for Nonprofits
Basic Profit & Loss Statement
Profit & Loss Statement by month and by program
Budget vs. actual reports
Year-end financial statements for auditors, directors and accountant (for 990 tax form)
Customizing QuickBooks
Adding, deleting, resizing, and reordering columns on reports
Filtering and formatting reports
Saving reports and creating memorized report groups
Customizing forms
Creating and using custom fields
Exporting reports to Excel
Advanced Budgeting
Entering and reviewing budgets
Copying prior years' budgets
Modifying budgets using Excel
Importing an Excel budget
Tracking budgets by program
Entering budgets by grant
Preparing budget reports for a Board of Directors
Generating budget vs. actual reports
Pledges
Entering pledges
Reports of outstanding pledges
Sending reminder letters for overdue pledges
Membership Organizations
Invoicing for membership organizations
Setting up members
Reports of dues past-due
Sending renewals
In-Kind Contributions
Understanding In-kind Contributions
Accounting for In-kind Contributions
Matching Grants
Setting up Matching Grants
Recording donations and pledges for Matching Grants
Reports for Matching Grants
Capital Campaigns
Creating a capital campaign
Setting up accounts, classes, and budgets for a capital campaign
Entering pledges, individual contributions, and lump-sum contributions
Recording year-end adjustments
Reports for capital campaigns
Special Events
Creating a special event
Setting up accounts, items, and budgets for a special event
Accounting for sponsorship activities
Entering ticket sales
Tracking in-kind contributions, lump-sum deposits, and expenses
Reports for special events
Direct Mail Pieces (Fundraising Letters)
Creating fundraising letters
Creating accounts and items for letters
Two methods for entering income from letters
Accounting for expenses
Reports for fundraising letters
Fiscal Sponsorships
Creating accounts, items, and customers
Two methods for entering income
Accounting for payments
Reports for fiscal sponsorships
Tracking Donors/Volunteers
Entering information for donors and volunteers
Sending letters to donors
Year-end reports for donors
Tracking time for volunteers
Houses of Worship
Running the Profit & Loss Statement by committee
Creating special accounts and budgets
Reports for Houses of Worship
Tracking Funds
Creating classes and accounts for funds
Entering transactions
Recording beginning fund balances
Reviewing fund balances
Advanced Features
Using QuickBooks on a network (multi-user)
Password protecting QuickBooks
Updating QuickBooks
Protecting your QuickBooks data
Payroll
Setting up payroll
Entering employees
Setting up payroll items
Tracking and invoicing time
Processing paychecks
Modifying paychecks
Making tax deposits
Preparing tax forms
Tricky Transactions
Using online banking
Handling bounced checks...easily
Entering customer down payments/deposits
Setting up automatic transactions (memorizing transactions)
Using credit cards
Inventory
Entering purchase orders
Receiving inventory
Adjusting inventory quantities
Mastering QuickBooks Level 2
Customizing QuickBooks
Modifying important preferences
Customizing your home page
Modifying the Icon Bar
Creating and using custom fields
Using account numbers
Using classes (for departments, locations, etc.)
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
Two 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
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 1099s 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
Items & Inventory
Expenses vs. Items: which do you use?
Inventory limitations
Inventory adjustments
Creating group items
Working with inventory assemblies
Units of measure
Advanced Tricks
When should you start over with a new file?
The limitations of QuickBooks
Handling bank reconciliation errors
Using multiple currencies
Fixing errors in all areas of QuickBooks
Completing Set Up
Account setup: opening balances, special accounts, and opening balance equity
Completing setup: completing lists, setting up payroll
Two methods for entering transaction history
Checking the setup
Payroll Transactions, Tricks, and Workarounds
Correcting the setup of payroll items
Adding difficult payroll items
Using payroll effectively for job costing
Voiding/Reprinting paychecks
Handling special payroll deductions and payments
Preparing and adjusting W-2s
Employee loans
Setting up and tracking workers' compensation insurance
Net to Gross paycheck calculations
Mastering QuickBooks Reporting
Advanced report customization
Report types in QuickBooks
Importing and exporting reports
Using special fields to improve reports
Troubleshooting reports filters
Memorizing reports and creating report groups
Adding reports to the Icon Bar
Powerful techniques for modifying reports in Excel
Generating 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, custom fields, and more!)
Unlocking the Power of QuickBooks
Deleting and archiving old transactions in your file
Remote access (access your company file through the internet)
Automating backups
Tricks to make QuickBooks run faster and more efficiently
Corrupt data files: how & why it happens, and what to do
Verify and rebuild company files
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
Secrets Your Accountant Should Know
Common client mistakes and their fixes
Closing the books
Getting information to and from your accountant
Finding changes made to closed periods
Understanding and using retained earnings
Discovering the quirks of QuickBooks journal entries
Using reversing journal entries
Year-end procedures
Using the Audit Trail and other reports to find errors
Cash basis financial statements
Special reports for your accountant
What you REALLY need to know to become an advanced user!
Little known power features in all areas of QuickBooks
Mastering Accounting Basics
Accounting Basics
Defining accounting from the small business' perspective
Why do you need accounting?
Financial statements: what are they?
What is an account?
Double entry accounting and how it applies to QuickBooks
Debits and Credits: The essence of accounting
Accounting Principles
Introduction to Accounting Principles
The Reporting Principle
The Reliability Principle
The Comparability Principle
The Cost Principle
The Revenue Principle
The Matching Principle
Applying the principles
Accounting Basics in QuickBooks
The Balance Sheet and Profit & Loss Statement
Working with account types
Setting up the Chart of Accounts
Management reporting vs. financial reporting
Working with subaccounts
Techniques to review account detail
Understanding debits/credits in common QuickBooks transactions
Reviewing Numbers for Accuracy
Basic review techniques
Using QuickZoom as an investigative tool
Reconciling accounts to external documentation
Verifying numbers on key reports
Checking Accounts Receivable, Accounts Payable, and Inventory balances
Analyzing and Interpreting Data
Basic financial interpretations
Analyzing business trends
Interpreting variable expenses
Understanding and using key financial ratios
The Accounting Cycle
What is the accounting cycle, and why is it important?
Daily accounting tasks
Weekly accounting tasks
Pay period accounting tasks
Monthly accounting tasks
Quarterly accounting tasks
Annual accounting tasks
Closing the books
Restricting access to closed periods
Working with Your Accountant
Speaking the same language as your accountant!
Creating a client/accountant agreement
Methods for getting information to your accountant
Accountant's Copy Process
Special reports for your accountant
More Accounting
Using account numbers
Setting up classes to segment financial statements
Budgeting and planning in QuickBooks
Cash vs. Accrual accounting
Understanding and using Retained Earnings
Year-end closing entries
Finding prior year changes
Valuable Resources Included with the Course:
Glossary of Accounting Terms
QuickBooks Keyboard Shortcuts List
Summary of Account Types (and the financial statements they flow to)
A Debits and Credits "Cheat Sheet"
Financial Ratios List (and how they're calculated)
Sample Tax Calendar
List of Record-Keeping Requirements (as recommended by The IRS)
Periodic Activities Checklist (avoid overlooking important tasks!)
Year-end Closing Checklist
Step-by-Step Summary of Exchanging Data with your Accountant
Help Guide for Creating a Client/Accoutnant Agreement (and assigning responsibilities)
Backup Log (to schedule and monitor timely backups)
Mastering QuickBooks Payroll
Payroll...Before You Begin
The top 10 payroll mistakes to avoid
Know your payroll risks and responsibilities
Standard forms for new employees
Contractors vs. employees (when to use each)
Set Up
Information you need to get started
Using the Payroll Setup Wizard
Setting up employees
Adding compensation types (hourly, salary, bonus, etc.)
Setting up employee benefits (insurance, reimbursements, etc.)
Adding retirement benefits like 401(k) plans
Adding PTO (sick & vacation time)
Setting up federal taxes (Income tax, FICA, etc.)
Setting up the right taxes for your state
Reviewing your payroll set up
Entering payroll history
Customizing payroll
Creating payroll schedules
Understanding and adding payroll items
Creating unique and special payroll items
Running Payroll
Entering employee time
Running employee productivity reports
Preparing employee paychecks
Printing & modifying paychecks
Printing employee paystubs
Running payroll reports
Exporting payroll data to Microsoft Excel
Taxes & Tax Forms
Making tax deposits
Paying other payroll liabilities
Using E-file/E-pay to file forms and make payments electronically
Correcting & adjusting payroll liabilities
Preparing & filing your quarterly & annual tax returns (federal and state)
Special Transactions
Entering "net to gross" paychecks
Running unscheduled & termination paychecks
Handling unexpected changes during the year
Voiding paychecks
Tracking & paying employee commissions
Custom liability payments
Depositing tax refunds
Advanced Transactions
Handling unique expenses (e.g. employee & employer contributions to insurance)
Mapping payroll items to get meaningful financial statements
Job costing payroll
Tracking employee loans
Handling wage garnishments
Paycheck issues
Tracking payroll by "class"
Mastering Word & Excel
Excel: The Basics
What are spreadsheets and workbooks?
Moving around in Excel
Understanding the Excel interface
Getting Help
Tips for exporting to QuickBooks
Working with Excel & QuickBooks Together
Sending reports to a new workbook
Transferring reports to an existing workbook
Moving and naming worksheets
Aligning, deleting, and inserting worksheets
Changing report headings
Selecting, moving, merging, and editing cells
Deleting columns and rows
Formatting in Excel
Creating the look you want 
Adding borders 
Number styles: Accounting vs. Currency
Using the Format Painter
Adding tab colors and comments
Freezing Panes (column and row heading show while scrolling)
Understanding date formats
Calculations and Formulas in Excel
Relative vs. absolute references
Creating and copying formulas 
Array formulas
3-D formulas
Using the formula Error Checking feature
Summarizing and Analyzing Data in Excel
How to analyze numbers in Excel
Using the Count, Average, and Mean functions
Collapsing Excel reports (to hide and show relevant data)
Using the Auto-Outline feature
Filtering reports in Excel
Grouping and sorting data
Pivot Tables
Using the What-If Analysis tool
Real World Applications for Excel
Creating an amortization schedule
Building an expense reimbursement form 
Speeding up bank reconciliations 
Creating graphs of QuickBooks data (in Excel!)
Importing lists from Excel into QuickBooks
Importing IIF files into QuickBooks 
Customizing Excel
Creating personalized toolbars 
Building your own menus
Changing the screen layout
Password protecting Excel files 
Setting the default format 
Shortcuts and Saving Time in Excel
Creating macros to automate Excel steps
Mouse Shortcuts
Keyboard Shortcuts
Printing tips and tricks
Word: The Basics
What are files and templates?
Moving around in Word
Understanding the Word interface
Using different layout views
Getting Help 
Working with Word and QuickBooks Together
Using the QuickBooks to Word link 
Creating a letter from scratch
Converting an existing Word document 
Modifying Word letter templates
Creating invoice cover letters 
Fixing “missing information” errors 
Word Techniques
Working with Word documents 
Understanding document compatibility issues 
Setting the Auto Recover options
Entering, selecting, dragging, dropping, cutting, copying, pasting, and deleting in Word 
Using the built-in spelling and grammar checkers
Formatting in Word
Understanding and using the Home tab
Customizing fonts 
Highlighting fonts 
Using the format painter feature 
Creating and using bulleted and numbered lists 
Setting tabs, tab stops, and indents 
Creating and using styles and style sheets 
Adjusting margins 
Setting page breaks 
Printing word documents
Working with Document Objects in Word
Adding a company logo to letters
Re-sizing and re-positioning objects
Creating watermarks 
Using Word symbols 
Using and modifying clip art and other pictures 
Working with tables 
Importing tables from Excel
Inserting files
Adding “Hyperlinks” to documents, web pages, and spreadsheets 
Customizing Word
Creating smart tags to use Word information in other programs
Creating personalized toolbars
Building your own menus 
Changing the screen layout 
Password protecting files 
Setting the default format 
Tracking changes in Word 
Shortcuts and Saving Time
Using keyboard shortcuts to find information
Other keyboard shortcuts 
Auto-correcting Word documents
Using different languages 
Creating and using Word templates
How does the OnDemand class work?
After you place your order, you receive log-in credentials for the course via email. Follow the link in the email, type your username and password, and start learning!
Do you offer a money-back guarantee on your OnDemand training?
Absolutely! If you are not completely satisfied with the training, send an email to office@realworldtraining.com, and you will receive a full refund (minus a processing fee of $14). We stand behind our classes. No hassle. No question.
Are the self-paced courses hands-on?
If you have QuickBooks installed on your computer, you can pause the class and switch to QuickBooks to practice hands-on.
Do I need QuickBooks on my computer?
No. You can view the training on any device with an internet connection. Anytime, anywhere.

No risk, money-back guarantee

We know you'll love our QuickBooks training and we stand behind it 100%. See refund and cancellation details.
Change QuickBooks version
Chat with us

QuickBooks training near your location

United States

Refund and cancellation policies

Live classes To cancel your seat in a live class, please notify us at office@realworldtraining.com before the first day of your class. You'll receive a refund (less a $45 processing fee). If you attend class and it doesn't meet your expectations, just let your instructor know by the end of the first day of class. Then, you'll receive a refund (less a $45 processing fee). Please note... we do not provide refunds if you don’t attend class. We will, however, keep your credit so that you may attend another class in the future.

Self-paced courses If you're not satisfied for any reason, please send an email to office@realworldtraining.com within 30 days of purchase and you’ll receive a refund (less a $45 processing fee).

VIP Membership To cancel your membership, please send an email to office@realworldtraining.com within 30 days of purchase and you'll receive a refund (less a $45 processing fee). After 30 days, we'll stop your monthly subscription for live services (these include weekly live classes, Q&A sessions, and "ask the instructor") but you can keep any 4 self-paced courses of your choice. If you've been a member for 3 months, you can keep your access to the entire learning library.