Automated Bank Statement Import - Register and Setup

Automated Bank Statement Import - Register and Setup

Automated Bank Statement Import - Register and Setup

Cashbook Platinum

Setup and Registering for Automated Bank Statement Import (PS Bank Feeds)
Practical Systems Automated Bank Statement Import is a simple and secure service that allows the user to automatically import their bank transactions directly from the bank(s) into one or more of the Cashbook companies. This process will save time and ensure complete data accuracy. It provides automatic data entry, while also allowing to allocate or modify account coding, add or modify details, record bank transfers and even apply transactions to outstanding invoices. The user can also find and match transactions that have already been entered into Cashbook
Currently, this service is only available through the following banking institutions:
  •    ANZ (Australian and New Zealand Bank)
  •    Bank of Melbourne
  •    Bank of Queensland
  •    BankSA
  •    Bendigo Bank
  •    Commonwealth Bank Australia
  •    Macquarie Bank
  •    National Australia Bank
  •    Rabobank (all-in-one included) 
  •    Rural Bank Limited
  •    St George Bank
  •    Westpac Bank
If you wish to import from a bank not listed above, please contact Practical Systems and we will see if your bank can be included.
Regional Australia Bank (previously credit union) is not included. 
 

Setup Bank Feeds

Each bank for which the user requires automated transaction import (what we call a Bank Feed) requires individual set up. However, before any banks can be set up, the user must register once for PS Data Feed, from within Cashbook, as detailed below.
  1. Click on Setup
  2. Bank Feed Setup menu option
The entry screen is divided into the following tab sections to provide a step-by-step setup procedure:
  1. General
  2. Register
  3. Banks
  4. Authorisation
  

Step 1: General Tab

  • Tick the Enable Bank Data Feeds box
  • From the drop down menu, check to see if the bank you would like to import transactions is in the list. If the bank is not in this list, you will not be able to use this service. (If the bank is not listed, please contact Practical Systems for further assistance.)
  • Tick the Automate Bank Statement Import On Startup if you want to be taken to Bank Feed Import window to view and import any new transactions, each time Cashbook starts
  • Make sure the bank you would like to import transactions is in the bank list. Click on the down-arrow to search.
 
v. If you would like to specify a Default Expense Account, choose that account from the drop-down list. The default will only be used if an account is not automatically assigned for each transaction by linking to a customer or supplier that itself has a default account. This can speed up the import process a lot, but may require some account re-allocation after the import, depending on the required level of categorisation
vi. If you would like to specify a Default Receipt Account, choose that account from the drop-down list. The default will only be used if an account is not automatically assigned for each transaction by linking to a customer or supplier that itself has a default account
 

Step 2: Account Details Tab

  • Click on the Account Details tab
  • Fill in Details for Entity Name, First Name, Last Name, Email Address and Password
  • Click Register
Note: Your email will become your user name
Note: The password must be at least 6 characters long and contain a mixture of lower and uppercase letters, numbers and symbols
 
If all details are correct, you should receive the following message. If not, correct the error or please contact Practical Systems.

 
Open the Email Verification and click on the link.

 

Note:
  • At any point after the initial registration, you can change your Account Details (i.e. Entity Name, First Name, Last Name, Email Address). After changing details click the Update Details button to save. Note: that if you change your email address, you will get another email confirmation request. This confirmation must be done before you will able to proceed with other Data Feed operations.
  • At any point after the initial registration, you can change your password. After changing password click on the Change Password button.
  • Click on the Deactivate button to cancel your bank feed registration.

 

Step 3: Banks Tab

  • Click on the Banks tab
  • Click on the down arrow to Select a Bank - one of the banks listed in the Chart of Accounts
  • BSB and Account Number automatically filled
  • Click on the drop down arrow beside The selected bank is linked to window, to select the name of the bank your account is with

v. Click Enable Bankfeed
You should receive the following message:
 
vi. Check to see you have an email/s from Practical Systems
vii. Print off the Data Authority Form - you may have one or more of these forms depending on the number of bank accounts you have registered
viii. Sign and post these forms to:
SISS Data Services Pty Ltd
PO Box 98
CROWS NEST NSW 1585
This address can be found on the bottom of the General Data Authority form
DO NOT POST THESE FORMS TO YOUR BANK

For a successful datafeed application the Bank window should now have a Datafeed Id. and Datafeed Status.


  • The Datafeed Status shows what stage the application is at:
    • Action needed - indicates that a PDF authority form (DAF) has been generated and needs to be signed and returned
    • Processing - indicates that a PDF authority form has been received by the operators providing access to your bank data
    • Active - indicates that the bank datafeed service is now available for you to access
    • Error - means the bank has rejected setting up the account due to errors with account numbers, signatures, account type, etc.
  • The Cancel Datafeed button will cancel your datafeed application
  • Get Trans. button - do not click on this button unless instructed by the software or Practical Systems staff

Step 4: Authorisation Tab

  • This enables the current user registered for Bank Data Feeds to authorise another user to import on their behalf. (eg. an accountant), Set  Email Address of Authorised Person to that person's PS Data Feed registered email address
  • There can only be one authorised user at a time
  • You will not be able to import bank transactions until the authorisation has been removed
  • To return authorisation to yourself, set the Email Address of Authorised Person to blank
  • Click on the Assign button to effect the change of authorisation
 
Once the bank Datafeed Status becomes 'active', you can expect to see imported transactions available in Cashbook. The following link shows you how to process those transactions.
Note: Once you have registered for Data Feed, you can add other bank accounts in exactly the same way as  shown above Go to Step 3 - Banks. Bank accounts can be from any of your  Cashbook companies. You do not have to register a second time

The Logout button. Normally, you will be logged in to PS Bank Feeds, whenever necessary, using a special token provided to the software on initial registration. This avoids the need to manually login each time you want to access PS Bank Feeds, and automates the process of fetching the transactions for your bank(s). However, if you wish to disable the automatic connection, you can logout manually, using this button. The next time you need to access PS Bank Feeds, you will need to login manually. Automatic login will then be reinstated until next you manually log out of PS Bank Feeds. This button can be seen from all tabs. When you click on this button, you will receive the following message:
​




Article ID 4221