Help Library
All Articles First-Day Setup Download Transactions Upload Transactions Categorize Transactions
Monthly Tools
Copy Finalized Name Accounts Income Labels Expense Labels
Open System

Categorize Your Transactions

The step that transforms a list of raw charges and deposits into real financial insight. This is the core monthly habit in Money Mastery — and the one that deserves the most care.

Must-Have 10–20 min / month Personal & Business
Before you start: Newest transactions already pasted into the correct account tab
Success check: Uncategorized rows reduced, recurring merchants labeled consistently
Key tool: The categorization modal — not the raw spreadsheet cells
Tone: You are labeling meaning, not just merchant names

What This Tutorial Is For

This is the core monthly habit in Money Mastery.

Uploading transactions gets your data into the system. Categorizing is what makes that data useful.

This is the moment where "Amazon," "Shell," "Stripe," "Whole Foods," "Payroll," or "Owner Contribution" stops being just a line item and starts becoming a meaningful part of your financial story. Without categorization, your reports can count transactions. With categorization, they can explain your life.

"Without categorization, your reports can count transactions. With it, they explain your life."

And if this step has ever felt tedious, overwhelming, or weirdly emotional, that's normal too. Categorizing money is not just administrative — it asks you to look directly at your habits, your patterns, your priorities, and sometimes your contradictions. The point here is not to do it perfectly. The point is to do it clearly and consistently enough that your system can finally help you.


Before You Begin

Open the account tab with the newly pasted transactions you want to work through.

You are not meant to read every row and type into random cells across the sheet by hand. The current system is built around the categorization modal — a cleaner, more guided workspace for this step. That modal pulls in your transaction rows and lets you work through them with category fields, Need/Desire buttons, memo space, suggestions, and batch tools all in one place.

Think of it this way: the account tab is where transactions live. The categorization modal is where you work on them.

The 11 Steps

Step 1: Open the Categorization Workspace. From the account you want to work on, open the Categorization tool. When the modal opens, each transaction row is laid out for you with its key pieces visible side by side.

That matters because it changes the feeling of this task. You are no longer hunting around a spreadsheet trying to remember what belongs where. The system is placing the whole decision in front of you, one row at a time.


Step 2: Start at the top and read what the transaction actually was. Work from top to bottom, one visible row at a time. Do not categorize based only on the merchant name if the merchant name could mean several things. Read the transaction like a tiny story.

Ask yourself:

  • What was this really for?
  • Was it personal or business?
  • Was it income or an expense?
  • Will I need context later to remember why this happened?
Merchant
Could mean any of these…
Amazon
Office Supplies Household Goods Gifts & Giving Business Inventory
Target
Food — Groceries Cleaning Supplies Business Event Supplies Kids' Clothing
Stripe
Services Income Sales Payout Refund — Needs Review

You are not labeling brands. You are labeling meaning.


Step 3: Choose the right category lane first. Before you decide the exact category, decide which field should hold the answer. The modal gives you two main category lanes.

Personal Category

Use this when the transaction belongs to your personal financial life.

ExampleWhole Foods → Food — Groceries
ExampleNetflix → Entertainment — Subscriptions
ExampleShell Gas → Transportation — Gas
Business / Special Label

Use this when it belongs to your business life — or when the row needs a system label instead.

ExampleStripe Payout → Services — Client Retainers
ExampleAdobe Subscription → Biz — Software
Special labels also live here
CC Payment · Transfer · Refund · Ignore
These apply to both Personal and Business systems. They are not business-only — any account type may need a Transfer, CC Payment, Refund, or Ignore label.
Wrong lane is a common mistake: Many categorization errors are not "wrong category" mistakes — they are wrong lane mistakes. The user knew what the transaction was, but put it in the wrong column. If you mix those lanes carelessly, your reports stop telling the truth.

Step 4: Assign the most accurate category — not the most convenient one. Use the category field that fits the transaction and select the label that most honestly describes what happened. The goal is not speed at all costs. The goal is a category you will still agree with later.

  • A restaurant charge for a business meeting → "Business Meals", not just "Restaurants"
  • A deposit from a client → "Services", not a vague catch-all
  • An owner contribution → "Owner Contribution", not earned income

The deeper rule: categorize based on financial meaning, not visual resemblance.


Step 5: Be consistent with recurring merchants. If the same kind of purchase happens every month, use the same category every month — unless there is a real reason to change it. Consistency is what makes your reports believable.

Recurring merchant — same merchant, different months Starbucks
Nov
Starbucks
−$8.75
Food — Coffee
stable ✓
Dec
Starbucks
−$9.10
Food — Coffee
stable ✓
Jan
Starbucks
−$11.40
Food — Coffee
stable ✓
vs. category drift — same merchant, inconsistent labels
Nov
Starbucks
−$8.75
Dining Out
drift ✗
Dec
Starbucks
−$9.10
Food
drift ✗
Jan
Starbucks
−$11.40
Lifestyle
drift ✗

If one coffee-shop visit is "Dining Out," the next is "Food," and the third is "Lifestyle," the system can only show you your indecision — not your actual coffee spending. A helpful test: If I saw this exact merchant and amount next month, would I want it categorized the same way again? If yes, keep it stable.


Step 6: Use Need / Desire thoughtfully — and only where it applies. For expense transactions, the modal includes Need and Desire buttons. This becomes part of how the system helps you read your behavior later.

Try it — click Need or Desire on any row
Rent PaymentHousing — Rent/Mortgage
−$1,850
Need
Desire
Spotify PremiumEntertainment — Subscriptions
−$10.99
Need
Desire
Electric BillHousing — Utilities
−$92.40
Need
Desire
New SneakersShopping — Clothing
−$118.00
Need
Desire
  • A Need is something essential, required, or functionally necessary.
  • A Desire is something chosen, wanted, flexible, or lifestyle-driven.
  • Sometimes the answer is obvious. Sometimes it is not — and that's okay.

This section is not asking you to shame yourself. It is asking you to be honest enough that your reports can show the emotional shape of your spending, not just the math of it.

Income rows don't use Need/Desire the same way expense rows do. If you notice the buttons behaving differently on income, that's not a bug — that's the system respecting the difference.

Step 7: Add a memo when future-you would otherwise forget. The Memo field is for context, not for busywork. Use it when the transaction needs a quick explanation that will matter later.

When to add a memo
Why a charge was unusually high this month
Who a payment was for (person or project)
Whether something is reimbursable
Why a personal-looking charge was actually business
What a vague transfer or deposit related to
The transaction will still make perfect sense in 6 months
The merchant name and category are already self-explanatory
It's a routine, recurring charge with no unusual context
You'd just be restating what the category already says

A good memo is short and practical. It should answer a future question, not create a new essay.


Step 8: Use suggestions as help, not as authority. The categorization modal includes AI / Clarity suggestions — and those can be genuinely helpful, especially for recurring merchants or patterns the system has started to recognize. But suggestions are exactly that: suggestions.

  • If the suggestion matches reality → use it.
  • If it doesn't → override it without guilt.
  • If it's close but not quite right → treat it as a clue, not a command.

The system gets smarter when you keep teaching it the truth. It gets messier when you accept suggestions just because you're tired.


Step 9: Use bulk actions only after you confirm the pattern is truly the same. The modal has Select All and Apply to Selected tools for a reason: they save time when several rows genuinely deserve the same treatment.

3 rows selected Applying: Food — Groceries · Need
Jan 4
Whole Foods Market
−$94.18
Food — Groceries
Jan 11
Trader Joe's
−$67.45
Food — Groceries
Jan 19
Kroger
−$52.30
Food — Groceries
Jan 22
Amazon.com
−$47.92
— uncategorized —

Bulk actions are wonderful when dealing with repeated subscriptions, multiple similar deposits, or a batch of transactions that all clearly belong in one category. But don't bulk-categorize because rows look similar at a glance. Bulk-categorize because you already confirmed they are functionally the same. Used carelessly, it spreads one wrong decision across ten rows at once.


Step 10: Treat unusual rows with extra care. Not every row is a normal category decision. Some transactions are adjustments, transfers, split situations, or offsets like refunds. When something feels unusual, duplicated, circular, or hard to explain — pause instead of forcing it into a normal category.

These apply to both Personal and Business. CC Payment, Transfer, Refund, and Ignore are not limited to business accounts — any account type, in any system, may need them. If you only use the Personal system, these labels still apply to you.
Transfers
Money moved between your own accounts. Needs the Transfer special label — not a spending category.
Refunds & Returns
Money coming back. Deserves its own careful walkthrough — especially when it offsets a prior purchase.
CC Payments
System-behavior labels, not ordinary categories. The individual charges are already tracked on the card account.
Split Transactions
One charge that belongs in two or more categories. This changes the structure of the data — deserves a full walkthrough.
Ignore
Rows that should be excluded from reports entirely — test transactions, duplicates, or imported errors.
Receipt Attachments
When a row needs documentation attached. Especially useful for reimbursable or audit-relevant expenses.

These deserve their own companion tutorials — see the section below.


Step 11: Keep going until the visible unlabeled work is truly reduced. The goal is not perfection in one dramatic sitting. The goal is that the account meaningfully clears. Continue until the visible uncategorized rows are reduced as far as they reasonably can be.

In many months, that means all of them. In messier months, it may mean all but a few special cases you need to investigate. What matters is that the system is no longer mostly a pile of unlabeled transactions.

Once the unlabeled rows shrink, your reports stop feeling generic and start feeling personal. That is the whole point of this step.

Best Practice

Use the same category for the same kind of purchase each month unless there is a genuine reason to change it. That one habit alone will make your reporting dramatically more useful.

And if you're ever unsure between two labels, choose the one that will make the report more helpful later — not the one that merely feels easier to click now.


What to Check When You're Done

This categorization session did its job when…
  • Unlabeled rows are greatly reduced or eliminated
  • Recurring merchants are categorized consistently
  • Need/Desire choices are present where they belong
  • Memo notes exist only where they actually add clarity
  • Unusual rows were paused for proper treatment — not forced into bad categories
  • Your reports begin to reflect real patterns instead of raw activity
"Done gently and consistently, this practice will show you not just what happened to your money — but what your money keeps trying to say about your life."
If this step ever feels like the beating heart of the whole system, that's because it is. Uploading is mechanical. Categorizing is interpretive. This is where the system stops being a record of transactions and becomes a mirror.

Continue in the Library
Browse All Help Articles