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.
940 guides · Page 27 of 79
Take your time. Find what helps.
Keeping a versioned categories and tax codes file (Australia)
Categories change, and so does what your accountant needs. Keep a dated categories and tax codes file with a change log. A-dollar example and a template.
Read article
What accountants mean by categories and tax codes (Canada)
Confused when your accountant asks for categories and tax codes? A plain-English Q&A with a Canadian-dollar example and what to prepare.
Read article
Mapping table or inline codes for your accountant? (Europe)
Two ways to give an accountant your categories and tax codes: a separate mapping table or a code on every row. Compared, with a € example and a decision guide.
Read article
Categories and tax codes file for your accountant: a gig worker's version
A categories and tax codes file maps your spending labels to your accountant's codes. Here is how a gig worker can prepare one, with a worked rider example.
Read article
Onboarding a bookkeeper: the categories and codes file to send first (UK)
Starting with a new bookkeeper? Send a categories and tax codes file first. A UK first-call checklist with a £ example and questions to ask.
Read article
Build a categories and tax codes sheet before your accountant asks (US)
Before year-end, make a one-page sheet matching your expense categories to the codes your accountant uses. A US sole proprietor's example, in dollars.
Read article
Chart monthly spending by category across three months
Build a stacked column chart that compares spending by category over three months using SUMIFS and EDATE, with an Australian dollar worked example.
Read article
Chart monthly spending by category in Excel 365 with spill formulas
Use UNIQUE, SUMIFS and SORTBY in Excel 365 or 2021 to build a self-growing spending-by-category summary and chart, with a Canadian dollar example.
Read article
Chart monthly spending by category in Google Sheets with QUERY
Use a single QUERY formula in Google Sheets to total spending by category and chart it, with a euro worked example and tips for decimal-comma sheets.
Read article
Chart your monthly spending by category without the spreadsheet pain
Make a clean monthly spending chart by category: tag your expenses, total them with a pivot table or formula, pick the right chart and read it. Gig worker example.
Read article
Monthly spending by category chart with SUMIFS and a bar chart
Build a monthly spending chart by category using SUMIFS and a sorted bar chart in Excel or Google Sheets, with a pounds worked example and checks.
Read article
Chart your monthly spending by category with a pivot table
Turn a month of exported bank lines into a spending-by-category chart in minutes using a pivot table in Excel or Google Sheets, with a dollar example.
Read article