Manage Bank Statement Information

Use this screen to store statement and timing information for a bank account.

If you are not uploading a bank statement:

Each month when you receive a bank statement, you enter the fiscal year, period, subperiod, and bank statement ending date and ending balance on this screen. This information is used to create the Bank Reconciliation Inquiry and the Bank Reconciliation Summary report.

If you are uploading a bank statement:

To upload your bank statement files from your bank to this screen, you must first complete the information on the Upload Bank Settings tab of the Manage Company Bank Accounts screens for US Banks and/or Non-US Banks.

Every time you upload a bank statement using the Manage Bank Statement Information screen, you must set the FY/ Pd/Subpd default settings for these columns by selecting Options > User Preferences from the menu, and click the Change Default Period link on the User Preferences screen.

You must initiate this screen when you use bank reconciliations for the first time and for each subsequent bank reconciliation.

If you are uploading your bank statement from a file, you must use this screen to upload the statement.

If a CSV input file has a transaction description that exceeds 45 characters, that description will be automatically truncated and the file will still be uploaded. No warning message will be provided.