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.
599 guides · Page 9 of 50
Take your time. Find what helps.
Credit card spend tracker sheet organised by statement cycle
Track credit card spends by statement cycle, not calendar month, in a spreadsheet with a statement-month formula and totals that match your bill.
Read article
Credit card statement lines marked Cr: refunds and payments in Excel
What Cr means on a credit card statement, why its sign differs from a bank account, and how to normalise both in Excel so payments are not spending.
Read article
Credit card statement PDF to Excel: pull out only the transactions
Convert a credit card statement PDF to Excel and keep only the transaction table: drop summary boxes, sign payments and refunds, and check the date range.
Read article
Cumulative spend line vs the monthly budget line
Chart month-to-date spending against a straight budget line in Excel with SUMIFS, and see which day you will cross the limit at your current pace.
Read article
Customer paid less than the invoice: a difference column
Add Invoice, Received and Difference columns, then split each gap into labelled reasons such as deductions, bank charges and short payment.
Read article
Daily expense sheet in Google Sheets that is easy to fill on a phone
Design a daily expense sheet in Google Sheets for phone entry using a Google Form, a category dropdown, a Today total cell and a monthly summary tab.
Read article
Daily spending allowance for the rest of the month: formula
Work out how much you can spend per day for the rest of the month with a budget, spend so far, EOMONTH and TODAY, plus a guard for the last day.
Read article
Checklist: clean your expense data before formulas or pivots
A ten-point checklist to clean expense data before formulas or pivot tables: real dates, numeric amounts, one header row and consistent categories.
Read article
Why you stop updating your expense spreadsheet after a few weeks
Why you stop updating an expense spreadsheet after a few weeks: one month's typing effort worked out, and which parts statement import can remove.
Read article
One-variable Data Table: see savings at different spending cuts
Build a one-variable Data Table in Excel to see monthly savings at different spending cuts, and avoid the row and column input cell mix-up.
Read article
Two-variable Data Table: monthly saving vs months to a goal
Build a two-variable Data Table in Excel with monthly saving down the side and months across, to see the goal amount reached at each combination.
Read article
Data validation to stop wrong amounts in an expense sheet
Use Data Validation in Excel to stop wrong amounts: allow only a decimal above zero, show a clear message, block text like 1,200 rs and catch blanks.
Read article