Opening The File And Formatting Your Data

1.1

Open the template file in Excel. You should be presented with something that looks like the image below:

1.2

You will notice that the first column is a list of column headers indicating what data should be provided in the fields below.  Anywhere it says “IGNORE”, you can simply leave that column blank.

1.3

IMPORTANT: Fields S and T are the routing and account number field.  It is very important that the data you put in this field matches what your customer provides.

1.3.1

In order to accomplish this, you should highlight both columns and then right click and select the “Format Cells” option.

1.3.2

You will be presented with the following dialog menu to select the format of the fields.

1.3.3

By default, all columns are formatted as General.  You should select “Text” as it is shown in the above screenshot. And click OK.

1.3.4

1.1.1.  For any bank account and routing numbers that have leading zeros, you should now see a green triangle on the upper left hand side of the cell indicating that the data is preserved in that format.