Expense categories

Rules for filing Uber as commute: run it, then reconcile in Australia

For an Australian team lead, a run-then-reconcile method to file Uber as commute on past and future rows, with a worked example in Australian dollars.

Editorial illustration for Rules for filing Uber as commute: run it, then reconcile in Australia

The safest way to apply a rule to past rows is to run it, then reconcile: compare totals before and after and read the rows that changed. A rule that looks right on screen can still quietly move dozens of rows.

What is run-then-reconcile?

You take a snapshot of the totals by category, run the rule, take another snapshot, and explain every difference. If the only change is that Uber rows moved from Uncategorised or Misc into Commute, the rule behaved. If another category lost money, ask why.

Worked example in Australian dollars

Say a field-service lead has a ledger with these made-up totals before the rule.

CategoryBeforeChange from ruleAfter
UncategorisedA$1,240.00-A$386.50A$853.50
MiscA$610.00-A$92.00A$518.00
CommuteA$420.00+A$478.50A$898.50
MealsA$830.00A$0.00A$830.00

Rows leaving Uncategorised and Misc total A$478.50 (386.50 plus 92.00), and Commute gains exactly that. Nothing else moved, which is what you want. If Meals had dropped by even A$20, the rule would have caught a food order.

How do I run the rule safely?

  1. Copy the data to a safe place, or note the category totals first.
  2. Test the rule on a filter of 10 to 20 Uber rows and read them.
  3. Run the rule on the full history.
  4. Reconcile the totals as in the table above.
  5. Read the biggest five rows that changed.

What about a quick check in a spreadsheet?

To see how many rows contain the merchant name and what they total, use these two lines. The amount is in column D and the description in column B.

  • =COUNTIF($B$2:$B$500, "*uber*")
  • =SUMIF($B$2:$B$500, "*uber*", $D$2:$D$500)

Both ignore capitalisation and treat the star as any text. After running the rule, compare SUMIF with the Commute total plus any Uber rows in other categories.

What should happen with future rows?

Once the past is clean, new rows should be labelled as they arrive, ideally by the same rule. Put a standing reminder in the team calendar for the end of each month to look at three things: rows that nothing matched, rows over your usual ride amount, and any new merchant that appears more than twice.

What does the team lead hand over?

  • A one-page rule list with the order of the rules and the reason for each.
  • The before and after totals for the first run.
  • A name for the person who maintains the rules.

Labels are for understanding your spending. How a cost is treated for tax or reimbursement is a separate decision for your finance team or accountant, who will know the current local rules.

What if the numbers do not reconcile?

Start with the biggest difference and work backwards. Say your reconciliation shows Commute rising by A$478.50 but your quick Uber total says A$512.00. The gap is A$33.50, so look for a single ride of that size, or two smaller ones, sitting in a different category such as Meals or Travel. Filter that category by the merchant name and read the descriptions.

Common causes are a row that was categorised by hand earlier, a refund that shows as a negative amount, or a second spelling of the merchant that the rule did not match. A refund is easy to miss: a negative A$12.00 row will reduce the Commute total, so the totals can differ by exactly that amount in the other direction. Fix the cause, run the check again and write the finding in the rule list so the next person does not repeat it.

A reconciled rule is one you can explain in a sentence to anyone who asks how the Commute number was reached.

SPENDIXAI JOURNAL

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

Explore your reports