Fintrix Consulting LLC

Bookkeeping

Signs your QuickBooks setup is holding you back

November 20, 2026 · 10 min read

← All articles
Frustrated man with his hand on his head staring at a laptop screen at a table
Photo via Pexels

Quick answer

Your QuickBooks Online setup is holding you back when the reports you need take a spreadsheet to build, when bank rules keep posting things to the wrong account, or when old payments pile up in Undeposited Funds. Other signs: a chart of accounts with hundreds of lines nobody uses, products mapped to the wrong income accounts, everyone logged in as an admin, and a plan that lacks the features you need (or charges for ones you don't). Each one is fixable without starting a new file.

Your QuickBooks file isn't a disaster. The bank accounts reconcile, your CPA files the return and nobody's panicking. But every month someone exports the P&L to Excel to split it by location. Revenue for one product line keeps landing in the wrong account. And when you asked who changed last quarter's numbers, the answer was "anyone could have."

That's not a messy file. It's a file that was set up for the business you were three years ago. If you're looking at months of unreconciled transactions, start with our post on resetting a messy QuickBooks Online file instead. This one is about the settings and structure that quietly cost you time and bad decisions even when the transactions are entered on time.

250

Account limit in the chart of accounts on Simple Start, Essentials and Plus

40

Combined classes and locations allowed on QuickBooks Online Plus

25

Billable users on Advanced, against 5 on Plus

Sign 1: Your chart of accounts is bloated

Open the chart of accounts and count. If you're scrolling past "Meals 2," "Meals & Entertainment (old)," "Ask Sarah" and nine different software accounts, the chart has grown by accident.

A bloated chart causes two problems. First, people code the same expense three different ways, so no single line on the P&L is right. Second, you hit Intuit's limits: Simple Start, Essentials and Plus cap you at 250 accounts. If you're near that, it usually means the chart is being used to track things it shouldn't, like a separate income account per customer or an expense account per project.

The fix is to merge duplicates, make the rest inactive and move the detail somewhere better (customers, projects, classes or locations). Our chart of accounts design post covers how to structure it.

Sign 2: You build segment reports in Excel

If you've ever exported a P&L and split it by hand into "Store A" and "Store B," or "Residential" and "Commercial," you're paying for classes and locations without using them (or you're on a plan that doesn't have them).

Class and location tracking is included in QuickBooks Online Plus and Advanced, not in Simple Start or Essentials. Plus allows 40 classes and locations combined; Advanced has no limit. Set them up once, make the class field required on transactions, and the P&L by class runs itself.

A rule of thumb: use locations for where (a store, a region, an entity-like division) and classes for what (a service line, a department). Don't use either for things that already have a home, like individual customers.

Sign 3: Bank rules are creating errors, not saving time

Bank rules are great until they aren't. The classic problem is a rule with auto-add turned on. Intuit's auto-add setting confirms matching transactions automatically, so nobody looks at them. A rule written two years ago for "AMAZON" that sends everything to Office Supplies will happily post a $3,800 laptop, a $600 inventory restock and your personal Prime membership to the same account.

Signs your rules are the problem:

  • Expense lines jump in months when nothing changed in the business.
  • Transfers between your own accounts show up as income or expense.
  • Owner draws or loan payments land in expense accounts.
  • Nobody knows how many rules exist or who wrote them.

Review the rule list once a quarter. Turn auto-add off for any vendor where the spending varies. Our bookkeeping automations post has the ones worth keeping on.

Sign 4: Undeposited Funds keeps growing

Undeposited Funds is a holding account. Customer payments sit there until you group them into a bank deposit, which matches what actually hit the bank. Used properly, it should be close to zero at month end, except for checks you received but haven't deposited yet.

The trouble starts when payments are recorded against invoices and the bank deposit is categorized straight to income. Revenue gets counted twice, and the invoice payments sit in Undeposited Funds forever. Intuit notes that invoice payments processed through QuickBooks Payments don't need to go through Undeposited Funds at all, which is one more reason an old balance there usually means a workflow problem, not real cash.

If your balance sheet shows $14,000 in Undeposited Funds and you know there's no stack of checks in a drawer, you have a cleanup job and a process to fix. The reset post walks through the cleanup; the process fix is to decide one way of recording customer payments and train everyone on it.

Sign 5: Products and services are set up wrong

Every product or service in QuickBooks is mapped to an income account (and, for inventory items, to inventory and cost of goods sold). When those mappings are wrong, the invoices look fine and the P&L is quietly wrong.

Common setups that cause trouble:

What you seeWhat's usually behind itThe fix
All revenue in one "Sales" lineEvery item maps to the same income accountMap items to the income accounts you actually want to report
Gross margin swings month to monthInventory sold as non-inventory items, so cost hits when you buy, not when you sellUse inventory items (Plus and above) or adjust cost of goods sold at month end
Deposits counted as revenueCustomer deposits invoiced with a normal service itemCreate a deposit item mapped to a liability account
Hundreds of one-off itemsA new item created for every quoteKeep a short list of standard items and use descriptions

If you sell physical products, inventory tracking starts on the Plus plan. On Simple Start or Essentials, you'll need a workaround or a connected app. See landed cost for what usually goes missing from cost of goods sold.

Sign 6: Too many people have admin access

Look at Settings, then Manage users. If the office manager, two salespeople, a former bookkeeper and an app integration all have company admin access, anyone can change closed periods, delete transactions, add a vendor and pay them.

That's a fraud risk and an accuracy risk at the same time. A company admin can see and change everything except the primary admin's access. Most people need less: a sales role, a role to enter bills, or reports only. Advanced adds custom roles so you can limit access more precisely.

Two things owners often don't know:

  • Accountant users are free. Intuit says invited accountants don't count against your plan's user limit. So there's no reason to give your outside bookkeeper one of your paid seats or, worse, your own login.
  • Shared logins break the audit log. If three people use one login, the audit log can't tell you who did what.

Our post on small business fraud controls covers the separation of duties to aim for.

Sign 7: You're on the wrong plan

Plans are built in steps, each one including everything in the plan below. Being on the wrong one hurts in both directions.

Which QuickBooks Online plan fits which business

1 or 3 users

Simple Start / Essentials

  • Fine for a service business with one location
  • No class or location tracking
  • No inventory tracking
  • Essentials raises the user count from 1 to 3

5 users

Plus

  • Class and location tracking, up to 40 combined
  • Inventory tracking
  • Project profitability
  • Still capped at 250 accounts

25 users

Advanced

  • Unlimited classes, locations and accounts
  • Custom user roles and access levels
  • Approval workflows for bills
  • Worth it when users, controls or segments outgrow Plus

You've outgrown your plan if you're building class reports in spreadsheets, tracking inventory outside QuickBooks, or sharing logins because you've run out of users. You may be over-buying if you're on Advanced with three users, no classes and no workflows. Plan names and features change, so check Intuit's current comparison before you switch. If you're still choosing software altogether, see QuickBooks Online vs Xero.

A worked example: where the hours go

Say you run a hypothetical landscaping company with two crews and a design studio, about $2.4 million in revenue, on QuickBooks Online Essentials. The office manager spends roughly 15 hours a month working around the setup:

Hours a month spent working around the setup

Hypothetical landscaping company on QuickBooks Online Essentials

Splitting the P&L by divisionin ExcelSplitting the P&L by division in Excel: 66Re-coding auto-added banktransactionsRe-coding auto-added bank transactions: 44Chasing old Undeposited FundsChasing old Undeposited Funds: 33Fixing invoices with wrongitemsFixing invoices with wrong items: 22

Hypothetical example. 6 + 4 + 3 + 2 = 15 hours a month.

Show the numbers
Splitting the P&L by division in Excel6
Re-coding auto-added bank transactions4
Chasing old Undeposited Funds3
Fixing invoices with wrong items2

Moving to Plus and setting up three classes (Maintenance, Installation, Design) removes the six hours of spreadsheet work. Turning off auto-add on six vendor rules and reviewing the rest cuts the re-coding to under an hour. Clearing Undeposited Funds once and changing how payments are recorded stops that job coming back. Mapping items properly ends the invoice fixes.

That's roughly 14 of the 15 hours back each month, plus division margins the owner can actually trust. The bigger win usually isn't the time. It's finding out, for the first time, that Design runs at a loss once its share of payroll is counted.

Common mistakes when fixing the setup

Starting a new file. It feels clean, but you lose history and comparisons. Most setup problems can be fixed in place.

Deleting accounts with history. Make them inactive after moving the balances. Deleting can scramble past reports.

Adding classes without rules. If class is optional, half the transactions won't have one, and the report is useless. Make it required and decide what goes where.

Changing closed periods. Fix setups going forward, and only adjust history deliberately, with your CPA in the loop, after closing the books. Set a closing date password so nobody edits filed months by accident.

Upgrading to solve a process problem. Advanced won't fix bank rules nobody reviews.

When to get help

If your file has a few of these signs and someone on your team knows QuickBooks well, a focused afternoon fixing users, rules and items will go a long way. Bring in help when the chart needs restructuring, when history has to be reclassed, or when the setup problems have turned into reconciliation problems.

Fintrix Consulting works inside your own QuickBooks Online file, and onboarding includes fixing the chart of accounts, catching up or cleaning up past months and documenting a close checklist built for your business. See how our monthly bookkeeping works, or try the free chart of accounts generator to sketch a cleaner structure.

Frequently asked questions

How many accounts should a small business chart of accounts have?

There's no magic number, but most small businesses report well with somewhere between 50 and 100 active accounts. If you're near the 250 limit on Simple Start, Essentials or Plus, the chart is probably doing a job that customers, projects or classes should do.

Can I use classes on QuickBooks Online Essentials?

No. Intuit includes class and location tracking on Plus and Advanced only. Plus allows 40 combined; Advanced is unlimited.

Does my bookkeeper need one of my paid user seats?

Usually not. Invite them as an accountant user. Intuit says accountant users don't count against your plan's user limit.

Should Undeposited Funds ever have a balance?

Only for payments you've received but not yet deposited, such as checks waiting to go to the bank. A balance that's months old usually means payments were recorded twice.

Can I downgrade my QuickBooks Online plan?

Yes, but check first that you're within the lower plan's limits for users, accounts, classes and locations. Intuit asks you to reduce usage before downgrading.

The bottom line

A QuickBooks file can be up to date and still hold the business back. Watch for a bloated chart of accounts, reports built in Excel, bank rules nobody reviews, a growing Undeposited Funds balance, wrongly mapped items, too many admins and a plan that doesn't fit. Fix them in place, in that order of pain, and the file starts giving you answers instead of chores.

This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.

Have a question about this article?

Ask us. A real person will reply by email within one business day. Your question isn’t published.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms apply.

Ready for books you can trust?

Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.