THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

718 guides · Page 3 of 60

Take your time. Find what helps.
Editorial illustration for A two-level category tree for a student's pocket money
Expense categories 4 min read

A two-level category tree for a student's pocket money

Split food into mess, canteen and late-night orders with a simple parent and child category tree built for a student living on pocket money.

Read article
Editorial illustration for Two-Level Category Tree: Keep Groceries and Eating Out Apart
Expense categories 4 min read

Two-Level Category Tree: Keep Groceries and Eating Out Apart

A forum-style answer on building a two-level expense category tree so groceries, eating out and delivery apps are separate but still roll up to Food.

Read article
Editorial illustration for Bulk edit hundreds of categories by working biggest groups first (AU)
Expense categories 3 min read

Bulk edit hundreds of categories by working biggest groups first (AU)

Count how often each merchant appears, fix the biggest groups first and cover most of 200 rows in a handful of edits. A worked A$ example.

Read article
Editorial illustration for How to bulk edit transaction categories safely (Canada)
Expense categories 3 min read

How to bulk edit transaction categories safely (Canada)

A cautious way to change categories on 200 rows: back up, log the old value, change in batches and reconcile totals with SUBTOTAL. Examples in CA$.

Read article
Editorial illustration for Bulk edit transaction categories in a spreadsheet (Europe)
Expense categories 3 min read

Bulk edit transaction categories in a spreadsheet (Europe)

Use one IFS formula and a regional-settings check to categorise hundreds of rows at once, including how to fix amounts that imported as text in euros.

Read article
Editorial illustration for Fixing 200 miscategorised transactions at once: a gig worker's method
Expense categories 4 min read

Fixing 200 miscategorised transactions at once: a gig worker's method

After a statement import, hundreds of rows may land in the wrong category. Here is how gig workers can sort, group and bulk edit them in a few passes.

Read article
Editorial illustration for Bulk edit hundreds of transaction categories with a lookup (UK)
Expense categories 3 min read

Bulk edit hundreds of transaction categories with a lookup (UK)

Build a small keyword table and one formula to assign categories to hundreds of rows at once, then review what is left. Excel 365 and Sheets, in pounds.

Read article
Editorial illustration for How to bulk edit 200 transaction categories at once (US)
Expense categories 3 min read

How to bulk edit 200 transaction categories at once (US)

Fix hundreds of miscategorised rows in a spreadsheet by filtering one merchant at a time and pasting a category into only the visible cells. Dollar example.

Read article
Editorial illustration for Categorise Rent Paid by Bank Transfer to a Person
Expense categories 3 min read

Categorise Rent Paid by Bank Transfer to a Person

Rent paid to a landlord by bank transfer has no merchant name. Use a narration rule, fixed amount and a note so it is always filed as Rent.

Read article
Editorial illustration for Tag rent as Rent when a couple pays the landlord in two parts
Expense categories 3 min read

Tag rent as Rent when a couple pays the landlord in two parts

If each partner pays part of the rent to the landlord, use one narration rule so both transfers land in Rent and the household total matches the agreement.

Read article
Editorial illustration for Categorise rent paid to a landlord by bank transfer as a freelancer
Expense categories 4 min read

Categorise rent paid to a landlord by bank transfer as a freelancer

Rent sent to a landlord by NEFT, IMPS or UPI has no merchant name. Freelancers can match the narration with a rule so Rent is tagged correctly every month.

Read article
Editorial illustration for Categorise rent paid in India by an NRI, by transfer to a landlord
Expense categories 3 min read

Categorise rent paid in India by an NRI, by transfer to a landlord

NRIs paying rent for a family home in India by bank transfer can use one narration rule for Rent, and record foreign-currency transfers with the rate saved.

Read article