Corporate Credit Card Expense Reporting: How to Get Statement Data Into Your Expense System

Every month, the same friction happens in companies everywhere: employees get a PDF credit card statement, the expense system needs line-item transaction data, and there's no clean path between the two.

This guide covers the real options — from direct system integrations to manual CSV imports to PDF conversion — and when each one applies.

The Corporate Card Data Problem

The fundamental issue is a format mismatch. Corporate card issuers send statements as PDFs designed for human reading. Expense systems (Concur, Expensify, SAP, custom Excel templates) need structured data: one row per transaction, fields in specific columns.

The gap between "statement" and "expense report" is where time gets lost. Finance teams spend hours re-entering data that the bank already has in structured form. Employees delay expense submissions because the process is painful. Month-end close gets extended because the data isn't ready.

There are three legitimate paths out of this problem, depending on your card program and company setup.

How Corporate Cards Typically Provide Data

The data your company can access depends heavily on your card program:

Company-wide feed programs: Enterprise card programs from Amex (@ Work), Chase (for Business), Capital One (Spark Business), and Citibank (Corporate) offer direct data feeds to major expense systems. These feed transaction data automatically to your expense platform without any manual export. If your company has more than ~50 cards, you probably have this — check with your finance team.

Individual employee downloads: For smaller programs, or cards not enrolled in the enterprise feed, each cardholder logs in to their card portal and downloads their own transaction history. The data is the same; the delivery is manual.

PDF statements only: Some card programs — especially older corporate accounts or cards from mid-size banks — still only provide PDF statements. These require a conversion step before the data can go anywhere.

Option 1: Your Card Has a Direct System Integration

The best case: your company's corporate card feeds directly into your expense system automatically. No export, no conversion, no manual entry.

How to check if this applies to you:

Ask your finance or AP team. If you're on Amex Corporate, Chase Ink, or Capital One Spark and your company has an enterprise agreement, there's a good chance the feed is already set up. Many employees don't know their card has a direct integration because they've never needed to use it — the transactions appear in the expense system before they even know to look.

Common integrations:

• Amex @ Work → Concur: Automated daily feed. Transactions appear in Concur within 24-48 hours of posting.
• Chase Ink → Expensify: SmartFeed integration, automatic nightly sync.
• Capital One Spark → QuickBooks: Direct bank feed connection available in QBO. For manual import workflows, see our guide on importing credit card statements into QuickBooks.
• Citi Corporate → SAP Concur: Standard for enterprise programs.

If the integration exists but transactions aren't flowing: Check with your IT or finance team about whether your specific card is enrolled in the feed (not just your program — individual cards sometimes need to be activated in the system separately). Also verify your employee profile in the expense system matches the name on the card.

Option 2: Download and Import Manually

If there's no automatic feed, or for card programs that don't support one, the next best option is manual export from the card portal followed by CSV import into your expense system.

Downloading from major corporate card portals:

American Express @ Work: Log in to the Global Account Management portal → select your card → Transactions → Download. Choose CSV or OFX. Amex gives you flexible date ranges — you can pull a full statement period or a custom range.

Chase Ink Business: Log in to Chase for Business → Account Activity → Download Account Activity. Select the statement period and CSV format. Chase's file includes date, description, category (merchant category code), and amount.

Capital One Spark: Log in to the Capital One Business portal → Transactions → Export. CSV download available with date range filtering.

Bank of America Business: Business Advantage portal → Accounts → Download Transactions. QBO, OFX, or CSV options.

File formats — what to choose:

• CSV: Most flexible. Works with Excel, Google Sheets, and most expense systems via manual import.
• OFX/QBO: Designed for Quicken and QuickBooks. Use this if your accounting system accepts it.
• PDF: Only if you have no other option — see Option 3 below.

Importing into your expense system:

Most expense platforms support CSV import but require a specific column layout. Before importing:

1. Open the downloaded CSV in Excel
2. Check what columns your expense system requires (usually: Date, Description/Merchant, Amount, Card/Account number)
3. Rename and reorder your columns to match the required import format
4. Remove any summary rows (opening balance, payment, closing balance) — import tools usually only want transaction rows

Concur CSV import: Upload at Expenses → Import Expenses. Concur maps columns on import — you'll match your CSV columns to Concur fields in a preview step.

Expensify: Use the Expenses → Import Spreadsheet option. Expensify accepts CSV with Date, Merchant, Amount, and optionally Category and Notes columns.

Option 3: Convert the PDF Statement

When you only have a PDF — either because your card program doesn't support direct download, or because you need older statements that predated a feed integration — you'll need to convert the PDF before you can import it anywhere.

What you typically get from a corporate card PDF:

• Transaction date
• Posting date (sometimes different from transaction date)
• Merchant name (may be truncated)
• Transaction amount
• Merchant category (not always present)
• MCC code (sometimes, on Amex and Chase business statements)

What you'll need to add manually:

• Business category/expense type (the system category, not just the merchant)
• Project code or cost center (if your company requires this)
• Business purpose / memo
• Receipt attachment

To convert the PDF, CreditCardToExcel handles most major corporate card formats — Amex, Chase, Capital One, and Citi — and outputs a clean CSV with each transaction on its own row. Processing a 30-transaction statement takes about 30 seconds.

Once you have the CSV, follow the same import steps as Option 2.

Building the Expense Report From Your Spreadsheet

Once your transaction data is in Excel (or your expense system), the remaining work is adding the context that turns a bank record into a compliant expense report.

Separating business vs. personal charges: If employees use corporate cards for personal purchases (many do), those charges need to be flagged for repayment to the company. Add a column called "Business/Personal" and mark each row. Filter to business-only before building your expense report. For a structured approach to tagging expenses, see our expense categories template.

Handling split charges: A single charge that's partly business and partly personal (a hotel stay that includes a personal minibar charge, for example) requires a note and sometimes a partial repayment calculation. Flag these in a "Needs Split" column and address them one by one.

Adding required documentation: For audit compliance, most companies require:

• Receipts for charges above a threshold (often $25 or $75)
• Memo/business purpose for meals and entertainment
• Attendee list for client entertainment above a certain amount

Add a "Documentation Status" column to track what's missing before you submit.

Mapping to expense report fields: Every expense system has its own category structure. Your card's "Restaurant" MCC code doesn't automatically map to your company's "Meals & Entertainment" category. Build a simple lookup table once (merchant type → company category), and the mapping becomes a formula rather than manual work. Our guide on categorizing credit card expenses for taxes covers standard category structures that work well as a starting point for corporate mapping tables.

Uploading to Common Expense Systems

SAP Concur: CSV import is available but often IT-controlled. More practically: once your transactions are clean in Excel, most companies with Concur have employees create expense line items manually in the Concur UI, copying from the spreadsheet. The integration is more valuable for the automatic feed (Option 1) than for CSV import.

Expensify: Most flexible CSV import among major platforms. Go to Expenses → Import Spreadsheet, map your columns, and transactions appear in your expense queue for categorization and receipt attachment.

Excel-only shops: For smaller companies or departments using Excel templates, your combined spreadsheet IS the expense report. Add subtotals by category, a summary tab, and your manager's approval signature line.

Year-End Corporate Card Reconciliation

Finance teams face a specific version of this problem at fiscal year-end: closing all open expense reports before the books close, catching unsubmitted charges, and ensuring cards from departed employees have been reconciled.

The year-end checklist:

1. Pull all transaction data for the fiscal year across all active cards (feed data or manual exports from each card portal)
2. Cross-reference against submitted expense reports — identify any transactions that were never expensed
3. For cards of recently departed employees: contact the cardholder, flag unsubmitted items to their former manager for approval
4. Close out any cards that should be deactivated
5. Document the reconciliation in your audit trail (date reconciled, reconciled by, open items and their resolution)

The biggest year-end problem is usually unsubmitted charges from employees who left the company without completing their final expense report. Having a quarterly reconciliation process — not just annual — prevents this from becoming a year-end surprise.

---

Corporate card expense reporting is mainly a data format problem: the bank has the data in structured form, your expense system needs it in structured form, and the question is how to get from one to the other with minimum manual effort. Direct feeds eliminate the problem entirely. Manual CSV exports plus clean import workflows get you most of the way there. PDF conversion is the fallback when nothing else is available.

For more on getting credit card data into spreadsheets, see the CreditCardToExcel blog.