QuickBooks Online Onboarding Template

QuickBooks Online client onboarding template: set up the company file, chart of accounts, bank feeds, integrations, and opening balances, then hand off to ongoing bookkeeping.

Onboarding a client onto QuickBooks Online is the foundation everything else sits on. It covers creating or accessing the company file, configuring company and accounting settings, building a chart of accounts that matches the client’s industry, connecting bank and credit card feeds, and either migrating historical data or entering opening balances as of the conversion date. Done well, the file is clean from day one and the team can move straight into recurring bookkeeping. Done in a rush, the mistakes compound for months.

The risk is that QuickBooks Online setup feels deceptively simple. A bank feed pulls in the wrong start date, opening balances are entered without a trial balance to back them, or the chart of accounts is left as the default and never tailored. By the time someone notices, there are duplicate transactions to unwind and reconciliations that will not tie out. A repeatable process turns client onboarding into something you can run the same way every time, regardless of who picks up the job.

QuickBooks Online onboarding checklist

The subtasks in this template work as a step-by-step checklist: create or access the company file, configure company and accounting settings, connect the firm and client users, tailor the chart of accounts, link bank and credit card feeds, set up integrations and sales tax, migrate data or enter opening balances, then run the opening trial balance review before handoff. Work through them in order so nothing slips before the file goes live.

When to run it

Run this at the start of every new engagement: a brand-new client setting up QuickBooks Online for the first time, or a migration from spreadsheets, desktop software, or another cloud platform. The job is owned by the bookkeeper or accountant leading the relationship, who confirms the file is accurate before the first regular bank reconciliation begins.

How to run it in Tidyflow

Save this as a reusable job template so every QuickBooks Online onboarding follows the same path. Each setup step becomes a subtask your team checks off in order, and progress stays visible across the firm rather than living in one person’s head. See workflow management for how templates and subtasks work.

The information you need from the client (business details, account lists, prior-period financials, logos) goes out as structured requests through the client portal. Clients upload documents and confirm details in one place, so you are not chasing replies across email. Because Tidyflow integrates directly with QuickBooks Online, the client record and the file stay aligned as the engagement moves into ongoing work.

Common pitfalls

Leaving the default chart of accounts untouched instead of tailoring it to the client’s industry and your firm’s reporting standards.
Setting the wrong bank feed start date, which creates duplicate or missing transactions that are painful to clean up later.
Entering opening balances without a trial balance or recent statements to verify them, so the file never reconciles.
Choosing cash versus accrual basis incorrectly, or leaving it unconfirmed, before any transactions are categorized.
Entering opening balances straight to the general ledger without a backing journal entry, so the starting position cannot be traced or verified later.
Skipping the trial balance and opening financials review, then handing off a file no one has actually checked.

What's included in this checklist

24 steps and 9 client requests.

1

Create or access the QuickBooks Online company file

Create a new QuickBooks Online company or accept an invitation to an existing file from the client.
2

Configure company settings

Set legal name, entity type, industry, fiscal year-end, business address, and base currency.
3

Confirm accounting method and reporting basis

Ensure the client is set to cash or accrual basis as required for reporting and tax purposes.
4

Connect firm accountant access

Add the firm as the accountant user via QuickBooks Online Accountant, or accept an accountant invite from the client. Accountant users are separate from the client's billable user seats, so adding the firm this way does not use up one of their subscription seats.
5

Invite client user(s) and set permissions

Add the client as an admin or standard user and configure appropriate role-based permissions.
6

Set up chart of accounts

Customize the default chart of accounts to match the client's industry, reporting needs, and firm standards.
7

Connect bank and credit card feeds

Link all active bank and credit card accounts through direct feeds or manual upload.
8

Confirm correct start date for bank feeds

Verify the start date of imported transactions and ensure no duplicates or gaps exist.
9

Set up bank rules for recurring transactions

Create bank rules for the client's regular, predictable transactions so the file categorizes them consistently from day one and reduces ongoing cleanup.
10

Connect payment processors (if applicable)

Link Stripe, Square, PayPal, or other payment platforms to sync transaction data.
11

Set up payroll integration (if applicable)

Connect Gusto, ADP, QuickBooks Online Payroll, or another payroll provider and verify journal entries flow correctly.
12

Connect third-party apps (if applicable)

Set up integrations such as Dext, Hubdoc, Bill.com, or other tools the firm uses for receipt capture, bill pay, or reporting.
13

Configure sales tax settings (if applicable)

Turn on automated sales tax, confirm the locations where the client is registered to collect tax, and assign tax categories to taxable items.
14

Set up products and services list (if applicable)

Create product and service items used on invoices, estimates, and purchase orders.
15

Customize invoice and estimate templates (if applicable)

Apply client branding (logo, colors, payment terms) to invoice, estimate, and receipt templates.
16

Import customer and vendor lists (if applicable)

Upload or manually enter existing customer and vendor records with contact details and default terms.
17

Import historical data or enter opening balances (if applicable)

Bring in prior-period transactions, or enter a trial balance and opening journal entry as of the conversion date.
18

Review uncategorized or excluded transactions

Check for uncategorized, excluded, or duplicate transactions in the bank feed.
19

Reconcile opening bank balances (if applicable)

Match opening balances in QuickBooks Online to the most recent bank statements to confirm the starting position is accurate.
20

Set up recurring transactions (if applicable)

Create recurring invoices, bills, journal entries, or transfers for predictable monthly activity.
21

Configure classes and locations for tracking (if applicable)

Enable and set up class and location tracking for departmental, project, or multi-entity reporting.
22

Run trial balance and review opening financials

Generate a trial balance, P&L, and balance sheet to verify the setup is accurate before beginning regular bookkeeping.
23

Document configuration notes and special settings

Record any non-standard setup decisions, integration credentials (stored securely), and client-specific instructions for the team.
24

Mark onboarding complete and hand off to bookkeeping workflow

Confirm all setup steps are done, create the first recurring bookkeeping job, and assign it to the appropriate team member.

What to request from the client

Built-in client requests so you collect everything in one go.

Provide business details

Please provide your legal business name, entity type, tax ID or business number, fiscal year-end, and registered address.
Provide bank and credit card account details

Please list all bank and credit card accounts to be connected, including institution names and account types.
Authorize bank feed connections

Please complete the bank feed authorization steps we've initiated, or provide secure access so we can connect your accounts.
Grant access to third-party integrations (if applicable)

For any connected apps (e.g., Dext, payment processors, payroll), please add us as a user or send us an invitation so we can complete the integration. Only share raw login credentials as a last resort if no invite or delegated access option exists.
Upload company logo (if applicable)

Please provide a high-resolution version of your company logo for use on invoices and estimates.
Provide customer and vendor lists (if applicable)

Please share any existing lists of customers and vendors with contact details, so we can import them into QuickBooks Online.
Provide prior-period financials or trial balance (if applicable)

Please upload your most recent financial statements or trial balance so we can set up accurate opening balances.
Provide recent bank statements (if applicable)

Please upload the latest statement for each bank and credit card account so we can reconcile the starting position.
Confirm QuickBooks Online access and user permissions

Please log in to QuickBooks Online and confirm you can access the company file with the correct permissions.

Frequently asked questions

It covers creating or accessing the company file, configuring company and accounting settings, tailoring the chart of accounts, connecting bank and credit card feeds, and either migrating historical data or entering opening balances. The goal is a clean, verified file before regular bookkeeping starts.

It depends on the client's needs and the quality of their prior records. Many firms enter a trial balance and opening journal as of the conversion date for a fresh start, while others import historical transactions when comparative reporting matters.

You run the setup as a reusable job template where each step is a subtask, and you collect business details, account lists, and prior financials through structured requests in the client portal. Tidyflow also integrates with QuickBooks Online so the client record stays aligned with the file.

The bookkeeper or accountant leading the client relationship typically owns it. They confirm the file is accurate, run the opening trial balance review, and hand off to the recurring bookkeeping workflow once setup is complete.

When the client hands over an existing file with miscategorized, duplicate, or incomplete data, the work shades from onboarding into a cleanup engagement. Use this template to confirm the settings, access, and integrations are correct, then scope the data remediation as a separate bookkeeping cleanup job rather than trying to fix it inline. That keeps the onboarding job's progress clear and lets you size the cleanup work on its own.

Getting the bank feed start date wrong, which creates duplicate or missing transactions that are tedious to unwind. Confirming the start date and reviewing opening balances against recent statements avoids most of the cleanup later.

QuickBooks Online Onboarding Template

QuickBooks Online onboarding checklist

When to run it

How to run it in Tidyflow

Common pitfalls

What's included in this checklist

What to request from the client

Frequently asked questions

Run this as a live workflow in Tidyflow

Related templates

Bookkeeping Template

Bookkeeping Template (Australia)

Bookkeeping Template (Canada)

Bookkeeping Template (New Zealand)

Get your firm organized today.