Getting started

Duplicate income and expenses in your tracker: a freelancer's fix

When a freelancer records an invoice by hand and then imports the bank credit, income is counted twice. Use a balance check to find the gap and stop it.

Editorial illustration for Duplicate income and expenses in your tracker: a freelancer's fix

Duplicates do the most harm on the income side for a freelancer: an invoice entered by hand when you raise it and the same money imported when it reaches the bank. Your income looks higher than it was. The quickest check is a balance reconciliation: opening balance plus credits minus debits should equal the closing balance on your statement.

Why freelancers get doubles

A salaried person's income arrives once. A freelancer raises an invoice, waits, gets a partial payment, and sometimes a second payment from the same client. Entering the invoice as income when you raise it feels sensible. It also means the bank credit, when it arrives, is a second entry for the same money.

The balance check, step by step

You do not need to hunt through rows first. Start with the statement.

  1. Write the opening balance on the first day of the month, as shown on the statement.
  2. Total all the credits in your tracker for that account, and all the debits.
  3. Calculate opening plus credits minus debits.
  4. Compare it with the closing balance on the statement.
  5. The difference is the size of what you double counted, or missed.

A worked example with an ₹18,000 gap

Say the statement opens at ₹14,200 and closes at ₹34,700. Your tracker shows credits of ₹70,000 and debits of ₹31,500.

LineAmount
Opening balance₹14,200
Credits in tracker₹70,000
Debits in tracker₹31,500
Calculated closing balance (14,200 + 70,000 minus 31,500)₹52,700
Closing balance on statement₹34,700
Gap (52,700 minus 34,700)₹18,000

The gap is exactly ₹18,000, which looks like one invoice entered by hand and again by import. Search your credits for that amount. If you find two entries with the same client and amount, delete the manual one.

What if the gap does not match one entry?

Then it may be several smaller duplicates, a missed debit or a transfer between your own accounts counted as income. Subtract matches one at a time. If the remaining gap is still unexplained, compare the tracker's list against the statement line by line for that account.

  • Transfers between your own accounts are not income. Mark them as transfers.
  • A client who pays in two instalments gives two real credits. Those are not duplicates.
  • A reimbursement for a cost you fronted is not income either.

How should I record invoices?

Keep invoices in an invoice sheet with a status, and count income only when it is credited. That way the bank credit is the one and only record of that money. Your invoice list shows what is outstanding, and your tracker shows what you actually have.

Where an app helps

SpendixAI flags possible duplicate imports and lets you review rows before saving, and deleted transactions sit in a recycle bin for 30 days. You still need to decide which entry is the real one, and it does not do invoicing, so the invoice sheet stays separate.

What about expenses paid by a client?

A client may pay for a cost directly, or reimburse you later. If you enter the cost as an expense and then also enter the reimbursement as income, your tracker is correct only if the bank statement shows both. If the client paid the vendor directly, nothing touched your account and there should be no row at all, only a note in your client file. Mixing these cases is another common source of gaps in the balance check.

Monthly routine

  1. Run the balance check on each account.
  2. Search for the gap amount.
  3. Remove the manual twin.
  4. Note which source you will use for that account from now on.
SPENDIXAI JOURNAL

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

Explore your reports