Frequently Asked Questions

 

Do I use Amount or Amount Reverse sign?

 

How do I delete a record?

 

How can I delete an entire import?

 

 

Do I use Amount or Amount Reverse sign?

Amount is used when the records on the file are issued checks, and the amount on the import file is

listed as a negative amount. Amount_Reverse_Sign is used when the records on the file are issued

checks, and the amount on the import file is a positive amount. The File Formatter requires Issued

Checks to have a negative amount, and Void Checks to have a positive amount.
 
I entered the wrong Bank account number and/or Bank number. How do I fix this?
Click the Settings tab > Enter Bank Express Code. Select the Resume Startup tab

and click the Resume button. This will re-enter the Account Creation wizard and bring you to the page

where the Account Number and Bank Number are entered. Correct the entries as needed, click Next,

and then click Finish to save the changes.

 

How do I change where the Issue File is saved?
Click the Settings tab > Transmit to Bank. Select the Local File tab, and modify the Transmission file

location textbox. The Transmission File Location must include both a file name and extension (.TXT).

 

 

 
 

How do I delete a record?

Select the View tab > All Reports.  From the drop down select the All Records Report and choose a

date range.  Now select a record in the grid, and click the Red X on the toolbar.

 
 
 
 

How can I delete an entire import?

From the Home tab select Delete Entire Import. Highlight the import you wish to delete and click the

Red X on the toolbar. Deleting an import will remove all records from that import file from the File

Formatter database.

 

 

 

 

When Importing an Excel® file, my dates convert from MM/DD/YY to numbers. How do I avoid this?

Close the Excel® file when you are importing it into the File Formatter. When the Excel® file is open

during the import process, Excel® converts the dates to Julian format, which will be rejected by the File

Formatter for an “Invalid Date.”

 

Can I manually add a record without importing? Yes. Click Edit > Add Record and enter in the check

information on the form. When finished, click OK.

 

I need to resend a transaction to the bank, how do I do this? From the Home tab select Delete Entire

Import. Highlight the import you wish to delete and click the Red X on the toolbar. Deleting an import

will remove all records from that import file from the File Formatter database.  Now you can re import

your data and create the file.

 

How do I enter my license codes?

Click File > Enter/remove License Codes. Enter in the License ID and License Password and click

the Register button. If prompted to complete the Authentication process, please follow the instructions

provided on the screen.

 

Can I also select the ACH Universal or Bank Reconciliation option to format a check file to transmit to BMO Harris Bank?
No. The Bank Positive Pay file option is the only option for selection by BMO Harris Bank clients.

 

 

 

 

Check Issue File Formatter is software offered by Treasury Software Corporation. BMO Harris Bank N.A.

and Treasury Software Corporation are separate legal entities, which are not affiliated with each other in

any way by common ownership, management, control, or otherwise.  The content, availability, and

processing accuracy of the Treasury Software products are the responsibility of Treasury Software

Corporation.  BMO Harris Bank N.A. makes no representations or warranties as to the suitability, fitness,

accuracy, completeness or timeliness of the information provided, including any information or service

provided by Treasury Software Corporation.

 

Third party web sites may have privacy and security policies different from BMO Harris. Links to other web

sites do not imply the endorsement or approval of such web sites. Please review the privacy and security

policies of web sites reached through links from BMO Harris.  Microsoft®, Excel® and Access® are

registered trademarks of Microsoft Corporation in the United States and/or other countries. Banking deposit

and loan products and services are provided by BMO Harris Bank N.A. and are subject to bank and credit

approval. BMO HarrisSM and BMO Harris BankSM are trade names used by BMO Harris Bank N.A.

Member FDIC.