Question: "Our bank combines the activity for all three bank accounts into one download file.  I've been manually sorting them in Excel and then importing them.  Is there an easier way to do this with the system?"

Yes, you can filter out the other records, by only importing the records which have the current account number:

--When importing the file, make sure that the 'Filter' field is mapped, and

--Enter the account number (or other filter code) into the Filter setting located in 'Options', then 'Import Tab'.

 

Note: The original source file is unchanged.  You may use this file again for other accounts.

Tip:

Look at your file and find the exact account number that you will be filtering on.  It may, or may not have the leading zeroes as indicated on your bank statement.  Use the format found in the file.

 

Knowledge Base Article: KB2012

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

Can't find what you need? Contact us