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.

Bank Data
Download and save your detailed Bank data in one of the formats noted above.
 

General Ledger Data
Enter your General Ledger program and run a Detail Transaction Report on your bank account. Bank accounts are traditionally at the beginning of the Chart of Accounts (ie. #1001-00-00). After running the report, save it from within the General Ledger program (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 should be negative. Therefore, checks that are issued (G/L) and cleared (Bank) should be negative. Conversely, deposits and voided checks should be positive.

Tip: If a file lists transactions decreasing the account 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