Search This Blog

Wednesday 10 April 2013

Bank Feeds Explanation

“Bank Feeds” is a term being used to describe the automatic transmission of bank transactions into Accounting Software.  The Accounting Software uses third party applications such as Yodlee or BankLink or direct file transfer to download the transactions from the Banks.  An authorisation must be provided to the Bank to link the bank & accounting software.  This process can vary depending on the bank and the software.

Setup

ü   Initial setup requires authorisation to link the Accounting Software with the Bank used by the client.  There are 2 methods used to provide authorisation:-
  1. Authority form signed by the client and sent to the Accounting Software company.  This form is typically produced through the software and a different authority form is required for each bank or credit card to establish the bank feed.
     
  2. Provide your Online Banking Client ID# & password which is used by some accounting software to access & download the bank transactions from the banks online services. (Check your terms & conditions with the bank & review security)
ü After authorisation, you are required to create a link in the software between the respective bank and/or credit accounts set up for bank feeds and the appropriate account in the accounting software.

ü All Software allows changes to the bank feed setup including passwords. 
 
J  You are now ready to receive Bank Feeds !!!

Retrieving Bank Feeds
Transactions will either be automatically downloaded when you login or you are required to select the Bank or Credit Card you wish to retrieve & click on the update/retrieve button.     You may be asked to key in clients login and password

Processing Transactions received
All software will download the bank feed transactions in to a bank feed transaction screen for the operator to either match, create or transfer transactions within the accounting file.

·    Each Bank Feed Processing Screen will commonly show the bank feed transactions on the LEFT & the transaction that has been found or created in the software on the RIGHT. 

·    Upon download, all software will intuitively try & match bank feed transactions to existing transactions within the accounting file.

·    The software uses the bank feed transaction field’s description, date or amount to provide a possible suggestion for matching.

With the remaining unallocated transactions either:-  MATCH - Find an existing transaction within the accounting file. OR

CREATE - Create transactions with the accounting software, allocate an account, add a contact if required & define the tax code.  This may include making a customer or supplier payment to clear invoices.
 

ü Create Rules

Most accounting software has the feature of creating rules which will enhance the automatic matching. A rule is a ‘criteria’ set that can automatically find a transaction, apply it to the account & add a description in the memo field. Some software will allow multiple conditions which helps to marry the bank feed transaction to the rule.

All rules require the following:- 
  1. Rule Name – A name that resembles the transaction ie Merchant Fees
  2. Stipulate which Bank account the rule relates to
  3. Description: This description must match ‘some part’ of the bank’s description’ for the software to find the transaction & automatically match it to the rule  See below ‘merchant fees example’ you would use MERCH FEE as the description in the rule
Bank Statement Description
AUTOMATIC DRAWINGS
MERCH FEE000044455566 ABC ARCHITECTS 00233

Allocate an expense or income Account for the transaction

The rules within all accounting software will apply the rules on download of the bank feed transaction & either approve automatically or ask the operator to approve.

Bank Reconciliation
The Bank Reconciliation process differs once Bank Feeds are operational. All transactions downloaded will typically be flagged as ready for reconciliation within the Bank Reconciliation screen.  Therefore, a bank balance at a point in time is all that is required to reconcile the bank. 

Daily Bank Balance is either shown on the Dashboard of the accounting software or you are required to obtain the balance via online banking or statement.

1 comment:

  1. There are a lot of banking rules that I didn't know about apparently. That must be some complex software to keep up with all these things and more. It would be interesting to see how the programs and software has changed over the years. There are probably changes just within the last few years.
    http://bmabankingsystems.com/products_and_services/

    ReplyDelete