Hi Kari_B

Since it looks like you are using Sage 50 Canada, I am going to move this post to that Support Group so that other users of this software will see it and can offer you their thoughts and insight.

Related to your post though:

For security reasons the export for vendor / customer records, only includes basic name and general contact details when you go to File > Import/Export > Export records.No banking details are allowed to be exported. If you are subscribed to EFT though, you can generate .DAT files for your bank to process payments.

Hope this helps!

Thanks,

Erzsi

Yes, we just subscribed to EFT.  However, I wanted to ensure that the banking details were correct prior to uploading a file to the bank.  I think as a work around I could create test company based off of the actual company, run and EFT for all the accounts that I want to check and compare to my current list.

Thanks so much for your reply and confirming that there is no current report available.

You can open two separate company data files at once on the same machine so that could work :)

Note that the Direct Deposit Log report is available to you too for checking uploaded data. It includes at least the routing number of an account.

One way to access the report in order to modify it is to visit your Reports menu in Sage 50 CA, then scroll down to launch the Report Center. Once the window opens, see the left side and select Banking, then see the bottom of the list to select Direct Deposit Log, choose modify this report  to get a window where you can add / remove report columns. See this blog for more details.