Processing an EFT Transaction

Processing an EFT Transaction

Cashbook provides a method of producing a file of transactions for direct crediting to payee bank accounts via internet banking software. Relevant transactions must be marked by clicking the EFT checkbox in the transaction entry screen.
To process EFT Transactions:
Make sure you have:

Step 1. Click on the Transactions > Process EFT menu option

 

Step 2. List of all payments marked as EFT File will pop up 

  • This will display a list of all payments that have been marked as "EFT File" and have not yet been processed.
  • Set the required date for the transactions to be processed by the bank in the Date to be processed by bank box.
  • Tick the Mark processed transactions as cleared to bank statement check box at the bottom of the screen, if you wish to mark processed transactions as "cleared" for bank reconciliation purposes.
  • Make sure that all payments to be made are  in the Pay column next to the relevant payment (right-click to add / remove the tick and exclude transaction/s).
  • If a remittance advice is required for payments (to be emailed or printed), make sure the printer icon is displayed in the Remit column next to the relevant payment.  (Right-click to add/remove the print icon and exclude printing).
  • Click the Process button to produce the electronic payment file. (In Australia, electronic payment files are prepared using the Australian Bankers' Association (ABA) file format).  
Note: Payments with no tick will not be processed to the current file and will remain on the EFT list for later processing.
  • To remove a payment from the EFT list (without processing it to an EFT file), tick (right click) the required transaction/s and click on the Remove Items From EFT List button. and then click Yes to the confirm message. (Alternatively, go to the cashbook listing screen and edit the transaction and "untick" the EFT File checkbox, then click OK to save.
 
Note: If a transaction needs to be re-processed for some reason (e.g. an invalid bank account number used), you will need to go to the cashbook listing screen and edit the transaction and clear the EFT checkbox and click OK to save. Now re-edit the transaction and re-set the EFT checkbox on - the transaction will now appear on the list of items for EFT processing.

Step 3. Click Yes to the Confirm message:


  • Save to an appropriate location.
  • Click on the Save button
 
  • Click Yes to the Confirm message:
 
  • Click OK to the Information message:
 
  • The electronic payment file can now be uploaded to your bank using your bank's online banking portal.
  • Refer to the help in your online banking for instructions on how to upload payment files, or ask your bank directly (or Google search for your banks instructions, e.g. upload aba file to CBA).

CSC Article ID 806