Using EFT Begin and End Dates in JobStream

Using EFT Begin and End Dates in JobStream

Info
The attached document is a pdf version of this article.
Introduced in v5.20.57 under ADO 40865

This item provides the ability to process EFT File Generation through JobStream using the same file generation parameters that are available when processing the same task manually through Tasks - EFT File Generation. Prior to this work item the JobStream parameters for EFT File Generation did not allow any Due Date range to define records to include in the EFT file. 

If no date is provided in the Due Dates Begin Date field, ASPIRE tries to catch up on payments for all EFT-eligible invoices that are not paid.

Note: This is not desirable for UK finance companies. 

  1. When an invoice falls into delinquency in the UK, an attempt to re-collect the payment is scheduled to occur in 5 business days. This is handled through Alternate EFT schedule processing. 
  1.  If an attempt to recollect the payment also fails, a further attempt to re-collect is scheduled to occur in another 5 business days.
  1.  If this fails, the collections team escalates. 

 The EFT process completed through Tasks - EFT File Generation, supplemented with Alternate EFT schedules accomplishes the goal for UK clients processing EFT. 


In Admin - JobStream, the EFT File Generation Task parameters did not allow configuring how the Due Date range should operate. This results in ASPIRE attempting to process EVERYTHING through the processing date. 

Now the JobStream parameters provide the ability to specify a Begin Date for the JobStream EFT Task.



  1. Previous Day - the day before the current system date (even if that's a weekend)
  2. Current Day - the current day based on the system date
  3. Next Day - the day after the current system date (even if that's a weekend)
  4. Previous Business Day - the most recent business day before the current system date (i.e. Friday if it's Monday)
  5. Earliest Date - equivalent to not setting a begin date
  6. This setting defaults to Earliest Date to mimic the current behavior

                                                     i.     No custom date logic is applied when this value is used; it mimics current behavior and uses the earliest date possible, effectively including payments for all EFT-eligible invoices that are not paid.

Before we get into specific setup, it is helpful to note that US/Canada and UK handle EFT processing differently and this is reflected in ASPIRE.
- In the US and Canada, ASPIRE assumes that EFT will be processed at the end of the day to primarily collect the payments that were due on the day. Since it assumes the originating bank is closed at time of processing - and thus will not actually process the EFT file until the following morning or next business day - a date like the Effective Entry Date within the NACHA file are set to the next business day (based on EFT Calendar Setup)

- In the UK, it is most common for EFT to be pulled ahead of the invoices due date by at least a day.
  1. When Begin Date is set to:

a.      Previous Day – ASPIRE will use the day prior to the current system day as the Due Date Begin Date.

EXAMPLE: (US/Canada) Running EFT on 1/17/2024 (Wednesday) at 5 pm, picks up all invoices or alternate EFTs with due dates of 1/16/2024 or greater. This is most often paired with an end date of "Current Day" - this results in charges with due dates of 1/16/2024 - 1/17/2024 being picked up.

- Multiple days over the weekend will not be covered. If EFT is not running on Saturday and Sunday, full coverage of invoices due on Friday and Saturday may not be picked up.
- Holidays will not be considered
- If backdated invoices (with due dates prior to the previous day) are open and unpaid, they will not be included.

b.      Current Day - ASPIRE will use the current system day as the Begin Date for selecting invoices due to include in the EFT file.

EXAMPLE: (US/Canada) Running EFT on 1/17/2024 (Wednesday) at 5 pm, picks up all invoices or alternate EFTs with due date of 1/17/2024 or greater (depending on end date). If paired with an end date of "Current Day" - this will result in only charges with a due date of 1/17/2024 being picked up
EXAMPLE: (UK) Running EFT on 1/17/2024 (Wednesday) at 4 am, picks up all invoices or alternate EFTs with due dates of 1/17/2024 or greater (depending on end date). Could be paired with an end date of "Current Day" (only pick up charges due 1/17/2024), "Next Day" (invoice due dates of 1/17/2024 - 1/18/2024), or "Next Business Day" (invoice due dates of 1/17/2024 - 1/18/2024 [assuming this is not a holiday])

-Weekends given no special consideration
-Holidays given no special consideration
-If backdated invoices/alternate EFTs (with due dates prior to current day)  are open and unpaid, they will not be included

c.      Next Day - ASPIRE will use the day after the current system day as the Begin Date for selecting invoices due to include in the EFT file, even if that day is a weekend or holiday.

EXAMPLE: (UK) Running EFT on 1/18/2024 (Wednesday)

d.      Previous Business Day - ASPIRE will use the Business Calendar and EFT Calendar tied to the originating bank to determine the most recent business day to use as the Begin Date for selecting invoices due to include in the EFT file.

e.      Earliest Date - ASPIRE will use the earliest day used within the system (or no date) as the begin date for selecting invoices due to include in the EFT file, effectively including payments for all EFT-eligible invoices that are not paid.

  1. Ability to specify an End Date for the JobStream EFT Task:

a.      Current Day

b.      Next Day

c.      Next Business Day

d.      This field defaults to 'Next Business Day' to mimic the current behavior

                                                i.          Current day + add 1 day for the end date calculation when an end date is not specified

  1. When End Date is set to:

a.      Current Day - ASPIRE will use the current system day as the End Date for selecting invoices due through to include in the EFT file.

b.      Next Day - ASPIRE will use the day after the current system day as the End Date for selecting invoices due through to include in the EFT file.

c.      Next Business Day - ASPIRE will use the Business Calendar and EFT Calendar tied to the originating bank to determine the next business day to use as the End Date for selecting invoices due through to include in the EFT file.

                                              ii.          The existing code uses current day + add 1 day for the End Date calculation when an end date is not specified

                                             iii.          This value is the default to match existing logic





    • Related Articles

    • EFT Bank and Company Setup

      See attached document for details. Please see the attached guide for specifications on the EFT Bank setup in ASPIRE (Administration > Cash Management > EFT Bank)

    • Electronic Funds Transfer Module Training

      Please see the attachments for detailed information, recording available from within the Vimeo weblink 3 Attachments available + a link for the Recorded Training: 1. EFT Bank and EFT Company setup screen definitions, available to assist with ...

    • Vendor Payments via EFT using the ASPIRE Accounts Payable Module

      If you are using the AP module and want to generate a Vendor Payment file AND you also want ASPIRE to generate the GL activity (Dr AP and Cr CASH), this is how you would set up the Vendor and the Invoice. Note: you will need both the Accounts Payable ...

    • NACHA File Format and NACHA Rules

      See attached documents for complete details. The attached documents cover all aspects of the NACHA file format and 2010 NACHA Operating Rules.

    • ASPIRE Training Video Inventory

      The following is a list of training videos available in this Knowledge Base. The links will take you to the Knowledge Base article that contains the link to the video. Be sure to browse the Category for additional information related to your topic. ...