Go to Ledger > Extra > EFT Export

Hover the mouse over the different menu options. If the cursor changes to a hand (), then click to go to the subject.

EFT Export

Debit Order Collections

•A simple and efficient method to collect payments from your customers through debit orders.

•This process allows you to automatically create the necessary EFT files required by banks for processing payments

1. Fill in all the fields.

2. Choose Between

A. Age Analysis

•Data is retrieved from the Age Analysis.

•Debit Order must be checked, and banking details must be filled in.

B. Recurring Invoices

•Data is retrieved from Recurring Invoices.

•Debit Order must be selected, and banking details must be correct.

C. Age Analysis (No Checks)

•Data is retrieved from the Age Analysis, but no validation checks are performed.

•All amounts from the Age Analysis are transferred.

•Commonly used by farm shops, where agreements allow deductions from salaries.

•Important:

•Do not click Export File if using this option.

•Instead, check Completed and click Process.

Automatic Journal Entry

•Once processed, a journal entry is automatically created to reflect the amount as paid on the customer statement.

Editing & Adjustments

•Right-click on the row selector to delete or change amounts.

•You can also manually edit the amount directly.

3. Exporting & Processing

. Once the file is populated, click Export File.

•This file must be imported into Sage Pay.

•The batch will now be marked as Completed.

4. Click Process to finalize.

•The system will generate a journal entry:

•Debit: Bank

•Credit: Debtor's Control

Finding EFT Transactions

•Navigate to Customer > Customer Detail.

•Type EFT in the blue filter box to display all EFT transactions.