DB2 Database Platform

EFTXpress version 5.2A

Exciting Features available in EFTXpress version 5.2A.

Setup EFTXpress Banks

Bank Code

Select the relevant Bank Account code for which you are creating the EFT file. This bank must have already been set up in Cashbook for Windows.

You can only create one EFT file format per Bank Account.

Bank Format

From the Bank Format drop down list select your bank. Many EFT bank formats are available from PereSoft. Contact your Solution Provider or visit the PereSoft web site to obtain an up to date list of EFT formats available.

Export Path

In the “Export Path” field, you must specify the location of the file which you wish to create. This is normally the location from where the file can be sent to your bank.

File Extension

In the file extension to use when exporting the EFT file. This is normally the default file extension your bank uses when browsing for the EFT file to import.

Date

Select the date on which the bank will be processing the payment transactions contained in the EFT file. This will be the date on which the consolidated EFT amount (total of all the EFT payments contained in the EFT file) will be reflected on your bank statement.

Export Fields

In the Export Fields section you need to enter the information required by your bank. Please refer to the Bank Formats section for more information that is required by your bank.

The Export Field section will have different fields for each EFT bank format depending on the information required by the specific bank.

Setup Miscellaneous Codes for EFTXpress

EFTXpress requires additional information for Vendors, Customers and Miscellaneous clients depending on which bank format you are using.

You are able to enter additional information for multiple banks for each miscellaneous code.

To link a miscellaneous code to an existing Vendor or Customer, use the same Vendor or Customer number that you used in ACCPAC Accounts Payable and Accounts Receivable. When creating an EFT batch and entering the Vendor or Customer number in Batch Entry, Cashbook will retrieve this information from the CB Miscellaneous Codes table.

Creating an EFT Batch

An extra batch type is now available called EFT Batch. Use this batch type to create an Electronic Funds Transfer file to submit to your particular bank for processing.

During posting, batch types that are EFT will be posted normally and an export file will be created in the directory you set up in the Setup EFTXpress Banks form.

Import EFTXpress References

Some banks offer a facility to import a file provided by the bank that will allocate new reference numbers to the posted EFT transactions. This file can be imported into EFTXpress using the EFTXpress Import References function.

If your bank does have this facility you will be able to select the bank name from the Bank Format dropdown list.

Bank

Select the Bank Account code for which you are importing the EFTXpress data.

Location

In the “filename” field, you must specify the location of the file which you wish to import. This is normally the location of the file which has been downloaded from your bank.

Bank Format

If your bank provides this feature you will be given the choice of your bank format in the drop down combo.

If you want to create your own format choose Cashbook as the bank format you want to use. You can select which fields you want to import. Click on the Fields tab to select the fields you want to import.

Location

In the “filename” field, you must specify the location of the file which you wish to import. This is normally the location of the file which has been downloaded from your bank.

With this form you can:

Import

You can import the filename you have selected in the Location section.

Post

Posting the imported file will update the references in the posted transactions in Cashbook.

Clear

Delete an existing imported file.

Edit EFTXpress References

You may wish to refine and improve the accuracy of the import by editing the matched results.

In this form where you can examine and change the entries that have been matched to the imported EFT batch.

You are able to change the displayed entries of the Bank Reference Import by selecting:

• All - all imported entries .

• Correctly Matched - entries that were matched by amount, date and description.

• No Match - nothing was found in Cashbook to match.

The sequence of the display can also be changed:

Clear Existing EFTXpress Imported Entries

If you wish to bring forward the unmatched entries from a previous imported file, toggle this option on. All unmatched entries will not be cleared and will be appended to the following imported RecXpress file.

Refresh

Refresh will update the worksheet you have created.

Print

Print will print a report showing all the entries.

Post

When your records have been successfully imported and you are satisfied with the results, you will need to post the imported file to update the References in the Cashbook Transaction Header. Click on the Post button and the message "Update Cashbook with imported EFTXpress References?" is displayed. If you are satisfied with the import, click on the Yes button, and your Cashbook will be updated. If you select No, you can choose to Clear the imported batch.