Business

Freelancer report not matching the bank? Check what was really credited

A freelancer's income report rarely matches the bank because credits arrive net of deductions. The usual reasons, with an invoice worked through to the credit.

Editorial illustration for Freelancer report not matching the bank? Check what was really credited

If your income or expense report does not match your bank, start with the client payments: what your invoice said and what the bank received are often different amounts. Deductions at source, platform fees, a tax-savings transfer and a personal transfer through the same account all push the report away from the statement.

Reconciling is mostly about naming each difference once.

What is the difference between invoiced and credited?

An invoice states what the client owes. The bank statement shows what arrived. Between the two can sit a deduction the client made at source, a payment gateway fee, or a bank charge. If your report records the invoice amount as income but the bank shows less, the report will look better than the statement for the same month.

A worked example with hypothetical figures

Say you invoice a client ₹50,000. The client's accounts team deducts ₹5,000 at source and pays ₹45,000. You also receive ₹20,000 from another client in full. During the month you spend ₹14,000 on business costs, move ₹12,000 to a tax-savings account and withdraw ₹25,000 for home.

LineAmount in ₹
Invoiced70,000
Credited to bank65,000
Difference from deduction at source5,000
Business costs14,000
Moved to tax-savings account12,000
Withdrawal for home25,000
Bank balance change65,000 - 14,000 - 12,000 - 25,000 = 14,000

If your report says you earned 70,000 and spent 14,000, it shows 56,000 left, while your account grew by 14,000. The 42,000 gap is the 5,000 not received, the 12,000 saved, and the 25,000 taken home. None of it is an error; each belongs on its own line.

What other causes are specific to freelancers?

  • Taxes collected on your invoice, if you charge them, are not income and need their own line.
  • A client who pays two invoices in one credit makes one bank line out of two.
  • A part payment makes one invoice into two credits.
  • Advances for work you have not started.
  • Business spending paid from a personal card, which appears on a different statement.

How do you reconcile in four steps?

  1. List every credit on the statement and attach an invoice or reason to each.
  2. List invoiced amounts with no credit yet and mark them unpaid.
  3. Mark transfers to your own accounts and withdrawals separately.
  4. Compare the grand total to the closing balance minus the opening balance.

SpendixAI imports each account separately and reports on categorised spend, so tag the tax-savings transfer and the home withdrawal as transfers and the rest as income or business costs. It does not file or compute tax and does not issue invoices, so keep your invoice list in your own sheet and compare.

If one number still does not match

Look for a credit with no description, such as an unlabelled UPI receipt. A friend repaying you, a refund and a client payment can look the same on a statement. Ask the sender or check your messages for the date.

If you invoice in more than one currency or receive part payments, add a column for the invoice number next to every credit. When three credits and two invoices will not pair up, the invoice number is the thread that lets you pull them apart. Keep that column even if it feels like extra work; it is the fastest answer when a client asks whether a payment has reached you.

A monthly check

  • Total credits equal total income plus refunds plus transfers in.
  • Total debits equal business costs plus personal spending plus transfers out.
  • Opening balance plus credits minus debits equals closing balance.
SPENDIXAI JOURNAL

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

Explore your reports