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 29 of 50

Take your time. Find what helps.
Editorial illustration for PG and flat rent split sheet in Google Sheets with electricity share
Spreadsheets 4 min read

PG and flat rent split sheet in Google Sheets with electricity share

Split flat rent, electricity and wifi in Google Sheets using room weights and days stayed, with a worked example for four flatmates and a mid-month joiner.

Read article
Editorial illustration for A shoot-wise profit sheet for photographers in Google Sheets
Spreadsheets 3 min read

A shoot-wise profit sheet for photographers in Google Sheets

A Google Sheets template for photographers: one row per shoot with fee, advance, balance, costs and profit, plus a pending-balance list that updates itself.

Read article
Editorial illustration for Pie chart or bar chart for spending categories: which to use?
Spreadsheets 4 min read

Pie chart or bar chart for spending categories: which to use?

Pie chart or bar chart for spending categories: use a pie for a few parts of a whole and a sorted bar chart for ten categories, shown with the same data.

Read article
Editorial illustration for Calculated field in a pivot table: income minus expenses
Spreadsheets 4 min read

Calculated field in a pivot table: income minus expenses

Work out monthly savings in a pivot table: split income and expense into fields, add a calculated field in Excel or Sheets, or use SUMIFS beside the pivot.

Read article
Editorial illustration for Pivot chart for monthly spending by category in Excel
Spreadsheets 4 min read

Pivot chart for monthly spending by category in Excel

Make a stacked column pivot chart of monthly spending by category in Excel, hide the field buttons, and use a pie chart for a single month.

Read article
Editorial illustration for Pivot chart with slicers for expense analysis
Spreadsheets 4 min read

Pivot chart with slicers for expense analysis

Add a pivot chart, a Category slicer and a Date timeline in Excel, then connect them to several pivots so one click filters the whole view.

Read article
Editorial illustration for Pivot table for expenses by category and month in Excel
Spreadsheets 4 min read

Pivot table for expenses by category and month in Excel

Build an Excel pivot table of expenses by category and month, with rows, columns and values set up step by step, using a sample bank export of 300 rows.

Read article
Editorial illustration for Pivot table by financial year (April to March) using a helper column
Spreadsheets 3 min read

Pivot table by financial year (April to March) using a helper column

Group a pivot table by Indian financial year, April to March, with a helper column for FY, fiscal quarter and month order, plus a worked example.

Read article
Editorial illustration for Pivot table for an expense summary in Google Sheets
Spreadsheets 4 min read

Pivot table for an expense summary in Google Sheets

Create a pivot table in Google Sheets to summarise expenses by category, set rows, columns and values, switch on totals and sort by sum of amount.

Read article
Editorial illustration for Pivot table not showing new expense rows: how to fix it
Spreadsheets 4 min read

Pivot table not showing new expense rows: how to fix it

Pivot table not showing new expense rows? Refresh it, extend the data source, turn the data into a Table so ranges grow, and use whole columns in Sheets.

Read article
Editorial illustration for Show each category as a percentage of total in a pivot table
Spreadsheets 4 min read

Show each category as a percentage of total in a pivot table

Show each expense category as a percentage of total in an Excel or Google Sheets pivot table using Show Values As, and learn which percent option to pick.

Read article
Editorial illustration for Pivot table of spending by category and month from a statement
Spreadsheets 4 min read

Pivot table of spending by category and month from a statement

Build an Excel pivot table of spending by category and month from a bank statement: clean the rows, group dates, fix blanks and refresh.

Read article