Expense categories

Set a rule so every Uber trip is filed as commute: UK example

How a UK office lead can write a rule that files every Uber trip under commute, covering old and new rows, with a worked example in pounds.

Editorial illustration for Set a rule so every Uber trip is filed as commute: UK example

Think of a categorisation rule as a small sentence the system can follow: when the merchant looks like this, file it there. Write the sentence, run it on past rows, keep it for future ones, and review what it misses.

Start by writing the rule in plain English

Before you touch any tool, write it on paper. "If the merchant name includes Uber and the amount is under £40, file as Commute. If it includes Uber and the amount is £40 or more, hold for review." That second line is the useful part: a long, expensive ride is more likely to be an airport run or a client trip than a normal commute, so a person should look at it.

Is an amount band really necessary?

Not always, but it catches odd rows cheaply. Suppose your team's usual commute ride is between £8 and £22. Anything over £40 is worth a glance. You choose the line from your own history, not from a rule of thumb. Look at last quarter, sort by amount and see where the normal rides stop.

Row (made-up)AmountRule resultAction
Uber trip, Monday£12.80CommuteNone
Uber trip, Tuesday£18.45CommuteNone
Uber trip, Friday late£47.00Hold for reviewCheck purpose
Uber eats order£21.60Meals, by earlier ruleNone

How do I apply it to the past?

  1. Search all rows whose merchant includes Uber across the last six months.
  2. Count them and add the total. Say there are 31 rows totalling £486.75.
  3. Apply the rule to those rows only, not the whole ledger.
  4. Check the split: Commute, Hold for review and Meals should add back to £486.75.
  5. Clear the Hold for review rows by hand, one at a time.

If the three groups total £486.75 again, nothing slipped through. If they do not, one row was filed twice or fell out of the filter.

What about future rows?

A rule only helps if it is kept. Put the sentence in a shared document with a date and the name of the person who owns it. When a new ride-hailing service appears in the team's statements, add a line for it instead of changing the Uber one.

A monthly five-minute review

  • Open the Hold for review list and clear it.
  • Scan the Uncategorised rows for any new merchant that deserves a rule.
  • Check that the monthly Commute total is in the range you expect.
  • Note any rule you changed and the date.

If you want to use the rows as a record for someone else, such as a client who is billed for travel or a payroll team, say clearly what each category includes. A label is only as useful as its definition.

What if the team uses more than one ride service?

Add a separate line per merchant rather than stretching one rule across all of them. If the team also uses a taxi firm and a bike-hire scheme, each gets its own sentence: contains the name, assign Commute or Travel. That keeps the reasoning visible, and when a service changes its name on statements you only edit one line.

Say the quarter shows £486.75 on Uber, £92.40 on a local taxi firm and £38.00 on bike hire. Three rules give three totals, £617.15 together (486.75 plus 92.40 plus 38.00), and you can see which service the team actually relies on. One combined rule would hide that, and the next time somebody asks whether the team needs a corporate account with one provider, you would have no figure to show.

SPENDIXAI JOURNAL

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

Explore your reports