DocuClipper logo
Transaction Categorization

How DocuClipper Transaction Categorization Works

Define categories and keywords to automatically categorize bank transactions in DocuClipper. Use the default set, build custom groups, or upload a vendor CSV.

The Transaction Categorization feature lets you organize bank transactions into categories using keywords. You can use the built-in default categories, create custom groups, or upload a vendor CSV to categorize in bulk.

Note: Transaction categorization is available on Professional, Business, and Enterprise plans.

Where to find it

Open a converted bank statement and click Categorize (next to Reconcile in the Summary Table).

Automatic categorization with default categories

DocuClipper includes a built-in set of 15 default categories: Miscellaneous, Travel, Debt Payments, Savings and Investments, Education, Shopping/Retail, Entertainment, Healthcare, Insurance Premiums, Transportation, Eating Out/Dining, Groceries, Rent or Mortgage, Bills and Utilities, and Income.

To run automatic categorization:

  1. Navigate to Categorize.
  2. Make sure the Category dropdown is set to default.
  3. Click Categorize.

DocuClipper matches each transaction's description against its vendor database and assigns a category.

Adding and editing keywords

To customize which transactions land in which category:

  1. Select the category group from the dropdown and click Setup Categories.
  2. In the editor, find the category you want to adjust.
  3. Type a new keyword and hit Enter to save it. Transactions whose description contains that keyword will be assigned to that category.
  4. Click Add New Category to Group to create a new category, then add keywords to it.

Updating uncategorized transactions

  • Manual: Click the pencil icon on a transaction row and select the correct category.
  • Bulk: Select multiple transactions (or select all), then click Update Categories and choose the category to apply.

Creating a custom categorization group

  1. Click Add New at the top of the category dropdown.
  2. Name the group (e.g. "Client Expenses") and click Add New Category Group.
  3. Open the group and click Setup CategoriesEdit Categories/Keywords Manually.
  4. In the popup, enter a category name and click Add New Category to Group. Repeat for each category.
  5. Add keywords to each category and hit Enter to save.
  6. Click Close when done.
  7. Click Categorize All Accounts to apply the rules.

To add categories in bulk using a spreadsheet, see Uploading Vendor Categorization CSV Files.

Tips for effective categorization

  • Use specific category names. "Gas" is more useful than "Auto".
  • Add multiple keywords per category to improve match rates.
  • Periodically review and update keywords as your transaction descriptions change.
  • Use the manual override for any transaction the auto-categorization gets wrong.

Use cases

  • Accountants and bookkeepers organizing client financial data
  • Business owners analyzing expenses and payroll
  • Tax professionals separating deductible expenses
  • Forensic accountants investigating transaction patterns

For questions, contact support@docuclipper.com.

Related