Why QuickBooks Online Keeps Putting the Same Vendor in Different Accounts (and How to Stop It)

You coded the vendor once. Next month the same vendor shows up in a different account. Sometimes that's correct. Often it isn't, and it quietly moves dollars from one line of your P&L to another.

A freight carrier lands in cost of goods one month and in operating expenses the next. A software vendor splits between two accounts for no reason anyone can explain. Each transaction looks fine on its own. Together they make your margins wobble and your budget variances point at the wrong line.

Here's why it happens, how to see it in your own file, and how to make it stop.

First: not every spread is a mistake

Some vendors should land in several accounts. A big-box store sells you shop supplies and office supplies. A supplier sells materials and freight. For those vendors, spreading across accounts is correct, and the goal is consistent rules for which purchase goes where. The vendors to worry about are the ones that should always land in one place and don't.

Why it happens

• The bank feed learns from you. Bank-feed transactions get categorized one at a time, often in a hurry. One quick choice, such as a one-off purchase coded to supplies, is easy to repeat, and anyone who clicks Add without looking passes it along.
• Bank rules that are too broad, or in the wrong order. A rule matching a fragment of the bank description catches more than you meant. Intuit says the rule with the highest priority is applied first, so the order matters: a general rule sitting above a specific one can win when you didn't intend it to.
• Several ways in. Bills, bank-feed expenses, receipt capture, manual entries and imports can each land the same vendor in a different account.
• Duplicate vendor records. If "Northstar Supply" and "Northstar Supply Co." both exist, each builds its own habits. (We cover this in the duplicate bills post.)
• More than one person coding. A new bookkeeper, a part-timer or the owner on a Sunday night each make a slightly different call, and nothing records what the policy was.

Step 1: See the spread

1. Run a vendor transaction report for a quarter, or the whole year if you can, with the vendor and the account (category) shown for every line. Transaction List by Vendor is a good starting point; use Customize to add the account column if it isn't there.
2. Export it to Excel.
3. Insert a PivotTable with vendor as the rows, account as the columns, and the sum of amount as the values.
4. Add a count of transactions, then sort so vendors with two or more accounts come first, largest dollars at the top.

You can do this in a few minutes, and it tells you more about your books than most reports. Ignore tiny amounts. You're hunting for the vendors where real dollars sit in more than one account.

Step 2: Sort what you find into three piles

• Legitimately mixed. The vendor sells you different things. Leave the spread, and write down the rule that explains it.
• Wrong. The vendor should always be in one account, and some transactions are elsewhere. These get reclassified.
• One-offs. A single odd transaction. Fix it, but don't build a process around it.

Step 3: Fix the past

• Plus, Essentials and Simple Start: open each transaction and change its account, one at a time.
• Advanced (and QuickBooks Online Accountant): use the Reclassify transactions tool to move many at once, as described in the Ask My Accountant cleanup.
• Closed periods. If a period is closed, or its numbers have already gone to a lender, a board or your tax preparer, talk to your bookkeeper or CPA before changing it. Recoding rewrites reports other people have already seen.

Step 4: Stop it coming back

• Write bank rules per vendor, and for mixed vendors add conditions on amount or description, so each kind of purchase has its own rule.
• Put specific rules above general ones, and delete rules that no longer match anything.
• Merge duplicate vendor records.
• One way in per vendor. Don't let the same vendor arrive by bank feed and by bill.
• Keep a coding sheet for your top 20 vendors: vendor, account, and the rule for exceptions. It's the difference between a policy and a habit.
• Re-run Step 1 every month, as part of the close.

Why this matters more than it looks

Say an $8,000 freight bill is coded to marketing instead of cost of goods. Gross margin looks $8,000 better than it is, marketing looks $8,000 over budget, and someone spends a meeting chasing a marketing overspend that never happened. If your budget is built on categories that roll up accounts, a vendor wandering between accounts moves dollars between budget lines, and the variance shows up in the wrong place.

Where a checkup comes in

This is one of the 15 checks in DrillFi's Financial Check Up: the same vendor landing in a different account than usual. Each finding is tied to the exact transactions, ranked by dollars, so you start with the ones that move your margins. The same run also flags look-alike vendor names that split your spend. See a sample finding.

DrillFi Financial Check Up is an advisory service. It is not an audit, review or compilation, and it is not tax preparation or legal advice. QuickBooks menus, report names and plan features change over time, so check each step against your version.