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

940 guides · Page 27 of 79

Take your time. Find what helps.
Editorial illustration for Keeping a versioned categories and tax codes file (Australia)
Business 3 min read

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
Editorial illustration for What accountants mean by categories and tax codes (Canada)
Business 4 min read

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
Editorial illustration for Mapping table or inline codes for your accountant? (Europe)
Business 3 min read

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
Editorial illustration for Categories and tax codes file for your accountant: a gig worker's version
Business 4 min read

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
Editorial illustration for Onboarding a bookkeeper: the categories and codes file to send first (UK)
Business 4 min read

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
Editorial illustration for Build a categories and tax codes sheet before your accountant asks (US)
Business 4 min read

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
Editorial illustration for Chart monthly spending by category across three months
Business 4 min read

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
Editorial illustration for Chart monthly spending by category in Excel 365 with spill formulas
Business 3 min read

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
Editorial illustration for Chart monthly spending by category in Google Sheets with QUERY
Business 3 min read

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
Editorial illustration for Chart your monthly spending by category without the spreadsheet pain
Business 4 min read

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
Editorial illustration for Monthly spending by category chart with SUMIFS and a bar chart
Business 3 min read

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
Editorial illustration for Chart your monthly spending by category with a pivot table
Business 3 min read

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