Bank statements

Freelancers: import a year of statements without double entries

A freelancer's guide to avoid duplicate transactions when importing bank statements, when client payments repeat and one account mixes personal and work money.

Editorial illustration for Freelancers: import a year of statements without double entries

Real payments often look like duplicates in freelance income, which is the hard part: the same client pays the same retainer on the same day each month, and two clients may pay the same amount together. To avoid duplicate transactions when importing bank statements, separate true repeats from double imports by date window and reference, not by amount alone.

Why freelance statements confuse any duplicate check

Income arrives in lumps. A client who pays a ₹25,000 retainer on the fifth of every month will produce twelve rows with the same amount and similar narration. Two different clients might each send ₹15,000 on the same day. A tool, or you, scanning for 'same amount, same day' will flag them, and wrongly deleting one means your income for the year is understated.

Spending is just as repetitive: a coworking desk, a software tool, a data pack, all with identical amounts every cycle.

Download by financial year, not by whim

Freelancers get asked for records by clients, by a CA at filing time, and sometimes by a lender who wants a year of statements. All of them think in April to March. So pull one file for 1 April to 31 March per account, or two half-year files that meet exactly at 30 September and 1 October.

A worked example: two clients, one day

Say your account shows these rows in one week of June.

DateNarrationCreditReal or duplicate?
5 JunRetainer, Client A₹25,000Real
5 JunRetainer, Client B₹25,000Real, different payer
12 JunFinal invoice, Client C₹18,000Real
12 JunFinal invoice, Client C₹18,000Duplicate if the reference is identical

Four rows, total ₹86,000 if you count everything, but the true total is ₹68,000 because the last row is a double import. The only way to tell rows 1 and 2 from rows 3 and 4 is the payer name and the reference in the narration.

How do I tell a genuine repeat from a double import?

  1. Open the original statement at that date and count the rows yourself.
  2. Check whether the reference or UTR text is identical. A real second payment carries a different one.
  3. Check the running balance. A real second credit moves it again.
  4. If the two rows came from different files, check whether those files overlap.
  5. When in doubt, keep both until the monthly total matches the bank.

Keeping personal and work money readable

If one account carries both, import it once into one account in the app and separate by category afterwards, rather than importing it twice under two names. In SpendixAI, you pick the account before importing, the rows are reviewed before saving, and possible duplicate imports are flagged so you can look at them. Categories and sub-categories, including custom ones, let you mark work spending apart from household spending after the fact. The flag is a prompt, not a verdict; your client retainer is not an error.

Why does the same retainer look like a duplicate to a checker?

A checker only sees fields: a date, an amount and some text. It cannot know that the fifth of June and the fifth of July are separate invoices. That is why you should read every flagged income row against your own invoice list before deleting anything. A short habit helps: keep one line per invoice with the client, the amount and the date it was due, then tick each credit against it. Whatever is left unticked is either a late payment or a stray row, and both are worth knowing about.

  • Never delete an income row on amount alone.
  • Delete only when the reference matches and the file overlap is proven.
  • Note the reason in a comment so you can explain it later.

A closing checklist

  • One file per account per window, windows that do not overlap.
  • Name files with account and dates.
  • Reconcile each month's credits with the bank total.
  • Keep the invoice number in the notes of each income row so repeats are explainable later.
SPENDIXAI JOURNAL

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

Explore your reports