User Guides

Spreadsheet File Transfer

If you're currently using a spreadsheet (e.g. Microsoft Excel or Lotus 123) to prepare your data, you can use IESUB to easily transmit your file to the Federal Reserve. Initially you will need to include in your spreadsheet data the report name, report as-of date, etc. You then create a formula in one cell of your spreadsheet to pull in the data. Once that is completed, save it as a text file and submit it via IESUB to the Federal Reserve. For step-by-step instructions, see the following guides:

• IESUB Spreadsheet File Transfer User Guide [PDF] --FFIEC 101 (June 9, 2009)
• IESUB Spreadsheet File Transfer User Guide [PDF] --BHC Reports Current Period (updated June 30, 2009)
• IESUB Spreadsheet File Transfer User Guide [PDF] --BHC Reports Prior Periods (updated June 8, 2008)
• IESUB Spreadsheet File Transfer User Guide [PDF] (updated June 15, 2009)
• IESUB Spreadsheet File Transfer User Guide [PDF] -FX Survey (updated April 1, 2005)
• IESUB Spreadsheet File Transfer User Guide for Treasury Reports(TIC & TFC)[PDF] (updated March 9, 2009)
• IESUB Spreadsheet File Transfer User Guide for GSDS—FR2004a/b/c/WI/S [PDF] (updated January 7, 2004)
• IESUB Spreadsheet File Transfer User Guide for STBL - FR 2028a/b/s (updated July 26, 2006)
• IESUB Help Screens User Guide [PDF] (updated June 1, 2004)

File Transfer

If you're currently transmitting your report using FedLine, you now can transmit it via IESUB. The file transfer option is compatible with many vendor-developed deposit and regulatory reporting applications. IESUB will accept the file created by your vendor software, provide you with a receipt containing the date and time IESUB received the file and forward it to the Federal Reserve. To use this option, simply click on the File Transfer button on the IESUB home page, enter the file name with the .txt extension and click Submit File. For more details, see the File Transfer User Guide [PDF].