HomeContactLog in

Import bank statements into Sage

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 click on Bank and credit card statements
Step 1 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 2 select the statements
step 2 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 3 Transactions are extracted automatically
step 3 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 4: Download a Sage CSV file

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

Import the Web Connect file into Sage 1
Import the Web Connect file into Sage 1

Step 5: Upload your file to Sage

  1. Go to Banking. Select the account you want to import transactions to.

  2. From Actions select the drop-down arrow and Import statement.

Import the Web Connect file into Sage 1
Import the Web Connect file into Sage 1

  1. Set the file type to CSV 3 columns.

  2. To add the file you can either: Choose Select file and find the bank statement file on your computer. Select Open to add the bank statement. or Drag and drop the file.

  3. Select the date format used in your file so we can process it correctly. Choose either:

    • Day, month, year
    • Month, day, year
    • Year, month, day
  4. Add a comment to help you identify the import later.

  5. Select upload file.

Import the Web Connect file into Sage 2
Import the Web Connect file into Sage 2

Step 6 Verify transactions

After the file upload, you need to tell us which transactions show:

  • money coming into the account
  • money coming out of the account

To help with this, one of your transactions will be displayed on screen. You need to confirm your transaction as either money in or money out of the account. We will apply this rule to the rest of your transactions.

Import the Web Connect file into Sage 3
Import the Web Connect file into Sage 3

Step 7 Review transactions

All your transactions will be listed and shown as either money in or money out of the account. If there are errors with the way these are categorized, you can go back to the Verify screen.

Import the Web Connect file into Sage 4
Import the Web Connect file into Sage 4

Once you have reviewed the transactions select Import transactions. You will be taken back to the Banking screen. Once the transactions have been imported into your account, they will show on your banking tile.

Review bank transactions The number of imported transactions from your statement are shown on the Banking page. Select the number to view all transactions on the incoming bank transactions page.

The Imported from statement message shows each transaction that has been imported from your bank statement.

Match, create or transfer transactions For each transaction you need to choose whether to:

  • Match transactions to bank rules

  • Match transactions to outstanding invoices, credit notes or receipts

  • Create a new transaction

  • Transfer from or to a different account

  • Delete transactions you don’t want to import

Import the Web Connect file into Sage 5
Import the Web Connect file into Sage 5

For more information check out the official Sage article.

Yes, DocuClipper can import digital and scanned statements from any bank into Sage.

Can DocuClipper import credit card statements into Sage?

Yes, DocuClipper can import any bank or credit card statement into Sage.

Can DocuClipper import scanned bank statements?

Yes, DocuClipper uses Optical Character Recognition (OCR) technology to import any scanned bank statement into Sage.

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
Import bank statements into Xero

Related Posts

Import invoices into Excel and QuickBooks

Links

Contact Us