Gather Your Data

The system can import files in Excel, Access, ASCII Text: Fixed Width, ASCII Text: Comma Separated Values, and ASCII Text: Tab Delimited.

 

 

The file should have one transaction on each row, with each row having information about the account you are transferring funds to/from.

1. Basic

Your list can simply be: amount, account number and routing/ABA number.  You can import this list at 'Import', 'ACH Transactions'.

OR

2. Customer, Employee and Vendor Accounts

If your accounting/billing system is not capable of producing a report with the amounts and account information on the same report, we can make your life easier.

Regardless of which method you use (or combination of the two), you can import additional data such as the batch description, internal accounting name and numbers, etc... For those transmitting with CTX/EDI, please contact support for additional field information.

 

When importing, how does the system know if we want to collect or send funds?

Transactions with positive amounts increase your account balance by collecting money from your customers. Transactions with negative amounts decrease your balance and pay vendors and employees.

We have built-in tools if your reports have all positive (unsigned) amounts, or if you need to make them all negative.

 

I need to consolidate funds from various banks. How do I make a simple transfer?

First you need to (once) add/identify the accounts you will be moving funds between. Then you can transfer funds whenever you want.

• Add Transfer Accounts - From the main menu 'Edit', then 'Add/Edit Corporate Transfer Accounts'.

• There is no limit to the number of 'Corporate Controlled' accounts that you can transfer funds to and from.

• The 'Master' account represents the account you are working in (only one).

• To enter a transfer, From the main menu 'Edit', 'Add a Transfer' and the window will appear.

• Note: The execution order of transfers is determined by your bank, not your sequence of entries.

• You must 'Transmit to Bank', just as you would any other transaction.

 

How do I prepare the list from my Accounting/Billing/Payroll Package?

To get started, enter your Accounting, Payroll or Billing Package and run the appropriate report. After running the report, save it from within the Package (typically from the File's sub-menu 'Save As...' selection) in one of the file formats noted above.

Remember: Collecting funds from customers increases your account and should have positive amounts. Payments to Vendors and Employees reduce your account balance and should be negative.

Tip: If the report lists all amounts with a positive amount, and you need to make payments, you can map the amount field with 'Amount_Reverse_Sign', rather than 'Amount' during the import process (Easy Step #2)

How do I create a CTX file?

By default, the system is configured to create NACHA standard PPD and CCD files. Please contact Treasury Software Licensing department for our professional version to enable you to create CTX files.

 

Treasury Software Corp. 1999 - 2005.  All rights reserved.

Can't find what you need? Contact us