Product guides

Selecting many rows to categorise in one go

Multi-select lets you change the category of dozens of transactions at once. Learn how to build a selection, apply a change and avoid sweeping up the wrong rows.

Editorial illustration for Selecting many rows to categorise in one go

Editing transactions one by one is fine for a handful and painful for a hundred. The transaction list supports selecting several rows at once, after which a bar offers bulk actions such as categorising, changing the type and deleting. Used carefully, it turns an evening's work into a few minutes.

Building a useful selection

The quality of a bulk edit depends on the quality of the selection. Start by narrowing the list with search or filters, so that only the transactions you mean to change are visible. A search for a merchant, a tag or a note keyword is the usual starting point. Filters can add conditions such as an account or an amount range.

Once the list shows the right set, press and hold a row to begin selecting, and tap the others. Check the count on the selection bar before acting. If the number surprises you, stop and look again.

The bulk actions

  • **Categorise.** Assign one category to every selected transaction.
  • **Type.** Change whether the selected entries are expenses, income or refunds.
  • **Delete.** Remove the selected transactions, which move to the recycle bin.

Of the three, categorise is the workhorse. It is ideal for cleaning up after an import, for reorganising after a category change, or for catching stragglers that rules missed.

A safe workflow

Follow the same steps each time so bulk edits stay predictable.

StepCheck
Filter or searchDoes the list show only the intended group?
SelectDoes the count match your expectation?
Scan the rowsAre there any strays in the selection?
Apply the actionIs the category or type the right one?
ReviewDo a few edited rows look correct?

The scan step deserves emphasis. A quick scroll through the selected rows often reveals a transaction that does not belong, such as a refund caught in a payment search.

Cautions

Bulk delete is the one to treat with respect. Deleted transactions are recoverable from the recycle bin, which softens the risk, but a mass deletion still disrupts balances and reports until restored. Prefer categorising or retyping over deleting where possible, and double-check the selection count before confirming a delete.

Changing type in bulk affects how totals are computed. Turning expenses into income, or the reverse, flips their effect on reports. Make sure that is what you intend, and examine a report afterwards.

Pairing selection with rules

If a bulk selection is something you do repeatedly, it is a sign that a rule would serve better. Selecting the same group of transactions every month to apply the same category is the exact job rules are designed for. Use bulk edit for the one-time clean-up and a rule for the future.

Selecting across several screens

Long lists may need scrolling during selection, and it is easy to lose track of what is chosen. Keep an eye on the running count rather than the visible rows. If you need to stop partway, clear the selection and restart from the filtered list, rather than leaving a half-built group that you may later apply by accident.

A quick example

After an import, forty payments to a family of related stores appear with different categories. Searching for their common name shows them together. Selecting all, applying the categorise action once and choosing the right category takes under a minute. Writing a matching rule afterwards means next month's payments will not need the same treatment.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports