Instructions for…
Importing an ACH files within Business Online Banking.
Rockland Trust Online Business Banking offers Cash Management Services of ACH. The following will guide authorized users on ACH processing within Business Online Banking. User Guidelines:
• Users may be limited from some or all of the functionality listed on this page. Consult your company's administrator for full information on your Online Banking settings and functionality Batches submitted after 4:30 p.m. will not be processed until the following business day Batches can not be accessed after 4:30pm. Batches being maintained at 4:30 will be blocked from submission until the following day
• •
IMPORTING an ACH FILE (Not into a Template):
This page displays how to import a file into the ACH functionality.
• • •
View a list of imported ACH batches View details for an imported ACH batch Create an ACH batch to be submitted to Rockland Trust
You can import into either an existing batch or an existing template or create a new template or batch. 1. Select “ACH Import” from the side tool bar. 2. The screen will list all files that have been previously imported.
3. Select the File you would like to import again or click on “Import File at the top of the screen.
If you select to “Import File” you will be on the “Import ACH Batch” screen
4. Next select the file format: • NACHA • NACHA – w/out file header • NACHA – Transactions Only 5. Select the action to take from the choice list provided: • create new batch (Most Popular) • update existing batch (The records in the file must match the records in the Batch) • add to existing batch • create new template • update existing template • add to existing template 6. Select the batch type: • PPD - Prearranged Payment or Deposit entry PPD (Consumer non-business) • CCD - Cash Concentration Disbursement 7. Select the location of the file to be imported. • Select the “browse” button to locate the file to be imported 8. Once you have located the file Click “Submit” to import the file. 9. Once the import is complete review the file to ensure it is accurate. 10. Click “Continue” to complete the import or Click Cancel Import to return to the Import File Screen 11. Use the following chart to determine what the next screen to appear should be. The screen depends on the “Action” selected when establishing the Import
Action selected Create New Batch Create New Template Update Existing Batch Add to Existing Batch Update Existing Template Add to Existing Template
Page that will appaera Create ACH Batch Create ACH Batch ACH Transactions ACH Transactions ACH Transactions ACH Transactions
Create ACH BATCH:
This page allows users to set up your batch for processing of the file just imported.
1. Select the portfolio you want to work with from the drop-down list. Note: If you are not authorized to view more than one company portfolio, the Portfolio drop-down menu will not display. 2. Enter the Batch Name. This is for your reference. 3. Select a Batch Type from the pull-down list. The Batch Type determines the payment options available. • Cash Concentration or Disbursement (CCD) • Prearranged Payment and Deposit Entry (PPD) 4. Select the payment option: • Send a Payment • Receive a Payment 5. Select the Offset Account from the pull-down list. 6. Enter the Effective Date for the ACH batch. Enter a date as mm/dd/yyyy or • Click the calendar icon to select a date from the visual calendar.
•
Timing is determined by your agreement with Rockland Trust standard is to schedule 2 days from current date.
7. Enter the Entry Description. The description may contain up to 10 alphanumeric characters and is a required field. • This description will be sent with the file for processing, typical use would be payroll or direct dep 8. Enter the Discretionary Data (if applicable – not required). The discretionary data may contain up to 20 alphanumeric characters. 9. Click “Submit”. The ACH Transactions page will display. 10. The ACH Transaction page will be displayed as below.
Note: The Batch Name and the Totals should equal the records that were imported.
Scroll down to view transactions
11. To view all transactions associated with this batch scroll to the bottom of the screen. 12. Verify the information in the transactions. 14. If the batch is all set and no changes need to be made to the transactions then click “Submit”. Skip to “Batch Complete” To make any adjustments to the imported transactions follow the steps below
Editing/Adding Transaction Records
• • Addenda Allow users to add additional information to a specific record for the receiving party to reference the transaction (Invoice #, reference #) Modify a record in this batch click the “Modify” link next to the specific record 1. The details for the specific record will appear in the fields at the top of the screen 2. Change the information as necessary. 3. When complete, click Modify Transaction. The transaction displays the updated information in the list. • Delete a record in this batch click the “Delete” link next to the specific record • • Deleting a record can not be undone
Add a transactions to this batch, enter the details in the upper portion of the screen 1. Enter the details regarding the ACH Transaction: • Company or Individual name • Individual id (discretionary) • ABA/Routing Number • Account Number • Amount • Transaction type from drop down box 2. Click “Add Transaction”. 3. Continue with step 12 until all transactions have been entered. 4. Click “Submit” to send your transactions to the bank for processing.
Batch Complete
Once a batch has been submitted the ACH Confirmation page will be displayed This page will give a summary of the batch.
5. All Totals should be verified at this time. 6. To verify if the batch has been sucessfully sent to the bank for processing click on “ACH Activity” link. This will display all batches to view the status of your batch and do one last verification. Note: Depending on the company administration structure batches may need to be approved and released before it can be sent for processing, Each company administrator can set these parameters.
Sorted by
The ACH Activity Screen displays all batches in alpha order by Batch name. To view any batches waiting to be processed by the bank click on “Status”. Find all “Pending” batches and these are due to go to the bank on the date indicated in the “Due Date field” .