Card statement to CSV with Statement to Spreadsheet
This page opens with a card statement the way many issuers print it: dates without a year, purchases as positive numbers, and credits shown in brackets or marked CR. The sign flip is switched on and CSV is the download, so you can see how those conventions turn into a clean transactions file.
- Drop your card statement PDF on the tool. It is read in your browser and never uploaded.
- If the dates have no year, type the statement year in the box that appears so every date is complete.
- Check that purchases show as negative amounts and payments and refunds as positive. Tick or untick the flip option if the signs are the wrong way round.
- Review any amber rows, then press Download CSV.
What to know
Card statements follow different conventions from bank statements. Many print a purchase as a positive number, show a payment or refund in brackets such as (500.00), and mark credits with CR. A converter that copies the signs as printed gives you a file where spending looks like income. Here the tool notices that most amounts are positive and offers to flip them, so purchases become money out and credits become money in.
A label is never flipped. An amount marked CR is always money in and an amount marked DR is always money out, whatever the sign convention of the rest of the statement. Only the printed sign, positive or in brackets, is reversed by the switch, which is what keeps a refund marked CR from turning into a charge.
Dates are often printed as month and day only, such as 03/14. The year is not in the table, so the tool does not invent one: those rows stay held back until you give the statement year, and then every date is written as a full yyyy-mm-dd value in the CSV.
Updated · Cosmovex
Questions
Why do my purchases show as positive numbers?
Many card statements print purchases as positive numbers. The tool detects that pattern and suggests flipping the signs so purchases are negative, meaning money out, and payments and refunds are positive.
What happens to amounts marked CR?
An amount marked CR is treated as money in and an amount marked DR as money out, with or without the sign flip. Only unlabelled amounts follow the flip setting.
The statement has dates without a year. What now?
The tool asks for the year and keeps those rows out of the file until you enter it, because a date without a year cannot be written as a complete date without a guess.
Can I open the CSV in Excel?
Yes. The file starts with a UTF-8 marker so accented descriptions display correctly, and dates are written as yyyy-mm-dd. For Excel, the .xlsx download keeps dates and amounts as typed cells.
Does it read statements from every card issuer?
It needs a header row with a Date column and an Amount column and reads the rows below. Many layouts work, but issuers differ, so check the preview against your statement before using the file.
The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.