How to Convert an HSBC Statement PDF to CSV

HSBC US is one of the few US banks with a genuinely international footprint, offering Premier Checking, Advance Checking, and credit card accounts. Getting transaction data out of an HSBC statement is straightforward - either through the portal's built-in download, or by converting the monthly eStatement PDF with a local tool.

HSBC US operates as a full-service retail bank with checking, savings, and credit card accounts. Customers who maintain HSBC Premier status often use the account for international wire transfers, foreign currency transactions, and multi-country banking - which adds some complexity to statement exports that other banks don't have. This guide covers both the direct CSV download from the portal and the PDF-to-CSV conversion route for older statements.

HSBC US account types covered

The steps below apply to all major HSBC US account types:

• HSBC Premier Checking - the flagship account, often held by high-balance or internationally mobile customers
• HSBC Advance Checking - the mid-tier personal checking option
• HSBC Choice Checking - the everyday checking account
• HSBC US savings accounts - including the Online Savings Account
• HSBC US credit cards - including the HSBC Premier credit card and HSBC Cash Rewards Mastercard

Statement PDF formats are consistent across HSBC US accounts, though the credit card layout differs from the checking and savings layout. Both are covered below.

Method 1: Download a CSV directly from HSBC US

For recent transaction history, HSBC US's built-in download is the fastest route. No conversion needed.

Steps to download the transaction CSV

• Log into your HSBC US account at hsbc.com and navigate to the account you want to export.
• Go to the Account Activity or transaction history screen.
• Look for a Download Transactions or Export button. This is typically located above the transaction list or in the account menu. HSBC US offers multiple formats: CSV, OFX (for Quicken), and QFX (for QuickBooks Desktop).
• Set your date range and select CSV as the format.
• Save the file and open it in Excel, Google Sheets, or Numbers.

Understanding the HSBC US CSV format

The HSBC US checking and savings CSV typically contains these columns: Date, Description, Amount, and Running Balance. A few things to know:

• Date: The date the transaction posted to your account, formatted as MM/DD/YYYY. For international wire transfers, the posting date may be one to two business days after the value date.
• Description: The full transaction description as it appears on your statement. HSBC tends to preserve more detail in descriptions than many US banks, including reference numbers for wire transfers and originating bank identifiers for ACH credits.
• Amount: Credits (deposits, incoming wires, interest) appear as positive values. Debits (purchases, withdrawals, fees) appear as negative values. This is the standard bank CSV convention.
• Running Balance: The account balance after each transaction posts. Useful for spotting discrepancies but not needed for bookkeeping imports.

For credit card CSVs, the column format differs: purchases are listed as positive amounts and payments as negative. This is the opposite of the checking/savings convention and matches standard credit card CSV formatting used by most US card issuers.

Method 2: Convert an HSBC eStatement PDF to CSV

HSBC US keeps several years of monthly eStatements available as PDFs. For periods outside the transaction download window, or when you need a statement-period-specific view rather than a rolling date range, the PDF is the right source.

Step 1: Download the eStatement PDF from HSBC US

• Log into hsbc.com and navigate to your account.
• Find the eStatements or Documents section. HSBC US places this under the account menu or in a dedicated Documents tab, depending on account type.
• Select the statement period you need and download the PDF.
• Repeat for each additional month you need to cover.

Step 2: Extract the transactions

HSBC US checking and savings statement PDFs follow a clean single-column layout: statement summary at the top (beginning balance, total credits, total debits, ending balance), followed by a transaction-by-transaction list with date, description, and amount columns. The credit card PDF uses a two-section layout with a billing summary and a separate transaction detail section.

Copying and pasting directly from HSBC PDFs often produces garbled output. The column structure in the PDF does not translate cleanly to clipboard text, and multi-line transaction descriptions may split across rows. A dedicated PDF converter reads the HSBC layout and produces a clean, single-row-per-transaction CSV.

Quill parses HSBC US statement 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, verify it against the statement summary:

• Transaction count. Count the rows in your CSV and compare against the number of transactions listed on the statement. HSBC statements print a subtotal for each category of transaction (credits, debits) and a final ending balance. Make sure your CSV totals match.
• Ending balance check. Add up all amounts in the CSV starting from the opening balance. The result should match the statement's ending balance to the cent.
• Foreign currency transactions. HSBC US accounts used for international banking often contain transactions in foreign currencies that were converted to USD at the time of posting. The statement lists the USD amount charged plus a description note with the original foreign currency amount and exchange rate. Your CSV will carry the USD amount; the foreign currency detail is in the description text.

HSBC-specific details worth knowing

International wire transfer rows

HSBC Premier customers frequently use the account for international wire transfers. These appear as single transaction rows with a description that includes a reference number, the beneficiary bank's country, and often a correspondent bank identifier. For bookkeeping purposes, categorize outgoing international wires as transfers (not expenses) unless they represent payment for goods or services, in which case categorize them against the relevant expense account.

Foreign currency conversion fees

HSBC US checking accounts do not charge a foreign transaction fee for wire transfers, but some HSBC credit cards do charge one for foreign currency purchases (typically 3%). On credit card statements, this fee appears as a separate line item immediately after the foreign purchase. When converting to CSV, this fee row shows up as its own transaction. Categorize it as a bank fee or travel expense depending on your bookkeeping conventions.

Premier relationship fee or waiver credits

HSBC US Premier and Advance accounts have monthly maintenance fees that are waived when balance requirements are met. If a fee was charged and then reversed in the same statement period, both the charge and the credit appear as separate rows. Neither represents actual income or expense in the traditional sense: the fee charge is a bank fee, and the waiver credit offsets it. In bookkeeping, you can net the two to zero or keep them as separate bank fee and bank fee reversal rows.

Interest credits on savings

HSBC US Online Savings accounts typically credit monthly interest on the last business day of the month. This appears as a small positive transaction with a description like "Interest Payment" or "Interest Credit." For bookkeeping purposes, categorize this as interest income. It is not revenue from operations, so keep it in a dedicated interest income account rather than commingling it with sales or service revenue.

Which method to use

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