It’s end-of-year reporting time again. That means most of our clients are working in the “can I have my reports back yesterday?” frame of mind. We try and fine tune our processing schedule to turn around our report sets quickly and efficiently. Although we collect some detailed data files, our process is usually held-up waiting for a bank’s call report file.
Many of our clients know this, but we get asked enough to mention it again…No, we don’t have to wait until your call report data is publicly available from the FDIC’s web site. You can create a data file and upload it to us. Obviously how you create the file depends on which call report software you are using. Here are some suggestions for how to create the file:
CallReporter or “CR Premier” from Fidelity
1) Choose “CDR” from the toolbar at the top of the screen.
2) Choose “Create XBRL Transmission file”
3) Save the file using the suggested name. The file is typically named
“InstDoc_yyyy_mm_dd_nnnnnn.xml” where the nnnnnn is your bank's Fed RSSD number.Call Report Pro from Jack Henry
1) Choose “File | Save As” from the main menu
2) In the drop-down input box labeled “Save as type” change the type to “XBRL”
3) Save the file using the suggested name. The file is typically named
"000nnnnnnn_mmyy.XTRN" where the nnnnnn is your bank's Fed RSSD number.EasyCALL from DBI Financial
1) Once you’ve filed your call report with the CDR, the program saves a copy of the transmission file in a folder on your hard-drive. The folder name is usually something like “C:\EasyCALL”. The file is typically named "000nnnnnnn_mmyy.XTRN" where the nnnnnn is your bank's Fed RSSD number.SmartCall from FedReporter Inc.
1) Select the “Schedules” tab
2) Click on the “Tools” button and then from the menu that appears choose “Import/Export”
3) Check “I would like to EXPORT my SmartCall data” - make sure the file type is set to “FFIEC XBRL Instance Document (.XML or .XBRL)”
4) Click the “Browse” button to indicate the folder where you are going to store the data
5) Finally click the “Begin Export” button at the bottom of the window.
6) The file is typically named “Rssd999999_mmmYYYY.xml” where 999999 is your bank’s Fed RSSD number.
e.g. “Rssd123456_Dec2011.xml”
If your software vendor is not listed here, the process for creating the file is probably quite similar. Please call us and let us know if you are having difficulty creating the file. We’ll try and walk you through the process.
Comments