ProAdvisor Prep: Module 2 — Setting Up a New Client & Importing Data

We survived Module 1.

You can navigate the dashboard. You know whose books you’re in. You’ve clicked on things. Hopefully none of those things belonged to an actual client.

Now we’re moving on to Module 2: Setting Up a New Client & Importing Data.

And this is where QBO starts feeling less like software you’re poking around in and more like something you could actually use to help somebody.

Because eventually a client is going to arrive carrying financial information assembled through some combination of spreadsheets, bank records, old software, receipts, questionable organizational decisions, and hope.

Our job is to turn that into something useful.

Let’s learn how.

First Rule of Onboarding: Don’t Start Clicking Yet

Imagine someone hands you a spreadsheet containing years of business information and says:

“Here. This is everything.”

Your first instinct should NOT be:

IMPORT.

Your first question should be:

What the hell am I looking at?

Before bringing data into a new company, figure out what exists, what needs to exist, what belongs in QBO, and how everything relates.

Because importing garbage faster is still importing garbage.

Automation can save an enormous amount of time.

It can also help you create an enormous mess remarkably efficiently.

Adding a Client to Your Firm

Current QBOA workflows allow you to add clients to your firm whether they’re completely new to QuickBooks, already using QuickBooks, or simply someone whose information you want to manage through your practice.

If they already have QuickBooks, they can invite your firm as their accountant.

For a brand-new client, you’ll enter their information, determine what products they need, and establish how the subscription will be billed.

And this is one of those places where I’m deliberately not telling you to memorize one exact sequence of buttons.

Intuit changes the furniture.

As of this writing, you’ll generally work through the Clients/Client list area to add them. Current options can include accountant-billed ProAdvisor pricing, client-paid discounts or revenue-share arrangements, and even split billing across products.

Learn what those choices mean, not just which radio button somebody told you would be on an exam.

Because someday the radio button will move.

The concept won’t.

Who Pays for What?

This is an actual business decision.

Sometimes the accounting firm manages the client’s subscription and gets billed for it.

Sometimes the client pays Intuit directly.

Sometimes different products can be billed differently.

Before choosing anything, understand the arrangement between the firm and client.

Who owns the subscription relationship?

Who is paying?

What products does this client actually need?

Those questions matter considerably more than memorizing terminology.

Now Let’s Talk About Importing Data

There was a time when QuickBooks could import exactly four things.

This is no longer the case.

Current QuickBooks Online documentation lists quite a few types of information that can be imported, including things like:

• Chart of Accounts
• Customers
• Vendors
• Products and Services
• Employees
• Bank data
• Invoices
• Bills
• Checks
• Expenses
• Estimates
• Deposits
• Journal entries
• Purchase orders
• Sales receipts
• Classes and locations
• Time activities

Availability can depend on your QuickBooks version and the particular import method you’re using, so check the current Intuit documentation when you’re doing this for real.

The important lesson for Module 2 isn’t memorizing a giant list.

It’s understanding how imported information fits together.

ORDER MATTERS

This one is worth remembering.

QuickBooks currently recommends importing your lists before your transactions.

And there’s logic behind that.

A transaction references things.

An invoice may reference a customer.

An expense may reference an account.

An item may reference income or expense accounts.

If those underlying records don’t exist yet, QuickBooks has considerably less to work with.

Intuit’s current recommended list order starts with:

Chart of Accounts → Customers → Vendors → Employees → Classes → Locations → Products & Services

Then you can move into transaction data.

That isn’t arbitrary.

You’re building the structure before filling it with activity.

Think of it like moving into a house.

We would ideally like the cabinets installed before I dump 47 boxes of kitchen shit onto the floor.

Your Spreadsheet Is Not Sacred

Clients have spreadsheets.

Omg, do clients have spreadsheets.

Some will be beautiful.

Some will make you question whether Excel has personally offended them.

Before importing anything, inspect the file.

Look for:

• Blank rows or unnecessary headers
• Duplicate records
• Weird formatting
• Inconsistent names
• Columns containing multiple kinds of information
• Dates stored incorrectly
• Numbers stored as text
• Accounts or categories that don’t make sense
• Information that shouldn’t be imported at all

QuickBooks supports common spreadsheet formats including CSV and Excel files, and current import tools also support Google Sheets in various workflows.

During the import process, you’ll map the columns in the source file to the corresponding fields in QuickBooks.

Translation:

You’re telling QBO:

“This column means customer name. This one means email. This one means account type.”

Do not blindly click through this part.

Mapping is where you make sure QuickBooks understands the spreadsheet the same way you do.

Stop Before You Press Import

This deserves its own tiny ritual.

Before committing an import, ask:

Am I in the correct company?

Am I importing the correct file?

Does the data look clean?

Did I map the columns correctly?

Am I bringing things in in a sensible order?

Five seconds of checking can prevent considerably more than five seconds of cleanup.

This is a recurring theme in accounting.

Possibly life.

About the Magical “Just Purge It” Solution

You may encounter training or older resources discussing the ability to purge a recently created QBO company and start over.

Treat that as a specific tool with eligibility requirements, not your universal Undo button.

Account type, age, subscription status, and current Intuit functionality matter.

Before relying on a purge as your recovery strategy, verify the current requirements in Intuit’s documentation.

Better yet:

Plan the setup before importing the data.

Deleting your entire company should probably not be Step 2 of your onboarding workflow.

Module 2 Scavenger Hunt: Welcome to Your First Fake Client

We’re not just reading this shit.

For this exercise, pretend you’ve acquired a tiny fictional business.

Let’s call it:

Resistance Coffee & Books

Because obviously.

Your new client sells books, coffee, and questionable amounts of caffeine to exhausted accountants.

Your mission is to explore your practice/demo environment and determine:

• Where would you add this client?
• What information would you need from them before setup?
• Where would you determine their subscription arrangement?
• Where would you find the import tools?
• Where would you import a Chart of Accounts?
• Where would you import customers?
• Where would Products & Services fit into your import order?
• What file formats are currently accepted?
• Where does QBO let you map spreadsheet columns?
• What would you verify before completing the import?

Bonus: Create a tiny spreadsheet yourself with five fake customers.

Make one row intentionally shitty.

Duplicate somebody.

Leave something blank.

Format something strangely.

Then see whether you can spot the problem before QBO has to complain about it.

That’s the skill we’re actually building.

Mini-Quiz: Do You Understand It or Did You Just Read It?

Question 1

Your client gives you their Chart of Accounts, customer list, vendor list, and transaction history.

What should you generally establish first?

A. Transaction history
B. The underlying lists and company structure
C. Whatever spreadsheet has the fewest rows

Question 2

You’re importing customer data and QBO asks you to map fields.

What are you actually doing?

A. Telling QBO which spreadsheet columns correspond to QuickBooks fields
B. Choosing which bank account the client uses
C. Performing some ancient accountant ritual nobody understands

Question 3

You discover a badly formatted spreadsheet containing duplicate records immediately before importing it.

What’s your best move?

A. Import it and let Future You deal with the consequences
B. Clean and review the source data first
C. Close QuickBooks and become a florist

Question 4

Why do we care about import order?

A. Because underlying records need to exist for transactions that reference them
B. Because accountants enjoy arbitrary rules
C. Because QuickBooks can smell fear

Answers: B, A, B, A.

If you selected C on Question 3, I understand.

But get back to work.

What I Actually Want You to Learn From Module 2

I don’t want you leaving this module thinking:

I know where the Import button is.

That’s useful.

But I want you thinking:

I understand what I’m importing, why I’m importing it, what needs to exist first, and what I should verify before I commit it.

That’s a professional skill.

Buttons move.

Interfaces change.

Import tools improve.

Terminology gets renamed.

But understanding the relationship between the data is what lets you adapt when the software inevitably changes.

And that is the whole point of this series.

We’re not memorizing QuickBooks long enough to collect a badge.

We’re learning how the damn thing works.

Module 2 mission:

Inspect first.

Build the structure.

Clean the data.

Map carefully.

Verify everything.

Then import.

And for the love of all things financially balanced:

Make sure you’re in the correct client’s books first.

See you in Module 3, Resistance Accountant.