How do I stack multiple accounts in one file?

Bank Positive Pay > Advanced Topics > How do I stack multiple accounts in one file?

How do I stack multiple accounts in one transmission file?

First configure Bank Positive Pay as if you were only transmitting one account - that means entering the Bank Express Code, entering transmission settings, etc...

Perform at least one full test of importing and file creation.

Overview

The process for multiple origination account file creation is essentially the same as for a single file creation.  The only differences are:

--the data must contain a field with the account number (if not available, Treasury Software can provide optional custom scripting)

--the transmission file will contain 'stacked' data sets, each set containing different account information

--any bank identifiers should all be the same (same bank number)

--The file can contain up to three header records, one batch header, and up to an equal number of footers.

During the import process, you will map the account number field as the 'Origination_Account' field.  During the export process, you will substitute all occurrences of the Bank_Account field with the 'Origination_Account' field (including the detail section).

Step by Step

I. Setup the transmission file format

From the main menu select 'File', 'Options', Transmit to Bank', 'Data' tab.  Click on 'File Header'.  Change the drop down selection box from 'Header - Top' to 'Batch Header'.

1. Enter the header format using the 'Header - Top' as a guide.  Note: Substitute 'Origination Account' for 'Bank_Account' in the Batch Header.

2. Switch back to 'Header - Top' and delete the mapping template.  Click 'Done'.

Click on 'File Footer'.  Change the drop down selection box from 'Footer - Bottom' to 'Batch Footer'.

3. Enter the footer format using the 'Footer - Last Line' as a guide.  Note: Substitute 'Origination Account' for 'Bank_Account' in the Batch Footer.

4. Switch back to 'Footer - Last Line' and delete the mapping template.  Click 'Done'.

Note: You can have any combination of headers and footers, as specified by your bank.

II. Setup the Import Mapping

When importing your data, map the field containing your account numbers as the 'Origination_Account'.

Notes:

--This feature requires the account number to be a field on each transaction.  Treasury Software can provide optional scripting/lookup table functionality if this is not available.

--The bank number, also known as region number, should be the same for all accounts.

--Of course, confirm and arrange with your bank that you will be sending consolidated files.  Not all banks are equipped to handle this.

Page url: http://www.treasurysoftware.com/TSHelp/index.html?multiple_accounts_in_one_file.htm