Consolidation/Summary of Records

 

 

Overview

This feature enables you to import detailed information and summarize it for both payment, as well as well as email (if needed).

 
Your detailed data from your accounting system:

 

 

Will be paid in summary as:

 

 

 

In addition, if you are sending emails, we will:

send one consolidated email with the check stub information as below:

 

 

 

To enable this feature:

From within the Settings tab > ACH Setup > Panel 7 > Advanced tab > General tab.  Finish the wizard to save your updates.

Note: If you are using a version prior to 2013.  From the main menu select File > ACH Setup > Panel 7 > Advanced tab > General tab.  Finish the wizard to save your updates.

 
 

How it works:

1. Import and manually add records.

When importing, remember to import your remittance information mapped as the ID_Number and ACH_Text_Addenda fields (you do not need to use both fields).

 

 

2. After you import/add records (Step #1), but before you create the ACH files (Step #3),

the system will display the records as detailed.

If you run reports, you will see the detail as usual.

If you were to send emails (prior to step #3 below), an email would be created for each individual transaction.  Therefore, using the example on this page - Staples would receive 3 emails and Verizon would receive 4.
 

 
3. Create the ACH File
****It is at this point that the records are consolidated****
During the ACH file creation process, the system will create summary records by grouping the untransmitted records based on the banking information (ABA and Account #) of each record, as well as all batching rules (payment date, etc....).

 
The newly created summary records will contain the check stub information from the detailed records.  This will include data from the following fields:
--Amount
--ID Number

--ACH_Text_Addenda
 

 

If you were to send emails at this time, a summary email would be sent.  Using the example on this page - Staples and Verizon would each receive one email showing the check stub information.

 

You can run reports, such as the Transmittal Log report, and view either detailed or consolidated information.

 

 

Notes:
--ACH Universal Corporate or Processor edition required
--Use with SEC codes of PPD and CCD only
--Turn off ACH Universal encryption

--Not for use with QuickBooks, as ACH Universal already has a check stub feature within the QuickBooks Integration module.

--The ACH file contains the payment summary amount, but not does not contain the remittance (check stub) information, as the ACH/NACHA file does not have any fields to accommodate it.  The remittance (check stub) information is included by default in the check stub information of the email.  If you are using a third party report writer and our SQL Server platform, this information is also available in the 'Memo-Field'.