# Find Tax Deductions in Bank Statements, Row by Row

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Tax time on a budget
- Canonical: https://cheapbankconvert.com/blog/find-tax-deductions-in-bank-statements

> Find tax deductions in bank statements: filter the rows by payee, tag the deductible ones, and total them by category for your return.
To find tax deductions in bank statements, load a full year of rows into one spreadsheet, filter the payees that tend to be deductible, and tag each keeper with a tax category and a short reason. Then total the tags. The statement shows who you paid, when and how much, which covers most of what a deduction needs.

## Which bank statement rows can hold tax deductions?

Deductible rows are payments that a tax rule lets you subtract: business costs if you are self-employed, and a narrower set of personal costs if you itemize. On a statement they look like any other debit. What marks them is the payee and the purpose, so the search starts from a list of payee types worth a second look.

For a freelancer or sole owner, the richest rows are usually business ones. Software plans, advertising, a coworking desk, shipping labels, professional insurance, trade association fees, bank charges on a business account and payments to subcontractors all appear as plain debits. Each one may belong on a business schedule, and [Schedule C expenses from bank statements](/blog/schedule-c-expenses-from-bank-statements) shows how those rows map to the form's expense lines.

Personal rows matter only if you itemize. The usual candidates are mortgage interest, state and local tax payments, gifts to charity and large medical bills. Most of these arrive with a year-end form from the lender, the state or the charity, so the bank row is a cross-check more than the main record.

Then there are mixed rows: a phone bill, home internet, rent or utilities when part of the home is an office. Only the business share counts, so these rows need a percentage, not a yes or no. The rules for the home part are covered in [home office expenses from bank statements](/blog/home-office-expenses-from-bank-statements).

Credit card statements belong in the search too. A business expense paid on a personal card is still a business expense, and many small owners put most of their spending on one card.

## Getting a year of statement rows into one deduction sheet

A deduction sheet is one spreadsheet holding every row from every account for the tax year, with the same columns throughout: date, account, payee, amount and a blank tag column. You need all twelve months from checking, savings and every card in one place, or the filters in the next step will miss rows.

The fastest source is the bank's own export. Most online banking sites let you download recent activity as CSV, and some reach back a full year or more. Download each account separately, then paste the files under one header row. Add an account column before you paste so you can tell a card charge from a checking debit later.

When the export does not reach back far enough, the PDFs are what you have. Retyping a year of rows is slow and invites typos in the amounts. A converter turns each PDF into rows instead. CheapBankConvert, which is not open yet, is meant for exactly this: you pay once per statement at its early prices, and the free preview shows the first two pages as rows before you spend anything. The [CheapBankConvert homepage](/) has the current prices.

If you plan to repeat this every year, or every month, set the import up once. [Reusing a Power Query for monthly statements](/blog/reuse-power-query-for-monthly-statements) shows how to point one query at a folder so each new file lands in the same table with the same column types.

Before you search, check that the sheet is complete. Each account should have twelve statement periods. A quick pivot of row counts by month and account shows a gap at once, such as a card month that never got downloaded.

## Filtering payees on the statement for likely deductions

Filtering payees means narrowing hundreds of rows to the few dozen that could be deductible, by searching the description column for words and merchant names linked to deductible spending. Sort by payee first so repeats sit together, then filter with a short list of search terms. You will still read each match, but you read far fewer rows.

### A filter pass, step by step

1. Sort the whole sheet by the payee column, A to Z.
2. Add a helper column that flags a match, such as `=IF(ISNUMBER(SEARCH("insur",C2)),"check","")`, where column C holds the payee.
3. Run the helper for each term on your list and tag matches as "check".
4. Filter the tag column to "check" and read every row it shows.
5. Clear the flag from rows you rule out, so the final filter shows only keepers.

Useful terms depend on your work, but a starting list for a self-employed person might include insur, software, hosting, domain, ads, postage, ship, supply, office, cowork, license, dues, bank fee, interest and the names of tools you pay for. For itemizers, add donate, church, foundation, clinic, pharmacy, county and tax.

Sorting by amount is a second pass worth doing. Read the fifty largest debits of the year. Big deductible items, such as a laptop for work, an annual insurance premium or a county property tax payment, tend to be there, and a search term would not have caught a vague description like a store name.

Transfers between your own accounts and card payments from checking are not spending. Filter them out before you total anything, or a card payment will count the same purchases twice.

## Tagging each deduction row with a category and a reason

A tag is a short label in the tag column that names the tax category a row belongs to, plus a few words on why. The category lets you total the rows. The reason is what you will need if anyone asks about the row in two years, because a payee name such as "SQ *JLM" means nothing by then.

Keep the categories few and close to the lines on the form you file. For a business, that might be advertising, insurance, office expense, supplies, software, contract labor, bank charges and travel. For personal itemized rows, use charity, medical, taxes paid and mortgage interest. A shorter list keeps you from tagging the same kind of cost two different ways in March and November.

Write the reason as a plain fact: "logo design for client site", "annual liability policy", "half of internet, home office". Add a share column for mixed rows and enter the business percentage there, so the sheet can multiply the amount by the share.

The IRS lists account statements and credit card statements among the supporting documents for expenses on its [what kind of records should I keep](https://www.irs.gov/businesses/small-businesses-self-employed/what-kind-of-records-should-i-keep) page. It also says a mix of documents may be needed to support every part of an expense. That is why the reason column matters: it records the business purpose the bank line leaves out.

## A worked deduction tally from twelve statement months

The tally is a pivot or SUMIF table that adds the tagged rows by category, using the business share for mixed rows. It gives you one number per category to carry to your return or hand to your preparer, and it points back to the rows behind each number.

The table below is a worked example for a self-employed designer. The payees, amounts and shares are made up for illustration.

| Category (example) | Rows | Statement total | Business share | Deductible total |
| --- | ---: | ---: | ---: | ---: |
| Software plans | 26 | 1,184.40 | 100% | 1,184.40 |
| Advertising | 9 | 615.00 | 100% | 615.00 |
| Contract labor | 4 | 2,350.00 | 100% | 2,350.00 |
| Business insurance | 1 | 438.00 | 100% | 438.00 |
| Bank charges, business account | 12 | 144.00 | 100% | 144.00 |
| Phone | 12 | 780.00 | 40% | 312.00 |
| Home internet | 12 | 840.00 | 30% | 252.00 |
| **Total** | **76** | **6,351.40** | | **5,295.40** |

Read it column by column. The statement total is what left the accounts. The deductible total is what counts once the personal share comes off. The phone and internet rows show why the share column exists: without it, $1,056 of personal use would have slipped into the total.

To build it, use `=SUMIFS(F:F, D:D, "Software plans")` where column F holds amount times share and column D holds the tag. A pivot table on the same columns gives the same result and lets you click a total to see its rows.

Save the sheet with the year in the file name and keep it with the PDFs. If a number on the return is ever questioned, you can show each row that built it.

## Statement deductions that need more than the bank row

Some deductions cannot rest on the bank line alone. The statement proves a payment, but it does not show what you bought, who it helped or whether the purpose was business. For those rows, pair the line with a receipt, invoice, written acknowledgment or log before you claim it.

Charity is the clearest case. A gift above a set size needs a written acknowledgment from the charity, not only a bank debit, so check for the letter or email before you tag the row as final. Meals and travel need a note of who, where and why. Vehicle costs need a mileage record. Equipment may need to be depreciated over years rather than deducted at once, so a large purchase row deserves a question to a preparer.

Cash is the gap no statement can fill. An ATM withdrawal later spent on supplies shows up only as a withdrawal, so a cash expense needs its receipt.

A useful habit is a fourth column, "proof", with values such as "statement only", "receipt saved" or "letter needed". Filter it to "letter needed" in January and chase the missing paper while it is still easy to get.

## Is a deduction search worth it if you take the standard deduction?

A full search of personal rows is wasted effort if you will take the standard deduction, because itemized costs then change nothing on the return. Business rows are different: a self-employed person deducts business costs on top of the standard deduction, so those rows are worth finding every year.

A quick test tells you which case you are in. Add up the big itemized items from their year-end forms, such as mortgage interest, state and local taxes and charity. If the sum is well below the standard deduction for your filing status, stop searching personal rows and spend the time on business ones.

The same logic applies to tiny categories. Chasing a $12 fee is not worth an hour. Tag what you see and move on. The large rows and the regular ones carry most of the total.

The one mistake to avoid is mixing the two kinds. A business cost tagged as a personal itemized item can disappear if you take the standard deduction, so keep business tags and personal tags in separate categories from the start.