Creating an EFT BatchEFTXpress Video

EFTXpress Resources

Posting an EFT Batch

EFT Vendor Payment Information

Miscellaneous Codes at point of entry

EFTXpress Explained Video

When you create a batch expand the batch information by selecting the Zoom button.
Select the Batch Type dropdown to select an EFT type batch.

Note: If you have chosen EFT the batch has to be negative only. If you change it back to Normal and the entries is negative only, you cannot select Deposit.

Field

Value

Batch ID

Cashbook assigns a sequential batch number to each new batch you create. Posting includes the batch number with each transaction detail in a batch, so you can trace a posted detail batch to the original batch entry. You use the batch number to select the batch for editing and for posting.

Description

You can enter a 30 character description for the batch e.g. Cheques from Payroll, Journals, etc. If the batch is a deposit batch this description will be used as the main description for the transaction once it has been posted to Cashbook.

Batch Type

Three batch types can be created:

  • Normal: All Cashbook entries

  • Transfers: Transferring money between banks

  • EFT: Create an Electronic Funds Transfer file to submit to your particular bank for processing

Note: During posting, batch types that are EFT will be posted normally and an export file will be created. It will either be saved in a directory or uploaded to SFTP depending on your setup in the Setup EFTXpress Banks form.

EFT Process Date

The EFT Process Date must be either the current day or a future date. This is essential for maintaining the accuracy of your financial records, preventing data confusion, and ensuring timely financial management and system compliance.

Single Reference

The Single Reference batch in Cashbook operates the same as a Deposit batch whereby all the entries in a batch are posted through to the Bank Reconciliation with one Reference Number reflecting the total of the batch. The difference between a Single Reference batch and a Deposit batch is a Single Reference batch can contain both Receipt and Payment entries where as the Deposit batch can only contain Receipt entries. The entries in a Single Reference batch can not be printed online.

Single Reference No

Either accept the deposit/single reference number generated by Cashbook or enter your own deposit/single reference number e.g. 01012010.

Single Reference Prefix

Enter a prefix to add to the beginning of the deposit/single reference number e.g. DP/SR.

Enter EFT Payment Details in Batch Entry

If the batch is an EFT batch and you have not entered the vendor details in Miscellaneous Codes you can enter EFT Vendor/Customer payment details on the fly. To enter these details enter the Miscellaneous Code and select the Zoom button next to the Miscellaneous Code. Select the EFT tab and enter the EFT bank payment details. The EFT bank payment details must be approved by ticking the Approved Y/N tick box.

 

To exclude entries from being uploaded to the bank deselect the EFT check box. These entries will then still be included in your EFT batch and can be paid separately.

 

If you have setup two different bank accounts for the same bank code and you want to change the bank account from the default setup in Miscellaneous Codes, select the Zoom button next to the Miscellaneous Code and select the finder in the Bank Account field to change the bank account.