Guides

Custom Categories for Bank Statements

Suggest Edits

The Custom Categories Setup feature in the US Bank Statement – Analytics API allows businesses to define their own set of categories and subcategories for categorizing transactions, enabling more personalized and precise financial insights.

Getting Started with Custom Categories

1. Enable Categorisation

Begin by toggling the Categorisation switch in your bank statement analysis settings.

  • On: Transactions will be automatically assigned categories.
  • Off: You will receive raw, uncategorized transaction data.

You must enable categorisation to use Basic Analysis analytics type, including custom.

2. Select Analytics Type

Choose the categorization scheme that fits your business requirements.

  • MCA Categories – Designed for Merchant Cash Advance (MCA) workflows (Revenue, MCA Debits, Debt, Fees).
  • Business Cash Flow – Follows traditional accounting buckets (Operating, Investing, Financing).
  • Basic Analysis – Standard general-purpose categories., OR your own tags and definitions based on uploaded CSV data.

To choose a type:

  • Navigate to the Select Analytics Type dropdown at the top.
  • Select Basic Analysis to enable user-defined categories.


3. Upload Custom Categories CSV

To define your own categorization logic:

  1. Go to Settings > Database Tables
  2. Upload a file named: dynamic_categorization.csv: Sample CSV
  3. Format: A CSV file with at least two columns – category and subcategory.

Sample format:

category,subcategory
Income,Salary
Income,Freelance
Income,Interest
Expense,Groceries
Expense,Utilities
Expense,Transport
Expense,Entertainment
Expense,Medical
Transfer,Internal Transfer
Transfer,Credit Card Payment
Loan,Loan Repayment
Loan,Loan Disbursement
Investment,Stocks
Investment,Mutual Funds
  • The associated category and subcategory pair will be applied when a match is found.

Sample CSV File

This setup allows complete flexibility to define revenue, expenses, or any other tag your analysis requires..

4. Upload Bank Statements

To run your analysis:

  • Navigate to the Upload Document section.
  • Select a file under the US Bank Statement type.
  • Click Submit to begin processing.

After the document has been processed, the following fields will be populated for each transaction in the extracted transaction table:

  • Category
  • Subcategory
  • Merchant


Transactions will be automatically categorized using the selected analytics type, including your custom definitions if applicable.

Updated about 14 hours ago