Freelancers need the card statement in a spreadsheet for a different reason from most people: to split what the card spent on work from what it spent on life. Get the text out of the PDF with a copy and Text to Columns, add a Business or Personal column, and total each. The conversion is easy; the tagging is where the value is.
Why the card statement matters more when income is uneven
A salaried person's card is a spending record. A freelancer's card is also a cost record. Software, a co-working day pass, a client's reimbursable travel and your groceries all sit on one statement, and in a month when a client pays late you need to know what the card is actually costing you before the bill falls due. If the statement stays a PDF you will not look at it until the due date.
How do you get the rows out of the PDF?
- Check the PDF is text. Try to select a single line with your cursor; if you can, it is readable.
- Select all the transaction lines for the statement period and paste them into a new sheet, with each line in one cell of column A.
- Choose Data, then Text to Columns, and split on spaces or a fixed width. If the narration contains spaces, split only the date and the amount off the ends and leave the middle as one text cell.
- Delete the repeated page headings and the summary lines.
- Convert the amounts to numbers and the dates to real dates.
If your version of Excel offers an import from PDF under the Data tab, try that first. It can save the splitting step, but results vary by layout, so inspect the rows it brings in.
What columns does a freelancer need?
| Column | Purpose | Example value |
|---|---|---|
| Date | sort and filter by month | 12/09/2026 |
| Narration | what the bank printed | a software subscription |
| Amount | money out | ₹1,499 |
| Use | Business or Personal | Business |
| Client | who it is for, if anyone | blank or a client name |
| Recoverable | can you bill it on | Yes or No |
The Recoverable column is the one that pays for itself. A flight you booked on your card for a client site visit is a cost you may bill onwards; if you do not mark it, you will forget.
What does a lean month look like on the card?
Say the statement shows ₹52,000 of purchases. Tagging gives ₹18,500 of business costs (₹9,000 for tools and subscriptions, ₹6,500 for a client trip you may bill back, ₹3,000 for printing and courier) and ₹33,500 personal. The check is that ₹18,500 plus ₹33,500 equals ₹52,000. If a client pays ₹6,500 back for the trip, your real business cost falls to ₹12,000. With that figure you can see how much income you need before the due date, and you can decide whether to pay the full amount or part of it from whatever you have.
Use SUMIFS to get the totals: =SUMIFS(C2:C60,D2:D60,"Business") for business, and the same with "Personal". Add a third SUMIFS on Recoverable to see what you still need to invoice.
When a spreadsheet becomes a chore
If you do this every month for several months, the repeated cleaning gets tiresome. SpendixAI imports the card PDF, CSV or Excel file with the card chosen as the account, shows the parsed rows for review and lets you set your own categories, so a Business and a Personal split can be done with categories instead of a hand-built column. Receipts can be kept with the transaction. It will not invoice your clients or file anything for you, and you should check the figures with your CA before using them for tax.
Before the due date arrives
- Know the statement total and the minimum amount due.
- Know your business share and the amount you can still bill onwards.
- Check that no subscription is charging you for a tool you stopped using.
- Plan the payment from known income, not from the next client who might pay.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

