Categorize bank transactions
“show every bank transaction from our bank transactions and keyword list, match description words to categories, and add a Status that says "Agrees" when it fits, else a short reason on rows to review”
show every bank transaction from our Bank transactions and Category keyword list, match description words to categories, and add a Status that says "Agrees" when it fits, else a short reason on rows to review
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileBank transactionsCSV export · 30 rows
- FileCategory keyword listCSV export · 23 rows
- StepAdd join keyStep 1
- StepAdd join keyStep 2
- JoinBring keywords30 of 30 paired
- StepChoose categoryStep 4
- ResultBank transaction review30 rows · 6 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 30 rows came out, and the join paired 30 of 30 rows.
- Download Bank transactions sample (30 rows)Bank: Transactions > Export CSV
- Download Category keyword list sample (23 rows)Spreadsheet tab: Category Rules
What you get back
The result of that run, the rows to look at first.
| Date | Description | Amount | Transaction ID | Category | Status |
|---|---|---|---|---|---|
| 2026-10-14 | STRIPE PAYOUT 2026-10-13 | 7,310.44 | bk_txn_1021 | · | No keyword match |
| 2026-09-17 | STRIPE PAYOUT 2026-09-16 | 6,842.15 | bk_txn_1007 | · | No keyword match |
| 2026-10-21 | REMOTE DEP ACH CASH APP | 5,198 | bk_txn_1027 | · | No keyword match |
| 2026-10-21 | REMOTE DEP ACH CASH APP | 5,000 | bk_txn_1028 | · | No keyword match |
| 2026-10-14 | STRIPE PAYOUT 2026-10-13 | 7,310.44 | bk_txn_1022 | · | No keyword match |
| 2026-10-12 | BANK SERVICE FEE | -15 | bk_txn_1020 | · | No keyword match |
| 2026-10-02 | OFFICE DEPOT 1149 | -76.88 | bk_txn_1014 | Office Supplies | Agrees |
| 2026-09-05 | AMZN Mktp US*F2K9D Office Desk | -248.70 | bk_txn_1001 | Office Supplies | Agrees |
| 2026-09-24 | FEDEX 7712 SHIPPING | -38.90 | bk_txn_1010 | Shipping | Agrees |
| 2026-09-15 | RENT AUTOPAY HARBOR LOFTS OCT | -4,200 | bk_txn_1006 | Rent | Agrees |
| 2026-09-22 | PINTEREST ADS 8841 | -560 | bk_txn_1009 | Advertising | Agrees |
| 2026-09-08 | GSUITE *OAKLEDGER APP SUBSCRIPTION | -96 | bk_txn_1002 | Software | Agrees |
How do you categorize bank transactions by matching description words to a category list?
Upload your bank export and your category keyword export. Mammoth matches words in each transaction description to your category list, then adds a Status for each row. Rows that match show Agrees, and rows that do not match show a short reason to review.
How it works
How to use the Bank transaction review workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Bank transaction review: questions
What export should you use for this workflow?
What happens to rows that do not match any category keyword?
How do you change the categorization rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent
- Code transactions to GL accountsUse exported QuickBooks files to code card and bank transactions to GL accounts, apply vendor rules, and flag rows with no rule.See the workflow Built by the agent
- Deferred revenue scheduleSpread Stripe invoices over service months and track month-end deferred revenue in one workflow.See the workflow Built by the agent
- Fixed asset register and depreciationBuild a fixed asset register from exported QuickBooks buys, asset life schedules, and account lists. Calculate straight-line monthly depreciation and net book value.See the workflow Built by the agent
- Map a chart of accounts to a new oneMap a QuickBooks trial balance to a new Xero chart of accounts, then flag unmapped, duplicate, and not mappable accounts.See the workflow Built by the agent
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the workflow Template