close

PS Cashbook

Automated Bank Statement Import - Register and Setup

Detailed Description

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 you to automatically import your bank transactions directly from your bank(s) into one or more of your Cashbook companies. This process will save you time and ensure complete data accuracy. It provides automatic data entry, while also allowing you to allocate or modify account coding, add or modify details, record bank transfers and even apply transactions to outstanding invoices. You can also find and match transactions you have already 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) not included as they want us to go through a different 3rd party (other than SISS). 

 

1. Setup Bank Feeds

Each bank for which you require automated transaction import (what we call a Bank Feeds) requires individual set up. However, before any banks can be set up, you must register once for PS Data Feed, from within Cashbook, as detailed below.

  • Click on the Setup > Bank Feed Setup menu option.

    • The entry screen is divided into the following tab sections to provide a step-by-step setup procedure:

      • General

      • Register

      • Banks

      • Authorisation

  

Step 1 - General tab

  • Tick the Enable Bank Data Feeds box.

  • From the drop down menu, check to see if the bank for which you would like to import transactions is in the list. If your bank is not in this list, you will not be able to use this service. (If your bank is not listed, please contact Practical Systems for further assistance.)

  • Tick the Automate Bank Statement Import On Startup if you wish 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.

 

  • If you would like to specifiy 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 your required level of categorisation.

  • If you would like to specifiy 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 NameFirst NameLast NameEmail Address and Password.

  • Click on the Register button. 

(Note: Your email will effectively 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 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 your 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.


  • Click on the Enable Bankfeed button.

  • You should receive the following message:

 

  • Check to see you have an email/s from Practical Systems.
  • 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).
  • Sign.
  • Post these forms to:
    • SIS 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 succesful datafeed application the Bank window should now have a Datafeed Id. and Datafeed Status.


  • The Datafeed Status shows you what stage your 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 your 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.

Note:  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:

 

How do I import bank transactions? (Automated Bank Data Feed processing)

Was this helpful?

Not helpful ( ) Very helpful