Overview

The bank reconciliation process can be automated by importing transactions from your bank's online banking site. By importing in a supported format, Readysell can automated your bank reconciliation by:

Automatically matching bank statement lines to transactions or groups of transactions already in Readysell
Automatically creating bank payments or bank deposits for bank statement lines that match a pre-defined criteria

Introductory Video

Setup

Before running automated bank reconciliation, the following must be set up.

Reconciliation Method on each tender (see Tenders). Ensure you have configured the following:
- Reconciliation Method
- Reconciliation Cut Off Time
- Matching Mode
- Site and/or Workstation Reconciliation References (if applicable)
Bank Reconciliation Rules for each recurring transaction (see Bank Reconciliation Rules)
Recurring Bank Payments (see Creating a Recuring Bank Payment)
Ensure that when entering the Direct Deposits working from the Bank Statement, that the date and payment reference are filled in as per what is on the bank statement and the correct tender is used.

Import transactions into the bank reconciliation

Automated Bank Reconcilation from a imported Bank Statement

Extract a new Bank Reconciliation (following the standard process)
Go to your bank's online banking site, export and download an extract of your transactions for the same date range as the reconciliation in either BAI2 or CSV or QIF format. (We have documented the process for some of the common banks below).
In Readysell, click "Import Transactions"
Find the exported file and click "Open"
Depending upon the Bank Reconciliation rules that have been set up transactions such as bank deposits and bank payments may have been auto created.
These transactions are left with a Status = Open
Go to Bank Deposits and Payments, click on show outstanding and review the transactions.
Make any required adjustments/corrections, then post the automatically generated transactions.
Go back to the bank reconciliations. Checked that these transactions have been matched automatically.
Complete your bank reconciliation as usual

Exporting bank transactions with various banks

ANZ

Log into your account
Click on the account you wish to reconcile
Click "Download Transaction History"
Select your account
Fill in the date range based on the bank reconciliation
Select "MYOB(QIF)" from the software drop down
Click "Download"
Save the exported ANZ.qif file to your PC

NAB

Log into your account
Find the account you wish to reconcile, click "Transactions" directly underneath
Click "Show Filter"
Set the "From" date and the "To" date based on the bank reconciliation
Click "Display"
At the top right, click "Export Data"
Select "MYOB(QIF) . There are two types with one is good but NOT the one with the date format of MMDDYY
Click "OK"
Save the exported TransactionHistory.csv file to your PC

Westpac

Log into your account
Click on the account you wish to reconcile
Click "Export"
Fill in the date range based on the bank reconciliation
Select the "MYOB v9 and above" application
Click "OK"
Save the exported Data.QIF file to your PC

Commonwealth

Log into your account
Click on the account you wish to reconcile
Click "Export"
Fill in the date range based on the bank reconciliation
Select the "QIF MYOB' application or QIF Aus 2004
Click "OK"
Save the exported Data.QIF file to your PC

Browser not supported