Resources / Templates

Bookkeeping

Quickbooks Onboarding (QBO) Template

Set up a new client in QuickBooks Online, including company file creation, chart of accounts, bank feeds, integrations, data migration (if applicable), and handoff to the ongoing bookkeeping workflow.

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 QBO 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.

When to run it

Run this at the start of every new engagement: a brand-new client setting up QBO 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 QBO 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.
  • Skipping the trial balance and opening financials review, then handing off a file no one has actually checked.

What's included in this checklist

23 steps and 9 client requests.

  1. 1

    Create or access the QBO company file

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

  2. 2

    Configure company settings

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

  3. 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. 4

    Connect firm accountant access

    Add the firm as the accountant user via QuickBooks Online Accountant (QBOA), or accept an accountant invite from the client.

  5. 5

    Invite client user(s) and set permissions

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

  6. 6

    Set up chart of accounts

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

  7. 7

    Connect bank and credit card feeds

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

  8. 8

    Confirm correct start date for bank feeds

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

  9. 9

    Connect payment processors (if applicable)

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

  10. 10

    Set up payroll integration (if applicable)

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

  11. 11

    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.

  12. 12

    Configure sales tax settings (if applicable)

    Enable automated sales tax, set tax agencies, and configure rates or exemptions as required.

  13. 13

    Set up products and services list (if applicable)

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

  14. 14

    Customize invoice and estimate templates (if applicable)

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

  15. 15

    Import customer and vendor lists (if applicable)

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

  16. 16

    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.

  17. 17

    Review uncategorized or excluded transactions

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

  18. 18

    Reconcile opening bank balances (if applicable)

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

  19. 19

    Set up recurring transactions (if applicable)

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

  20. 20

    Configure classes and locations for tracking (if applicable)

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

  21. 21

    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.

  22. 22

    Document configuration notes and special settings

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

  23. 23

    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.

  • Provide login credentials for third-party integrations (if applicable)

    Please share login details or send invitations for any connected apps (e.g., Dext, payment processors, payroll) so we can complete the integration.

  • 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 QBO.

  • 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 QBO 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.

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.

Run this as a live workflow in Tidyflow

Turn this checklist into a repeatable job: subtasks your team checks off, requests your clients complete in their portal.

Start free trial

Related templates

Get your firm organized today.

No credit card required. Cancel anytime.