Dishonour files from the bank

Not all banks detail dishonour transactions in the bank statements, example ANZ bank. This makes it impossible to process dishonoured transactions through the bank statement upload.

ANZ bank have a separate file called a “return items” file that contains a list of all dishonoured transactions. This file will be imported separately in order to process the dishonoured transactions.

The uploading, matching and posting of the dishonour return items files will operate and function the same way that bank statement files are uploaded, matched and posted.

Process Step 1 – Upload dishonour files:

1. The dishonour files are uploaded, the same way bank statements are uploaded. Navigate to Banking > Bank Statements > Upload Dishonour File

           

2. Once selected you will be able to select the file that contains the dishonours as supplied by the bank.

     

      Select File - Click the browse button to locate the dishonour file supplied by the bank.

      Description - Supply a description for the upload. It is best to enter the date in the description.

3. Select the file and click “Upload”. The file will be uploaded, the same as is done in bank statements. 

4. Once uploaded the file will appear in the list of dishonour file uploads that can be accessed from the menu item “dishonour uploads”.

Process Step 2 – Import dishonour files

 1. Once the file has been located and uploaded, it need to be imported. 
Navigate to Banking > Bank Statements > Dishonour Uploads.

2. When you click the menu item, you will be presented with a list of all dishonour files that have been uploaded.

      

      Allocated - "Full" - if all items in the files have been allocated to accounts. "Partial" if some of the items in the file have been allocated to accounts.

      Posted - if all items in the files have been posted to accounts. "Partial" if some of the items in the file have been posted to accounts.

3. Clicking on a file will open the file details allowing you to Import the uploaded file from the function’s menu.

4. Once Imported the details will appear under the  “File” tab at the bottom of the page and the actual file will appear under the "Documents" tab. 

When a dishonour file is imported, manually, if the “automatically match dishonoured Files” on the bank configuration is set to true, the auto matching will take place automatically. The same as if the user clicked the “auto match” menu item from within a dishonour file. A check must also be done when the user tries to auto match manually, that matching is not already in progress, so as to avoid deadlocks and duplicates.

You are able to download and view the uploaded file by clicking the “download ” link under the "Documents" tab..

Process Step 3 – Matching and posting dishonour transactions

1. Clicking on the item in the file tab will open a page to display the specific details on the items in the file.  From here you will be able to allocate and post the dishonour transactions.

All transactions that have been matched and allocated to accounts, will be moved from the “Unallocated” tab into the “Allocated but not posted”  tab. 

All transactions that have been posted to accounts, will be moved to the “Posted” tab.

2. Auto Match - All the items in the file can be auto matched to accounts. Using the menu items under the actions / hamburger menu, the items in the file can be matched to accounts.

Auto match will match the “reference” number in the file to the reference number in Fusion. . 

DD transactions that dishonoured “Credit” can only be allocated / matched to

1. Finance agreements.

DC transactions that dishonoured “Debit” can be allocated to 

1. Suspense Accounts - A DC for a finance agreement payout cannot be allocated to a finance agreement as it will reduce the balance to zero. The money must be allocated to a suspense account and resolved from there. The same goes for DC transactions for interbranch transfers from fund account bank account to asset class bank account.
2. Fund Accounts - Withdrawals from investor fund account
   
3. Control Accounts - Payments from control accounts

3. Post - All the allocated items will be posted to the accounts. Once this is done the transactions will appear against the account. These are dishonour transactions so a revaluation of the account will take place to deal with back dated transactions.

4. Manual Match - Selecting a specific item in the file from the “unallocated” list, you will be able to able to manually match to an account. 

The following options are available to manually match transactions:

1. “Account” – you can search for and select a specific account.
   
2. “Account by account number” – you can enter an account number if you already know it. 
   
3. “DD dishonour transaction reference” - you can enter a DD transaction reference number that the dishonour must be matched to. This happens when the file supplied by the bank does not contain the correct reference number for a dishonour. A DC for a finance agreement payout cannot be allocated to a finance agreement as it will reduce the balance to zero. The money must be allocated to a suspense account and resolved from there. The same goes for DC transactions for interbranch transfers from fund account bank account to asset class bank account.

      

• Related Articles

• Auto match a bank statement

  Once a statement has been uploaded the transactions in the statement need to be allocated to the correct account. The auto match function will automatically match transactions to the correct accounts where possible, based on the auto matching rules ...

• Bank statements

  The process to bank statement processing involves the following steps: Step 1 – Upload files Step 2 – Import files Step 3 – Auto matching transactions Step 4 – Manually matching items that did not auto match Step 6– Post the matched transactions Once ...

• Bank reconciliation

  Ensuring that the finance company bank accounts are reconciled to the bank control accounts in Clearmatch is an important function to ensure that all transactions are processed and accounted for. It is important that all transactions that appear in ...

• Manually match a bank statement

  At times there will be transactions that appear in the bank statement that do not meeting the auto matching rules and will need to be manually allocated to an account e.g. a customer deposits money into the bank account and does not put the finance ...

• Create electronic funds transfer files - direct debit export file

  This document includes the steps to create a Direct Debit bank file from Fusion Create Direct Debit Export File  1. Go to Banking -> Electronic Funds Transfer -> Select the correct Warehousing Entity from the drop down 2. Once the warehousing entity ...