Downloading CNB Bank Statements

 

To download your statement for Auto-Clear in LAjit, begin by logging into your City National Bank online account, either Treasury Net or Business Online.

(They might look slightly different, but the functionality should be the same.)

How to download from City National Bank – Step 1

 

Click through to Reports/Reporting, (not Online Statements) and choose “Previous Day Detail Report”.

How to download from City National Bank – Step 2

 

On the Criteria Selection page, select the following options:

How to download from City National Bank – Step 3

 

After clicking Export, you should see the following screen:

How to download from City National Bank – Step 4

 

After clicking Export, it will return to the Criteria Selection screen but with the following message:

How to download from City National Bank – Step 5

 

Click the browser’s refresh button as directed, and you should see this screen with this message:

How to download from City National Bank – Step 6

 

VERY IMPORTANT!!!

Click to download your file. You should rename it to something more manageable, and put it somewhere easy to find.

Open the file in Excel, and save it as a “.csv” type file.

You are now ready to upload the file to LAjit.

 

To upload the bank file, navigate to the Auto-Clear link (shown below) and select it.

Ho To download from City National Bank – Step 7

 

From the next screen, select “Browse” and locate the bank file and select it. Once that is done, click on “Upload” to submit file.

How to download from City National Bank – Step 8

 

By selecting Cleared Results, you can review the items that have been cleared through the Auto-Clear function and address any discrepancies.

How to download from City National Bank – Step 9

 

Once your bank reconciliation is done, review your totals. The Ending Balance must match the Adjusted Balance (Figure 3-10). If it doesn’t, review your bank statements for any discrepancies.

How to download from City National Bank – Step 10

 

To finalize the reconciliation select Finalize Statement to close the monthly entry, see below.

How to download from City National Bank – Step 11

 

You can also print out a Reconciliation report from this menu. Simply click on the Print Reconciliation link to generate your report (Steps 11 & 12).

How to download from City National Bank – Step 12