When your CA asks for Tally-format expenses, give them one export for the period with each row tagged to a business expense head, not a pile of screenshots. Freelancers have mixed accounts and irregular months, so the work is mostly in separating business from personal before you export. Do that once a month and the year-end request takes minutes.
Why freelancers get this request
Your CA needs your costs to build the profit-and-loss view of your work. If you send screenshots from three apps, they retype all of it. If you send a structured list, they can import it and spend their time on judgement instead of typing.
Separate before you export
- Business: software subscriptions, co-working, travel to clients, equipment, internet share, freelance contractors.
- Personal: groceries, rent for home, family transfers.
- Mixed: phone and internet. Agree a sensible split with your CA and record the split basis.
What would a month look like?
Say in a month you paid ₹1,999 for design software, ₹2,500 for a co-working pass, ₹1,250 for a cab to a client, ₹6,000 to a freelance illustrator and ₹850 for printing. You also have ₹32,000 of home rent and ₹9,000 of groceries, which stay out.
| Business head | Items | Total in ₹ |
|---|---|---|
| Software | Design subscription 1,999 | 1,999 |
| Workspace | Co-working pass 2,500 | 2,500 |
| Travel | Client cab 1,250 | 1,250 |
| Contract work | Illustrator 6,000 | 6,000 |
| Printing | Client prints 850 | 850 |
| Business total | Five heads | 12,599 |
The check: 1,999 + 2,500 + 1,250 + 6,000 + 850 = 12,599. The rent and groceries, which total 41,000, stay in your personal records.
Which steps get you to an export?
- Upload or add the month's statements, choosing the account before importing.
- Review each row and save.
- Apply business categories, and set rules so recurring merchants go to the right head next time.
- Check the total of business rows against your expectation.
- Export using the Tally template and send it with a short note.
SpendixAI covers these steps: statement import from PDF, CSV or Excel with a review before saving, your own category rules, and an export centre with a Tally template. It does not connect to your bank, and it does not do GST filing or invoicing, so it supports your books rather than replacing your CA's work.
What if a client has paid you in a way that confuses the statement?
Keep income handling separate. Match each client payment to its invoice in your own list, and tell your CA about anything unclear instead of forcing it into an expense head. GST questions in particular should be settled with your CA, since figures in any tool are estimates.
How do you handle income and expenses together?
Your CA may want to see what came in beside what went out. Keep client receipts in the same period and tag each with the client name. If a client paid ₹30,000 and your project costs were the ₹12,599 from the example, the rough gap is 30,000 - 12,599 = ₹17,401. That is only a working figure, before your time, taxes and other overheads, and it is not a profit figure for any filing.
- Match each payment to an invoice number in the narration.
- Note part-payments as part-payments.
- Flag any payment that arrived from someone other than the client.
These small habits spare your CA from writing back with "whose money is this?"
A quarterly rhythm
- Month-end: import and categorise.
- Quarter-end: export and send, even if your CA has not asked.
- Year-end: review heads with your CA for the next year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

