Health and family

Giving your CA safe access to a freelancer's expense data

How an Indian freelancer can give a CA safe access to income and expense records, with invoice matching, a quarterly routine and a worked rupee example.

Editorial illustration for Giving your CA safe access to a freelancer's expense data

A freelancer's CA needs two lists that match each other: money that came in, linked to the client or invoice it belongs to, and money that went out for work. Give them both in one place, as a view-only seat or an export, and keep bank logins to yourself. The work is in matching credits to invoices before they ask.

What does a CA of a freelancer actually look for?

  • Every credit in your bank account, and which client or invoice it belongs to.
  • Credits that are not income, such as a loan from a friend or a refund.
  • Work-related costs with a bill or invoice behind each.
  • Costs that are part personal, such as a phone or a co-working pass you also use for non-work.

How do I match credits to invoices?

Keep a simple register with these columns: Invoice number, Client, Invoice amount, Date received, Amount received, Difference. Clients often deduct or pay in parts, so the amount received can differ from the invoice. Here is a made-up quarter:

InvoiceClientInvoice amountReceivedDifference
INV-014Studio A₹60,000₹54,000₹6,000
INV-015Agency B₹45,000₹45,000₹0
INV-016Startup C₹90,000₹30,000₹60,000
Total-₹1,95,000₹1,29,000₹66,000

Check: 60,000 + 45,000 + 90,000 = 1,95,000; 54,000 + 45,000 + 30,000 = 1,29,000; and 6,000 + 0 + 60,000 = 66,000. Some of the first difference may be a deduction at source, but do not guess which; mark it and ask your CA how to record it.

What is a safe way to hand it over?

  1. Reconcile first: every credit tagged to an invoice, or marked Other with a note.
  2. Categorise costs and attach bills for anything larger than a few thousand rupees.
  3. Give a view-only seat or export the period. Do not hand over a net-banking login.
  4. Ask the CA to confirm they can open the file or see what they need within a day, so you find problems early.
  5. Remove the seat or stop sharing once the filing season ends.

How often should I share?

Quarterly works for most freelancers. A small monthly tidy takes ten minutes; a year's worth takes a weekend. If a quarter is lumpy, as it often is, a short note saying so is more useful than a polished sheet.

Where does SpendixAI fit?

SpendixAI imports bank or card statements (PDF, CSV or Excel) with rows reviewed before saving, categorises in stages with your own rules first, keeps receipts with transactions and offers exports including Tally, Zoho Books and QuickBooks templates. It has role-based access, though Pro covers one personal workspace. It does not do invoicing or GST filing, so your invoice register stays in your own sheet.

What if clients pay late or in parts?

Then your register matters even more. Add a row for each part-payment, with the date and the invoice number it belongs to, and keep the invoice amount fixed in its own column. The CA can then see at a glance that INV-016 is ₹60,000 short and may be recovered next quarter.

A credit that nobody can identify is the one that causes the longest email chain, so write the client name beside it the day it arrives. If a client pays two invoices in one transfer, enter the credit once and add a note listing both invoice numbers and the amount for each.

What to send, in one list

  • Invoice register with matched receipts.
  • Categorised cost list with bills.
  • A note on odd credits.
  • Dates the period covers.
SPENDIXAI JOURNAL

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

Explore your reports