UPDATE BEGINNING BANK STATEMENT BALANCES

Use extreme caution and with guidance from Deltek support personnel before you update beginning bank statement balances.

You can run this process at any time because there are no system restrictions for its use. To avoid unexpected results, however, make sure that you first read the specific documentation regarding timing and other issues and obtain guidance from Deltek support personnel.

Use Update Beginning Bank Statement Balances to update the data in the Statement and Timing Info table on the Manage Bank Statement Information screen using existing Costpoint data. This is an alternative to manually entering bank statement information or uploading from a file using the Manage Bank Statement Information screen.

When you run this process, it rolls forward bank account balance information based on one of two options.

The first option sums the cleared posted transactions and adjustments in the period.

The second option sums the bank statement detail from the period selected.

The updating process can be used to compute and update bank statement information for a single bank or a range of banks.

When you update beginning bank statement balances, a row is inserted for the selected Fiscal Period To Be Updated fields.

Location

Selection Range

Bank Abbreviation

Option

Select a type of range for bank abbreviation from the drop-down list. The available options are:

• All

• One

• Range

• From Beginning

• To End

Start

Enter, or click to select, the starting bank abbreviation.

End

Enter, or click to select, the ending bank abbreviation.

Non-Contiguous Range

Select this check box when you want to specify a list of non-contiguous bank abbreviations ranges.

Accounting Period

Option

This field displays One to indicate that you can specify one fiscal year, period and subperiod.

Fiscal Year

Enter, or click to select, the fiscal year.

Period

Enter, or click to select, the period.

Subperiod

Enter, or click to select, the subperiod.

End Date

This field displays the end date for the selected period.

Accounting Period to be Updated

Option

This field displays One to indicate that there is only one fiscal year, period and subperiod to be updated.

Fiscal Year, Period, Subperiod

These fields display the Fiscal Year, Period and Subperiod that will be updated.

End Date

This field displays the end date for the period.

Statement Beginning Date

Option

This field displays One to indicate that there is only one date that can be selected.

Start

Enter, or click to select, the beginning date of the bank statement.

Statement Ending Date

Option

This field displays One to indicate that there is only one date that can be selected.

Start

Enter, or click to select, the ending date of the bank statement.

Options

Balance Update Method

Use Cleared Bank Transaction History

Select this option to use selected Subperiod Cleared Bank Trans History and Bank Statement Beginning Balances.

Use Uploaded Bank Statement Detail

Select this option to use GL balances for functional currency and Bank Statement Info and Detail for Bank currency.

Update Selected Subpd End Balance

Select this check box to have the Ending Balance for the Selected Subperiod updated.

Subtask