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 on this 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.

Enhanced Bank Reconciliation and Plaid Integration with Bank Statement Tables

The Enhanced Bank Reconciliation feature allows you to execute a daily bank reconciliation process that allows real-time matching and reconciliation of your bank transactions, while the Plaid Integration with Bank Statement Tables feature provides the capability to automatically to insert bank transactions downloaded from Plaid directly into bank statement tables.

If these features are enabled, you are not required to enter the fiscal year, period, and subperiod when you enter bank statement details, and you are not required to set up a default fiscal year/period/subperiod combination in Configure User Preferences.

To populate bank statement tables with transactions downloaded from Plaid, use the Transfer Plaid Bank Transactions screen.

CAUTION: If you attempt to manually enter transactions for a bank abbrev set up with Plaid integration, a warning message will display.

Note: For Costpoint Cloud, you can choose to opt in to this feature for the Costpoint 2025.4 release. The ability to opt in is temporary and will be removed when the feature becomes automatically enabled for all users as part of a future Costpoint release. See the Manage Opt-In Features topic for more information.