About Us
Book a consultation

206-717-4040  ·  info@kafoocpa.com

Bookkeeping & systems

QuickBooks Online setup: get it right the first time

Setup takes an afternoon. Undoing a bad setup takes months and costs real money. Here is how to make the handful of decisions that every future month of your books will inherit.

Two bookkeepers reconciling monthly accounts with reports and a calculator

Key takeaways

  • Every month of data inherits your setup, which is why these decisions are cheap now and expensive later.
  • Design the chart of accounts around how your business makes and spends money, then stop adding accounts.
  • Bank feeds save enormous time and will confidently miscategorize if left unsupervised.
  • Owner draws, equity, and loans need clean separation from day one, the most common cleanup we perform.
  • A short monthly close checklist keeps a good setup from drifting into a bad one.

QuickBooks Online will do almost exactly what you tell it to. That is the good news and the problem. The default file is generic, and most owners accept the defaults because nothing signals that a choice is being made. Two years later the reports do not reconcile to reality, the profit and loss has ninety accounts nobody uses, and personal spending sits in operating expenses.

Setup decisions compound because accounting is cumulative. Change the structure later and you either leave history coded the old way, breaking year-over-year comparison, or reclassify thousands of transactions at real cost. Spend the extra hours up front on the structural decisions and treat everything else as adjustable.

Choosing a start date and opening balances

Your start date is where QuickBooks takes over your live accounting. The clean choice is the first day of a fiscal year: a full year inside one system, and a straightforward tax return. Mid-year starts work, but they need accurate opening balances as of the day before.

Opening balances are the part people rush. You need closing balances from your prior books or last filed return for every balance sheet account: bank and credit cards, receivables and payables in detail, loans, fixed assets, and equity.

If they do not tie to something defensible, the difference lands in an opening balance equity account and quietly sits there. That account should be zero once setup is complete. A balance in it at year end means setup was never finished.

A test worth running on day one

Run a balance sheet as of your start date and compare it line by line to the prior year’s closing balance sheet or return. If they match, you have a foundation. If not, resolve the difference before recording anything new.

Designing a chart of accounts around your business

QuickBooks offers a default chart based on your industry. It is a starting point, not a design. The right chart answers one question: what do you need to see to run this business?

Start from your decisions, not a template

If you price by service line, split revenue by service line. If labor is your largest controllable cost, direct labor belongs in cost of goods sold, apart from administrative payroll. Write down the five numbers you want on one page each month, then build accounts that produce them.

Cost of goods sold versus operating expense

This boundary makes gross margin meaningful. Costs that scale with delivering the work sit above the gross profit line; costs you would pay anyway sit below. Dump everything into operating expenses and your profit and loss shows whether you made money, never why.

The “too many accounts” failure mode

The opposite error is as common. Owners add an account whenever a transaction feels different and end up with a report nobody reads. An account earns its place only if you would decide differently for seeing it separately.

Bank feeds, rules, and where automation misleads

Feeds are the largest time saver in the system. Connect every account the business uses, including credit cards and any loan or line of credit that posts activity. A partially connected file forces manual entry for the gaps, and that is where errors live.

Rules go further by auto-categorizing recurring transactions, and used well they handle the repetitive majority: the same utility, the same vendor, the same monthly service.

Where they go wrong is with vendors you use for more than one purpose. A hardware retailer might be job materials one week and office supplies the next. A rule set on the vendor name codes all of it the same way, silently.

Two guardrails. Do not enable auto-add on a rule you have not watched behave correctly for a couple of months, and never let feed transactions bypass review. The feed is a proposal, not a decision.

Bank rules do not have judgment. They have pattern matching. The moment a vendor means two things to your business, the rule is guessing, and it never tells you that it guessed. Ali Kafoo, CPA

Classes, locations, products, and services

The chart of accounts answers “what kind of cost is this.” Classes and locations answer “which part of the business does it belong to.” Together they keep the account list short and still show segment profitability.

When classes are worth the effort

Turn them on if you run distinct service lines, properties, programs, or departments and want a profit and loss for each. The cost is discipline: every transaction has to be classed, or segment reports will be incomplete in ways that are hard to notice.

Products and services

Every item you sell should map to the correct income account. This is skipped constantly, usually because the first invoice was made in a hurry and defaulted to a generic sales account. Every later invoice inherits it, and revenue reporting collapses into one line. If you track inventory, configure it before recording purchases.

Sales tax, payroll, and integrations

If you sell taxable goods or services, configure sales tax before you invoice. QuickBooks needs your agencies, filing frequency, and which items and customers are taxable. Getting it wrong means correcting filed returns, which is worse than correcting a category. Multi-state sellers should treat it as its own project, since nexus rules can extend obligations beyond where you are located.

Payroll should post in summary detail: gross wages, employer taxes, and liabilities separated. Liability accounts that grow month over month mean something posts incorrectly.

Integration order matters

Connect banking first, then payroll, then your point of sale or e-commerce platform. Each layer creates transactions the next may duplicate, a processor and a sales platform both pushing the same revenue is the most common duplication we see. Add one at a time and reconcile a month before adding the next.

Owner draws, equity, and user permissions

This section generates the most cleanup work, and it is entirely avoidable.

Money you take out is not an expense. Depending on your structure it is an owner draw, a distribution, or payroll, and each is recorded differently. Money you put in is a contribution or a loan, not income. Set up distinct equity accounts at the start, separate from any owner loan account.

This matters because basis, distributions, and reasonable compensation all depend on these accounts being right. With an S‑Corp election, sloppy equity records become a compliance exposure rather than an annoyance.

On users: give each person their own login, because the audit log is only useful if it can tell people apart. Give your bookkeeper and CPA accountant-level access and limit everyone else.

The monthly close that keeps the setup intact

A good setup decays without a routine, and the routine need not be elaborate.

  1. Reconcile every bank, credit card, and loan account to the statement, to the exact ending balance.
  2. Clear the uncategorized and ask-my-accountant accounts to zero.
  3. Review the profit and loss against the prior month and question anything that moved unexpectedly.
  4. Check the balance sheet for accounts that should be zero or moving and are not: opening balance equity, undeposited funds, payroll liabilities.
  5. Confirm receivable and payable aging matches what you believe is outstanding.
  6. Close the books through the period and set a closing password.

That last step is the one owners skip and later regret. Without a closing date, a mistyped date can silently change a year you have already filed. With reliable closes, your reports become usable for cash flow forecasting rather than only for the return.

Five setup mistakes that cost the most to unwind

  1. Skipping opening balances. Every balance sheet is then wrong by an amount nobody can explain.
  2. Running personal spending through the business. It contaminates the expense accounts and weakens the separation entity protection depends on.
  3. Letting rules auto-add without review. Months of confident miscategorization, found when fixing it is most expensive.
  4. Enforcing classes halfway. Segment reports that look complete and are not.
  5. Never reconciling. An unreconciled year is a rebuild, and the most common reason a cleanup engagement is necessary.

If you are inheriting an existing file

Do not start by fixing categories. Reconcile the most recent complete month and work backward until the accounts tie. Categorization work on top of unreconciled accounts is cosmetic.

A note on the numbers in this article

Software plans, features, integration behavior, and sales tax rules all change, and vary by state and industry. Anything described here illustrates how the pieces relate rather than current pricing or tax requirements. Confirm plan features and your filing obligations before relying on them.

The bottom line

Good books are not diligence applied monthly to a bad structure. They come from a structure that makes the right coding the easy coding, maintained by a short routine.

Setting up a new file? Spend the extra hours on the start date, the chart of accounts, the segment strategy, and the equity section. Inheriting one? Reconcile first, then judge whether to repair or rebuild.

If you would like a second set of eyes, get in touch. We build and maintain these files as part of our compliance and accounting services.

Frequently asked questions

Choose on the features your structure requires rather than on price. The deciding questions are whether you need classes and locations for segment reporting, whether you track inventory, how many users need access, and whether you need job-level profitability. Plan tiers change over time, so confirm current features first. It is usually cheaper to start a tier lower and upgrade than to pay for capability you never configure.

Use classes if you run distinct service lines, properties, programs, or departments and want a profit and loss for each without inflating your chart of accounts. The requirement is discipline: every transaction has to be classed, or segment reports will be quietly incomplete. A partially classed file is worse than an unclassed one, because the reports look authoritative while missing data. If you will not enforce it, leave classes off.

Yes, but changes are not free. You can rename accounts, merge duplicates, and make accounts inactive at any time. What costs time is restructuring after you have history: you either leave prior transactions coded the old way, breaking year-over-year comparison, or reclassify in bulk, which takes hours and can introduce errors. Small refinements are routine; a full redesign is a project.

Ali Kafoo, CPA

Ali Kafoo, CPA

Founder, Kafoo CPA

Ali is a Certified Public Accountant with a decade of experience in accounting and taxation, previously at Deloitte, Starbucks, Sweeney Conrad, and Security Tax Services. He founded Kafoo CPA so business owners could have one firm for both their personal and business finances.

Connect on LinkedIn

Keep reading

Related articles

An accountant reviewing a bookkeeping cleanup
Bookkeeping & systems

The bookkeeping cleanup guide: from messy to closeable

Read article
A financial reporting dashboard showing cash flow trends
CFO & growth

Cash flow forecasting that actually holds up

Read article
A business owner reviewing deductions with a CPA on a video call
Owner basics

Small business tax deductions owners routinely miss

Read article

Want your books built to close cleanly every month?

We set up QuickBooks Online properly and keep it that way, so your reports are worth reading.