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