Using AutoRec to create Bank Statement Files

Importing Bank Statements by scanning the Printed Statements for subsequent Transaction Matching.

Written By Grainne Reidy (Super Administrator)

Updated at March 28th, 2024

Introduction

To produce electronic files of Statement Transactions, you can:

  • Use an On-Line Bank or Credit Card Export facility.
  • Scan hard copies of your Bank or Credit Card Statements. Then, using AutoRec, convert them to an electronic file which you can import into the Bank Reconciliation process.

You should use these facilities as frequently as possible. This allows the system to match and reconcile as many transactions as possible with that of your bank, clearing up any discrepancies between the two as close as possible to the occurrence of any miss-matches.
 

When you first present a Bank or Credit Card Statement, AutoRec will recognise that it is new. The system will then examine and configure the layout and save these details for future processing of these statement types. This initial examination and configuration will take some time, perhaps several hours, to appear in the Bank Statement Inbox. 

See:

Bank Feeds (6B.1) - AIQ Academy

Importing bank statements manually (6B.2) - AIQ Academy

How do I Use the Bank Import Facility to assist with my Bank Reconciliation?‍ 

Delete

Logging into AutoRec and Uploading your Scanned Paper Statement

  1. Scan your single, or multi-page Statement and save it to a memorable location on your Desktop. 
  2. Login to AutoRec. It will have been made available to you by your system provider on request. 
  3. Click your Company Name.
  4. Click Upload to open the Add Bank Statements window.

  1. Click Select Bank Statements. Browse to the location on your Desktop where you saved your scanned Statement and click Open.

  1. When you receive the message, labelled Done, close the window.

  1. If you click Inbox, you may receive a message that your file is queued for processing. If so, log out of the system and wait for the uploaded statement to appear in your Inbox. 

  1. When you logged into the AutoRec system, you provided your email address as the Username. AutoRec will use this email address to send you updates regarding when the uploaded Statement is ready for further processing. On receipt log back into AutoRec to further process the transaction.
Delete

Downloading the Import File

  1. In AutoRec, click on your Company Name to bring up the Bank Statements window.
  2. Click Inbox.

 

  1. The View icon (in red) allows you to examine the contents of the file. The Trash Can icon (in green) allows you to delete files when no longer needed.

  1. Click Download and select from the dropdown.

  1. Click Save to save the resulting file to a memorable location on your Desktop where you can subsequently use it in the Bank Reconciliation Import facility.

See:

Bank Feeds (6B.1) - AIQ Academy

Importing bank statements manually (6B.2) - AIQ Academy

How do I Use the Bank Import Facility to assist with my Bank Reconciliation?‍ 

Delete