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

599 guides · Page 18 of 50

Take your time. Find what helps.
Editorial illustration for Freelancer income and expense tracker in Excel with monthly totals
Spreadsheets 4 min read

Freelancer income and expense tracker in Excel with monthly totals

Set up a freelancer income and expense tracker in Excel with client, invoice, gross, TDS and received columns, and monthly totals using SUMIFS.

Read article
Editorial illustration for Fuzzy merge in Power Query for slightly different merchant names
Spreadsheets 4 min read

Fuzzy merge in Power Query for slightly different merchant names

Use Merge Queries with fuzzy matching in Power Query to match slightly different merchant names to a clean list, tune the threshold and review borderline rows.

Read article
Editorial illustration for Get a PDF statement into Google Sheets: the practical routes
Spreadsheets 4 min read

Get a PDF statement into Google Sheets: the practical routes

How to get a PDF bank statement into Google Sheets: routes that work with Google tools, their honest limits, and a paste-and-split routine to clean it up.

Read article
Editorial illustration for Goal Seek: how much to cut spending to hit a savings target
Spreadsheets 4 min read

Goal Seek: how much to cut spending to hit a savings target

Use Goal Seek in Excel to find how much to cut a grocery or dining budget to hit a monthly savings target, with the exact steps and its one-answer limit.

Read article
Editorial illustration for Gold purchase record sheet: grams, making charges and bill details
Spreadsheets 4 min read

Gold purchase record sheet: grams, making charges and bill details

A gold purchase record sheet for Excel: date, shop, grams, rate per gram on the bill, making charges, GST printed on the bill, total, plus a jeweller scheme tab.

Read article
Editorial illustration for Design a Google Form for expense entry that gives clean data
Spreadsheets 4 min read

Design a Google Form for expense entry that gives clean data

Design a Google Form expense tracker that gives clean data: dropdown categories, a validated amount field, payment mode choices and an optional note, step by step.

Read article
Editorial illustration for Receipt upload in Google Forms: where the files go and the limits
Spreadsheets 4 min read

Receipt upload in Google Forms: where the files go and the limits

See where Google Forms receipt uploads are stored, why respondents must sign in, how the file size and type settings work and how to link each file to its row.

Read article
Editorial illustration for Log expenses from your phone with a Google Form and Sheets
Spreadsheets 3 min read

Log expenses from your phone with a Google Form and Sheets

Log expenses from your phone with a Google Form linked to Google Sheets: build the form, link responses, and summarise them on a separate tab with SUMIFS or QUERY.

Read article
Editorial illustration for The Google Sheets 10 million cell limit: what counts
Spreadsheets 3 min read

The Google Sheets 10 million cell limit: what counts

What counts toward the Google Sheets 10 million cell limit, why empty grid cells count too, how to find the tabs using it up and how to free space safely.

Read article
Editorial illustration for Dropdown category lists in Google Sheets for cleaner expense data
Spreadsheets 4 min read

Dropdown category lists in Google Sheets for cleaner expense data

Set up a category dropdown in Google Sheets from a Settings tab so every expense uses the same spelling and your SUMIFS totals stop going wrong.

Read article
Editorial illustration for Make an expense tracker in Google Sheets from scratch
Spreadsheets 4 min read

Make an expense tracker in Google Sheets from scratch

Make a Google Sheets expense tracker from scratch: a log tab, dropdown categories, a QUERY monthly summary, sharing settings and phone entry limits.

Read article
Editorial illustration for Export one tab of a Google Sheet to PDF with the right page setup
Spreadsheets 4 min read

Export one tab of a Google Sheet to PDF with the right page setup

Export one tab of a Google Sheet to PDF: choose the current sheet, landscape, fit to width, hide gridlines and repeat frozen rows for a clean result.

Read article