Categories and Organization

Guide 6: Categories and Organization

Organize your income and expenses for better insights

Overview

Categories are the backbone of financial organization in OtterLedger. Well-organized categories make reports meaningful, tax preparation easier, and help you understand where your money goes. This guide covers everything from using default categories to creating a custom structure.

What you'll learn:

• Understanding category hierarchy
• Using default categories effectively
• Creating custom categories
• Mapping categories to tax lines
• Category best practices
• Keeping categorization consistent across all transactions

Time required: 15 minutes

Prerequisites

• OtterLedger file with transactions (see Guide 5: Working with Transactions)

Category Basics

Category Types

OtterLedger has two main category types:

Special categories:

• Transfer - Moving money between accounts (not income/expense)
• Uncategorized - Transactions without a category

Category Hierarchy

Categories can have subcategories for detailed tracking:

Food & Dining (parent)
├── Groceries
├── Restaurants
├── Coffee Shops
└── Fast Food

Transportation (parent)
├── Gas
├── Parking
├── Public Transit
└── Rideshare

[Screenshot: Categories view showing hierarchy]

Default Categories

OtterLedger comes with a comprehensive set of default categories.

Default Income Categories

Default Expense Categories

Creating Custom Categories

Add a New Category

1. Click Categories in the sidebar
2. Click Add Category
3. Fill in the details:

[Screenshot: Add Category dialog]

4. Click Save

Create a Subcategory

1. Click Categories → Add Category
2. Enter the name (e.g., "Vet Bills")
3. Select Parent Category (e.g., "Pet Expenses")
4. Save

Or right-click an existing category → Add Subcategory

Edit a Category

1. Click Categories in sidebar
2. Click on the category
3. Click Edit
4. Make changes
5. Save

Note: Renaming a category updates all associated transactions automatically.

Delete a Category

1. Click Categories → Select category → Delete
2. Choose how to handle existing transactions:
   • Move to another category
   • Mark as uncategorized
3. Confirm deletion

Organizing Categories

Recommended Structure

Personal Finance:

Income
├── Salary
├── Side Income
├── Interest & Dividends
└── Other Income

Expenses
├── Housing
│   ├── Rent/Mortgage
│   ├── Utilities
│   └── Maintenance
├── Transportation
│   ├── Gas
│   ├── Car Insurance
│   ├── Maintenance
│   └── Parking
├── Food
│   ├── Groceries
│   ├── Dining Out
│   └── Coffee
├── Healthcare
├── Insurance
├── Entertainment
├── Shopping
├── Personal Care
├── Subscriptions
└── Miscellaneous

Business/Freelancer:

Business Income
├── Client A
├── Client B
├── Consulting
└── Product Sales

Business Expenses
├── Advertising (Schedule C Line 8)
├── Car & Truck (Line 9)
├── Contract Labor (Line 11)
├── Insurance (Line 15)
├── Office Expense (Line 18)
├── Professional Services (Line 17)
├── Software & Subscriptions
├── Travel (Line 24a)
├── Meals (Line 24b)
└── Other Expenses

Merging Categories

If you have redundant categories:

1. Go to Categories
2. Select the category to remove
3. Click Merge Into...
4. Select the target category
5. All transactions move to the target
6. Original category is deleted

[Screenshot: Merge category dialog]

Category Consistency Tab

OtterLedger includes a built-in consistency checker to help you find and fix categorization drift — situations where the same payee has been assigned different categories over time.

What It Shows

The Consistency tab surfaces payees with mixed categorization. For example, if "Starbucks" has been tagged as both "Food:Coffee" and "Dining:Restaurants" across your transactions, it appears here as an inconsistency.

[Screenshot: Category Consistency tab showing payees with mixed categories]

Accessing the Consistency Tab

1. Click Categories in the sidebar
2. Select the Consistency tab at the top of the view
3. Review the list of payees with inconsistent categorization

Fixing Inconsistencies

For each flagged payee, you can:

• Reassign all - Apply one category to every transaction for that payee
• Review individually - Click through transactions to decide case by case
• Ignore - Dismiss the flag if the mixed categorization is intentional

Tip: Run the Consistency tab after a large import to catch categorization drift before it affects reports.

Payee Consistency Report

For a broader view across your entire history, see the Payee Consistency Report available from Reports or from the Categories view. It lists every payee with mixed categorization and the categories in use, giving you a single snapshot to work from.

For tools to merge duplicate payees and standardize payee names, see Guide 47: Payee Management & Merge.

Tax Line Mapping

For business users, mapping categories to Schedule C lines simplifies tax preparation.

Setting Up Tax Mapping

1. Categories → Select a business expense category
2. Click Edit
3. Set Tax Line to the appropriate Schedule C line
4. Save

Schedule C Line Reference

Viewing Tax Summary

Go to Reports → Schedule C Report to see expenses organized by tax line.

[Screenshot: Schedule C report showing expenses by line]

Category Rules

Automate categorization with rules. See Guide 24: Creating Rules for details.

Quick overview:

1. Go to Banking → Rules (or Settings → Rules)
2. Create rules like: "If payee contains 'Starbucks', set category to 'Food:Coffee'"
3. Rules apply automatically to imported transactions

Using Categories Effectively

Category Assignment

When adding a transaction:

1. Start typing the category name
2. Select from suggestions
3. Or browse the full hierarchy

Smart features:

• OtterLedger remembers payee-category associations
• If you always categorize "Starbucks" as "Food:Coffee", it suggests this automatically
• AI categorization can suggest categories for new payees

Batch Reassignment with Autocomplete

When you need to recategorize multiple transactions at once, the batch reassign tool now includes type-ahead autocomplete for faster category selection:

1. Go to Transactions
2. Filter to find the transactions you want to recategorize
3. Select multiple transactions (Shift-click or Ctrl-click)
4. Right-click → Set Category
5. Start typing the category name — matching categories appear as you type
6. Select the correct category from the suggestions and confirm

This is significantly faster than scrolling through the full category dropdown, especially if you have a large category tree.

[Screenshot: Batch reassign dialog with autocomplete suggestions]

Uncategorized Transactions

The Dashboard shows uncategorized transactions. To categorize:

1. Click the Uncategorized widget
2. Review each transaction
3. Assign a category
4. Or use bulk categorization for similar transactions

[Screenshot: Uncategorized widget showing transactions to review]

Splitting Categories

When a transaction spans multiple categories, use splits:

Example: Target purchase $100

• Groceries: $60
• Household: $30
• Personal Care: $10

See Guide 5: Working with Transactions for split details.

Tips & Best Practices

1. Don't over-categorize - 10-20 categories is usually enough. You can always add more later.

2. Be consistent - Always use "Dining Out" or always use "Restaurants", not both. Use the Consistency tab to catch drift early.

3. Use subcategories wisely - Only create subcategories if you'll actually review them separately.

4. Review monthly - Check for uncategorized transactions and category inconsistencies.

5. Think about reports - Create categories that will make your reports meaningful.

6. Business users: Map tax lines - It makes tax time much easier.

7. Let AI help - Enable AI categorization to automate the tedious work.

Troubleshooting

Q: I have duplicate categories.

A: Use the Merge feature to combine them. Go to Categories → select duplicate → Merge Into → select the one to keep.

Q: I need to recategorize many transactions.

A: Use batch reassign. Go to Transactions → filter to find them → select all → right-click → Set Category. Start typing the category name to use autocomplete and find it quickly.

Q: My reports don't look right.

A: Check for uncategorized transactions and miscategorized ones. Review your top spending categories for accuracy. The Consistency tab in the Categories view can also surface payees that have been categorized in conflicting ways.

Q: Can I import categories from another app?

A: Not directly, but the QBO Migration wizard maps QuickBooks categories. For other apps, you'll create categories as you categorize imported transactions.

Q: I deleted a category I need.

A: Create it again with the same name. Or restore from backup if you had transactions assigned to it.

What's Next?

Continue organizing your finances:

• Guide 7: Tags - Add another layer of organization
• Guide 23: AI Categorization - Automate categorization
• Guide 24: Creating Rules - Build categorization rules
• Guide 18: Schedule C Report - Tax reporting
• Guide 47: Payee Management & Merge - Merge duplicate payees and standardize payee names

Need help? Visit the OtterLedger community at github.com/openledger or check the FAQ.