Software spend guides for bookkeeping firms
How to find duplicate subscriptions in a client's QuickBooks Online file
Sort them into three kinds first: the same charge recorded twice, the same tool paid for twice, or two tools that do the same job. Run Transaction List by Vendor for 12 months to catch charges recorded twice, then group lines by product across every card and bank account to find tools paid twice or overlapping. Fix recording errors in the file, and take the spending questions to the client.
A duplicate subscription in QuickBooks Online is one of three things: the same charge recorded twice, the same tool paid for twice, or two tools that do the same job. Each one needs a different report and a different fix, so sort them before you raise anything with the client.
The first kind is a bookkeeping error, and you fix it in the file. The second and third are spending questions, and the client decides what to do. Mixing them up is how a cleanup note turns into an awkward conversation.
Which kind of duplicate are you looking at?
The same charge recorded twice. A bank feed line gets added instead of matched, or a recurring template keeps posting next to the feed. The vendor, date and amount line up, and only one payment left the bank.
The same tool paid twice. Two accounts for one product, often on two cards or one card plus bill pay. Both payments are real. The descriptors often differ, so the vendor list can show two names for one product.
Two tools doing one job. Two project boards, two meeting apps, two e-signature tools. Both are real payments to different vendors, and only the client knows whether both are needed.
Step 1: rule out recorded-twice errors
Start here, because a doubled entry inflates everything you look at next.
Run Transaction List by Vendor for the last 12 months and sort by vendor, then date. Look for pairs with the same vendor, the same amount and dates a few days apart. Open each pair. If one is a bank feed match and the other was added by hand, or one came from a recurring template, you have a recorded-twice error.
Then open the recurring transactions list (the gear menu, then Recurring transactions) and compare each template's amount and next date with what the bank feed shows. A template that keeps posting after a price change or a cancellation is a common source of doubles.
Fix these in the books before you go further. They are not findings for the client.
Step 2: group the same tool under one name
Run Transaction Detail by Account on the accounts where software lands. In most files that is a software or dues and subscriptions expense account, plus Uncategorized Expense and any holding account the firm uses.
Read the payee and the memo together. A processor name such as "PAYPAL *" or "STRIPE" hides the real vendor in the memo. Write the product name next to each line, then sort by it. Two different payee names for one product are now side by side.
If the same vendor exists twice in the vendor list, you can merge the two vendor profiles in QuickBooks Online (Vendors, select the one you do not want to keep, Edit, then Merge contacts). Merging moves its past transactions to the vendor you keep and cannot be undone, so pick carefully (Intuit help: merge duplicate vendors, updated August 5, 2026). That is housekeeping, and it does not answer whether the client needs both accounts.
Step 3: check every payment method
Same-tool duplicates hide across payment methods. One person pays on a company card, and a second account is paid by bill pay or ACH from the operating account. A card statement shows half of it. The ledger shows both, as long as every bank and card account is in the books.
Filter the same report by account and confirm that each card and bank account in the file appears. A missing card account is the most common reason a review misses a duplicate.
Step 4: list overlapping tools, without guessing
For the third kind, list tools by what they do: chat, meetings, project boards, file storage, e-signature, design. Two paid tools in one row is worth a question. It is not a finding that one of them is unused. The books show what was paid, and nothing about who opens either tool.
What to bring to the client
Keep it to a short table the client can answer line by line. Fictional example (made-up client, made-up tools):
- MEETLINE*TEAM: product Meetline, how paid Company card, monthly amount $45.00. Question: Two Meetline accounts?
- Meetline Inc: product Meetline, how paid Bill pay, monthly amount $45.00. Question: Two Meetline accounts?
- Taskboard Pro: product Project board, how paid Company card, monthly amount $96.00. Question: Both boards still needed?
- TASKMINT.IO: product Project board, how paid ACH, monthly amount $64.00. Question: Both boards still needed?
Write what the ledger shows and ask the question. Leave the decision with the client.
Where this gets slow, and what a scheduled review changes
Steps 2 to 4 are reading work: payee names, memo lines, rails, dates. On one client it takes careful reading. Across a book of QuickBooks Online and Xero clients it competes with close.
ShadowLedger does that first pass from the payments. It takes a QuickBooks Online or Xero export, or a CSV from other books, and flags charges that repeat, possible duplicate vendors, amounts that changed, and renewals you can see from the charges. In the report, fixed rules calculate every figure. AI only suggests vendor names, flagged for review. On the Firm plan you can connect QuickBooks Online or Xero directly instead of exporting, and you get a white-labeled findings report to share under your firm's name. Connected clients on the Pro and Firm plans are re-scanned weekly.
Built from payments in the ledger, no seat or login data needed.
To try it on one client first, run the free CSV audit on one company's export. It needs no card. For the whole book, the Firm plan is $15 per client per month with a 4-client minimum ($60 a month), and the Firm trial runs 14 days. Data handling is on the security page and in the DPA.
Related reading: reading vendor names and memo lines, why the books beat a card-only feed, what QuickBooks can and cannot show and the company-owner version of this check.
FAQ
How do I find duplicate transactions in QuickBooks Online?
Run Transaction List by Vendor for the period, sort by vendor and date, and look for pairs with the same vendor and amount a few days apart. Open each pair. If one was added by hand or posted by a recurring template next to a matched bank feed line, it is a recorded-twice error to fix in the books.
Is a duplicate vendor the same as a duplicate subscription?
No. Two vendor records can point to one product with one account, which is a list cleanup. A duplicate subscription means two real payments for the same product, often on different cards or rails. Group lines by product name before you decide which one you have.
Can the books show which of two tools the client uses?
No. The ledger records what was paid, how it was paid and when. It does not show who opens a tool. Bring both lines to the client as a question.
Which QuickBooks Online accounts should I check for software?
The software or dues and subscriptions expense account, Uncategorized Expense, any holding account the firm uses, and every card and bank account in the file. Software is often paid from more than one place.