Convert PDF Bank Statements to CSV Files Using Hubdoc For Import Into QuickBooks Online

Managing bank statements can be a bit overwhelming, especially if you’re dealing with PDFs and need to import transactions into QuickBooks Online (QBO).

Thankfully, Hubdoc easily converts PDF bank statements into a CSV format that you can upload into QBO.

In this guide, I’ll walk you through the step-by-step process of using Hubdoc to convert your PDF bank statements and import them into QuickBooks.

Quick Instructions:

  1. Log into Hubdoc
  2. Click the Upload Documents button at the top of the screen
  3. Click Bank Statement Upload
  4. Browse to your file
  5. When completed, close the Upload pop-up
  6. Find your statement in the All tab
  7. Select Bank and File Format in the BANK STATEMENT EXTRACTION box on the right
  8. Click Generate CSV
  9. Click Download
  10. Import CSV into QuickBooks Online

Keep reading for a complete walkthrough with screenshots:

Convert PDF Bank Statement to CSV

The first step is to upload the PDF of your bank statement to Hubdoc.

Log into Hubdoc and click the green Upload Document button at the top of the screen.

Upload Document button in Hubdoc

In the Upload pop-up, click the Bank Statement Upload box. Click Browse and find the statement. When it’s finished, click the X in the corner to close the pop-up.

Upload a PDF bank statement to Hubdoc for converting to CSV

Once uploaded, Hubdoc will begin processing the document. Depending on the size of your bank statement, this process could take a few minutes.

Once Hubdoc processes the PDF, you’ll find it in the All tab.

When you click on a statement in the list of documents, it will appear in the middle of the screen. On the far right, look for the gray BANK STATEMENT EXTRACTION box.

Bank statement extraction box in Hubdoc where you select the bank and file type for converting PDF bank statements to CSV

In the Bank drop-down, select the bank that issued the statement. In the File Format drop-down, select QuickBooks CSV. Then click the Generate CSV button.

Generating a QuickBooks CSV from a Bank of America PDF bank statement using Hubdoc

This could take about a minute.

I got an orange box warning me of problems with the extracted data. 

Whether you get a warning or not, click the green Download button to download the CSV file.

Below is the bank statement I converted. It contains all the purchases, but it’s missing any payments. This could be why I got the warning message shown above:

CSV file created by Hubdoc from a PDF bank statement

Import Into QuickBooks Online

Now that I’ve got a CSV, I will upload these transactions into QuickBooks Online. 

Within QuickBooks click Transactions -> Bank transactions in the left side menu.

Navigating to Bank Transactions from the left side menu in QBO

No Connected Accounts

If you don’t have bank accounts connected yet, click the Upload transactions button.

Uploading transactions into QBO when you don't have any banks connected

Connected Bank Accounts

If you have bank accounts connected to QuickBooks, click the drop-down arrow next to Link account on the right.

Select Upload from file.

Upload from file option in QBO for importing a CSV of transactions

Manually Upload Your Transactions

Step 1 is to drag and drop or navigate to your file using the Manually upload your transactions box. Then click Continue.

Manually upload your transactions into QBO, step 1, file upload

In step 2, select the correct QuickBooks Account from the drop-down menu, then click Continue.

Selecting the correct QuickBooks Account for your imported bank transactions in QBO

In Step 3-1, check that everything in the drop-down boxes is correct.

In Step 3-2, check that the columns match the QuickBooks fields.

Then click Continue.

Importing Bank Transactions into QBO, step 3

Step 4 shows you a list of the transactions. 

Take note of the radio buttons at the top. Keep original values and Reverse all values.  

These are purchases, so negatives are correct, and I’ll select Keep original values.

Note: If you select the wrong one, exclude all the imported transactions and re-upload them, making sure to select the opposite radio button next time.

Click the checkbox at the top to select all transactions or check off individual transactions you want to import. Then click Continue.

Click Yes on the pop-up that shows how many transactions are importing. Then click Done in step 5.

Your transactions are now imported and will be listed under For review.

Bank transactions under For review after importing into QBO from a PDF converted into a CSV using Hubdoc

Scroll down if you’d like to watch a video walkthrough of this process.

☕ If you found this helpful, you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

If you have questions about importing transactions into QuickBooks Online, click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Learn how to use Saasant to upload multiple checks to QuickBooks Online for printing.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.