Auto-Categorize Expenses by Pattern Learning

Stop manually categorizing every receipt—Nora learns your patterns.

Nora monitors QuickBooks expenses, learns which vendor/amount patterns belong to which expense categories (meals, travel, software, utilities), and auto-categorizes new expenses, holding anything it has not seen before for your confirmation.

When a new expense is submitted in QuickBooks, Nora reads the transaction details. It checks the vendor name, payment amount, and description against historical categorized expenses in the account. Using these past patterns, Nora assigns the most probable expense category to the new transaction. If the vendor and amount match a clear historical precedent, the expense is categorized immediately.

The finance manager reviews a daily summary of categorized expenses and handles only the exceptions that Nora flags. They no longer review every individual coffee receipt or recurring software subscription. When a transaction involves a new vendor or ambiguous details, Nora leaves it uncategorized and messages the manager to make the final decision.

Runs real-time when expense is submitted using QuickBooks, run by your Finance Manager.

How it works

  1. Monitor for new expenses — Nora polls the QuickBooks API on a schedule to find new transaction events. It isolates expenses that lack an assigned category, pulling the vendor name, total amount, transaction date, and any submitted description or memo.
  2. Query historical transactions — For each uncategorized expense, Nora queries the QuickBooks account for past transactions involving the same vendor or similar descriptions. It retrieves the categories previously assigned to these matches to establish a baseline pattern for the specific supplier.
  3. Evaluate category probability — Nora compares the new expense against the historical data. It evaluates whether the vendor always maps to a single category, like software subscriptions, or if the amount suggests a specific type of purchase, like a meal versus a catering event.
  4. Apply the expense category — When the historical pattern is consistent and clear, Nora updates the QuickBooks transaction record via the API. It writes the determined category to the expense, moving it out of the uncategorized queue and updating the associated ledger.
  5. Flag ambiguous transactions — If a vendor is entirely new or past transactions split evenly across multiple categories, Nora takes no action on the record. It sends a message to the finance manager in their preferred channel requesting a manual category assignment.
  6. Learn from manual corrections — When the finance manager categorizes a flagged transaction or corrects an existing one, Nora records the decision. Future transactions from that vendor will incorporate this new data point, adjusting the pattern matching for subsequent expense evaluations.

What this replaces

The finance manager logs into QuickBooks and opens the uncategorized expenses queue. They read the vendor and amount for each line item, recall or search for how similar expenses were coded in the past, select the correct category from a dropdown menu, and save the record. They repeat this for every transaction in the list.

Rough estimate rather than a measured figure: about 45 minutes a week, based on 60-80 expenses taking 30-45 seconds each to investigate and categorize.

What it needs to run

Accounts and plans

Access it asks for

What Nora reads

What Nora writes

When it goes wrong

Who this is for

Worth it if

Not worth it if

A worked example

Harbour Kitchen Supplies processes about 150 card expenses a week. Nora is configured to check QuickBooks daily, categorize clear matches based on past data, and send a daily summary of ambiguous transactions to the finance lead via WhatsApp.

QuickBooks Expense Categorization Complete (Oct 12):
- 142 expenses categorized based on historical patterns.
- 8 expenses require manual review.

Exceptions needing your input:
1. Vendor: 'Stripe', Amount: $15.00. (Past categories: Software, Bank Fees).
2. Vendor: 'City Parking', Amount: $45.00. (New vendor, no history).
3. Vendor: 'Unknown', Amount: $120.00. (No description provided).

Reply with the category for each exception, or type 'skip' to leave them uncategorized in QuickBooks. I will apply your choices and learn them for next time.

Frequently asked questions

What happens if Nora assigns the wrong category to an expense?

If an expense is miscategorized, you correct it directly in QuickBooks just as you normally would. Nora reads your correction during its next sync and updates its understanding of that vendor's pattern. If you notice a recurring error, you can tell Nora in chat to always map that specific vendor to your preferred category.

How does Nora decide when to ask for help versus categorizing automatically?

Nora looks at the consistency of your historical data. If past transactions for a vendor are always coded to the same category, it proceeds automatically. If the history is split, or if the vendor is entirely new, Nora stops and asks you for a decision. You can adjust this behaviour by telling Nora to be more or less strict.

Can I restrict Nora to only categorize specific types of expenses?

Yes. You can tell Nora to only process transactions from specific bank feeds, under certain amounts, or from specific departments. Just send a message in your chat channel describing the boundaries you want. Nora updates its instructions and will ignore any transactions that fall outside those rules.

Does Nora read my entire QuickBooks history to learn these patterns?

Nora queries the QuickBooks API for past transactions related to the specific vendors found in your current uncategorized queue. It retrieves enough historical records to establish a clear pattern for those vendors. It does not pull or store your entire historical ledger, and all data processing happens within your dedicated single-tenant instance.

Connects to

Related automations

Start a 2-week free trial · Browse all automations