How to Import HSBC Statements into QuickBooks

HSBC US accounts are common among small business owners and freelancers with international clients. Getting HSBC transactions into QuickBooks is straightforward once you know which import route fits your situation - live bank feed for ongoing sync, QFX for QuickBooks Desktop, or a local PDF converter for older history that predates your current setup.

HSBC US supports both QuickBooks Online and QuickBooks Desktop through multiple import paths. The live bank feed is the best option for ongoing tracking. For historical imports, HSBC offers QFX and CSV downloads from the portal, and older eStatement PDFs can be converted locally and imported manually. This guide covers all three routes and how to handle HSBC-specific transaction types like international wires and foreign currency charges once they are inside QuickBooks.

Setting up an HSBC account in QuickBooks

Before importing any transactions, create the HSBC account in QuickBooks with the correct account type.

• For checking accounts: Account type should be Bank, detail type Checking. Give it a descriptive name like "HSBC Premier Checking ...1234" or "HSBC Advance Checking ...5678."
• For savings accounts: Account type should be Bank, detail type Savings.
• For credit cards: Account type should be Credit Card. Do not set a credit card as a Bank account - the reconciliation and balance calculations will be wrong.
• Opening balance: If you are starting mid-history, enter the statement balance as of the date you want to begin tracking. If you are importing from the start, set the opening balance to zero and let the imported transactions build the balance.

Route 1: Live bank feed in QuickBooks Online

The live bank feed is the cleanest ongoing setup. New transactions appear in QuickBooks automatically and you review and categorize them at your own pace.

• In QuickBooks Online, go to Banking (or Transactions) and click Link account.
• Search for HSBC or HSBC Bank USA.
• Authenticate with your hsbc.com login credentials and any multi-factor authentication step.
• QuickBooks will import roughly 90 days of recent history and then keep the account updated automatically.
• Map each HSBC account to the corresponding QuickBooks account you created: checking to Bank/Checking, savings to Bank/Savings, credit card to Credit Card.

The live feed handles sign conventions automatically. Debits (withdrawals, purchases) reduce the bank account balance or increase the credit card balance. Credits (deposits, payments) increase the bank account balance or reduce the credit card balance. This is correct and requires no adjustment on your end.

Route 2: QFX import for QuickBooks Desktop

HSBC US offers QFX (Quicken/QuickBooks exchange format) files as a direct download from the account activity screen. QFX is the most reliable import format for QuickBooks Desktop because it carries transaction IDs that prevent duplicate imports.

Downloading the QFX from HSBC US

• Log into hsbc.com and navigate to the account you want to export.
• Go to the Account Activity screen.
• Look for a Download Transactions or Export option.
• Set a date range and select QFX as the format.
• Save the file to your computer.

Importing into QuickBooks Desktop

• In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files.
• Browse to the QFX file you downloaded and open it.
• QuickBooks will ask which account to import into. Select the HSBC account you created.
• QuickBooks processes the file and adds the transactions to the Banking Center for review and categorization.

QFX imports carry transaction IDs, so importing the same date range twice does not create duplicates. If you are importing overlapping date ranges, QuickBooks will recognize the duplicates and skip them automatically.

Route 3: CSV import into QuickBooks Online

If you prefer to pre-process transactions before they enter QuickBooks, the CSV download from HSBC US works well. The column format is clean and requires minimal adjustment.

Exporting from HSBC US

• Log into hsbc.com and open your account.
• Go to the Account Activity screen and click the download or export button.
• Set a date range and download as CSV.

Importing into QuickBooks Online

• In QuickBooks Online, go to Banking, click the dropdown next to Link account, and choose Upload from file.
• Select the HSBC account you want to import into.
• Upload the CSV and map the columns: Date to Date, Description to Description, Amount to Amount. The HSBC CSV uses standard column names that QuickBooks usually auto-maps correctly.
• Review the transaction preview. Credits (deposits) should show as positive additions to the account balance, and debits (withdrawals) should show as negative. If they look reversed, check the sign convention in your CSV.
• Complete the import. Transactions appear in the Banking feed for categorization.

Route 4: Convert older HSBC eStatement PDFs and import

For billing history older than the CSV or QFX download window, HSBC US eStatement PDFs are available in the portal going back several years. This is the route for anyone setting up HSBC in QuickBooks mid-year or reconstructing historical records.

Step 1: Download the eStatement PDF

• Log into hsbc.com and navigate to your account.
• Find the eStatements or Documents section.
• Select the statement period you need and download the PDF.
• Repeat for each month you need to cover.

Step 2: Extract transactions with a local converter

HSBC US statement PDFs use a consistent layout. A dedicated PDF converter reads the layout and produces a properly signed CSV with one row per transaction.

Quill parses HSBC US eStatement PDFs locally on your computer. Drop in the file, it extracts every transaction, and you export to CSV ready for QuickBooks import. No upload, no cloud account, no bank login required.

Step 3: Import the CSV into QuickBooks

Use the Upload from file option in QuickBooks Online's Banking section and follow the same column mapping steps as Route 3 above. For QuickBooks Desktop, you can also import a CSV through the Banking Center using the Custom format import.

Handling HSBC-specific transactions in QuickBooks

International wire transfers

HSBC Premier customers frequently send and receive international wire transfers. In QuickBooks, the categorization depends on the purpose of the wire:

• Paying a foreign supplier or contractor: Categorize as an expense in the appropriate expense account (e.g., Contract Labor, Cost of Goods Sold, or the relevant service category).
• Transferring between your own accounts: Use a Transfer transaction in QuickBooks. Do not categorize this as income or expense - it will distort your profit and loss.
• Receiving payment from a foreign client: Categorize as income in your revenue account. Note that the USD amount in the statement reflects the exchange rate at the time of posting, which is the correct amount to record.

HSBC wire transfer fees

HSBC US charges fees for outgoing international wire transfers. These appear as separate debit transactions, often on the same day as the wire or one business day later, with descriptions like "Wire Transfer Fee" or "Cable Fee." Categorize these as bank fees or financial service expenses. They are deductible as business expenses when the underlying wire transfer was for business purposes.

Foreign currency transaction fees on credit cards

Some HSBC US credit cards charge a foreign transaction fee (typically 3%) on purchases billed in a foreign currency. This fee appears as a separate line item in the credit card statement immediately after the purchase. When the CSV is imported, this fee row shows up as its own transaction. Categorize it as a bank fee or travel expense rather than leaving it uncategorized.

Monthly maintenance fee waivers

HSBC Premier and Advance checking accounts have maintenance fees that are waived when balance requirements are met. When a fee is charged and reversed in the same statement period, both transactions import. In QuickBooks, post the fee charge as a bank fee expense and the waiver credit as a bank fee expense reversal (negative amount in the same account). They net to zero and accurately reflect the transaction history.

For a guide focused on getting HSBC data into spreadsheet format without the QuickBooks step, see our companion post on converting HSBC statement PDFs to CSV.