Bank statements

Refunds showing as expenses? Fixing the import for gig workers

When a refund lands as an expense after a statement import, your totals go wrong. Learn how gig workers can spot, relabel and net out refunds correctly.

Editorial illustration for Refunds showing as expenses? Fixing the import for gig workers

A refund shows up as an expense when the importer cannot tell that money came back in, usually because the statement's sign or column is read the wrong way round. To fix it, find the row, change it to a credit or income-type entry for the right category, and check that the monthly total for that category falls by the refunded amount.

Why do refunds go wrong at import?

Statements encode direction in different ways. Some have separate debit and credit columns, some a single amount with a minus sign, some a suffix such as Dr or Cr. If a refund is read as an unsigned number it looks identical to a purchase. The narration usually gives it away, with words such as reversal, refund or credit, but a quick importer cannot always rely on that.

For a gig worker the damage is bigger than for a salaried person, because refunds are part of your working life: a cancelled vehicle booking, a returned phone mount, a fuel charge reversed after a failed card swipe, a platform clawing back a fee and later returning it.

How do you spot refund rows quickly?

  • Sort the imported rows by amount and look for repeated amounts, a charge followed by the same figure a few days later.
  • Search the narration for words like refund, reversal, cancelled, chargeback or credit.
  • Check the direction of every row against the bank's own totals: total credits and total debits for the period should match what you imported.
  • Look at the category total for anything that suddenly looks higher than usual.

A worked example with real arithmetic

Say you bought a ₹3,200 phone holder and a ₹1,800 charging cable for your delivery bike in one week, and returned the holder, which came back as a ₹3,200 refund. Your true spend on gear is ₹1,800 for the cable, plus nothing for the holder. If the refund is imported as an expense, the sheet says 3,200 + 1,800 + 3,200 = ₹8,200 gone. The error is ₹6,400, twice the refunded amount, because you counted the refund as spend instead of subtracting it.

RowAmountRead asShould be
Phone holder purchase₹3,200expenseexpense
Charging cable₹1,800expenseexpense
Holder refund₹3,200expense (wrong)credit to the same category
Gear total₹8,200 shown-₹1,800 correct

The gear category should end the week at ₹1,800 net, because ₹3,200 out and ₹3,200 back cancel.

What is the right way to record a refund?

  1. Change the direction of the row so it is money in, not money out.
  2. Put it in the same category as the original purchase, so the category nets down rather than your income going up.
  3. If the refund arrives in a later month, keep it in the month it arrived and note the original date in the description.
  4. For work-related gear, keep the refund confirmation along with the original receipt.

What does SpendixAI show you before saving?

SpendixAI shows the imported rows on a review screen before anything is saved, so a refund that came in the wrong direction can be corrected before it touches your totals. You pick the account first, upload the PDF, CSV or Excel statement, and then read through the rows, including their direction. Your corrections become history for later imports. It also lists possible duplicate charges, the same amount to the same merchant within two days, which is a useful cross-check when a charge and its reversal sit close together.

Checks to run after every import

  • Total debits and total credits agree with the bank's summary.
  • No category went negative by accident.
  • Each refund sits in the category of its original purchase.
  • The month you are viewing is the month of the statement.
SPENDIXAI JOURNAL

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

Explore your reports