Extract bank statement data in Hubdoc (USA and Canada)

Overview

  • Convert a PDF bank statement to a CSV file of transactions which you can import to Xero or Quickbooks.
  • Submit a request to add your bank to the statement extraction feature.

What you need to know

How it works

You can use Hubdoc to extract the transactions in your PDF bank statement and convert the data to a CSV file. You can then import the CSV file to Xero or Quickbooks to reconcile your transactions.

Hubdoc can extract data from debit or credit statements:

  • Debit statements – Hubdoc will extract the date, description and amount for each transaction.
  • Credit statements – Hubdoc will extract the posted date, transaction date, description and transaction amount.

For Hubdoc to export your data, your file must:

  • Be a PDF statement downloaded directly from your bank’s online banking platform – you can’t use a statement converted from a different format to PDF, an image of a statement, or a scanned or faxed file.
  • Be a debit or credit statement – other types of financial statements, such as mortgage documents and cheques, are not supported.
  • Only contain one statement – if you have multiple statements, you need to upload each individually.
  • Meet Hubdoc’s upload requirements – the maximum file size for a document in Hubdoc is 35MB.

Supported banks

Hubdoc can extract data from selected statement types from the following banks:

  • Chase Bank
  • Royal Bank of Canada
  • TD Canada Trust Bank
  • Wells Fargo

If your bank isn’t supported, you can request to add it while logged in to Hubdoc.

Extract bank statement data

Before you start, you’ll need to download a PDF bank statement from your bank’s online banking platform. If you’re unsure how to do this, contact your bank.

To extract your bank statement data:

  1. Upload your bank statement to Hubdoc.
  2. Once uploaded, find and open the statement in Hubdoc, then click Edit Document to open the data toolbar.
  3. Under Document Type, select Statement.
  4. Under Financial Institution, select the bank your statement is from.
  5. Under File Format, select your preferred file format for the exported data.
  6. Click Generate CSV.

Once the extraction is complete, your transactions will download as a CSV file to your device.

Note that Hubdoc might create multiple CSV files to meet the import requirements of the selected file format. For example, the import limit for Xero is 1,000 transactions per CSV file. If you select Xero CSV as your file format and your statement has more than 1,000 transactions, Hubdoc will export your data to a zip folder containing multiple CSV files.

If you notice an issue with your CSV data, you can report it.

Request a bank

If your bank isn’t supported, you can request to add it while logged in to Hubdoc.

Before you start, you’ll need to download a PDF statement from your bank’s online banking platform and upload it to Hubdoc. We’ll use this information if we choose to make the feature compatible with your bank.

Once you’ve uploaded a statement from your bank:

  1. Find and open the statement, then click Edit Document to open the data toolbar.
  2. Under Document Type, select Statement.
  3. Under Financial Institution, click Request a new bank.
  4. Enter the name of your bank.
  5. Click Request bank.

You can refer to this article for an up-to-date list of supported banks.

What's next?

Now you’ve extracted the transactions from your statement, import the CSV file to Xero (Xero Central website) or Quickbooks (Quickbooks website) to reconcile them.

 

Was this article helpful?
0 out of 0 found this helpful
Questions? Raise a case on Xero Central. If you don't have a Xero login, click here.