If you use an Asda Money card for everyday spending, your Asda Money statements for tax filing hold more than a record of groceries and fuel. For anyone who is self-employed, runs a small side business, or claims work expenses, those monthly statements contain deductible costs mixed in with personal spending, and the only way to separate them reliably is to convert Asda Money bank statement PDF to Excel and work through the transactions row by row. This guide shows you how to turn a year of card statements into a tax-ready record without guessing.
Why card statements need extra care at tax time
Bank account statements show money moving in and out, but credit card statements show spending on credit, which makes them trickier for tax work. A payment to your card is not an expense; the expense happened when you made the purchase. That distinction trips up many first-time filers, who total their card payments and call it spending, which understates some categories and double counts others. The correct approach is to work from the individual transactions on each statement, not from the monthly payment totals.
Card statements also mix categories freely. A single month might contain business travel, office supplies, personal groceries, and a family gift, all in one list. Sorting that list in a PDF is painful. In a spreadsheet, you can filter by merchant, sort by amount, and tag each row as business or personal in an afternoon. That tagged list becomes the backbone of your expense claim.
Convert to Excel and separate business from personal
Start by downloading all twelve monthly statements and converting each PDF to Excel, then combine them into one workbook. Add two columns every filer needs: a category column and a business-or-personal flag. Work through the transactions in date order and be strict with yourself. A lunch with a client is business; a lunch alone on a workday usually is not. Fuel for a business trip counts; the weekly family shop does not, even if you picked up printer paper on the same trip. When a purchase is genuinely mixed, split the row and note your reasoning in a comments column.
Two card-specific items deserve attention. First, interest charges and late fees on the card are generally not deductible business expenses in the way the underlying purchases are, so keep them in their own category rather than folding them into spending totals. Second, cashback and rewards are not income in the usual sense, but keep a note of any large reward redemptions so you can answer questions about them if they ever come up. Your goal is a workbook where every row has a defensible label.
Total your deductions and check them twice
Once every row is tagged, use your spreadsheet to total each business category for the full year: travel, supplies, phone and internet, subscriptions, professional fees, and any other category your work involves. Compare the annual totals against your own memory of the year. If travel looks far lower than you expected, you probably left a few trips tagged as personal. If supplies look far higher, you may have included personal purchases by mistake. These sanity checks catch most errors before they reach a return.
Cross-check the card totals against your bank account as well. Every card payment in your bank statements should match a payment on the card statements, and the total you paid toward the card during the year should reconcile with the card's own records. If the two sides disagree, find the difference now. A mismatch usually means a payment that cleared in January for a December balance, or a refund that was applied to the card rather than to your bank account.
Build a record your accountant can trust
When the workbook is clean, put together a short summary: total business spending by category, total interest and fees kept separate, and a list of any items you flagged as uncertain. Attach the original monthly PDFs behind the workbook, and keep both together as your record for the year. Most tax authorities expect you to keep supporting records for several years, so store the folder somewhere backed up and do not rely on the card provider's online archive alone.
If anything in your statements is unclear, such as a merchant name you do not recognize or a charge you never made, resolve it before filing. An unexplained charge is either a forgotten purchase or an error, and both are easier to fix now than after a return is submitted. For a broader look at statement-based filing, see our guide on using a bank statement for an income tax return.
Frequently asked questions
Should I total my card payments or my card purchases for tax?
Your purchases. Card payments are transfers toward a balance, not expenses. Work from the individual transactions on each statement to avoid double counting.
Can I claim a purchase that was partly personal and partly business?
Yes, claim only the business portion and split the row in your spreadsheet with a note explaining the split. Keep the receipt if the amount is large.
Are interest charges on my Asda Money card deductible?
Keep interest and fees in their own category and ask your tax adviser how they apply to your situation. Do not fold them into ordinary spending totals.
How long should I keep my card statements after filing?
Keep the original PDFs and your workbook for several years after filing, stored somewhere backed up. Check the record-keeping rules that apply in your country for the exact period.
A clean workbook turns a stressful filing into a routine one. Convert your Asda Money statements to Excel today, separate business from personal spending, and file with numbers you can stand behind, or see pricing if you have more than 8 pages to convert.