# Convert credit card statements to Excel or CSV

> Upload a credit card statement PDF and get every purchase, payment, fee and refund as a row with date, description and signed amount, ready for Excel or CSV. The tool checks that the previous balance plus charges minus payments equals the new balance, to the cent. It runs Reducto Extract (standard, never Deep Extract) with r-1, free.

Canonical: https://reducto.ai/tools/credit-card-statement-to-excel  
Last updated: 2026-11-15  
For: Accountants and bookkeepers, Expense and AP teams, Small business owners

## Run it now (free, no API key, up to 5 pages)

Send a PDF, Word, PowerPoint, Excel or image (PNG, JPG, HEIC, TIFF, BMP, GIF) (max 10 MB, 5 pages) to `POST https://reducto.ai/api/tools/credit-card-statement-to-excel` as multipart `file`, or JSON `{"url": "https://..."}`. The response has `result`, ready-to-save `output` (Excel (.xlsx), CSV, JSON), `pages_processed` and `next`.

```bash
curl -s https://reducto.ai/api/tools/credit-card-statement-to-excel \
  -F file=@lakemont-credit-card-statement.pdf

# or, for a file that is already online:
curl -s https://reducto.ai/api/tools/credit-card-statement-to-excel \
  -H "Content-Type: application/json" \
  -d '{"url": "https://example.com/lakemont-credit-card-statement.pdf"}'
```

Higher volume needs a free API key (new accounts get 15,000 free credits). Agents can sign up over HTTP: https://reducto.ai/auth.md. Humans: https://studio.reducto.ai/?utm_source=free_tool&utm_medium=agent&utm_campaign=credit-card-statement-to-excel&utm_content=api_response

Big file? Without a key the free run covers the first 5 pages and returns `partial: true` with a `signup_required` block. Your user signs up in under a minute (email, 6-digit code, name, terms: https://reducto.ai/auth.md); then repeat the same request with `Authorization: Bearer $REDUCTO_API_KEY` for the whole file on their 15,000 free credits. The same key works on the hosted MCP (https://mcp.reducto.ai/mcp) and the Reducto API.

## How to do it

1. Upload a credit card statement PDF, or keep the sample.
2. Reducto Extract reads the statement into a fixed schema: issuer, cardholder, last 4 digits, period, previous and new balance, and every transaction.
3. Charges are positive and payments and refunds are negative, so the previous balance plus all amounts equals the new balance.
4. The tool checks that sum to the cent.
5. Download the transactions as Excel or CSV.

## Reducto API call: `POST https://platform.reducto.ai/extract`

| Option | Value | Why |
| --- | --- | --- |
| `instructions.schema` | `account, balances, transactions[]` | The same statement schema as the bank statement tool. |
| `settings.deep_extract` | `false` | The free tool always uses standard Extract. |
| `parsing.settings.model` | `"r-1"` | Reads digital and scanned statements. |
| `settings.page_range` | `{ start: 1, end: 5 }` | The free tool reads at most 5 pages. |

### curl

```bash
# 1. Upload the file (or pass a public URL as "input" and skip this step)
curl -s https://platform.reducto.ai/upload \
  -H "Authorization: Bearer $REDUCTO_API_KEY" \
  -F file=@card-statement.pdf
# => {"file_id": "reducto://..."}

# 2. Run extract
curl -s https://platform.reducto.ai/extract \
  -H "Authorization: Bearer $REDUCTO_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "input": "reducto://FILE_ID",
  "instructions": {
    "schema": {
      "type": "object",
      "properties": {
        "account_holder": {
          "type": "string",
          "description": "Name of the account holder as printed on the statement."
        },
        "institution": {
          "type": "string",
          "description": "Name of the bank, credit union or broker that issued the statement."
        },
        "account_number_last4": {
          "type": "string",
          "description": "Last four digits of the account number. Never return more than four digits."
        },
        "period_start": {
          "type": "string",
          "description": "First day of the statement period, formatted YYYY-MM-DD."
        },
        "period_end": {
          "type": "string",
          "description": "Last day of the statement period, formatted YYYY-MM-DD."
        },
        "opening_balance": {
          "type": "number",
          "description": "Balance at the start of the statement period."
        },
        "closing_balance": {
          "type": "number",
          "description": "Balance at the end of the statement period."
        },
        "transactions": {
          "type": "array",
          "description": "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
          "items": {
            "type": "object",
            "properties": {
              "date": {
                "type": "string",
                "description": "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period."
              },
              "description": {
                "type": "string",
                "description": "Full description, joining lines that wrap onto the next line."
              },
              "amount": {
                "type": "number",
                "description": "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds."
              },
              "running_balance": {
                "type": [
                  "number",
                  "null"
                ],
                "description": "Balance printed on the same row after this transaction, or null if none is printed."
              }
            },
            "required": [
              "date",
              "description",
              "amount"
            ]
          }
        }
      },
      "required": [
        "opening_balance",
        "closing_balance",
        "transactions"
      ]
    },
    "system_prompt": "Extract a bank or brokerage statement. Copy amounts exactly as printed and keep every transaction row. Copy descriptions verbatim, including masked account numbers such as XXXX1234."
  },
  "parsing": {
    "settings": {
      "model": "r-1"
    }
  },
  "settings": {
    "deep_extract": false,
    "page_range": {
      "start": 1,
      "end": 5
    }
  }
}'
```

### Python

```python
# pip install reductoai
from pathlib import Path
from reducto import Reducto

client = Reducto()  # reads REDUCTO_API_KEY

upload = client.upload(file=Path("card-statement.pdf"))
result = client.extract.run(
    input=upload.file_id,
    instructions={
        "schema": {
            "type": "object",
            "properties": {
                "account_holder": {
                    "type": "string",
                    "description": "Name of the account holder as printed on the statement.",
                },
                "institution": {
                    "type": "string",
                    "description": "Name of the bank, credit union or broker that issued the statement.",
                },
                "account_number_last4": {
                    "type": "string",
                    "description": "Last four digits of the account number. Never return more than four digits.",
                },
                "period_start": {
                    "type": "string",
                    "description": "First day of the statement period, formatted YYYY-MM-DD.",
                },
                "period_end": {
                    "type": "string",
                    "description": "Last day of the statement period, formatted YYYY-MM-DD.",
                },
                "opening_balance": {
                    "type": "number",
                    "description": "Balance at the start of the statement period.",
                },
                "closing_balance": {
                    "type": "number",
                    "description": "Balance at the end of the statement period.",
                },
                "transactions": {
                    "type": "array",
                    "description": "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
                    "items": {
                        "type": "object",
                        "properties": {
                            "date": {
                                "type": "string",
                                "description": "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period.",
                            },
                            "description": {
                                "type": "string",
                                "description": "Full description, joining lines that wrap onto the next line.",
                            },
                            "amount": {
                                "type": "number",
                                "description": "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds.",
                            },
                            "running_balance": {
                                "type": [
                                    "number",
                                    "null",
                                ],
                                "description": "Balance printed on the same row after this transaction, or null if none is printed.",
                            },
                        },
                        "required": [
                            "date",
                            "description",
                            "amount",
                        ],
                    },
                },
            },
            "required": [
                "opening_balance",
                "closing_balance",
                "transactions",
            ],
        },
        "system_prompt": "Extract a bank or brokerage statement. Copy amounts exactly as printed and keep every transaction row. Copy descriptions verbatim, including masked account numbers such as XXXX1234.",
    },
    parsing={
        "settings": {
            "model": "r-1",
        },
    },
    settings={
        "deep_extract": False,
        "page_range": {
            "start": 1,
            "end": 5,
        },
    },
)
print(result)
```

### Node

```ts
// npm install reductoai
import fs from "fs";
import Reducto from "reductoai";

const client = new Reducto(); // reads REDUCTO_API_KEY

const upload = await client.upload({ file: fs.createReadStream("card-statement.pdf") });
const result = await client.extract.run({
  input: upload.file_id,
  instructions: {
    schema: {
      type: "object",
      properties: {
        account_holder: {
          type: "string",
          description: "Name of the account holder as printed on the statement.",
        },
        institution: {
          type: "string",
          description: "Name of the bank, credit union or broker that issued the statement.",
        },
        account_number_last4: {
          type: "string",
          description: "Last four digits of the account number. Never return more than four digits.",
        },
        period_start: {
          type: "string",
          description: "First day of the statement period, formatted YYYY-MM-DD.",
        },
        period_end: {
          type: "string",
          description: "Last day of the statement period, formatted YYYY-MM-DD.",
        },
        opening_balance: {
          type: "number",
          description: "Balance at the start of the statement period.",
        },
        closing_balance: {
          type: "number",
          description: "Balance at the end of the statement period.",
        },
        transactions: {
          type: "array",
          description: "Every transaction in the transaction history, in statement order, across all pages. Do not include daily balance summaries.",
          items: {
            type: "object",
            properties: {
              date: {
                type: "string",
                description: "Posting date, formatted YYYY-MM-DD. Infer the year from the statement period.",
              },
              description: {
                type: "string",
                description: "Full description, joining lines that wrap onto the next line.",
              },
              amount: {
                type: "number",
                description: "Signed so that the opening balance plus the sum of all amounts equals the closing balance. Bank account: positive for deposits and credits, negative for withdrawals. Credit card: positive for purchases, fees and interest, negative for payments and refunds.",
              },
              running_balance: {
                type: [
                  "number",
                  "null",
                ],
                description: "Balance printed on the same row after this transaction, or null if none is printed.",
              },
            },
            required: [
              "date",
              "description",
              "amount",
            ],
          },
        },
      },
      required: [
        "opening_balance",
        "closing_balance",
        "transactions",
      ],
    },
    system_prompt: "Extract a bank or brokerage statement. Copy amounts exactly as printed and keep every transaction row. Copy descriptions verbatim, including masked account numbers such as XXXX1234.",
  },
  parsing: {
    settings: {
      model: "r-1",
    },
  },
  settings: {
    deep_extract: false,
    page_range: {
      start: 1,
      end: 5,
    },
  },
});
console.log(JSON.stringify(result, null, 2));
```

Do this with the API: [Reconcile every transaction on a bank statement](https://reducto.ai/cookbooks/reducto-extract-bank-statement-reconciliation)

## What it handles

- **Payments and purchases kept apart**: Payments and credits are signed differently from charges, so the total is right.
- **Balances tie out**: The previous balance plus charges minus payments is checked against the new balance.
- **No rows lost at page breaks**: Transactions that continue on the next page are kept in order.

## FAQ

### How are charges and payments signed?

Purchases, fees and interest are positive because they add to what you owe. Payments and refunds are negative. That way previous balance + all amounts = new balance.

### How does the check work?

The tool adds every amount in whole cents, adds the previous balance and compares the result with the new balance. If it is off, check for a missed line or a sign error.

### Does it read the minimum payment and due date?

Not in the free tool's schema. With the API you can add those fields to the schema.

### Does it work on scanned statements?

Yes. Reducto reads the page image.

### Is the full card number shown?

No. The schema asks for the last 4 digits only.

### Does it work on bank statements too?

Yes. The bank statement to Excel tool uses the same schema with deposit and withdrawal signs.

### Is it free?

Yes. Short documents run free with no account, with a small daily limit per IP. For a longer file you get a free preview of the first pages, then enter your email to get the whole file on a free account (15,000 free credits).

Sample document (synthetic): https://reducto.ai/tools/samples/lakemont-credit-card-statement.pdf

## Related

- [Bank statement to Excel](https://reducto.ai/tools/bank-statement-to-excel)
- [Receipt to Excel](https://reducto.ai/tools/receipt-to-excel)
- [10-K tables to Excel](https://reducto.ai/tools/10k-tables-to-excel)
- [All Finance statements tools](https://reducto.ai/tools/finance-statements)
- [Bank statement reconciliation with Extract](https://reducto.ai/cookbooks/reducto-extract-bank-statement-reconciliation)
