A freelancer's card statement mixes three kinds of spending: personal, business you will absorb, and things a client will reimburse. When descriptions wrap across lines and a converter splits them, you cannot tell which is which. Fix the structure first, then tag every row once, then total each tag, and your CA gets a sheet instead of a PDF.
Why does this matter more when income is irregular?
In a month with a big client payment you will not notice a stray subscription; in a thin month you will. Knowing what your card cost the business in a month that earned nothing is how you decide whether a tool or a desk is worth keeping. Late or unpaid clients make the reimbursable column important too, because the money you have fronted is money you are waiting on.
Step 1: get one row per transaction
Paste or convert the statement onto a raw tab. Continuation lines usually have text but no date. Use a helper in D2 such as =IF(A2="","",B2&IF(AND(A3="",B3<>"")," "&B3,"")), then filter out blank results. Check the sum of your purchases against the statement before you move on.
Step 2: build a small alias table
Card descriptions look like SAMPLE DESIGN TOOL 4421 MUMBAI. Put the first word of each recurring merchant in column H and the label you want in column I, for example SAMPLE in H2 and Design software in I2. Then in E2 use:
=IFERROR(VLOOKUP(LEFT(D2,FIND(" ",D2&" ")-1),$H$2:$I$50,2,FALSE),"Check")
Anything that returns Check is a merchant you have not labelled yet. Add it to the table once and every future month benefits.
Step 3: tag every row three ways
| Tag | Meaning | Example |
|---|---|---|
| P | Personal | Groceries |
| B | Business cost you carry | Design software, co-working desk |
| R | Reimbursable by a client | Train fare to a client site |
Say one month shows: design software ₹1,180, co-working desk ₹4,500, train fare for a client meeting ₹640, groceries ₹2,300, a family dinner ₹1,850. With tags in column F, =SUMIFS($C$2:$C$500,$F$2:$F$500,"B") gives 1,180 + 4,500 = ₹5,680. The reimbursable total is ₹640 and the personal total is 2,300 + 1,850 = ₹4,150. Altogether ₹10,470, which should match the card's purchases total.
Does the reimbursable column need follow-up?
Yes. Add a column for Billed on and Paid on. A row tagged R with no Billed on date is money you have spent and not yet asked for. Review that column when you do your monthly invoicing round, not when a client suddenly asks for receipts.
When a sheet stops being enough
After a few months of monthly paste, helper and alias upkeep, many freelancers want the clean-up done once and remembered. SpendixAI accepts card statements as PDF, CSV or Excel, shows the rows for review before saving, and learns from your corrections, with merchant aliases you can add. The Export centre can produce Tally, Zoho Books or QuickBooks templates if your CA uses one of those. It is not an invoicing or GST filing tool.
A month in which a client pays late deserves one more column: Cash position. Put the card bill's due amount next to the money you actually have in the account that pays it. If the bill is ₹10,470 and ₹3,000 of that is reimbursable and unbilled, you know how much of your own money is tied up in other people's projects. That number, more than any category total, shapes who you chase first.
Keep the raw tab for each month. When a client queries a cab fare or a software charge, the original wording from the statement is what you point to.
Monthly routine, five minutes
- Download the new statement and paste to the raw tab
- Run the join helper and check the purchases total
- Add new merchants to the alias table
- Tag P, B or R on anything left
- Chase any R row with no Paid on date
Useful ideas start with a clearer picture of your own spending.
Explore your reports


