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:
- Navigate to Categorize.
- Make sure the Category dropdown is set to default.
- 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:
- Select the category group from the dropdown and click Setup Categories.
- In the editor, find the category you want to adjust.
- Type a new keyword and hit Enter to save it. Transactions whose description contains that keyword will be assigned to that category.
- 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
- Click Add New at the top of the category dropdown.
- Name the group (e.g. "Client Expenses") and click Add New Category Group.
- Open the group and click Setup Categories → Edit Categories/Keywords Manually.
- In the popup, enter a category name and click Add New Category to Group. Repeat for each category.
- Add keywords to each category and hit Enter to save.
- Click Close when done.
- 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.