Credit card statement to CSV
Credit card statements are the richest expense record most businesses have, and the hardest to use. The transactions are grouped by cardholder or category, purchases print as positives, and interest and fees hide in their own block at the end.
Drop a credit card statement
Drop your PDF statement here
or click to browse · 10MB max · nothing is stored
Sign convention for cards
On a card, a purchase increases what you owe. In accounting terms the card is a liability, so purchases export as negatives and payments and credits as positives. That is what QuickBooks, Xero and every other package expects when the CSV is mapped to a credit card account.
Multiple cardholders
Corporate and family cards print charges grouped by cardholder. The cardholder is carried into the description so spend can be split per person with a pivot table instead of by re-reading the PDF.
Fees, interest and foreign currency
The lines that matter for accuracy are the ones people skim past:
- Interest charges, which are an expense and not part of the purchase total
- Annual and late fees, which belong in their own category
- Foreign transaction fees, usually a separate line from the converted charge
- Statement credits and refunds, which offset spend rather than adding income
Reconciling a card statement
Previous balance, plus purchases, plus fees and interest, minus payments and credits, should equal the new balance. If the converted rows satisfy that equation, nothing was missed.
Frequently asked questions
+Which card issuers are supported?
Any issuer. Visa, Mastercard, Amex, Discover and retailer store cards all convert, since the layout is read from the document itself.
+Are rewards points converted?
No, points are not currency movements. Cash-back credits posted to the balance are included.
+Can I split business and personal spend?
Yes, convert the full statement then filter in the spreadsheet, which keeps the complete record intact.