HomeContactLog in

How to convert bank and credit card statements to Excel

Importing bank statement transactions is straightforward when you set up bank feeds on your accounting software or if you can download a file directly from the bank’s website.

However, sometimes you need to import old transactions from a few years ago or maybe you only have PDF or scanned copies of the statements.

As a busy professional, you don’t have the time to manually enter all this information. Thankfully, there’s a better way. You can use DocuClipper to automatically import the bank statements into Excel or your accounting softare.

Step 1: Select the statements

Click on “Bank and credit card statements”.

Step 1 Select the statements click on bank and credit card statements
Step 1 Select the statements click on bank and credit card statements

Drag and drop one or more statements. DocuClipper works with any text or scanned bank statement. It uses Optical character recognition technology to be able to read scanned statements. You can process multiple statements at the same time.

Click on convert.

Step 1 Select the statements
Step 1 Select the statements

Step 2: Transactions are extracted automatically

DocuClipper extracts all the transactions from the bank statement and other data like balances, dates, account numbers, etc.

Step 2: Transactions are extracted automatically
Step 2: Transactions are extracted automatically

Step 3: Reconcile the statements

DocuClipper compares transaction totals to summary information on the statement. If everything checks out, the statement is identified as reconciled, saving you time and manual review. You can see the reconciliation status on the summary table (top right of the page).

Here’s a video showing how to reconcile the statements:

Step 4a: Convert to Excel

Click on “Download data”. Select “Excel” as the output format. Select XLSX. Click on “Download Data” and the spreadsheet will be downloaded to your computer.

Step 4: Download an Excel or CSV file
Step 4: Download an Excel or CSV file

Step 4b: Convert to CSV

Click on “Download data”. Select “Excel” as the output format. Select CSV. Click on “Download Data” and the spreadsheet will be downloaded to your computer.

Step 5: Configure the output format

With DocuClipper, you can choose which columns to include in the output. Supported fields are “date”, “date2”, “amount”, “debit”, “credit”, “balance”, “account number” and more.

Here’s a video showing how to download the data and customize the output format:

And here’s a video version of this tutorial:

Frequently asked questions

Can DocuClipper convert PDF bank statements to Excel?

Yes, DocuClipper can convert digital and scanned statements from any bank to Excel.

Can DocuClipper convert PDF bank statements to CSV?

Yes, DocuClipper can convert digital and scanned statements from any bank to CSV.

Can DocuClipper convert credit card statements to Excel?

Yes, DocuClipper can convert any bank or credit card statement to Excel.

Can DocuClipper convert scanned bank statements?

Yes, DocuClipper uses Optical Character Recognition (OCR) technology to convert any scanned bank statement to Excel.

Can DocuClipper convert several statements at the same time?

Yes, DocuClipper can convert as many statements as you want in a single job.


Tags

#help-center
Previous Article
How to leave a review on the Intuit App Store

Related Posts

Import ABSA statements into QuickBooks Desktop

Links

Contact Us