How to spot repeat software charges in a QBO or Xero ledger

Many clients pay for software they can't list from memory. The charges are already in the books. They sit under vague vendor names, card processor prefixes, and memo lines that nobody reads twice.

This post walks through a manual way to find them in a QuickBooks Online or Xero ledger. Start with a client you know well.

Start with the right report

Pull 12 months of transactions. A shorter window misses annual renewals, and those are often the largest software charges a client has.

In QuickBooks Online, run Transaction Detail by Account or Transaction List by Vendor for the date range. Filter to the expense accounts where software usually lands, such as Software, Dues and Subscriptions, Computer and Internet, and Office Expenses. Add Uncategorized Expense too, plus any holding account the firm uses, such as Ask My Accountant, because a lot of software ends up there.

In Xero, run the Account Transactions report for the same accounts and range. Show the Description and Reference columns. On bank statement lines, the useful text is often in those fields and not in the contact name.

Export the report to a spreadsheet, where sorting is faster.

Read the vendor name, then the memo

The vendor or contact name is the first clue, but it is often wrong or incomplete. Bank rules assign names based on whatever match someone set up years ago. A rule that maps every line containing "PAYPAL" to one contact can hide several different tools under one name.

So read the memo or description line next. That is the raw text from the bank or card feed, and it usually carries more detail. Watch for these patterns:

• Processor prefixes like "PAYPAL *", "SQ *", or "STRIPE" followed by a short merchant name. The name after the prefix is the real vendor.
• App store billing, such as "APPLE.COM/BILL". One line on the statement can stand for several separate subscriptions.
• Cut-off names. Card feeds often truncate merchant names, so "TASKBOARDPRO SUBSCR" and "TASKBOARD PRO INC" may be the same vendor.
• Words like "subscription", "monthly", "annual", "renewal", "plan", or "license" anywhere in the line.
• A web address or support phone number where a store would show its city. Online merchants often put these in the card descriptor.

Look for the rhythm in the dates

A repeat software charge has a pattern. Sort the export by vendor, then by date.

Monthly tools show up on about the same day each month, give or take a few days for weekends. Annual tools show up once, so check the prior year for the same vendor in the same month. A flat amount month after month points to a subscription. An amount that steps up and then stays flat usually means the client changed plans.

A charge that changes every month is less likely to be a plain subscription. It may be metered billing, or it may be ordinary purchases from a vendor that also sells software. Flag it as a question instead of counting it.

Group the same tool under one name

Clean up names before you count anything. Add a column with one plain name per tool. In the fictional example below, "MEETLINE.IO 888-555-0100", "MEETLINE INC", and "PAYPAL *MEETLINE" all become Meetline.

Then add up 12 months for each tool. The client cares about the yearly total more than the monthly figure, because the monthly figure always looks small.

Check every payment method

The same tool can be paid through more than one route. Look across the operating account, each company card, and any owner card that gets reimbursed through expense claims. The same tool on two cards, or two tools that do the same job, is worth a question.

Write down what you found, not what you assume

A payment tells you that money left the business. It does not tell you who uses the tool or whether anyone opened it this year. Only the client knows that.

Keep the list factual. For each tool, record the plain name, the payment method, how often it bills, the last charge date, and the 12-month total. Add a column for questions, such as "Is this still needed?" or "Two project tools. Is one left over?"

Here is an example. Northpine Landscaping is a made-up client, and the tools and numbers are fictional.

• Meetline: Company card, Monthly, $1,080
• Taskboard Pro: Operating account, Monthly, $720
• FieldRoute Planner: Owner card, Annual, $1,450
• Taskmint: Company card, Monthly, $600

Taskboard Pro and Taskmint are both project tools. That pair is the first question to ask the Northpine owner.

Where this gets slow

The manual method works. It gets slow when you repeat it across 30 or 60 clients, each with different bank rules and naming habits. Reading vendor names and memo lines takes most of the time.

ShadowLedger does a 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. 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.

FAQ

What is the best report for finding software charges in QuickBooks Online?

Transaction Detail by Account works well. Run it for 12 months, filter to software, subscription, and uncategorized expense accounts, and export it. Then sort by vendor and date.

Where do software charges hide in Xero?

They often sit in the Description or Reference of bank statement lines, under a contact name set by an old bank rule. Run the Account Transactions report and read those columns along with the contact name.

How can I tell a subscription from a one-off purchase?

Look for the same vendor billing on about the same day each month, or once a year in the same month. A flat amount, or one that steps up and then stays flat, points to a subscription.

Does a software charge in the ledger mean the client uses the tool?

No. A ledger shows payments. It does not show who uses a tool. List what the client paid and ask them whether each tool is still needed.

If you want to see this on one client first, run the free audit on one company's CSV. It needs no card. Upload an export and review the findings.