Enter Bank Statements Manually

Your prior day bank statement for the account you want to reconcile.

Configure the Bank Statement Event
business process and security policy in the Banking and Settlement functional area.

With manual entry, you can enter your prior day bank statement lines into Workday. You can use separate tasks to reconcile the statement lines with account transactions.

Access the

Record Bank Statement

task.

Select

Manual Entry Bank Statement

Specify the

Statement Beginning Date

, and the

Statement Date

from the bank statement.

Workday automatically populates the beginning date that follows the previous statement date for the bank account.

Specify the

Beginning Balance

and

Ending Balance

from the bank statement.

Workday automatically populates the ending balance as the beginning balance from the previous statement for the bank account.

Enter the balances and transactions from the bank statement by type code.

As you complete the task, consider:

Option	Description
Type Code	Select the type code that identifies the type of activity on the bank statement line. Example: Type code 475 that identifies a paid check amount. You can select predefined custom type codes or standard type codes. The type codes are based on the bank statement format associated with the bank account.
Value Date	(Optional) Enter the date when the financial institution recognizes the full transaction value on the bank statement line. When you specify a value date, you can: Group multiple bank statement lines or match individual lines by their value date using matching rules for automatic bank reconciliations. Generate ad hoc bank transactions and the associated accounting based on the value date for manual or automatic bank reconciliations. Workday posts the journal lines to the accounting period containing the value date. If this period is closed, Workday posts the journal lines to the next open period. If you don't specify a value date, the ad hoc transactions reflect the bank statement line date by default.

Option

Description

Type Code

Select the type code that identifies the type of activity on the bank statement line. Example: Type code 475 that identifies a paid check amount.

You can select predefined custom type codes or standard type codes. The type codes are based on the bank statement format associated with the bank account.

Value Date

(Optional) Enter the date when the financial institution recognizes the full transaction value on the bank statement line. When you specify a value date, you can:

Group multiple bank statement lines or match individual lines by their value date using matching rules for automatic bank reconciliations.

Generate ad hoc bank transactions and the associated accounting based on the value date for manual or automatic bank reconciliations. Workday posts the journal lines to the accounting period containing the value date. If this period is closed, Workday posts the journal lines to the next open period.

If you don't specify a value date, the ad hoc transactions reflect the bank statement line date by default.

If you click

Save for Later

, you can use the

Find Bank Statements

report later to locate this statement by bank account and statement date. The related actions menu enables you to edit or reconcile it.

After you've entered all the statement data from the bank statement, verify that:

The calculated ending balance matches the ending balance.

The

Difference

field displays a zero.

If not, check your entries for typographical errors in the amount fields.