Convert a bank or credit card statement in PDF format to CSV/Excel format and import into Excel, Quickbooks Online, Xero, Quicken for Mac

This tutorial shows how to convert a PDF file from your bank or credit card statement to CSV format and import into Quickbooks Online. We will use the PDF2CSV utility. IMPORTANT: PDF2CSV is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Step by step instructions for Windows

Follow the steps below for the Windows version, followed by the Mac version.

Make sure you are using the latest version of PDF2CSV. Download it from the PDF2CSV download page. Start PDF2CSV and select a PDF file. Review transactions before converting. Check that dates are correct, have the correct year, amount, withdrawals and deposits are shown in corresponding columns. 

Try the different PDF Library if your PDF file is not parsed correctly by the selected library. You can change the PDF library for better parsing a specific PDF file. 

Check with your accounting software for the expected format, in many cases, it has to be the system where you import data, expected for Quicken and Quickbooks. Set the year if missing manually. 

Choose the CSV Target: Regular CSV, Excel (XLS or XLSX), Quickbooks Online, Xero, Quicken for Mac (CSV Mint), POSH or copy to clipboard to be pasted into any spreadsheet software like Excel. 

Set the Date format for Quickbooks Online. Quickbooks online imports with Date format as MM/DD/YYYY. 

Click the 'Convert' button to create a CSV file. For Excel targets, an Excel file will be created. 

Confirm the file name and location. 

Import created CSV file into Quickbooks Online

Now the CSV file is created, let's switch to Quickbooks online and import created CSV file. Look for 'Banking' and click on it.

The next step is to select an account and click the 'File Upload' button. 

Then click the 'Browse' button and select the created CSV file, click 'Next'. 

Then select an account in Quickbooks to import and click 'Next'. 

The next step is to confirm the mapping and date format. Date and Description columns should be preselected and the amount column needs to be set. Click the 'Next' button. 

Review transactions in Quickbooks online, before importing and click the 'Next' button. 

Finish the import by on the next step. Once the transactions are imported, you can review and categorize them under the account. 

Step by step instructions for macOS

Make sure you are using the latest version of PDF2CSV. Download it from the PDF2CSV download page. IMPORTANT: PDF2CSV is now replaced with the Transactions app, which converts from more formats and converts to more formats.

Start PDF2CSV and select a PDF file.Review transactions before converting. Check that dates are correct, have the correct year, amount, withdrawals and deposits are shown in corresponding columns. 

Choose the CSV Target: Regular CSV, Excel (XLS or XLSX), Quickbooks Online, Xero, Quicken for Mac (CSV Mint), POSH or copy to clipboard to be pasted into any spreadsheet software like Excel. 

Set Output Dates for Quickbooks Online. Quickbooks online imports with Date format as MM/DD/YYYY. 

Click the 'Convert' button to create a CSV file. For Excel targets, an Excel file will be created. 

Confirm the file name and location. 

Import created CSV file into Quickbooks Online

Now the CSV file is created, let's switch to Quickbooks online and import created CSV file. Look for 'Banking' and click on it.The next step is to select an account and click the 'Upload' button. 

Then click 'Browse' and select created CSV file, click 'Next'. 

Then select an account in Quickbooks to import and click 'Next'. 

The next step is to confirm the Mapping and Date format. Date and Description columns should be preselected and the Amount column needs to be set. Click the 'Next' button. 

Review transactions in Quickbooks online, before importing and click the 'Next' button. 

Finish the import by on the next step.  

Once the transactions are imported, you can review and categorize them under the account.