How to Detect Unauthorized Charges on Your Bank Statement

Quick Answer: Convert your bank statement to CSV using [QuickBankConvert](/), then sort and filter transactions by merchant, amount, and frequency to quickly identify unauthorized charges, duplicate transactions, and suspicious patterns that are easy to miss on a PDF.

Why Fraud Detection on Bank Statements Matters

Bank fraud and unauthorized charges cost Americans billions of dollars every year. The Federal Trade Commission reports millions of fraud complaints annually, and a significant portion involves unauthorized bank account transactions. What makes this especially troubling is that most victims do not notice fraudulent charges for weeks or even months after they first appear.

The reason is simple: bank statements are hard to read. PDFs present transactions in dense, chronological rows. A $12.99 subscription charge from an unfamiliar merchant buried between grocery purchases and a utility bill is easy to overlook — especially across multiple pages of a monthly statement.

Converting your statement to a structured CSV and systematically analyzing the data changes everything. Patterns that are invisible in a PDF become obvious in a spreadsheet. A fraudulent merchant that charged you $4.99 in March, $9.99 in April, and $14.99 in May is immediately visible when you sort by description. A duplicate charge for the same amount on the same day stands out when you use a duplicate detection formula.

This guide provides a systematic, spreadsheet-based approach to fraud detection that any bank customer can use — no technical expertise required.

Types of Unauthorized Charges to Watch For

Small Recurring Charges

Fraudsters frequently test stolen card numbers with micro-transactions of $1 to $10 before escalating to larger purchases. These small charges often go unnoticed for months. When sorted by amount in ascending order, they stand out immediately as unfamiliar merchants at the bottom of the list. A fraudster who successfully tests a card number will often sell that information or escalate to larger fraudulent purchases within days or weeks.

Duplicate Transactions

A merchant may accidentally or deliberately charge you twice for the same transaction. Same merchant, same amount, on the same or adjacent dates — this is a clear duplicate that warrants a dispute. Duplicate charges happen more often than most people realize, particularly for online purchases and restaurant transactions where the payment system sometimes processes the authorization twice.

Unfamiliar Merchant Names

Credit card and debit processors often display truncated or coded merchant names that look unfamiliar even for legitimate purchases. However, a name you genuinely cannot explain after investigation may indicate fraud. Common patterns include generic names like "SERVICES LLC," foreign payment processors, or digital goods vendors with unfamiliar brand names.

Subscription Charges You Did Not Authorize

Free trials that converted to paid subscriptions, services you cancelled that kept charging, or subscriptions in a family member's name that were never cancelled — these show up as recurring monthly charges that can persist for years. The average American has 4 to 6 active subscription charges, and a significant percentage of people have at least one subscription they forgot about and no longer use.

Geographic Anomalies

Transactions in cities or countries you have not visited recently are strong fraud indicators. If your statement shows a purchase at a hardware store in Dallas on a day you were in Chicago, or a transaction in a foreign country you have never visited, that warrants immediate investigation. Many banks flag these automatically, but not all do.

How to Extract and Analyze Statement Data

Step 1: Download Your Statements

Download the last three months of statements from your bank's online portal as PDFs. If you suspect fraud going back further, download six to twelve months. Start with the most recent statement and work backwards.

Step 2: Convert to CSV With QuickBankConvert

Upload each PDF statement to [QuickBankConvert](/) to convert it to a clean CSV file. The conversion happens entirely in your browser — your financial data is never transmitted to any server. Each row in the resulting CSV represents one transaction with date, description, and amount columns. This structured format is the foundation for all your analysis steps.

Step 3: Open in a Spreadsheet

Open the CSV in Excel or Google Sheets. This immediately gives you sorting, filtering, and search capabilities that a PDF simply cannot provide. If you have multiple months to analyze, combine them into one sheet by copying all transaction rows into a master spreadsheet.

Six Techniques to Find Unauthorized Charges

Technique 1: Sort by Amount (Ascending)

Sort all transactions from smallest to largest amount. Look at the smallest negative amounts — these are where micro-transaction fraud hides. Any recurring small charge to an unfamiliar merchant name deserves investigation. Legitimate subscriptions like Netflix, Spotify, or Amazon Prime have consistent amounts; unexpected small charges to unknown names are red flags.

Technique 2: Sort by Merchant Description

Sort alphabetically by the description column. This groups all charges from the same merchant together, making recurring charges immediately visible. You can instantly see how many times you were charged by each merchant and whether the amounts are consistent. Inconsistent amounts from the same merchant may indicate price escalation fraud.

Technique 3: Filter for Duplicates

Use a spreadsheet formula to flag potential duplicates. In Excel, add a helper column and use COUNTIFS to count rows with the same date, description, and amount. Any count greater than 1 indicates a potential duplicate. Review each flagged row manually before disputing — legitimate transactions can share the same description and amount if you made the same purchase twice.

Technique 4: Look for International or Unusual Merchant Names

Filter the description column for common indicators of foreign transactions: currency codes like EUR or GBP, country names, or phrases like "INTL" or "FOREIGN." Any international charge you cannot explain should be investigated immediately.

Important: If you find a transaction you do not recognize, do not immediately assume fraud. Search the exact merchant name in Google — many legitimate purchases appear under the parent company's name rather than the brand you recognize.

Technique 5: Identify Unauthorized Subscription Charges

Filter for transactions that repeat on or near the same date each month with the same amount. Create a list of all your known subscriptions and compare against the recurring charges in your CSV. Any recurring charge not on your known list requires investigation. Check whether the amount matches any service you use, even if the merchant name looks unfamiliar.

Technique 6: Reconcile Against Receipts and Emails

For your largest transactions, find the receipt or confirmation email. Any large purchase you cannot match to a receipt or confirmation is a serious red flag. Many email providers allow you to search for "receipt," "order confirmation," or "invoice" to quickly surface all purchase confirmations from the past few months.

What to Do When You Find an Unauthorized Charge

Step 1: Verify It Is Actually Unauthorized

Search the merchant name online. Check with household members who share the account. Look at your email for any subscription confirmation you may have forgotten. Many disputes turn out to be legitimate charges with unfamiliar display names. Amazon, Apple, Google, and PayPal all process payments for thousands of third-party vendors whose names appear on your statement rather than the familiar brand name.

Step 2: Document Everything

Screenshot the transaction in your online banking portal. Note the date, amount, merchant name, and transaction ID. Save your converted CSV as a record. This documentation is critical when filing a dispute — banks resolve disputes faster when you can provide specific transaction details.

Step 3: Contact Your Bank Immediately

Call your bank's fraud line or file a dispute through the online portal. Under the Electronic Fund Transfer Act, you have up to 60 days from when the statement was provided to dispute unauthorized electronic transactions. Acting quickly is critical — the sooner you report, the better your chances of full recovery.

Pro Tip: Export your statement to CSV with [QuickBankConvert](/) before calling your bank. Having organized transaction data makes the fraud reporting conversation significantly more efficient and helps you provide precise details about every suspicious charge.

Step 4: Request a Card Number Change

If you find evidence of card fraud — not just an accidental double charge — ask your bank to cancel the compromised card and issue a new one with a different number. This prevents any further fraudulent charges on the compromised card number.

Step 5: Monitor for Further Activity

After filing a dispute, continue monitoring your account weekly for the next two to three months. Fraudsters who have your information may attempt further charges, sometimes waiting weeks between attempts to avoid triggering automated fraud detection systems.

Building a Regular Statement Review Habit

The best fraud detection is systematic and proactive. Set a calendar reminder to review your bank statements monthly using this process:

1. Download last month's statement PDF
2. Convert to CSV with QuickBankConvert
3. Spend 10 minutes sorting and scanning for unfamiliar charges
4. Update your subscription list with any new authorizations
5. Confirm all large transactions against receipts or emails

Most people who discover bank fraud do so accidentally, often months after the first unauthorized charge. A monthly 10-minute review catches fraud early — before small test charges grow into large fraudulent transactions and before the dispute window closes.

The time investment is minimal compared to the financial protection it provides. A single fraudulent subscription caught and cancelled within the first month saves $120 to $300 per year compared to letting it run undetected for a year. A card fraud incident caught within days instead of months might prevent $500 to $5,000 in additional fraudulent charges.

[QuickBankConvert](/) makes this routine fast and private. Your statements never leave your browser, so you can review them as frequently as you like without any security risk from uploading sensitive financial data to third-party servers.

Advanced Fraud Detection: Patterns and Red Flags

Beyond the basic techniques, experienced fraud detectors look for subtle patterns that indicate systematic rather than one-time fraud. Understanding these patterns helps you differentiate between isolated incidents and ongoing attacks on your account.

Escalation Patterns

The most common fraud pattern starts with a small test transaction — often $1 to $5 — followed by progressively larger charges if the test succeeds. If you find a small unfamiliar charge, do not assume it is isolated. Immediately review the following two to four weeks of transactions for larger charges from any unfamiliar merchant, regardless of whether the merchant names match the initial test charge. Fraudsters often use different merchant names for escalation transactions.

Velocity Attacks

Some fraudsters make multiple small purchases in rapid succession rather than one large purchase, hoping each individual charge falls below your bank's automatic alert threshold. A pattern of five to ten $15 to $25 charges appearing in the same day at unfamiliar merchants is a velocity attack signature. These are easy to spot when you sort by date and scan for clusters of unfamiliar transactions.

Account Takeover Indicators

Account takeover fraud is different from card number theft. If a fraudster gains access to your online banking credentials, you might see: changes to your contact information (phone number or email), new payees added to bill pay, wire transfers or ACH pushes to unfamiliar accounts, or debit card replacement requests. These actions do not always appear as typical transactions in your statement, but bill pay payees and wire transfers do. Scan your CSV for any transfer to an unfamiliar account name or external transfer that you did not initiate.

Subscription Escalation

A common fraud pattern exploits free trial offers. A fraudster using stolen card information signs up for a service with a free trial, knowing the card will be charged when the trial expires. The initial charge appears legitimate (free trial or $1 verification charge), followed by a full subscription charge weeks later. Filter your statement CSV for any charge from merchants you do not recognize that followed an earlier $0 or $1 charge from the same or similar merchant name.

Staying vigilant and converting your statements monthly with [QuickBankConvert](/) is the best defense against all these fraud patterns. Early detection limits your financial exposure and gives you the best chance of full recovery through your bank's dispute process.