Bank statements

Freelancers: why a review step matters when importing bank rows

For freelancers with lumpy income, a quick review of imported bank rows keeps client payments, own-account transfers and refunds from distorting the month.

Editorial illustration for Freelancers: why a review step matters when importing bank rows

Income lines are where the review step matters most for a freelancer. Client payments arrive under UPI names, NEFT references and platform payout labels, and one misread credit can make a thin month look healthy. Check what each incoming row actually is before it joins your record.

Why is income harder to import than spending?

Spending lines carry merchant names the importer can recognise. Incoming lines often say nothing useful: a person's name, a reference number, a payout batch. A credit might be a client paying an invoice, you moving money from your own other account, a friend returning a loan or a reversal of a failed payment. To a bank all four are simply credits.

What are the credits that fool you?

  • Own-account transfers from your savings account into your current account.
  • A client's advance for a project you have not started.
  • A refund from a software vendor.
  • A friend settling a dinner you paid for.
  • A payment that is actually a reimbursement of costs you paid for the client.

Only some of those are earnings. The rest belong to a transfer, a liability or a cost reversal.

A worked example for an uneven month

Say a month's credits on the statement total ₹96,000. On review you find ₹40,000 moved from your own savings account, ₹5,500 a client repaid for software you bought on their behalf, and ₹3,000 from a friend. The real earnings from work are then 96,000 minus 40,000 minus 5,500 minus 3,000, which is ₹47,500. Without the review you would think the month brought in nearly double.

CreditAmountTreat as
Own savings transfer₹40,000transfer, not income
Client reimbursement₹5,500reduces the software cost
Friend settling a dinner₹3,000reduces personal spending
Client invoices paid₹47,500income

The check: 40,000 plus 5,500 plus 3,000 plus 47,500 equals ₹96,000, the full credits on the statement.

What should you look at on the review screen?

  1. Sort credits by amount and read the narration on every one above your usual invoice size.
  2. Match each client payment to an invoice you issued. If you cannot, ask yourself what it is.
  3. Mark transfers between your own accounts.
  4. Check the expense side for repeated debits, such as a subscription charged twice.
  5. Confirm the statement period matches the dates on screen.

Where does SpendixAI fit?

SpendixAI shows every imported row on a review screen before it is saved, so you can recategorise a credit or correct a row first. You pick the account before importing, which keeps your personal account and your business account separate. Custom categories let you keep Client income apart from Transfers. It does not create invoices or file taxes, and any figures you use for GST or income tax should be confirmed with a CA.

Should you review debits as carefully as credits?

Less carefully, but not carelessly. For a freelancer the debit-side traps are subscriptions that renew on the card, a client's cost paid from your pocket and a payment you set aside from earnings. Look for three things: a charge that repeats on the same date each month, a cost you plan to bill to a client, and a large round-figure payment that may be a savings movement rather than a bill.

A quick way is to sort debits by merchant name rather than amount. Repeats cluster together, and an old tool you stopped using stands out at once. Write the client name in the notes while it is fresh, because three months later nobody remembers which project a ₹4,200 courier charge was for.

Habits that keep the record honest

  • Review the credits before the debits; they decide whether the month was good.
  • Keep one category for transfers and use it every time.
  • Write the client name in the notes when a credit is ambiguous.
  • Do the review the day you import, while you still remember who paid what.
SPENDIXAI JOURNAL

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

Explore your reports