QuickBooks Online Bookkeeping for VAs: The Client Workflow Course

Course Overview

Core promise: You will learn the QuickBooks Online (QBO) workflows a client actually expects their bookkeeper to handle. You are not just learning where the buttons are. The whole course follows one simple progression:

Invoice it → Track it → Collect it → Categorize it → Reconcile it → Report it

Who this course is for: Beginner bookkeepers, Virtual Assistants adding bookkeeping to their services, and small business owners who want to understand their own books.

Course Learning Objectives

By the end of this course, you will be able to:

1. Set up and navigate a client's QBO file, including customers, products and services, the chart of accounts, and bank connections.
2. Run the full invoicing cycle: create, send, receive payment, apply credits and refunds, and collect on overdue balances.
3. Categorize bank feed transactions accurately, including splits, transfers, and owner activity, and automate routine ones with bank rules.
4. Reconcile bank and credit card accounts and troubleshoot discrepancies.
5. Execute a repeatable month-end close.
6. Produce and deliver a professional month-end reporting package.
7. Handle realistic client requests with confidence.

Recommended Prerequisites

• Basic computer and spreadsheet skills (sorting, simple formulas, working with CSV files).
• Comfort with basic arithmetic.
• No accounting background is required. The theory is taught in Module 1.
• A reliable computer and internet connection.

Tools, Software and Templates

• QuickBooks Online Accountant (QBOA): for managing multiple client files. It is free for accounting professionals.
• QBO sample company or free trial: your practice environment. Never practice in a live client file.
• Xero (optional): used for "Tool Translation" comparisons. A demo company is available.
• Excel or Google Sheets: for trackers, checklists, and import files.
• Google Drive or other cloud storage: for client folders and report delivery.
• A password manager: an essential habit for any bookkeeper.

Templates you will receive (built up module by module): Client Onboarding Checklist, Customer Import Sheet, Chart of Accounts Mapping Sheet, Collections Tracker, Month-End Close Checklist, Reconciliation Discrepancy Log, and Client Report Cover Note — all available any time on the Templates & Resources page.

Course Map

• Module 1: QBO Foundations (Setup)
• Module 2: Invoicing and A/R (Invoice it, Track it, Collect it)
• Module 3: Transaction Categorization (Categorize it)
• Module 4: Reconciliation (Reconcile it)
• Module 5: Month-End Close (Close it)
• Module 6: Accounts Payable & Bills (Bill it)
• Module 7: Client Reporting (Report it)
• Module 8: Real Client Scenarios (Everything combined)

How Each Lesson Works

• Consistent lesson format: Objectives, Theory, Walkthrough, Example, Best Practices and Pitfalls.
• One running case client: Bright Path Cleaning Co. appears in every module, so you watch one set of books grow from setup to month-end package.
• Tool Translation callouts: each lesson shows the Xero equivalent and a Google Sheets or Excel companion.
• A note on the interface: QBO updates its menus and layout from time to time, and labels vary slightly by plan and region. Learn the function first. If something has moved, use the search bar in QBO to find it.

---

Module 1: QBO Foundations

Module goal: You will be able to open a client's QBO file, understand what you are looking at, and set up the four building blocks that everything else depends on: customers, products and services, the chart of accounts, and bank accounts.

Running case introduced: Bright Path Cleaning Co. is a small residential and office cleaning business run by owner Dana Reyes. Dana invoices clients, pays a few part-time cleaners, and has been keeping records in a spreadsheet. She has just hired you.

Lesson 1.1: The QBO Dashboard

Learning Objectives

• Explain what QBO is and how a client's "company file" is organized.
• Read each dashboard widget and know what it does and does not tell you.
• Perform a 5-minute "client health check" from the dashboard.

Content and Theory

QuickBooks Online is cloud-based accounting software. Every client has their own company file, which holds all their transactions, lists, and settings. As a bookkeeper you will usually reach it through QuickBooks Online Accountant, where you see all your clients in one list and open each file from there.

The Dashboard (Home) is a summary screen. Typical widgets include:

• Bank accounts: shows the bank balance (what the bank says) next to the QuickBooks balance (what the books say), plus a count of transactions waiting for review.
• Profit and Loss: a quick income-versus-expense snapshot for a selected period.
• Expenses: spending by category.
• Invoices: unpaid, overdue, and recently paid totals.
• Sales: income trend over time.

The key idea: The dashboard is a symptom checker, not a source of truth. Its numbers are only as accurate as the categorization and reconciliation behind them. A pretty dashboard on unreviewed books can be very wrong.

Step-by-Step Walkthrough: The 5-Minute Health Check

1. Open the client file from QBOA.
2. Bank widget: Compare the bank balance and the QuickBooks balance. A big gap, or a large "to review" count, means transactions are waiting.
3. Invoices widget: Note the overdue amount. Anything large gets flagged for the collections work in Module 2.
4. P&L widget: Change the date range to "Last month" and scan for anything odd, such as zero income for an active business or a huge "Uncategorized" figure.
5. Expenses widget: Look for vague categories like "Miscellaneous" or "Uncategorized Expense" near the top.
6. Write 3 to 5 bullet notes in your Client Onboarding Checklist template.

Real-World Example

Bright Path's dashboard shows a bank balance of $8,420 but a QuickBooks balance of $3,150, with 63 transactions to review.

Solution breakdown: The $5,270 gap is very likely unrecorded activity, meaning bank transactions that have not yet been accepted into the books. The 63 pending items are your Module 3 workload. You do not "fix" the number. You process the bank feed and then reconcile.

Best Practices and Common Pitfalls

• ✅ Do a dashboard check at the start of every work session. It takes five minutes and prevents surprises.
• ✅ Note the accounting basis (cash or accrual) shown on the P&L widget. It changes the numbers (see Lesson 1.6).
• ⚠️ Never quote dashboard figures to a client as "final" before reconciliation.
• ⚠️ A low "to review" count does not mean the books are right. Transactions can be reviewed and still be miscategorized.

Tool Translation: Xero's Dashboard has similar bank, invoice, and cash flow panels. Xero calls the pending-transaction count "items to reconcile."

Sheets companion: Keep a "Client Health Log" tab recording the dashboard numbers and the date you checked them.

Lesson 1.2: Customers

Learning Objectives

• Explain the customer list's role in Accounts Receivable.
• Create, edit, deactivate, and import customers correctly.
• Apply naming standards that prevent duplicates.

Content and Theory

Every invoice in QBO is tied to a customer. The customer list therefore forms the A/R subledger, the detail behind the single Accounts Receivable balance on the balance sheet. If the customer list is messy, A/R reporting and collections are messy.

Key customer fields:

• Display name: how the customer appears in lists and reports. This is the most important field to standardize.
• Company or contact name, email, phone, and addresses.
• Payment terms: for example Net 15 or Due on receipt. Setting a default here saves time later.
• Preferred delivery method and payment method.
• Sub-customers or projects: a hierarchy for clients with multiple locations or jobs.

Names must be unique across customers, vendors, and employees in QBO. If a client is both a customer and a vendor, you need a distinguishing suffix, such as "Acme Supplies (Vendor)".

Step-by-Step Walkthrough

Add a customer

1. Go to Sales, then Customers, then New customer (or use + New, then Customer).
2. Enter the display name following your naming standard.
3. Add the email and billing address.
4. Under Payments, set the default terms.
5. Save.

Import customers from a spreadsheet

1. Prepare a CSV using QBO's import template (use the Customer Import Sheet template).
2. Go to Settings (gear icon), then Import data, then Customers.
3. Upload the file, map the columns, review, and import.
4. Spot-check ten records afterward.

Clean up a duplicate

1. Identify the primary record (the one with the most history).
2. Rename the duplicate to exactly match the primary. QBO will offer to merge them.
3. Confirm. Merges cannot be undone, so take a screenshot of both records first.

Deactivate instead of delete: Use Make inactive for customers who are no longer active. Records with history should never be deleted.

Real-World Example

Dana's old spreadsheet lists "Maria Santos," "M. Santos," and "Santos, Maria." Two of them have open invoices.

Solution breakdown: Adopt a naming standard ("Last Name, First Name" for individuals and the company name for businesses). Choose the record with the most history as the primary. Rename the others to match and merge them. Then confirm the A/R total did not change. If it did, something went wrong.

Best Practices and Common Pitfalls

• ✅ Set a written naming standard before importing anything.
• ✅ Add a billing email for every customer. You will need it for invoices in Module 2.
• ⚠️ Avoid creating customers "on the fly" while entering transactions. It is the top source of duplicates.
• ⚠️ Do not put notes like "PAID!!" or "DO NOT CALL" in the name field.

Tool Translation: In Xero these are called Contacts, and customers and suppliers share one list.

Sheets companion: Keep a master customer list that you sort and de-duplicate before importing.

Lesson 1.3: Products and Services

Learning Objectives

• Distinguish the item types in QBO.
• Create items linked to the correct income accounts.
• Design a lean item list that supports useful reporting.

Content and Theory

The Products and Services list holds the items a business sells. An item does two jobs: it speeds up invoicing (default description and price), and it routes income to the right account in the chart of accounts, which drives your reports.

Item types:

• Service: labor or time, such as cleaning or consulting.
• Non-inventory: physical goods you sell but do not track in stock.
• Inventory: goods tracked by quantity (available on higher-tier plans).
• Bundle: a group of items sold together.

Guideline: Match the item list to how the owner wants to see their income. If Dana wants to know whether residential or commercial cleaning earns more, they need separate income lines.

Step-by-Step Walkthrough

1. Go to Sales, then Products and services (or the gear icon, then Products and services).
2. Click New and choose Service.
3. Name it (for example, Standard Home Cleaning).
4. Enter the default price and description.
5. Choose the Income account (for example, Residential Cleaning Income), creating it first if needed.
6. Set sales tax handling if it applies.
7. Save, then repeat for each core service.

Real-World Example

Bright Path sells: Standard Home Cleaning ($120), Deep Cleaning ($220), Office Cleaning (custom quote), and a Move-Out Cleaning package.

Solution breakdown: Create four service items. Map Standard Home Cleaning, Deep Cleaning, and Move-Out Cleaning to Residential Cleaning Income, and map Office Cleaning to Commercial Cleaning Income. Dana can now see residential versus commercial revenue on the P&L without any extra work.

Best Practices and Common Pitfalls

• ✅ 5 to 15 well-defined items is usually enough for a small business.
• ✅ Keep default descriptions clean and client-friendly, since they print on invoices.
• ⚠️ Mapping every item to one generic "Sales" or "Services" account wastes the feature.
• ⚠️ Do not use Inventory items unless the client genuinely needs stock tracking.
• ⚠️ Avoid a "Miscellaneous" catch-all item. It hides what the business really sells.

Tool Translation: Xero calls these Items (Business, then Products and services), with a sales account set per item.

Sheets companion: An Item Mapping Sheet listing each item, its price, and its target account for client sign-off.

Lesson 1.4: The Chart of Accounts

Learning Objectives

• State the accounting equation and identify the five account types.
• Explain debits and credits and normal balances.
• Review, clean up, and customize a chart of accounts.

Content and Theory

The Chart of Accounts (COA) is the master list of categories where every transaction lands. It is the skeleton of the financial statements.

The accounting equation:

Assets = Liabilities + Equity

The five account types:

• Assets are what the business owns (bank accounts, A/R, equipment). They appear on the Balance Sheet.
• Liabilities are what the business owes (credit cards, loans, sales tax payable). They appear on the Balance Sheet.
• Equity is the owner's stake (owner's investment, draws, retained earnings). It appears on the Balance Sheet.
• Income is money earned (service income). It appears on the P&L.
• Expenses are the costs of operating (supplies, rent, software). They appear on the P&L.

Debits and credits. Every transaction affects at least two accounts (this is called double-entry), and total debits always equal total credits. Debit means the left side and credit means the right side. They are not "good" and "bad."

Normal balances:

• Assets and Expenses increase with a debit.
• Liabilities, Equity, and Income increase with a credit.

Examples of double-entry:

• Invoice a customer $500: Debit A/R $500, Credit Service Income $500.
• Customer pays $500 (deposited): Debit Bank $500, Credit A/R $500.
• Buy $60 of supplies with a debit card: Debit Supplies Expense $60, Credit Bank $60.

You do not enter debits and credits by hand in QBO for most tasks, because the forms do it for you. But understanding them is how you spot errors and explain the books to clients.

QBO structure: Each account has an Account Type (Bank, Accounts Receivable, Expenses, and so on) and a Detail Type (a subcategory). Accounts can have sub-accounts to roll up detail.

Step-by-Step Walkthrough

Review a new client's COA

1. Go to the gear icon, then Chart of accounts.
2. Scan for unused default accounts, duplicates, accounts with confusing names, and any balance in Opening Balance Equity.
3. Compare against how the owner talks about their business and, if available, their tax return categories.

Add an account

1. Click New.
2. Choose the Account Type, then the Detail Type.
3. Name it and add a description.
4. Optionally make it a sub-account.
5. Save.

Clean up

• Rename to fix wording. Renaming to match an existing account offers a merge, which is irreversible.
• Make inactive for unused accounts rather than deleting them.
• Use Run report on any account to see its transaction history.

Real-World Example

Bright Path's default COA includes "Uncategorized Expense," "Miscellaneous," "Commissions & fees," and no account for cleaning supplies or contractor pay.

Solution breakdown: Add Cleaning Supplies (Expense), Contract Labor (Expense), Vehicle: Fuel (a sub-account under Vehicle Expenses), and Owner's Draw (Equity). Make unused defaults like "Commissions & fees" inactive. Now the categories reflect how this business actually spends money.

Best Practices and Common Pitfalls

• ✅ Keep it lean. Fewer, clearer accounts beat 120 rarely used ones.
• ✅ Ask the client's tax preparer whether they want specific categories.
• ✅ Opening Balance Equity should end at $0. A lingering balance means setup entries need review.
• ⚠️ Avoid changing an account's type after transactions exist unless you understand the impact.
• ⚠️ Owner personal spending is not an expense. It is a draw or distribution (covered in Module 3).
• ⚠️ Accounts with history cannot be deleted, and merging carelessly can bury errors.

Tool Translation: Xero's chart of accounts is under Accounting, then Chart of accounts, and it requires account codes.

Sheets companion: A COA Mapping Sheet with columns for account name, type, purpose, and "used for."

Lesson 1.5: Bank Accounts

Learning Objectives

• Set up bank and credit card accounts correctly in QBO.
• Connect a bank feed securely and choose the right start date.
• Distinguish bank feed data from the books.

Content and Theory

Bank and credit card accounts live in the COA. Bank accounts are assets and credit cards are liabilities. Getting the type right matters because it controls how balances show on the balance sheet.

Bank feeds import transactions from the bank into QBO's Banking area. They are staged there as for review items until you categorize or match them. Feeds save typing, but they do not decide categories. That is your job, and it is the focus of Module 3.

Alternatives to a live feed: Upload a CSV, QBO, or QFX file. This is useful when a bank is not supported or the connection is unreliable.

The start date matters. Choose a start date that does not overlap transactions already entered or reconciled. Overlap causes duplicates.

Clearing accounts: Payment processors (PayPal, Stripe, Square) often deposit net amounts after fees. Treat them as their own accounts so gross sales and fees can be recorded properly. This is explored more deeply in Modules 3 and 5.

Step-by-Step Walkthrough

Connect a feed

1. Go to Banking, then Link account (or Connect account).
2. Search for the bank and sign in with credentials the client authorizes.
3. Complete any multi-factor prompts (the client may need to provide a code).
4. Select the account to connect.
5. Choose the account type and set "Download transactions from" to the correct start date.
6. Click Connect, then review what imports.

If the feed will not connect

1. Export a statement CSV from the bank.
2. Use Upload from file, then map the columns (Date, Description, Amount).
3. Import and review.

Set up the account itself

• Confirm the account name, for example Business Checking (…4417), using the last four digits to distinguish accounts.
• For an existing business, obtain the ending balance from the last reconciled statement as the opening balance, and record its date.

Real-World Example

Dana gives you access to her business checking account and a credit card. You connect both and set the feed start date to January 1, but Dana had already typed in January's transactions by hand. You see 40 transactions that look identical to ones already entered.

Solution breakdown: QBO offers matches for many of them, so use Match to link the feed transactions to the existing entries (Lesson 3.2 covers this properly). To avoid the issue, check what is already in the books before choosing the start date.

Best Practices and Common Pitfalls

• ✅ Use read-only or limited access where the bank offers it, and store credentials in a password manager, never in email.
• ✅ Connect business accounts only. Personal accounts mix personal and business activity.
• ✅ Include the account's last four digits in its name.
• ⚠️ Do not set a start date before the client's books begin or before the last reconciled period.
• ⚠️ Bank feeds can disconnect. Check the Banking page for reconnect notices during each session.
• ⚠️ Do not confuse a feed's balance with the reconciled balance.

Tool Translation: Xero uses Bank feeds with a similar connection flow, and its statement lines are "reconciled" in place.

Sheets companion: A Bank Connection Tracker with bank name, account, last four digits, feed status, and date last checked (never passwords).

Lesson 1.6: Basic Navigation

Learning Objectives

• Move efficiently between QBO's main areas.
• Use search, the Create button, and recent transactions to work quickly.
• Configure the essential company settings for a new client.

Content and Theory

Once you understand where things live, you will work much faster.

Main navigation areas:

• Left menu: typically Dashboard, Banking (transactions), Sales (customers, invoices), Expenses (vendors, bills), Reports, Taxes, and Accounting (chart of accounts, reconciliation).
• + New / Create button: fast entry for invoices, payments, expenses, and more.
• Global search: finds transactions, customers, and reports by name or amount.
• Gear icon: settings, lists, tools, and import/export options.

Essential company settings (gear icon, then Account and settings):

• Accounting method: Cash recognizes income when money is received and expenses when they are paid. Accrual recognizes them when invoiced or billed. Confirm which the client's tax preparer expects.
• Fiscal year: the start month.
• Closing date: locks the books before a set date so past periods cannot be changed accidentally. You will use this in Module 5.
• Company info, emails, and Sales settings: covered in Module 2.

Audit Log: records who changed what and when, which is very useful for tracing problems.

Step-by-Step Walkthrough: New-Client Settings Checklist

1. Verify the company name, legal name, and address.
2. Confirm the accounting method with the client or their CPA.
3. Confirm the fiscal year start.
4. Confirm the closing date is not set yet (you will set it later at month-end).
5. Review the Advanced settings, including turning on account numbers if desired.
6. Add yourself as an accountant user (or confirm your QBOA access).
7. Open the Audit Log and note the last few entries.
8. Record everything in your Client Onboarding Checklist.

Real-World Example

Dana asks, "Where did my March 12 payment from the Lopez family go?"

Solution breakdown: Use global search for "Lopez," or search by the amount, and open the payment. Check its deposit account and whether it is applied to an invoice. If it is not obvious, use the Audit Log to see whether someone edited or deleted it. It is a two-minute task once you know the navigation.

Best Practices and Common Pitfalls

• ✅ Use a separate browser profile for each client when you handle several. It prevents editing the wrong file.
• ✅ Always check the company name in the top corner before entering data.
• ✅ Confirm cash versus accrual before running any reports for a client.
• ⚠️ Turning on multi-currency is permanent in QBO. Never enable it without a genuine need.
• ⚠️ Menu labels move with QBO updates. Learn the function, then find it by search if the layout has changed.

Tool Translation: Xero's navigation runs across the top (Dashboard, Business, Accounting, Reporting, Contacts).

Sheets companion: A "QBO Where-To-Find-It" cheat sheet that you personalize as you learn.

Module 1 Knowledge Check

Answer each question. Your answers are checked only when you click Check answers — nothing is revealed until then.

Module 1 Practical Exercise: Onboard Bright Path Cleaning Co.

Scenario: Dana Reyes has hired you. She sends: "Here's my old spreadsheet, my price list, and a CSV from my bank. Please get my QuickBooks set up so I can start invoicing next week." You will be working in a sample company or practice file.

Provided Materials

• A messy customer list of about 12 rows, including 2 duplicates and 1 missing email
• A price list with 5 services
• A default-style chart of accounts that needs customizing
• A 30-day bank CSV (about 25 rows)

Tasks

1. Health check: Record the dashboard state in your Client Onboarding Checklist.
2. Customers: Clean the spreadsheet using the Customer Import Sheet, import it, and confirm the count matches.
3. Products and Services: Create 5 service items mapped to at least 2 different income accounts.
4. Chart of Accounts: Add at least 4 accounts and make at least 3 inactive. Add a one-line reason for each change in your COA Mapping Sheet.
5. Bank setup: Upload the CSV into the practice file and confirm the imported row count.
6. Settings: Complete the New-Client Settings Checklist.
7. Summary note: Write a short email to Dana (5 to 8 sentences) explaining what you set up and what you need from her next (for example, missing emails or the last statement balance).

Deliverables

Your completed onboarding checklist, cleaned customer file, COA mapping sheet, screenshots of the item list and chart of accounts, and the client email.

Self-Assessment Rubric

• Customer list: Excellent means no duplicates, consistent names, and emails present. Needs work means duplicates or inconsistent naming remain.
• Items: Excellent means clear names and correct income mapping. Needs work means everything is mapped to one account.
• Chart of accounts: Excellent means lean, relevant, and documented with reasons. Needs work means unnecessary accounts and no rationale.
• Bank import: Excellent means the row count was verified. Needs work means it was not verified or rows are duplicated.
• Client email: Excellent means clear, professional, with specific next steps. Needs work means vague or too technical.

Stretch Challenge

Recreate the customer and item setup in a Xero demo company and list three differences you noticed.