Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
718 guides · Page 3 of 60
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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