How to Convert a Barclays Statement PDF to CSV

Barclays US issues several popular co-branded travel and rewards credit cards. Getting the transaction data out of a Barclays statement - whether through the online activity download or an older monthly PDF - is straightforward once you know the layout and its quirks around travel credits and foreign transactions.

Barclays does not operate checking or savings accounts in the United States. In the US market, Barclays is a credit card issuer, and the cards are typically co-branded with travel and airline loyalty programs. If you have a card branded Aviator Red, Wyndham Rewards, Frontier Airlines, Hawaiian Airlines, JetBlue, or Priceline, your statement comes from Barclays US and is managed through barclaysus.com. Getting these statements into a spreadsheet or accounting tool requires knowing where to find the download and what the file contains.

Barclays US cards covered by these steps

All Barclays US consumer credit cards share the same online portal and statement format. Cards currently or recently issued by Barclays US include:

• AAdvantage Aviator Red World Elite Mastercard (American Airlines miles)
• Wyndham Rewards Earner, Earner Plus, and Earner Business cards
• Frontier Airlines World Mastercard
• Hawaiian Airlines World Elite Mastercard
• JetBlue Plus and JetBlue Business Mastercard
• Priceline VIP Rewards Visa

All of the above produce eStatement PDFs in a consistent format and share the same CSV download tool at barclaysus.com. The steps below apply to all of them.

Method 1: Download a CSV directly from Barclays US

For recent transaction history, Barclays US's built-in export is the fastest path, with no conversion needed.

Steps to download the CSV

• Log into barclaysus.com and navigate to the card account you want to export.
• Go to the Account Activity or transaction history screen.
• Look for a Download, Export, or Print option near the top of the transaction list. Barclays US labels this slightly differently depending on when your account was created, but the button is usually near the date filter or search controls.
• Select a date range and choose CSV as the format.
• Save the file and open it in Excel, Google Sheets, or Numbers.

Understanding Barclays US CSV column format

The Barclays US CSV typically includes these columns: Transaction Date, Description, Category, and Amount. A few things to know:

• Transaction Date: The date the charge posted to your account, not necessarily the date you made the purchase. For travel charges made during a trip, the posting date may be one or two days after the purchase date.
• Description: The merchant name as reported by the payment network, sometimes followed by a city and state. International transactions may include a foreign currency amount in the description text alongside the USD charge amount.
• Category: Barclays assigns a spending category to each transaction. These may not align with your bookkeeping categories but are useful as a starting point.
• Amount: Purchases are shown as positive amounts in the CSV. Credits, payments, and refunds appear as negative amounts. This is the opposite of a bank account CSV, where debits are negative and credits are positive. When importing into a spreadsheet, confirm whether you need to flip the sign on payments to avoid them appearing as income.

Method 2: Convert a Barclays eStatement PDF to CSV

Barclays US monthly eStatement PDFs are available in the portal going back several years. For periods outside the CSV download window, or when you need a specific statement period rather than a date-range export, the PDF is the right source.

Step 1: Download the eStatement PDF from Barclays US

• Log into barclaysus.com and navigate to your card account.
• Find the Statements section. On the Barclays US portal, this is typically in the account menu or under a Documents tab.
• Select the billing period you need and download the PDF.
• Repeat for each additional month you need to cover.

Step 2: Extract the transactions

Barclays US eStatement PDFs use a standard credit card layout: a header with your account details, a billing summary section showing previous balance, payments, purchases, fees, interest, and new balance, followed by a transaction detail section with one charge per row. The layout is clean and consistent across all Barclays US cards.

Copying and pasting from the PDF still produces misaligned data. The two-column layout (left side for charges, right side for credits) means paste output mixes debit and credit rows into the wrong columns. A dedicated PDF converter reads the Barclays layout and produces a properly signed, single-column amount output.

Quill parses Barclays US eStatement PDFs locally on your computer. Drop in the file and it extracts every transaction and lets you export to CSV. No upload, no account connection required.

Step 3: Verify the output

Before importing the CSV anywhere, a quick check against the statement summary is worth doing:

• Transaction count. The Barclays statement does not always print a total count, but it does show a total for purchases and a total for payments in the billing summary. Verify the sum of your CSV purchase rows matches the statement's "Total New Charges" line.
• Rewards credits. Barclays co-branded cards sometimes credit statement credits (for example, a $100 annual travel credit or a bonus reward applied as a statement credit). These appear as credit rows in the transaction detail and should show up as negative amounts in the CSV.
• Foreign transactions. International charges include the original foreign currency amount in the description text and the USD equivalent as the charged amount. The USD amount is what you spent; the foreign currency figure is informational. Verify a few international charges match what you expected to be billed.

Barclays US-specific details worth knowing

Foreign transaction fees

Some Barclays US cards charge a foreign transaction fee (typically 3%) on purchases made outside the US or billed in a foreign currency. This fee appears as a separate line item in the transaction detail, immediately after the purchase it applies to. When converting to CSV, this fee row shows up as its own transaction. For bookkeeping purposes, you can either leave it as a separate "Bank Fees" expense row or combine it with the related purchase amount.

Annual fee and promotional credits

Most Barclays US co-branded cards charge an annual fee, which appears as a charge on the statement where it posts. Statement credits from promotional offers, travel credits, or companion ticket benefits appear as credits in the transaction list. Both are real rows in the CSV. Tag the annual fee as a card fee expense and credits as a reduction against the relevant expense category.

Co-branded loyalty points in descriptions

Barclays co-branded card statements sometimes include points earned information within transaction description text (for example, "3X miles: UNITED AIRLINES"). This text is part of the description string and carries through into the CSV. You do not need to do anything with this information for bookkeeping purposes, but be aware that string searches on merchant names may need to handle this suffix.

Balance transfers and cash advances

If you have taken a balance transfer or cash advance on a Barclays US card, these appear as separate line items in the transaction detail with distinct descriptions. They often have different interest rates than purchases. For bookkeeping purposes, categorize balance transfers as transfers (not income or expense) and cash advances as short-term debt draws.

Which method to use

• Recent transactions, spreadsheet output: Use Barclays US's built-in CSV download from the account activity screen.
• Older history or a specific billing period: Download the monthly eStatement PDF from the Statements section and convert it locally.
• For QuickBooks import: See our companion guide on importing Barclays statements into QuickBooks for account setup and import details.