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.

Enter your Accounting Package and run either a:

• Check register from Accounts Payable, or

• Detail General Ledger Transaction Report on your bank account (ie, #1001-00-00).

After running either report, save it from within the Accounting Package (typically from the File's sub-menu 'Save As...' selection) in one of the file formats noted above.

Remember: Transactions increasing the account balance should have positive amounts, those reducing the account balance should be negative. Therefore, checks that are issued ('cut') should be negative. Conversely, voided checks should be positive.

Tip: If the Check Register lists all check amounts with a positive amount, in Easy Step #2 (next), map the amount field with 'Amount_Reverse_Sign', rather than 'Amount'.

Treasury Software Corp. 1999 - 2005.  All rights reserved.
Can't find what you need? Contact us