Categorize bank transactions in Excel

Updated 28 September 2026 · Edoardo Panichi, maker of Hunch

=HUNCH.PICK reads a raw transaction description like AMZN Mktp US*2K3LH0 and returns one budget category from the list you give it. Amounts and dates never touch the formula; they stay exactly where they are, in ordinary Excel columns and formulas.

The formula

Point it at the description column from your bank or card export, the one full of merchant codes and reference numbers. The formula reads the merchant name inside the noise and ignores the rest.

Write categories that match your statement

Bank exports repeat the same handful of merchants every month once you have shopped somewhere twice, so the category list only needs to cover the kinds of spending you have. Add a description after a colon for anything your team might disagree on, such as shopping: retail purchases, not groceries or dining, so a bookstore and a supermarket do not land in the same bucket.

Real outputs

Ten lines pulled from a small business card statement, with the model's answers as returned on 28 September 2026.

Nine of the ten land where you would expect, including two dining rows from different card processors, TST* and SQ *, both read correctly past the point-of-sale prefix to the merchant behind it. The one worth questioning is CHASE CREDIT CRD AUTOPAY: the model puts it under fees and interest, but a credit card autopay is usually money moving to pay the bill, not a fee at all. That is what happens when a category list has no transfer option: the model picks the closest label on the list instead of telling you none of them fit. Add a ninth option, such as transfer: moving money between your own accounts, not a purchase, and the same row would likely land there instead.

Keep the math in Excel, not in the question

Hunch does not read the amount column and cannot compare dates, so leave both jobs to formulas that already do them well. Once column B holds a category, a normal SUMIF gives you spend by category for the statement:

A PivotTable on columns B and C turns the same output into a monthly report, and a plain filter on category = "other" is where to look first when a total does not add up. An "other" row means the description did not clearly match any category you gave it.

Limits

• The model reads the description text only. Amount, date, account and card-last-four stay in their own columns and their own formulas.
• Descriptions from different banks vary in format, but merchant names inside them are usually legible enough for a category pick.
• One credit per categorized row. Blank cells and exact duplicate descriptions inside one column are free, which matters here since the same merchant repeats often.
• Transaction text passes through to compute the answer and is not stored by Hunch.

Setup in three steps

1. Sideload the add-in from hunchsheet.app/excel.
2. Save your key once: =HUNCH.SETKEY("hunch_..."), then delete the cell.
3. Paste your exported description column into A2 and fill the formula down to match.

See also

• HUNCH.PICK reference for the full argument list.
• Text classification in Excel, the general pattern behind this guide.
• AI formulas in Excel, an overview of all four formulas.

Questions

Reference: HUNCHPICK

More guides

• Categorize expenses in Google Sheets Expense categorization
• Text classification in Excel with a formula Classification
• Categorize support tickets in Excel Ticket triage
• AI formulas in Excel that return a number AI formulas
• Sentiment analysis in Excel with one formula Sentiment